dydx_v1_ethereum

Tables

LiquidityStaking_ClaimedRewards_event

Reward claim events from dYdX v1 liquidity staking contract on Ethereum, recording user addresses, claimed reward amounts, and recipient addresses. Used for analyzing staking reward distributions and participant behavior in the dYdX protocol’s liquidity mining program.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_claimedRewards`	`STRING`	Amount of staking rewards claimed by the user, denominated in the smallest unit of the reward token (wei-equivalent). Values typically range from hundreds of millions to trillions of base units.

Sample Data

address	in_user	removed	log_index	block_number	in_recipient	block_timestamp	transaction_hash	in_claimedRewards
0x5aa653a076c1dbb47cec8c1b4d152444cad91941	0x92fe4a4154b42030928e8043f70ca1624538bf53	false	532	14422442	0x92fe4a4154b42030928e8043f70ca1624538bf53	2022-03-20T09:27:01.000Z	0x66fc587a19c83b51fffde17fc95ec746dddde3aac9f4e7eca793c49e4de2fa7e	294527047615549150
0x5aa653a076c1dbb47cec8c1b4d152444cad91941	0xb1e1af544e215e9aa34fb3d75c3c719728528d5d	false	295	14422488	0xb1e1af544e215e9aa34fb3d75c3c719728528d5d	2022-03-20T09:37:05.000Z	0x4d4c2cfecb68f1426f35013c65fd21b90bb26de6339ffe805e5e4d5938ce28a0	300428756625683041
0x5aa653a076c1dbb47cec8c1b4d152444cad91941	0x23863232e9cb3d80e7378dc2fde29ae3277d6b4f	false	410	14422726	0x23863232e9cb3d80e7378dc2fde29ae3277d6b4f	2022-03-20T10:30:34.000Z	0xd164fc0071c84bde3ab1449bc509cbb617bba9ac94327da2d3b86456b43f42cf	303272741206473728

Example Query

Query with partition filter

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

MerkleDistributor_RewardsClaimed_event

Reward claim events from dydx v1’s Merkle distributor contract on Ethereum, recording token distribution to accounts with claimed amounts in wei. Used for analyzing reward program participation and distribution patterns across protocol users.

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_account`	`STRING`	Account 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

address	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x01d3348601968ab85b4bb028979006eac235a588	false	97597331772060355169	11	0x957291eae3d53b5a7c0a6bf2c0f08de5d87b14f6	15167488	2022-07-18T15:34:30.000Z	0xb23253820c0fcfc00ed70251c0950a24a89bfcd21593cde2f5a779eefdf6bd74
0x01d3348601968ab85b4bb028979006eac235a588	false	2056617421337642056112	218	0x570507279f1d766dff4c8b52ca00830847689650	15168769	2022-07-18T20:29:02.000Z	0x1f3a2d924e496b29b2b4a5d00faf79ce85494187d5920bf2f733de57ee50bab7
0x01d3348601968ab85b4bb028979006eac235a588	false	1702074820300501908436	76	0x44141506d5df783da4ef92bd9a216e3fb2b2a287	15166978	2022-07-18T13:44:01.000Z	0x4414fe5ebaa4ada5054d7945985e33f2f4116f86e1e5527ed132aa9cfdecad48

Example Query

Query with partition filter

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

SafetyModuleV2_ClaimedRewards_event

Reward claim events from dYdX’s Safety Module V2 contract on Ethereum, tracking when stakers claim their earned incentives. Records user addresses, recipient addresses, and claimed reward amounts (in wei) for analyzing staking participation and reward distribution 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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_claimedRewards`	`STRING`	Amount of rewards claimed by the user in the transaction, denominated in the smallest unit of the reward token (wei). Values typically range from hundreds of billions to hundreds of quintillions of wei, representing substantial token claims from the dYdX Safety Module.

Sample Data

address	in_user	removed	log_index	block_number	in_recipient	block_timestamp	transaction_hash	in_claimedRewards
0x65f7ba4ec257af7c55fd5854e5f6356bbd0fb8ec	0x97cbc06317424f17efb419c5b27843f7c070153b	false	92	14684291	0x97cbc06317424f17efb419c5b27843f7c070153b	2022-04-30T07:36:22.000Z	0xe8a37cc1696649ddc5bc98057b9f8f8187ef9dbcdf3e480be3cf3fda2281aab6	719488218292722096495
0x65f7ba4ec257af7c55fd5854e5f6356bbd0fb8ec	0xbfc5c76182be1d1ed863eeb0e8780825c1924aa3	false	55	14684936	0xbfc5c76182be1d1ed863eeb0e8780825c1924aa3	2022-04-30T09:58:33.000Z	0x4414462c8fa3ac274ccfcbcdf555374d52a77695869e22d9c569e660a5fdab2f	139682435746151800790
0x65f7ba4ec257af7c55fd5854e5f6356bbd0fb8ec	0x572c91946f470e03925f5ea80c74d623b275d16b	false	427	14683738	0x572c91946f470e03925f5ea80c74d623b275d16b	2022-04-30T05:26:33.000Z	0x2b2a19a48ff569190ebeef765e74c54610babc7a4677d10d00e5b8e1cfbcc7d2	180052822996467059800

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

LiquidityStaking_ClaimedRewards_event

MerkleDistributor_RewardsClaimed_event

SafetyModuleV2_ClaimedRewards_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​LiquidityStaking_ClaimedRewards_event

​MerkleDistributor_RewardsClaimed_event

​SafetyModuleV2_ClaimedRewards_event

Tables

LiquidityStaking_ClaimedRewards_event

MerkleDistributor_RewardsClaimed_event

SafetyModuleV2_ClaimedRewards_event