versedex_v1_ethereum

Tables

ETHDAIFarm_RewardPaid_event

Reward distribution events from VerseDEX’s Ethereum-DAI liquidity mining farm on Ethereum, recording token amounts paid to stakers. Used to track farming incentive payouts and analyze yield farming participation patterns.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

address	in_user	removed	log_index	block_number	in_tokenAmount	block_timestamp	transaction_hash
0xdd5a9eec299b74b2db2d3430608c1c5a8d9598eb	0x3840dc4dc4c9891f2aac424461e9e98b4f006520	false	266	17274115	249962951794966586137919	2023-05-16T18:45:11.000Z	0x2b245b17a3942ab67f2ce88bd56f2e7aa0842e75bb06fd2f9d9ee800085dd9d4
0xdd5a9eec299b74b2db2d3430608c1c5a8d9598eb	0xf61d6742eea5e1f29cb4b96cf7108f32424d562c	false	264	17270140	500614586162733241259020	2023-05-16T05:14:59.000Z	0x60478f21af929603dafeff04f4e177816d1115fd37aa525b784674a84b22c788
0xdd5a9eec299b74b2db2d3430608c1c5a8d9598eb	0x551ca6e193d891967b28491195d1faca8201a8bc	false	331	17617092	23229628988576626025371	2023-07-04T00:46:35.000Z	0x1c2ec0f4caccc565d1275af0e5e62656fcbe2339ae971d9601b3f66eb507334b

Example Query

Query with partition filter

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

ETHUSDCFarm_RewardPaid_event

Reward distribution events from VerseDEX’s ETH-USDC liquidity farming contract on Ethereum. Tracks individual reward payouts to liquidity providers with token amounts and recipient addresses for analyzing yield farming participation and incentive 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

address	in_user	removed	log_index	block_number	in_tokenAmount	block_timestamp	transaction_hash
0x4e1f1206f2b9a651ecf2d49c5d33761861d4910c	0xbc0b4983f6375b25ae7d0f8f56d029cc24f78d05	false	170	17209771	2055897024500928868323925	2023-05-07T16:12:23.000Z	0x1a8b118989cc466fbef8427801acbe5d3fa804a4cfa770e3f87727219668958b
0x4e1f1206f2b9a651ecf2d49c5d33761861d4910c	0x339643855fc4dde20b8b340781bdf7a1990ebc3d	false	204	17826619	834857723045653660221	2023-08-02T10:08:35.000Z	0xf814c75eaef233310fd6352faa969d0e18bac4fa20e6ffbe67a8478537247d5f
0x4e1f1206f2b9a651ecf2d49c5d33761861d4910c	0x63a7367bc9727e8b81dad797aa1a265ec8f5ac56	false	253	16862868	94100117286413741611679	2023-03-19T16:12:35.000Z	0x75e506ef358c25ad41b53efb5a85e90aa5a2fbd9522664f3d74d3d325754f28e

Example Query

Query with partition filter

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

ETHUSDTFarm_RewardPaid_event

Reward distribution events from VerseDEX ETH-USDT yield farm contract on Ethereum, tracking token amounts paid to liquidity providers. Used to analyze farm yield distributions and individual user reward claims over time.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

address	in_user	removed	log_index	block_number	in_tokenAmount	block_timestamp	transaction_hash
0xc5af93687088c28da839371f3249df757b219aa8	0x277d250383807fdb4840e7901a262f5c4c4be64b	false	232	16874255	618489786723728359740646	2023-03-21T06:32:23.000Z	0x2d899caaff6e99b6d685797afb338f78707576744175edaa37052a3075af33c4
0xc5af93687088c28da839371f3249df757b219aa8	0x26738b7d98b73caca4e11ae32efaa18d9de3c1be	false	89	17582545	223769088944830419837140	2023-06-29T04:21:11.000Z	0xc80e1946c47dee6b1d12e1382fc13f84035ef1533f3b0b5a6b6c4efa87b7ee0a
0xc5af93687088c28da839371f3249df757b219aa8	0x26738b7d98b73caca4e11ae32efaa18d9de3c1be	false	63	17633872	254211773477820604148281	2023-07-06T09:19:11.000Z	0xa46178d04db357f3896ff7a74fb9dd5ad15ed663085946e868937e492771177b

