synthetix_v1_ethereum

Tables

FeePool_FeesClaimed_event

Fee claim events from Synthetix V1 protocol on Ethereum, recording when stakers collect their sUSD trading fees and SNX staking rewards. Used for analyzing staker behavior, fee distribution patterns, and reward claim timing.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sUSDAmount`	`STRING`	Amount of sUSD (Synthetix USD stablecoin) fees claimed by the account in this transaction, denominated in wei (18 decimals). Values range from small amounts like 0.0005 sUSD to hundreds of sUSD per claim event.
`in_snxRewards`	`STRING`	Amount of SNX (Synthetix Network Token) rewards claimed by the account in this transaction, denominated in wei (10^-18 SNX). Values typically range from billions to quadrillions of wei, representing fractional to whole SNX tokens.

Sample Data

address	removed	log_index	in_account	block_number	in_sUSDAmount	in_snxRewards	block_timestamp	transaction_hash
0xb440dd674e1243644791a4adfe3a2abb0a92d309	false	340	0x8ec6e73a2fa9959be35975178eeeaa20b5b71a94	18188491	3022532710769157	6055840618253925141	2023-09-22T02:43:23.000Z	0x237b56a5044870b21dba9dd2af4b5fcc23344910578ced02fc21eef2b14a0396
0xb440dd674e1243644791a4adfe3a2abb0a92d309	false	305	0x103f1a97147b2345ba1dee9852f4991754425801	18190151	186566624902404561	373798351650267553021	2023-09-22T08:18:59.000Z	0x9aedb388098c08718beef727021d815793c1ea18df38d4d6199cd4c15e077b68
0xb440dd674e1243644791a4adfe3a2abb0a92d309	false	140	0x11d64f176b72f831d5760e562d8ed01cf33eadcf	18188444	191846044287491091	384376011319290056424	2023-09-22T02:33:59.000Z	0xd39e9fb21b5e8c62500f60c3560a0ce3a3f6ad2abe25c44c46db7216c32a0073

Example Query

Query with partition filter

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

ShortingRewardssBTC_RewardPaid_event

Reward distribution events from Synthetix V1’s sBTC shorting rewards contract on Ethereum, capturing incentive payouts to users who provided liquidity for synthetic Bitcoin shorts. Used for analyzing reward claim patterns and liquidity provider earnings in the legacy shorting mechanism.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xced4055b47cfd0421f3727a35f69ce659c8baf7a	0xaa3b1fdc3aa57bf24418e397f8c80e7385aaa594	false	389913958366438380042	100	12827176	2021-07-14T20:11:38.000Z	0xfb04592ddf4134073493e2ffb90d50b5e61ba129e127a87d4e69b293b84cc4bc
0xced4055b47cfd0421f3727a35f69ce659c8baf7a	0x10af482f012c16b56c3722d73d14cca9b986d7f1	false	748742129839681416927	302	12380755	2021-05-06T12:31:44.000Z	0xbebc27d1dad0845d7cfbca22b9492d33dc2630bea83c5d9424675dcd573d08b0
0xced4055b47cfd0421f3727a35f69ce659c8baf7a	0x5cff9a79c09e21d5c34fe6a2e5f99fc41d1549bf	false	203657039166474218925	367	12377759	2021-05-06T01:27:59.000Z	0xec62db654d23bee3c845597c20549c3bcac3f6c499f58de6b69bb62a6b50f858

Example Query

Query with partition filter

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

ShortingRewardssETH_RewardPaid_event

Reward distribution events from Synthetix V1’s sETH (synthetic Ether) shorting rewards contract on Ethereum, capturing when users claim staking incentives for providing liquidity to short positions. Used for analyzing reward claim patterns and liquidity provider behavior in Synthetix’s shorting mechanism.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x12dc1273915a16ab8bd47ba7866b240c253e4c12	0x5a180ac8aa821434d0c870c175aa3606837b69fc	false	30285513800782201533	254	12371073	2021-05-05T00:46:21.000Z	0x3114840b2acc56d45e7c75e9a9f144c8f9d21825edb6b66a7281601ca4a11386
0x12dc1273915a16ab8bd47ba7866b240c253e4c12	0x5607ce36aa531a8ce77ac21d33296b7cd1c50687	false	51675468660221044	25	12052968	2021-03-17T00:40:15.000Z	0x1ed48fde29bb562b7a32acd9579e8c78b9e3aff0712ef79f7dd74dca9023e49e
0x12dc1273915a16ab8bd47ba7866b240c253e4c12	0x5cff9a79c09e21d5c34fe6a2e5f99fc41d1549bf	false	35592099183017016532	201	12261439	2021-04-18T02:37:38.000Z	0x6a5eff872aab4c7f83922a1d93004496e9ed4d13ebd3063db2307282ce80543e

Example Query

Query with partition filter

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

SNX_AtomicSynthExchange_event

Atomic swap events from Synthetix v1 protocol on Ethereum, capturing instant exchanges between synthetic assets (synths) with source/destination currency keys, amounts, and recipient addresses. Used for analyzing trading volumes, synth liquidity flows, and atomic exchange pricing across sUSD, sETH, sBTC, and other synthetic assets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromCurrencyKey`	`STRING`	Hex-encoded 32-byte identifier representing the source synthetic asset being exchanged (e.g., sETH, sUSD). Common currency keys include sUSD (0x73555344…), sETH (0x73455448…), and other synths available on Synthetix V1.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toCurrencyKey`	`STRING`	Hex-encoded bytes32 identifier for the synthetic asset received in the exchange (e.g., sUSD, sETH, sBTC). Uses Synthetix currency key format where asset symbols are left-padded with zeros.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAddress`	`STRING`	Destination address for the cross-chain transfer or operation. Hex-encoded string with 0x prefix, left-padded with zeros to 66 characters total.

