sudoswap_v1_ethereum

Tables

LSSVMPairFactory_createPairERC20_function

NFT liquidity pool creation transactions on Sudoswap v1 Ethereum, recording ERC20-based pair deployments with bonding curve parameters, initial NFT deposits, and token balances. Enables analysis of liquidity provider behavior and pool configuration strategies across different NFT collections.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_params`	`STRUCT<token STRING, nft STRING, bondingCurve STRING, assetRecipient STRING, poolType INT64, delta STRING, fee STRING, spotPrice STRING, initialNFTIDs STRING, initialTokenBalance STRING>`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
`out_pair`	`STRING`	Contract address of the created liquidity pair. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	status	gas_used	out_pair	in_params	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
1035165	false	237585			0x59722caa	0xb16c1342e617a5b6e4b631eb114483fdb289c0a4	16331118	0x00003183f59e825911d98fb509a157cd2abbae25	2023-01-04T04:45:35.000Z	0xc5615ef8a30a810ab2c4ef20f1f54508b9237d7d1698e6ec0f3088c2d5c5a237
1035165	true	860914	0x80ba1ec24b4f43d50c4d6f82017632769ba02add	{“fee”:“0”,“nft”:“0xef1a89cbfabe59397ffda11fc5df293e9bc5db90”,“delta”:“0”,“token”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“poolType”:1,“spotPrice”:“99502488”,“bondingCurve”:“0x5b6ac51d9b1cede0068a1b26533cace807f883ee”,“initialNFTIDs”:“6204,5271,4909,4694,4703,4650,4594,3926,3814”,“assetRecipient”:“0x00003183f59e825911d98fb509a157cd2abbae25”,“initialTokenBalance”:“0”}	0x59722caa	0xb16c1342e617a5b6e4b631eb114483fdb289c0a4	16331117	0x00003183f59e825911d98fb509a157cd2abbae25	2023-01-04T04:45:23.000Z	0x456bccad7382fed004321d481886631b68bf804746261bdf1795d992987b22b1
459219	true	371859	0x772dc2559d57df639c191104695c9b338e306f77	{“fee”:“20000000000000000”,“nft”:“0x566309d3523a216287bfb39c6b6bbb3a504ef5f0”,“delta”:“0”,“token”:“0x3472a5a71965499acd81997a54bba8d852c6e53d”,“poolType”:2,“spotPrice”:“975609756097561100”,“bondingCurve”:“0x5b6ac51d9b1cede0068a1b26533cace807f883ee”,“initialNFTIDs”:“5597”,“assetRecipient”:“0x0000000000000000000000000000000000000000”,“initialTokenBalance”:“961168781237985300”}	0x59722caa	0xb16c1342e617a5b6e4b631eb114483fdb289c0a4	15727981	0xcdc15bf0cdb1bc2f8ac44206b0687475cd227c2e	2022-10-11T22:54:35.000Z	0x78784eb8b17181a3b76b3a2969958788565eb1821c5006af55feb932c7b37ad3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sudoswap_v1_ethereum.LSSVMPairFactory_createPairERC20_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LSSVMPairFactory_createPairETH_function

NFT liquidity pool creation events from Sudoswap V1 on Ethereum, capturing bonding curve parameters (spot price, delta, fee), initial NFT deposits, and deployed pair contract addresses for analyzing AMM pool configurations and market maker activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__nft`	`STRING`	Contract address of the NFT collection. Hex-encoded, 0x-prefixed, 42-character string.
`in__bondingCurve`	`STRING`	Contract address of the bonding curve implementation used for pricing calculations. Hex-encoded, 0x-prefixed, 42-character string.
`in__assetRecipient`	`STRING`	Address designated to receive assets (ETH or NFTs) from trades executed on this sudoswap liquidity pool. Typically set to the pool creator’s address as seen in sample data.
`in__poolType`	`INT64`	Pool type indicator where 0 represents a Token-to-NFT pool (buying NFTs) and 1 represents an NFT-to-Token pool (selling NFTs). Determines the trading direction for the created Sudoswap liquidity pair.
`in__delta`	`STRING`	Delta parameter for the bonding curve pricing function. Numeric string representation of the price change rate or step size between consecutive NFT trades.
`in__fee`	`STRING`	Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points.
`in__spotPrice`	`STRING`	Initial price point for the bonding curve pricing function. Numeric string representation in wei or smallest token denomination.
`in__initialNFTIDs`	`STRING`	Comma-separated list of NFT token IDs deposited into the liquidity pool at creation time. May be empty if the pool is created without initial NFT inventory.
`out_pair`	`STRING`	Contract address of the created liquidity pair. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	value	status	in__nft	gas_used	out_pair	in__delta	signature	to_address	block_number	from_address	in__spotPrice	block_timestamp	in__bondingCurve	transaction_hash	in__assetRecipient
230334	480000000000000000	true	0x306b1ea3ecdf94ab739f1910bbda052ed4a9f949	191945	0x5ce9b6e48531907091ac5eac89cb38ae7fbb7a24	0	0xce9c095d	0xb16c1342e617a5b6e4b631eb114483fdb289c0a4	15256616	0x1fb576ce36f72b056b456554622335e9dccd6f3f	120000000000000000	2022-08-01T12:18:50.000Z	0x5b6ac51d9b1cede0068a1b26533cace807f883ee	0x352d5f5d15c7562927ac9995b9ff150ca08efffaa85c2453fca3aa23dcfa7261	0x1fb576ce36f72b056b456554622335e9dccd6f3f
232676	690000000000000000	true	0x5af0d9827e0c53e4799bb226655a1de152a425a5	193897	0x0898046b2fedacc905df4504684981ea189ed9a3	0	0xce9c095d	0xb16c1342e617a5b6e4b631eb114483fdb289c0a4	15257163	0xf33364a83b6002d5070ec5fa31f5d9eb93572732	690000000000000000	2022-08-01T14:17:25.000Z	0x5b6ac51d9b1cede0068a1b26533cace807f883ee	0x0ccecfc9712b39b8fd02dca76759c220a48c17080322b0bb68ce50b9869d9a95	0xf33364a83b6002d5070ec5fa31f5d9eb93572732
230679	800000000000000	true	0xb9b2fae0086a14f626af91da173ec48233b7ab89	192233	0xc6eb1e94155ab1e2be26215fd806264ac6325a78	100000000000000	0xce9c095d	0xb16c1342e617a5b6e4b631eb114483fdb289c0a4	15254715	0xc16b76c25b60e5970ace61c719ca263133ccc1b3	800000000000000	2022-08-01T05:24:57.000Z	0x5b6ac51d9b1cede0068a1b26533cace807f883ee	0x78d27ac7415e78c4717716fa03e84c42860936e6319cf42c1212be8d91923884	0xc16b76c25b60e5970ace61c719ca263133ccc1b3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sudoswap_v1_ethereum.LSSVMPairFactory_createPairETH_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LSSVMPairFactory_NewPair_event

