Skip to main content

Tables

ClGaugeFactory_FeeCollectorChanged_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_newFeeCollectorSTRINGAddress of the new fee collector contract after a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.
in_oldFeeCollectorSTRINGAddress of the previous fee collector contract before a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.ClGaugeFactory_FeeCollectorChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ClGaugeFactory_GaugeCreated_event

Gauge creation events from Shadow Exchange V3 on Sonic blockchain, recording when new liquidity mining gauges are deployed for specific liquidity pools. Links gauge contracts to their associated pool addresses for tracking incentive distribution mechanisms.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_gaugeSTRINGContract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedin_gaugelog_indexblock_numberblock_timestamptransaction_hash
0x452f378db86f6ef98731cdeb8344d8c171b6968c0x5c8e4d65c68e4244511f33ecef5ee34f6de5d5bafalse0x6f2d5ebfc4ac5774e08b0250155fd519728587b723133189372025-03-12T20:42:31.000Z0x3c6e650a0cbf22c0269c09f4ad2857afdda55eadb29bc144d02bdbd113f14ae3
0xf914cc768040b4268a779c3084a3e9cda6e8a1a80x66a8289bdd968d1157eb1a608f60a87759632cd6false0xedb2c989940c8fdc5d469b2adb88e651c3ac30eb677391482025-02-13T18:18:38.000Z0xb0a3d7ffb2a556a390a199dba3f5f816c8f845a6916d5907e80eddc0acdcb269
0xf914cc768040b4268a779c3084a3e9cda6e8a1a80x1f50e4f90c02411a07474b3209182b1e0162ad1afalse0x7cb49f27c012cc5e59ede661feb473d0587d659a895880872025-02-23T14:53:47.000Z0x78da08be9efe25a7d04dc6425b2eec9a8d454bebbbf455aebac52158bba3b29f
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.ClGaugeFactory_GaugeCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ClGaugeFactory_VoterChanged_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_newVoterSTRING-
in_oldVoterSTRING-
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.ClGaugeFactory_VoterChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_token0STRINGContract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_token1STRINGContract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_feeSTRINGFee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
in_tickSpacingINT64Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_feeaddressin_poolremovedin_token0in_token1log_indexblock_numberin_tickSpacingblock_timestamptransaction_hash
100000xcd2d0637c94fe77c2896bbcbb174ceffb08de6d70x77facbfd6dc7e6ae4592954d13efeae2dcc0373ffalse0x4451765739b2d7bce5f8bc95beaf966c45e1dcc90xb098afc30fce67f1926e735db6fdadfe433e61db0367922561002025-07-02T03:01:09.000Z0xbb71781b67077cdd6d5557501159d57cb1bd946757b2ff8da4e563e9c7c0373b
5000xcd2d0637c94fe77c2896bbcbb174ceffb08de6d70xd0c6623047c5c3f749ce888b3d7569eaf4cf344cfalse0x674a430f531847a6f8976a900f8ace765f896a1b0x6f330fee89ad64cae005f85764e7f7dd3f660b2b036914169102025-07-02T23:10:52.000Z0xc2409601c9f3c33681a8ed592146530a0f67ad22919f18ec389ef79620020346
1000xcd2d0637c94fe77c2896bbcbb174ceffb08de6d70x9c4c4bb8b62ebc2f5af9c01909678b1d225286f0false0x29219dd400f2bf60e5a23d13be72b486d40388940x3333111a391cc08fa51353e9195526a70b33333314863405712025-02-19T10:58:41.000Z0x3b010ed3177c13f2c5d8148cee7e00a9acb7c6f7c7fd1c0280a76601af090e15
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Factory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FeeDistributor_ClaimRewards_event

Reward claim events from Shadow Exchange v3 fee distributor contracts on Sonic, recording token rewards distributed to liquidity providers and stakers by period. Tracks claimed amounts, reward token addresses, and beneficiary accounts for analyzing protocol revenue distribution and user reward harvesting patterns.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_periodSTRINGNumeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountin_periodin_rewardlog_indexin_receiverblock_numberblock_timestamptransaction_hash
0xb3a14f50cd726c31bd513382a9c0e991cefbfe0efalse0x0321c819b5f949e4535215ba33062c0a0c5cb6ff35384375170269829010x50c42deacd8fc9773493ed674b675be577f2634b30x0321c819b5f949e4535215ba33062c0a0c5cb6ff428704372025-08-13T21:39:37.000Z0x2cd5aaf319f90238bf347951977ff8cb8b818a7b8e508230d092c8efb5237f7e
0xb3a14f50cd726c31bd513382a9c0e991cefbfe0efalse0x0321c819b5f949e4535215ba33062c0a0c5cb6ff448549575710973841329010x039e2fb66102314ce7b64ce5ce3e5183bc94ad3810x0321c819b5f949e4535215ba33062c0a0c5cb6ff428704372025-08-13T21:39:37.000Z0x2cd5aaf319f90238bf347951977ff8cb8b818a7b8e508230d092c8efb5237f7e
0x160393c0683743eb6473694cf71b52dd24a17d28false0x04ad5ef15ddb276e180ff4598cd8c8e736c9f0b5361428129010x29219dd400f2bf60e5a23d13be72b486d4038894130x04ad5ef15ddb276e180ff4598cd8c8e736c9f0b5428608332025-08-13T20:18:33.000Z0x794bd450f053c93cba79b8742f296698fb3eb5b134cc77ce7cf5c5d4928523c6
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.FeeDistributor_ClaimRewards_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FeeDistributor_Deposit_event

Fee deposit events from Shadow Exchange V3 on Sonic blockchain capturing when users deposit tokens into the protocol’s fee distribution contract. Used for tracking fee collection addresses, deposit amounts, and participant activity in the exchange’s revenue sharing mechanism.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountlog_indexblock_numberblock_timestamptransaction_hash
0x160393c0683743eb6473694cf71b52dd24a17d28false0x000755294934bf654461241d530ff4fdc69f943216456341403704905192328626702025-06-09T09:28:51.000Z0x81143f0b89a6719fb25eb267a854798c8efc8ca7ec78087556c7fc63cbf50ed5
0x35f08d8be8e908ba587d369c7e1f5d61ba4ce293false0x000755294934bf654461241d530ff4fdc69f943216456341403704905199328626112025-06-09T09:28:31.000Z0x91b9a4bfd0ac20c8b100abba749fcaadec0602846c3a284a74be2193e8bb732e
0x35f08d8be8e908ba587d369c7e1f5d61ba4ce293false0x00d69eaf25a939a2e8db6238c9ea055ca963357111353593437791354844329545072025-06-09T18:45:58.000Z0x8579c2f3730e08c6970edfd8bf5e06aaabbd53953cc05e39f96ce85b106abda7
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.FeeDistributor_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FeeDistributor_NotifyReward_event

