tx_hash,

'Inflow' as type,

block_timestamp,

amount_in as amount_usd,

trader as user

from near.core.ez_dex_swaps

where token_in_contract = 'usdt.tether-token.near'

count(distinct tx_hash) as swaps,

count(distinct user) as swappers,

sum(amount_usd) as volume_usd,

min(block_timestamp)::date as first_transaction_date,

avg(amount_usd) as average_volume_usd,

median(amount_usd) as median_volume_usd,

swaps / count(distinct date_trunc('day', block_timestamp::date)) as daily_average_swaps,

swappers / count(distinct date_trunc('day', block_timestamp::date)) as daily_average_swappers

from t