select

count( tx_hash) as "all_Trades"

,count(DISTINCT TRADER) as Traders

,count(DISTINCT block_timestamp::date) as "Activity Days"

,sum(AMOUNT_USD) as "Total Perp Volume"

from arbitrum.vertex.ez_perp_trades

-- where IS_TAKER =true

union all

select

count( tx_hash)

,count(DISTINCT TRADER)

,count(DISTINCT block_timestamp::date)

,sum(AMOUNT_USD)

from arbitrum.vertex.ez_spot_trades

-- where IS_TAKER =true

select

sum("all_Trades") as "TRADES"

,sum(Traders) as "Traders"

,sum("Total Perp Volume") as "Total Trading Volume"

from lst_all