swell_v1_ethereum

Tables

swETH_ETHDepositReceived_event

ETH deposit events from Swell’s liquid staking protocol showing user deposits, swETH (Swell Ethereum) minted amounts, and cumulative protocol ETH deposited. Used for tracking staking activity, exchange rates between ETH and swETH, and protocol growth metrics.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_swETHMinted`	`STRING`	Amount of swETH (Swell staked ETH) tokens minted to the depositor in exchange for their ETH deposit. Value is in wei (1e-18 swETH), showing the liquid staking token received at the current exchange rate.
`in_newTotalETHDeposited`	`STRING`	Cumulative total of ETH deposited into the Swell protocol after this deposit event, denominated in wei. Tracks the running sum of all ETH staked through the swETH contract over time.

Sample Data

address	in_from	removed	in_amount	log_index	block_number	in_swETHMinted	block_timestamp	transaction_hash	in_newTotalETHDeposited
0xf951e335afb289353dc249e82926178eac7ded78	0xe155b3687cd66155de46f8f08f2f12b35357b30a	false	1000000000000000	316	17440938	972470591646355	2023-06-09T06:35:11.000Z	0x83cd7a8b7e81c4441e9f0f60dd1025232f9bbd0e5e9ba67a0063e2e27be4b38b	20388510862154211879096
0xf951e335afb289353dc249e82926178eac7ded78	0x0a7d1beb6258bf28a9092b9a50ebc6433ec8d197	false	2748660000000000	201	17443874	2672991016434670	2023-06-09T16:32:23.000Z	0x592613a2d4d73dee040cf6a1ed7c349feeb4a45cf537b997bcbae54bcf4a0a81	20727647828916157975906
0xf951e335afb289353dc249e82926178eac7ded78	0x5db843f02ed41f73af987339a5dfc6acbef3c0da	false	5000000000000000	86	17444436	4862352958231776	2023-06-09T18:26:47.000Z	0x039bd18eab826a9b02f552ce83935d25b4677a1444028e6a8deb24b4137a2975	20734971828916157975906

Example Query

Query with partition filter

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

swETHV2_ETHDepositReceived_event

ETH deposit events from Swell’s liquid staking protocol (swETH V2) on Ethereum, recording when users stake ETH and receive swETH tokens in return. Tracks deposit amounts, swETH minted, referral addresses, and cumulative protocol deposits for analyzing staking activity and token exchange rates.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_swETHMinted`	`STRING`	Amount of swETH (Swell Ethereum) tokens minted to the depositor in exchange for their ETH deposit. Value is denominated in wei (1e18 per swETH token).
`in_newTotalETHDeposited`	`STRING`	Cumulative total amount of ETH deposited into the Swell protocol after this deposit event, denominated in wei. This running total tracks all historical ETH deposits across all users in the contract.
`in_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.

Sample Data

address	in_from	removed	in_amount	log_index	in_referral	block_number	in_swETHMinted	block_timestamp	transaction_hash	in_newTotalETHDeposited
0xf951e335afb289353dc249e82926178eac7ded78	0x74ebc61d8e1ce460b312ef863b7231fac9ba6049	false	1000000000000000	97	0x0000000000000000000000000000000000000000	18205614	964641700400619	2023-09-24T12:19:59.000Z	0x367ded10252539c36e80aee114d9a1886b13421d9cd6ec0ca3facb7b450de785	47755958155414388951603
0xf951e335afb289353dc249e82926178eac7ded78	0x66e11eec76af138a896ac20ed2750dd93580fa29	false	3000000000000000	332	0x0000000000000000000000000000000000000000	18207129	2893925101201858	2023-09-24T17:25:23.000Z	0x0931d843f834e5d78f78971d04921841c1288cef2663f6fdf866fed9cde390a2	47761962037228886257920
0xf951e335afb289353dc249e82926178eac7ded78	0xfb07d2bdef2deb1ebec001644b4732ab77281c7a	false	3000000000000000	165	0x0000000000000000000000000000000000000000	18202613	2893925101201858	2023-09-24T02:12:59.000Z	0xe2c8ffe3387b00856a12b0c62f3516896fb46bf6b39757a47d634fe88b9cf5f7	47743417989980934779333

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

swETH_ETHDepositReceived_event

swETHV2_ETHDepositReceived_event

​Tables

​swETH_ETHDepositReceived_event

​swETHV2_ETHDepositReceived_event

Tables

swETH_ETHDepositReceived_event

swETHV2_ETHDepositReceived_event