tokenlon_v1_ethereum

Tables

AMMWrapper_Swapped_event

Swap execution events from Tokenlon v1’s AMM wrapper contract on Ethereum, routing trades through decentralized exchanges like SushiSwap. Contains trade amounts, fees, subsidies, and routing information for analyzing DEX aggregator flow and fee structures.

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_source`	`STRING`	Source chain identifier for the cross-chain operation. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-1” for Ethereum, “EVM-56” for BSC).
`in_transactionHash`	`STRING`	Transaction hash on the destination chain for the cross-chain bridge or swap operation. 66-character hex string including 0x prefix.
`in_userAddr`	`STRING`	Address of the user initiating the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_takerAssetAddr`	`STRING`	Contract address of the token provided by the taker in the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_takerAssetAmount`	`STRING`	Amount of tokens provided by the taker in the swap or order. String-encoded integer representing token units in the taker asset’s smallest denomination.
`in_makerAddr`	`STRING`	Address of the market maker or liquidity provider fulfilling the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_makerAssetAddr`	`STRING`	Contract address of the token provided by the market maker in the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_makerAssetAmount`	`STRING`	Amount of tokens provided by the market maker in the order or swap. String-encoded integer representing token units in the maker asset’s smallest denomination.
`in_receiverAddr`	`STRING`	Address designated to receive the output tokens from the swap or fill operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_settleAmount`	`STRING`	Amount of tokens actually settled in the swap or order operation. String-encoded integer representing token units in the smallest denomination of the settled asset.
`in_receivedAmount`	`STRING`	Actual amount of destination tokens received by the beneficiary in the swap or withdrawal operation. String-encoded integer representing token units in the destination token’s smallest denomination.
`in_feeFactor`	`STRING`	Fee multiplier used to calculate protocol fees for the swap or fill operation. String-encoded integer representing basis points or a scaling factor.
`in_subsidyFactor`	`STRING`	Platform subsidy multiplier applied to this trade, expressed as basis points or raw factor. Lower values indicate higher subsidies offered to incentivize liquidity or volume on the Tokenlon platform.

Sample Data

address	removed	in_source	log_index	in_userAddr	block_number	in_feeFactor	in_makerAddr	block_timestamp	in_receiverAddr	in_settleAmount	in_subsidyFactor	transaction_hash	in_makerAssetAddr	in_receivedAmount	in_takerAssetAddr	in_transactionHash	in_makerAssetAmount	in_takerAssetAmount
0x4a14347083b80e5216ca31350a2d21702ac3650d	false	SushiSwap	8	0x645ea4cbd0ec1b2f6b69d0beffcb2e09b4a731d5	15203767	993	0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	2022-07-24T06:41:32.000Z	0x645ea4cbd0ec1b2f6b69d0beffcb2e09b4a731d5	42569438379144489	4	0x25d5e2ae7e5895169cda819cbdd007d57d2c209760a6313f8ac0d7bd41534b68	0x0000000000000000000000000000000000000000	47262616164255012	0xdac17f958d2ee523a2206206994597c13d831ec7	0xfb9ac63ac03e9eb62a973c015e3ab426ccf11309833a097dd8fdd4c90d3e952e	42143078645910000	76410000
0x4a14347083b80e5216ca31350a2d21702ac3650d	false	SushiSwap	86	0xd60c3cfccafddcf7b7c55647f2ae39377cced729	15207792	30	0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	2022-07-24T21:40:49.000Z	0xd60c3cfccafddcf7b7c55647f2ae39377cced729	244368677689130075	0	0x34ca12de6d19aabe8d92aac9838ddbe7ec17e4147bc46756de7ec933a18458d5	0x0000000000000000000000000000000000000000	245103989658104389	0xdbdb4d16eda451d0503b854cf79d55697f90c8df	0x0946280d908933894b7b9887628e74d50b0b6b1cdd683a1623bf3a31346d3919	238832614794200000	13750000000000000000
0x4a14347083b80e5216ca31350a2d21702ac3650d	false	SushiSwap	70	0x1e50c0809006976cdb3d9ddebf544e0b8ccf7115	15202551	3333	0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	2022-07-24T02:02:33.000Z	0x1e50c0809006976cdb3d9ddebf544e0b8ccf7115	13665048013184421	4	0x956afad974788a538dcab992c12b28c774463828708cb3c6db6534c5f7f5dd5c	0x0000000000000000000000000000000000000000	20496547192417012	0xdac17f958d2ee523a2206206994597c13d831ec7	0xbde1012fa306a878b6dfbf84c4a7d400d6189c7e64c53ab496b0533eced2dafb	13405397703040000	32000000

Example Query

Query with partition filter

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

AMMWrapperWithPath_Swapped_event

