synthetix_v1_optimism

Tables

AccessControlledOffchainAggregator_AnswerUpdated_event

Chainlink oracle price feed update events emitted when off-chain aggregators submit new data on-chain. Contains the updated answer value, round identifier, and timestamp for tracking oracle price movements and data freshness across decentralized oracle networks.

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_current`	`STRING`	Current oracle data value reported in the price feed update. Numeric string representing the latest aggregated data point from the oracle network.
`in_roundId`	`STRING`	Sequential identifier for the oracle price update round. Numeric string that increments with each new data submission to the aggregator contract.
`in_updatedAt`	`STRING`	Unix timestamp when the oracle data was last updated. Numeric string representing seconds since epoch.

Sample Data

address	removed	log_index	in_current	in_roundId	block_number	in_updatedAt	block_timestamp	transaction_hash
0x0d5642c6329adb3246c13d78b429a9fb1965a0d8	false	2	1122213988709478835143839969	6819	10729437	1654509800	2022-06-06T10:03:20.000Z	0xb9b48510fff215e5a027f7e79382bdd9aa373cacc6dc6a0d97dfa4c114de51de
0x0d5642c6329adb3246c13d78b429a9fb1965a0d8	false	2	1119943452014784567493469295	6812	10720873	1654502864	2022-06-06T08:07:44.000Z	0xe0bf8c12e7fb8bb17b6f78eb74855c87f9926d1c008b0ee41e5de4392efe98df
0x0d5642c6329adb3246c13d78b429a9fb1965a0d8	false	2	1116324145859151891179245199	6847	10765239	1654539504	2022-06-06T18:18:24.000Z	0x5bca82ad0132daf07a5061609a16cdd6231c3642d1a3f53a66e4cacc6e97d749

Example Query

Query with partition filter

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

AddressResolver_AddressImported_event

Contract address registry updates from Synthetix v1 protocol on Optimism, tracking when named contract references (Issuer, FeePool, Liquidator, ExchangeRates) are imported or modified in the AddressResolver system. Used for monitoring protocol upgrades and contract dependency changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_name	removed	log_index	block_number	in_destination	block_timestamp	transaction_hash
0x95a6a3f44a70172e7d50a9e28c85dfd712756b8c	0x4973737565720000000000000000000000000000000000000000000000000000	false	11	74503564	0x52c4612dbb84282332300a5cdaba7acd7661a94b	2023-02-15T15:07:38.000Z	0xb309b3f06dc3d311940518e5ff3d1a0e9a20fd042d68afdf7d208582d317d25b
0x95a6a3f44a70172e7d50a9e28c85dfd712756b8c	0x466565506f6f6c00000000000000000000000000000000000000000000000000	false	10	74503564	0xf9fe3607e6d19d8dc690dd976061a91d4a0db30b	2023-02-15T15:07:38.000Z	0xb309b3f06dc3d311940518e5ff3d1a0e9a20fd042d68afdf7d208582d317d25b
0x95a6a3f44a70172e7d50a9e28c85dfd712756b8c	0x53796e7468657469780000000000000000000000000000000000000000000000	false	8	44284444	0x49b35be7d96888c02f342552ab218d859599aceb	2022-12-01T13:44:37.000Z	0x1d4219d58bccc2830ccc9cf269749a2f8e448f1048df64ee19d1d4e08f0e0e6d

Example Query

Query with partition filter

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

FeePool_FeesClaimed_event

Fee claim events from Synthetix V1 protocol on Optimism, recording when stakers collect their sUSD trading fees and SNX staking rewards. Used to analyze fee distribution, staker behavior, and reward claiming patterns across the protocol.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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) fees claimed by the staker in this transaction. Denominated in wei (18 decimal places), representing the USD-denominated portion of trading fee rewards.
`in_snxRewards`	`STRING`	Amount of SNX tokens rewarded to the fee claimer, denominated in wei (18 decimals). Values represent staking incentives distributed alongside sUSD fees for participating in the Synthetix protocol.

Sample Data

address	removed	log_index	in_account	block_number	in_sUSDAmount	in_snxRewards	block_timestamp	transaction_hash
0x4a16a42407aa491564643e1dfc1fd50af29794ef	false	5	0xbee2d469aacb46251ae33cca91f482e26c971dff	2085491	451141710663008345	759909270405581337	2022-01-08T05:58:24.000Z	0x7d5ffd5847fb0d62711caa0600f9808621c0581941c5670fa0fb2f1365275654
0x4a16a42407aa491564643e1dfc1fd50af29794ef	false	5	0xf286e07ed6889658a3285c05c4f736963cf41456	2090487	618136504220223682	1041197585660443676	2022-01-08T10:10:40.000Z	0x0f43864e1215ec03b8295d97276ad8f635287983543ca19caed0d6d5b394b1da
0x4a16a42407aa491564643e1dfc1fd50af29794ef	false	5	0x35714b9bbd64c5911e5897a50672e24055c2ea70	2096365	661561134154073260	1114342626499536625	2022-01-08T14:00:20.000Z	0x172acdbb6821d263015c6e00662daa955d31cc782458037d54a481d6a458493f

Example Query

Query with partition filter

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

FuturesMarket_FuturesTracking_event

Futures position changes tracked with referral codes on Synthetix v1 perpetuals protocol on Optimism. Contains position size deltas, fees, market identifiers, and tracking codes (referral sources) for analyzing trading volume attribution and fee generation by integration partner.

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_trackingCode`	`STRING`	Identifier used to track the source or referrer of the perpetual futures trade. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros.
`in_baseAsset`	`STRING`	Symbol identifier for the underlying asset of the futures market. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros.
`in_marketKey`	`STRING`	Identifier for the perpetual futures market being tracked. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros, representing the market symbol with ‘s’ prefix (e.g., 0x7345544850455250 for sETHPERP).
`in_sizeDelta`	`STRING`	Change in position size denominated in USD. String-encoded integer value representing the delta in smallest unit with extended precision (30 decimal places).
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	removed	log_index	block_number	in_baseAsset	in_marketKey	in_sizeDelta	block_timestamp	in_trackingCode	transaction_hash
17752181890272715597	0x001b7876f567f0b3a639332ed1e363839c6d85e2	false	3	13513006	0x4141564500000000000000000000000000000000000000000000000000000000	0x7341415645000000000000000000000000000000000000000000000000000000	72002592259225922592	2022-06-30T06:34:33.000Z	0x4b57454e54410000000000000000000000000000000000000000000000000000	0x3befcede0b9b035b2aeb5106e344af545abc322689cadfc7fc12a00f5af876f7
20469020678874279000	0x001b7876f567f0b3a639332ed1e363839c6d85e2	false	3	13570473	0x4141564500000000000000000000000000000000000000000000000000000000	0x7341415645000000000000000000000000000000000000000000000000000000	71863231597845601436	2022-06-30T23:48:58.000Z	0x4b57454e54410000000000000000000000000000000000000000000000000000	0x8b25db4788c63614f68d789f26994d034879d36d1ef0624af2f418c93da2b160
18415763494495238624	0x001b7876f567f0b3a639332ed1e363839c6d85e2	false	3	13541091	0x4141564500000000000000000000000000000000000000000000000000000000	0x7341415645000000000000000000000000000000000000000000000000000000	74958034877179823739	2022-06-30T14:12:27.000Z	0x4b57454e54410000000000000000000000000000000000000000000000000000	0xc9c546d15ec1f6dd25e0dd6a6ce012601b50ec1f6aeb171ef7d9bce2594512cd

