flipside

    test - tvl for terraswap
    messaritest - tvl for terraswap
    Updated 2022-05-06
    WITH pools AS (
    SELECT DISTINCT
    CONTRACT_ADDRESS
    FROM terraswap.pool_reserves
    )
    SELECT * FROM terra.daily_balances
    WHERE ADDRESS IN (SELECT * FROM pools)
    -- and BALANCE_USD > 0
    -- Order by DATE desc
    LIMIT 5
    Run a query to Download Data