NUMBER_OF_BRIDGE_TRANSACTIONS | NUMBER_OF_BRIDGERS | NUMBER_OF_TOKENS | TOTAL_VOLUME | NET_VOLUME | |
|---|---|---|---|---|---|
1 | 5649 | 3178 | 19 | 42982458.6522096 | -9244915.91594722 |
SandeshRonin bridge stats
Updated 9 days 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
›
⌄
WITH chain_ids AS (
SELECT *
FROM (
VALUES
(1, 'ethereum', 'Ethereum Mainnet'),
(10, 'optimism', 'Optimism'),
(137, 'polygon', 'Polygon'),
(42161, 'arbitrum', 'Arbitrum One'),
(43114, 'avalanche', 'Avalanche C-Chain'),
(56, 'bsc', 'BNB Smart Chain'),
(8453, 'base', 'Base'),
(2020, 'ronin', 'Ronin'),
(5, 'ethereum', 'Goerli Testnet'),
(11155111, 'ethereum', 'Sepolia Testnet'),
(80001, 'polygon', 'Mumbai Testnet'),
(421613, 'arbitrum', 'Arbitrum Goerli'),
(97, 'bsc', 'BSC Testnet'),
(43113, 'avalanche', 'Avalanche Fuji Testnet'),
(84531, 'base', 'Base Goerli')
) AS v (chain_id, blockchain, network_name)
),
eth_to_ronin_native as (
select
'ethereum'::VARCHAR as blockchain
, 'axie infinity: ronin bridge v2'::VARCHAR as platfrom
, 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
Last run: 9 days ago
1
51B
91s