adambalaHODL or Sell?
Updated 2022-06-16
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
30
31
32
33
34
35
36
›
⌄
with
a as (
select date(block_timestamp) as date, amount ,origin_address,amount_usd,TX_ID
from ethereum.udm_events
where block_timestamp::date>=CURRENT_DATE-90
and to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
AND event_type = 'native_eth'
and amount_usd>0
and date <'2021-01-01' or date between '2021-05-01' and '2022-02-01'
),
now as (
select
user_address ,
balance ,
amount_usd
from ethereum.erc20_balances
where lower(contract_address) = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84' )
and balance_date::date = current_date - 1
and user_address in ( select origin_address from a)
),
b as (
select
now.user_address,
now.amount_usd as now,
a.amount_usd as past
from now inner join a on user_address=origin_address
group by 1,2,3
)
select
count(distinct user_address) as holders,
case when now > past then 'add more stETH'
when now = past then 'Hold'
when now < past then 'sold' else 'Hold'
Run a query to Download Data