First Restake Day | STAKERS | UNSTAKERS | MINTS | BURNS | CIRCULATING_SUPPLY | ETH_PRICE_USD | MARKETCAP_USD | |
|---|---|---|---|---|---|---|---|---|
1 | 0 | 0 | 1874.16 |
datavortexswell native bridge
Updated 2025-04-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
⌄
⌄
⌄
/*
SELECT min(block_timestamp)
, SUM(decoded_log:amount)/ 1e18 as "total amount"
,COUNT(distinct tx_hash) as restakes
,COUNT(distinct origin_from_address) as "stakers"
FROM ethereum.core.ez_decoded_event_logs
where event_name = 'ETHDepositReceived'
AND origin_function_signature = '0xd0e30db0'
and contract_address = LOWER('0xfae103dc9cf190ed75350761e95403b7b8afa6c0')
and origin_to_address = '0xfae103dc9cf190ed75350761e95403b7b8afa6c0'
*/
/*
SELECT count(distinct tx_hash)
, SUM(decoded_log:amount/1e18)
, COUNT(distinct decoded_log:from)
FROM ethereum.core.ez_decoded_event_logs
where contract_address = '0xf951e335afb289353dc249e82926178eac7ded78'
and event_name = 'ETHDepositReceived'
and origin_function_signature = '0x12599ac6'
limit 500
*/
/*
SELECT distinct origin_to_address
FROM ethereum.core.ez_decoded_event_logs
where event_name = 'ETHDepositReceived'
and contract_address = '0xfae103dc9cf190ed75350761e95403b7b8afa6c0'
*/
/*
select * from ethereum.core.ez_decoded_event_logs
where tx_hash = '0x0e794d2c33d3f4f67850cb351e6a6c6c715f6c4fd6a13f44200a05e836d4032e'
where contract_address = '0xfae103dc9cf190ed75350761e95403b7b8afa6c0'
and date(block_timestamp) = '2025-03-07'
*/
SELECT
Last run: 20 days ago
1
40B
1s