AmiRdaily
Updated 2024-10-16
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select block_timestamp::date as day,
count(DISTINCT TX_hash) as bridge,
count(distinct ORIGIN_FROM_ADDRESS) as bridger,
count(DISTINCT TOKEN_SYMBOL) as tokens_bridged,
sum(AMOUNT_USD) as bridge_vol
from avalanche.defi.ez_bridge_activity
where BLOCK_TIMESTAMP>=current_date-60
group by 1
order by 1
QueryRunArchived: QueryRun has been archived