select

date_trunc('day', hour) as date,

upper(symbol) as symbol,

avg(price) as price_usd

from aptos.price.ez_prices_hourly

where hour::date >= '2025-01-01'

group by 1, 2

),

base as (

block_timestamp,

tx_hash,

swapper,

platform,

token_in,

token_out,

symbol_in,

symbol_out,

amount_in * tin.price_usd as amount_in_usd,

amount_out * tout.price_usd as amount_out_usd

from

aptos.defi.ez_dex_swaps

left join price tin on upper(tin.symbol) = upper(symbol_in) and tin.date = block_timestamp::date

left join price tout on upper(tout.symbol) = upper(symbol_out) and tout.date = block_timestamp::date

where

block_timestamp::date >= '2025-01-01'

),

users as (

date_trunc('day', block_timestamp) as date,

swapper,