SocioAnalyticaSEI > EVM histograms by chain
    Updated 4 days ago
    WITH chains AS (
    SELECT
    *
    FROM
    (
    VALUES
    ('Ethereum', '1'),
    ('OP', '10'),
    ('BSC', '56'),
    ('Gnosis', '100'),
    ('Polygon', '137'),
    ('BASE', '8453'),
    ('Arbitrum', '42161'),
    ('Avalanche', '43114'),
    ('Blast', '81457')
    ) AS a (chain, dest_chain_id)
    ),
    all_bridge_txns as (
    SELECT
    *,
    'Sei' as src_chain
    FROM
    sei.core_evm.ez_decoded_event_logs
    WHERE
    block_timestamp >= '2024-09-01'
    ),
    prices as (
    SELECT
    hour,
    price,
    case
    when token_Address in (
    '0xb75d0b03c06a926e488e2659df1a861f860bd3d1',
    '0x3894085ef7ff0f0aedf52e2a2704928d1ec074f1'
    ) then '6'
    when token_Address in (
    Last run: 4 days agoAuto-refreshes every 24 hours
    DESTINATION_CHAIN
    SIZE_BUCKET
    TX_COUNT
    TOTAL_VOLUME
    AVG_TX_SIZE
    PCT_OF_CHAIN_TXS
    PCT_OF_CHAIN_VOLUME
    1
    Arbitrum0-1003370132004.8572854639.17058079760.811.33
    2
    Arbitrum100-5001150240961.636618513209.53185792920.752.42
    3
    Arbitrum500-1K308215781.087642573700.5879468915.562.17
    4
    Arbitrum1K-5K4691016122.533066882166.5725651758.4610.21
    5
    Arbitrum5K-10K95662123.9178438126969.7254509871.716.65
    6
    Arbitrum10K+1507687505.914012251250.0394267482.7177.23
    7
    Avalanche0-1001252855.67686102622.84541488856.560.41
    8
    Avalanche100-500429385.315305552223.459888227191.36
    9
    Avalanche500-1K1410772.120794607769.4371996156.331.56
    10
    Avalanche1K-5K2150172.8424375462389.1829732169.57.26
    11
    Avalanche5K-10K431597.885633177899.4714082921.814.57
    12
    Avalanche10K+15586650.42006206139110.0280041376.7984.85
    13
    BASE0-1003243109095.08067271833.64017288763.142.01
    14
    BASE100-5001073240296.491950398223.9482683620.894.43
    15
    BASE500-1K295203210.00924836688.8474889775.743.75
    16
    BASE1K-5K335678870.2119015722026.4782444826.5212.52
    17
    BASE5K-10K80587934.8554291527349.1856928641.5610.84
    18
    BASE10K+1103604892.5140825932771.7501280242.1466.46
    19
    BSC0-10057517439.28124158130.32918476862.032.01
    20
    BSC100-50018445470.730047479247.12353286719.855.23
    47
    3KB
    7s