Total Unique Bridge Transactions | Token Symbol | Net Flow (USD) | |
|---|---|---|---|
1 | 22419 | CRA | 4883506.57445956 |
2 | 185 | DGNX | 1679538.80109533 |
3 | 211 | SNCT | 2158.734452575 |
4 | 244 | TOC | -2004.182011761 |
5 | 51265 | TUS | 4400690.60686324 |
6 | 23207 | USDC | 262.364621418 |
datavortexswimmer token
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
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
Last run: 3 months ago
6
178B
56s