Swap execution events from Tokenlon’s AMMWrapperWithPath contract routing trades through Uniswap V3 on Ethereum. Contains order details, execution amounts, fees, and user addresses for analyzing decentralized exchange aggregation 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_anon0`	`STRUCT<source STRING, transactionHash STRING, settleAmount STRING, receivedAmount STRING, feeFactor STRING, subsidyFactor STRING>`	Contract address of the lending pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_order`	`STRUCT<makerAddr STRING, takerAssetAddr STRING, makerAssetAddr STRING, takerAssetAmount STRING, makerAssetAmount STRING, userAddr STRING, receiverAddr STRING, salt STRING, deadline STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.

Sample Data

address	removed	in_anon0	in_order	log_index	block_number	block_timestamp	transaction_hash
0x4a14347083b80e5216ca31350a2d21702ac3650d	false	{“source”:“Uniswap V3”,“feeFactor”:“15”,“settleAmount”:“193371321525”,“subsidyFactor”:“0”,“receivedAmount”:“193661814247”,“transactionHash”:“0xe0d16092436a046cd553388f82695cf2d9d44a8daee3f7be2aaf9fe550c5c2e2”}	{“salt”:“56131960261892943625317187302517551983107896927787886942432565623686442066160”,“deadline”:“1657745525”,“userAddr”:“0xfc308b7d848a53da38802e2088ae622de8a6b5a1”,“makerAddr”:“0xe592427a0aece92de3edee1f18e0157c05861564”,“receiverAddr”:“0xfc308b7d848a53da38802e2088ae622de8a6b5a1”,“makerAssetAddr”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“takerAssetAddr”:“0x0000000000000000000000000000000000000000”,“makerAssetAmount”:“189565724250”,“takerAssetAmount”:“179996000000000000000”}	241	15136395	2022-07-13T20:22:17.000Z	0x01600ae5da6cc94042a181c7c28ecc5b7f3a3397e8d63eaf124a301b1acb6189
0x4a14347083b80e5216ca31350a2d21702ac3650d	false	{“source”:“Uniswap V3”,“feeFactor”:“20”,“settleAmount”:“809478783”,“subsidyFactor”:“0”,“receivedAmount”:“811100985”,“transactionHash”:“0x58419e704c6b6dfde84f811877ce06d950c2212a3b0277ca6e08482ae9d013bf”}	{“salt”:“60659611278276172131382768140723391527821612134892671264006397007520966062372”,“deadline”:“1657685210”,“userAddr”:“0xf348f05cafa7a8f4b7807859524b707abca8c53a”,“makerAddr”:“0xe592427a0aece92de3edee1f18e0157c05861564”,“receiverAddr”:“0xf348f05cafa7a8f4b7807859524b707abca8c53a”,“makerAssetAddr”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“takerAssetAddr”:“0x0000000000000000000000000000000000000000”,“makerAssetAmount”:“796147055”,“takerAssetAmount”:“770000000000000000”}	175	15131920	2022-07-13T03:36:59.000Z	0xe32f5b15d8a4ecf71797a758060abcf749385de7b4d7436e67d912fc70cb0a67
0x4a14347083b80e5216ca31350a2d21702ac3650d	false	{“source”:“Uniswap V3”,“feeFactor”:“22”,“settleAmount”:“50083216330”,“subsidyFactor”:“0”,“receivedAmount”:“50193642344”,“transactionHash”:“0xc3e80ea5412901890e54516502a165abb6fae015237273549ed709beffb12697”}	{“salt”:“47053195698182250454499751388070449543992218542859299510063107913350543700968”,“deadline”:“1657737148”,“userAddr”:“0x0671f92c5f7bb4c0ba076b2eb2b10143b8e1cc70”,“makerAddr”:“0xe592427a0aece92de3edee1f18e0157c05861564”,“receiverAddr”:“0x0671f92c5f7bb4c0ba076b2eb2b10143b8e1cc70”,“makerAssetAddr”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“takerAssetAddr”:“0x0000000000000000000000000000000000000000”,“makerAssetAmount”:“49103707656”,“takerAssetAmount”:“46160000000000000000”}	45	15135762	2022-07-13T18:02:46.000Z	0xd195afd6549762e88a438b451858dbeb1281d774aff0d855b5e8a540221a94dd

Example Query

Query with partition filter

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

AMMWrapperWithPath_Swapped2_event

Token swap execution records from Tokenlon’s AMMWrapper contract on Ethereum, routing through DEXs like Uniswap V2 and SushiSwap. Captures trade details including input/output amounts, fees, subsidies, and liquidity sources for analyzing Tokenlon aggregator performance.

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_source`	`STRING`	Source chain identifier for the cross-chain operation. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-1” for Ethereum, “EVM-56” for BSC).
`in_transactionHash`	`STRING`	Transaction hash on the destination chain for the cross-chain bridge or swap operation. 66-character hex string including 0x prefix.
`in_userAddr`	`STRING`	Address of the user initiating the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_takerAssetAddr`	`STRING`	Contract address of the token provided by the taker in the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_takerAssetAmount`	`STRING`	Amount of tokens provided by the taker in the swap or order. String-encoded integer representing token units in the taker asset’s smallest denomination.
`in_makerAddr`	`STRING`	Address of the market maker or liquidity provider fulfilling the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_makerAssetAddr`	`STRING`	Contract address of the token provided by the market maker in the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_makerAssetAmount`	`STRING`	Amount of tokens provided by the market maker in the order or swap. String-encoded integer representing token units in the maker asset’s smallest denomination.
`in_receiverAddr`	`STRING`	Address designated to receive the output tokens from the swap or fill operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_settleAmount`	`STRING`	Amount of tokens actually settled in the swap or order operation. String-encoded integer representing token units in the smallest denomination of the settled asset.
`in_receivedAmount`	`STRING`	Actual amount of destination tokens received by the beneficiary in the swap or withdrawal operation. String-encoded integer representing token units in the destination token’s smallest denomination.
`in_feeFactor`	`STRING`	Fee multiplier used to calculate protocol fees for the swap or fill operation. String-encoded integer representing basis points or a scaling factor.
`in_subsidyFactor`	`STRING`	Fee subsidy applied to the swap transaction, represented as basis points. Typically 0 when no subsidy is provided, or a small value (e.g., 4) when Tokenlon subsidizes the swap.

Sample Data

address	removed	in_source	log_index	in_userAddr	block_number	in_feeFactor	in_makerAddr	block_timestamp	in_receiverAddr	in_settleAmount	in_subsidyFactor	transaction_hash	in_makerAssetAddr	in_receivedAmount	in_takerAssetAddr	in_transactionHash	in_makerAssetAmount	in_takerAssetAmount
0x4a14347083b80e5216ca31350a2d21702ac3650d	false	Uniswap V2	179	0xddc1929d86f047bd540407bd24846eeb5ca96654	17388240	22	0x7a250d5630b4cf539739df2c5dacb4c659f2488d	2023-06-01T20:11:11.000Z	0xddc1929d86f047bd540407bd24846eeb5ca96654	274271351808450280	0	0x3f0ef785c357fff24156cdebd01c8322e0884b4bbe7449e96470523082855d4c	0x0000000000000000000000000000000000000000	274876079182652115	0xdac17f958d2ee523a2206206994597c13d831ec7	0xf63d034b2b46b95c9bb091baf5eb0c38b9f9f9e4c9950fc3f8441f9ae019c43c	273559589704950000	515000000
0x4a14347083b80e5216ca31350a2d21702ac3650d	false	Uniswap V2	167	0x450ec29d52036d84a8c83f471b1f7a904d66456a	17384737	1126	0x7a250d5630b4cf539739df2c5dacb4c659f2488d	2023-06-01T08:20:23.000Z	0x450ec29d52036d84a8c83f471b1f7a904d66456a	95291981904387389	4	0x15fdb13eccc599559d64c860ca80cc51dcd50860b4845b24a687b8d683534c08	0x0000000000000000000000000000000000000000	107383346748239114	0xdac17f958d2ee523a2206206994597c13d831ec7	0x374ffcc5b6cc68765e0969a98f34dec100a79116220ca458cc898d451ea349b6	94339635984000000	200000000
0x4a14347083b80e5216ca31350a2d21702ac3650d	false	Uniswap V2	114	0x41d9b6d7ce6ba8268a5cacfec2759eb5f0b63ed4	17388848	18	0x7a250d5630b4cf539739df2c5dacb4c659f2488d	2023-06-01T22:14:59.000Z	0x41d9b6d7ce6ba8268a5cacfec2759eb5f0b63ed4	2743204490	0	0x8744560e9df1405f8467c0819785ed67c36808053d2a72f7201be6c7ac7e6b12	0xdac17f958d2ee523a2206206994597c13d831ec7	2748151163	0x0000000000000000000000000000000000000000	0x8c1aff3c0c24c097376f92933b4b38a2bc0d15465caa54c652f72d397eb2a032	2729474727	1470000000000000000

Example Query

Query with partition filter

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

Exchange_FillOrder_event

Order fill events from Tokenlon v1 decentralized exchange on Ethereum, recording user swaps with filled amounts, maker asset quantities, and recipient addresses. Enables analysis of trading volumes, user activity patterns, and asset swap flows on the Tokenlon protocol.

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_executeTxHash`	`STRING`	Transaction hash of the Tokenlon relayer’s execution transaction that fulfilled this order. This differs from `transaction_hash` which represents the user’s original order submission.
`in_userAddr`	`STRING`	Address of the user initiating the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiverAddr`	`STRING`	Address designated to receive the output tokens from the swap or fill operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_filledAmount`	`STRING`	Token amount filled in the trade, denominated in the taker asset’s smallest unit (wei for ETH-based tokens). Values are string-encoded integers representing amounts like 10.656 tokens (with 18 decimals) or smaller fractional fills.
`in_acutalMakerAssetAmount`	`STRING`	Actual amount of the maker asset received in the trade, denominated in the token’s smallest unit (wei-equivalent). Values vary widely based on token decimals and trade size, representing the executed quantity on the maker side of the swap.