Liquidity pool creation events from Sudoswap V1 NFT AMM (Automated Market Maker) factory contract on Ethereum. Tracks new pair deployments with pool addresses for analyzing Sudoswap liquidity provisioning activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_poolAddress`	`STRING`	Contract address of the liquidity pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	in_poolAddress	block_timestamp	transaction_hash
0xb16c1342e617a5b6e4b631eb114483fdb289c0a4	false	184	15038185	0x9bdfb65dec3f632a40ee7bf61e83a541fda67117	2022-06-28T05:43:34.000Z	0xc0c1b0a01126e75e8b6e79ac1545d0af0be908b2e7ef57e1a8b17649d7c60158
0xb16c1342e617a5b6e4b631eb114483fdb289c0a4	false	270	15037122	0xd49325d2e0f4cff902d690ecd28ae3a4acb49a00	2022-06-28T00:48:25.000Z	0x4e52be5eaa5ef22993961d411d642f66d28b665b860ef2ea93eff6f2f8554867
0xb16c1342e617a5b6e4b631eb114483fdb289c0a4	false	62	15040910	0xd2af9be3e2787f21e9fe9388b78ebe0d2d5ea0ac	2022-06-28T18:05:52.000Z	0x8c87b553e13b20c32028845c7ff8f57247e769a17185e163bb0f2e8de1b8300b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sudoswap_v1_ethereum.LSSVMPairFactory_NewPair_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LSSVMRouterWithRoyalties_RoyaltyIssued_event

Royalty payment events from Sudoswap V1 NFT marketplace on Ethereum, capturing royalty amounts paid to creators and recipients during NFT sales through liquidity pools. Contains sale prices, royalty amounts, and recipient addresses for analyzing creator earnings and marketplace revenue distribution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_issuer`	`STRING`	Address of the entity or contract that initiated the issuance or application event. Hex-encoded, 0x-prefixed, 42-character string.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_salePrice`	`STRING`	Sale price of the NFT transaction in wei (ETH’s smallest unit), before royalty deduction. Typically ranges from ~1e15 to ~3e16 wei (0.001 to 0.03 ETH based on sample data).
`in_royaltyAmount`	`STRING`	Amount of royalty paid in the transaction, denominated in the smallest unit of the payment token (wei for ETH). Typically represents 5-10% of the sale price based on the sample ratios.

Sample Data

address	in_pair	removed	in_issuer	log_index	block_number	in_recipient	in_salePrice	block_timestamp	in_royaltyAmount	transaction_hash
0x844d04f79d2c58dcebf8fff1e389fccb1401aa49	0xcf58542f71b70122eaaa56782bb559fc9337b529	false	0x12239fcdff8cd48c24661d3c4243ce33ceb2e273	299	15648431	0x8aa986eb2f0d3b5001c9c2093698a4e13d646d5b	980198019801982	2022-09-30T20:06:23.000Z	49009900990099	0xe25fec3dcd0a5b98d0ec2a2dafa0866400e530de466dea14db8a6b45facb07ad
0x844d04f79d2c58dcebf8fff1e389fccb1401aa49	0x71e54db82840a3ea3c115a30357692aa28982444	false	0x5e6cc75351c68b8ab96a38960f833c947469dbd7	57	15836149	0x43cdb4a408c1670f2a3c9b80e891cd63770cfca7	28123428858722977	2022-10-27T01:32:59.000Z	2812342885872297	0x57f0374127c9f64eb8ec6339d60a264a3eb8ac73c09ba87ad10806c5e3fa1821
0x844d04f79d2c58dcebf8fff1e389fccb1401aa49	0x7b4e67b68fd2a305fc99fae84860c281ba8a8e76	false	0x12239fcdff8cd48c24661d3c4243ce33ceb2e273	252	15769273	0xd1d1d4e36117ab794ec5d4c78cbd3a8904e691d0	15323300492610841	2022-10-17T17:19:47.000Z	1057307733990148	0x761404fb89c09e044d6b7553ea7bbd728a60b3a597ad264763c82a90ef805066

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sudoswap_v1_ethereum.LSSVMRouterWithRoyalties_RoyaltyIssued_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_changeFee_function

SudoSwap liquidity pair fee adjustment events on Ethereum, tracking when pool owners update trading fees via the changeFee function. Used for analyzing fee strategy changes and competitive positioning of NFT liquidity pools.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

gas	status	gas_used	in_newFee	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
16654	true	7177	200000000000000000	0x6b7a2200	0x68325a925f4de169b083d4401353cea59b1dee23	14801747	0x68325a925f4de169b083d4401353cea59b1dee23	0,1	2022-05-18T23:48:47.000Z	0x84953c2a2f257d5b1726b2dd81b97040b5a1712c57c8b693621d737939851e0d
17523	true	7177	29000000000000000	0x6b7a2200	0x18cab634c18b7e965c3c5e33fd5b5de41e76ab00	17635156	0x18cab634c18b7e965c3c5e33fd5b5de41e76ab00	0,2	2023-07-06T13:39:35.000Z	0xeded52984b391830bbd88b7ed39e9a25119db48fb46244ec122b9dcde3b97a38
16646	true	7177	26000000000000000	0x6b7a2200	0xbb0f911f7462b178904d0b67d9416a411fe12b58	16398249	0xbb0f911f7462b178904d0b67d9416a411fe12b58	0,1	2023-01-13T13:44:47.000Z	0x384860d302c650711ff5262017dc1463eb8e89ee45b8327ddd3fb70d689b068f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sudoswap_v1_ethereum.Pair_changeFee_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_swapNFTsForToken_function

NFT-to-token swap transactions on sudoswap v1 liquidity pairs on Ethereum, capturing NFT token IDs sold and ETH/ERC20 tokens received. Used for analyzing NFT liquidity pool trading activity and price discovery.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_nftIds`	`ARRAY<STRING>`	Array of NFT token identifiers being swapped or transferred in the operation. String-encoded integers representing unique token IDs within the NFT collection.
`in_minExpectedTokenOutput`	`STRING`	Minimum amount of tokens the caller is willing to receive from swapping NFTs. String-encoded integer representing the slippage protection threshold in the token’s smallest unit (wei for ETH).
`in_tokenRecipient`	`STRING`	Address designated to receive the tokens from the NFT swap operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_isRouter`	`BOOL`	Indicates whether the function call originated through a router contract rather than directly from a user address.
`in_routerCaller`	`STRING`	Address of the original caller when the swap was routed through a router contract. Hex-encoded, 0x-prefixed, 42-character string representing the end user’s address, or zero address when called directly.
`out_outputAmount`	`STRING`	Amount of tokens received from swapping NFTs. String-encoded integer representing the token quantity in the smallest unit (wei for ETH).

Sample Data

gas	status	gas_used	in_nftIds	signature	to_address	in_isRouter	block_number	from_address	trace_address	block_timestamp	in_routerCaller	out_outputAmount	transaction_hash	in_tokenRecipient
182150	true	115175	[“3033”]	0xb1d3f1c1	0x4d359301afe42b18afb6e838a53b2b05d636c978	true	20291870	0x2b2e8cda09bba9660dca5cb6233787738ad68329	0,0,0,0,2,0	2024-07-12T17:18:35.000Z	0xa97727370e2592f83602bc92975c49c4fea4491f	2038408419219357	0xb9c5cf270e0ede9d0c04f7192d66015f9a68c57af11c39c701da8bc6272c5b1a	0xa97727370e2592f83602bc92975c49c4fea4491f
140400	true	115023	[“9645”]	0xb1d3f1c1	0xa75d62106ddb84e7e38c098be046a9bca99f8bd3	true	20286756	0x2b2e8cda09bba9660dca5cb6233787738ad68329	0,0,0,0,2,0	2024-07-12T00:10:11.000Z	0xa97727370e2592f83602bc92975c49c4fea4491f	553747572815535	0x65bdb11fef8ca5b54bafe1f8c714f49bcd8b139d2be86c98c3094066501e705a	0xa97727370e2592f83602bc92975c49c4fea4491f
182150	true	115175	[“3034”]	0xb1d3f1c1	0x4d359301afe42b18afb6e838a53b2b05d636c978	true	20291866	0x2b2e8cda09bba9660dca5cb6233787738ad68329	0,0,0,0,2,0	2024-07-12T17:17:47.000Z	0xa97727370e2592f83602bc92975c49c4fea4491f	2109752713892035	0x3c26965d3eea37a77d051040c4c31ec25a10b8a8f0de71d5500373e13cd2f3cd	0xa97727370e2592f83602bc92975c49c4fea4491f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sudoswap_v1_ethereum.Pair_swapNFTsForToken_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_swapTokenForAnyNFTs_function

Token-to-NFT swap transactions on sudoswap v1 Ethereum, where users exchange ETH or ERC20 tokens for any available NFTs from a liquidity pool. Used for analyzing NFT purchase patterns, pricing dynamics, and slippage tolerance across sudoswap AMM pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_numNFTs`	`STRING`	Number of NFTs being purchased from the Sudoswap pool in this swap transaction. Represented as a string-encoded integer, typically ranges from 1 to several NFTs per transaction.
`in_maxExpectedTokenInput`	`STRING`	Maximum amount of tokens the buyer is willing to spend for the NFT swap. Numeric string representing the token quantity in its smallest denomination.
`in_nftRecipient`	`STRING`	Address designated to receive the NFTs from the swap operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_isRouter`	`BOOL`	Indicates whether the function call originated through a router contract rather than directly from a user address.
`in_routerCaller`	`STRING`	Address of the original caller when the swap was routed through a router contract. Hex-encoded, 0x-prefixed, 42-character string representing the end user’s address, or zero address when called directly.
`out_inputAmount`	`STRING`	Actual token amount paid by the buyer for the NFT purchase, denominated in the pool’s token with wei precision. Value may differ slightly from maxExpectedTokenInput due to bonding curve pricing and slippage.

Sample Data

gas	value	status	gas_used	signature	in_numNFTs	to_address	in_isRouter	block_number	from_address	trace_address	block_timestamp	in_nftRecipient	in_routerCaller	out_inputAmount	transaction_hash	in_maxExpectedTokenInput
1069462	465791648866086600	true	181713	0x28b8aee1	4	0xca3cb0bed10c305aa603b0d168389deeece99f5a	false	17120454	0x50a269ff3238db9c60ac2205cf5268e009753de8	0	2023-04-25T02:57:59.000Z	0x50a269ff3238db9c60ac2205cf5268e009753de8	0x0000000000000000000000000000000000000000	465791648866086601	0x48259c7f0ef67d06f5cc028b93db1959789f723848ab7a403d292a6ff07ba00a	465791648866086601
537396	39475000000000000	true	109266	0x28b8aee1	1	0x2e5800bc3474dfee44da5c4fb0e55dd4dc1c58b0	false	20080564	0x50a269ff3238db9c60ac2205cf5268e009753de8	0	2024-06-13T04:37:11.000Z	0x50a269ff3238db9c60ac2205cf5268e009753de8	0x0000000000000000000000000000000000000000	39475000000000001	0x0aa5b189e8f8c4e50b52d8b8c3f1c9d6139900dec3235697aeeb622d7ac0e874	39475000000000001
138903	425000000000000060	true	93584	0x28b8aee1	1	0xe0a5b509063e171370381f1885b9b6c28f1b8642	true	16852727	0x2b2e8cda09bba9660dca5cb6233787738ad68329	0,0,1	2023-03-18T06:01:35.000Z	0x0c9133fa96d72c2030d63b6b35c3738d6329a313	0xb7957fe76c2feae66b57cf3191afd26d99ec5599	425000000000000044	0x6c55aaadaa94ce9c779caedc9f3ba893ededd8148b081a130cd77c6d172b0690	428442842622116331

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sudoswap_v1_ethereum.Pair_swapTokenForAnyNFTs_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_swapTokenForSpecificNFTs_function

Token-to-NFT swap transactions on Sudoswap V1 liquidity pools, where users purchase specific NFT token IDs by spending ERC-20 tokens or ETH. Captures buyer addresses, target NFT IDs, price slippage parameters, and actual token amounts paid for analyzing NFT marketplace pricing and trading behavior.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_nftIds`	`ARRAY<STRING>`	Array of NFT token identifiers being swapped or transferred in the operation. String-encoded integers representing unique token IDs within the NFT collection.
`in_maxExpectedTokenInput`	`STRING`	Maximum amount of tokens the buyer is willing to spend for the NFT swap. Numeric string representing the token quantity in its smallest denomination.
`in_nftRecipient`	`STRING`	Address designated to receive the NFTs from the swap operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_isRouter`	`BOOL`	Indicates whether the function call originated through a router contract rather than directly from a user address.
`in_routerCaller`	`STRING`	Address of the original caller when the swap was routed through a router contract. Hex-encoded, 0x-prefixed, 42-character string representing the end user’s address, or zero address when called directly.
`out_inputAmount`	`STRING`	Actual token amount paid by the buyer for the specified NFTs, represented as a wei-denominated string. Typically slightly less than the maximum expected input due to slippage protection in the Sudoswap AMM.

Sample Data

gas	value	status	gas_used	in_nftIds	signature	to_address	in_isRouter	block_number	from_address	block_timestamp	in_nftRecipient	in_routerCaller	out_inputAmount	transaction_hash	in_maxExpectedTokenInput
133455	1343145217702682000	true	106756	[“4180”]	0x6d8b99f7	0xd1fae9575aeae06cf9bbd11d99c7a9f111886028	false	17225751	0x042d200e5375204f022570361f3913b245488091	2023-05-09T22:08:23.000Z	0x042d200e5375204f022570361f3913b245488091	0x0000000000000000000000000000000000000000	1343145217702672108	0x25f62165d8331cc4ebe1aad6c7e3b30cc8d7d86980fa766cf3fa49ff00dae9d3	1343145217702682108
135409	34381818061898936	true	108501	[“5698”]	0x6d8b99f7	0xce512736c1258660391138c51a06812d472e3e15	false	17222969	0x04a5e8c4a44780d115adda776b04bcf1c4f3254e	2023-05-09T12:43:59.000Z	0x04a5e8c4a44780d115adda776b04bcf1c4f3254e	0x0000000000000000000000000000000000000000	34381818061888934	0x6149f751a3da52b5003133bd159e2287a339a2d4bedc30d07d518c94007aab1d	34381818061898934
133528	340185499281122100	true	106821	[“10912”]	0x6d8b99f7	0xe0a5b509063e171370381f1885b9b6c28f1b8642	false	17224753	0x1a652b3fceeee743aa0bd84e84cd14555cc63e17	2023-05-09T18:46:11.000Z	0x1a652b3fceeee743aa0bd84e84cd14555cc63e17	0x0000000000000000000000000000000000000000	340185499281112101	0x3339a73e151327138140b17eb7c672cce215581dd58d28aa31a6a78f25b6d974	340185499281122101

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sudoswap_v1_ethereum.Pair_swapTokenForSpecificNFTs_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

LSSVMPairFactory_createPairERC20_function

LSSVMPairFactory_createPairETH_function

LSSVMPairFactory_NewPair_event

LSSVMRouterWithRoyalties_RoyaltyIssued_event

Pair_changeFee_function

Pair_swapNFTsForToken_function

Pair_swapTokenForAnyNFTs_function

Pair_swapTokenForSpecificNFTs_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​LSSVMPairFactory_createPairERC20_function

​LSSVMPairFactory_createPairETH_function

​LSSVMPairFactory_NewPair_event

​LSSVMRouterWithRoyalties_RoyaltyIssued_event

​Pair_changeFee_function

​Pair_swapNFTsForToken_function

​Pair_swapTokenForAnyNFTs_function

​Pair_swapTokenForSpecificNFTs_function

Tables

LSSVMPairFactory_createPairERC20_function

LSSVMPairFactory_createPairETH_function

LSSVMPairFactory_NewPair_event

LSSVMRouterWithRoyalties_RoyaltyIssued_event

Pair_changeFee_function

Pair_swapNFTsForToken_function

Pair_swapTokenForAnyNFTs_function

Pair_swapTokenForSpecificNFTs_function