Reward distribution notifications from the Shadow Exchange v3 FeeDistributor contract on Sonic, tracking token rewards allocated to stakers per epoch period. Used for analyzing reward distribution patterns and protocol revenue sharing across different reward tokens.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_periodSTRINGNumeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
addressin_fromremovedin_amountin_periodin_rewardlog_indexblock_numberblock_timestamptransaction_hash
0xeb0b8821bd5e44dc402b0523825776b36abb9cb10x1776bc72c591686bf85fdadeb6909cf59941646afalse416350476565528840xc00021495419f35ad564e289b5077f48d1399b2d362186341722025-04-07T03:35:16.000Z0x04500b1c3cec3912e51465a091a61e2a541b75f2b2926f50288a34b7b02bf5ea
0xeb0b8821bd5e44dc402b0523825776b36abb9cb10x1776bc72c591686bf85fdadeb6909cf59941646afalse1690885332228840xc00021495419f35ad564e289b5077f48d1399b2d146187707342025-04-07T17:10:19.000Z0x0698da65ed58fa66695ba77314e1dbee4192fd9f666290f1720fbbfab35317ce
0xeb0b8821bd5e44dc402b0523825776b36abb9cb10x1776bc72c591686bf85fdadeb6909cf59941646afalse115244177109628840xc00021495419f35ad564e289b5077f48d1399b2d267186916782025-04-07T09:20:18.000Z0x139ea572629ca7806a12e8d5163a94315eb7ec0e116a17d4813f8ed7530f9171
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.FeeDistributor_NotifyReward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FeeDistributor_RewardsRedirected_event

Reward token redirect events from Shadow Exchange V3’s FeeDistributor contract on Sonic, recording when users redirect their protocol fee rewards to different destination addresses. Tracks reward token addresses, amounts in wei, and recipient addresses for analyzing reward claim patterns and delegation strategies.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_destinationSTRINGTarget address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in__rewardSTRINGAmount of reward tokens paid to the liquidator or recipient. String-encoded integer representing token quantity in smallest unit.
in__amountSTRINGAmount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
addressremovedlog_indexin__amountin__rewardblock_numberin_destinationblock_timestamptransaction_hash
0x8bc5103fc796ab962e61a32af6a5167b361e7ae6false969837336814749639042454890xf26ff70573ddc8a90bd7865af8d7d70b8ff019bc147010350x565f818fde36a487f894aea816138a45e2a55c052025-03-19T20:30:44.000Z0xad373afe085f78854a01fc927e4b066039f9e8e5c32c1a6535cdf2e53a6f4685
0x8bc5103fc796ab962e61a32af6a5167b361e7ae6false13578184443443415260033730x039e2fb66102314ce7b64ce5ce3e5183bc94ad38147010350x565f818fde36a487f894aea816138a45e2a55c052025-03-19T20:30:44.000Z0xad373afe085f78854a01fc927e4b066039f9e8e5c32c1a6535cdf2e53a6f4685
0x8bc5103fc796ab962e61a32af6a5167b361e7ae6false11568384508035621111900x3333b97138d4b086720b5ae8a7844b1345a33333147010350x565f818fde36a487f894aea816138a45e2a55c052025-03-19T20:30:44.000Z0xad373afe085f78854a01fc927e4b066039f9e8e5c32c1a6535cdf2e53a6f4685
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.FeeDistributor_RewardsRedirected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FeeDistributor_RewardsRemoved_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__rewardSTRINGAmount of reward tokens paid to the liquidator or recipient. String-encoded integer representing token quantity in smallest unit.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.FeeDistributor_RewardsRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FeeDistributor_VotesIncentivized_event

Vote incentive deposits on ShadowExchange V3 DEX (decentralized exchange) on Sonic, tracking reward token amounts offered by addresses to incentivize governance votes for specific liquidity pools during voting periods. Used for analyzing bribe markets and vote-escrow tokenomics in liquidity mining programs.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_periodSTRINGNumeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
addressin_fromremovedin_amountin_periodin_rewardlog_indexblock_numberblock_timestamptransaction_hash
0x7a9f9b72392f5b521bbe555add73b57d40651fbf0x6cde3e2a3f66c916d26d3f3a2ee2e389e903b2b1false250000000000000000000028810x31e2eed04a62b232da964a097d8c171584e3c3bd6137171092025-03-14T17:48:47.000Z0xdec20ae69fbd167d4fe1c55f935f6e576c72d7b38be46e0cd2041034123ebee0
0x2ad4f83d1fab1ee46234978ca7f3af2e7e1ed0f60xd189c72ffe430b3557549c8c794cbf818b3d6005false1801722874051137028810x3333b97138d4b086720b5ae8a7844b1345a333331137358982025-03-14T19:46:10.000Z0xbc21ad72ef2fa1cc857f2fb852dbe06784fe39d2780f584b19563e2e4fcc3c6d
0x160393c0683743eb6473694cf71b52dd24a17d280x3902c4d90ab9421d0e634c907514ac3f958faafdfalse8621100150369838728810x3333b97138d4b086720b5ae8a7844b1345a333331135708852025-03-14T01:12:30.000Z0xd05efc3957a2977d9f5bf568956d1f17449b754b5363a1e896ccfbd024563e97
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.FeeDistributor_VotesIncentivized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FeeDistributor_Withdraw_event

Fee withdrawal events from Shadow Exchange V3 FeeDistributor contracts on Sonic, capturing when users claim accumulated trading fees with owner addresses and withdrawal amounts. Used for tracking fee distribution patterns and liquidity provider earnings across different fee distributor contracts.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountlog_indexblock_numberblock_timestamptransaction_hash
0x160393c0683743eb6473694cf71b52dd24a17d28false0x02039619366b8cb7a18d0a455074b5a9157c7c3f96407867273047511211383721512025-07-13T21:42:09.000Z0x4630175270ca66098941f2f29cfaf709464ec4c19a58f2bd46a344006809aaf7
0xb3a14f50cd726c31bd513382a9c0e991cefbfe0efalse0x051a3190c9342211eb311723b23b8c7cbd7b5a5d4939316269602131521382989022025-07-13T08:57:25.000Z0x44ddcc0c1cf5b02b78c9ac95fad18c3ab2d0e730e7606948d856f2c5c280821d
0xb3a14f50cd726c31bd513382a9c0e991cefbfe0efalse0x063714dd924e5db3e4c6f79a07e28c58797f8c4544306437704876668831382639852025-07-13T01:48:23.000Z0x26df95496ee48a3f7c64451dac90d2aee19f052d83bf93bc9651fc62c36258a5
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.FeeDistributor_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GaugeV3_Bribe_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_periodSTRINGNumeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.GaugeV3_Bribe_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GaugeV3_ClaimRewards_event

