DIRECTION | N_BRIDGES | N_BRIDGERS | BRIDGED_AMOUNT_USD | AVG_BRIDGED_AMOUNT_USD | MEDIAN_BRIDGED_AMOUNT_USD | MAX_BRIDGED_AMOUNT_USD | AVG_VOL_PER_RECIPIENT | |
|---|---|---|---|---|---|---|---|---|
1 | sol=>Near | 149 | 30 | 95321.524031191 | 55.645956819 | 0.006311895446 | 10849.989834895 | 3177.384134373 |
2 | eth=>Near | 192 | 49 | 77158.7087979 | 27.092243258 | 0.004745376229 | 14983.909196987 | 1574.667526488 |
3 | Near=>eth | 278 | 127 | 121.915999264 | 0.08860174365 | 0.007339121296 | 1.245 | 0.9599684981 |
4 | Near=>sol | 738 | 54 | 115.010665552 | 0.09512875563 | 0.009899284183 | 0.5641797377 | 2.12982714 |
5 | Near=>base | 14 | 5 | 7.33808565 | 0.08948884939 | 0.01132495572 | 0.564178547 | 1.46761713 |
6 | base=>Near | 3 | 3 | 2.367654176 | 0.04932612867 | 0.006095273153 | 0.3879293868 | 0.7892180588 |
7 | Near=>arb | 2 | 2 | 1.256876146 | 0.08977686759 | 0.01138996848 | 0.5426545845 | 0.6284380731 |
0xHaM-dOver Time copy
Updated 2025-04-30
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 inboundTb as (
select
-- 'Inbound' as direction,
BLOCK_TIMESTAMP,
TX_HASH,
try_parse_json(CLEAN_LOG):FinTransferEvent:transfer_message:recipient::string as recipient,
try_parse_json(CLEAN_LOG):FinTransferEvent:transfer_message:sender::string as sender,
try_parse_json(CLEAN_LOG):FinTransferEvent:transfer_message:token::string as token,
try_parse_json(CLEAN_LOG):FinTransferEvent:transfer_message:amount as amount_unadj,
from near.core.fact_logs
where (PREDECESSOR_ID = 'omni.bridge.near'
and RECEIVER_ID = 'omni.bridge.near')
and try_parse_json(CLEAN_LOG) ilike '%FinTransferEvent%'
-- and tx_hash in (
-- '7fBHBF9uUean7txYj3oapEYdcWKeyojs3PtsbhnCyCsE' -- omni
-- )
and BLOCK_TIMESTAMP >= '2025-02-01'
)
, outboundTb as (
select
-- 'Outbound' as direction,
BLOCK_TIMESTAMP,
TX_HASH,
try_parse_json(CLEAN_LOG):SignTransferEvent:message_payload:recipient::string as recipient,
try_parse_json(CLEAN_LOG):SignTransferEvent:message_payload:transfer_id:origin_chain::string as origin_chain,
try_parse_json(CLEAN_LOG):SignTransferEvent:message_payload:token_address::string as token,
try_parse_json(CLEAN_LOG):SignTransferEvent:message_payload:amount as amount_unadj,
from near.core.fact_logs
where (PREDECESSOR_ID = 'omni.bridge.near'
and RECEIVER_ID = 'omni.bridge.near')
and try_parse_json(CLEAN_LOG) ilike '%SignTransferEvent%'
-- and tx_hash in (
-- 'GyVDzucHZjsen5Sv1fxVjuGmAmgWWzKsw5T1s8jLiCcw' -- omni
-- )
and BLOCK_TIMESTAMP >= '2025-02-01'
)
Last run: about 2 months ago
7
615B
265s