Tables
Gauge_deposit_reward_token_function
Deposit transactions for reward token distributions into Curve V2 liquidity gauge contracts on Ethereum. Records token address, amount, epoch period (weekly 604800s or biweekly 1209600s), and sender details for analyzing incentive programs and reward distribution patterns.Columns
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. |
trace_address | STRING | Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | FLOAT64 | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | INT64 | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in__reward_token | STRING | Contract address of the reward token being deposited to the Curve gauge for distribution to liquidity providers. Hex-encoded, 0x-prefixed 40-character Ethereum address identifying the ERC20 token used as incentive. |
in__amount | STRING | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
in__epoch | STRING | Epoch identifier for the vault or contract cycle. String-encoded integer representing the sequential period number. |
Sample Data
Sample Data
| gas | value | status | gas_used | in__epoch | signature | in__amount | to_address | block_number | from_address | trace_address | block_timestamp | in__reward_token | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 313347 | 0 | true | 57342 | 604800 | 0x33b50aed | 67021993264733008503 | 0x3ac4b6da715e7963bbcfb31de39a1b139f426223 | 22285017 | 0x4347d2d28a3428ddf1b7cfc7f097b2128a1a0059 | 3,2 | 2025-04-17T00:04:11.000Z | 0xb01dd87b29d187f3e3a4bf6cdaebfb97f3d9ab98 | 0xae40ea13a5eb8924398ca4b6893995ff4cd049d6c24d7289b7f445f4486a74b4 |
| 313347 | 0 | true | 57342 | 604800 | 0x33b50aed | 351499963599264610562 | 0xa8bb51606db8e81f0ac964f0855c20d9e474ab63 | 22285019 | 0xa76434d58ccc9b8277180a691148a598fd073035 | 2,2 | 2025-04-17T00:04:35.000Z | 0xb01dd87b29d187f3e3a4bf6cdaebfb97f3d9ab98 | 0x01e3481c972f1f2c3e61b355b18df68bcc2e77d2396199d11b2a55bfe46e5a10 |
| 136421 | 0 | true | 132832 | 1209600 | 0x33b50aed | 5136106831022085000000 | 0x48727018d010dc2e414c5a14d588385ae112869e | 22289639 | 0xb76782b51bff9c27ba69c77027e20abd92bcf3a8 | 0,3,1 | 2025-04-17T15:33:59.000Z | 0x3472a5a71965499acd81997a54bba8d852c6e53d | 0xa551974c704047f1eea4bc12710fdcac4daa19acbb06d665ca627a2837eaafe2 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.curve_v2_ethereum.Gauge_deposit_reward_token_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100