lyra_v1_ethereum

Tables

LyraSafetyModule_RewardsClaimed_event

Reward claim events from Lyra V1’s Safety Module staking contract on Ethereum, tracking when users withdraw earned staking rewards. Records recipient addresses and claim amounts for analyzing staker behavior 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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

in_to	address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x0b411e641a36be7a99f9a86c2fbb8eec3ee560f3	0xb9619d73c08076bc5d4f0470593e98b9eb19a219	0x0b411e641a36be7a99f9a86c2fbb8eec3ee560f3	false	5484251295263825295687	222	14692193	2022-05-01T13:18:31.000Z	0x75ca4a6044ac03b31c14dc30ff2874a83710c86d0e9904b2cb17b743c862c978
0x4b5aeeb5fd6b9d7febf8aec97bf5717423f8cc89	0xb9619d73c08076bc5d4f0470593e98b9eb19a219	0x4b5aeeb5fd6b9d7febf8aec97bf5717423f8cc89	false	381497383152743208609	199	14692061	2022-05-01T12:50:34.000Z	0x1ebc997f522c543665bbebe3dd187e1ca22f6fcbe898e3ccd616e17f27735ced
0x7b3e062b606a177c2dad79d0eb1c81941efe26c0	0xb9619d73c08076bc5d4f0470593e98b9eb19a219	0x7b3e062b606a177c2dad79d0eb1c81941efe26c0	false	24760483542251505165	465	15008715	2022-06-22T17:24:23.000Z	0xa7b54052d537737f0dc8f2ddf98ff044305635624456c171a5284b8c270c0883

Example Query

Query with partition filter

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

LyraUsdcSafetyModule_RewardsClaimed_event

Reward claim events from Lyra v1’s USDC Safety Module on Ethereum, recording the amount of rewards distributed to stakers. Used for analyzing Safety Module reward distributions and staker 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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

in_to	address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xe1e4d457a9ada9407d0f0697a760854f5a64f24a	0x54d59c4596c7ea66fd62188ba1e16db39e6f5472	0xe1e4d457a9ada9407d0f0697a760854f5a64f24a	false	5769793983526472653551	353	14751473	2022-05-10T23:39:02.000Z	0x566b0ac2d7f918a17781c1c41735e7c4a7c77c45add4d2e304b9f7b3489e06a7
0x328284cc6010f6b8485e120b0e94c9c39cc6250e	0x54d59c4596c7ea66fd62188ba1e16db39e6f5472	0x328284cc6010f6b8485e120b0e94c9c39cc6250e	false	10716860479345650584	353	14750626	2022-05-10T20:22:06.000Z	0xd98b0dd82a65680a6ad307ccc8ef2876a54e8f9b5888de46445c2ba6201de1a0
0xb0a6f90f11c5ae94e30476a7534191194492a91b	0x54d59c4596c7ea66fd62188ba1e16db39e6f5472	0xb0a6f90f11c5ae94e30476a7534191194492a91b	false	771456009363016399822	58	14745761	2022-05-10T01:30:13.000Z	0x970ee1ad44c1d1f106d19cf62400cbb15d667cf7a824d5e6034fcaa02dbb514c

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

LyraSafetyModule_RewardsClaimed_event

LyraUsdcSafetyModule_RewardsClaimed_event

​Tables

​LyraSafetyModule_RewardsClaimed_event

​LyraUsdcSafetyModule_RewardsClaimed_event

Tables

LyraSafetyModule_RewardsClaimed_event

LyraUsdcSafetyModule_RewardsClaimed_event