Example Query

Query with partition filter

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

FuturesMarket_PositionLiquidated_event

Liquidation events from Synthetix v1 perpetual futures markets on Optimism, recording when undercollateralized positions are force-closed with position details, liquidation fees, and liquidator addresses. Used for analyzing liquidation cascades, keeper profitability, and market stress periods.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_size`	`STRING`	Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_id	in_fee	address	in_size	removed	in_price	log_index	in_account	block_number	in_liquidator	block_timestamp	transaction_hash
320	19452664170517141725	0x1228c7d8bbc5bc53db181bd7b1fce765aa83bf8a	563110845868205000000	false	9870000000000000000	4	0x66b259b9e072e1ae256e738dac2ebc25044178de	7393343	0x4a684b70a83ea656cfd3a0d257fcbd97e84bbd04	2022-05-08T17:10:01.000Z	0x12fce61c684adceae5517ed58fbb2f306f49a6daf432b85e0f15c29ed1145e09
25	8930250000000000000	0x4ff54624d5fb61c34c634c3314ed3bfe4dbb665a	50000000000000000000	false	51030000000000000000	4	0x8c0e7049bd05d1521d5a568295f530057c516e75	7392903	0x256343832ac6efde5424da9dc797fcc2b0861b0d	2022-05-08T17:07:31.000Z	0x2f49824c594f58f4c522fac74421f60e1f0ce0b0b50928f3cab9143e0eb3e3cf
71	5000000000000000000	0x4ff54624d5fb61c34c634c3314ed3bfe4dbb665a	5000000000000000000	false	51981752380000000000	4	0x54cf78c31739b97f87381b19937d13f04dc9819f	7378919	0x51f4cf25a1212ce0c76742050b35f28cdb851cf7	2022-05-08T13:57:17.000Z	0x619469090016ec33f54bb27d4574afac6bf541ee00c9e66277ec4ef017e56054

Example Query

Query with partition filter

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

FuturesMarket_PositionModified_event

Position modification events from Synthetix v1 perpetual futures markets on Optimism, capturing changes to trader positions including size, margin, fees, and execution price. Used for tracking position lifecycle, funding rate impacts, and trader PnL (profit and loss) analysis.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_margin`	`STRING`	Margin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency.
`in_size`	`STRING`	Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value.
`in_tradeSize`	`STRING`	Quantity change applied to the position in the derivative contract. String-encoded integer value representing the delta in position size, with negative values indicating position decreases and positive values indicating increases.
`in_lastPrice`	`STRING`	Price of the underlying asset at the time of position modification. String-encoded integer value representing the price in the smallest unit with 18 decimal precision.
`in_fundingIndex`	`STRING`	Index value tracking cumulative funding rate adjustments for perpetual futures positions. Numeric string representation of the funding rate counter at the time of position modification.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_id	in_fee	address	in_size	removed	in_margin	log_index	in_account	block_number	in_lastPrice	in_tradeSize	block_timestamp	in_fundingIndex	transaction_hash
112	19925999999999999999	0x9f231dbe53d460f359b2b8cc47574493caa5b7bf	-80458572678003386964306	false	2978477003234434277859	4	0x4634739c8909fb668007c10b4046ecf82a2c99fe	28306294	61913850000000000	-80458572678003386964306	2022-10-08T21:41:57.000Z	409	0x21f61c0719e4c5d522b25c45652ff895a5a3d8a6d71b4e5cae475e83a0b81f71
1042	3372266271732133568	0xbcb2d435045e16b059b2130b28be70b5ca47bfe5	0	false	53341722735576122610	4	0x944e762766a90a3c3a8aa9bbd39e6cdffdf73ef7	28308595	809937130000000000	-1040903715493366000000	2022-10-08T21:56:20.000Z	4047	0xd8707f69424111dacb4f6155d0287f3aed0d1ea43ac4dc3f07b16a56f555bec5
1047	1571978029506143067	0xbcb2d435045e16b059b2130b28be70b5ca47bfe5	0	false	73073814536811868467	4	0x9ceb46c594d6581cf26bb4032b73fe7e59de61bb	28157903	823500000000000000	-477224659837930500000	2022-10-08T04:48:15.000Z	4046	0xdab88a44bc488a6a279325574771901c247015b445125744118eb33e8a986dae