Sample Data

address	removed	log_index	in_account	in_toAmount	block_number	in_toAddress	in_fromAmount	block_timestamp	in_toCurrencyKey	transaction_hash	in_fromCurrencyKey
0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f	false	237	0xbf683b7aaf9accea6bff8e926e03f6ceb98b525a	79688425854999999999966	18202027	0xbf683b7aaf9accea6bff8e926e03f6ceb98b525a	50041155881423209100	2023-09-24T00:15:23.000Z	0x7355534400000000000000000000000000000000000000000000000000000000	0xa825c539ef426c55f14827e11642e79391c719c467a7c583b90e32d12b7f8ff8	0x7345544800000000000000000000000000000000000000000000000000000000
0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f	false	254	0xbf683b7aaf9accea6bff8e926e03f6ceb98b525a	79677814008577499999977	18202027	0xbf683b7aaf9accea6bff8e926e03f6ceb98b525a	50034492064567490828	2023-09-24T00:15:23.000Z	0x7355534400000000000000000000000000000000000000000000000000000000	0xa825c539ef426c55f14827e11642e79391c719c467a7c583b90e32d12b7f8ff8	0x7345544800000000000000000000000000000000000000000000000000000000
0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f	false	102	0x19ea2e6f21bdfc894abf09fa179d59f6c0e0797b	9485506528104643493484	17833079	0x19ea2e6f21bdfc894abf09fa179d59f6c0e0797b	7476296570346776410157	2023-08-03T07:47:23.000Z	0x7355534400000000000000000000000000000000000000000000000000000000	0xac793e8c6e065698eb01a7e459e087dc9c735d7fe509153f1d3e8c527cc7a54b	0x7347425000000000000000000000000000000000000000000000000000000000

Example Query

Query with partition filter

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

SNX_SynthExchange_event