Example Query

Query with partition filter

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

SwapsFactory_PairCreated_event

Liquidity pool creation events from VerseDEX automated market maker (AMM) factory contract on Ethereum, recording new trading pair deployments with token addresses and sequential pair identifiers. Useful for tracking DEX pool launches and analyzing token pair availability over time.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. 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_anon3`	`STRING`	Sequential counter tracking the total number of pairs created by the factory contract.

Sample Data

address	in_pair	removed	in_anon3	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0xee3e9e46e34a27dc755a63e2849c9913ee1a06e2	0x0b02428e7c2c24ccf64426e637aee0c879bd1860	false	23	0xdac17f958d2ee523a2206206994597c13d831ec7	0xf411903cbc70a74d22900a5de66a2dda66507255	458	18319288	2023-10-10T09:54:11.000Z	0xc7f8800145d2fdc0ea9305b2311050606df1bb66a990f14d99f984d0e73b89d1
0xee3e9e46e34a27dc755a63e2849c9913ee1a06e2	0xf3f82bc165a83425e81b8f2858d786e41ab21671	false	3	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	239	15262662	2022-08-02T10:51:50.000Z	0x51481ac25dd41e9e90f7722c6efdbcb18322df517d5f26f361407c1df46513fb
0xee3e9e46e34a27dc755a63e2849c9913ee1a06e2	0x8ff77def1ff9a5c7230f0c224a716a6399da8336	false	2	0x6b175474e89094c44da98b954eedeac495271d0f	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	85	15262641	2022-08-02T10:47:26.000Z	0xa24fd006bf69b14094e364ee22f7a6c04660c19a03e8f2900cf91d1acd44e250

Example Query

Query with partition filter

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

SwapsPair_Burn_event

Liquidity removal events from VerseDEX V1 pairs on Ethereum, recording token amounts withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity changes and provider exit activity across VerseDEX trading 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.
`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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xb4b0ea46fe0e9e8eab4afb765b527739f2718671	0x845c0179060362f071ff5c7f1d2703617a480f3e	false	0xb4b0ea46fe0e9e8eab4afb765b527739f2718671	215	1537525493689904028766325	1027468421364479403	16488545	2023-01-26T04:16:47.000Z	0xd228e065fa09eda10b4230d152a912f3a99655a761e9b44015f70eff74d7271d
0xb4b0ea46fe0e9e8eab4afb765b527739f2718671	0x845c0179060362f071ff5c7f1d2703617a480f3e	false	0xb4b0ea46fe0e9e8eab4afb765b527739f2718671	244	62282262163107881268417	11833048414634069	18342033	2023-10-13T14:21:23.000Z	0xea20d97fed88c5eff19aee5a7292170ee51f964da4a9f2ec92a690bb1879ed9c
0xb4b0ea46fe0e9e8eab4afb765b527739f2718671	0x845c0179060362f071ff5c7f1d2703617a480f3e	false	0xb4b0ea46fe0e9e8eab4afb765b527739f2718671	106	4699627389772905736200693	898065087768403843	18341026	2023-10-13T10:58:35.000Z	0x288dcc750754328444ed69b1a1865b9b4c19e320690b29c4c79f9798b90d631d

Example Query

Query with partition filter

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

SwapsPair_Mint_event

Liquidity provision events from VerseDEX V1 on Ethereum, recording when liquidity providers add tokens to trading pairs. Captures deposited token amounts and sender addresses for analyzing liquidity provisioning behavior and pool growth.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xeacadc656c9394fb09af25aebc0897fdffe484a1	false	0xb4b0ea46fe0e9e8eab4afb765b527739f2718671	48	250590	39380513371459762	17943964	2023-08-18T20:10:11.000Z	0x961b515ea6429d19e7149aa388102dbc8126d824cd98fa687e084c7348ffddbb
0x682831244b0e97946abc52cb1893cce398de3a35	false	0xb4b0ea46fe0e9e8eab4afb765b527739f2718671	80	5956586039579663072	3598642534924527	17943964	2023-08-18T20:10:11.000Z	0x961b515ea6429d19e7149aa388102dbc8126d824cd98fa687e084c7348ffddbb
0x6e1fbeeaba87bae1100d95f8340dc27ad7c8427b	false	0xb4b0ea46fe0e9e8eab4afb765b527739f2718671	112	7636249	4608909127274013	17943964	2023-08-18T20:10:11.000Z	0x961b515ea6429d19e7149aa388102dbc8126d824cd98fa687e084c7348ffddbb