Reward claim events from Shadow Exchange v3 liquidity gauge contracts on Sonic, recording token reward distributions to staking position holders by period. Useful for analyzing yield farming rewards, incentive program effectiveness, and liquidity provider earnings across different reward periods and tokens.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_periodSTRINGNumeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
in__positionHashSTRINGUnique identifier hash for a specific liquidity position in the Shadow Exchange gauge. Hex-encoded, 0x-prefixed 64-character string that remains constant across multiple reward claims for the same position.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_amountin_periodin_rewardlog_indexin_receiverblock_numberblock_timestampin__positionHashtransaction_hash
0x06308c747cf7b5b5bb3b9494b2314c166f0b7fa5false132159247977241628940x5050bc082ff4a74fb6b0b04385defddb114b242450x06fded36509dfd28ecec6c91560ce915ab868242381505022025-07-12T04:59:40.000Z0xd37048ef7182b0a68554fb28500ee2dd97db5113b80283e1c60519d44bd757060xa604d579a3ddcf77c57e4de7357b96813468d20c55605c80b15e8018bc14ba4a
0x06308c747cf7b5b5bb3b9494b2314c166f0b7fa5false22148633938136228920x5050bc082ff4a74fb6b0b04385defddb114b242410x06fded36509dfd28ecec6c91560ce915ab868242381505022025-07-12T04:59:40.000Z0xd37048ef7182b0a68554fb28500ee2dd97db5113b80283e1c60519d44bd757060xa604d579a3ddcf77c57e4de7357b96813468d20c55605c80b15e8018bc14ba4a
0x06308c747cf7b5b5bb3b9494b2314c166f0b7fa5false24658022928900x5050bc082ff4a74fb6b0b04385defddb114b2424130x06fded36509dfd28ecec6c91560ce915ab868242381505022025-07-12T04:59:40.000Z0xcd005e572ab7d091bfeb3e6467a6771ab6dc52f830055576f3d073d686acfcd30xa604d579a3ddcf77c57e4de7357b96813468d20c55605c80b15e8018bc14ba4a
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.GaugeV3_ClaimRewards_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GaugeV3_NotifyReward_event

Reward distribution events from Shadow Exchange V3 liquidity gauges on Sonic, recording when rewards are allocated to specific gauges for distribution to liquidity providers. Tracks reward token addresses, amounts, distribution periods, and source addresses for analyzing incentive programs and yield farming opportunities.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_periodSTRINGNumeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
addressin_fromremovedin_amountin_periodin_rewardlog_indexblock_numberblock_timestamptransaction_hash
0xa5f6fec46f3be8f0f640ba1450f922cbb951fe1e0x78d5d1bc82228b2b1b54aa620949b7172f5ed5edfalse159029464792945401862629010x039e2fb66102314ce7b64ce5ce3e5183bc94ad3831423863432025-08-10T13:30:07.000Z0x8ceb31eceebf25b6695d7c9ef9bf7def641465dbc22529e4994ccd4d21dfab6a
0x1cf16d22409bff9a133cf4c346ae4f9afd4e03800x5e7a9eea6988063a4dbb9ccddb3e04c923e8e37ffalse62646027748817842995228750x5050bc082ff4a74fb6b0b04385defddb114b242412967164112025-02-06T00:16:55.000Z0xafd144a6f3092ba1fc7cbfaa66bed63416b1e9e66f5eb7ec1b36172b417a6631
0x944bcd098177cf23ec92ea874e05c20c9e9a64740x5e7a9eea6988063a4dbb9ccddb3e04c923e8e37ffalse7763538300664119296028750x5050bc082ff4a74fb6b0b04385defddb114b242416367164112025-02-06T00:16:55.000Z0xafd144a6f3092ba1fc7cbfaa66bed63416b1e9e66f5eb7ec1b36172b417a6631
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.GaugeV3_NotifyReward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GaugeV3_RewardAdded_event

Reward token distribution events from ShadowExchange V3 liquidity gauges on Sonic, recording when incentive tokens are added to staking pools. Used to track reward program deployments and analyze gauge incentive structures across liquidity pairs.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_rewardlog_indexblock_numberblock_timestamptransaction_hash
0x89b45f5b830fb5bc42d037c1130933c86da27c58false0x6047828dc181963ba44974801ff68e538da5eaf9173612712025-02-11T05:26:21.000Z0xa12914669f9a7a6e33c593781b43e076928589783b8d0cadae275af31ee10c95
0x89b45f5b830fb5bc42d037c1130933c86da27c58false0x3333b97138d4b086720b5ae8a7844b1345a33333273612712025-02-11T05:26:21.000Z0xa12914669f9a7a6e33c593781b43e076928589783b8d0cadae275af31ee10c95
0x89b45f5b830fb5bc42d037c1130933c86da27c58false0x29219dd400f2bf60e5a23d13be72b486d4038894073612712025-02-11T05:26:21.000Z0xa12914669f9a7a6e33c593781b43e076928589783b8d0cadae275af31ee10c95
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.GaugeV3_RewardAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GaugeV3_RewardRemoved_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.GaugeV3_RewardRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Burn_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL changes.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
in_tickUpperINT64Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountlog_indexin_amount0in_amount1block_numberin_tickLowerin_tickUpperblock_timestamptransaction_hash
0xa1538e790ccdd639755602857f582a39ed7f650cfalse0x074505e455feae35bf46d8b8f445a8be6a96bc760310042734556-360900-3579002025-08-13T02:10:17.000Z0x990fe84a6b35b748129ba6bd35393117dc49039a3492e088e8a564c65628544c
0xa1538e790ccdd639755602857f582a39ed7f650cfalse0x12e66c8f215ddd5d48d150c8f46ad0c6fb0f44060660042800666-360600-3561502025-08-13T12:06:17.000Z0x0941939e1750dd3b5e90c1afa7923c343c32ada11cf07a7e08378a7057b9a685
0xa1538e790ccdd639755602857f582a39ed7f650cfalse0x12e66c8f215ddd5d48d150c8f46ad0c6fb0f44060320042722042-360600-3561502025-08-13T00:06:31.000Z0xe9d69174aa2a59f08ea671f867a54d4b23b47fb79f45b20e62b2178a9fb34a81
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Pool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Collect_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
in_tickUpperINT64Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerlog_indexin_amount0in_amount1block_numberin_recipientin_tickLowerin_tickUpperblock_timestamptransaction_hash
0x324963c267c354c7660ce8ca3f5f167e05649970false0x12e66c8f215ddd5d48d150c8f46ad0c6fb0f440633000330565120x006f318a9e71a6a27e4057803077b183b9f907cd-287950-2835002025-06-10T06:05:10.000Z0x33af87ab5eb1ee115311da19213ba0df170dfcb0a0900c21e54c02fd5ae5308f
0x324963c267c354c7660ce8ca3f5f167e05649970false0x12e66c8f215ddd5d48d150c8f46ad0c6fb0f440637500331444990x006f318a9e71a6a27e4057803077b183b9f907cd-287950-2835002025-06-10T15:05:44.000Z0xea156d7813c681eb229048e8483f7baa604f4667459fdc39e32b934e47d9922e
0x286cc998298d9d0242c9ad30cdb587e0b2f59f22false0x12e66c8f215ddd5d48d150c8f46ad0c6fb0f44066135079051234924331156295333026236845331883290x009d13e9bec94bf16791098ce4e5c168d27a9f07-5154852025-06-10T19:39:46.000Z0xd7c5d9d5710b15348507aebef5f6127aae9cc04d5b2dcdc7cde7b449dfe94f00
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Pool_Collect_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_CollectProtocol_event