Example Query

Query with partition filter

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

FuturesMarketManager_MarketAdded_event

Historical record of perpetual futures market deployments on Synthetix v1 protocol on Optimism, tracking when new trading pairs (sETH, sLINK, sSOL, etc.) were added to the FuturesMarketManager contract. Used for analyzing protocol expansion and available trading markets over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_marketKey`	`STRING`	Identifier for the perpetual futures market being tracked. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros, representing the market symbol with ‘s’ prefix (e.g., 0x7345544850455250 for sETHPERP).

Sample Data

address	removed	in_asset	in_market	log_index	block_number	in_marketKey	block_timestamp	transaction_hash
0xc704c9aa89d1ca60f67b3075d05fbb92b3b00b3b	false	0x5841470000000000000000000000000000000000000000000000000000000000	0xb147c69bee211f57290a6cde9d1babfd0dcf3ea3	6	5153617	0x7358414700000000000000000000000000000000000000000000000000000000	2022-03-31T22:25:33.000Z	0x6971f0e1b5f92d347ea91b086e77abb876789f6f35d6de2fb052a8105e609e56
0xc704c9aa89d1ca60f67b3075d05fbb92b3b00b3b	false	0x534f4c0000000000000000000000000000000000000000000000000000000000	0xcf853f7f8f78b2b801095b66f8ba9c5f04db1640	0	5153617	0x73534f4c00000000000000000000000000000000000000000000000000000000	2022-03-31T22:25:33.000Z	0x6971f0e1b5f92d347ea91b086e77abb876789f6f35d6de2fb052a8105e609e56
0xc704c9aa89d1ca60f67b3075d05fbb92b3b00b3b	false	0x4d41544943000000000000000000000000000000000000000000000000000000	0xbcb2d435045e16b059b2130b28be70b5ca47bfe5	4	5153617	0x734d415449430000000000000000000000000000000000000000000000000000	2022-03-31T22:25:33.000Z	0x6971f0e1b5f92d347ea91b086e77abb876789f6f35d6de2fb052a8105e609e56

Example Query

Query with partition filter

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

Issuer_SynthAdded_event

Synthetic asset registration events from Synthetix v1 protocol on Optimism, recording when new synth tokens (sUSD, sETH, sBTC, etc.) are added to the system with their currency keys and contract addresses. Useful for tracking protocol expansion and available synthetic asset markets over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_currencyKey`	`STRING`	Bytes32-encoded ticker symbol representing the synthetic asset type being added to the Synthetix protocol (e.g., sUSD, sETH, sBTC). The value is hex-encoded and right-padded with zeros to fill 32 bytes.
`in_synth`	`STRING`	Contract address of the newly added synthetic asset (synth) in the Synthetix protocol. Hex-encoded, 0x-prefixed 40-character string representing the synth token contract on Optimism.