Example Query

Query with partition filter

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

SwapsPair_Swap_event

Token swap events from VerseDEX decentralized exchange (DEX) on Ethereum. Records trade executions with input/output token amounts, pair contract addresses, and participant addresses for analyzing DEX trading activity and liquidity dynamics.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount1In	in_amount0Out	block_timestamp	transaction_hash
0x0000000000a84d1a9b0063a910315c7ffa9cd248	0xeacadc656c9394fb09af25aebc0897fdffe484a1	false	0x0000000000a84d1a9b0063a910315c7ffa9cd248	49	18293801	89989160000000000	529971	2023-10-06T20:19:47.000Z	0x9313b0d0429a01cf6560f70421a6052aec78e006e8feba7fa53380e8e965fff1
0x04c613ce5be6a8fda3a441163975a62909b337d7	0xf3f82bc165a83425e81b8f2858d786e41ab21671	false	0x04c613ce5be6a8fda3a441163975a62909b337d7	415	18294194	702685690	2502810	2023-10-06T21:39:11.000Z	0x921a339ce697ff1774e8507d60d1fca1539673ebdc5de4045019ca44a7fa0da5
0x1a2d11cb90d1de13bb81ee7b772a08ac234a8058	0xeacadc656c9394fb09af25aebc0897fdffe484a1	false	0x2577d9d2bc9498666cc88e309bdc6170860227ba	405	18294516	62955224143914100	370666	2023-10-06T22:43:47.000Z	0x0ebbdc6818003b2fb5ba6cdbe85eb232e3ad5a4e2a8877e6e183ca6979b1c943

Example Query

Query with partition filter

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

SwapsPair_Sync_event

