shadilDistribution of Rocketpool stake amount
Updated 2022-09-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select case when volume <=0.01 then 'Less than 0.01 ETH'
when volume > 0.01 and volume <= 0.1 then 'Between 0.01 and 0.1 ETH'
when volume > 0.1 and volume <= 1 then 'Between 0.1 and 1 ETH'
when volume > 1 and volume <= 2 then 'Between 1 and 2 ETH'
when volume > 2 and volume <= 3 then 'Between 2 and 3 ETH'
when volume > 3 and volume <= 5 then 'Between 5 and 5 ETH'
when volume > 5 and volume <= 10 then 'Between 5 and 10 ETH'
when volume > 10 and volume <= 15 then 'Between 10 and 15 ETH'
when volume > 15 and volume <= 30 then 'Between 15 and 30 ETH'
when volume > 30 and volume <= 50 then 'Between 30 and 50 ETH'
when volume > 50 and volume <= 100 then 'Between 50 and 100 ETH'
when volume > 100 then 'More than 100 ETH' end as category,
count (distinct tx_hash) as total
from (select event_inputs:value/pow(10,18) as volume, tx_hash
from ethereum_core.fact_event_logs
where event_inputs:from in ('0x0000000000000000000000000000000000000000')
and event_name in ('Transfer')
and origin_to_address ilike '%0x4d05e3d48a938db4b7a9a59a802d5b45011bde58%')
where category is not null
group by category
Run a query to Download Data