shadowexchange_v2_sonic - Token Terminal Docs

Tables

Factory_PairCreated_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX 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_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	block_number	block_timestamp	transaction_hash
0x2da25e7446a70d7be65fd4c053948becaa6374c8	0xcc355f3243a671022972f63d9eb8b84492d4885e	false	1825	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	0x77a6940289d3e96f194b1f6cfdef748d0f63f055	23763547	2025-05-02T11:03:53.000Z	0xf9c9fb3c2fc85f2b30f981fb3b4941c25de85f862dd96de376ee1cb29265e940
0x2da25e7446a70d7be65fd4c053948becaa6374c8	0x7498c98518ff427a392ad15a7019acddc8a99df2	false	1829	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	0x0c1af8e2b8ee3c276cfd891870dcab889238ae01	23764112	2025-05-02T11:06:58.000Z	0x87d036240e90da0b7c01ef38f7cb956c08caf952ce3d668ff6c5acbcb571311a
0x2da25e7446a70d7be65fd4c053948becaa6374c8	0x01efda487370b8da8388c958dde48c4659130da8	false	1827	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	0x6cad03d31e0c79b600dadc475e37e49dfedbd942	23763757	2025-05-02T11:05:02.000Z	0x03fb88435c97acacd783e563c95de8b317c9db992fdba9bc686e1ae8f3df3fbf

Example Query

Query with partition filter

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

FeeDistributorFactory_createFeeDistributor_function

Factory contract deployments of fee distributor contracts on Shadow Exchange V2 (Sonic chain), linking fee recipients to newly created distributor addresses. Tracks protocol revenue sharing infrastructure setup with block-level granularity.

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_feeRecipient`	`STRING`	Address designated to receive fees collected from the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	out_anon0	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_feeRecipient	transaction_hash
3640459	true	1380636	0xcda00b54f73d6dfd147124d01676b3a1ceceefcf	0x062e631e	0x29adf08a22381855243eeeb3228647ac56847ff5	14877092	0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4f	0,2,7,3	2025-03-20T17:38:06.000Z	0x6835490ae91a4d95a1749ed4f848451d7cf2383a	0xd8d6069a535cec4b85c4cf340ef9a069700582e1da4ce48842c37bb472026996
3640459	true	1380636	0x3f63882407d99c710c9d849f9023eda82ce96a50	0x062e631e	0x29adf08a22381855243eeeb3228647ac56847ff5	14877768	0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4f	0,2,7,3	2025-03-20T17:42:14.000Z	0x6b0d9af796a519aa3921703b38eba0c6b4402ca0	0xe00db619e4e0aba0a548f6e9b29b6b05ef35e5078da77abf3e607674295030a3
3684312	true	1380636	0xbe8f55f0060f7eed0fc7e232d19b8b6910917f6c	0x062e631e	0x29adf08a22381855243eeeb3228647ac56847ff5	14876368	0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4f	0,2,7,3	2025-03-20T17:33:37.000Z	0xafedf82299064cb450bacb9b8994d2525f6910f2	0xeefcefef942f637c14da8442f4c512b8758d59538c55aeff92009eaa0454f7bb

Example Query

Query with partition filter

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

Gauge_ClaimRewards_event

Reward distribution events emitted when users claim accrued incentives from liquidity mining gauges. Records the claimer address, reward token contract, and claimed amount for tracking protocol incentive flows.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. 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.

Sample Data

address	in_from	removed	in_amount	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xcd15aec547d01e24da7368d683872692354bf704	0xa8249e30fb87b176efb730fe100ddc65f283ca6c	false	14939624583272443	0x5050bc082ff4a74fb6b0b04385defddb114b2424	6	30774934	2025-05-31T00:08:13.000Z	0x9b6c602a2afcd8e7ed82554cdc647e8658019f1b227c558b9086fe00b7d5036d
0xfd197f2c6e8077bb5ad81f6f682736e4c4de8712	0x8cd6d52c3372d07c050526a67c4e2c2ee100931c	false	22088742763778749	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	116	30776355	2025-05-31T00:16:30.000Z	0x9a1687474599708975ee885f3cf631a8abdf60f1e9ba2cb5d8dcfeedee6538f4
0xfd197f2c6e8077bb5ad81f6f682736e4c4de8712	0x8cd6d52c3372d07c050526a67c4e2c2ee100931c	false	38968161729533	0x5555b2733602ded58d47b8d3d989e631cbee5555	112	30776355	2025-05-31T00:16:30.000Z	0x9a1687474599708975ee885f3cf631a8abdf60f1e9ba2cb5d8dcfeedee6538f4

Example Query

Query with partition filter

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

Gauge_Deposit_event

Deposit events into ShadowExchange V2 liquidity gauge contracts on Sonic, recording staking transactions with depositor addresses and token amounts. Used for tracking gauge participation and liquidity mining position changes.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xcbcad939e2bbbe01850a141f204f25df63b8fc5b	0x3beb6f7485c51fca97f31a2ae1816b6a078d4d4a	false	18221394638828882252	1	4221222	2025-01-17T02:38:31.000Z	0xe03b047a4b424538d3418460dc7d725cac7fbcf3305e16503745938545a3c158
0xcbcad939e2bbbe01850a141f204f25df63b8fc5b	0xcc1f3956f16942ce6a4af938c5c1ce16f2b9ff81	false	2087009651177197800	1	4209455	2025-01-17T00:07:19.000Z	0x1bdd6b779b7fc7b0dbd2ef8d022b29ecf3c30fd1d4bc87df45f36537941958c0
0xcbcad939e2bbbe01850a141f204f25df63b8fc5b	0xcc1f3956f16942ce6a4af938c5c1ce16f2b9ff81	false	2087009651177197800	1	4209169	2025-01-17T00:03:57.000Z	0x0b4ebdfa5deb85301f2e0dd8b0959b0ad1fc99bce395271b6f05cef1e8587110

Example Query

Query with partition filter

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

Gauge_NotifyReward_event

Reward distribution events from ShadowExchange v2 liquidity gauges on Sonic, capturing token incentives allocated to liquidity providers. Contains reward token addresses, amounts, and distributor information for analyzing emissions and gauge 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_from`	`STRING`	Address originating the transfer or 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.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_amount	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x2092a2041bb2d533943e462ec618e5e6cedef9af	0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d	false	4486286106225658448	0x3333b97138d4b086720b5ae8a7844b1345a33333	195	46432134	2025-09-11T00:03:57.000Z	0xd925a63763c28c533ed8fce091d72d791c62c200da63d1a83fe80a7bf16f23d6
0x7fcc1510bbdbf100c12250336278f8c1a40b65b7	0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d	false	221005331710040098946	0x3333b97138d4b086720b5ae8a7844b1345a33333	176	46432134	2025-09-11T00:03:57.000Z	0xd925a63763c28c533ed8fce091d72d791c62c200da63d1a83fe80a7bf16f23d6
0x55f4a7a4a74dfb2e03046e82732d93227602cbdc	0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d	false	9616229984445770965	0x3333b97138d4b086720b5ae8a7844b1345a33333	191	46432134	2025-09-11T00:03:57.000Z	0xd925a63763c28c533ed8fce091d72d791c62c200da63d1a83fe80a7bf16f23d6

Example Query

Query with partition filter

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

Gauge_Withdraw_event