Sample Data

address	removed	log_index	in_userAddr	block_number	block_timestamp	in_filledAmount	in_receiverAddr	in_executeTxHash	transaction_hash	in_acutalMakerAssetAmount
0xdc6c91b569c98f9f6f74d90f9beff99fdaf4248b	false	5	0xe1b1a07b1b985a270c5af3f42f475c142c0eaac1	8405059	2019-08-23T07:02:01.000Z	10656300000000000000	0xe1b1a07b1b985a270c5af3f42f475c142c0eaac1	0x24e60a678a686a16513e5d98652f455ee72930ea201c747a8a884a3bcb4b5dda	0x3c0429ee796d017bc0320c02e254c8072b4e0063b5cec16c92d9e025f5c6939c	55335022419000000
0xdc6c91b569c98f9f6f74d90f9beff99fdaf4248b	false	5	0xeb07cdd4d4f98268150ea1b64389b4d558b31db7	8409522	2019-08-23T23:30:27.000Z	562100000000000000	0xeb07cdd4d4f98268150ea1b64389b4d558b31db7	0x27f6f50a59070aa134e777119a3c3d2f4ee795092099e7e9de902ec5e44a33da	0x15d7c2e3aac80253d2afaf8ddd59ff87d3ade8d31cc44c21afa8374e4485816f	108379213559356000000
0xdc6c91b569c98f9f6f74d90f9beff99fdaf4248b	false	5	0xa993a97e557a7afa6d3248638efca8e414718b91	8403700	2019-08-23T01:56:51.000Z	209819600000000000	0xa993a97e557a7afa6d3248638efca8e414718b91	0xd3d6ced8a51c764c448137156d62b24fb387fc1d6ad212b3da8dcf0d09866ecd	0x638d0bb6c6b85ea6e4e16dc32dd04c752de38d8453297c0fee7e8414611c753b	39880000

