Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_swETHMintedSTRINGAmount 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_newTotalETHDepositedSTRINGCumulative 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.
addressin_fromremovedin_amountlog_indexblock_numberin_swETHMintedblock_timestamptransaction_hashin_newTotalETHDeposited
0xf951e335afb289353dc249e82926178eac7ded780xe155b3687cd66155de46f8f08f2f12b35357b30afalse1000000000000000316174409389724705916463552023-06-09T06:35:11.000Z0x83cd7a8b7e81c4441e9f0f60dd1025232f9bbd0e5e9ba67a0063e2e27be4b38b20388510862154211879096
0xf951e335afb289353dc249e82926178eac7ded780x0a7d1beb6258bf28a9092b9a50ebc6433ec8d197false27486600000000002011744387426729910164346702023-06-09T16:32:23.000Z0x592613a2d4d73dee040cf6a1ed7c349feeb4a45cf537b997bcbae54bcf4a0a8120727647828916157975906
0xf951e335afb289353dc249e82926178eac7ded780x5db843f02ed41f73af987339a5dfc6acbef3c0dafalse5000000000000000861744443648623529582317762023-06-09T18:26:47.000Z0x039bd18eab826a9b02f552ce83935d25b4677a1444028e6a8deb24b4137a297520734971828916157975906
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_swETHMintedSTRINGAmount 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_newTotalETHDepositedSTRINGCumulative 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_referralSTRINGReferral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.
addressin_fromremovedin_amountlog_indexin_referralblock_numberin_swETHMintedblock_timestamptransaction_hashin_newTotalETHDeposited
0xf951e335afb289353dc249e82926178eac7ded780x74ebc61d8e1ce460b312ef863b7231fac9ba6049false1000000000000000970x0000000000000000000000000000000000000000182056149646417004006192023-09-24T12:19:59.000Z0x367ded10252539c36e80aee114d9a1886b13421d9cd6ec0ca3facb7b450de78547755958155414388951603
0xf951e335afb289353dc249e82926178eac7ded780x66e11eec76af138a896ac20ed2750dd93580fa29false30000000000000003320x00000000000000000000000000000000000000001820712928939251012018582023-09-24T17:25:23.000Z0x0931d843f834e5d78f78971d04921841c1288cef2663f6fdf866fed9cde390a247761962037228886257920
0xf951e335afb289353dc249e82926178eac7ded780xfb07d2bdef2deb1ebec001644b4732ab77281c7afalse30000000000000001650x00000000000000000000000000000000000000001820261328939251012018582023-09-24T02:12:59.000Z0xe2c8ffe3387b00856a12b0c62f3516896fb46bf6b39757a47d634fe88b9cf5f747743417989980934779333
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