Total Unique Bridge Transactions | Total Unique Bridgers | Total Inflow (USD) | Total Outflow (USD) | Net Flow (USD) | Average Bridged Volume (USD) | Volume Bridged Last 24H (USD) | Active Bridgers Last 24H | |
|---|---|---|---|---|---|---|---|---|
1 | 7445 | 3318 | 1386336.11625626 | 0 | 1386336.11625626 | 186.210358127 | 0 |
datavortexxena
Updated 2025-03-29
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
28
29
30
31
32
33
34
35
36
›
⌄
WITH transaction_data AS (
SELECT
DATE_TRUNC('hour', block_timestamp) AS event_hour,
tx_hash,
decoded_log:user AS wallet_address,
decoded_log:amount AS raw_token_quantity,
'0x31c994ac062c1970c086260bc61babb708643fac' AS token_address,
event_name AS activity_type
FROM avalanche.core.ez_decoded_event_logs
WHERE
contract_address = '0xb866b661db0b1b0f39ed28fc59c77d60983dccbb'
AND event_name IN ('Deposit', 'Withdraw')
),
price_data AS (
SELECT
hour AS recorded_hour,
token_address,
symbol AS token_symbol,
name AS token_name,
decimals,
price
FROM avalanche.price.ez_prices_hourly
WHERE token_address = '0x31c994ac062c1970c086260bc61babb708643fac'
),
final_aggregations AS (
SELECT
t.event_hour,
t.wallet_address,
p.token_symbol,
t.tx_hash,
t.activity_type,
t.raw_token_quantity / POW(10, COALESCE(p.decimals, 18)) AS token_quantity,
p.price * (t.raw_token_quantity / POW(10, COALESCE(p.decimals, 18))) AS usd_value,
p.price
Last run: 3 months ago
1
70B
9s