PierandreaLiquidity Pools Active
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
36
›
⌄
WITH POOLS AS (
SELECT
LEFT(date_trunc('day', CREATION_TIME), 10) AS DATE_OF_CREATION,
POOL_NAME,
POOL_ADDRESS,
PLATFORM,
TOKEN0,
TOKEN1
FROM
ethereum.core.dim_dex_liquidity_pools
WHERE
TOKEN0_SYMBOL = {{TOKEN}}
OR TOKEN1_SYMBOL = {{TOKEN}}
),
LIQUIDITY0 AS (
SELECT
CURRENT_BAL AS TOKEN0_BAL,
USD_VALUE_NOW AS TOKEN0_USD,
USER_ADDRESS,
CONTRACT_ADDRESS
FROM
ethereum.core.ez_current_balances
),
LIQUIDITY1 AS (
SELECT
CURRENT_BAL AS TOKEN1_BAL,
USD_VALUE_NOW AS TOKEN1_USD,
USER_ADDRESS,
CONTRACT_ADDRESS
FROM
ethereum.core.ez_current_balances
),
TOT AS (
SELECT
POOL_NAME,
Run a query to Download Data