flipside

    BOB vs. Other Chains (Summary Table)
    mamad-5XN3k3BOB vs. Other Chains (Summary Table)
    Updated 1 day ago
    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: 1 day agoAuto-refreshes every 24 hours
    CHAIN
    CURRENT_TVL
    AVG_TPS
    AVG_TXS
    AVG_USERS
    AVG_FEE
    AVG_SUCCESS_RATE
    1
    		CORE 602,640,442 5 2,916,968 1,356,177 3,973 98.53
    2
    		BOB 229,575,849 1 366,410 25,058 15,340 99.69
    3
    		Arbitrum 2,848,259,394 28 15,031,257 1,074,990 179,023 83.84
    4
    		Base 5,106,417,642 115 62,341,874 8,651,510 1,151,229 91.39
    4
    508B
    126s