Skip to main content

​
Tables

​
USD1_Burn_event

USD1 token burn events from World Liberty Financial on Ethereum, recording when tokens are destroyed with caller address, source account, and burn amount in wei (18 decimals). Used for tracking token supply reduction and analyzing redemption or liquidation activity in the protocol.
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_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_fromSTRINGAddress originating the transfer or 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_fromremovedin_amountin_callerlog_indexblock_numberblock_timestamptransaction_hash
0x8d0d000ee44948fc98c9b98a4fa4921476f08b0d0xee9b1a09aedaced9dcda74964ea447feb93861c2false35000000000000000000xee9b1a09aedaced9dcda74964ea447feb93861c2264225880222025-05-29T11:10:23.000Z0x46403de2f14baca639cfdc7343bb732cf2ecbc20c4d3cad5aff7904f8e14d861
0x8d0d000ee44948fc98c9b98a4fa4921476f08b0d0xee9b1a09aedaced9dcda74964ea447feb93861c2false10000000000000000000xee9b1a09aedaced9dcda74964ea447feb93861c2226225904582025-05-29T19:22:35.000Z0x3cd46fa104a72734d92fef3a158fd271d4dceb78ef17c2e3b0a7fa7acbe59a88
0x8d0d000ee44948fc98c9b98a4fa4921476f08b0d0x295a858f0938bc8127fe24f8116722cf253b618efalse100000000000000000000x295a858f0938bc8127fe24f8116722cf253b618e122220220802025-03-11T07:16:35.000Z0xd75ad24947f45b9f9e1eb488c337fd37148b148bdf41c1e8e15d61ef4a19f6fb
Query with partition filter
SELECT *
FROM `tt-contracts.worldlibertyfinancial_v1_ethereum.USD1_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
USD1_Mint_event

USD1 stablecoin minting events from World Liberty Financial on Ethereum, capturing token issuance with caller address, recipient, and minted amounts. Useful for tracking USD1 token supply creation and analyzing minting activity patterns.
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_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the 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.
in_toaddressremovedin_amountin_callerlog_indexblock_numberblock_timestamptransaction_hash
0x295a858f0938bc8127fe24f8116722cf253b618e0x8d0d000ee44948fc98c9b98a4fa4921476f08b0dfalse100000000000000000000x295a858f0938bc8127fe24f8116722cf253b618e71220067342025-03-09T03:50:11.000Z0x0a49aa4b2855cf9432c02715d44cae0ab9edf93ca2a952b90c2dfb1cea5f7cb2
0xee9b1a09aedaced9dcda74964ea447feb93861c20x8d0d000ee44948fc98c9b98a4fa4921476f08b0dfalse200000000000000000xee9b1a09aedaced9dcda74964ea447feb93861c2380225015362025-05-17T08:21:59.000Z0xcbc6b1e1e14966421e9e55bb0b07bda03a17132466eb9e19784033587efcbd17
0xee9b1a09aedaced9dcda74964ea447feb93861c20x8d0d000ee44948fc98c9b98a4fa4921476f08b0dfalse1295926103475764143059260xee9b1a09aedaced9dcda74964ea447feb93861c283225009192025-05-17T06:17:23.000Z0x51aacd90c7700f795cd6e492cb4518b2381f5a3c03fd5c2765356eb1c9820596
Query with partition filter
SELECT *
FROM `tt-contracts.worldlibertyfinancial_v1_ethereum.USD1_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100