Synthetic asset exchange transactions on Synthetix v1 Ethereum protocol, recording conversions between synths (sUSD, sBTC, sCHF) with input/output amounts and currency keys. Used for analyzing trading volume, synth liquidity flows, and exchange patterns across synthetic assets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromCurrencyKey`	`STRING`	Identifier of the synthetic asset (synth) being exchanged from, encoded as a bytes32 hex value representing the currency key (e.g., sBTC, sCHF). Common values include sUSD, sBTC, and other Synthetix synth tickers.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toCurrencyKey`	`STRING`	Identifier of the synthetic asset received in the exchange, represented as a bytes32-encoded currency key. Commonly sUSD (0x73555344…) as seen in samples, but can be any Synthetix synth.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAddress`	`STRING`	Destination address for the cross-chain transfer or operation. Hex-encoded string with 0x prefix, left-padded with zeros to 66 characters total.

Sample Data

address	removed	log_index	in_account	in_toAmount	block_number	in_toAddress	in_fromAmount	block_timestamp	in_toCurrencyKey	transaction_hash	in_fromCurrencyKey
0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f	false	38	0x53222470cdcfb8081c0e3a50fd106f0d69e63f20	115257464863014499999995	16165332	0x53222470cdcfb8081c0e3a50fd106f0d69e63f20	6819024022901809877	2022-12-12T01:25:35.000Z	0x7355534400000000000000000000000000000000000000000000000000000000	0xfb219e456ad7a6ce7333c743bb63c60322baf45a99fb27f1ba0b584b57c344c1	0x7342544300000000000000000000000000000000000000000000000000000000
0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f	false	291	0x3b17056cc4439c61cea41fe1c9f517af75a978f7	49398439618493999999997	16168867	0x3b17056cc4439c61cea41fe1c9f517af75a978f7	2918474506048052564	2022-12-12T13:16:35.000Z	0x7355534400000000000000000000000000000000000000000000000000000000	0x36ec810e9756e07738a19fcffba57decf473bde41d9610dd738e4ef4b7ee4e74	0x7342544300000000000000000000000000000000000000000000000000000000
0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f	false	105	0x53222470cdcfb8081c0e3a50fd106f0d69e63f20	91785668598854999999995	16168939	0x53222470cdcfb8081c0e3a50fd106f0d69e63f20	5423809190157897399	2022-12-12T13:31:11.000Z	0x7355534400000000000000000000000000000000000000000000000000000000	0x758327dc121f91010b7bfdd05b4f5f27e2c1d1d35f190714ad77bdb5caf12968	0x7342544300000000000000000000000000000000000000000000000000000000

Example Query

Query with partition filter

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

StakingDualRewards_RewardPaid_event

Reward distribution events from Synthetix V1 dual-rewards staking contracts on Ethereum, capturing when users claim rewards in two different tokens simultaneously. Used for analyzing staking yield distributions and reward token flows across liquidity mining programs.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	in_rewardToken	block_timestamp	transaction_hash
0xb59e8d8ad40d06571dc0cf9936e727846dfae93f	0xa990139f25663b07b93298c680b720c0cd1debfe	false	305828924604679171667	198	12080095	0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f	2021-03-21T04:50:09.000Z	0x4ecfe85e29f4f662c235bfecf0293dc04d7ddeb269d74533e28e52d2fd7e9aaf
0xb59e8d8ad40d06571dc0cf9936e727846dfae93f	0xa990139f25663b07b93298c680b720c0cd1debfe	false	1529144623023415615578	196	12080095	0xca1207647ff814039530d7d35df0e1dd2e91fa84	2021-03-21T04:50:09.000Z	0x4ecfe85e29f4f662c235bfecf0293dc04d7ddeb269d74533e28e52d2fd7e9aaf
0xb59e8d8ad40d06571dc0cf9936e727846dfae93f	0xc9cbb5b3ea986375e28dd0e8e129179f643b8d7b	false	19845660459273627479	98	12079923	0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f	2021-03-21T04:05:46.000Z	0xb3dcc76a2408fd1c1903922df3ddddcacac7259e065d3930292df98f314261c2

Example Query

Query with partition filter

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

StakingRewardsiBTC_RewardPaid_event

Reward distribution events from Synthetix v1’s iBTC (inverse Bitcoin) staking contract on Ethereum, recording when users claim their staking incentives. Used to analyze staking reward rates, user claim patterns, and yield farming activity for the inverse Bitcoin synthetic asset.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x167009dcda2e49930a71712d956f02cc980dcc1b	0xae3bce4a8cdb3eb511ef06e8373e0989d7c5ba2c	false	11841359957599233452	274	12032912	2021-03-13T22:29:15.000Z	0xfa9cc8b25b441f7bff9f57a5f86430e35ca098695f61510da1101e998291d2f4
0x167009dcda2e49930a71712d956f02cc980dcc1b	0xc567256848abdafc49144f744b92ddceef0084e7	false	91306152001238221865	135	12028526	2021-03-13T06:26:43.000Z	0x55d6598946639e42badfb0cc45efd6d82746115db22bc94d0b2a56d484c514a6
0x167009dcda2e49930a71712d956f02cc980dcc1b	0xf3ae3bbdeb2fb7f9c32fbb1f4fbdaf1150a1c5ce	false	401925580765050490696	160	11660149	2021-01-15T14:10:09.000Z	0x6f3096513e90cf056705d923897d583d3008d1335b3f44fc64c17f7a576fc475

Example Query

Query with partition filter

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

StakingRewardsiETH_RewardPaid_event

Staking reward distribution events for Synthetix iETH (inverse Ethereum) token stakers on Ethereum mainnet. Tracks individual reward payments with user addresses and reward amounts in wei for analyzing staking yield and participant behavior.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x3f27c540adae3a9e8c875c61e3b970b559d7f65d	0xea5ed53ec1244a1baf72086c6f5726b1dd913fdc	false	329398803227401777230	197	11883857	2021-02-18T23:45:15.000Z	0xe78397fed1e5c86e342d170710772abfa640d5f4d3948e4c0fc884b74827b33e
0x3f27c540adae3a9e8c875c61e3b970b559d7f65d	0x4c09fc918bf73b12e39181b3b462806e0f7d7222	false	688773532692905765960	126	11879271	2021-02-18T06:45:04.000Z	0x01f821ca1e7348c47d208949341478df4258f94da119b6e596e6981276abf4a5
0x3f27c540adae3a9e8c875c61e3b970b559d7f65d	0x13dc08f5ddbcbfdf6ebc04c909c3052a2aa7a111	false	243650960432686100658	93	11978777	2021-03-05T14:14:09.000Z	0x6180914f824434c615b6cb283fb0b2f37b3639fca0e731888c1b3821703690f4

Example Query

Query with partition filter

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

StakingRewardssAAPLBalancer_RewardPaid_event

Reward distribution events from Synthetix V1’s sAAPL (synthetic Apple stock) Balancer pool staking contract on Ethereum. Tracks SNX or other token rewards paid to liquidity providers who staked sAAPL pool tokens.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x7af65f1740c0eb816a27fd808eaf6ab09f6fa646	0x444c996b74631763ce0c406fcbe9aa13d35f395e	false	24979716118490134766	171	17117143	2023-04-24T15:50:11.000Z	0x633fd4cac5f25e63a43e2e1811291a637d42bfe2bbd8f9bdb7a02d8b2050993a
0x7af65f1740c0eb816a27fd808eaf6ab09f6fa646	0x7676fd533b63f29cc7c2a7ca1354836f9564a04d	false	8423334336093112269	324	12661975	2021-06-19T01:52:24.000Z	0x7cd68e61ef560493516a15dce366e5baaadd0322f803f7ea392e41966a5f80b2
0x7af65f1740c0eb816a27fd808eaf6ab09f6fa646	0xef9af12bf7c5a32d7461d011c4ce9124d73f52a0	false	1429319026668242835371	168	12459337	2021-05-18T16:01:00.000Z	0xd6a11b4a2dc3ae41a36484bb71d30a1a3448282439450f3e7a102a6cfbd9e8b2

Example Query

Query with partition filter

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

StakingRewardssAMZNBalancer_RewardPaid_event

Reward distribution events from Synthetix V1’s sAMZN-Balancer staking pool on Ethereum, tracking when users claim their staking incentives. Records include user addresses and reward amounts in wei for analyzing liquidity mining participation and yield distribution for the synthetic Amazon stock token pool.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xdc338c7544654c7dadfeb7e44076e457963113b0	0x657e21723ae99c05c9c2a6032343c7865bcb1940	false	560681702708881011046	131	12602156	2021-06-09T19:21:08.000Z	0x50caa92276829d8fdb97681e6d001ac739d84e8cdd426ca81c41b9833d32e738
0xdc338c7544654c7dadfeb7e44076e457963113b0	0x0716266cc5d3c443e30b0c4e9c72afa33778e1de	false	129595334258832537427	127	12598515	2021-06-09T05:38:03.000Z	0x860651e41e5f27f17651744e4724be9aecfed461d8a76656388f770b06b73448
0xdc338c7544654c7dadfeb7e44076e457963113b0	0xc292eafd5422a9c961cc2630cbddf04c93db33bd	false	19195551982730698955	277	12541209	2021-05-31T08:57:17.000Z	0xd4a4d155299dfd1d3eefa5d218a945dd2e76530a1daec6783c439ed391f215ac

Example Query

Query with partition filter

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

StakingRewardssBTCCurve_RewardPaid_event

Reward distribution events from Synthetix v1 sBTC Curve staking contract on Ethereum, recording SNX token payouts to liquidity providers. Tracks individual reward claims with user addresses and reward amounts for analyzing incentive program participation.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x13c1542a468319688b89e323fe9a3be3a90ebb27	0x02062b8727cdde62cd784382c60d738fcdbb736d	false	5882678779583550	62	10594989	2020-08-04T18:44:25.000Z	0xff8a810c26effeee93d3d68581d7363737121ea356f22822335f467fbacb47e5
0x13c1542a468319688b89e323fe9a3be3a90ebb27	0x0346102313365e34877b27e460f15d1381bfe79d	false	6557116332305	127	10595718	2020-08-04T21:29:45.000Z	0x55b2acb93eeb7b0a04bd70650470db5a428e19e9e2fc4f539e0ae6aa5a78df23
0x13c1542a468319688b89e323fe9a3be3a90ebb27	0x0549ae0aca68d11f35c5f8dbe7ae126809f129bf	false	74450361454294	208	10595249	2020-08-04T19:43:29.000Z	0x4ac6884e07ed1129931ebbae1d847cc0e084308683357a68eab7f3f11efc158b

Example Query

Query with partition filter

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

StakingRewardssCOINBalancer_RewardPaid_event

Reward distribution events from Synthetix V1’s sCOIN-Balancer liquidity pool staking contract on Ethereum, recording user addresses and reward amounts (in wei) when stakers claim their incentives. Used for analyzing staking reward patterns and liquidity provider returns.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x1c1d97f6338759ab814a5a717ae359573ab5d5d4	0x09482d9d4797808d0789670f7bdea23caf7f3dfe	false	647285952954189433065	165	12451649	2021-05-17T11:33:54.000Z	0x54955c8051a791acc19e796ba8cac041522bc0677d515fd9663679f960b5787c
0x1c1d97f6338759ab814a5a717ae359573ab5d5d4	0x21e4920bfece1009fd55958b50da12c72c3a7140	false	134255755210074436179	256	12569205	2021-06-04T16:52:27.000Z	0xb84e31e2178cbd05d6ed24139886d51458cd0a994ba5725b5369d554479e5145
0x1c1d97f6338759ab814a5a717ae359573ab5d5d4	0x7f960b97b12ef8b6828529e961f6646ad764d90b	false	786709526178122423483	94	12390129	2021-05-07T23:23:26.000Z	0xa6ac72ac102689d405e9465234ef53640a227bcf7350778f81dbd42337f26ace

Example Query

Query with partition filter

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

StakingRewardssETHUniswapV1_RewardPaid_event

Reward distribution events from Synthetix V1’s sETH Uniswap V1 liquidity pool staking contract on Ethereum. Records individual reward claims with user addresses and SNX token amounts paid for analyzing liquidity mining incentive distributions.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x48d7f315fedcad332f68aafa017c7c158bc54760	0x1fcfd25b25ccead63665cf867f4f7cba3e75de64	false	71611445095748347984	10	9819009	2020-04-06T14:16:13.000Z	0x6c6ca739f188a184e92daf4eb0c77e1ad8f7fe48551ce20dafc0f56b403bd92c
0x48d7f315fedcad332f68aafa017c7c158bc54760	0xb153806801f1826a3ae0c14981b0d9e60f1f3d19	false	340209488937591954	24	9818381	2020-04-06T12:03:33.000Z	0x518525ef3c47cf8b09b8c74175e07f3093d04a7a02b07cd610cddd22a448c36d
0x48d7f315fedcad332f68aafa017c7c158bc54760	0xfadafce89ea2221fa33005640acf2c923312f2b9	false	31072294392283623405	24	9821375	2020-04-06T23:12:34.000Z	0xfb3c239554f1548d519605b91fdc0148580a9c49be7f477b8ccfca3117cf27d5

Example Query

Query with partition filter

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

StakingRewardssEURCurve_RewardPaid_event

Reward distribution events from Synthetix V1’s sEUR Curve liquidity pool staking contract on Ethereum. Tracks when users claim SNX or other incentive tokens for providing liquidity to the sEUR/EUR Curve pool.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xc0d8994cd78ee1980885df1a0c5470fc977b5cfe	0x90bb609649e0451e5ad952683d64bd2d1f245840	false	102182539682504922504	9	11745117	2021-01-28T15:33:29.000Z	0xf5d6c2c33b76ee8c84b4913fc2688750b1825e321419b08ecf50f64a9a4e8f24
0xc0d8994cd78ee1980885df1a0c5470fc977b5cfe	0x90bb609649e0451e5ad952683d64bd2d1f245840	false	1256613756585946282	24	11743676	2021-01-28T10:06:21.000Z	0xb5eaa79335e6b5ee2b226f6bfbb9f3b4840da6503d4df94f7d185c860ba308da
0xc0d8994cd78ee1980885df1a0c5470fc977b5cfe	0x90bb609649e0451e5ad952683d64bd2d1f245840	false	10886243386238968044	29	11746746	2021-01-28T21:20:15.000Z	0x2c23de8ab8c9101cce74134411d1dae230f60e33d14e097f192b60c653741039

Example Query

Query with partition filter

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

StakingRewardssFBBalancer_RewardPaid_event

Reward payment events from Synthetix V1’s Balancer pool staking rewards contract on Ethereum, tracking SNX (Synthetix Network Token) incentive distributions to liquidity providers. Used for analyzing staking yields and user participation in Balancer pool liquidity mining programs.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x26fa0665660c1d3a3666584669511d3c66ad37cb	0x2f6119e04d7766b6b867b62a6d54318346b47afe	false	11453744388430629598	166	12455395	2021-05-18T01:25:04.000Z	0x55a87af006bd7438073f808c83300d6b83a9ef552d58187c9d23de1e9f56322a
0x26fa0665660c1d3a3666584669511d3c66ad37cb	0xef9af12bf7c5a32d7461d011c4ce9124d73f52a0	false	887848488498146165027	404	12459386	2021-05-18T16:10:06.000Z	0x1efea75791db88212d2c004d7e6d9713be61da055f740508d63fd6a4ac4957ba
0x26fa0665660c1d3a3666584669511d3c66ad37cb	0xe9947f9d6137be1efc8525384c49e964aeb4bcd9	false	506706427214923793659	205	12588525	2021-06-07T16:42:30.000Z	0xfec836c248980e85d22bb7d48162c85d39072a77c978c2b8bb11173dc7b5ebf7

Example Query

Query with partition filter

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

StakingRewardssGOOGBalancer_RewardPaid_event

Reward claim events from Synthetix v1’s sGOOG-Balancer staking rewards contract on Ethereum, tracking SNX token payouts to liquidity providers. Useful for analyzing yield farming participation and reward distribution patterns for the synthetic Google stock pool.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x6fb7f0e78582746bd01bcb6dfbfe62ca5f4f9175	0xf0f225e01cf084d3c246ad595ab60d0d4f5b4c78	false	13460188604986225736	81	12299391	2021-04-23T23:14:28.000Z	0x28d537b48ea6d6d3aca49ab73e86817e0596975542468b3e366b914d0bf4dd33
0x6fb7f0e78582746bd01bcb6dfbfe62ca5f4f9175	0x7f960b97b12ef8b6828529e961f6646ad764d90b	false	909326631856705136135	129	12486511	2021-05-22T21:20:45.000Z	0x5c089a3b18ec419e10cf9ee26f13c59399dbd322ecfcb665a94d2621fd784298
0x6fb7f0e78582746bd01bcb6dfbfe62ca5f4f9175	0x16f037a3ddf53da1b047a926e1833219f0a8e1fc	false	194859151993896703170	276	12591793	2021-06-08T04:39:27.000Z	0x064dabe207c5dc2c680aeab85620f3d569e8a6ced7ea1b0167dbc68d682210eb

Example Query

Query with partition filter

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

StakingRewardssMSFTBalancer_RewardPaid_event

Reward claim events from Synthetix V1’s sMSFT (synthetic Microsoft stock) Balancer pool staking contract on Ethereum. Tracks individual reward payouts to liquidity providers with user addresses and reward amounts in wei.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x9d003cc298e7ea141a809c241c0a703176da3ba3	0x75a35f615cb1bc590e83fbbbc1fe10aa7b58fdc1	false	29888373408293712325	192	12375647	2021-05-05T17:44:20.000Z	0x441450b2e87b8f0910ece69b664d20dc0b3c9a414519f1d88724c66c9f618c6e
0x9d003cc298e7ea141a809c241c0a703176da3ba3	0x21e4920bfece1009fd55958b50da12c72c3a7140	false	115984039773062602264	313	12569217	2021-06-04T16:54:52.000Z	0x78bd44727a5cccceaa60c5ffd9179067556bf5259fe91b15d165fb9ea5fa616b
0x9d003cc298e7ea141a809c241c0a703176da3ba3	0xa982bbdaf783eb7c3914d988b7e2a0be865ccb53	false	116848593172522584601	318	12518363	2021-05-27T20:03:16.000Z	0xaeb6f9d13604e8b1bf08a68646c47acb6967bb3cf2c19b3510550b827c1f7b45

Example Query

Query with partition filter

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

StakingRewardssNFLXBalancer_RewardPaid_event

Reward distribution events from Synthetix V1’s sNFLX Balancer pool staking contract on Ethereum. Captures individual reward payouts to liquidity providers with reward amounts in wei for analyzing yield farming participation and incentive distribution.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x8ef8ca2acaaafec19fb366c11561718357f780f2	0x2f34ee226e149a1fe2d03e883df9544d84c1c47c	false	115360424670527975783	253	12563667	2021-06-03T20:31:07.000Z	0xbcc15439948707e319f597a9518bc22326aae930da50ce17d147a479832b4b46
0x8ef8ca2acaaafec19fb366c11561718357f780f2	0x0f45156f109e474295913d78036fa213b1745d5a	false	23107073182441752167	171	12364890	2021-05-04T01:49:46.000Z	0x75d36763669f5041cd6560bcade44a99a94c6d739f56c59145ba45986de28233
0x8ef8ca2acaaafec19fb366c11561718357f780f2	0xfe3befecec12d396be61f3483ee029171751ec07	false	34243148080093193471	40	12640356	2021-06-15T17:20:36.000Z	0x9d3f1cfeef97aba855a51e8ca97cec8c4f3a64d64549237a64ef902a5c7a5430

Example Query

Query with partition filter

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

StakingRewardsSNXBalancer_RewardPaid_event

SNX (Synthetix Network Token) reward distribution events from the Synthetix v1 staking contract for Balancer liquidity providers on Ethereum. Tracks individual reward claims with user addresses and token amounts denominated in wei for analyzing liquidity mining incentive payouts.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xfbaedde70732540ce2b11a8ac58eb2dc0d69de10	0xec5f9994ebe1bdeaa009cb0a3e984c5c55bf3fdd	false	9711091647845689696	8	10387085	2020-07-03T14:50:42.000Z	0xbe19eb7bba12336afe7713cdf913b6de1699affb975e035ec2475140f739c2c2
0xfbaedde70732540ce2b11a8ac58eb2dc0d69de10	0x0f8eae6c2597fdaff296382eb5ce923008426508	false	13014016346082666008231	15	10386361	2020-07-03T12:11:28.000Z	0x4be0bf6d5cb4ca6fdd43a054711c8cfcf0a53936adce8340d2fb01cc039d423a
0xfbaedde70732540ce2b11a8ac58eb2dc0d69de10	0xe58585b22cc2ac4270a2b92c2d2d8c5db5a3330e	false	19739468288372008501	19	10385678	2020-07-03T09:28:09.000Z	0x93068233fa3b8eb5d3f51b37b4a4c3c641f8162ba62d99f94158f6b85beefffc

Example Query

Query with partition filter

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

StakingRewardssTSLABalancer_RewardPaid_event

Reward claim events from Synthetix V1’s sTSLA-Balancer staking rewards contract on Ethereum, recording SNX token payouts to liquidity providers. Used for tracking staking incentive distributions and individual user earnings from the Tesla synthetic asset liquidity pool.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xf0de877f2f9e7a60767f9ba662f10751566ad01c	0xdb611d682cb1ad72fcbacd944a8a6e2606a6d158	false	196261767782427146213	258	11986959	2021-03-06T20:11:26.000Z	0x5625174e53bc177a5bd1fa1ac2c83f6b93a312070e1cd8c32fb4566077c61de3
0xf0de877f2f9e7a60767f9ba662f10751566ad01c	0xe9883b15b321f3f381e9fafd1277a98e1e5d86f7	false	159771484551692157212	132	11984377	2021-03-06T10:41:57.000Z	0x1ecf5c198d08065369a77d64a2b67277b4a87aa9a7a55730f48526dcee87b66b
0xf0de877f2f9e7a60767f9ba662f10751566ad01c	0x9bdce66d77c5653b370a62d7f1b0f7574860edb2	false	142673322242926341230	192	11891797	2021-02-20T04:52:39.000Z	0x200b30a75c60622ce54c1d9d663c3de4c57808877e2df361dcc5a28f44402837

Example Query

Query with partition filter

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

StakingRewardssUSDCurve_RewardPaid_event

Reward distribution events from Synthetix V1’s sUSD Curve pool staking contract on Ethereum. Records individual reward payments to liquidity providers with amounts in wei for analyzing staking yield distribution and participant activity.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xdcb6a51ea3ca5d3fd898fd6564757c7aaec3ca92	0xc54db577897b82933634ed1cee5d61d9d5a701d5	false	5710813210572821816	1	10543731	2020-07-27T20:46:27.000Z	0x769c6a75c58d103d812dbbe81287a907f8aef8cfa55d2b0bfdedba430a00519e
0xdcb6a51ea3ca5d3fd898fd6564757c7aaec3ca92	0x5d3183cb8967e3c9b605dc35081e5778ee462328	false	2444970794670874957776	1	10542329	2020-07-27T15:21:32.000Z	0x9a2b7dcd6e817f17906668111273624f4929ac4049b7bbbb54a3d2ffb45e3893
0xdcb6a51ea3ca5d3fd898fd6564757c7aaec3ca92	0xcfc579300d3e8016c70147a37c48cc6467daee98	false	379709979565231275	262	10542340	2020-07-27T15:22:55.000Z	0x36f1526cc2e5d4ad1976036369e3dd663dd19336d19c99a84321f376c3bd403a

Example Query

Query with partition filter

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

StakingRewardssXAUUniswapV2_RewardPaid_event

Reward claim events from Synthetix V1 staking contract for sXAU (synthetic gold) Uniswap V2 liquidity providers on Ethereum. Tracks individual reward payouts to liquidity providers with claim amounts and recipient addresses for analyzing staking incentive distribution.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x8302fe9f0c509a996573d3cc5b0d5d51e4fdd5ec	0xa340143f3bf37edd230816cdfed6199151debf52	false	164659485636786902273	27	10366697	2020-06-30T10:59:49.000Z	0x1e5f9fdab354988b8a7cdad227db02e7316a9116db9593b1a41f49c454173f28
0x8302fe9f0c509a996573d3cc5b0d5d51e4fdd5ec	0x13fcb7b29f135d3740ca8c6e3f775df6994a3d8e	false	33730113627001536105	52	10370225	2020-06-30T23:47:14.000Z	0x5ba373657be72d0a1cef63e03f16f77962f3992a4303ac720daea4c23fcb9dd8
0x8302fe9f0c509a996573d3cc5b0d5d51e4fdd5ec	0xf12a175ffa3d47f6d68b4875a21ea48db3c33588	false	66987328899409391486	105	10369784	2020-06-30T22:13:31.000Z	0x0c3c6760952a5db4f7d4524d3c8bd2f4449163fe83c8c924f2fd5f98bfb518a9

Example Query

Query with partition filter

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

sUSD_Burned_event

sUSD burn events from Synthetix V1 protocol on Ethereum, recording when synthetic USD stablecoins are destroyed by user accounts. Useful for tracking debt repayment, position closures, and sUSD supply changes in the Synthetix ecosystem.

Columns

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

Sample Data

address	removed	in_value	log_index	in_account	block_number	block_timestamp	transaction_hash
0x57ab1ec28d129707052df4df418d58a2d46d5f51	false	1500000000000000000000	658	0xfd81b27d9796a1ba7d7171ea70010c9befb2a62a	18313522	2023-10-09T14:30:11.000Z	0xeb4c0e46e582ec3369bb60ec2273b2dc03fb62ff813ca26fd3d86ef00ec7b962
0x57ab1ec28d129707052df4df418d58a2d46d5f51	false	103369626946273097858	181	0xe37e799d5077682fa0a244d46e5649f71457bd09	18311381	2023-10-09T07:19:11.000Z	0xbaa1ca45848f34bc724dbfa2f0f9dfea11e3fd3ecf3fbc20859f5823267d1060
0x57ab1ec28d129707052df4df418d58a2d46d5f51	false	23358587450000000000	251	0xd3ad72af19df2633e25f1370036a501b21232ed7	18310809	2023-10-09T05:23:59.000Z	0x2db8cc030999b898a9608d3b113d3e2a92b92c4f388427a7071522afe449eda8

Example Query

Query with partition filter

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

sUSD_Issued_event

sUSD minting events from Synthetix V1 protocol on Ethereum, tracking when users issue synthetic USD stablecoin against their collateral. Records account addresses and issued amounts in wei (18 decimals) for analyzing protocol debt creation and user minting behavior.

Columns

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

Sample Data

address	removed	in_value	log_index	in_account	block_number	block_timestamp	transaction_hash
0x57ab1ec28d129707052df4df418d58a2d46d5f51	false	30693258200248662384	3	0xb56b77df9e5001028711cfc20c8aa3aaa9d851db	10379315	2020-07-02T09:51:22.000Z	0x1f2b0715203b264866bdcc79363886690e800dc2c7266384396b7d8ed43b0fcb
0x57ab1ec28d129707052df4df418d58a2d46d5f51	false	200000000000000000000	4	0x65447778c02ac5cb611bd8d952e3aa77eab48446	10377764	2020-07-02T04:08:28.000Z	0x9f88fffbca6e00152e21339ada674e95b9ab7f20d3a00eb9a729363da166b02f
0x57ab1ec28d129707052df4df418d58a2d46d5f51	false	1500000000000000000000	5	0x2debdf4427ccbcfdbc7f29d63964499a0ec184f6	10379428	2020-07-02T10:18:46.000Z	0xb182cc1f0dbd39205cf7cb5c5575e50f81c3c5071c47f66718d74893cd52b306

Example Query

Query with partition filter

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

SynthetixDebtShares_Burn_event

Debt share burn events from Synthetix V1 on Ethereum, recording when users reduce their protocol debt position by burning debt shares. Tracks account addresses and burn amounts for analyzing debt pool participation and liquidation activity.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x89fcb32f29e509cc42d0c8b6f058c993013a843f	false	15340889347455223535	305	0x6c9228905928ca1a0cf678e159104a1506a8aa8f	18291473	2023-10-06T12:30:59.000Z	0x88738fbcb1f35fa0c2e8b9d7741eed5b5270ca3afa44e719a76a253bafa4de14
0x89fcb32f29e509cc42d0c8b6f058c993013a843f	false	242053650079916232363	305	0x70bcca115bbfe0ced96c672f2db987c5f71c8db3	18294148	2023-10-06T21:29:47.000Z	0xda4feb8147618038ca798d54b4272dccd473eb09ced5cce9e635db7c2a6075d5
0x89fcb32f29e509cc42d0c8b6f058c993013a843f	false	33063586715106477475	191	0xf5395120d09cf2182a5a9eb69fc2e2be1131ca38	18293851	2023-10-06T20:29:47.000Z	0x82fd51e3fa7cffdd172b723b7168d2dbfcd9bd2d247aaab83aa59d30376e7845

Example Query

Query with partition filter

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

SynthetixDebtShares_Mint_event

Debt share issuance events from Synthetix V1 protocol on Ethereum, tracking when users mint sUSD stablecoins by staking SNX collateral. Records the minted debt share amount and account address for analyzing protocol debt pool participation and staking behavior.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x89fcb32f29e509cc42d0c8b6f058c993013a843f	false	24060856799039861824	88	0x4c2b52daf92944d99a6cddcf3c697e16a2638600	16887089	2023-03-23T01:49:11.000Z	0x1e12aa2aff3afc29dbcb6850eadcdf88d9b9ac6f6600845b15c3555bfe44c640
0x89fcb32f29e509cc42d0c8b6f058c993013a843f	false	1175584410954050711	70	0x7e215eecea18bb1adacf2c00df6c61f9ab5457f9	16888999	2023-03-23T08:16:47.000Z	0x0b87349d631426cc9a30acccd98a48f316b9ef920fef3b3395a07402a7d9833b
0x89fcb32f29e509cc42d0c8b6f058c993013a843f	false	968353617924051429572	53	0x94ee11855595a6a355c93eb938b87b08b13b57b7	16892259	2023-03-23T19:16:59.000Z	0x7704aef5f7a0b8a76afbc228d9250182922abf96fb21ee932c845d3dcf59018c

Example Query

Query with partition filter

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

SynthSNX10_burnSynths_function

Synthetic asset burn transactions from Synthetix V1 sNX10 contract on Ethereum, capturing attempts to destroy synths and reduce debt positions. Includes both successful and failed burn operations with transaction details and gas consumption for analyzing debt management patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_currencyKey`	`STRING`	The currency key identifier for the synthetic asset being burned in the Synthetix protocol. This column is null in all sample transactions, indicating it may only be populated for specific burn operation types or deprecated functionality.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
1000000	false	37447	0xea168b62	0x22a67ecd108f7a6fc52da9e2655ddfe88eccd9ca	8986182	0xc0fb2a3be460a9a027ab55b947f8461402284f7d	2019-11-23T11:36:33.000Z	0x7898e79d8094a46a45862edd9399fd71cdc3d07aa5a8b180f2719948aaeb1ebd
1000000	false	37453	0xea168b62	0x22a67ecd108f7a6fc52da9e2655ddfe88eccd9ca	8985322	0xc0fb2a3be460a9a027ab55b947f8461402284f7d	2019-11-23T08:12:26.000Z	0x289683ed5e2ef3d1647b12ea31039177bb33be37f6c0afb58b157cb09244c063
1000000	false	37453	0xea168b62	0x22a67ecd108f7a6fc52da9e2655ddfe88eccd9ca	8985362	0xc0fb2a3be460a9a027ab55b947f8461402284f7d	2019-11-23T08:22:26.000Z	0x2bb855c787df6d3eba37c714fc0447fae343669e799b2ca3ebc0cb285a0e26e3