Example Query

Query with partition filter

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

MerkleRedeem_Claimed_event

Token claim events from Merkle tree-based distribution contracts recording successful redemptions. Contains claimant address and claimed token balance for tracking airdrop and reward distribution execution.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_balance`	`STRING`	Token balance amount involved in the operation. Numeric string representation in smallest denomination of the token.

Sample Data

address	removed	log_index	in_balance	block_number	in_recipient	block_timestamp	transaction_hash
0x0000000006a0403952389b70d8ee4e45479023db	false	269	63545392000000000000	14945878	0xf2c5e6b7c398d46fd1b7f234a5a39572fe477fcb	2022-06-11T19:01:36.000Z	0xeca049e3cc44244e59c1b562f7f2a0149f191354700b71e4a5eb23f8f257f0ba
0x0000000006a0403952389b70d8ee4e45479023db	false	430	227017231000000000000	14945374	0xebd60094ae7d1f389ddaf56757b40ccbb3cd976a	2022-06-11T16:54:58.000Z	0x0da3b284d60231dffc48423a6fba3899c463d39572e580a28001c685c71006a9
0x0000000006a0403952389b70d8ee4e45479023db	false	127	50418418000000000000	11650561	0x78d2711ed899ae9ff6ed8cf26b8b36c62901dcdf	2021-01-14T02:22:04.000Z	0x3b58b3690345d89799fe18df0903c4192376ef2d103db06e69f8c2a1b06ead9c

Example Query

Query with partition filter

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

PMM_FillOrder_event

Order fill events from Tokenlon’s Private Market Maker (PMM) v1 protocol on Ethereum, capturing swap executions with maker/taker addresses, asset amounts, fees, and settlement details routed through 0x v2 for analyzing DEX aggregator trading 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_source`	`STRING`	Source chain identifier for the cross-chain operation. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-1” for Ethereum, “EVM-56” for BSC).
`in_transactionHash`	`STRING`	Transaction hash on the destination chain for the cross-chain bridge or swap operation. 66-character hex string including 0x prefix.
`in_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_userAddr`	`STRING`	Address of the user initiating the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_takerAssetAddr`	`STRING`	Contract address of the token provided by the taker in the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_takerAssetAmount`	`STRING`	Amount of tokens provided by the taker in the swap or order. String-encoded integer representing token units in the taker asset’s smallest denomination.
`in_makerAddr`	`STRING`	Address of the market maker or liquidity provider fulfilling the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_makerAssetAddr`	`STRING`	Contract address of the token provided by the market maker in the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_makerAssetAmount`	`STRING`	Amount of tokens provided by the market maker in the order or swap. String-encoded integer representing token units in the maker asset’s smallest denomination.
`in_receiverAddr`	`STRING`	Address designated to receive the output tokens from the swap or fill operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_settleAmount`	`STRING`	Amount of tokens actually settled in the swap or order operation. String-encoded integer representing token units in the smallest denomination of the settled asset.
`in_feeFactor`	`STRING`	Fee multiplier used to calculate protocol fees for the swap or fill operation. String-encoded integer representing basis points or a scaling factor.

Sample Data

address	removed	in_source	log_index	in_userAddr	block_number	in_feeFactor	in_makerAddr	in_orderHash	block_timestamp	in_receiverAddr	in_settleAmount	transaction_hash	in_makerAssetAddr	in_takerAssetAddr	in_transactionHash	in_makerAssetAmount	in_takerAssetAmount
0x8d90113a1e286a5ab3e496fbd1853f265e5913c6	false	0x v2	257	0x9b29a973688ddf7ea8ba5abc063294636fd62cb6	14585522	4	0x0000006daea1723962647b7e189d311d757fb793	0x7c17dfa5425fad93288b1392e2085b4a0d463c255357498b4926f7c176f4aed9	2022-04-14T19:50:55.000Z	0x9b29a973688ddf7ea8ba5abc063294636fd62cb6	149783245200	0xce6bcd1bf4897d21a10de617338c36fd905c6dfa8c1b955d4b43c85a56f11db6	0xdac17f958d2ee523a2206206994597c13d831ec7	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x8a5fd0a227bbfe0393e2c352786dd4d4242ec3f722d01bc7517e7acbc060f1f0	149843182473	149975000000
0x8d90113a1e286a5ab3e496fbd1853f265e5913c6	false	0x v2	259	0x3b9ada98c5db1bb404b2a30e556000d7d9fb211d	14581189	5	0x0000006daea1723962647b7e189d311d757fb793	0xfb01bb5bfd8f0b603a222252e0d58f45daf49818f9fd985a182341435defc2a1	2022-04-14T03:34:34.000Z	0x3b9ada98c5db1bb404b2a30e556000d7d9fb211d	49922009720	0xdcb49d0f706e135e496e858b2119ef2b10359e3b79df5e0200780494d7988e26	0xdac17f958d2ee523a2206206994597c13d831ec7	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x49c94bf932ff3040ac8af91dff7d4a29bf3b8293f2d499b06d447a6217a608e5	49946983212	49980000000
0x8d90113a1e286a5ab3e496fbd1853f265e5913c6	false	0x v2	322	0x646cb54fc825e3aa8ad04632a91f0334c1e96372	14586171	5	0x0000006daea1723962647b7e189d311d757fb793	0x588067f9d6b117802c7b15a96a4770c2d2813c46e57cebb919d70f87d6ab0682	2022-04-14T22:16:11.000Z	0x646cb54fc825e3aa8ad04632a91f0334c1e96372	102848278391	0xd57c992726f88a613a94f5a7221bbba227a1e3907e5b518afe131c8584b4c5b3	0xdac17f958d2ee523a2206206994597c13d831ec7	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x706736f924f38356e09707b27e5aaa4544a1f8a5a567d78cf3c1ab83e2c8f787	102899728256	102978462500

Example Query

Query with partition filter

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

RFQ_FillOrder_event

Filled order events from Tokenlon’s Request-for-Quote (RFQ) v1 protocol on Ethereum, capturing maker-taker swaps with asset addresses, amounts, fees, and participant accounts. Used for analyzing liquidity provider performance and trade settlement patterns in the RFQ market-making model.

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_source`	`STRING`	Source chain identifier for the cross-chain operation. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-1” for Ethereum, “EVM-56” for BSC).
`in_transactionHash`	`STRING`	Transaction hash on the destination chain for the cross-chain bridge or swap operation. 66-character hex string including 0x prefix.
`in_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_userAddr`	`STRING`	Address of the user initiating the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_takerAssetAddr`	`STRING`	Contract address of the token provided by the taker in the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_takerAssetAmount`	`STRING`	Amount of tokens provided by the taker in the swap or order. String-encoded integer representing token units in the taker asset’s smallest denomination.
`in_makerAddr`	`STRING`	Address of the market maker or liquidity provider fulfilling the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_makerAssetAddr`	`STRING`	Contract address of the token provided by the market maker in the swap or order. Hex-encoded, 0x-prefixed, 42-character string.
`in_makerAssetAmount`	`STRING`	Amount of tokens provided by the market maker in the order or swap. String-encoded integer representing token units in the maker asset’s smallest denomination.
`in_receiverAddr`	`STRING`	Address designated to receive the output tokens from the swap or fill operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_settleAmount`	`STRING`	Amount of tokens actually settled in the swap or order operation. String-encoded integer representing token units in the smallest denomination of the settled asset.
`in_feeFactor`	`STRING`	Fee multiplier used to calculate protocol fees for the swap or fill operation. String-encoded integer representing basis points or a scaling factor.

