drone-mostafaHodl or Sold when price lower than 1133$
    Updated 2022-06-15
    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