Pmisha-bmlMdxbucket.stakers
Updated 2022-04-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
CASE
when amount between '0' and '1' then 'Tiny: 0-1 ETH'
when amount between '2' and '10'then 'Small: 2-10 ETH'
when amount between '11' and '30' then 'Medium: 11-30 ETH'
when amount between '31' and '100' then 'Big: 31-100 ETH'
when amount > '100' then 'Huge: over 100 ETH'
end as stakers,
count(distinct origin_address) as stake_wallets,
count (tx_id) as number_stake,
sum(amount_usd) as stake_USD,
sum(amount) as stake_ETH
from ethereum.udm_events
where to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and symbol='ETH' and event_name = 'transfer' and block_timestamp>= CURRENT_DATE-90
group by 1 having stakers is not null
Run a query to Download Data