houdiniswap_v2_ethereum

Tables

Staker_Compounded_event

Reward compounding events from Houdiniswap V2 staking contract on Ethereum, capturing when stakers reinvest their earned rewards back into their stake positions. Contains user addresses, compounded amounts in wei, and transaction metadata for tracking staking yield auto-compounding behavior.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0xf96094910fc82e71a022c52276ef16f41548219c	false	12693428614289195728	167	19211462	2024-02-12T10:50:47.000Z	0xbc6c37a4d546d8ef967d613a223db11b7cf225366e8eed189b866c6171dbeb2a
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0xcd3f9b3389794104e2ce3d5e4424014d56e59729	false	6059649164073240481	552	19213310	2024-02-12T17:03:35.000Z	0x9a76ac348be9f8fcb910a738b9d1df76a8fcd2a42b73076fba3c9091e6876b93
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0xe99d339f9d18b76ffa4085f5e6d82e6a3ff546ca	false	76660915427162146635	289	19617850	2024-04-09T11:40:47.000Z	0xc5b829ddfd43d6638d8771ec915cc692829e4edafa23bc3831e869b643717f30

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.houdiniswap_v2_ethereum.Staker_Compounded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staker_FallenWizardFee_event

Fee distribution events for HoudiniSwap V2 stakers on Ethereum, recording token amounts allocated to user addresses from the Fallen Wizard fee mechanism. Used to track staking reward distributions and fee-sharing payouts to liquidity providers.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0xff16d25c97a872da47a0d49c04da9539db0fd2e1	false	150752483380111370407	189	19494938	2024-03-23T04:32:11.000Z	0xe37c86c4f9470e0c3e1dbd1c2d1129320b6c9ab80a71455327fe8ba082ea3358
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0xff16d25c97a872da47a0d49c04da9539db0fd2e1	false	0	77	19494946	2024-03-23T04:33:47.000Z	0x8739479a7fd1ebe212cd367d699d9589ae9b506b1f289d86f4569c5397ad7dc2
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0xaf02acf6074bc07869fb8f4f590603db05765229	false	229107707953462788891	181	19342224	2024-03-01T18:49:47.000Z	0xd1a9ed8dd6a3134033ede807e943b60d3b7e438866a04358396d7e178f5f9dc0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.houdiniswap_v2_ethereum.Staker_FallenWizardFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staker_initialize_function

No description available.

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__rewardsToken`	`STRING`	-
`in__stakingToken`	`STRING`	-
`in__stakingTokensDecimal`	`STRING`	-
`in__treasuryAddress`	`STRING`	-
`in__admin`	`STRING`	-
`in__earlyStakePeriodEnd`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.houdiniswap_v2_ethereum.Staker_initialize_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staker_MultiplierChanged_event

Staking reward multiplier adjustment events from HoudiniSwap V2 on Ethereum, tracking when user multipliers change (stored as basis points where 1000 = 1x). Used for analyzing staking incentive structures and user tier changes over time.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_multiplier`	`STRING`	Multiplier value applied to the user’s staking rewards or voting power, represented as an integer where 1000 equals 1x. Higher values indicate boosted rewards, with the sample showing a baseline 1x multiplier.

Sample Data

address	in_user	removed	log_index	block_number	in_multiplier	block_timestamp	transaction_hash
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0x99910e1a4cd086dace05703acd25c3d1a0042036	false	132	19317255	1000	2024-02-27T06:59:59.000Z	0xb86cbca5cb6f617e30a4f225e4e3bdbe31bee8dc2b1a173cfaf18703bf08a3de

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.houdiniswap_v2_ethereum.Staker_MultiplierChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staker_Rebased_event

