SELECT

ORIGIN_FROM_ADDRESS,

count(*) as amt,

min(date_trunc('day', block_timestamp)) as day_buy

FROM ethereum.core.ez_dex_swaps

WHERE symbol_out LIKE 'WETH'

GROUP by 1

HAVING amt > 2

), tab2 as (

SELECT

ORIGIN_FROM_ADDRESS,

min(date_trunc('day', block_timestamp)) as day_sell

FROM ethereum.core.ez_dex_swaps

WHERE symbol_in LIKE 'WETH'

GROUP by 1

), tab3 as (

SELECT

tab1.ORIGIN_FROM_ADDRESS as user1,

DATEDIFF(day, DAY_SELL, DAY_BUY) as hodl_days

FROM tab1 JOIN tab2

ON tab1.ORIGIN_FROM_ADDRESS = tab2.ORIGIN_FROM_ADDRESS

where hodl_days > 700

SELECT

count(*) as amt,

sum(AMOUNT_OUT) as volume

FROM ethereum.core.ez_dex_swaps

WHERE symbol_out LIKE 'WETH'

AND ORIGIN_FROM_ADDRESS in (SELECT user1 FROM tab3)