Skip to main content

​
Tables

​
TokenDistributor_Claimed_event

Token claim events from a distributor contract on Scroll, recording user addresses and claimed amounts (typically 28-101 tokens with 18 decimals). Used for tracking airdrop or reward distribution participation and analyzing claim patterns across eligible users.
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_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressin_userremovedin_amountlog_indexblock_numberblock_timestamptransaction_hash
0xe8be8eb940c0ca3bd19d911cd3bebc97bea0ed620x83f0c266a2ff536583dec7348e2e3dc19a80fd25false307569000000000000001111261582024-11-15T20:20:56.000Z0x167c2c83ed2df0984b5fd8af8d27f2ba67b0e7dbd8a802286932707d772ec615
0xe8be8eb940c0ca3bd19d911cd3bebc97bea0ed620x34bf708399d257a8a80fa4a04a9cc9400e0afee1false290758000000000000001111182972024-11-15T13:39:06.000Z0xd2993c867f54308a6dcd8c44960a382c432b04110dc22ffef438270c1655e5a1
0xe8be8eb940c0ca3bd19d911cd3bebc97bea0ed620x8d708ee21bd9367ac6cad1f4e115647dae1ac303false366897000000000000001111149412024-11-15T10:47:50.000Z0x344b15597228c076a3c265c68629d6cb8b72c52d16a08331bb5722f77ded2c81
Query with partition filter
SELECT *
FROM `tt-contracts.scroll_v1_scroll.TokenDistributor_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100