Eman-Razhushed-violet
Updated 2024-10-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select sum(amount_usd) as "Transfers Volume",
avg(amount_usd) as "Avg",
median(amount_usd) as "Median",
max(amount_usd) as "Max",
count(distinct tx_hash) as "Transfers Count",
count(distinct source_address) as "Senders Count",
count(distinct destination_address) as "Receivers Count",
count(distinct source_chain || '➡' || destination_chain) as "# of Path"
FROM near.defi.ez_bridge_activity
where platform='allbridge'
and (source_chain='near' or destination_chain='near')
and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'
QueryRunArchived: QueryRun has been archived