select

'Post' as status

,block_timestamp::date as date

,count(tx_hash) as tx_count

,count(DISTINCT origin_from_address) as wallets

,sum(amount_in_usd) as swap_volume

from ethereum.core.ez_dex_swaps

where block_timestamp::date >='2022-09-15'

group by 1,2

order by 1

,pre as (

select

'Pre' as status

,block_timestamp::date as date

,count(tx_hash) as tx_count

,count(DISTINCT origin_from_address) as wallets

,sum(amount_in_usd) as swap_volume

from ethereum.core.ez_dex_swaps

where block_timestamp::date BETWEEN '2022-08-29' and '2022-09-14'

group by 1,2

order by 1

select * from pre

union all

select * from post