etherfi_v4_scroll

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_safe`	`STRING`	Safe contract address associated with the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_spendingInUsd`	`STRING`	USD value of the user’s spending that qualified for cashback. Represented as a string-encoded integer in smallest unit (e.g., cents).
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_cashbackToken`	`STRING`	Contract address of the token used for cashback payment. Hex-encoded, 0x-prefixed, 42-character string.
`in_cashbackAmountInToken`	`STRING`	Token-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_cashbackInUsd`	`STRING`	USD value of the cashback reward. Represented as a string-encoded integer in smallest unit (e.g., cents).
`in_cashbackType`	`INT64`	Numeric identifier indicating the category or program type of the cashback reward. Based on samples, value 0 appears to be a standard cashback classification.
`in_paid`	`BOOL`	Boolean flag indicating whether the cashback payment has been processed and distributed to the recipient.

Sample Data

address	in_paid	in_safe	removed	log_index	block_number	in_recipient	block_timestamp	in_cashbackInUsd	in_cashbackToken	in_spendingInUsd	transaction_hash	in_cashbackAmountInToken
0x380b2e96799405be6e3d965f4044099891881acb	true	0x001eaa4bfc67772092b6433451b1dcdfd5f7c5a9	false	4	18581698	0x001eaa4bfc67772092b6433451b1dcdfd5f7c5a9	2025-08-07T13:34:55.000Z	35400	0xd29687c813d741e2f938f4ac377128810e217b1b	1180000	0x75228905f7ee226503680107bbe4fb57a78b6b9fb7c80a0e2df1612372684ad7	114046391752577319
0x380b2e96799405be6e3d965f4044099891881acb	true	0x001eaa4bfc67772092b6433451b1dcdfd5f7c5a9	false	4	18579411	0x001eaa4bfc67772092b6433451b1dcdfd5f7c5a9	2025-08-07T12:56:47.000Z	211800	0xd29687c813d741e2f938f4ac377128810e217b1b	7060000	0xc69967a9de2bfd9b7b381232392fbb9f1be3d503681e6ca821c447d2fca1cd85	685883050139411073
0x380b2e96799405be6e3d965f4044099891881acb	true	0x001eaa4bfc67772092b6433451b1dcdfd5f7c5a9	false	4	18583079	0x001eaa4bfc67772092b6433451b1dcdfd5f7c5a9	2025-08-07T13:57:56.000Z	54600	0xd29687c813d741e2f938f4ac377128810e217b1b	1820000	0x2eb61f5363fdf88c6ebfe85857d0d1aca2426ed15474ee67ff747b6f36242db6	175861269293205184

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_safe`	`STRING`	Safe contract address associated with the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_txId`	`STRING`	Transaction identifier for the cross-chain or layer-2 operation. 66-character hex string including 0x prefix.
`in_binSponsor`	`INT64`	Integer flag indicating the sponsor bin allocation for this spend transaction. Typically 0 in sample data, potentially used for internal categorization or batching logic.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<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_amountInUsd`	`ARRAY<STRING>`	USD-denominated value of the input amount. Numeric string representation in smallest unit (e.g., cents or basis points).
`in_totalUsdAmt`	`STRING`	Total 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_mode`	`INT64`	Operational mode identifier for the transaction or instruction. Integer or string value specifying the configuration, action type, or execution variant being performed.

Sample Data

address	in_mode	in_safe	in_txId	removed	in_tokens	log_index	in_amounts	block_number	in_amountInUsd	in_totalUsdAmt	block_timestamp	transaction_hash
0x380b2e96799405be6e3d965f4044099891881acb	1	0x04c0e6c5d6701d17069f0a55a11230fd91017f2e	0x75dba84d8f733f698c4de14d8f60bd3afeb3ea07b68b743690d54603a25f7480	false	[“0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4”]	2	[“38230000”]	15120448	[“38230000”]	38230000	2025-05-01T06:57:23.000Z	0x4b0706854ee13f7130a542975396ef0df701d8fbe4f83ace934e784fb7932421
0x380b2e96799405be6e3d965f4044099891881acb	1	0x04c0e6c5d6701d17069f0a55a11230fd91017f2e	0x2f37640df19a0e4d51f9d8207164b6844ca3370ad35ae36275d7bae6816420a2	false	[“0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4”]	2	[“30070000”]	15121100	[“30070000”]	30070000	2025-05-01T07:32:14.000Z	0x717792305c80cafdd9a7b2ab7cb4be79982aeb862157047476a3c108f41ce8fb
0x380b2e96799405be6e3d965f4044099891881acb	1	0x04c0e6c5d6701d17069f0a55a11230fd91017f2e	0xd9ca438ad03ca20fc7c5787f18e14c9a2060f69087d1a1a912c60967c4694875	false	[“0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4”]	2	[“1480000”]	15124369	[“1480000”]	1480000	2025-05-01T10:39:21.000Z	0x4dcd8b6778f33a58adaba6a4458292abdddb3033c7c5f0499bcaab68a6dbc6fb

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

CashEventEmitter_Cashback_event

CashEventEmitter_Spend_event

​Tables

​CashEventEmitter_Cashback_event

​CashEventEmitter_Spend_event

Tables

CashEventEmitter_Cashback_event

CashEventEmitter_Spend_event