with tab11 as (

SELECT

date_trunc('day', hour) as day1,

symbol as symbol1,

avg(price) as daily_price1

FROM ethereum.core.fact_hourly_token_prices

GROUP BY 1,2

--WHERE blockchain LIKE 'near'

--LIMIT 100

), tab1 as (

SELECT

date_trunc('day', timestamp) as day2,

token_contract,

symbol as saymbol2,

median(price_usd) as daily_price2

FROM near.core.fact_prices

GROUP BY 1,2,3

), tab3 as (

SELECT

date_trunc('day', timestamp) as day3,

token_contract as token_contract3,

symbol as saymbol3,

median(price_usd) as daily_price3

FROM near.core.fact_prices

GROUP BY 1,2,3

SELECT

trader,

sum(CASE when NOT daily_price1 is NULL then daily_price1 * amount_out

when NOT daily_price2 is NULL then daily_price2 * amount_out

when NOT daily_price3 is NULL then daily_price3 * amount_in

else 0 end) as volume_usd,

count(DISTINCT tx_hash) as swaps,