Gauge withdrawal events from Shadow Exchange V2 on Sonic, recording when users unstake liquidity provider tokens from incentive gauges. Used for analyzing farming participation patterns and liquidity mining exit 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_from`	`STRING`	Address originating the transfer or 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.

Sample Data

address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x01a40194431d3b9def35ee2b1b8e3e46c66ae8e7	0xe6e0a10eb298f0ac4170f2502cf7b201375bbc85	false	90000000000000000000000	1	15339194	2025-03-23T02:05:53.000Z	0xe6aa47508b1433c8ebd155efddeb9b929247d88a5e56a1a2f965dd49129f377e
0x320c717a32b69de9a8a5e001786ff2352a4fa85b	0x10c9124939a543e5c2c3f1fdbb9b17c0848ee279	false	40474788983882505363	1	15432139	2025-03-23T13:30:19.000Z	0x51f0f4d12ef55ef8fc028bbc2ed6733414467f3c124a56b3de0a2755cb2c5d61
0x320c717a32b69de9a8a5e001786ff2352a4fa85b	0xee07dea66e9284a8ddeae1db612f2ce0c4824cac	false	10000000000000000000	1	15376253	2025-03-23T07:12:38.000Z	0x8e952ecd468a1c72c0f4737a41dd01e284d4bf15a5af1a003a63bf28dc253c53

Example Query

Query with partition filter

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

GaugeFactory_createGauge_function

Gauge creation events from ShadowExchange v2 on Sonic, recording when new liquidity mining gauges are deployed for specific pool addresses. Useful for tracking governance-approved incentive programs and analyzing which liquidity pools receive emission rewards.

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__pool`	`STRING`	Contract address of the liquidity pool for which the gauge is being created. Hex-encoded, 0x-prefixed 40-character string representing the pool on Sonic chain.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in__pool	out_anon0	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
6437895	true	1959360	0xa30db08e1ace7c23ae959e1d2e3584b8e3b1858a	0xf2036cd038a1abb9522e8ccd09bb9e78afbadb05	0xa5f4301e	0x8cf82d413ca20a40a2fa43c2bf77d136d81299e9	25100190	0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4f	0,2,1,0,0,8,0,9,7	2025-05-07T21:56:16.000Z	0x10989eb51df218ae11c570225eea8310d63cae060336b24b97f9a615d8172cbe
6437895	true	1959360	0xd7202d441778714ffe7c59879aad163abd91ad82	0x910d9106fd2134db034756a1671350f1c1f32ff9	0xa5f4301e	0x8cf82d413ca20a40a2fa43c2bf77d136d81299e9	25100304	0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4f	0,2,1,0,0,8,0,9,7	2025-05-07T21:57:01.000Z	0x80a3a28621c03feda37b20764c2cc084e031d158db28a8e818231a2943f5ca40
10971559	true	1876649	0xd7202d441778714ffe7c59879aad163abd91ad82	0xe19da85a76ddac5f10fd9e7b5581d348fb82c6c6	0xa5f4301e	0x57c4c4bb67a19ab3a8609568a038d917be86043f	25100304	0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d	0,2,1,0,0,5	2025-05-07T21:57:01.000Z	0x80a3a28621c03feda37b20764c2cc084e031d158db28a8e818231a2943f5ca40

Example Query

Query with partition filter

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

GaugeFactory_GaugeCreated_event

Gauge creation events from Shadow Exchange V2’s GaugeFactory contract on Sonic, recording the deployment of new liquidity mining gauges for specific pools. Links each gauge to its associated pool, fee distributor, and creator address for analyzing reward distribution infrastructure and liquidity incentive programs.

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_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeDistributor`	`STRING`	Contract address of the fee distributor associated with the gauge. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_gauge	log_index	in_creator	block_number	block_timestamp	transaction_hash	in_feeDistributor
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d	0x5b4dc4eefdd7973b4f309238e8cada7cea0b00c1	false	0x63d39cc1df75c52e1d52d9129fe9ede76b060b9c	23	0x5e7a9eea6988063a4dbb9ccddb3e04c923e8e37f	24508116	2025-05-05T12:02:34.000Z	0x0656029b184e8c562df757bfaba365420ce8733daef458b02603901ec15b9671	0xbc44d52ac90b5866b2fa602598c53151ac6deefb
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d	0xd9e3be6c93a575d9b2cbd5372d54d1921ca2fbbc	false	0xc66ede2f33ed99ec09711a7789eb5c750bf8e4ea	8	0x5e7a9eea6988063a4dbb9ccddb3e04c923e8e37f	14671739	2025-03-19T17:24:19.000Z	0x50cb06253cb1b215c2930fc59ef9e714c0bc509f7a96b8b50eebb5393b44681a	0x62c5442449db7ec783a38d355851f061131730f2
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d	0x5d47882852688084d94adcf12e30b11d0afb50fa	false	0x542ab869e328e63fb4d863f17ac95b1508a64b38	101	0x5e7a9eea6988063a4dbb9ccddb3e04c923e8e37f	14708200	2025-03-19T21:19:51.000Z	0xbb5e6d88aeb776fde754a8a5e5bb8562384365396c767763cc859c628a7b1541	0xc96e2c763fc02a34263a0ad765421c10f16bfea1

Example Query

Query with partition filter

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

Pair_mintFee_function

Liquidity pool fee minting function calls on ShadowExchange V2 DEX (decentralized exchange) deployed on Sonic chain. Tracks protocol fee collection attempts across trading pairs, useful for analyzing fee accrual patterns and pool profitability.

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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
166467	false	41060	0x13966db5	0xd7202d441778714ffe7c59879aad163abd91ad82	38255709	0xe1af2e74bc4e75fc973c84b997dbd0c0d8e63187	167	2025-07-13T00:00:18.000Z	0xacdb4471ba9c1d53d7576dd5bb5860dacd844f2adcaec4c43ae7d5e0a12e64fb
361736	false	41118	0x13966db5	0xc00021495419f35ad564e289b5077f48d1399b2d	38255709	0xe1af2e74bc4e75fc973c84b997dbd0c0d8e63187	159	2025-07-13T00:00:18.000Z	0xacdb4471ba9c1d53d7576dd5bb5860dacd844f2adcaec4c43ae7d5e0a12e64fb
590505	false	41120	0x13966db5	0xa30db08e1ace7c23ae959e1d2e3584b8e3b1858a	38255709	0xe1af2e74bc4e75fc973c84b997dbd0c0d8e63187	151	2025-07-13T00:00:18.000Z	0xacdb4471ba9c1d53d7576dd5bb5860dacd844f2adcaec4c43ae7d5e0a12e64fb

Example Query

Query with partition filter

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

Pair_setFee_function

Trading fee configuration changes for Shadow Exchange V2 liquidity pairs on Sonic blockchain. Records setFee function calls showing fee adjustments in basis points (10000 = 1%) with caller addresses and pair contracts for tracking fee tier management.

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__fee`	`STRING`	Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points.

Sample Data

gas	status	in__fee	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
48969	true	10000	5573	0x69fe0e2d	0x382e360d672ec27d9225c3d2c439993316f95623	16711000	0x2da25e7446a70d7be65fd4c053948becaa6374c8	0,2,0,0	2025-03-29T04:20:09.000Z	0x474d150661265fd2d44a7ddaa85f53750b8b698395a4defdd682d8dfa6c8bb34
48969	true	10000	5573	0x69fe0e2d	0x07e356f542da8a86728d8625f52aadb436147456	16840618	0x2da25e7446a70d7be65fd4c053948becaa6374c8	0,2,0,0	2025-03-29T18:18:25.000Z	0x04301151b96e2366d7db78f97bf381a61e74c9d802e848a87b57f79d05d75313
48969	true	20000	5573	0x69fe0e2d	0x382e360d672ec27d9225c3d2c439993316f95623	16711051	0x2da25e7446a70d7be65fd4c053948becaa6374c8	0,2,0,0	2025-03-29T04:20:29.000Z	0xb055df3743759a265a0278a5060c61b8b358c6ea08f9fd485c607f3e91c1f4aa