Sample Data

address	removed	in_synth	log_index	block_number	in_currencyKey	block_timestamp	transaction_hash
0x59b01789bf268c7c77451d02758621990bb50bbf	false	0xe9dcea0136fefc76c4e639ec60cce70482e2acf7	413	34056369	0x7345544800000000000000000000000000000000000000000000000000000000	2022-11-03T17:19:02.000Z	0x62aaa78f51ac2aaf1a99dfb932df037d3536ff281eea787121caf4d0db6b102a
0x59b01789bf268c7c77451d02758621990bb50bbf	false	0xf49c194954b6b91855ac06d6c88be316da60ed96	418	34056369	0x734d415449430000000000000000000000000000000000000000000000000000	2022-11-03T17:19:02.000Z	0x62aaa78f51ac2aaf1a99dfb932df037d3536ff281eea787121caf4d0db6b102a
0x59b01789bf268c7c77451d02758621990bb50bbf	false	0x421def861d623f7123dfe0878d86e9576cbb3975	414	34056369	0x7342544300000000000000000000000000000000000000000000000000000000	2022-11-03T17:19:02.000Z	0x62aaa78f51ac2aaf1a99dfb932df037d3536ff281eea787121caf4d0db6b102a

Example Query

Query with partition filter

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

SNX_SynthExchange_event

