flipside

    BOB vs. Other Chains (Summary Table)
    mamad-5XN3k3BOB vs. Other Chains (Summary Table)
    Updated 2025-05-19
    with pricet as (
    select
    'Core' as sym,
    Hour::date as pdate,
    avg(price) as price
    from core.price.ez_prices_Hourly
    where symbol = 'CORE'
    group by 1,2

    union

    select
    'ETH' as sym,
    Hour::date as pdate,
    avg(price) as price
    from ethereum.price.ez_prices_Hourly
    where symbol = 'ETH'
    and token_address is null
    group by 1,2
    ),

    tvlt as (
    select
    chain as chaintvl,
    max_by(TVL_USD, date) as tvl
    from external.defillama.fact_chain_tvl
    where chain in ('BOB','CORE','Base','Arbitrum')
    and date_trunc('day', date) >= current_date - {{Past_Days}}
    group by 1
    order by 1 asc
    )

    select
    chain,
    to_varchar(round(tvl, 0), '999,999,999,999') as current_tvl,
    to_varchar(round(avg(avg_tps), 0), '999,999,999,999') as avg_tps,
    Last run: 12 days agoAuto-refreshes every 24 hours
    CHAIN
    CURRENT_TVL
    AVG_TPS
    AVG_TXS
    AVG_USERS
    AVG_FEE
    AVG_SUCCESS_RATE
    1
    		Arbitrum 2,868,908,978 23 11,627,527 788,129 129,905 82.36
    2
    		CORE 719,522,038 4 2,133,406 894,153 3,577 97.88
    3
    		Base 4,446,705,371 82 41,776,337 4,895,152 808,249 92.50
    4
    		BOB 235,095,079 1 317,350 18,523 8,721 99.83
    4
    508B
    91s