Skip to main content

​
Tables

​
CashEventEmitter_Cashback_event

Cashback reward events from Ether.fi’s Cash product on Scroll, tracking USD spending amounts, corresponding token cashback earned, and payment status for user safes. Used for analyzing user rewards, cashback rates, and Cash product adoption metrics.
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-denominated cashback amount paid to the recipient, denominated in the smallest unit of the cashback token (wei-equivalent). Stored as a string to preserve precision for large integers typical of 18-decimal ERC-20 tokens.
in_cashbackInUsdSTRINGUSD value of the cashback reward. Represented as a string-encoded integer in smallest unit (e.g., cents).
in_cashbackTypeINT64Numeric identifier indicating the category or program type of the cashback reward. Based on samples, value 0 appears to be a standard cashback classification.
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
0x380b2e96799405be6e3d965f4044099891881acbtrue0x001eaa4bfc67772092b6433451b1dcdfd5f7c5a9false4185816980x001eaa4bfc67772092b6433451b1dcdfd5f7c5a92025-08-07T13:34:55.000Z0354000xd29687c813d741e2f938f4ac377128810e217b1b11800000x75228905f7ee226503680107bbe4fb57a78b6b9fb7c80a0e2df1612372684ad7114046391752577319
0x380b2e96799405be6e3d965f4044099891881acbtrue0x001eaa4bfc67772092b6433451b1dcdfd5f7c5a9false4185794110x001eaa4bfc67772092b6433451b1dcdfd5f7c5a92025-08-07T12:56:47.000Z02118000xd29687c813d741e2f938f4ac377128810e217b1b70600000xc69967a9de2bfd9b7b381232392fbb9f1be3d503681e6ca821c447d2fca1cd85685883050139411073
0x380b2e96799405be6e3d965f4044099891881acbtrue0x001eaa4bfc67772092b6433451b1dcdfd5f7c5a9false4185830790x001eaa4bfc67772092b6433451b1dcdfd5f7c5a92025-08-07T13:57:56.000Z0546000xd29687c813d741e2f938f4ac377128810e217b1b18200000x2eb61f5363fdf88c6ebfe85857d0d1aca2426ed15474ee67ff747b6f36242db6175861269293205184
Query with partition filter
SELECT *
FROM `tt-contracts.etherfi_v4_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_binSponsorINT64Integer flag indicating the sponsor bin allocation for this spend transaction. Typically 0 in sample data, potentially used for internal categorization or batching logic.
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, expressed in smallest currency unit (e.g., cents). Aggregates the values from in_amountInUsd array for multi-token spends.
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
0x380b2e96799405be6e3d965f4044099891881acb10x04c0e6c5d6701d17069f0a55a11230fd91017f2e0x75dba84d8f733f698c4de14d8f60bd3afeb3ea07b68b743690d54603a25f7480false[“0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4”]2[“38230000”]151204480[“38230000”]382300002025-05-01T06:57:23.000Z0x4b0706854ee13f7130a542975396ef0df701d8fbe4f83ace934e784fb7932421
0x380b2e96799405be6e3d965f4044099891881acb10x04c0e6c5d6701d17069f0a55a11230fd91017f2e0x2f37640df19a0e4d51f9d8207164b6844ca3370ad35ae36275d7bae6816420a2false[“0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4”]2[“30070000”]151211000[“30070000”]300700002025-05-01T07:32:14.000Z0x717792305c80cafdd9a7b2ab7cb4be79982aeb862157047476a3c108f41ce8fb
0x380b2e96799405be6e3d965f4044099891881acb10x04c0e6c5d6701d17069f0a55a11230fd91017f2e0xd9ca438ad03ca20fc7c5787f18e14c9a2060f69087d1a1a912c60967c4694875false[“0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4”]2[“1480000”]151243690[“1480000”]14800002025-05-01T10:39:21.000Z0x4dcd8b6778f33a58adaba6a4458292abdddb3033c7c5f0499bcaab68a6dbc6fb
Query with partition filter
SELECT *
FROM `tt-contracts.etherfi_v4_scroll.CashEventEmitter_Spend_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100