Example Query

Query with partition filter

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

Pair_setFeeRecipient_function

Administrative function calls that update the fee recipient address for Shadow Exchange V2 liquidity pairs on Sonic. Used for tracking protocol fee configuration changes across different 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.
`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__feeRecipient`	`STRING`	Address designated to receive trading fees from the ShadowExchange v2 liquidity pair contract. Consistently set to the same recipient address (0xe25e95f75432a79d31256cc3026e24aaa5540882) across all function calls.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in__feeRecipient	transaction_hash
352080	true	23191	0xe74b981b	0x278ad0cac12b1b4e67d0163e0d04e9855d3498c1	51442172	0x2da25e7446a70d7be65fd4c053948becaa6374c8	1,3	2025-10-21T18:31:07.000Z	0xe25e95f75432a79d31256cc3026e24aaa5540882	0x2da46e7b54047c30f70cfd27f12b4861a71651e7adc5eac23fa00001e7ba035a
352168	true	23191	0xe74b981b	0xf94fed51da830996d77d1325a890e2ec5d1ff565	51379904	0x2da25e7446a70d7be65fd4c053948becaa6374c8	1,3	2025-10-21T05:55:03.000Z	0xe25e95f75432a79d31256cc3026e24aaa5540882	0x329f95a53bea2d5c69b9a3d16667dd2fc08e739cca3a4f2504dcea14dffab806
352216	true	23191	0xe74b981b	0x59776ed26172722d868cd1b1c87b0859af184974	51404948	0x2da25e7446a70d7be65fd4c053948becaa6374c8	1,3	2025-10-21T12:17:40.000Z	0xe25e95f75432a79d31256cc3026e24aaa5540882	0x665e146bd906280ce6f7ffcdc5f6793b4aa45aa91f64254cb60ed494b7032d4b

Example Query

Query with partition filter

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

Pair_setFeeSplit_function

Fee distribution configuration changes for Shadow Exchange v2 liquidity pairs on Sonic, recording when protocol administrators adjust the fee split parameter across different 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.
`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__feeSplit`	`STRING`	Fee split ratio expressed in basis points. Integer string representing the percentage allocation multiplied by precision factor.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in__feeSplit	trace_address	block_timestamp	transaction_hash
4409559	true	3081	0xcd962a06	0x268d86627e193dc731bb06109d69175d56d54c98	53858839	0x2da25e7446a70d7be65fd4c053948becaa6374c8	10000	0,19,0,3,0,1,0,0	2025-11-06T00:01:30.000Z	0x9321b03f469eb768c4ecedffdfab2f34fad9bb8a216ad17689ca65ebc8062715
4995428	true	3081	0xcd962a06	0xf19748a0e269c6965a84f8c98ca8c47a064d4dd0	53858839	0x2da25e7446a70d7be65fd4c053948becaa6374c8	10000	0,14,0,3,0,1,0,0	2025-11-06T00:01:30.000Z	0x9321b03f469eb768c4ecedffdfab2f34fad9bb8a216ad17689ca65ebc8062715
4077550	true	3081	0xcd962a06	0xb901d7316447c84f4417b8a8268e2822095051e6	53858839	0x2da25e7446a70d7be65fd4c053948becaa6374c8	10000	0,21,0,3,0,1,0,0	2025-11-06T00:01:30.000Z	0x9321b03f469eb768c4ecedffdfab2f34fad9bb8a216ad17689ca65ebc8062715

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX 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.
`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
0x058e99e564c3a600bdea7f082aba09a877023e0e	0x1c3a9a436de6b67c4125a7d4ed42832fdeae50f1	false	0x058e99e564c3a600bdea7f082aba09a877023e0e	12	20918785	1013533407256055769107	140241959355678720	2025-04-18T16:53:10.000Z	0xda5c9792c8f25df152e6d90f15667d9654c0688b87809648c56b8660108dcdad
0x058e99e564c3a600bdea7f082aba09a877023e0e	0xd6bb2e371ad969a8ae0d7ee306e500e9fb2a3663	false	0x058e99e564c3a600bdea7f082aba09a877023e0e	8	20816389	293845188358796556848603	1388182349744701440	2025-04-18T00:26:45.000Z	0x4a011d4b5a21044caab0c4c8321070935980ac1944da2d9866065d77e6892675
0x0f4a1d7fdf4890be35e71f3e0bbc4a0ec377eca3	0x1d57b8f22c1f9a5831b443077a6fe043a5ac2ffb	false	0x0f4a1d7fdf4890be35e71f3e0bbc4a0ec377eca3	5	20849411	443664579785194852213	57859659	2025-04-18T06:28:20.000Z	0x8989e2a63e10f4cc4faf26b0e7eee6592ebfd287d67a16865ea678f472f40862

Example Query

Query with partition filter

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

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

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
0xccac870ddff20dabb5606a6eb5fd159cd6a64ee9	false	93	115238702155389897185618	1009519474155225888586806	12525190	2025-03-08T20:45:37.000Z	0x40ad0c8e38a6ef85e7d754ec51dac6ec253dcff2b9f38f0582d74e2b2306d09c
0xccac870ddff20dabb5606a6eb5fd159cd6a64ee9	false	83	115216352848673304846501	1009714710105913546292621	12525190	2025-03-08T20:45:37.000Z	0x40ad0c8e38a6ef85e7d754ec51dac6ec253dcff2b9f38f0582d74e2b2306d09c
0xccac870ddff20dabb5606a6eb5fd159cd6a64ee9	false	72	115194021411704969788471	1009909865505369306877675	12525190	2025-03-08T20:45:37.000Z	0x40ad0c8e38a6ef85e7d754ec51dac6ec253dcff2b9f38f0582d74e2b2306d09c

Example Query

Query with partition filter

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

PairFactory_FeeSplitWhenNoGauge_event

Fee split configuration events from Shadow Exchange V2’s pair factory contract on Sonic, tracking when fee distribution is enabled or disabled for trading pairs without active gauge incentives.

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__caller`	`STRING`	Address of the account that initiated the function call which emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`in__status`	`BOOL`	Boolean flag indicating whether fee splitting is enabled (true) or disabled (false) when no gauge is present for the pair. Determines the fee distribution behavior in the absence of an active liquidity gauge.

Sample Data

address	removed	log_index	in__caller	in__status	block_number	block_timestamp	transaction_hash
0x2da25e7446a70d7be65fd4c053948becaa6374c8	false	7	0x5e7a9eea6988063a4dbb9ccddb3e04c923e8e37f	true	10103452	2025-02-25T17:32:14.000Z	0x89cb4a6b4a57e9b26f9bc50abc0d7630833f819b864783ce3bbecded2fde1f46

Example Query

Query with partition filter

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

PairFactory_NewTreasury_event

