Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_toaddressin_fromremovedin_valuelog_indexblock_numberblock_timestamptransaction_hash
0x3cd751e6b0078be393132286c442345e5dc496990xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f0xd8d7c77ace3702fc59e6efe617caceba7e6a1808false500000000000000000068126128852021-06-11T11:07:44.000Z0xe33a36b0e751f8e31a3b5dabc749aad1c15486e5632065124629b87895ed9233
0xede8dd046586d22625ae7ff2708f879ef7bdb8cf0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f0x6710073666e7b9e8c1ba1d9d4cded9d1513d1d1ffalse66745176368535044024328126115332021-06-11T06:00:32.000Z0x18641ae2ba89de528915c9419417363e0c4292ce04e86e057567e58a568b6fe6
0x5abfbe56553a5d794330eaccf556ca1d2a55647c0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f0xa1d7b2d891e3a1f9ef4bbc5be20630c2feb1c470false68396032338993904159126111602021-06-11T04:39:00.000Z0xbbd2172f57861adabb493006567b543d687740ac27e15be6b79a7ff25cb61e8f
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