select recorded_at::date as day,

avg (price) as EVMOSPrice

from osmosis.core.dim_prices

where symbol = 'EVMOS'

and recorded_at >= CURRENT_DATE - 7

group by 1)

select 'From EVMOS' as swap_type,

block_timestamp::date as date,

count (distinct tx_id) as Swaps_Count,

count (distinct trader) as Swappers_Count,

sum (from_amount/1e18) as EVMOS_Volume,

sum ((from_amount/1e18)*EVMOSPrice) as USD_Volume,

avg (from_amount/1e18) as AVG_EVMOS_Volume,

median (from_amount/1e18) as Median_EVMOS_Volume,

avg ((from_amount/1e18)*EVMOSPrice) as AVG_USD_Volume,

median ((from_amount/1e18)*EVMOSPrice) as Median_USD_Volume,

sum (usd_volume) over (order by date) as Cumulative_USD_Volume,

sum (EVMOS_Volume) over (order by date) as Cumulative_EVMOS_Volume

from osmosis.core.fact_swaps t1 join EVMOSPricet t2 on t1.block_timestamp::date = t2.day

where from_currency = 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A'

and block_timestamp >= CURRENT_DATE - 7

and tx_status = 'SUCCEEDED'

group by 1,2

union ALL

select 'To EVMOS' as swap_type,

block_timestamp::date as date,

count (distinct tx_id) as Swaps_Count,

count (distinct trader) as Swappers_Count,

sum (to_amount/1e18) as EVMOS_Volume,

sum ((to_amount/1e18)*EVMOSPrice) as USD_Volume,

avg (to_amount/1e18) as AVG_EVMOS_Volume,