houdiniswap_v1_ethereum

Tables

RewardsPool_RewardAdded_event

Reward distribution events from HoudiniSwap V1 liquidity mining program on Ethereum, recording token amounts allocated to user addresses from the rewards pool contract. Used to track incentive payouts to liquidity providers and analyze reward distribution patterns 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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xf7e1edf3e4ec64360afb739ebd2c0f40a5cc57d3	0x85475d3f64422e40354ac2c1ab38bc07708e0a85	false	125518452321881630000	437	18028019	2023-08-30T14:30:11.000Z	0xcaf84ad5dd0a9adf109fdd6a4c56b26d23ce3dd1ac19566a0ff0e292c32afbc0
0xf7e1edf3e4ec64360afb739ebd2c0f40a5cc57d3	0x9f68273597bf21f3106972547af2f0b6b57542a7	false	130473002556148340000	273	18030099	2023-08-30T21:30:11.000Z	0x0e035b718741e29b411406b0169d6bead6fae4dcd9ff4395dc226e86e601794f
0xf7e1edf3e4ec64360afb739ebd2c0f40a5cc57d3	0x33d0926d035aeb61b625f19e061d278457b91d9d	false	2886079295895988300000	97	16711419	2023-02-26T09:08:11.000Z	0x02adbc4f256cff70c397f4864be6b64f72ef178534bd73f69e9983bea0867167

Example Query

Query with partition filter

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

Staker_RewardPaid_event

Reward distribution events from HoudiniSwap v1 staking contract on Ethereum, recording when users claim their staking rewards. Contains user addresses and reward amounts (in wei) for analyzing staking participation and yield distribution.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x488b813ed84ab52857ca90ade050f8ca126beda6	0xc43a7ff154cf4a0be66927b6423af20d0a1f7596	false	2245754217085235212018	222	17178700	2023-05-03T07:23:59.000Z	0xd1c541267721da949117c14bf0371994ef7fb17b504d6e07a867080fa6baee11
0x488b813ed84ab52857ca90ade050f8ca126beda6	0xab6575fd4975c355be2271e8831cc90af75c508a	false	164615774733637641609	669	17178860	2023-05-03T07:56:23.000Z	0x1af71b5105cc231ab02a2c68713f182ac294064d65f663e44715369c1b7b9b21
0x488b813ed84ab52857ca90ade050f8ca126beda6	0xc43a7ff154cf4a0be66927b6423af20d0a1f7596	false	1630567304414000067284	108	17550151	2023-06-24T15:04:11.000Z	0xd4a4e48ea94b4d88cefba461b76c034698f868ff35d7c9b925370d6030f72403

Example Query

Query with partition filter

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

Staker2_RewardPaid_event

Reward distribution events from HoudiniSwap’s staking contract on Ethereum, tracking token amounts paid to stakers. Used for analyzing staking yields, reward claim patterns, and individual staker earnings 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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xf9fa02cc165dbd70ff34d27b5ac9e0ae6d74d756	0xca120a8d6a2c4687d2b7497822958417bbf8d97e	false	2663622526628000	543	17757163	2023-07-23T17:00:35.000Z	0x2dc3389f95b7bf0a6e4b86a7fbd40ed77b78dedad07019071494771511df2868
0xf9fa02cc165dbd70ff34d27b5ac9e0ae6d74d756	0xca120a8d6a2c4687d2b7497822958417bbf8d97e	false	474202054794519688000	268	17757151	2023-07-23T16:58:11.000Z	0x089e0af58f7ede82d237869c27a3b762b9d8622c02743da412fb037b54650e11
0xf9fa02cc165dbd70ff34d27b5ac9e0ae6d74d756	0x4064abf89bb6a7999483806461bf3ce65f27a5b2	false	290766425672246890	338	18181955	2023-09-21T04:43:59.000Z	0xc8bd944c1ed0ca8174aeb262e92a729642057a055b18acfddab028d2ce94af65

Example Query

Query with partition filter

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

Staker3_RewardPaid_event

