SELECT price,

hour,

FROM base.price.ez_hourly_token_prices

WHERE price > 0 AND token_address IS NOT NULL

),

total_volume as (

SELECT SUM(AMOUNT_OUT*price) as "Daily volume",

avg(AMOUNT_OUT*price) as "Average volume per swap",

COUNT(DISTINCT tx_hash) as daily_swaps,

"Daily volume"/daily_swaps as "Average swap volume",

COUNT(DISTINCT origin_from_address) as daily_swappers,

date_trunc('day', block_timestamp) as day

FROM base.defi.ez_dex_swaps s

JOIN prices_tab p ON (s.token_out = p.token_address AND date_trunc('hour', s.block_timestamp) = p.hour)

WHERE platform = 'baseswap'

GROUP BY date_trunc('day', block_timestamp)

ORDER BY day DESC

SELECT * FROM total_volume