Bridger Address | Total Volume Bridged (USD) | |
|---|---|---|
1 | 0xc89048d9e96f16b3e4a5e9f84caea67517bdb411 | 2204387.86940843 |
2 | 0xa3f87fbcc69d2f97f528266c35b713e4bb12f962 | 1987834.90714706 |
3 | 0x1507ae2c7db7c4a1078eb1b3847b4aa33cfc586a | 1369640.3506071 |
4 | 0xe71af80fde47c8c78f327354e4d25081058ec727 | 926675.288642096 |
5 | 0x2472f6c57ad97903d81741acdf462fa9d22c858f | 843736.788322479 |
6 | 0x02b79df8c38f29f39888557c0a89917fd99ddf77 | 788740.610161018 |
7 | 0x9b81d498c824aea5392ee81e777347d770782ece | 774966.855828871 |
8 | 0x50664ede715e131f584d3e7eaabd7818bb20a068 | 721378.45309362 |
9 | 0x2fe09e93acbb8b0da86c394335b8a92d3f5e273e | 624858.996678868 |
10 | 0x0792057e5da09de339cc1e4976472bd3d29baf14 | 607727.29780526 |
datavortexdfk top
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 dfk_tx AS (
SELECT
DATE_TRUNC('hour', block_timestamp) AS date_hour,
tx_hash,
origin_from_address AS sender,
origin_to_address AS receiver,
decoded_log:token::STRING AS token_address,
decoded_log:amount AS raw_amount,
CASE
WHEN event_name = 'TokenDeposit' THEN 'Deposit'
WHEN event_name IN ('TokenRedeem', 'TokenRedeemAndSwap') THEN 'Withdraw'
END AS flow_direction
FROM avalanche.core.ez_decoded_event_logs
WHERE contract_address = '0xc05e61d0e7a63d27546389b7ad62fdff5a91aace'
AND event_name IN ('TokenDeposit', 'TokenRedeem', 'TokenRedeemAndSwap')
AND decoded_log:chainId = '53935'
),
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
),
enriched_dfk AS (
SELECT
dt.date_hour AS block_timestamp,
dt.tx_hash,
dt.token_address,
tp.token_symbol AS "Token Symbol",
tp.token_name AS "Token Name",
COALESCE(tp.decimals, 18) AS "Token Decimals",
tp.price AS "Token Price (USD)",
Last run: 3 months ago
10
638B
10s