SYMBOL | NUMBER_OF_BRIDGE_TRANSACTIONS | NUMBER_OF_BRIDGERS | TOTAL_VOLUME | |
|---|---|---|---|---|
1 | PIXEL | 108 | 73 | 69455399.0895628 |
2 | WETH | 9507 | 5229 | 62991747.3241748 |
3 | USDC | 2791 | 1536 | 21517579.0323376 |
4 | AXS | 931 | 496 | 20050550.3686761 |
5 | YGG | 78 | 38 | 4795602.99364773 |
6 | APRS | 187 | 45 | 2331858.07277548 |
7 | JAIHOZ | 1607 | 553 | 1033233.01693559 |
8 | ZENT | 156 | 68 | 942519.831788468 |
9 | BANANA | 236 | 144 | 164892.720327064 |
10 | LUAUSD | 18 | 2 | 99030.759336064 |
11 | KOGIN | 175 | 44 | 74529.259914536 |
12 | LINK | 757 | 626 | 55694.652445558 |
13 | CGX | 12 | 9 | 23699.234133354 |
14 | SLP | 81 | 66 | 16122.39030377 |
15 | WBTC | 16 | 11 | 15245.66587071 |
16 | LUA | 4 | 2 | 6400.12161105 |
17 | ANIMA | 1 | 1 | 4.429808 |
0xHaM-dIn Total by Asset
Updated 11 hours ago
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
›
⌄
-- forked from Ronin Bridge data @ https://flipsidecrypto.xyz/Sandesh/q/s0t77Lcxz60S/ronin-bridge-stats
WITH eth_to_ronin_native as (
select
'ethereum'::VARCHAR as blockchain
, 'axie infinity: ronin bridge v2'::VARCHAR as platform
, edl.block_number::INT as block_number
, edl.block_timestamp::TIMESTAMP as block_timestamp
, edl.tx_hash::VARCHAR as tx_hash
, 'ethereum'::VARCHAR as source_chain
, 'ronin'::VARCHAR as destination_chain
, edl.origin_to_address::VARCHAR as bridge_address
, edl.origin_from_address::VARCHAR as source_address
, edl.decoded_log['receipt']['ronin']['addr']::VARCHAR as destination_address
, 'outbound'::VARCHAR as direction
, edl.decoded_log['receipt']['mainchain']['tokenAddr']::VARCHAR as token_address
, coalesce(pr.symbol,dc.symbol)::VARCHAR as token_symbol
, edl.decoded_log['receipt']['info']['quantity']::DOUBLE as amount_unadj
, (edl.decoded_log['receipt']['info']['quantity']/pow(10,pr.decimals))::DOUBLE as amount
, (edl.decoded_log['receipt']['info']['quantity']/pow(10,pr.decimals))*pr.price::DOUBLE as amount_usd
, current_timestamp() as inserted_timestamp
, current_timestamp() as modified_timestamp
-- , row_number() over (order by edl.block_timestamp asc, edl.tx_hash asc) as ez_bridge_activity_id
from ethereum.core.ez_decoded_event_logs edl
left join crosschain.price.ez_prices_hourly pr
on (date_trunc('hour',edl.block_timestamp)=pr.hour and edl.decoded_log['receipt']['mainchain']['tokenAddr']=pr.token_address)
left join ethereum.core.dim_contracts dc
on (edl.decoded_log['receipt']['mainchain']['tokenAddr']=dc.address)
where 1=1
and edl.block_timestamp >= '2025-01-01'
and edl.topics[0]=lower('0xd7b25068d9dc8d00765254cfb7f5070f98d263c8d68931d937c7362fa738048b')
and pr.blockchain='ethereum'
)
, ronin_to_ethereum_native_bridge as
(
with bridge_data as
Last run: about 11 hours ago
17
545B
228s