SandeshRonin bridge stats
    Updated 2025-03-10
    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: 10 days ago
    NUMBER_OF_BRIDGE_TRANSACTIONS
    NUMBER_OF_BRIDGERS
    NUMBER_OF_TOKENS
    TOTAL_VOLUME
    NET_VOLUME
    1
    564931781942982458.6522096-9244915.91594722
    1
    51B
    91s