Staking reward distribution events from HoudiniSwap’s Staker3 contract on Ethereum, recording user addresses and reward amounts (in wei) when participants claim their staking incentives. Used for tracking individual reward payouts and analyzing staker behavior 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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xe42adcb4b9f2e3e6acb70399c420cb6d6795b09d	0xb57981cb32a381783e02a4d622a7d08ab5f7741c	false	299246181126331641552	158	17669270	2023-07-11T08:45:11.000Z	0x3086733b3aea33cc3ecdd999eebd37ad04f93f8c180a7d1caa964b520c2d42ee
0xe42adcb4b9f2e3e6acb70399c420cb6d6795b09d	0x498bb2cb880920e3122ba49ef8dba13b509b4a11	false	716233849949263860079	248	17335531	2023-05-25T10:21:11.000Z	0x57974a68c12314bd4e7d39ac4b1780ab2315beed11d12f18237c4a9a8ff488af
0xe42adcb4b9f2e3e6acb70399c420cb6d6795b09d	0xab6575fd4975c355be2271e8831cc90af75c508a	false	156425177067478331196	361	17178868	2023-05-03T07:57:59.000Z	0x8c90cf635e0ab0ce86a57f6c82ccf362c3badfcd66930425fb085671397778f5

Example Query

Query with partition filter

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

Staker4_RewardPaid_event

Reward distribution events from HoudiniSwap’s Staker4 contract on Ethereum, tracking when staking rewards are paid to user addresses. Useful for analyzing staking yield distributions and participant reward accumulation 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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xe3507b38342ccb9aa03e5af2dea6c1f54351f553	0xca87d4a49aa3350fea523e679763c28af562019a	false	180560058346017226000	299	16720328	2023-02-27T15:09:23.000Z	0x25846ee3c6a1fabadb0f499d1bf022d136ceaad811eff282ef220a8cd52b573b
0xe3507b38342ccb9aa03e5af2dea6c1f54351f553	0x40bb685269f896a43372dbc26c52c8682852c19f	false	91300865138254640085	283	16907374	2023-03-25T22:13:35.000Z	0x42eb423f54dc8ebe209f754986ee980d5a9bf9c21f57859b676bf9fd77660a0c
0xe3507b38342ccb9aa03e5af2dea6c1f54351f553	0x40bb685269f896a43372dbc26c52c8682852c19f	false	962519025872218	409	16907387	2023-03-25T22:16:11.000Z	0x1d36116dd602364b7af589b2cd4c78f7ec6edfefbe9235c445abb4b1526613fc

Example Query

Query with partition filter

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

Staker6_RewardPaid_event

Staking reward distribution events from HoudiniSwap’s Staker6 contract on Ethereum, capturing reward amounts paid to user addresses. Used for analyzing staking reward payouts and yield distribution patterns across 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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x979a7307dd7ba386b52f08a9a35a26807affbcc9	0x3467b4257cb205676ba04a47fe3816466140ed8b	false	554691396340689729500	180	17955175	2023-08-20T09:50:47.000Z	0x9f54846c117820f7d08936fc86d3f351cc23ece54dcc33d7cc6d5e98fcfdb93c
0x979a7307dd7ba386b52f08a9a35a26807affbcc9	0x47ade238cc739dbce060c572e7393467ed6f0c50	false	2000141862379501567560	449	17737859	2023-07-21T00:10:11.000Z	0xfd4f7011f53950dbf5932b6dbb641e741db71ca1784a0629928caf5b78b21586
0x979a7307dd7ba386b52f08a9a35a26807affbcc9	0xbb7f4c7787f44379e724ed83f638e01c66da8126	false	1522070015220000	290	18274806	2023-10-04T04:35:35.000Z	0x8a088569dc26c4b2b3d0251c2d6e28c8d9c8aa447305371b30cc2ff93e54fc4a

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

RewardsPool_RewardAdded_event

Staker_RewardPaid_event

Staker2_RewardPaid_event

Staker3_RewardPaid_event

Staker4_RewardPaid_event

Staker6_RewardPaid_event

​Tables

​RewardsPool_RewardAdded_event

​Staker_RewardPaid_event

​Staker2_RewardPaid_event

​Staker3_RewardPaid_event

​Staker4_RewardPaid_event

​Staker6_RewardPaid_event

Tables

RewardsPool_RewardAdded_event

Staker_RewardPaid_event

Staker2_RewardPaid_event

Staker3_RewardPaid_event

Staker4_RewardPaid_event

Staker6_RewardPaid_event