Treasury address update events from ShadowExchange V2’s PairFactory contract on Sonic. Tracks administrative changes to the protocol’s treasury wallet address for fee collection monitoring.

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__caller`	`STRING`	Address of the account that initiated the function call which emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`in__newTreasury`	`STRING`	Contract address of the newly assigned treasury wallet for the Shadow Exchange PairFactory. This address receives protocol fees and is updated by authorized callers through governance actions.

Sample Data

address	removed	log_index	in__caller	block_number	block_timestamp	in__newTreasury	transaction_hash
0x2da25e7446a70d7be65fd4c053948becaa6374c8	false	1	0x5e7a9eea6988063a4dbb9ccddb3e04c923e8e37f	13884551	2025-03-15T14:35:01.000Z	0x0fd000904ac54a4912f03d49f6715a5728726d79	0xb5f0f9da816d61845ac7fa1ea98266d659ccd069214f7fa2b92990fe34693c82
0x2da25e7446a70d7be65fd4c053948becaa6374c8	false	0	0x5e7a9eea6988063a4dbb9ccddb3e04c923e8e37f	14515211	2025-03-18T21:37:46.000Z	0xe25e95f75432a79d31256cc3026e24aaa5540882	0x7b4aa128bab4d40f733cbfd82983d36fbf11f7c5a533254b7d2b028294f32cb7

Example Query

Query with partition filter

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

PairFactory_SetFee_event

Fee configuration change events from the Shadow Exchange v2 PairFactory contract on Sonic, recording when trading fee parameters are updated. Useful for tracking fee structure changes and analyzing protocol revenue optimization strategies.

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_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	removed	log_index	block_number	block_timestamp	transaction_hash
3000	0x2da25e7446a70d7be65fd4c053948becaa6374c8	false	5	4079611	2025-01-16T01:03:18.000Z	0x24102280e20447961eb651a1ff9e631c6b63654dc5ab5797ad28bca5d79a1214
500000	0x2da25e7446a70d7be65fd4c053948becaa6374c8	false	0	4057717	2025-01-15T22:12:10.000Z	0xbe713b89925db5c7327adf02a32eb875966e5cd39c6cbd700b07d87c30f4b753
10000	0x2da25e7446a70d7be65fd4c053948becaa6374c8	false	4	12716346	2025-03-09T21:01:12.000Z	0x699f67022c6d588e592b652edead9334dfe5f8a8b65bd2131a74ec33842b8ac1

Example Query

Query with partition filter

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

PairFactory_SetFeeRecipient_event

Fee recipient configuration events from ShadowExchange DEX (decentralized exchange) on Sonic blockchain, tracking which addresses receive trading fees for specific liquidity pairs. Used for analyzing fee distribution changes and protocol governance decisions.

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_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeRecipient`	`STRING`	Address designated to receive fees collected from the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pair	removed	log_index	block_number	block_timestamp	in_feeRecipient	transaction_hash
0x2da25e7446a70d7be65fd4c053948becaa6374c8	0xf19748a0e269c6965a84f8c98ca8c47a064d4dd0	false	1	4078047	2025-01-16T00:52:12.000Z	0xb9b20d182d29f7769fa7805b8d7f648f2825386b	0x07cf1fb251f238eb3a67152c2b88bbcf9ab5548b2f86108b935d2b48419bcdd7
0x2da25e7446a70d7be65fd4c053948becaa6374c8	0xf19748a0e269c6965a84f8c98ca8c47a064d4dd0	false	10	17792902	2025-04-03T00:00:16.000Z	0xb9b20d182d29f7769fa7805b8d7f648f2825386b	0x6927c0e18cb269d348b4a543d1c6e04eee61bbadcc2f3e6b91e9de8021f361d9
0x2da25e7446a70d7be65fd4c053948becaa6374c8	0xf19748a0e269c6965a84f8c98ca8c47a064d4dd0	false	14	17792902	2025-04-03T00:00:16.000Z	0x2a78f35726751d22e172dd755cfc051f352affbf	0x6927c0e18cb269d348b4a543d1c6e04eee61bbadcc2f3e6b91e9de8021f361d9

Example Query

Query with partition filter

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

PairFactory_SetFeeSplit_event

Fee split configuration changes for ShadowExchange V2 liquidity pairs on Sonic, emitted when the protocol adjusts revenue sharing parameters. Values represent basis points (500 = 5%, 10000 = 100%) for tracking fee distribution policy updates.

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__feeSplit`	`STRING`	Fee split ratio expressed in basis points. Integer string representing the percentage allocation multiplied by precision factor.

Sample Data

address	removed	block_number	in__feeSplit	block_timestamp	transaction_hash
0x2da25e7446a70d7be65fd4c053948becaa6374c8	false	10200895	500	2025-02-26T02:57:53.000Z	0xf0c51225cfd18bd44fa1f8f022c90f18dc9c3607fd550f37620b074bd87b16a4
0x2da25e7446a70d7be65fd4c053948becaa6374c8	false	4044354	500	2025-01-15T20:17:37.000Z	0x11912822ded1d2d1e6c447965dc2501a565beb1397570ca724c2c842e2d59dcd
0x2da25e7446a70d7be65fd4c053948becaa6374c8	false	4046356	10000	2025-01-15T20:35:33.000Z	0xced7ac8c910e1646aff6e9c467626b49d67de10a0db67fcd40980e9a055aa0e4

Example Query

Query with partition filter

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

PairFactory_SetPairFee_event

Fee configuration changes for trading pairs on Shadow Exchange v2 (Sonic chain), emitted when pair-level swap fees are updated by the factory contract. Useful for tracking fee tier adjustments and protocol governance decisions.

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_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	in_pair	removed	log_index	block_number	block_timestamp	transaction_hash
20000	0x2da25e7446a70d7be65fd4c053948becaa6374c8	0x1d57b8f22c1f9a5831b443077a6fe043a5ac2ffb	false	24	20054976	2025-04-13T22:05:20.000Z	0x2adae6302dc72961d6347701d49064f107ced8052cd004ce56edfffea2567a9b
0	0x2da25e7446a70d7be65fd4c053948becaa6374c8	0x1d57b8f22c1f9a5831b443077a6fe043a5ac2ffb	false	9	20054976	2025-04-13T22:05:20.000Z	0x2adae6302dc72961d6347701d49064f107ced8052cd004ce56edfffea2567a9b
20000	0x2da25e7446a70d7be65fd4c053948becaa6374c8	0x1d57b8f22c1f9a5831b443077a6fe043a5ac2ffb	false	17	20055057	2025-04-13T22:05:46.000Z	0x6e7488581ed534cae565a3dc3d91de0d7f1845dd602223a7d4f16239efbec75d

Example Query

Query with partition filter

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

PairFactory_SetPairFeeSplit_event

Fee split configuration events from ShadowExchange V2 DEX on Sonic chain, recording when trading pair fee distributions are set or updated. Tracks fee split values (in basis points, 10000 = 100%) assigned to specific liquidity pool pairs for protocol revenue 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_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in__feeSplit`	`STRING`	Fee split ratio expressed in basis points. Integer string representing the percentage allocation multiplied by precision factor.

Sample Data

address	in_pair	removed	log_index	block_number	in__feeSplit	block_timestamp	transaction_hash
0x2da25e7446a70d7be65fd4c053948becaa6374c8	0xb901d7316447c84f4417b8a8268e2822095051e6	false	2	8191914	10000	2025-02-16T23:57:51.000Z	0xa54506dad91730c2bc594297a7f0f87c523182c9e62b33e6dcf88460ce4f90bb
0x2da25e7446a70d7be65fd4c053948becaa6374c8	0x287c6882de298665977787e268f3dba052a6e251	false	0	8191636	10000	2025-02-16T23:54:28.000Z	0x619dfd218a7dd1e8e0ec2f061a8f0f0d7d613bbe17ef05ef70664d92af7be7cb
0x2da25e7446a70d7be65fd4c053948becaa6374c8	0x382e360d672ec27d9225c3d2c439993316f95623	false	223	21874036	10000	2025-04-24T00:02:26.000Z	0x19b6b7625401fac17e65ba21d397cff898a1fd6b414e7dbaf750caf5a5af812f