Example Query

Query with partition filter

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

SynthSNX10_issueSynths_function

Attempted calls to the issueSynths function on Synthetix v1 SynthSNX10 contract on Ethereum, capturing both successful and failed synthetic asset minting transactions. Useful for analyzing SNX staking behavior and protocol interaction patterns during the v1 era.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_currencyKey`	`STRING`	Currency key identifier for the synthetic asset being issued in Synthetix V1, typically a bytes32 encoded string like sUSD or sETH. This field is null in all sample transactions, suggesting failed function calls that did not process input parameters.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
1000000	false	44999	0x0ee54a1d	0x22a67ecd108f7a6fc52da9e2655ddfe88eccd9ca	9001688	0xc0fb2a3be460a9a027ab55b947f8461402284f7d	2019-11-26T01:56:35.000Z	0xb724a13e952870593f806571be7f63df708a25b6ce3e8663560d55471ee77d19
1000000	false	45069	0x0ee54a1d	0x22a67ecd108f7a6fc52da9e2655ddfe88eccd9ca	9003012	0xc0fb2a3be460a9a027ab55b947f8461402284f7d	2019-11-26T07:38:44.000Z	0xa18624a21ce296bfd4396507b13bf245b4d00779cdcb2c1eaf81e7c04246436e
1000000	false	45127	0x0ee54a1d	0x22a67ecd108f7a6fc52da9e2655ddfe88eccd9ca	9002859	0xc0fb2a3be460a9a027ab55b947f8461402284f7d	2019-11-26T06:58:25.000Z	0xc9baa1ce0b32fde261d3343c41ac2effaef23f62e76f3006a234871df88b2f40

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

FeePool_FeesClaimed_event

ShortingRewardssBTC_RewardPaid_event

ShortingRewardssETH_RewardPaid_event

SNX_AtomicSynthExchange_event

SNX_SynthExchange_event

StakingDualRewards_RewardPaid_event

StakingRewardsiBTC_RewardPaid_event

StakingRewardsiETH_RewardPaid_event

StakingRewardssAAPLBalancer_RewardPaid_event

StakingRewardssAMZNBalancer_RewardPaid_event

StakingRewardssBTCCurve_RewardPaid_event

StakingRewardssCOINBalancer_RewardPaid_event

StakingRewardssETHUniswapV1_RewardPaid_event

StakingRewardssEURCurve_RewardPaid_event

StakingRewardssFBBalancer_RewardPaid_event

StakingRewardssGOOGBalancer_RewardPaid_event

StakingRewardssMSFTBalancer_RewardPaid_event

StakingRewardssNFLXBalancer_RewardPaid_event

StakingRewardsSNXBalancer_RewardPaid_event

StakingRewardssTSLABalancer_RewardPaid_event

StakingRewardssUSDCurve_RewardPaid_event

StakingRewardssXAUUniswapV2_RewardPaid_event

sUSD_Burned_event

sUSD_Issued_event

SynthetixDebtShares_Burn_event

SynthetixDebtShares_Mint_event

SynthSNX10_burnSynths_function

SynthSNX10_issueSynths_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​FeePool_FeesClaimed_event

​ShortingRewardssBTC_RewardPaid_event

​ShortingRewardssETH_RewardPaid_event

​SNX_AtomicSynthExchange_event

​SNX_SynthExchange_event

​StakingDualRewards_RewardPaid_event

​StakingRewardsiBTC_RewardPaid_event

​StakingRewardsiETH_RewardPaid_event

​StakingRewardssAAPLBalancer_RewardPaid_event

​StakingRewardssAMZNBalancer_RewardPaid_event

​StakingRewardssBTCCurve_RewardPaid_event

​StakingRewardssCOINBalancer_RewardPaid_event

​StakingRewardssETHUniswapV1_RewardPaid_event

​StakingRewardssEURCurve_RewardPaid_event

​StakingRewardssFBBalancer_RewardPaid_event

​StakingRewardssGOOGBalancer_RewardPaid_event

​StakingRewardssMSFTBalancer_RewardPaid_event

​StakingRewardssNFLXBalancer_RewardPaid_event

​StakingRewardsSNXBalancer_RewardPaid_event

​StakingRewardssTSLABalancer_RewardPaid_event

​StakingRewardssUSDCurve_RewardPaid_event

​StakingRewardssXAUUniswapV2_RewardPaid_event

​sUSD_Burned_event

​sUSD_Issued_event

​SynthetixDebtShares_Burn_event

​SynthetixDebtShares_Mint_event

​SynthSNX10_burnSynths_function

​SynthSNX10_issueSynths_function

Tables

FeePool_FeesClaimed_event

ShortingRewardssBTC_RewardPaid_event

ShortingRewardssETH_RewardPaid_event

SNX_AtomicSynthExchange_event

SNX_SynthExchange_event

StakingDualRewards_RewardPaid_event

StakingRewardsiBTC_RewardPaid_event

StakingRewardsiETH_RewardPaid_event

StakingRewardssAAPLBalancer_RewardPaid_event

StakingRewardssAMZNBalancer_RewardPaid_event

StakingRewardssBTCCurve_RewardPaid_event

StakingRewardssCOINBalancer_RewardPaid_event

StakingRewardssETHUniswapV1_RewardPaid_event

StakingRewardssEURCurve_RewardPaid_event

StakingRewardssFBBalancer_RewardPaid_event

StakingRewardssGOOGBalancer_RewardPaid_event

StakingRewardssMSFTBalancer_RewardPaid_event

StakingRewardssNFLXBalancer_RewardPaid_event

StakingRewardsSNXBalancer_RewardPaid_event

StakingRewardssTSLABalancer_RewardPaid_event

StakingRewardssUSDCurve_RewardPaid_event

StakingRewardssXAUUniswapV2_RewardPaid_event

sUSD_Burned_event

sUSD_Issued_event

SynthetixDebtShares_Burn_event

SynthetixDebtShares_Mint_event

SynthSNX10_burnSynths_function

SynthSNX10_issueSynths_function