Skip to main content

​
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.
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_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_claimerSTRINGAddress of the account initiating the claim transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_amountClaimedSTRINGToken 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_amountRemainingSTRINGToken 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.
in_idaddressremovedlog_indexin_claimerblock_numberblock_timestampin_amountClaimedtransaction_hashin_amountRemaining
0xc98b620c8900494093d98c33a3cd83be0xe9c01f928296359ba1d0ad1000cc9bf972cb0026false50xd47248d5cc7bd078d111b9bae350587621a5aab61601840972023-12-15T00:45:03.000Z67447977990000000000xefdccf2ca274d0501d4e0cfc9b7de52935e0e2f9fcfb6f155aa2c1f5196b6793721861539152641000000000
0xc98b620c8900494093d98c33a3cd83be0xe9c01f928296359ba1d0ad1000cc9bf972cb0026false60xe23b55f09f0e46575ff39df10cab0bcbc2cab74b1692204952024-01-11T02:21:39.000Z26551064950000000000000x0e8dfe687d79db13e126711b9a06e8808a39de8619554dabe46c257d735fb3fa331443676374591000000000
0xc98b620c8900494093d98c33a3cd83be0xe9c01f928296359ba1d0ad1000cc9bf972cb0026false10xb5c62fb39363f3fc5b6d6a0340ba557b7cbf62b61549154032023-11-28T12:51:41.000Z71963865830000000000000x17b3b985acc6df07c32cf189e0913dda36b26b967e73f65f502fd478daf4536b773811093103230000000000
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