Example Query

Query with partition filter

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

VoteModule_ClaimRewards_event

Reward claim events from Shadow Exchange V2’s voting module on Sonic blockchain, recording when users claim voting incentives with claim amounts and recipient addresses. Used for analyzing voter participation patterns and reward distribution 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_from`	`STRING`	Address originating the transfer or 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.

Sample Data

address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xdcb5a24ec708cc13cee12bfe6799a78a79b666b4	0xc929cc467b1d1d3cd190d5253f2c8b0ef799d196	false	14186451648949323642	5	7376504	2025-02-11T08:32:22.000Z	0x976f4eec1d6df2c70d9dc0b086ed7d4936d63876226adf9303a85bcf411492aa
0xdcb5a24ec708cc13cee12bfe6799a78a79b666b4	0xc78e8ea590c6c75c346fe8c7b1ef302cffb9af0a	false	529882197437931739	5	7417046	2025-02-11T15:35:23.000Z	0x996966cc2ccf60e4b19e12f32bacd731366672d8d7af9805bcc74d7f499f7f89
0xdcb5a24ec708cc13cee12bfe6799a78a79b666b4	0x420d40297fee474b13f402aa86d76d6783b68420	false	1476389249078025417	5	7418916	2025-02-11T15:58:41.000Z	0xbebf8fbe9ee458586bfa68774b33a38fea79c8519fb777063d7651e1f9f852b7

Example Query

Query with partition filter

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

VoteModule_Deposit_event

Deposit events from Shadow Exchange v2’s voting module on Sonic, recording user staking deposits into the governance contract. Tracks depositor addresses and token amounts for analyzing voting power distribution and participation trends.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xdcb5a24ec708cc13cee12bfe6799a78a79b666b4	0xa62ae6615246cbf96536e50115137bb2ebe8fbc1	false	169854072029451157	1	14289217	2025-03-17T18:12:58.000Z	0x6c1480947531e9f59bcebe42f0da2ecd3ac20f76d21bc10aff3035bf464486e1
0xdcb5a24ec708cc13cee12bfe6799a78a79b666b4	0x2dfe90f531d48a3852613530c797aa7a9f6d6c08	false	203046818648681627	1	14169913	2025-03-17T02:47:53.000Z	0xbb85c8b0a93a887f4f5c957b6107b10bf35ef162ceebf7a5ed45ec3a3be8d6c9
0xdcb5a24ec708cc13cee12bfe6799a78a79b666b4	0xbecc9e2fb7ffa9fd78206e1bf551c2c0b124347c	false	141116721507372809	1	14299203	2025-03-17T19:22:08.000Z	0xc4f853f45558765b4997eaef703445dc468f1f7148ebef00bfd532f51bf06dc3

Example Query

Query with partition filter

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

VoteModule_NotifyReward_event

Reward notification events from ShadowExchange V2 VoteModule on Sonic, recording token reward distributions to voting participants. Contains reward amounts and sender addresses for analyzing voting incentive programs and governance participation rewards.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xdcb5a24ec708cc13cee12bfe6799a78a79b666b4	0x5050bc082ff4a74fb6b0b04385defddb114b2424	false	19395446561108880563888	28	20644026	2025-04-17T00:04:17.000Z	0xff6f6a8457ac9befb6936d46701f31bd395e972dad9cb51879f11c4fe8b77ea2
0xdcb5a24ec708cc13cee12bfe6799a78a79b666b4	0x5050bc082ff4a74fb6b0b04385defddb114b2424	false	4444407045455617966633	6	11936486	2025-03-06T00:09:39.000Z	0x846fbd671d8804102674d5fd286d430fd96465da8e190a605142af5caa7e9613
0xdcb5a24ec708cc13cee12bfe6799a78a79b666b4	0x5050bc082ff4a74fb6b0b04385defddb114b2424	false	34993596908822179459173	6	8764831	2025-02-20T00:03:02.000Z	0x03078733337d11cc132f684cd2800293e7e9eef820efac245999e015a24c292c

Example Query

Query with partition filter

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

VoteModule_Withdraw_event

Vote withdrawal events from ShadowExchange v2 governance module on Sonic chain, recording when users unstake their voting tokens. Contains withdrawal amounts and account addresses for tracking governance participation and token unlocking 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_from`	`STRING`	Address originating the transfer or 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.

Sample Data

address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xdcb5a24ec708cc13cee12bfe6799a78a79b666b4	0x430cec520b8d3872ace28036d2f0b88b85bd2fcc	false	1826090569895622444	1	7444255	2025-02-11T20:22:53.000Z	0x91b82de461ca964f82818f240671c5293de8a9e8762e2a425b485be2ef143007
0xdcb5a24ec708cc13cee12bfe6799a78a79b666b4	0xc929cc467b1d1d3cd190d5253f2c8b0ef799d196	false	161256260269222057130	1	7376599	2025-02-11T08:33:42.000Z	0xe30491ce0d08c706c031b6a45f4b83380b9297ba7584103152d9cb27e550fe84
0xdcb5a24ec708cc13cee12bfe6799a78a79b666b4	0x2fe9811e6b3cceb5c14cca6523f10ffdf4288af6	false	51209154204384744204	1	7366251	2025-02-11T06:25:35.000Z	0xa2e4003f88dc0bf649e81525d5c373c43684612f120ba8a32f8fc6875b0b5d24

Example Query

Query with partition filter

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

x33_ClaimedIncentives_event

Incentive claim events from ShadowExchange V2 on Sonic, recording when users collect trading rewards or fee distributions from the protocol’s fee distributor contracts. Useful for analyzing reward distribution patterns and liquidity provider earnings.

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_feeDistributors`	`ARRAY<STRING>`	Array of fee distributor contract addresses from which incentives were claimed. Hex-encoded, 0x-prefixed, 42-character strings.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

address	removed	in_tokens	log_index	block_number	block_timestamp	transaction_hash	in_feeDistributors
0x3333111a391cc08fa51353e9195526a70b333333	false	[]	211	8782949	2025-02-20T02:05:37.000Z	0x0b29bcfcf97ece2d6f2e3d542985ca9a55c6ebe17b54ad437580c64265f5c22c	[]
0x3333111a391cc08fa51353e9195526a70b333333	false	[]	155	7629706	2025-02-13T02:07:00.000Z	0x4cef885bdf3d507a2fed91bbd2b1be6eb7e7004e21ccfc86858ffc3832d1a7b6	[]
0x3333111a391cc08fa51353e9195526a70b333333	false	[]	98	5862571	2025-01-30T05:52:16.000Z	0xd2b4b521ea633d573adc189f5e27fea1b15c920b8af5c35837a374aeddbb445e	[]

Example Query

Query with partition filter

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

x33_Compounded_event

Compounding events from Shadow Exchange V2 on Sonic, tracking reward reinvestments with amounts and exchange ratio updates. Records the old and new ratio values for analyzing yield compounding frequency and protocol share price changes 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_oldRatio`	`STRING`	Previous ratio value before the state change. Numeric string representation in wei (18 decimal places).
`in_newRatio`	`STRING`	Updated ratio value after the state change. Numeric string representation in wei (18 decimal places).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_newRatio	in_oldRatio	block_number	block_timestamp	transaction_hash
0x3333111a391cc08fa51353e9195526a70b333333	false	3513402138335847547218	111	1124361743247336734	1108631975411010933	5867753	2025-01-30T07:04:51.000Z	0x56c8895404e6a64c263edb1c25d448a34b285f6dbec44b2f93677a9555fcef41
0x3333111a391cc08fa51353e9195526a70b333333	false	7280474534256156848169	29	1314485313466875586	1294359587175215988	12055272	2025-03-06T13:25:43.000Z	0xa0708a95cba45a9e2b9ed54b9e68394f018a0a8e3542aa37e267c2b6d55cd1b0
0x3333111a391cc08fa51353e9195526a70b333333	false	973609833224783067070	112	1294359587175215988	1291708764511911416	11962678	2025-03-06T03:00:01.000Z	0x4c69f006a167aa60726bcba9e0c724bbee365b42ffeac2ba2e58ea8b8063a7b3

