leo-lZzln2Number of Unique ETH Stakers per Month dex and cex
Updated 2022-10-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select date_trunc('month',block_timestamp) as month, sum(amount) as eth_vol, count(distinct eth_from_address) as staker_count, count(tx_hash) as stake_count,
sum(amount_usd) as eth_vol_usd,
SUM(eth_vol) OVER (order by month asc rows between unbounded preceding and current row) AS Cummulative_eth_vol,
SUM(staker_count) OVER (order by month asc rows between unbounded preceding and current row) AS Cummulative_staker_count,
SUM(stake_count) OVER (order by month asc rows between unbounded preceding and current row) AS Cummulative_stake_count, case
when eth_to_address='0x84db6ee82b7cf3b47e8f19270abde5718b936670' then 'Ankr'
when eth_to_address='0x39dc6a99209b5e6b81dc8540c86ff10981ebda29' then 'Staked.us'
when eth_to_address='0x2f47a1c2db4a3b78cda44eade915c3b19107ddcc' then 'binnace'
when eth_to_address='0xa40dfee99e1c85dc97fdc594b16a460717838703' then 'kraken'
end as platform
from ethereum.core.ez_eth_transfers
where (
eth_to_address='0x84db6ee82b7cf3b47e8f19270abde5718b936670' -- Ankr
or eth_to_address='0x39dc6a99209b5e6b81dc8540c86ff10981ebda29' --staked.us
or eth_to_address='0x2f47a1c2db4a3b78cda44eade915c3b19107ddcc' --binnace
or eth_to_address='0xa40dfee99e1c85dc97fdc594b16a460717838703') --kraken
group by 1,9
order by 1
Run a query to Download Data