hessTotal Bridge
Updated 2025-02-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with base as ( select block_timestamp,
tx_hash,
origin_from_address,
to_address,
amount_usd
from avalanche.core.ez_native_transfers
where block_timestamp::date >= current_date - 180
UNION
select block_timestamp,
tx_hash,
origin_from_address,
to_address,
amount_usd
from avalanche.core.ez_token_transfers
where block_timestamp::date >= current_date - 180
)
select
count(DISTINCT to_address) as "Bridgers",
count(DISTINCT tx_hash) as "Inflow Transaction",
sum(amount_usd) as "Inflow Volume (USD)",
avg(amount_usd) as "Average Inflow Volume (USD)"
from base a join avalanche.core.dim_labels b on a.origin_from_address = b.address
where label_type = 'bridge'
and to_address not in (select address from avalanche.core.dim_labels where label_type = 'bridge')
and block_timestamp::date >= current_date - 180
QueryRunArchived: QueryRun has been archived