flipside

    Four main pools (ETH and BTC covered calls, yvUSDC-ETH, USDC-ETH puts) on Ribbon by the changes of total value locked (TVL) over time since the beginning of January
    CoinConverseFour main pools (ETH and BTC covered calls, yvUSDC-ETH, USDC-ETH puts) on Ribbon by the changes of total value locked (TVL) over time since the beginning of January
    Updated 2022-02-07
    select sum(non_adjusted_balance) as tvl, date_trunc('Day', balance_date) as dt, case
    when contract_address = lower('0x25751853Eab4D0eB3652B5eB6ecB102A2789644B') then 'ETH call'
    when contract_address = lower('0x65a833afDc250D9d38f8CD9bC2B1E3132dB13B2F') then 'WBTC call'
    when contract_address = lower('0x16772a7f4a3ca291C21B8AcE76F9332dDFfbb5Ef') then 'USDC-ETH puts'
    when contract_address = lower('0xCc323557c71C0D1D20a1861Dc69c06C5f3cC9624') then 'yvUSDC-ETH puts'
    end as pool_name
    from ethereum.erc20_balances
    where pool_name in ('ETH call', 'WBTC call', 'USDC-ETH puts', 'yvUSDC-ETH puts')
    and non_adjusted_balance is not null
    and balance_date :: date >= '2022-01-01'
    group by 2,3
    Run a query to Download Data