Synthetic asset exchange events from Synthetix V1 protocol on Optimism, recording swaps between synths (sUSD, sBTC, sETH, sAVAX) with from/to amounts, currency keys, and account addresses. Used to analyze synth trading volumes, currency pair flows, and user exchange 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_fromCurrencyKey`	`STRING`	Hex-encoded bytes32 identifier of the source synthetic asset being exchanged (e.g., sUSD, sBTC). Common value in samples is sUSD (0x7355534400…).
`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`	Bytes32-encoded identifier of the synthetic asset received in the exchange. Common values include sUSD (0x73555344…), sBTC (0x73425443…), and sETH (0x73455448…) representing different Synthetix synths.
`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
0x8700daec35af8ff88c16bdf0418774cb3d7599b4	false	7	0x7a108a87efeebb7243cd9e348c0280cedb6b6d7a	129383575347242178	16458937	0x7a108a87efeebb7243cd9e348c0280cedb6b6d7a	12852500000000000000	2022-07-29T08:20:29.000Z	0x7341415645000000000000000000000000000000000000000000000000000000	0x8b1adf443e0e286bb81ec372685d9daffd2ef9c6a3977f7a79c72a7259a3e080	0x7355534400000000000000000000000000000000000000000000000000000000
0x8700daec35af8ff88c16bdf0418774cb3d7599b4	false	7	0xb8f52cdca68949a498e25b1ccbf258a38db64291	3994347530234140611	16419045	0xb8f52cdca68949a498e25b1ccbf258a38db64291	100000000000000000000	2022-07-29T05:12:57.000Z	0x7341564158000000000000000000000000000000000000000000000000000000	0xb223ba60656e26eeb6668e9b9af1cd7bbe78dc0d1d6fe3263f411623ed216b13	0x7355534400000000000000000000000000000000000000000000000000000000
0x8700daec35af8ff88c16bdf0418774cb3d7599b4	false	7	0x6012084d117ae383f38f888e95effe7e26615511	74310314739328932614	16456024	0x6012084d117ae383f38f888e95effe7e26615511	1811822800000000000000	2022-07-29T08:10:14.000Z	0x7341564158000000000000000000000000000000000000000000000000000000	0x3ff077eb2b3116a9ac5e5a0400c99cd536416061ccb10ce2c19b072ad25a165d	0x7355534400000000000000000000000000000000000000000000000000000000

Example Query

Query with partition filter

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

StakingRewardsSNXWETHUniswapV3_RewardPaid_event

Reward distribution events from Synthetix’s SNX-WETH Uniswap V3 liquidity mining program on Optimism, capturing when users claim their staking rewards. Records include user address, reward amount in wei, and transaction details for analyzing liquidity provider 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
0xfd49c7ee330fe060ca66fee33d49206eb96f146d	0xc00668f9f5960aeeea83101fde6789bd4c8bf538	false	1612629328239816702	35	114385644	2024-01-04T12:07:45.000Z	0xd1f2c779584244e6eb4df564b7930ed8e22d1d52ffb21efc346edafee059b502
0xfd49c7ee330fe060ca66fee33d49206eb96f146d	0x9cfd5052dc827c11a6b3ab2bb5091773765ea2c8	false	646353982887475254115	1	3716720	2022-02-21T07:44:31.000Z	0x04ec9aa7476c6a84693285acb129b555d3e051f76ebde1dcc5e0448c96b67c8f
0xfd49c7ee330fe060ca66fee33d49206eb96f146d	0x9223f2e38510aa77ded779c5f22c67f4e8315eea	false	54915013405375100156	1	3726633	2022-02-21T14:38:41.000Z	0xb87323c6b188503215a5e7374cbd095dbd4db47fd03dd993a82c41719e864c17

Example Query

Query with partition filter

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

StakingRewardssUSDDAIUniswapV3_RewardPaid_event

No description available.

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

sUSD_Burned_event

