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,

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 (SELECT SUM(daily_volume) FROM total_volume) as total_volume, COUNT(DISTINCT tx_hash) as total_swaps, COUNT(DISTINCT origin_from_address) as total_swappers

FROM base.defi.ez_dex_swaps

WHERE platform = 'baseswap'