Sample Data

address	removed	in_source	log_index	in_userAddr	block_number	in_feeFactor	in_makerAddr	in_orderHash	block_timestamp	in_receiverAddr	in_settleAmount	transaction_hash	in_makerAssetAddr	in_takerAssetAddr	in_transactionHash	in_makerAssetAmount	in_takerAssetAmount
0xfd6c2d2499b1331101726a8ac68ccc9da3fab54f	false	RFQ v1	323	0x56665aece0831a1699064b8fe4d34445ce2cdd39	16179672	20	0xb3c839dbde6b96d37c56ee4f9dad3390d49310aa	0x57f8fa614eaa3ef97bed045c53ad6d539514abde76d246554ab95406b6308626	2022-12-14T01:32:23.000Z	0x56665aece0831a1699064b8fe4d34445ce2cdd39	37418422598	0xd642c8d07713b5280fd056dbb57f22ad33a035d31ef9a0fb918be0771be16f00	0xdac17f958d2ee523a2206206994597c13d831ec7	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x67fae3afdb254aac5c318cba3b78e14bee859b2f0dedc0e66d94d11f77d6dbf7	37493409417	211220000
0xfd6c2d2499b1331101726a8ac68ccc9da3fab54f	false	RFQ v1	272	0x2b763c03a2a5af346b363be10659d0530dfdeb09	16180587	10	0x3b938e9525e14361091ee464d8acec291b3cae50	0x8d10bb6ba7e883c8d8732b9a56ef2fc2ec3b979289c4b25b4e71dc9787e4b474	2022-12-14T04:35:35.000Z	0x56665aece0831a1699064b8fe4d34445ce2cdd39	22387753	0x8ecf50c1266e8d3d7690371f9597343ee5b076c25dd7b09d02c883f31d000d87	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x3212b29e33587a00fb1c83346f5dbfa69a458923	0x3eb76389dfcc248b6cb68b716c773081a5fec6143e6a6be62f4f00398f92225a	22410164	22432500
0xfd6c2d2499b1331101726a8ac68ccc9da3fab54f	false	RFQ v1	59	0x2b763c03a2a5af346b363be10659d0530dfdeb09	16182113	10	0x3b938e9525e14361091ee464d8acec291b3cae50	0x1bef3912f0b022a148180af221b89a7022fdcb07c2798b74971cd080f12b6ddd	2022-12-14T09:43:23.000Z	0x335c8817885842850bc5776f7a4d8d0021fdfb92	149550449	0x8b0750ce35e8b565f54fac5a8f9171b74722469077f49c6ac0284208c3300993	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x3212b29e33587a00fb1c83346f5dbfa69a458923	0xf045cca223e2f8129cf65eaefc4f222864ae54efaa7270a944676b85d803374c	149700150	149850000

