Skip to main content

​
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.
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.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__reward_tokenSTRINGContract 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__amountSTRINGAmount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
in__epochSTRINGEpoch identifier for the vault or contract cycle. String-encoded integer representing the sequential period number.
gasvaluestatusgas_usedin__epochsignaturein__amountto_addressblock_numberfrom_addresstrace_addressblock_timestampin__reward_tokentransaction_hash
3133470true573426048000x33b50aed670219932647330085030x3ac4b6da715e7963bbcfb31de39a1b139f426223222850170x4347d2d28a3428ddf1b7cfc7f097b2128a1a00593,22025-04-17T00:04:11.000Z0xb01dd87b29d187f3e3a4bf6cdaebfb97f3d9ab980xae40ea13a5eb8924398ca4b6893995ff4cd049d6c24d7289b7f445f4486a74b4
3133470true573426048000x33b50aed3514999635992646105620xa8bb51606db8e81f0ac964f0855c20d9e474ab63222850190xa76434d58ccc9b8277180a691148a598fd0730352,22025-04-17T00:04:35.000Z0xb01dd87b29d187f3e3a4bf6cdaebfb97f3d9ab980x01e3481c972f1f2c3e61b355b18df68bcc2e77d2396199d11b2a55bfe46e5a10
1364210true13283212096000x33b50aed51361068310220850000000x48727018d010dc2e414c5a14d588385ae112869e222896390xb76782b51bff9c27ba69c77027e20abd92bcf3a80,3,12025-04-17T15:33:59.000Z0x3472a5a71965499acd81997a54bba8d852c6e53d0xa551974c704047f1eea4bc12710fdcac4daa19acbb06d665ca627a2837eaafe2
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