Protocol fee collection events from concentrated liquidity pools, recording fees withdrawn by the protocol from trading activity. Contains token amounts collected (amount0, amount1), sender address initiating the collection, and recipient address receiving the fees.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_senderlog_indexin_amount0in_amount1block_numberin_recipientblock_timestamptransaction_hash
0x28f1bb2952ae8742b9e16fd515e3d01f4be6bc30false0x949e7b2f3f66eae761a9397346ddbd719f046c0e1934957737032727474680196832640x949e7b2f3f66eae761a9397346ddbd719f046c0e2025-04-12T00:05:18.000Z0x31091b53736a499a32ffbeac3d9146a527c68e1f9adc10d3b13854aa1c124549
0xc291ca0a0a0e793dc6a0442a34e1607ce1905389false0x949e7b2f3f66eae761a9397346ddbd719f046c0e2770107164338315196832640x949e7b2f3f66eae761a9397346ddbd719f046c0e2025-04-12T00:05:18.000Z0x31091b53736a499a32ffbeac3d9146a527c68e1f9adc10d3b13854aa1c124549
0x5c8e4d65c68e4244511f33ecef5ee34f6de5d5bafalse0x949e7b2f3f66eae761a9397346ddbd719f046c0e28826870524199690261331629996597904942807792196832640x949e7b2f3f66eae761a9397346ddbd719f046c0e2025-04-12T00:05:18.000Z0x31091b53736a499a32ffbeac3d9146a527c68e1f9adc10d3b13854aa1c124549
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Pool_CollectProtocol_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_collectProtocol_function

Protocol fee collection events from Shadow Exchange V3 liquidity pools on Sonic chain. Records token amounts withdrawn by the protocol from pools, with recipient addresses and requested versus actual collection amounts for analyzing protocol revenue.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0RequestedSTRINGMaximum amount of token0 protocol fees requested for collection, typically set to uint128 max value to collect all available fees.
in_amount1RequestedSTRINGMaximum amount of token1 that the caller requests to collect from the pool’s accumulated protocol fees. Often set to uint128 max (340282366920938463463374607431768211455) to collect all available token1 fees.
out_amount0STRINGAmount of token0 returned or withdrawn from the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination.
out_amount1STRINGAmount of token1 returned or withdrawn from the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination.
gasvaluestatusgas_usedsignatureto_addressout_amount0out_amount1block_numberfrom_addressin_recipienttrace_addressblock_timestamptransaction_hashin_amount0Requestedin_amount1Requested
7747010true460560x85b667290x29fb72eb4052771f2580bd555fd2e4f4a10d68bb481406506700650284720330648107391505228125485170x949e7b2f3f66eae761a9397346ddbd719f046c0e0x5be2e859d0c2453c9aa062860ca27711ff5534327,52025-03-09T00:00:10.000Z0xeb2726ba44b9f541675c3a267b038a7f2b8c4d7f101ccad9887df19f04cd867a340282366920938463463374607431768211455340282366920938463463374607431768211455
3287730true476780x85b667290x28f1bb2952ae8742b9e16fd515e3d01f4be6bc3005472876661017688456125491330x949e7b2f3f66eae761a9397346ddbd719f046c0e0x5be2e859d0c2453c9aa062860ca27711ff55343211,52025-03-09T00:05:08.000Z0x19fecbc407ca5fe3b74baaed41ef5b92a2c303864f87e458b366ab2c2f39991c340282366920938463463374607431768211455340282366920938463463374607431768211455
9052060true456900x85b667290x5338d2993ca49212d1034ff36dd46f5192687dce8805747656562914231870479521219802890613125509280x949e7b2f3f66eae761a9397346ddbd719f046c0e0x5be2e859d0c2453c9aa062860ca27711ff5534329,52025-03-09T00:20:11.000Z0x1b91061448a24437325f504c691a2e1bf918c8f29af8bc7772376f7a1928d6d7340282366920938463463374607431768211455340282366920938463463374607431768211455
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Pool_collectProtocol_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Flash_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation analysis.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_paid0STRINGAmount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
in_paid1STRINGAmount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
addressremovedin_paid0in_paid1in_senderlog_indexin_amount0in_amount1block_numberin_recipientblock_timestamptransaction_hash
0xd7a373cf23f30065a11684efc763cb261cb68ccffalse020826000000000000000000xdb0b9d915b3626dd3fe4a32277f2cbaaa3d7d443210208260000000000000000000204132100xdb0b9d915b3626dd3fe4a32277f2cbaaa3d7d4432025-04-15T17:29:47.000Z0xf164d1400497714cb1725b2259686c5921a47bbcaed1721018d436ff6ba4a8c3
0x44d54cd01640b19fadbee78a8628c86bd8675319false069420000000000000000x0826303fe2aab23cad893df3f85c49ce3cc5b733310347100000000000000000204140050x0826303fe2aab23cad893df3f85c49ce3cc5b7332025-04-15T17:36:20.000Z0x3d192fd7b73c453c5a8350c9095e5383b50f9c5667975d879ef3394c929e48e8
0xc291ca0a0a0e793dc6a0442a34e1607ce1905389false04125044850380xe049ce9d2c614bf507239f00e354b1764a2c1ca637031731114233637352203913760xe049ce9d2c614bf507239f00e354b1764a2c1ca62025-04-15T14:42:32.000Z0x3c90cf43a2e37737bd4519e0d108d0e7305b264a46478b6ef67499821feb74b8
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Pool_Flash_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
in_tickUpperINT64Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountin_senderlog_indexin_amount0in_amount1block_numberin_tickLowerin_tickUpperblock_timestamptransaction_hash
0xa1538e790ccdd639755602857f582a39ed7f650cfalse0x12e66c8f215ddd5d48d150c8f46ad0c6fb0f4406748098846080114540x12e66c8f215ddd5d48d150c8f46ad0c6fb0f44061297344958180218730864030474853613680548-350150-3500502025-03-14T13:57:10.000Z0x4d50c6ed3b4df4ef8a041bd2deb44857584c7c49cdd0bcfa5d91e00da6166583
0xa1538e790ccdd639755602857f582a39ed7f650cfalse0x12e66c8f215ddd5d48d150c8f46ad0c6fb0f4406183169619687470640x12e66c8f215ddd5d48d150c8f46ad0c6fb0f44061068892770526763934863944356097913685897-350350-3499502025-03-14T14:30:58.000Z0x1f1086492e1981aeb47dac1d1e926cac68013d179f74351e4bbd57646e1644b3
0xa1538e790ccdd639755602857f582a39ed7f650cfalse0x12e66c8f215ddd5d48d150c8f46ad0c6fb0f440618637555866477630x12e66c8f215ddd5d48d150c8f46ad0c6fb0f440630184693790419819172978013755857-349950-3499002025-03-14T22:06:23.000Z0x7843453ba006942fe65ea75db4142e6031f5bb71af99a92466014a4b89a64f8f
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Pool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_SetFeeProtocol_event

