with main as (
SELECT
'Spot' as Type,
block_timestamp,
TRADER,
tx_hash,
AMOUNT_USD,
fee_amount
from arbitrum.vertex.ez_spot_trades
where IS_TAKER = 'TRUE'
union all
SELECT
'Perp' as Type,
block_timestamp,
TRADER,
tx_hash,
AMOUNT_USD,
fee_amount
from arbitrum.vertex.ez_perp_trades
where IS_TAKER = 'TRUE'
)
select
Type,
count(tx_hash) as "Trade",
sum(zeroifnull(AMOUNT_USD)) as "Volume",
sum(zeroifnull(fee_amount)) as Fee,
avg(zeroifnull(fee_amount)) as Avg_fee
from main
group by 1