Staking multiplier adjustment events from HoudiniSwap V2 on Ethereum, tracking when user stake positions are rebalanced with new multiplier values. Used for analyzing reward distribution mechanics and stake weight changes over time.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_multiplier`	`STRING`	Multiplier value applied during the rebase event for the specified user’s staked position. Typically expressed as basis points or a scaled integer (e.g., 1000 = 1.0x).

Sample Data

address	in_user	removed	log_index	block_number	in_multiplier	block_timestamp	transaction_hash
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0x99910e1a4cd086dace05703acd25c3d1a0042036	false	131	19317255	1000	2024-02-27T06:59:59.000Z	0xb86cbca5cb6f617e30a4f225e4e3bdbe31bee8dc2b1a173cfaf18703bf08a3de

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.houdiniswap_v2_ethereum.Staker_Rebased_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staker_Recovered_event

No description available.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.houdiniswap_v2_ethereum.Staker_Recovered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staker_RequestUnlock_event

Unlock requests initiated by stakers in HoudiniSwap v2 staking contract on Ethereum, recording user addresses and token amounts being withdrawn. Used for tracking staking exit behavior and liquidity movement patterns.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0x96f7336b43d58bfb62b0da07b6d6786bd976a3f4	false	7550131965000623762864	531	19491377	2024-03-22T16:32:47.000Z	0xcb306f40c8e130044a92a48dcd5dc98e7570b8b29af5341264a12ed24f254503
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0xd0e614213dd13f59fe780843cc012dcc656738ff	false	3850308580643509372964	887	19486480	2024-03-22T00:04:47.000Z	0xf075e62938b7cfd29e6ee71333398fbf0a645bec7cc89835b94300faa90327c6
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0xae1f5ce62cd70da2faeb297f9720c55bdbae3ec1	false	1124811334657468454989	735	19486465	2024-03-22T00:01:47.000Z	0x585377d4e121f85a0ebeb47eb741e2a64e116ffcf4a36e9309620f14e1df250b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.houdiniswap_v2_ethereum.Staker_RequestUnlock_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staker_RewardAdded_event

Reward distribution events from HoudiniSwap V2 staking contracts on Ethereum, capturing the token amounts added to staker reward pools. Used for tracking staking yield distribution patterns and reward frequency 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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x4401c51110e7d3a970fe48aeaee8249b181210a1	false	87100706964008624258922	266	19609621	2024-04-08T08:00:11.000Z	0x8e522cf1906b65bfa66e40b337138157d7aee11f948c17da5cce8e90b69a5dc1
0x4401c51110e7d3a970fe48aeaee8249b181210a1	false	33495608674405462386924	310	19360464	2024-03-04T08:00:11.000Z	0x1dc8715a600a533ac243935209c7d5bc867be52bc618a4aa9f2b1817d9bba3cc
0x4401c51110e7d3a970fe48aeaee8249b181210a1	false	61003411040621882711184	245	19510174	2024-03-25T08:00:11.000Z	0x2bb4b61ccf108d6a404a0b8a7cdb6bc008951a7d25466414fe2ec474509486e5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.houdiniswap_v2_ethereum.Staker_RewardAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staker_RewardPaid_event

No description available.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.houdiniswap_v2_ethereum.Staker_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staker_stake_function

Staking deposits to HoudiniSwap V2 protocol on Ethereum, capturing user addresses, token amounts, and transaction execution details. Contains both successful and failed stake attempts for analyzing protocol participation and staking patterns.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	status	gas_used	in_amount	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
152166	true	131072	222999999999999999999	0xa694fc3a	0x4401c51110e7d3a970fe48aeaee8249b181210a1	20151038	0x3f560c2dd30d15a4bb479ad0fff3ac77bc48a149	2024-06-23T01:12:23.000Z	0x8267cc60be46dc84323ec29c67c9cefd3b915c4a1ef3fda748df66fc64ecfe77
170410	true	101932	0	0xa694fc3a	0x4401c51110e7d3a970fe48aeaee8249b181210a1	20155301	0x2797f0fee73b3ef4878349529f1b0359efbdcf96	2024-06-23T15:31:47.000Z	0x9a92d2e7525a0c0a8aceadbd769c4466e718d8a3307b262e4fe663d348c39cf6
259884	true	165449	1309999999999999999999	0xa694fc3a	0x4401c51110e7d3a970fe48aeaee8249b181210a1	20151279	0x503844682489f75f3c59b84a1a547e4336f5ccba	2024-06-23T02:00:47.000Z	0x646c29a2bbf35115bf5c5b41365ce2ca4e1858708667c4f29dca6cce3b6a57d7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.houdiniswap_v2_ethereum.Staker_stake_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staker_Staked_event

Staking deposit events from HoudiniSwap V2 on Ethereum, recording when users lock tokens into the staking contract. Useful for analyzing staking participation, deposit sizes, and staker wallet behavior over time.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0x3a3c3a5115bc299fe4e03664c9bccf43bc252a7d	false	7999999999999999999999	183	19409925	2024-03-11T05:59:59.000Z	0x1dee12eb3b45f58c9b8dbf7d6e274dc56a007b902d55ffb6c9f8fecc77a6832a
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0xd24dd11b6bca2c119321f2acb29ad1b45ef98ea5	false	1426999999999999999999	335	19410959	2024-03-11T09:28:23.000Z	0x1457362460aa3000739218e44bd06ecc989516af4e04f7647151cd59793b7103
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0x020b1ba5c3fa43cf613e87032b1badd210301da8	false	3445999999999999999999	146	19411018	2024-03-11T09:40:11.000Z	0x22512c1d09fa4ec059a7e9ed543d0d33c89c1b66c8a263a24ecf78f47eea0b32

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.houdiniswap_v2_ethereum.Staker_Staked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staker_Withdrawn_event

Withdrawal events from HoudiniSwap V2 staking contract on Ethereum, recording when users unstake tokens with withdrawal amounts and user addresses. Useful for analyzing staking behavior, liquidity movements, and participant activity in the HoudiniSwap protocol.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0x7364bc2e9019e6e2506c4571558e5ab9b8cb5b91	false	745158764383016428971	236	19191490	2024-02-09T15:33:35.000Z	0xe2317fade76683fadb81c3fd183e815ece3acd7bff5338479f05cf587961f491
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0x019d805a1fe8d1f54835fe0107916ed189452993	false	1501099992585927532720	305	19193927	2024-02-09T23:45:11.000Z	0xf1efea1b7de970a220ea7f8c2aaaffd5a7a586dab2abee56b9380d71ea5ae1ca
0x4401c51110e7d3a970fe48aeaee8249b181210a1	0x7c86472518046cf6ec2e8baa29822cfa1c1c7aec	false	444186291454596537055	155	19265546	2024-02-20T01:09:23.000Z	0xe844b2a226f614e67f81358e90409ec9258e4790021d136a655da5d291de5e69

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.houdiniswap_v2_ethereum.Staker_Withdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Staker_Compounded_event

Staker_FallenWizardFee_event

Staker_initialize_function

Staker_MultiplierChanged_event

Staker_Rebased_event

Staker_Recovered_event

Staker_RequestUnlock_event

Staker_RewardAdded_event

Staker_RewardPaid_event

Staker_stake_function

Staker_Staked_event

Staker_Withdrawn_event

​Tables

​Staker_Compounded_event

​Staker_FallenWizardFee_event

​Staker_initialize_function

​Staker_MultiplierChanged_event

​Staker_Rebased_event

​Staker_Recovered_event

​Staker_RequestUnlock_event

​Staker_RewardAdded_event

​Staker_RewardPaid_event

​Staker_stake_function

​Staker_Staked_event

​Staker_Withdrawn_event

Tables

Staker_Compounded_event

Staker_FallenWizardFee_event

Staker_initialize_function

Staker_MultiplierChanged_event

Staker_Rebased_event

Staker_Recovered_event

Staker_RequestUnlock_event

Staker_RewardAdded_event

Staker_RewardPaid_event

Staker_stake_function

Staker_Staked_event

Staker_Withdrawn_event