with spot_trades as ( select BLOCK_TIMESTAMP, TX_HASH, CONTRACT_ADDRESS, SYMBOL, TRADER, AMOUNT_USD from arbitrum.vertex.ez_spot_trades where IS_TAKER AND trader <> '0x0000000000000000000000000000000000000000' AND subaccount<>'0x0000000000000000000000000000000000000000000000000000000000000001' UNION select BLOCK_TIMESTAMP, TX_HASH, CONTRACT_ADDRESS, SYMBOL, TRADER, AMOUNT_USD from mantle.vertex.ez_spot_trades where IS_TAKER AND trader <> '0x0000000000000000000000000000000000000000' AND subaccount<>'0x0000000000000000000000000000000000000000000000000000000000000001' ), perp_trades as ( select BLOCK_TIMESTAMP, TX_HASH, CONTRACT_ADDRESS, SYMBOL, TRADER, AMOUNT_USD from arbitrum.vertex.ez_perp_trades where IS_TAKER UNION select BLOCK_TIMESTAMP, TX_HASH, CONTRACT_ADDRESS, SYMBOL, TRADER, AMOUNT_USD from mantle.vertex.ez_perp_trades where IS_TAKER AND trader <> '0x0000000000000000000000000000000000000000' AND subaccount<>'0x0000000000000000000000000000000000000000000000000000000000000001' UNION select BLOCK_TIMESTAMP, TX_HASH, CONTRACT_ADDRESS, SYMBOL, TRADER, AMOUNT_USD from base.vertex.ez_perp_trades where IS_TAKER AND trader <> '0x0000000000000000000000000000000000000000' AND subaccount<>'0x0000000000000000000000000000000000000000000000000000000000000001' UNION select BLOCK_TIMESTAMP, TX_HASH, CONTRACT_ADDRESS, SYMBOL, TRADER, AMOUNT_USD from sei.vertex.ez_perp_trades where IS_TAKER AND trader <> '0x0000000000000000000000000000000000000000' AND subaccount<>'0x0000000000000000000000000000000000000000000000000000000000000001' UNION select BLOCK_TIMESTAMP, TX_HASH, CONTRACT_ADDRESS, SYMBOL, TRADER, AMOUNT_USD from blast.blitz.ez_perp_trades where IS_TAKER AND trader <> '0x0000000000000000000000000000000000000000' AND subaccount<>'0x0000000000000000000000000000000000000000000000000000000000000001' ), all_ as ( select 'SPOT' type , * from spot_trades UNION all select 'PERP' type , * from perp_trades ), daily as ( select date_trunc(day,BLOCK_TIMESTAMP) ::date daily , count (TX_HASH) num_trades , count (DISTINCT TRADER ) num_traders , sum (zeroifnull(AMOUNT_USD)) traded_volume , from all_ group by 1 ) select date_trunc(day,daily) ::date daily , avg(num_trades) avg_trades, avg(num_traders) avg_traders, avg(traded_volume) avg_traded_volume from daily group by 1

Query	Creator	Created
[Vertex protocol ] - overall over time average arbitrum base sei l2 ibc	saeedmzn	Mar 14, 2024
Voting Power Within the Arbitrum DAO - num delegators interacted with contracts arbitrum l2 evm	saeedmzn	Apr 4, 2023

saeedmzn