> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# dydx_v1_ethereum
> Tables in tt-contracts.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.dydx_v1_ethereum.SafetyModuleV2_ClaimedRewards_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***