Protocol fee configuration change events emitted when liquidity pool fee parameters are updated. Records old and new fee protocol values for both tokens in the pool, tracking governance-initiated fee structure modifications.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_feeProtocolOldINT64Previous protocol fee configuration value before the update. Integer representing the fee percentage allocated to the protocol from trading fees.
in_feeProtocolNewINT64Updated protocol fee configuration value being set. Integer representing the fee percentage allocated to the protocol from trading fees.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_feeProtocolNewin_feeProtocolOld
0x3e1071ae1ac0c1b2f155ee09794e2491298cf003false546768002025-01-20T12:12:58.000Z0x348decec984110718d74b0e23c83a7b4d2140bbe80c3df4694f8770a7f520c201005
0x097d8b97d15567fb9966ba7bfaec35cb86b09834false7147357362025-03-20T00:20:02.000Z0x03cbe041269b92a6a095cc5547581335225441cd7c1f2accd2ac9cc3c0d1e6ae5100
0x36688823ef912ca5f3c152163c3082a01f22cc67false20147357362025-03-20T00:20:02.000Z0x03cbe041269b92a6a095cc5547581335225441cd7c1f2accd2ac9cc3c0d1e6ae5100
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Pool_SetFeeProtocol_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_setFeeProtocol_function

Protocol fee configuration changes for Shadow Exchange V3 liquidity pools on Sonic. Records administrative function calls that modify pool fee parameters, useful for tracking fee structure updates and protocol governance actions.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
gasvaluestatusgas_usedsignatureto_addressblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
409270true105700x7b7d549d0x43b3ba354aee512ca45f0c5512440fbadf114e9868551460xcd2d0637c94fe77c2896bbcbb174ceffb08de6d70,0,02025-02-07T02:08:02.000Z0xb2e62776d377e1cea9babb879453c3cfa90c7b1aa1768567b4dd3185af973629
21885690true100020x7b7d549d0xbb2e96c784e69ebc9bbf99f748532736c271d09e60752970xcd2d0637c94fe77c2896bbcbb174ceffb08de6d77,02025-01-31T22:09:00.000Z0xfc80e7d2afec3393d812dc785bba69e6af500d45d84afa1097c2bba7ab535d10
21662490true100020x7b7d549d0x36688823ef912ca5f3c152163c3082a01f22cc6747795630xcd2d0637c94fe77c2896bbcbb174ceffb08de6d77,02025-01-21T06:37:33.000Z0xd8c936773cf9e6efa2dab67ec03f53dfe0a22063a51ca5aa6e91dbe00d5a7929
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Pool_setFeeProtocol_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_sqrtPriceX96STRINGSquare root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers.
in_liquiditySTRINGTotal liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
in_tickINT64Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.
addressin_tickremovedin_senderlog_indexin_amount0in_amount1block_numberin_liquidityin_recipientblock_timestampin_sqrtPriceX96transaction_hash
0x3fccdda302b23f3741df05e698d1300a346d92b1253451false0xba7bac71a8ee550d89b827fe6d67bc3dca07b1049-6771077266935229674282050681469434031395798156267262510x000000000bc3ea715de9e9b29638e995f811a7592025-02-07T20:40:05.000Z252484170669956599920693551534947280xfd49732ff4e79de0708ac012d3754e05a65afd6acb15b49f5c6dbe23be434c2f
0x3fccdda302b23f3741df05e698d1300a346d92b1253382false0xba7bac71a8ee550d89b827fe6d67bc3dca07b1046-7761569047893524963513870126669432811395798156267262510x000000000bc3ea715de9e9b29638e995f811a7592025-02-07T20:39:09.000Z251617621950455012295245070950437740xb622a5d01b4d20f03d07198fdbe88782c46496c877bf03880daeded9983ed268
0x3fccdda302b23f3741df05e698d1300a346d92b1253384false0xba7bac71a8ee550d89b827fe6d67bc3dca07b10420-841724585766159614383997769432811395798156267262510x000000000bc3ea715de9e9b29638e995f811a7592025-02-07T20:39:09.000Z251636905673276928550307034880331040xb622a5d01b4d20f03d07198fdbe88782c46496c877bf03880daeded9983ed268
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PoolFactory_FeeAdjustment_event

Fee adjustment events from Shadow Exchange v3 liquidity pools on Sonic, recording changes to pool trading fees with basis point values. Used for tracking fee tier modifications and pool economics over time.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_newFeeSTRINGUpdated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.
addressin_poolremovedin_newFeelog_indexblock_numberblock_timestamptransaction_hash
0xcd2d0637c94fe77c2896bbcbb174ceffb08de6d70xe62dcc8343fefd2169d65d9f953b2da74346c4e4false401037431327712025-08-15T13:16:03.000Z0x008dfb1ffce269f96554301e13c0d7c7fe42bafb3733b83646ce436996113163
0xcd2d0637c94fe77c2896bbcbb174ceffb08de6d70x6807a4ff4c87abdbaf083232136eff37e9205f12false60231431327712025-08-15T13:16:03.000Z0x008dfb1ffce269f96554301e13c0d7c7fe42bafb3733b83646ce436996113163
0xcd2d0637c94fe77c2896bbcbb174ceffb08de6d70xc15de0d97bb77873fd9755f98624c7a79c7ba3f9false120233431327712025-08-15T13:16:03.000Z0x008dfb1ffce269f96554301e13c0d7c7fe42bafb3733b83646ce436996113163
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.PoolFactory_FeeAdjustment_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PoolFactory_FeeCollectorChanged_event

Fee collector address updates from the ShadowExchange V3 pool factory contract on Sonic blockchain. Records governance changes showing transitions between old and new fee collection addresses for protocol revenue management.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_oldFeeCollectorSTRINGAddress of the previous fee collector contract before a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.
in_newFeeCollectorSTRINGAddress of the new fee collector contract after a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_newFeeCollectorin_oldFeeCollector
0xcd2d0637c94fe77c2896bbcbb174ceffb08de6d7false138265482025-01-14T04:07:01.000Z0x91a942becf368fdea5e9b3a6b3bc1f5f8ad1092617fb20ddf7595cebbefdb18b0xbf9ab1b18f9e943404e794bdfe9b5aac012fa0170x5be2e859d0c2453c9aa062860ca27711ff553432
0xcd2d0637c94fe77c2896bbcbb174ceffb08de6d7false640392632025-01-15T19:37:37.000Z0xc1959493ffd08e71eaa3fb6ec8efdc06157585bf73933f64ce2e745a0072caa20xcc0365f8f453c55ea7471c9f89767928c8f8d27f0x6a4400157291d1ff339188eca407011c7429c9c5
0xcd2d0637c94fe77c2896bbcbb174ceffb08de6d7false140275682025-01-15T17:49:23.000Z0x2508b1f28152a1a6db135c0a653c83a2da69294d8f62ca0624123f1d20a5f4ed0x6a4400157291d1ff339188eca407011c7429c9c50xbf9ab1b18f9e943404e794bdfe9b5aac012fa017
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.PoolFactory_FeeCollectorChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PoolFactory_SetFeeProtocol_event

