farid-c9j0VMLido dis*
Updated 2022-09-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
COUNT (DISTINCT TX_HASH) as "Total Number of Unique Staker",
(raw_amount)/pow(10,18) as "Total Amount of ETH Staked",
case
when "Total Amount of ETH Staked" < 0.1 then 'Lower than 0.1 ETHs'
when "Total Amount of ETH Staked" BETWEEN 0.1 and 1 then 'between 0.1-1 ETHs'
when "Total Amount of ETH Staked" BETWEEN 1 and 10 then 'between 1-10 ETHs'
when "Total Amount of ETH Staked" BETWEEN 10 and 100 then 'between 10-100 ETHs'
when "Total Amount of ETH Staked" BETWEEN 100 and 1000 then 'between 100-1000 ETHs'
when "Total Amount of ETH Staked" BETWEEN 1000 and 10000 then 'between 1000-10000 ETHs'
when "Total Amount of ETH Staked" > 10000 then ' more than 10000 ETHs'
end as label
from ethereum_core.fact_token_transfers
where contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84')
and from_address = '0x0000000000000000000000000000000000000000'
and raw_amount > 0
group by label,"Total Amount of ETH Staked"
Run a query to Download Data