jackguyQualified Pools
Updated 2022-07-06Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
›
⌄
with pools as (
SELECT
pool_name,
platform,
pool_address
FROM ethereum.core.dim_dex_liquidity_pools
), tab1 as (
SELECT
pool_name,
platform,
symbol,
avg(amount_usd) as val
FROM flipside_prod_db.ethereum.erc20_balances
LEFT outer JOIN pools ON user_address = pool_address
WHERE user_address in (SELECT pool_address from pools)
AND balance_date > CURRENT_DATE - 5
and not amount_usd is NULL
group BY 1,2,3
)
SELECT
pool_name,
platform,
sum(val) as bal_usd
from tab1
GROUP BY 1,2
HAVING bal_usd BETWEEN 100000 AND 1000000000
Run a query to Download Data