Liquidity pool reserve balance updates from VerseDEX (Uniswap V2 fork) on Ethereum, emitted when token reserves change after swaps or liquidity operations. Enables tracking of pool composition, price movements, and total value locked (TVL) changes across trading 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.
`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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x682831244b0e97946abc52cb1893cce398de3a35	false	19	68547853201313727568800	53002927231284492892	15707965	2022-10-09T03:51:11.000Z	0x42ce31da9aa6d8620e095797456f72a7a3ba099232aebaf5877faa9be649f131
0x682831244b0e97946abc52cb1893cce398de3a35	false	14	68743231629292248790392	52852735721477002373	15708546	2022-10-09T05:47:35.000Z	0x7b9954d2ebce1e24e0103ce30d11aee7f12f453a64b1c604bfaa1b971874488f
0x682831244b0e97946abc52cb1893cce398de3a35	false	273	69248839336527109970029	52467990415656973176	15710031	2022-10-09T10:46:11.000Z	0xe69fd6c940c57bcbbd9cf0d58cfa8f9949ea8cb28ec3b9ba232f6acfaea0dcd4

Example Query

Query with partition filter

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

SwapsPair_Transfer_event

ERC-20 token transfer events from VerseDEX liquidity pair contracts on Ethereum, including mints (from zero address), burns (to zero address), and transfers between accounts. Used for tracking liquidity provision, LP token movements, and swap-related token flows within the DEX.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x21ae363b6c9b16158a8e7e3b14ced19ce6f5b492	0x362ddd14f69924ebbf9066ddd2ae7c171cf6d098	0x0000000000000000000000000000000000000000	false	60011912912	82	17561189	2023-06-26T04:19:59.000Z	0xd00075de68be64815a274f4408e3bff0a133ddd6f566517d6369ed4e220f37d4
0xc5af93687088c28da839371f3249df757b219aa8	0x362ddd14f69924ebbf9066ddd2ae7c171cf6d098	0x26738b7d98b73caca4e11ae32efaa18d9de3c1be	false	949297190497	87	17561189	2023-06-26T04:19:59.000Z	0xd00075de68be64815a274f4408e3bff0a133ddd6f566517d6369ed4e220f37d4
0x26738b7d98b73caca4e11ae32efaa18d9de3c1be	0x362ddd14f69924ebbf9066ddd2ae7c171cf6d098	0x0000000000000000000000000000000000000000	false	949297190497	83	17561189	2023-06-26T04:19:59.000Z	0xd00075de68be64815a274f4408e3bff0a133ddd6f566517d6369ed4e220f37d4

Example Query

Query with partition filter

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

USDCHAPIFarm_RewardPaid_event

Reward distribution events from VerseDEX’s USDC-HAPI liquidity mining farm on Ethereum. Tracks token reward payouts to individual stakers with precise amounts in wei and recipient addresses for analyzing yield farming participation and reward distribution patterns.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

address	in_user	removed	log_index	block_number	in_tokenAmount	block_timestamp	transaction_hash
0x17bdceec80d3506e384db09e5d5696edf70605ef	0x94a9ce1e43d35882630cbc3795c038e99b717826	false	225	17134279	62177738900658478973799	2023-04-27T01:33:23.000Z	0xabdd5cf4dfff51b72e7f4e03d632ed742fc937a10b132fab256307fc642c9dea
0x17bdceec80d3506e384db09e5d5696edf70605ef	0x62af7c48cf412162465a8cafde44dfb17ba96038	false	171	17138410	202794967934564378526878	2023-04-27T15:29:35.000Z	0xe4f50cbc8aeecb5f3d270950437b6251ec995c7c217acbd18939279bf093dcb5
0x17bdceec80d3506e384db09e5d5696edf70605ef	0x0e8d8f04910a622ea74e3265ababeabd1e70b33e	false	561	16982625	13388090494788492549	2023-04-05T12:37:59.000Z	0xbf20c72d8be0ed03a79e2eeab41b46168fb5d2f18c640187df5f7767889f83e5

Example Query

Query with partition filter

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

VERSEETHFarm_RewardPaid_event

Reward claim events from VerseDex’s VERSE-ETH liquidity mining farm on Ethereum, capturing when users withdraw earned VERSE token rewards. Useful for analyzing farm participation, reward distribution patterns, and yield farming behavior across liquidity providers.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

address	in_user	removed	log_index	block_number	in_tokenAmount	block_timestamp	transaction_hash
0xded0c22acd80e7a4bd6ec91ced451fc83f04cab2	0x90763cf0ceb2d3ea37702d69db885e498eee14fb	false	350	17178004	6017858096663766687057120	2023-05-03T05:02:59.000Z	0x691ac9f3285227692a269681cc7e7c7ff6fdf9d872bb118298ef8caa832a48aa
0xded0c22acd80e7a4bd6ec91ced451fc83f04cab2	0x6f5153d05bcd36e2f13f4ef667150997dc9dfd01	false	119	17180655	864968751604376679693075	2023-05-03T14:01:11.000Z	0x6ddd86381a3837edf53aebcc8fd5d84f2bd594a221672fc4fd5fd1685c324366
0xded0c22acd80e7a4bd6ec91ced451fc83f04cab2	0x5d10c9cb503ffbb7ac7835f7f2653eb283ddbb2d	false	225	17178546	274035675055510695014218	2023-05-03T06:52:47.000Z	0xef842600e48e6a200de8f5000b301c0a6cb4d003f6e746fabd74c6dc393cd40b

Example Query

Query with partition filter

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

WBTCETHFarm_RewardPaid_event

Reward distribution events from VerseDEX’s WBTC-ETH liquidity farm on Ethereum, recording token amounts paid to liquidity providers when they claim farming incentives. Used for tracking yield farming reward flows and calculating actual APY (Annual Percentage Yield) for farm participants.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

address	in_user	removed	log_index	block_number	in_tokenAmount	block_timestamp	transaction_hash
0x4efff28192029bdb1ac027c53674721875da6b10	0xe0fc880e23c8ec6eacad41d0a3aa3e7b945e32d0	false	249	17072524	3747464630676292921076413	2023-04-18T08:55:47.000Z	0xcd3e0dd14e44e0ada1ef1fdea0f43c38aa4f4ba767df24286fd8d27c578c8ba6
0x4efff28192029bdb1ac027c53674721875da6b10	0xfb24af896317d35aca01b32c8689a9fb74475afc	false	101	17070058	5936701914877832992858592	2023-04-18T00:32:59.000Z	0x9e7aeea262781a6c0e2145333d468ff3d9bc4a0183c21c3bdbcc965ab4b11697
0x4efff28192029bdb1ac027c53674721875da6b10	0xfb24af896317d35aca01b32c8689a9fb74475afc	false	91	17911561	325882329142373862593210	2023-08-14T07:21:59.000Z	0xa3e3249c485243e7301c2445cc2f670e0f170dfc424c60b0fc04d9faf27e8ad0

Example Query

Query with partition filter

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

WBTCUSDCFarm_RewardPaid_event

Reward distribution events from VerseDEX’s WBTC-USDC liquidity mining farm on Ethereum. Tracks individual reward payouts to liquidity providers with token amounts and recipient addresses for analyzing farming incentives and participant 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.
`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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