Example Query

Query with partition filter

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

StakingRewards_RewardPaid_event

Reward distribution events from StakingRewards contracts recording when staked positions earn incentives. Contains recipient address, reward amount, and optional token or position identifiers for tracking yield distribution across protocols.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x9648b119f442a3a096c0d5a1f8a0215b46dbb547	0xae5d3f2cab377e2d57966d4b9fb0e8d8f573fa03	false	176856655664637599542	385	12594376	2021-06-08T14:16:58.000Z	0x674d1ff18a308dd0789f1d746c2f2629f8196aafa43a3b6082a7e4da1241e9a9
0x9648b119f442a3a096c0d5a1f8a0215b46dbb547	0x70672bb8017ad6854998a14f32fe61c1c6a0cd99	false	859394193821150141497	446	12591483	2021-06-08T03:28:55.000Z	0x8806fceb33d5601ba0f10b3c3478cf109b6058e0db139f291fb82c87f410f985
0x9648b119f442a3a096c0d5a1f8a0215b46dbb547	0x5208fae188254946807642822c8051adc6c4323f	false	2374058409286987640704	214	12593650	2021-06-08T11:40:16.000Z	0x5d237437e45f1603747c1e70037885e8c9173946b69149c604f14cf4feb63495

Example Query

Query with partition filter

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

xLON_Redeem_event