sUSD (Synthetix USD) burn events from Synthetix V1 protocol on Optimism, recording when users destroy synthetic stablecoins to unlock collateral or exit positions. Used for analyzing sUSD supply dynamics and debt pool interactions.

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
0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	113239579915567485	3	0x000c9d4824cfcd31ef2c52203c20f967e4ca08e0	16673199	2022-07-30T04:36:31.000Z	0x11626edada66ad372dd0fe725edc1a018b03bc87741e40e24841e9196cf27c14
0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	435168051484721646788	2	0x037afdc17d87a829e109a3bc8a259d99e06cdf37	16751169	2022-07-30T12:56:25.000Z	0x40a22e1941cd5202c4959c2ba1d3893cf99d6cd0c82a720a821991204b793a7c
0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	2466223018409957608	3	0x03ddb89345ff2a4e558413d6cb0a1d62d304bb12	16661220	2022-07-30T03:18:26.000Z	0xeb699f540a0be8b295ce2cc1e0c238dca4f5e3c37efa8c3d0b302e025b5bc885

Example Query

Query with partition filter

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

sUSD_Issued_event

Synthetic USD (sUSD) minting events from Synthetix V1 protocol on Optimism, recording when users create new sUSD stablecoin by locking collateral. Used for tracking sUSD supply changes and individual account debt positions over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	3000000000000000000000	1	0x86aabcd459587bc1a347ae1e2d15223856354ec9	72115642	2023-02-03T16:03:56.000Z	0xbf232a77e9af285337bd21cfa06f6fa022d8a98623a5b17001ff3d2c2529a6e7
0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	2100000000000000000000	1	0x86aabcd459587bc1a347ae1e2d15223856354ec9	72106953	2023-02-03T15:14:35.000Z	0x67a69cdf7c0f04bfb4c905485feec8ceb3460e04316d4f5cf6c9fc92390d76e4
0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	83556287685662477606	2	0x850d8744632e2769981541c841247b0b40df555c	72014566	2023-02-03T04:21:47.000Z	0x0fc764cccd5951f9503a8c4d95272b340a91b8d8d121cc6c1f273ee64928ffae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synthetix_v1_optimism.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 Optimism, recording when users reduce their staked position and corresponding debt pool obligations. Tracks account addresses and exact share amounts burned for analyzing staking behavior and protocol debt management.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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
0x45c55bf488d3cb8640f12f63cbedc027e8261e79	false	1283311610511484834639	1	0x0064b28742ee529579dba1074f0a1633ac1194b8	77694513	2023-02-28T06:38:22.000Z	0x7b9852c2b89ce3c8db27d80bfdbe61bc2a3351dd0ceab3269645fd1537eadabf
0x45c55bf488d3cb8640f12f63cbedc027e8261e79	false	5054722086651930611876	1	0x011b0a055e02425461a1ae95b30f483c4ff05be7	77712394	2023-02-28T08:53:03.000Z	0x8831e4f0c321fe74839d8488dfc9456c0061a63093f711d00af4eef4c78f5a8a
0x45c55bf488d3cb8640f12f63cbedc027e8261e79	false	4329698568549140262	1	0x016a20fb8734a3765ad0052003bbe10fe5b488b4	77663469	2023-02-28T01:39:20.000Z	0x506df125bfc2ce70cfbf6869ab75e1e90249205f86b6128e55e4ad6e4ecec798

Example Query

Query with partition filter

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

SynthetixDebtShares_Mint_event

Debt share minting events from Synthetix v1 protocol on Optimism, recording when users incur protocol debt through synthetic asset positions. Used for tracking debt pool participation and individual debt share balances over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x45c55bf488d3cb8640f12f63cbedc027e8261e79	false	5584169390652848829	1	0x0022505a56190e01336c48a480422ffb4dbdf3fb	72672794	2023-02-07T03:24:24.000Z	0xefd88ac8b7e101fd4a4e72fc6d4082ecf96250564db37474f5bb486865e56dfd
0x45c55bf488d3cb8640f12f63cbedc027e8261e79	false	20529648672625104214	1	0x00409fc839a2ec2e6d12305423d37cd011279c09	72769250	2023-02-07T17:26:21.000Z	0xed2b904e48a58a96eff10bc2424d8d3c054b1afc5aa10fd6cee0382c732bd827
0x45c55bf488d3cb8640f12f63cbedc027e8261e79	false	41991917609795505693	1	0x0045fa93dedb0af02956f7d7c306b34263688872	72715137	2023-02-07T10:10:47.000Z	0x2897d2c0c96c7885454a5db8396741d558d8580b41b37503770c6c7625747897

