Eman-RazSatellite Activity Over Time
Updated 2024-10-31
9
1
2
3
4
5
6
7
8
›
⌄
select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", token_symbol, sum(amount) as bridge_amount,avg(amount) as avg_bridge_amount,
count(distinct tx_hash) as bridge_tx_count,count(distinct sender) as sender_count,count(distinct receiver) as receiver_count
from axelar.defi.ez_bridge_{{bridge}}
where token_symbol in
('BUSD','DAI','FRAX','USDC','USDC.axl','USDT','USDT.axl','YieldUSD','avalanche.USDC','axlDAI','axlFRAX','axlUSDC','axlUSDT','polygon.USDC')
and block_timestamp::date>=current_date-{{Time_Period}}
group by 1,2
order by 1
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived