Soheil_MKopyn test
Updated 2022-06-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with pools as (
select
lower(POOL_ADDRESS) as pool
from ethereum.core.dim_dex_liquidity_pools
where TOKEN0 ='0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b'
or TOKEN1='0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b'
)
select
USER_ADDRESS,
AMOUNT_USD
from flipside_prod_db.ethereum.erc20_balances
where USER_ADDRESS in (select pool from pools)
and BALANCE_DATE ='2022-06-29'
--group by 1
Run a query to Download Data