select trader,

min (block_timestamp) as Mindate

from osmosis.core.fact_swaps

where from_currency = 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A'

and tx_status = 'SUCCEEDED'

group by 1),

table2 as (

select trader,

min (block_timestamp) as Mindate

from osmosis.core.fact_swaps

where to_currency = 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A'

and tx_status = 'SUCCEEDED'

group by 1)

select 'Swap From EVMOS' as swap_type,

mindate::date as date,

count (distinct trader) as New_Users,

sum (new_users) over (order by date) as Total_Users

from table1

group by 1,2

union ALL

select 'Swap to EVMOS' as swap_type,

mindate::date as date,

count (distinct trader) as New_Users,

sum (new_users) over (order by date) as Total_Users

from table2

group by 1,2