scroll_v1_scroll

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.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xe8be8eb940c0ca3bd19d911cd3bebc97bea0ed62	0x83f0c266a2ff536583dec7348e2e3dc19a80fd25	false	30756900000000000000	1	11126158	2024-11-15T20:20:56.000Z	0x167c2c83ed2df0984b5fd8af8d27f2ba67b0e7dbd8a802286932707d772ec615
0xe8be8eb940c0ca3bd19d911cd3bebc97bea0ed62	0x34bf708399d257a8a80fa4a04a9cc9400e0afee1	false	29075800000000000000	1	11118297	2024-11-15T13:39:06.000Z	0xd2993c867f54308a6dcd8c44960a382c432b04110dc22ffef438270c1655e5a1
0xe8be8eb940c0ca3bd19d911cd3bebc97bea0ed62	0x8d708ee21bd9367ac6cad1f4e115647dae1ac303	false	36689700000000000000	1	11114941	2024-11-15T10:47:50.000Z	0x344b15597228c076a3c265c68629d6cb8b72c52d16a08331bb5722f77ded2c81

Example Query

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

⌘I

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

TokenDistributor_Claimed_event

​Tables

​TokenDistributor_Claimed_event

Tables

TokenDistributor_Claimed_event