block_timestamp::date as date,

count (distinct tx_hash) as tx_count,

count (distinct origin_from_address) as Users_Count,

sum (amount_in) as Volume

from ethereum.core.ez_dex_swaps

where symbol_in in ('WETH','ETH','aETH','aWETH','cETH','cbETH','fETH','iETH','ibETH','icETH','pETH','rETH','sETH','stETH','stkETH','vETH','wstETH')

and origin_from_address in (select miner from ethereum.core.fact_blocks)

and block_timestamp >= '2022-07-15'

group by 1,2

union ALL

select 'Non-Miners' as type,

block_timestamp::date as date,

count (distinct tx_hash) as tx_count,

count (distinct origin_from_address) as Users_Count,

sum (amount_in) as Volume

from ethereum.core.ez_dex_swaps

where symbol_in in ('WETH','ETH','aETH','aWETH','cETH','cbETH','fETH','iETH','ibETH','icETH','pETH','rETH','sETH','stETH','stkETH','vETH','wstETH')

and origin_from_address not in (select miner from ethereum.core.fact_blocks)

and block_timestamp >= '2022-07-15'

group by 1,2