Protocol fee configuration changes for Shadow Exchange V3 liquidity pools on Sonic blockchain. Tracks fee percentage updates with old and new values for analyzing protocol revenue adjustments.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_feeProtocolOldINT64Previous protocol fee configuration value before the update. Integer representing the fee percentage allocated to the protocol from trading fees.
in_feeProtocolNewINT64Updated protocol fee configuration value being set. Integer representing the fee percentage allocated to the protocol from trading fees.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_feeProtocolNewin_feeProtocolOld
0xcd2d0637c94fe77c2896bbcbb174ceffb08de6d7false617057812024-12-27T02:25:15.000Z0x48710b2ffd2d74a0914eeb71badfc9a4edcf8c71210a78f76f40d4f24ff3266950
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.PoolFactory_SetFeeProtocol_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PoolFactory_SetPoolFeeProtocol_event

Protocol fee changes for Shadow Exchange V3 liquidity pools on Sonic blockchain. Tracks adjustments to pool-level fee parameters with old and new values for monitoring fee structure evolution.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_feeProtocolOldINT64Previous protocol fee configuration value before the update. Integer representing the fee percentage allocated to the protocol from trading fees.
in_feeProtocolNewINT64Updated protocol fee configuration value being set. Integer representing the fee percentage allocated to the protocol from trading fees.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hashin_feeProtocolNewin_feeProtocolOld
0xcd2d0637c94fe77c2896bbcbb174ceffb08de6d70x680fbd6917bcf7621f1becfe8a712082eeeddc0bfalse8294965082025-05-25T14:05:20.000Z0x0f89d5b289da511bba09568083f67fa0365c3c17767bb5185fdee744046ef52a5100
0xcd2d0637c94fe77c2896bbcbb174ceffb08de6d70x1d4e67cfa133718bb03b404eca0fbe4b7f25835ffalse46162073762025-03-27T00:00:41.000Z0x03c140e1294b16f42fea991cf176a3d4e1c8fd079580f13f98683b34c28f36f255
0xcd2d0637c94fe77c2896bbcbb174ceffb08de6d70x36688823ef912ca5f3c152163c3082a01f22cc67false173162072872025-03-27T00:00:13.000Z0x5cf04a995d427bbe369f3c5d38daa38b459e9eda4160ec2862841d4a42ac457b55
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.PoolFactory_SetPoolFeeProtocol_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PoolFactory_TickSpacingEnabled_event

Configuration events from Shadow Exchange V3 factory contract on Sonic recording enabled fee tier and tick spacing combinations for concentrated liquidity pools. Used for tracking supported pool parameters and fee structure changes over time.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_tickSpacingINT64Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
in_feeSTRINGFee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
in_feeaddressremovedlog_indexblock_numberin_tickSpacingblock_timestamptransaction_hash
5000xcd2d0637c94fe77c2896bbcbb174ceffb08de6d7false21705781102024-12-27T02:25:15.000Z0x48710b2ffd2d74a0914eeb71badfc9a4edcf8c71210a78f76f40d4f24ff32669
100000xcd2d0637c94fe77c2896bbcbb174ceffb08de6d7false417057811002024-12-27T02:25:15.000Z0x48710b2ffd2d74a0914eeb71badfc9a4edcf8c71210a78f76f40d4f24ff32669
2500xcd2d0637c94fe77c2896bbcbb174ceffb08de6d7false1170578152024-12-27T02:25:15.000Z0x48710b2ffd2d74a0914eeb71badfc9a4edcf8c71210a78f76f40d4f24ff32669
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.PoolFactory_TickSpacingEnabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_claimIncentives_function

Voter incentive claim transactions from ShadowExchange v3 DEX (decentralized exchange) on Sonic blockchain. Tracks liquidity provider reward claims with token and fee distributor parameters for analyzing protocol participation and rewards distribution.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in__feeDistributorsARRAY<STRING>Array of fee distributor contract addresses for claiming incentives or rewards. Each element is a hex-encoded, 0x-prefixed, 42-character string.
in__tokensARRAY<STRING>Array of token contract addresses involved in the operation. Each element is a hex-encoded, 0x-prefixed, 42-character string.
gasvaluestatusgas_usedin_ownersignaturein__tokensto_addressblock_numberfrom_addresstrace_addressblock_timestamptransaction_hashin__feeDistributors
20392440true7900020x307f38fa[]0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d496016350x03450893c013700bb5f074e78ca5c175d4ad27172025-10-07T05:42:26.000Z0xe99db8932efe19c2f8f47912e1f5035c6db5923af855e7571c048c11adb8771e[]
8065710true5398300x307f38fa[]0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d495936320x1d7d5d1c5a2e36ecc47a784be757c6438139ee532025-10-07T04:14:43.000Z0xe11c16ca89bcd2d79fc93f53f4255c60f0d85b4c26d9af4150c39f5e65ffb1e8[]
4911110true3248770x307f38fa[]0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d495939400x1d7d5d1c5a2e36ecc47a784be757c6438139ee532025-10-07T04:17:34.000Z0xede643cfd4eac1ab20411f6c8fc474c9aba844dcada3611dccd02c5604f27b5f[]
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_claimIncentives_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_claimLegacyIncentives_function

Function calls to claim legacy trading fee incentives from Shadow Exchange V3 voter contract on Sonic. Used to analyze historical reward claims and liquidity mining participation patterns.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in__feeDistributorsARRAY<STRING>Array of fee distributor contract addresses for claiming incentives or rewards. Each element is a hex-encoded, 0x-prefixed, 42-character string.
in__tokensARRAY<STRING>Array of token contract addresses involved in the operation. Each element is a hex-encoded, 0x-prefixed, 42-character string.
gasvaluestatusgas_usedin_ownersignaturein__tokensto_addressblock_numberfrom_addresstrace_addressblock_timestamptransaction_hashin__feeDistributors
13142960true8307980xbb7041c2[]0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d199400480x0810818c20c456c429ce9139a0dde0946a8c7d0d2025-04-13T08:06:20.000Z0x2b6a7b6e05225fc33f3819b35874d501447d52281d2006565b0e887d388e09bb[]
8409030true7526790xbb7041c2[]0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d200605890x3755b74ea0c85ae843cea30df733b68e128b3dad2025-04-13T22:38:28.000Z0x63d789b081b2a9ba0c7e6c79705fb82873284c9e31d0999cb297a226c2a0002a[]
9184670true5611900xbb7041c2[]0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d199288450x3d72a0ee73159f73183333942cc1e511d9b356362025-04-13T06:35:57.000Z0x0316305b736e5e3ef2625d5c3d2c08dd72e3d584584bac960caa0c247f7947ff[]
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_claimLegacyIncentives_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_claimLegacyRewardsAndExit_function

