Skip to main content

​
Tables

​
Billing_TokensPulled_event

Token withdrawal events from The Graph protocol’s billing contract on Polygon, recording when tokens are pulled from user accounts for service payments. Useful for analyzing billing activity, payment flows, and user spending patterns across The Graph’s decentralized indexing network.
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
0xa382f75b375d6a07bfd1af99d4383c6e1d1c40040xd807c894c31c10dd0cb90714edaa61fbaa4c7002false10569184581372021-08-27T17:48:54.000Z0x75c68d62f747053da5f2973af1e9825d8867303b13f13c75e61d48dba8a04c89
0xa382f75b375d6a07bfd1af99d4383c6e1d1c40040xaef4d0e5f6886431d1ca45c50c9ccba9a657aeb5false10000000000000567184581372021-08-27T17:48:54.000Z0x75c68d62f747053da5f2973af1e9825d8867303b13f13c75e61d48dba8a04c89
0xa382f75b375d6a07bfd1af99d4383c6e1d1c40040x4b1d03731765af61e71518fdcbb7772c699dce0afalse1000000000000000000562184581372021-08-27T17:48:54.000Z0x75c68d62f747053da5f2973af1e9825d8867303b13f13c75e61d48dba8a04c89
Query with partition filter
SELECT *
FROM `tt-contracts.thegraph_v1_polygon.Billing_TokensPulled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100