xLON token redemption events from Tokenlon protocol on Ethereum, recording when users unstake their shares to receive LON tokens with optional early withdrawal penalties. Used for analyzing staking behavior, redemption patterns, and penalty calculations across the Tokenlon governance token ecosystem.

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_share`	`STRING`	Number of shares minted or burned in the vault or liquidity pool operation. String-encoded integer representing share token quantity in smallest denomination.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_penaltyAmount`	`STRING`	Penalty amount deducted from the redemption due to early withdrawal or other conditions, denominated in the smallest unit of the token (wei-equivalent). Value is zero when no penalty applies, non-zero when users redeem before vesting period completion.

Sample Data

address	in_user	removed	in_share	log_index	block_number	block_timestamp	in_redeemAmount	transaction_hash
0xf88506b0f1d30056b9e5580668d5875b9cd30f23	0xc623f977e517cd8c145006a5d7be116677d59d46	false	511302919088890633474	309	12286606	2021-04-21T23:40:43.000Z	526905706208762771814	0xf0ea097961f8a4a36f84e66918eb0fbfed51b2f85dc4f8f857d0ee504de5d1f4
0xf88506b0f1d30056b9e5580668d5875b9cd30f23	0x659eaa57b998713cc71e7e4b3c444344c04e62b5	false	69586865471786108222	116	12282959	2021-04-21T10:12:18.000Z	71662715390885727738	0xd545e3c4d9a2f5c88f5c68f782201e27626ed5adeb3b93632997cf41566c83c8
0xf88506b0f1d30056b9e5580668d5875b9cd30f23	0x2cae385f00081d6b2708dc1429538bfaf483be62	false	29849646301809935971	367	12283291	2021-04-21T11:23:52.000Z	30740092874459301470	0xa6b951c0b92690c78d6aefd65636e85d959258a7fa93cfe8a1bc452cd53840df

Example Query

Query with partition filter

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

xLON_Staked_event

LON token staking events from Tokenlon’s xLON staking contract on Ethereum, recording when users stake LON tokens in exchange for xLON shares. Useful for analyzing staking participation, share-to-token conversion rates, and tracking individual staker positions 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_share`	`STRING`	Number of shares minted or burned in the vault or liquidity pool operation. String-encoded integer representing share token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_share	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xf88506b0f1d30056b9e5580668d5875b9cd30f23	0x70672bb8017ad6854998a14f32fe61c1c6a0cd99	false	54954611647697045704111	68444015574022963096575	240	13218163	2021-09-13T15:27:27.000Z	0xdad1e4b614ca120c5e5e95bc10307e6a54af5e3eb7bcaedca613877b2fe4dfaf
0xf88506b0f1d30056b9e5580668d5875b9cd30f23	0x2fa69be3b04e34c8695aebe0a5c08bd19aa0460b	false	16001723394598983177573	19929577744128000000000	114	13218140	2021-09-13T15:23:27.000Z	0xcd166857b381aee770daa4996619a57ca56e5c5905b42327a1b68f1f120f1a81
0xf88506b0f1d30056b9e5580668d5875b9cd30f23	0x57b3c68caf0ebea2d9173bdb013655fd8da31aa4	false	460532878129322845183	573577331145673093689	107	13219723	2021-09-13T21:06:20.000Z	0x129e6be46ce926731d3dda8a2c72ae2bdabfcedfda2149f8a052afac8f657f11

Example Query

Query with partition filter

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

ZeroExchange_Fill_event

Order fill events from Tokenlon’s 0x Exchange integration on Ethereum, capturing maker/taker details, filled amounts, and asset data for DEX (decentralized exchange) trade analysis.

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_makerAddress`	`STRING`	Ethereum address of the order maker who provided the maker asset in this 0x protocol trade. Hex-encoded, 0x-prefixed 40-character string representing the liquidity provider’s wallet.
`in_feeRecipientAddress`	`STRING`	Ethereum address designated to receive protocol or relayer fees from this 0x order fill. Frequently set to zero address when no fees are charged.
`in_takerAddress`	`STRING`	Ethereum address of the taker who accepted the maker’s order in this 0x protocol fill. Non-zero address indicating the party that executed against the maker’s limit order.
`in_senderAddress`	`STRING`	Ethereum address of the account that initiated or relayed the 0x order fill transaction. Typically matches the taker address in direct fills, or represents a relayer contract in meta-transactions.
`in_makerAssetFilledAmount`	`STRING`	Amount of the maker asset filled in this 0x exchange order, denominated in the smallest unit of the maker token. Typically represents a single NFT (value of 1) or fungible token quantity in wei-equivalent units.
`in_takerAssetFilledAmount`	`STRING`	Quantity of the taker asset filled in this 0x order execution, denominated in the asset’s smallest unit (wei for ETH). Always represents the actual amount transferred from taker to maker in the swap.
`in_makerFeePaid`	`STRING`	Fee paid by the maker to the fee recipient address, denominated in the maker asset. Typically zero in these 0x protocol trades on Ethereum.
`in_takerFeePaid`	`STRING`	Fee paid by the taker in the 0x protocol trade, denominated in the protocol’s fee token. Always zero in these samples, indicating fee-free trades or fees paid through alternative mechanisms.
`in_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_makerAssetData`	`STRING`	Encoded asset data for the token being sold by the order maker, containing contract address and token identifier for ERC721/ERC1155 tokens. Hex-encoded byte string starting with 0x that the 0x protocol decodes to identify the specific asset being traded.
`in_takerAssetData`	`STRING`	Encoded asset data specifying the token being received by the taker in this 0x order fill. Hex-encoded bytes containing the token contract address and potentially additional parameters like token ID for ERC-721/1155 assets.