Example Query

Query with partition filter

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

x33_Deposit_event

Deposit events from ShadowExchange V2 vault on Sonic, tracking user deposits with asset amounts, share allocations, and owner addresses. Useful for analyzing vault inflows, share pricing dynamics, and depositor behavior 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x3333111a391cc08fa51353e9195526a70b333333	false	0x04ccb4b8369cd4fd016ad3d638c5af1216ba9af3	2414196444739214938	0x9710e10a8f6fba8c391606fee18614885684548d	1739000686660744770	11	18651079	2025-04-07T05:21:51.000Z	0x63abdfd6843e807d211746c188b2dc08a6af22b94e75822bda4049201393ba67
0x3333111a391cc08fa51353e9195526a70b333333	false	0xdb1ab9e1aef1cb5fd7bafe1115869293cbbc583a	300843303192891498	0x9710e10a8f6fba8c391606fee18614885684548d	216704283518335718	11	18636449	2025-04-07T03:48:21.000Z	0x6840f873a05217112bc189fd9355945fa7b5d81ae74a3edddd996b27c24a66d9
0x3333111a391cc08fa51353e9195526a70b333333	false	0x11ec86d9ae83c4f513c87aa2153542faff1f31cc	4074054339584544937	0x9710e10a8f6fba8c391606fee18614885684548d	2934634134462914199	11	18618634	2025-04-07T01:46:56.000Z	0xfb48663ba1655b853c236d38edc393cf8d5ff481d1cde7bcb314fc59e5d684f9

Example Query

Query with partition filter

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

x33_Entered_event

No description available.

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_ratioAtDeposit`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

x33_Exited_event

No description available.

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__outAmount`	`STRING`	-
`in_ratioAtWithdrawal`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

x33_Rebased_event

Rebase events from the x33 token contract on Shadow Exchange v2 (Sonic), recording ratio adjustments that modify token balances across all holders. Tracks old and new rebase ratios with associated token amounts for analyzing rebasing token mechanics and holder value changes.

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_oldRatio`	`STRING`	Previous ratio value before the state change. Numeric string representation in wei (18 decimal places).
`in_newRatio`	`STRING`	Updated ratio value after the state change. Numeric string representation in wei (18 decimal places).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_newRatio	in_oldRatio	block_number	block_timestamp	transaction_hash
0x3333111a391cc08fa51353e9195526a70b333333	false	5896969249948180046864	19	1400147670067811230	1388266527585444028	19356815	2025-04-10T10:58:32.000Z	0x0d8f1c249d3c480eb915f4ca4d652c99d3b31220b4cb2d1ebc2f520854e5a1ee
0x3333111a391cc08fa51353e9195526a70b333333	false	7748472379196839191476	12	1534927426365759096	1518393745605442572	25259096	2025-05-08T13:35:38.000Z	0xfe460b90c0f0a42c3bd3c1a99e996eec83072360593dd76062519bcb894023a6
0x3333111a391cc08fa51353e9195526a70b333333	false	7295326997515297524395	129	1161772899742998431	1132839264921558504	7629843	2025-02-13T02:08:08.000Z	0x7d4a126db34dcda46429b039f2e2b37a9651a0c2cb9b7069e7570d846ff2393b

Example Query

Query with partition filter

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

x33_SwappedBribe_event

Bribe swap events from ShadowExchange V2 on Sonic chain, recording token exchanges where operators convert bribe tokens with input/output amounts. Used for tracking vote incentive flows and gauge reward distribution mechanics.

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_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenIn`	`STRING`	Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.

Sample Data

address	removed	log_index	in_tokenIn	in_operator	block_number	block_timestamp	transaction_hash
0x3333111a391cc08fa51353e9195526a70b333333	false	204	0x9710e10a8f6fba8c391606fee18614885684548d	0x9710e10a8f6fba8c391606fee18614885684548d	23393277	2025-04-30T23:50:55.000Z	0x49dc8348928e2da33bfa7d8cf20e497cc8f22470ae6254cad7bd4ae6f562370b
0x3333111a391cc08fa51353e9195526a70b333333	false	204	0x9710e10a8f6fba8c391606fee18614885684548d	0x9710e10a8f6fba8c391606fee18614885684548d	23392528	2025-04-30T23:45:07.000Z	0xa13ae8536c8bed17ef85f154dc814d5f5ff7e35aec19b7c85a154352720cae26
0x3333111a391cc08fa51353e9195526a70b333333	false	206	0x9710e10a8f6fba8c391606fee18614885684548d	0x9710e10a8f6fba8c391606fee18614885684548d	23392575	2025-04-30T23:45:27.000Z	0x4d9fd10029a748949503dd4870361dbda3bef13146a569430cdc469802938748

Example Query

Query with partition filter

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

x33_Unlocked_event

Token unlock events from Shadow Exchange v2 protocol on Sonic chain. Tracks when locked positions or vesting schedules release tokens at the contract address 0x3333…3333.

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__ts`	`STRING`	Timestamp when the data was ingested into the system. Unix epoch time in seconds, stored as a string.

Sample Data

in__ts	address	removed	log_index	block_number	block_timestamp	transaction_hash
1741875008	0x3333111a391cc08fa51353e9195526a70b333333	false	7	13466772	2025-03-13T14:10:08.000Z	0x3a242bcaba9d1f6fe017ae154ee1f88a64df845cea0b1d61f884448cbcea7b43
1739451229	0x3333111a391cc08fa51353e9195526a70b333333	false	1	7699619	2025-02-13T12:53:49.000Z	0x549137d8ddadac7772a5325074ee18dd5c95ccccbae24448cf31120871e12a86
1745504205	0x3333111a391cc08fa51353e9195526a70b333333	false	56	22009454	2025-04-24T14:16:45.000Z	0x8b2ceac9169123f337ce4d0ced53e78053deb81633879fa39b957aac5a6f5d22

Example Query

Query with partition filter

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

x33_UpdatedIndex_event

No description available.

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__index`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

x33_Withdraw_event

Withdrawal events from Shadow Exchange V2 vault on Sonic, recording when users redeem shares for underlying assets with conversion rates. Useful for analyzing liquidity provider exits and vault share-to-asset redemption ratios.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x3333111a391cc08fa51353e9195526a70b333333	false	0x2fed1fdddec37917482cd66a846227ff7d53ccf3	22656785298431170091	0x2fed1fdddec37917482cd66a846227ff7d53ccf3	20000000000000000000	113	0x2fed1fdddec37917482cd66a846227ff7d53ccf3	7474227	2025-02-12T02:17:05.000Z	0xcda83dc0294ccb439dda2bac9de49fdf4f1a98e32460277ce403544a54dfe46b
0x3333111a391cc08fa51353e9195526a70b333333	false	0x532ac6fa94797eb90745f4b140d05be1a9efee15	6916454005605337823	0x532ac6fa94797eb90745f4b140d05be1a9efee15	6105415145620200336	113	0x532ac6fa94797eb90745f4b140d05be1a9efee15	7471443	2025-02-12T01:51:54.000Z	0xe5bb59a94925029c25496e8d5cea95eaf073c1c2d5c7e80bda5fda34baa7512c
0x3333111a391cc08fa51353e9195526a70b333333	false	0x7f0fbb54d3961a59040d3fcba3b6e9959f0e3fff	29395947775460048861	0x7f0fbb54d3961a59040d3fcba3b6e9959f0e3fff	25948913218059686886	113	0x7f0fbb54d3961a59040d3fcba3b6e9959f0e3fff	7468774	2025-02-12T01:23:21.000Z	0x73fa8fcbfe6ae9b9308f09b93c1ff0b6b89f0d6ee0450476b9beb05f8353b5a0

