mo115Total Stakes avg
Updated 2022-09-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 DATEDIFF(day, min(block_timestamp),
max(block_timestamp)) AS period,
count(distinct TX_HASH) as deposits,
count(distinct to_ADDRESS) as depositors,
sum(AMOUNT)as ETH ,
sum(AMOUNT_USD)as usd,
(usd/ETH) as avg_cost,
'Stakewise' as platform
from ethereum.core.ez_token_transfers
where CONTRACT_ADDRESS = '0xfe2e637202056d30016725477c5da089ab0a043a'
and FROM_ADDRESS= '0x0000000000000000000000000000000000000000'
and SYMBOL='sETH2'
and AMOUNT_USD is not null
)
UNION
(select DATEDIFF(day, min(block_timestamp),
max(block_timestamp)) AS period,
count(distinct TX_HASH) as deposits,
count(distinct to_ADDRESS) as depositors,
sum(AMOUNT)as ETH ,
sum(AMOUNT_USD)as usd,
(usd/ETH) as avg_cost,
'Lido' as platform
from ethereum.core.ez_token_transfers
where CONTRACT_ADDRESS = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
and FROM_ADDRESS= '0x0000000000000000000000000000000000000000'
and SYMBOL='stETH'
and AMOUNT_USD is not null
)
UNION
(select DATEDIFF(day, min(block_timestamp),
Run a query to Download Data