Sample Data

address	removed	log_index	block_number	in_orderHash	block_timestamp	in_makerAddress	in_takerAddress	in_senderAddress	transaction_hash	in_makerAssetData	in_takerAssetData	in_feeRecipientAddress	in_makerAssetFilledAmount	in_takerAssetFilledAmount
0x080bf510fcbf18b91105470639e9561022937712	false	22	10076388	0xb624ee54abbace8a2eadd218865f52ca5f562a00225e4937465b3cdad7611fe5	2020-05-16T09:43:12.000Z	0x00dc3c460315191ef3f29f9d275e0cbaa3c45df9	0x4ef40d1bf0983899892946830abf99eca2dbc5ce	0x4ef40d1bf0983899892946830abf99eca2dbc5ce	0x8a83dcffcd0891dba3ca9373b0d72f2e9de2e73cda74a8834cc04bef23aca97f	0x025717920000000000000000000000000e3a2a1f2146d86a604adc220b4967a898d7fe07000000000000000000000000000000000000000000000000000000000a8c37b0	0xf47261b0000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x0d056bb17ad4df5593b93a1efc29cb35ba4aa38d	1	400000000000000
0x080bf510fcbf18b91105470639e9561022937712	false	3	10077921	0xf7e5751aa210650bbc09bcc3a97e758d398b184c6ab42f674fa931704c1926a8	2020-05-16T15:33:56.000Z	0x05b919c6fb57ba73240b2ea77711c1ccc845852f	0xb04239b53806ab31141e6cd47c63fb3480cac908	0xb04239b53806ab31141e6cd47c63fb3480cac908	0x5f38c0fe90908922e87bdf88d90ac91531b325eef84426e5d3994470baa7e262	0x025717920000000000000000000000000e3a2a1f2146d86a604adc220b4967a898d7fe07000000000000000000000000000000000000000000000000000000000d34dd6b	0xf47261b0000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x0000000000000000000000000000000000000000	1	300000000000000
0x080bf510fcbf18b91105470639e9561022937712	false	75	10077921	0x17bdd80a81605d488089e4b8b5a225feaff80668fd0a53d32cac092d00a5c328	2020-05-16T15:33:56.000Z	0x070b43c9397b2456949e0fa661d2ddde811c8740	0xb04239b53806ab31141e6cd47c63fb3480cac908	0xb04239b53806ab31141e6cd47c63fb3480cac908	0x5f38c0fe90908922e87bdf88d90ac91531b325eef84426e5d3994470baa7e262	0x025717920000000000000000000000000e3a2a1f2146d86a604adc220b4967a898d7fe07000000000000000000000000000000000000000000000000000000000d19dab6	0xf47261b0000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x0000000000000000000000000000000000000000	1	20000000000000000

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AMMWrapper_Swapped_event

AMMWrapperWithPath_Swapped_event

AMMWrapperWithPath_Swapped2_event

Exchange_FillOrder_event

MerkleRedeem_Claimed_event

PMM_FillOrder_event

RFQ_FillOrder_event

StakingRewards_RewardPaid_event

xLON_Redeem_event

xLON_Staked_event

ZeroExchange_Fill_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AMMWrapper_Swapped_event

​AMMWrapperWithPath_Swapped_event

​AMMWrapperWithPath_Swapped2_event

​Exchange_FillOrder_event

​MerkleRedeem_Claimed_event

​PMM_FillOrder_event

​RFQ_FillOrder_event

​StakingRewards_RewardPaid_event

​xLON_Redeem_event

​xLON_Staked_event

​ZeroExchange_Fill_event

Tables

AMMWrapper_Swapped_event

AMMWrapperWithPath_Swapped_event

AMMWrapperWithPath_Swapped2_event

Exchange_FillOrder_event

MerkleRedeem_Claimed_event

PMM_FillOrder_event

RFQ_FillOrder_event

StakingRewards_RewardPaid_event

xLON_Redeem_event

xLON_Staked_event

ZeroExchange_Fill_event