SELECT date_trunc('day', HOUR) AS date, avg(price) AS avg_prc

FROM crosschain.price.ez_hourly_prices

WHERE symbol = 'BAT'

GROUP BY 1),

tab1 as (

select date_trunc('day',block_timestamp) as date,

sum(amount_in_usd + amount_out_usd) as trading_volume

from ethereum.defi.ez_dex_swaps

where token_in = '0x0d8775f648430679a709e98d2b0cb6250d2887ef'

OR token_out = '0x0d8775f648430679a709e98d2b0cb6250d2887ef'

GROUP BY 1)

prc.date AS date,

prc.avg_prc AS avg_prc,

tab1.trading_volume

FROM prc

JOIN tab1 on prc.date = tab1.date

ORDER BY 1 DESC