SocioAnalyticaEVM > SEI start
    Updated 2025-02-02
    WITH chains AS (
    SELECT
    *
    FROM
    (
    VALUES
    ('Ethereum', '1'),
    ('OP', '10'),
    ('Cronos', '25'),
    ('Rootstock', '30'),
    ('BSC', '56'),
    ('Gnosis', '100'),
    ('Polygon', '137'),
    ('Fantom', '250'),
    ('Boba', '288'),
    ('zkSync', '324'),
    ('METIS', '1088'),
    ('Polygon zkEVM', '1101'),
    ('Lisk', '1135'),
    ('Gravity Alpha', '1625'),
    ('Mantle', '5000'),
    ('BASE', '8453'),
    ('Mode', '34443'),
    ('Arbitrum', '42161'),
    ('Avalanche', '43114'),
    ('Linea', '59144'),
    ('Blast', '81457'),
    ('Taiko', '167000'),
    ('Scroll', '534352'),
    ('Aurora', '1313161554'),
    ('Solana', '1151111081099710')
    ) AS a (chain, dest_chain_id)
    ),
    all_bridge_txns as (
    SELECT *, 'Arbitrum' as src_chain FROM arbitrum.core.ez_decoded_event_logs
    WHERE block_timestamp >= '2024-09-09'
    Last run: 11 days ago
    DATE
    BRIDGE
    INTEGRATOR
    SRC_CHAIN
    TX_COUNT
    CUM_N_TRANSFERS
    USER_COUNT
    VOLUME_USD
    CUM_VOLUME
    1
    2025-02-02 00:00:00.000stargateV2Busjumper.exchangeAvalanche186173.428288112383.973875638
    2
    2025-02-02 00:00:00.000relayjumper.exchangeOP3372202.35168861083.807625176
    3
    2025-02-02 00:00:00.000relayjumper.exchangeBASE159120186484.270437321
    4
    2025-02-02 00:00:00.000stargateV2Busjumper.exchangeArbitrum14097198.4012874558861.37454749
    5
    2025-02-02 00:00:00.000relayjumper.exchangeArbitrum1671086208.825483895
    6
    2025-02-02 00:00:00.000stargateV2BusReservoirEthereum13217391.437738749208143.450842637
    7
    2025-02-02 00:00:00.000symbiosisjumper.exchangeOP18912.8336559087.713881349
    8
    2025-02-01 00:00:00.000stargateV2jumper.exchangeBASE316983772.59340411755523.10545779
    9
    2025-02-01 00:00:00.000relayjumper.exchangeOP134199.98813117360881.455937176
    10
    2025-02-01 00:00:00.000stargateV2Busjumper.exchangeOP21296215547.0398838911475747.10942436
    11
    2025-02-01 00:00:00.000stargateV2jumper.exchangeEthereum14311655.615799099.272376328
    12
    2025-02-01 00:00:00.000relayjumper.exchangeArbitrum66657302.8744679586208.825483895
    13
    2025-02-01 00:00:00.000relayjumper.exchangeBASE45847107.671983386283.270437321
    14
    2025-02-01 00:00:00.000relayjumper.exchangeBSC1116.9966590586.996659058
    15
    2025-02-01 00:00:00.000stargateV2BusReservoirEthereum231113141.470669200752.013103888
    16
    2025-02-01 00:00:00.000stargateV2jumper.exchangeOP18051112.410862135633.87560317
    17
    2025-02-01 00:00:00.000stargateV2Busjumper.exchangeEthereum2273226668.7412314599.99590424
    18
    2025-02-01 00:00:00.000stargateV2Busjumper.exchangePolygon79044412.855686724122987.977882486
    19
    2025-02-01 00:00:00.000stargateV2jumper.exchangeArbitrum117631562.548964150815.41214976
    20
    2025-02-01 00:00:00.000stargateV2BusExtraFinanceBASE17151998.50944216484.884496829
    ...
    2220
    227KB
    199s