flipside

    ArOp_TVL copy
    vendettaArOp_TVL copy
    Updated 2023-03-09
    -- forked from 7d4bc807-4f29-4736-b259-afd3dc5bc431

    WITH
    arbitrum as (
    SELECT
    date as _date,
    sum(tvl_usd) / 1e9 as "Arbitrum TVL" -- Value is in bn dollars
    FROM
    external.defillama.fact_chain_tvl
    WHERE
    date >= current_date() - 365
    AND chain = 'Arbitrum'
    GROUP BY
    1
    ),
    optimism as (
    SELECT
    date as _date,
    sum(tvl_usd) / 1e9 as "Optimism TVL" -- Value is in bn dollars
    FROM
    external.defillama.fact_chain_tvl
    WHERE
    date >= current_date() - 365
    AND chain = 'Optimism'
    GROUP BY
    1
    )
    SELECT
    *
    FROM
    arbitrum a
    JOIN optimism p ON a._date = p._date
    ORDER BY
    a._date DESC


    Run a query to Download Data