binhachonCh-ch-ch-ch-changes - MIM in liquidity pools
Updated 2022-02-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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