Example Query

Query with partition filter

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

xShadow_CancelVesting_event

Vesting cancellation events from the xShadow token contract on Shadow Exchange V2 (Sonic chain), recording when users exit their token vesting schedules with the cancelled amount and vesting ID. Used for tracking early withdrawals from staking/governance token vesting positions.

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_vestId`	`STRING`	Unique identifier for the vesting position being cancelled in the xShadow contract. Value is typically ‘0’ in the sample data, representing the first or only vesting position for each user.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0xf27af189ff92e98cf1c8d13ead891b629ece36cd	false	680398647018472842	11	15330922	2025-03-23T00:57:22.000Z	0xc4e3d94d8219b31095c9124078e489e2ae68bce248640026dfff52eb0ffcfeec
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x47c0442c9d2b418c53d86010b67f40be5c59e60f	false	8073477106255444509	1	15478182	2025-03-23T18:21:54.000Z	0xd34c40d1e61820aa3abe13486ccf9fd8c61f6922082036d59b8e752648ba558f
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x4ab443cfa06a964e1b8f08c1bbf53f2dd584d0a7	false	12023075461374335697	1	15420077	2025-03-23T12:16:41.000Z	0xf55105a6f039b1d2f07a2a400b663f90a6884f0c6af190ed3d33f77ac4f39fea

Example Query

Query with partition filter

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

xShadow_Converted_event

xShadow token conversion events from ShadowExchange v2 on Sonic, tracking when users convert between xShadow (staked) and Shadow tokens. Records user addresses and conversion amounts for analyzing staking behavior and token flow.

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_anon1`	`STRING`	Token amount involved in the protocol operation. Numeric string representation in wei (smallest unit), with 18 decimal places of precision.

Sample Data

address	in_user	removed	in_anon1	log_index	block_number	block_timestamp	transaction_hash
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x9d94b60f5da3bfc9510a9702037bceec0ca02403	false	1447256231327695588	2	20618915	2025-04-16T20:27:28.000Z	0x518f8ec874ad7b6f6268d9a21e4fc60513481b2a9b4d9a8e6b429a2aaa2a45cc
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x6be841690a241f2a262bffb1ca843f3124bbc83f	false	1728623833350939657	2	20641217	2025-04-16T23:40:22.000Z	0x32ca232b24f112dc6bd771051eba7a4cd5866c8735e9717216a9e4064036c687
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0xc0aacf585c11507f7db33632051bda9081909aaa	false	26984249582606120149	2	20636576	2025-04-16T22:58:42.000Z	0x0563091eb1d57e5b63c0260e60ab01264ab99d80900ea9bf9ecf6f4918c9dc93

Example Query

Query with partition filter

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

xShadow_Exemption_event

Exemption status change events for candidates in the xShadow staking system on Shadow Exchange V2 (Sonic chain). Tracks addresses granted or revoked exemptions from staking requirements or penalties.

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_candidate`	`STRING`	Address of the candidate being granted or revoked exemption status in the xShadow contract. Hex-encoded, 0x-prefixed 40-character Sonic chain address.
`in_status`	`BOOL`	Status code representing the state of the entity or operation. Integer value with meaning specific to the contract context.
`in_success`	`BOOL`	Boolean flag indicating whether the operation completed successfully.

Sample Data

address	removed	in_status	log_index	in_success	block_number	in_candidate	block_timestamp	transaction_hash
0x5050bc082ff4a74fb6b0b04385defddb114b2424	false	false	17	true	19992571	0x9710e10a8f6fba8c391606fee18614885684548d	2025-04-13T14:55:55.000Z	0x0063ade6df42468a278e42cfae3e4190ee6c03ceae497a43aa84652dabb63c43
0x5050bc082ff4a74fb6b0b04385defddb114b2424	false	false	19	true	19992571	0x9710e10a8f6fba8c391606fee18614885684548d	2025-04-13T14:55:55.000Z	0x0063ade6df42468a278e42cfae3e4190ee6c03ceae497a43aa84652dabb63c43
0x5050bc082ff4a74fb6b0b04385defddb114b2424	false	false	16	true	19992571	0x3333111a391cc08fa51353e9195526a70b333333	2025-04-13T14:55:55.000Z	0x0063ade6df42468a278e42cfae3e4190ee6c03ceae497a43aa84652dabb63c43

Example Query

Query with partition filter

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

xShadow_ExitVesting_event

User exits from xShadow token vesting schedules on Shadow Exchange V2 (Sonic chain), recording withdrawn amounts and vesting position identifiers. Used for tracking unlock behavior and vesting schedule participation across user positions.

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_vestId`	`STRING`	Unique identifier for the specific vesting position being exited by the user. Numeric ID (0-indexed) representing an individual vest within the xShadow contract.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	in_vestId	log_index	block_number	block_timestamp	transaction_hash
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x5b1b5d7f419c8c26a6ed51b46db09ae6376a82da	false	1100000000000000000	2	1	8346101	2025-02-17T21:58:28.000Z	0xf0044bd032afad968110317054eb17f974377c14b6fdffe82bd8c62382162b9b
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x5b1b5d7f419c8c26a6ed51b46db09ae6376a82da	false	7000000000000000000	1	45	8345995	2025-02-17T21:57:44.000Z	0xf94ceb8dc90ec2fe290243d54a6f3f617819e07aa93ddef68acaeedad4bf1f7a
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0xab86389337d5d15fdc419195820cb97266d8ba63	false	1986557678046493178	4	1	8285622	2025-02-17T14:41:03.000Z	0xb48f9b25ecaa992918436bbba4bdcd78b78366eb7661ca5b19435990e59df9a5

Example Query

Query with partition filter

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

xShadow_InstantExit_event

Instant exit events from Shadow Exchange’s xShadow staking contract on Sonic, recording users who unstaked their xShadow tokens and the amounts withdrawn. Used for tracking xShadow liquidity flows and staking behavior 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_anon1`	`STRING`	Token amount involved in the protocol operation. Numeric string representation in wei (smallest unit), with 18 decimal places of precision.

Sample Data

address	in_user	removed	in_anon1	log_index	block_number	block_timestamp	transaction_hash
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x10ba44df917fbbc67f3b5e7fd6320707b66000a6	false	445655553076106766	2	21891116	2025-04-24T02:02:02.000Z	0xbbaf7e0ee13a45b2da4de38b19a1814789480562df20f732bbde90577540470c
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0xcd15aec547d01e24da7368d683872692354bf704	false	147663807361602630	2	22064609	2025-04-24T19:43:49.000Z	0x32f42d1e97f92331d63974ce092e8cb18fc9c48855ccbee2509585eccad8757f
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x6df6317d97d399be94f7e42173938f7595afb5ab	false	7744050862111706	2	21979215	2025-04-24T11:16:40.000Z	0xe87e956d159aa3d784d00634e54dc4296ffddb6c18448b1429eec58c9de1d442

Example Query

Query with partition filter

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

xShadow_NewSlashingPenalty_event

No description available.

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_penalty`	`STRING`	Penalty amount assessed in the operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

