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 | 97599 | 29170 | 15678726.7064384 | 4714573.80695804 | 10964152.8994804 | 209.095574878 | 0 |
datavortexSwimmer Totals
Updated 2025-03-29
999
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 celer_transfers AS (
SELECT
block_timestamp,
tx_hash,
contract_address,
decoded_log:from::string AS sender,
decoded_log:to::string AS receiver,
decoded_log:value::decimal AS raw_transfer_value,
'Celer' AS bridge_name,
CASE
WHEN decoded_log:from = '0xb51541df05de07be38dcfc4a80c05389a54502bb' THEN decoded_log:to::string
WHEN decoded_log:to = '0xb51541df05de07be38dcfc4a80c05389a54502bb' THEN decoded_log:from::string
END AS bridger,
CASE
WHEN decoded_log:from = '0xb51541df05de07be38dcfc4a80c05389a54502bb' THEN 'Outflow'
WHEN decoded_log:to = '0xb51541df05de07be38dcfc4a80c05389a54502bb' THEN 'Inflow'
END AS flow_direction
FROM avalanche.core.ez_decoded_event_logs
WHERE (decoded_log:to = '0xb51541df05de07be38dcfc4a80c05389a54502bb'
OR decoded_log:from = '0xb51541df05de07be38dcfc4a80c05389a54502bb')
AND decoded_log:from <> '0x0000000000000000000000000000000000000000'
AND decoded_log:to <> '0x0000000000000000000000000000000000000000'
), layerzero_transfers AS (
SELECT
block_timestamp,
tx_hash,
contract_address,
decoded_log:from::string AS sender,
decoded_log:to::string AS receiver,
decoded_log:value::decimal AS raw_transfer_value,
'LayerZero' AS bridge_name,
CASE
WHEN decoded_log:from = '0xfd21f6833b3a8e0ad2d1a684497ff58f55bbaf8c' THEN decoded_log:to::string
WHEN decoded_log:to = '0xfd21f6833b3a8e0ad2d1a684497ff58f55bbaf8c' THEN decoded_log:from::string
END AS bridger,
CASE
Last run: about 2 months ago
1
87B
22s