Example Query

Query with partition filter

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

SynthetixSystemSettings_IssuanceRatioUpdated_event

Governance events tracking changes to Synthetix V1 collateralization ratio (c-ratio) parameter on Optimism, with newRatio values representing the minimum collateral-to-debt ratio required for minting synthetic assets (sUSD). Used for analyzing protocol risk parameter adjustments and their impact on system stability.

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_newRatio`	`STRING`	Updated ratio value after the state change. Numeric string representation in wei (18 decimal places).

Sample Data

address	removed	log_index	in_newRatio	block_number	block_timestamp	transaction_hash
0xe28b785ecc2cb5fe949f5f31a5aec3989f764838	false	1	200000000000000000	76921740	2023-02-25T07:04:44.000Z	0xab5af6bc927c6586c966ffc2328d22fcd3d9a7d98ac85ea2896cb9d13c72572b
0x05e1b1dff853b1d67828aa5e8cb37cc25aa050ee	false	1	250000000000000000	32075581	2022-10-27T20:30:20.000Z	0xdc4c9b632c47efa38d6fff261a990295e953a6103ea1ccae369a2a662d4918be
0xde48d4b3b8737446193720ce23ef24f922341155	false	1	285714285714285728	12484029	2022-06-20T16:29:02.000Z	0x59fc921e53e42a8fc60b29c8de2972ea552f03dc0fe6415afedf038ed5d023b9

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AccessControlledOffchainAggregator_AnswerUpdated_event

AddressResolver_AddressImported_event

FeePool_FeesClaimed_event

FuturesMarket_FuturesTracking_event

FuturesMarket_PositionLiquidated_event

FuturesMarket_PositionModified_event

FuturesMarketManager_MarketAdded_event

Issuer_SynthAdded_event

SNX_SynthExchange_event

StakingRewardsSNXWETHUniswapV3_RewardPaid_event

StakingRewardssUSDDAIUniswapV3_RewardPaid_event

sUSD_Burned_event

sUSD_Issued_event

SynthetixDebtShares_Burn_event

SynthetixDebtShares_Mint_event

SynthetixSystemSettings_IssuanceRatioUpdated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AccessControlledOffchainAggregator_AnswerUpdated_event

​AddressResolver_AddressImported_event

​FeePool_FeesClaimed_event

​FuturesMarket_FuturesTracking_event

​FuturesMarket_PositionLiquidated_event

​FuturesMarket_PositionModified_event

​FuturesMarketManager_MarketAdded_event

​Issuer_SynthAdded_event

​SNX_SynthExchange_event

​StakingRewardsSNXWETHUniswapV3_RewardPaid_event

​StakingRewardssUSDDAIUniswapV3_RewardPaid_event

​sUSD_Burned_event

​sUSD_Issued_event

​SynthetixDebtShares_Burn_event

​SynthetixDebtShares_Mint_event

​SynthetixSystemSettings_IssuanceRatioUpdated_event

Tables

AccessControlledOffchainAggregator_AnswerUpdated_event

AddressResolver_AddressImported_event

FeePool_FeesClaimed_event

FuturesMarket_FuturesTracking_event

FuturesMarket_PositionLiquidated_event

FuturesMarket_PositionModified_event

FuturesMarketManager_MarketAdded_event

Issuer_SynthAdded_event

SNX_SynthExchange_event

StakingRewardsSNXWETHUniswapV3_RewardPaid_event

StakingRewardssUSDDAIUniswapV3_RewardPaid_event

sUSD_Burned_event

sUSD_Issued_event

SynthetixDebtShares_Burn_event

SynthetixDebtShares_Mint_event

SynthetixSystemSettings_IssuanceRatioUpdated_event