flipside

    BOB vs. Other Chains (Summary Table)
    mamad-5XN3k3BOB vs. Other Chains (Summary Table)
    Updated 2025-04-03
    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: 22 days ago
    CHAIN
    CURRENT_TVL
    AVG_TPS
    AVG_TXS
    AVG_USERS
    AVG_FEE
    AVG_SUCCESS_RATE
    1
    		CORE 684,839,678 5 2,402,579 969,993 3,058 97.51
    2
    		Base 3,608,597,638 83 44,940,221 4,641,758 904,763 93.75
    3
    		BOB 278,291,555 1 444,917 25,200 741 99.76
    4
    		Arbitrum 2,771,287,862 27 14,554,131 1,398,686 188,979 86.54
    4
    508B
    87s