binhachonCh-ch-ch-ch-changes - MIM in liquidity pools
    Updated 2022-02-10
    with liquidity_pools as (
    select
    pool_address
    from ethereum.dex_liquidity_pools
    where (token0 = '0x99d8a9c45b2eca8864373a26d1459e3dff1e17f3' or token1 = '0x99d8a9c45b2eca8864373a26d1459e3dff1e17f3')
    union
    select '0x5a6a4d54456819380173272a5e8e9b9904bdf41b' as pool_address --MIM - 3CRV
    union
    select '0x55a8a39bc9694714e2874c1ce77aa1e599461e18' as pool_address -- MIM - UST
    )
    select
    balance_date,
    sum(balance) as supply_in_liquidity_pools
    from ethereum.erc20_balances
    where balance_date > '2022-01-21'
    and contract_address = '0x99d8a9c45b2eca8864373a26d1459e3dff1e17f3'
    and user_address in (select pool_address from liquidity_pools)
    group by balance_date
    Run a query to Download Data