Skip to main content

​
Tables

​
CashEventEmitter_Cashback_event

Cashback reward events from EtherFi v2 protocol on Scroll, tracking user spending and corresponding cashback amounts in tokens. Contains recipient addresses, spending thresholds, cashback values in USD and token amounts, and payment status for analyzing rewards program activity.
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_safeSTRINGSafe contract address associated with the event. Hex-encoded, 0x-prefixed, 42-character string.
in_spendingInUsdSTRINGUSD value of the user’s spending that qualified for cashback. Represented as a string-encoded integer in smallest unit (e.g., cents).
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_cashbackTokenSTRINGContract address of the token used for cashback payment. Hex-encoded, 0x-prefixed, 42-character string.
in_cashbackAmountInTokenSTRINGToken amount of the cashback reward, denominated in the token specified by in_cashbackToken. Values are wei-denominated (smallest unit), requiring division by token decimals for human-readable amounts.
in_cashbackInUsdSTRINGUSD value of the cashback reward. Represented as a string-encoded integer in smallest unit (e.g., cents).
in_cashbackTypeSTRINGCashback category identifier for the reward event, typically represented as an integer code. Sample data shows type ‘0’ being used consistently across cashback transactions.
in_paidBOOLBoolean flag indicating whether the cashback payment has been processed and distributed to the recipient.
addressin_paidin_saferemovedlog_indexblock_numberin_recipientblock_timestampin_cashbackTypein_cashbackInUsdin_cashbackTokenin_spendingInUsdtransaction_hashin_cashbackAmountInToken
0x380b2e96799405be6e3d965f4044099891881acbtrue0x003603ac48cff347aa052b0d39dae34a8bfd3318false4202740550x003603ac48cff347aa052b0d39dae34a8bfd33182025-08-29T01:21:37.000Z01110000xd29687c813d741e2f938f4ac377128810e217b1b37000000x332afe74d1a3cadf41c21add005657c322ac0db01eb897a3f1e04564346027c7306629834254143646
0x380b2e96799405be6e3d965f4044099891881acbtrue0x003603ac48cff347aa052b0d39dae34a8bfd3318false4203032170x003603ac48cff347aa052b0d39dae34a8bfd33182025-08-29T16:24:16.000Z01404000xd29687c813d741e2f938f4ac377128810e217b1b46800000x01f9edabaddbf023a93357e23447c9fdd7fcba1a12aae8333935a7992d619955418314051359669639
0x380b2e96799405be6e3d965f4044099891881acbtrue0x00489ff9aedc29df85f3ebe63608ced67c525b76false4203000570x00489ff9aedc29df85f3ebe63608ced67c525b762025-08-29T14:59:12.000Z011256000xd29687c813d741e2f938f4ac377128810e217b1b375200000x773becbf3fd4eb755b47c01be1e0fdf18d9a8b33b075456538ad75ffa399ce183354932549641437112
Query with partition filter
SELECT *
FROM `tt-contracts.etherfi_v2_scroll.CashEventEmitter_Cashback_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
CashEventEmitter_Spend_event

Token spending events emitted by the CashEventEmitter contract, recording outflows from user safe addresses with token amounts and USD valuations. Tracks operational mode, transaction identifiers, and sponsor flags for spend transaction analysis.
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_safeSTRINGSafe contract address associated with the event. Hex-encoded, 0x-prefixed, 42-character string.
in_txIdSTRINGTransaction identifier for the cross-chain or layer-2 operation. 66-character hex string including 0x prefix.
in_binSponsorINT64Binary flag indicating whether this spend transaction was sponsored by a bin (promotional category). Typically 0 for non-sponsored transactions, may be 1 for sponsored spend events.
in_tokensARRAY<STRING>Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
in_amountsARRAY<STRING>Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
in_amountInUsdARRAY<STRING>USD-denominated value of the input amount. Numeric string representation in smallest unit (e.g., cents or basis points).
in_totalUsdAmtSTRINGTotal USD value of all tokens spent in this transaction, aggregated across the in_tokens and in_amounts arrays. Values are stored as strings representing amounts with implied decimal precision.
in_modeINT64Operational mode identifier for the transaction or instruction. Integer or string value specifying the configuration, action type, or execution variant being performed.
addressin_modein_safein_txIdremovedin_tokenslog_indexin_amountsblock_numberin_binSponsorin_amountInUsdin_totalUsdAmtblock_timestamptransaction_hash
0x380b2e96799405be6e3d965f4044099891881acb10x00ec30f845a06a959f715a81340ea22818669d3a0x2993628f1148df6d9d720e44a7c19e2af927aa277ee48afa6d6b87e9797b8672false[“0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4”]2[“21830000”]157114900[“21830000”]218300002025-05-21T02:45:13.000Z0xcfd508402f2e66c097c0bfd038a4c4ae4c8eaf0d6d0e60af1533b952a449f096
0x380b2e96799405be6e3d965f4044099891881acb10x00ec30f845a06a959f715a81340ea22818669d3a0x53aba1b5e69ca8a569c38c14b403a9e04739fc491871a5b7d60b16df51f6a740false[“0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4”]2[“15420000”]157529330[“15420000”]154200002025-05-21T20:16:33.000Z0xd229633c9abaa509939b9d168cf5addd098a820cdec0dbc8048eef5454ecdf99
0x380b2e96799405be6e3d965f4044099891881acb10x0209fb9d0da69cf8c38b04dde6c8b9cf21e8152c0xc48983410f6a823f0718cf1a9adf0ae122672199656f9e206df7708250eef60ffalse[“0x08c6f91e2b681faf5e17227f2a44c307b3c1364c”]2[“8262508”]157145850[“9050000”]90500002025-05-21T04:19:50.000Z0x4dc58ea487dd38830351132e9e3073d596dc260391b81be2cd5db4fc4c036db5
Query with partition filter
SELECT *
FROM `tt-contracts.etherfi_v2_scroll.CashEventEmitter_Spend_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100