Tables
SNX_Transfer_event
SNX token transfer events on Ethereum from Synthetix v2 protocol, capturing sender, receiver, and transfer amounts with transaction metadata. Used for analyzing SNX (Synthetix Network Token) holder flows, staking patterns, and token distribution changes.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_from | STRING | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_to | STRING | Destination address receiving tokens or assets in the 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
Sample Data
| in_to | address | in_from | removed | in_value | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x3cd751e6b0078be393132286c442345e5dc49699 | 0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f | 0xd8d7c77ace3702fc59e6efe617caceba7e6a1808 | false | 5000000000000000000 | 68 | 12612885 | 2021-06-11T11:07:44.000Z | 0xe33a36b0e751f8e31a3b5dabc749aad1c15486e5632065124629b87895ed9233 |
| 0xede8dd046586d22625ae7ff2708f879ef7bdb8cf | 0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f | 0x6710073666e7b9e8c1ba1d9d4cded9d1513d1d1f | false | 66745176368535044024 | 328 | 12611533 | 2021-06-11T06:00:32.000Z | 0x18641ae2ba89de528915c9419417363e0c4292ce04e86e057567e58a568b6fe6 |
| 0x5abfbe56553a5d794330eaccf556ca1d2a55647c | 0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f | 0xa1d7b2d891e3a1f9ef4bbc5be20630c2feb1c470 | false | 683960323389939041 | 59 | 12611160 | 2021-06-11T04:39:00.000Z | 0xbbd2172f57861adabb493006567b543d687740ac27e15be6b79a7ff25cb61e8f |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.synthetix_v2_ethereum.SNX_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100