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 | 22690 | 14470 | 3016555.07611079 | 0 | 3016555.07611079 | 132.975758259 | 0 |
datavortexTotal STepper
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 token_prices AS (
SELECT
hour AS price_hour,
token_address,
symbol AS token_symbol,
name AS token_name,
decimals,
price
FROM avalanche.price.ez_prices_hourly
),
tx AS (
SELECT
DATE_TRUNC('hour', block_timestamp) AS date_hour,
tx_hash,
origin_from_address AS sender,
contract_address::STRING AS token_address,
decoded_log:value * POW(10, -COALESCE(tp.decimals, 18)) AS token_amount,
CASE
WHEN decoded_log:to = '0xb890ef7a535488e4560b4b5b1690d916412c5f53' THEN 'Deposit'
WHEN decoded_log:from = '0xb890ef7a535488e4560b4b5b1690d916412c5f53' THEN 'Withdraw'
END AS flow_direction,
tp.price * (decoded_log:value * POW(10, -COALESCE(tp.decimals, 18))) AS transfer_value_usd
FROM avalanche.core.ez_decoded_event_logs
LEFT JOIN token_prices tp
ON contract_address = tp.token_address AND DATE_TRUNC('hour', block_timestamp) = tp.price_hour
WHERE (decoded_log:to = '0xb890ef7a535488e4560b4b5b1690d916412c5f53'
OR decoded_log:from = '0xb890ef7a535488e4560b4b5b1690d916412c5f53')
AND decoded_log:value IS NOT NULL
),
stats AS (
SELECT
COUNT(DISTINCT tx_hash) AS "Total Unique Bridge Transactions",
COUNT(DISTINCT sender) AS "Total Unique Bridgers",
SUM(CASE WHEN flow_direction = 'Deposit' THEN transfer_value_usd ELSE 0 END) AS "Total Inflow (USD)",
SUM(CASE WHEN flow_direction = 'Withdraw' THEN transfer_value_usd ELSE 0 END) AS "Total Outflow (USD)",
SUM(transfer_value_usd) AS "Net Flow (USD)",
Last run: 2 months ago
1
72B
23s