xShadow_NewVest_event

New vesting position creation events from Shadow Exchange’s xShadow staking contract on Sonic, tracking user addresses, vest IDs, and token amounts. Used for analyzing vesting schedules and lock-up behavior in the protocol’s tokenomics.

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_vestId`	`STRING`	Unique identifier for the vesting position created for the user within the xShadow contract. Numeric string that increments for each new vest, with ‘0’ being the most common first-time vest ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x3aeda42aed5519e5b5420563ec17b9c5e746be43	false	50803085607109214856	1	22036778	2025-04-24T16:56:41.000Z	0x0d34a079be3f38a6a6cc71713000a1006d9badb58435a2842cd98aa878e083cb
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x5cb28d05e19f88ff1a1bc4e1cc5bd787339372a0	false	67885861114853891	1	22038124	2025-04-24T17:05:33.000Z	0x86e22a0c384233e4e8924f71d5d46a709cef5d4b53bea792201652b5986242dd
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x7812d6b858ef1fdc6b9690b8095814b737cda24f	false	20045138732223434	1	21943681	2025-04-24T07:41:42.000Z	0x8c375807d264e4f6d889a8abe66a2c8f28e44bc85b78ef53e9e36ea91aeea937

Example Query

Query with partition filter

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

xShadow_Rebase_event

xShadow token rebase events from ShadowExchange V2 on Sonic, recording supply adjustments with the rebase amount and triggering caller address. Used for tracking xShadow (staked SHADOW) token supply changes and yield distribution mechanics.

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_caller`	`STRING`	Address that initiated or requested the contract function call. 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.

Sample Data

address	removed	in_amount	in_caller	log_index	block_number	block_timestamp	transaction_hash
0x5050bc082ff4a74fb6b0b04385defddb114b2424	false	105474340442172073708653	0xc7022f359cd1bda8ab8a19d1f19d769cbf7f3765	39	5054401	2025-01-23T00:00:54.000Z	0x3f4ee8e7a6c4b416d7983ad8337ebd17e84df365c46c50f9bce7d61e068da8db
0x5050bc082ff4a74fb6b0b04385defddb114b2424	false	22516480293864306764985	0xc7022f359cd1bda8ab8a19d1f19d769cbf7f3765	7	25119456	2025-05-08T00:00:11.000Z	0x879ba41527c3a746340a716b8afc964f1a11d72037ee62f5f0063ce964fbb61f
0x5050bc082ff4a74fb6b0b04385defddb114b2424	false	3286736466377145003602	0xc7022f359cd1bda8ab8a19d1f19d769cbf7f3765	7	14732317	2025-03-20T00:00:17.000Z	0x8bfe0033fd0d422d49e39d867b592f310680d0478bb8dc23f961453c0ef29fa7

Example Query

Query with partition filter

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

xShadow_XShadowRedeemed_event

xShadow token redemption events from ShadowExchange V2 on Sonic chain, capturing when users convert xShadow (staked SHADOW) back to SHADOW tokens with redemption amounts and user addresses.

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_anon1`	`STRING`	Token amount involved in the protocol operation. Numeric string representation in wei (smallest unit), with 18 decimal places of precision.

Sample Data

address	in_user	removed	in_anon1	log_index	block_number	block_timestamp	transaction_hash
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x5050bc082ff4a74fb6b0b04385defddb114b2424	false	10000000000000000000000	2	5843030	2025-01-30T01:05:58.000Z	0x0c87bd397ea6b21a3b08c73aa5fb484e0d3266b706e78b141c32e03f1370f0e4
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x5050bc082ff4a74fb6b0b04385defddb114b2424	false	6816471520821620059236	237	17850435	2025-04-03T06:57:50.000Z	0x4be0a2d89149d0c41a32a548cfb08d8049305530036fdad1b2a558d65158d60f
0x5050bc082ff4a74fb6b0b04385defddb114b2424	0x5050bc082ff4a74fb6b0b04385defddb114b2424	false	287632057121317280085	237	17852648	2025-04-03T07:11:58.000Z	0xa0f6e1df08097b7538577ab5549047f1cf226f1d3f5358ccbe547b4652031561

Example Query

Query with partition filter

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

​Tables

​Factory_PairCreated_event

​FeeDistributorFactory_createFeeDistributor_function

​Gauge_ClaimRewards_event

​Gauge_Deposit_event

​Gauge_NotifyReward_event

​Gauge_Withdraw_event

​GaugeFactory_createGauge_function

​GaugeFactory_GaugeCreated_event

​Pair_mintFee_function

​Pair_setFee_function

​Pair_setFeeRecipient_function

​Pair_setFeeSplit_function

​Pair_Swap_event

​Pair_Sync_event

​PairFactory_FeeSplitWhenNoGauge_event

​PairFactory_NewTreasury_event

​PairFactory_SetFee_event

​PairFactory_SetFeeRecipient_event

​PairFactory_SetFeeSplit_event

​PairFactory_SetPairFee_event

​PairFactory_SetPairFeeSplit_event

​VoteModule_ClaimRewards_event

​VoteModule_Deposit_event

​VoteModule_NotifyReward_event

​VoteModule_Withdraw_event

​x33_ClaimedIncentives_event

​x33_Compounded_event

​x33_Deposit_event

​x33_Entered_event

​x33_Exited_event

​x33_Rebased_event

​x33_SwappedBribe_event

​x33_Unlocked_event

​x33_UpdatedIndex_event

​x33_Withdraw_event

​xShadow_CancelVesting_event

​xShadow_Converted_event

​xShadow_Exemption_event

​xShadow_ExitVesting_event

​xShadow_InstantExit_event

​xShadow_NewSlashingPenalty_event

​xShadow_NewVest_event

​xShadow_Rebase_event

​xShadow_XShadowRedeemed_event

Tables

Factory_PairCreated_event

FeeDistributorFactory_createFeeDistributor_function

Gauge_ClaimRewards_event

Gauge_Deposit_event

Gauge_NotifyReward_event

Gauge_Withdraw_event

GaugeFactory_createGauge_function

GaugeFactory_GaugeCreated_event

Pair_mintFee_function

Pair_setFee_function

Pair_setFeeRecipient_function

Pair_setFeeSplit_function

Pair_Swap_event

Pair_Sync_event

PairFactory_FeeSplitWhenNoGauge_event

PairFactory_NewTreasury_event

PairFactory_SetFee_event

PairFactory_SetFeeRecipient_event

PairFactory_SetFeeSplit_event

PairFactory_SetPairFee_event

PairFactory_SetPairFeeSplit_event

VoteModule_ClaimRewards_event

VoteModule_Deposit_event

VoteModule_NotifyReward_event

VoteModule_Withdraw_event

x33_ClaimedIncentives_event

x33_Compounded_event

x33_Deposit_event

x33_Entered_event

x33_Exited_event

x33_Rebased_event

x33_SwappedBribe_event

x33_Unlocked_event

x33_UpdatedIndex_event

x33_Withdraw_event

xShadow_CancelVesting_event

xShadow_Converted_event

xShadow_Exemption_event

xShadow_ExitVesting_event

xShadow_InstantExit_event

xShadow_NewSlashingPenalty_event

xShadow_NewVest_event

xShadow_Rebase_event

xShadow_XShadowRedeemed_event