drone-mostafaHodl or Sold when price lower than 1133$
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
›
⌄
WITH tab1 as ( SELECT date_trunc('day', block_timestamp) AS td,to_address
FROM ethereum.udm_events where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
and from_address = '0x0000000000000000000000000000000000000000'
and origin_function_signature = '0xa1903eab'
and to_address = origin_address ),
tab2 as ( SELECT date_trunc('day', hour) as td1, avg(price) as price
FROM ethereum.core.fact_hourly_token_prices
WHERE symbol LIKE 'WETH' GROUP by 1 ),
tab3 as ( SELECT min(td) as td1,
CASE WHEN price < 1133 then 'lower $1,133 ETH' ELSE 'higher than $1,133 Eth' END cat, to_address
FROM tab1 join tab2 on td = td1 GROUP by 2,3 ),
tab4 as ( SELECT DISTINCT from_address as fa
FROM ethereum.udm_events where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84')
SELECT CASE WHEN fa is NULL THEN 'Hodl' else 'Sold' END, count(*)
FROM tab3 LEFT OUTER join tab4 ON to_address = fa
WHERE cat LIKE 'lower $1,133 ETH' GROUP by 1
Run a query to Download Data