address	in_user	removed	log_index	block_number	in_tokenAmount	block_timestamp	transaction_hash
0x4ba48df24008429ae9140a01e0d002f5fa6a125d	0x641ad78baca220c5bd28b51ce8e0f495e85fe689	false	107	16948679	127990593108458816616743	2023-03-31T17:31:47.000Z	0xe926f9949ef5ad9be09dce0938917163214de1ec21ea5f83aa225a483f5528c0
0x4ba48df24008429ae9140a01e0d002f5fa6a125d	0x6dbb3f02f9946b517313b448598194c948b68d56	false	75	16945610	24942068583417743436156	2023-03-31T07:09:47.000Z	0x050d2fe9378ab50d86f690063486f19c3d13fca4fae133eb49792ed040d4ff80
0x4ba48df24008429ae9140a01e0d002f5fa6a125d	0x6dbb3f02f9946b517313b448598194c948b68d56	false	152	16945638	2928302507430845339	2023-03-31T07:15:23.000Z	0xf420418d933c032d1e4b30485865c517989b70f2c359521819375b1c51228d77

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ETHDAIFarm_RewardPaid_event

ETHUSDCFarm_RewardPaid_event

ETHUSDTFarm_RewardPaid_event

SwapsFactory_PairCreated_event

SwapsPair_Burn_event

SwapsPair_Mint_event

SwapsPair_Swap_event

SwapsPair_Sync_event

SwapsPair_Transfer_event

USDCHAPIFarm_RewardPaid_event

VERSEETHFarm_RewardPaid_event

WBTCETHFarm_RewardPaid_event

WBTCUSDCFarm_RewardPaid_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ETHDAIFarm_RewardPaid_event

​ETHUSDCFarm_RewardPaid_event

​ETHUSDTFarm_RewardPaid_event

​SwapsFactory_PairCreated_event

​SwapsPair_Burn_event

​SwapsPair_Mint_event

​SwapsPair_Swap_event

​SwapsPair_Sync_event

​SwapsPair_Transfer_event

​USDCHAPIFarm_RewardPaid_event

​VERSEETHFarm_RewardPaid_event

​WBTCETHFarm_RewardPaid_event

​WBTCUSDCFarm_RewardPaid_event

Tables

ETHDAIFarm_RewardPaid_event

ETHUSDCFarm_RewardPaid_event

ETHUSDTFarm_RewardPaid_event

SwapsFactory_PairCreated_event

SwapsPair_Burn_event

SwapsPair_Mint_event

SwapsPair_Swap_event

SwapsPair_Sync_event

SwapsPair_Transfer_event

USDCHAPIFarm_RewardPaid_event

VERSEETHFarm_RewardPaid_event

WBTCETHFarm_RewardPaid_event

WBTCUSDCFarm_RewardPaid_event