Function calls to claim outstanding rewards from deprecated gauges and exit legacy positions on Shadow Exchange V3 (Sonic chain). Used to analyze migration patterns and reward redemption activity during protocol upgrades.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__gaugesARRAY<STRING>Array of gauge contract addresses for claiming rewards. Each element is a hex-encoded, 0x-prefixed, 42-character string.
in__tokensARRAY<STRING>Array of token contract addresses involved in the operation. Each element is a hex-encoded, 0x-prefixed, 42-character string.
gasvaluestatusgas_usedsignaturein__gaugesin__tokensto_addressblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
1624660true1277670x6003d24d[][]0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d327148370x96d77bac5749ea39263bd9bd1b400b3f9d8c91b62025-06-08T16:06:20.000Z0x205d526a2fbd9235199d15395f265caebed8ca8f0af3237f1b8cad841044cd36
1803800true1379510x6003d24d[][]0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d326038070xb051b6418c11052f56f81fe651a86938c512550c2025-06-08T03:33:53.000Z0xd35acb0c5b2025fc5472c58d6c34a25eedfb7b3416e3cebdc41fb9c842770e7c
1803920true1379600x6003d24d[][]0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d327437820xe26f8eda7f3b332ed440c760b67504c4dc5132472025-06-08T19:28:07.000Z0x41e52dbe0260254a61dd17dc3dde395b27ced5a29ef34e98e1aef0a1974fa731
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_claimLegacyRewardsAndExit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_claimRewards_function

Reward claim transactions from ShadowExchange V3’s Voter contract on Sonic, tracking user calls to claim trading fees and emissions from liquidity gauge staking. Used for analyzing reward distribution patterns and user claiming behavior across different gauge positions.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__gaugesARRAY<STRING>Array of gauge contract addresses for claiming rewards. Each element is a hex-encoded, 0x-prefixed, 42-character string.
in__tokensARRAY<STRING>Array of token contract addresses involved in the operation. Each element is a hex-encoded, 0x-prefixed, 42-character string.
gasvaluestatusgas_usedsignaturein__gaugesin__tokensto_addressblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
1284520true1163950x20b1cb6f[][]0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4f146446650xa521e425f37acc731651565b41ce3e5022274f4f2025-03-19T14:24:59.000Z0xc5636ca41acd7a734a8ae258f3a783b8586d5e462da037a8b0721f1e78c01e9e
1377490true1206490x20b1cb6f[][]0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4f145616650x894bfc764bac19441bb88d52a5195ecd3e996feb2025-03-19T04:03:27.000Z0xc87a6bad64dce17635e612c614df8e6706133e0e6e2c5c9675034202672c8310
1377490true1206490x20b1cb6f[][]0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4f146348690xf28bd1e69efd298f012d280b96d65e2a86785b172025-03-19T13:18:56.000Z0x1f9e75806eeea9c550682ed4b697bb15729371f7661fcd8dde71d9150c445b37
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_claimRewards_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_Deposit_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_lpSTRINGLiquidity pool contract address. Hex-encoded, 0x-prefixed, 42-character string.
in_gaugeSTRINGContract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_DistributeReward_event

Reward distribution events emitted when a Voter contract allocates tokens to gauge contracts. Records the sender address, target gauge contract, and token amount distributed for liquidity mining incentives.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_gaugeSTRINGContract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_gaugein_amountin_senderlog_indexblock_numberblock_timestamptransaction_hash
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062dfalse0xd9f075dcc8507612cdde043e379edfa1ae69e57b3788965252681419796930x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d76334542612025-06-12T00:00:04.000Z0xa9695bb07f3b971cb8b7365c827ae6b4950ac10bd7b91685c0c19357d996fb9f
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062dfalse0xd75e6fe4a5ed69104e1d369929e4ba049740967c265540317461187285160x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d44334542612025-06-12T00:00:04.000Z0xa9695bb07f3b971cb8b7365c827ae6b4950ac10bd7b91685c0c19357d996fb9f
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062dfalse0xcfbc3bb20d84580fcade784e7ee1cf7f7c1d3377177236076426728698690x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d102334542612025-06-12T00:00:04.000Z0xa9695bb07f3b971cb8b7365c827ae6b4950ac10bd7b91685c0c19357d996fb9f
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_DistributeReward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_EmissionsRatio_event

Emissions ratio parameter changes from Shadow Exchange V3 Voter contracts on Sonic, tracking adjustments to token distribution ratios. Used for analyzing protocol governance decisions and emissions policy modifications over time.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_oldRatioSTRINGPrevious ratio value before the state change. Numeric string representation in wei (18 decimal places).
in_newRatioSTRINGUpdated ratio value after the state change. Numeric string representation in wei (18 decimal places).
addressremovedin_callerlog_indexin_newRatioin_oldRatioblock_numberblock_timestamptransaction_hash
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062dfalse0x0000000000000000000000000000000000000000510000000102662242025-02-26T09:46:47.000Z0x1800442caa2fc3043417ee8933c51762a04595a86b6ebb6cd5851d0dbae35680
0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4ffalse0x000000000000000000000000000000000000000021000000040392632025-01-15T19:37:37.000Z0xc1959493ffd08e71eaa3fb6ec8efdc06157585bf73933f64ce2e745a0072caa2
0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4ffalse0x5e7a9eea6988063a4dbb9ccddb3e04c923e8e37f101000000419068242025-08-06T19:16:10.000Z0x0b760bfba8bae5359832a328b98e6e7192b8718128b0a15450625c01237f3030
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_EmissionsRatio_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_EmissionsRedirected_event

Emissions redirection events from Shadow Exchange V3 DEX on Sonic, tracking when token rewards are rerouted between liquidity gauge pools. Used for analyzing vote-escrowed tokenomics (veTokenomics) governance and incentive allocation changes.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_sourceGaugeSTRINGContract address of the gauge from which emissions are being redirected. Hex-encoded, 0x-prefixed 40-character string on Sonic chain.
in_destinationGaugeSTRINGContract address of the gauge receiving redirected emissions from the source gauge. Hex-encoded, 0x-prefixed 40-character string for EVM chains.
addressremovedlog_indexblock_numberin_sourceGaugeblock_timestamptransaction_hashin_destinationGauge
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062dfalse20420328880x4d7ed5e18b09173bef675acdb2614eee9cfa54a72025-08-07T17:10:05.000Z0xaf800adadd3ef2df5aa6394bf99c084811f02684343471e81d67a66eba56b6fe0x4d7ed5e18b09173bef675acdb2614eee9cfa54a7
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062dfalse23176867340x19d280e25fae18a8e538affd0e2841c364ac1eb52025-04-02T12:59:21.000Z0x5b9e14ee148a3ed99e690259bb52b19f9283c2ac66d0fcf01f5d9b1b1bba08fe0x19d280e25fae18a8e538affd0e2841c364ac1eb5
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062dfalse25102867860xd75e6fe4a5ed69104e1d369929e4ba049740967c2025-02-26T11:53:06.000Z0x2e725fb7f8311aaae171b12b5a25fefe6a5e796cf46b2a9663ae5b87433141220xd75e6fe4a5ed69104e1d369929e4ba049740967c
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_EmissionsRedirected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_GaugeCreated_event

