Tables
ClaimCampaigns_TokensClaimed_event
Token claim events from Hedgey Finance vesting and distribution campaigns on Arbitrum. Records individual claim transactions with claimed amounts, remaining balances, and campaign identifiers for tracking token unlock and distribution analytics.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_id | STRING | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
in_claimer | STRING | Address of the account initiating the claim transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_amountClaimed | STRING | Token amount claimed by the user in this transaction, denominated in the token’s smallest unit (wei for most EVM tokens). Values are stored as strings to preserve precision for large integers that exceed standard numeric limits. |
in_amountRemaining | STRING | Token amount remaining in the claim campaign after this claim event, denominated in the token’s smallest unit (wei). Decreases with each successful claim from the same campaign ID. |
Sample Data
Sample Data
| in_id | address | removed | log_index | in_claimer | block_number | block_timestamp | in_amountClaimed | transaction_hash | in_amountRemaining |
|---|---|---|---|---|---|---|---|---|---|
| 0xc98b620c8900494093d98c33a3cd83be | 0xe9c01f928296359ba1d0ad1000cc9bf972cb0026 | false | 5 | 0xd47248d5cc7bd078d111b9bae350587621a5aab6 | 160184097 | 2023-12-15T00:45:03.000Z | 6744797799000000000 | 0xefdccf2ca274d0501d4e0cfc9b7de52935e0e2f9fcfb6f155aa2c1f5196b6793 | 721861539152641000000000 |
| 0xc98b620c8900494093d98c33a3cd83be | 0xe9c01f928296359ba1d0ad1000cc9bf972cb0026 | false | 6 | 0xe23b55f09f0e46575ff39df10cab0bcbc2cab74b | 169220495 | 2024-01-11T02:21:39.000Z | 2655106495000000000000 | 0x0e8dfe687d79db13e126711b9a06e8808a39de8619554dabe46c257d735fb3fa | 331443676374591000000000 |
| 0xc98b620c8900494093d98c33a3cd83be | 0xe9c01f928296359ba1d0ad1000cc9bf972cb0026 | false | 1 | 0xb5c62fb39363f3fc5b6d6a0340ba557b7cbf62b6 | 154915403 | 2023-11-28T12:51:41.000Z | 7196386583000000000000 | 0x17b3b985acc6df07c32cf189e0913dda36b26b967e73f65f502fd478daf4536b | 773811093103230000000000 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.hedgeyfinance_v1_arbitrum.ClaimCampaigns_TokensClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100