flipside

    40.Statics value for custom bridges
    Azin40.Statics value for custom bridges
    Updated 2022-11-12
    with t1 as (select ADDRESS from optimism.core.dim_labels where LABEL_SUBTYPE='bridge'
    and ADDRESS not in (lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1'),lower('0x52ec2F3d7C5977A8E558C8D9C6000B615098E8fC')))

    select sum(AMOUNT) as "Volume ETH came from Origin addresses to custom bridge",count(distinct ETH_FROM_ADDRESS) as "number of Origin addresses that ETH comes from custom bridge" ,
    sum(AMOUNT)/"number of Origin addresses that ETH comes from custom bridge" as "ETH bridged to custom bridges per origin address"
    from optimism.core.ez_eth_transfers
    where
    ETH_TO_ADDRESS in (select address from t1)

    Run a query to Download Data