Gauge creation events emitted when new liquidity mining gauges are deployed for liquidity pools in vote-escrowed token (veToken) protocols. Links pool addresses to their corresponding gauge contracts and associated reward distribution mechanisms for governance-driven liquidity incentives.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_gaugeSTRINGContract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
in_creatorSTRINGAddress of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
in_feeDistributorSTRINGContract address of the fee distributor associated with the gauge. Hex-encoded, 0x-prefixed, 42-character string.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedin_gaugelog_indexin_creatorblock_numberblock_timestamptransaction_hashin_feeDistributor
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d0x0157699e0a26dbdf42a0a1dcf7426d0df408c60efalse0x0ae798f6d5464f5e972284ae56bde93b6a3a33dc290x5e7a9eea6988063a4dbb9ccddb3e04c923e8e37f205924332025-04-16T17:31:59.000Z0xbcbe3e0493ab7b5ab726bda18fe5c93bb30a60e32fce1f7b0a88277c07f4a10b0xbf042fec64820d1067b3587a75017860476dc473
0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4f0x738c23f7373bf474c48c58782310e5eb437b361cfalse0x08eca19456b150d56de8a4153edd5ddc7f5318eb70x5e7a9eea6988063a4dbb9ccddb3e04c923e8e37f146633982025-03-19T16:27:15.000Z0x8d4b5395ac999864a10f4c2378e796bec8fe5ce9843ab82732d5e44b8672b1260xb2d1d594efdeebfb7a938bbe252da33edc0b02de
0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4f0x5312d5a9d44debbd2b43238eda338d220154ab22false0x5d6235bb1fbf1e02af5ae7298c9c7694385a8995720x5e7a9eea6988063a4dbb9ccddb3e04c923e8e37f146634012025-03-19T16:27:16.000Z0xd69b5646b5f6e8fe956f1c8b1d22b0cb7fb386868bd0fa57a630f645ce553f770xaaee843176fcbb7af4611289d349c9693f170d43
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_GaugeCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_GaugeKilled_event

Event logs recording the deactivation of gauge contracts from voting eligibility. Contains the gauge address that was removed from the active reward distribution set.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_gaugeSTRINGContract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_gaugelog_indexblock_numberblock_timestamptransaction_hash
0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4ffalse0xcbcad939e2bbbe01850a141f204f25df63b8fc5b21419316732025-08-07T00:00:03.000Z0xaa42737227d25e08952f23f907b8e6530f29d3b8bcba790068991f12b91d3f5a
0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4ffalse0x580f88bb24ff392abe237b21bf88bdae7c00d9c526159371272025-03-25T19:47:57.000Z0xad28b203dcb4a65105f284a340634737733084016f6211a99c8150b7d0c2f1dd
0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4ffalse0x251ac7ad576f058caaa7d942362a2ffec3d8fb77464691562025-02-04T00:20:00.000Z0x96135db662aa0abb36c95dfdfab3061df7af20b3cd3417a6dfc49dc5ce952be5
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_GaugeKilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_GaugeRevived_event

Gauge reactivation events from ShadowExchange V3 DEX (decentralized exchange) on Sonic blockchain, tracking when previously killed liquidity gauges are revived for emissions. Used for monitoring governance decisions around incentive distribution and liquidity pool management.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_gaugeSTRINGContract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_gaugelog_indexblock_numberblock_timestamptransaction_hash
0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4ffalse0xcbcad939e2bbbe01850a141f204f25df63b8fc5b11319111362025-06-05T00:00:03.000Z0xbe38622b58cd587db6cec6ce823558b024491077d8ce6547ff8acde81f707983
0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4ffalse0xcbcad939e2bbbe01850a141f204f25df63b8fc5b33206440262025-04-17T00:04:17.000Z0xff6f6a8457ac9befb6936d46701f31bd395e972dad9cb51879f11c4fe8b77ea2
0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4ffalse0xcbcad939e2bbbe01850a141f204f25df63b8fc5b11399342682025-07-24T00:00:03.000Z0x7c543076722103bf4d03587e3dea16086c81b3f2feef6774ff990cf1312e911b
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_GaugeRevived_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_NotifyReward_event

Reward distribution events emitted when tokens are allocated to voting gauges in Decentralized Exchange (DEX) voter contracts. Records the sender address, reward token contract, and token amount distributed to incentivize liquidity provision and governance participation.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_amountin_rewardin_senderlog_indexblock_numberblock_timestamptransaction_hash
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062dfalse310495680000000000000000x3333b97138d4b086720b5ae8a7844b1345a333330x2a78f35726751d22e172dd755cfc051f352affbf18268509352025-05-15T00:00:08.000Z0x0c83b186c31d8c9b2adb228d4f8b59eb89d5565752307ba6efa489971ed4c5a8
0x3af1dd7a2755201f8e2d6dcda1a61d9f54838f4ffalse310495680000000000000000x3333b97138d4b086720b5ae8a7844b1345a333330xc7022f359cd1bda8ab8a19d1f19d769cbf7f37653268509352025-05-15T00:00:08.000Z0x0c83b186c31d8c9b2adb228d4f8b59eb89d5565752307ba6efa489971ed4c5a8
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062dfalse310495680000000000000000x3333b97138d4b086720b5ae8a7844b1345a333330x2a78f35726751d22e172dd755cfc051f352affbf18147323172025-03-20T00:00:17.000Z0x8bfe0033fd0d422d49e39d867b592f310680d0478bb8dc23f961453c0ef29fa7
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_NotifyReward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_Voted_event

Governance voting events recording weight allocation to liquidity pools or gauges. Contains voter address, target pool, and voting power in wei-denominated values for tracking vote distribution in vote-escrowed token systems.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_weightSTRINGVoting power or gauge weight allocated to a pool or account. Numeric string representation of wei-denominated value.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedin_ownerin_weightlog_indexblock_numberblock_timestamptransaction_hash
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d0x324963c267c354c7660ce8ca3f5f167e05649970false0x31be92cd745c622133f195a63ded70f1e41d6c98462280676401916034361423237162025-08-10T01:22:09.000Z0x1e11078d0270da90c45f02d260e9d441ffc16fe696f97c0b4a4eff170a9eceb4
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d0x5fc0e8736dc1012940ff373ade4bf6e09444cc3bfalse0x5a1ed8525c56e21e42f878e5c291f9c868f79c06315712779449227710641423259262025-08-10T01:50:15.000Z0x792a74170a25b1ea4a68492fe56b5c59958a0405a56f8b974ac67823c3a7b089
0x9f59398d0a397b2eeb8a6123a6c7295cb0b0062d0x324963c267c354c7660ce8ca3f5f167e05649970false0xaa970e6bd6e187492f8327e514c9e8c36c81f11e719991441218526393991423303852025-08-10T02:40:04.000Z0xe2b17b0862dee26ea28e88d03d74d630fd86f9a0ab840abf5a17a515897e3669
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_Voted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_Withdraw_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_lpSTRINGLiquidity pool contract address. Hex-encoded, 0x-prefixed, 42-character string.
in_gaugeSTRINGContract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.shadowexchange_v3_sonic.Voter_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100