freemartianLow Price Stakers
Updated 2022-06-15
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
›
⌄
with low_price as (
select distinct tx_from_address as staker, sum(event_inputs:amount)/pow(10,18) as staked_amount
from ethereum.events_emitted
where contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
and event_name = 'Submitted'
and block_timestamp between '2020-12-23' and '2021-02-01'
group by tx_from_address
),
now as (
select user_address, balance, staked_amount
from flipside_prod_db.ethereum.erc20_balances b
inner join low_price lp on b.user_address = lp.staker
where symbol = 'stETH'
and balance_date = CURRENT_DATE - 1
)
select count(user_address) as count, 'Hodlers' as label
from now
where balance = staked_amount
UNION
select count(user_address) as count, 'Seller' as label
from now
where balance < staked_amount
UNION
select count(user_address) as count, 'Buyer' as label
from now
where balance > staked_amount
Run a query to Download Data