Crazy_KidSwap Sizes of Top 10 Liquidity Pools 2
Updated 2022-02-09
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 one AS (SELECT DATE(block_timestamp) as date, avg(amount_usd) as ILV_WETH_SLP_avg_swap_amount
FROM ethereum.dex_swaps
WHERE pool_name ='ILV-WETH SLP' and date >= '2022-01-01'
GROUP BY date
ORDER BY date DESC),
two AS (SELECT DATE(block_timestamp) as date, avg(amount_usd) as USDC_WETH_SLP_avg_swap_amount
FROM ethereum.dex_swaps
WHERE pool_name ='USDC-WETH SLP' and date >= '2022-01-01'
GROUP BY date
ORDER BY date DESC),
three AS (SELECT DATE(block_timestamp) as date, avg(amount_usd) as BIT_WETH_SLP_avg_swap_amount
FROM ethereum.dex_swaps
WHERE pool_name ='BIT-WETH SLP' and date >= '2022-01-01'
GROUP BY date
ORDER BY date DESC),
four AS (SELECT DATE(block_timestamp) as date, avg(amount_usd) as TOKE_WETH_SLP_avg_swap_amount
FROM ethereum.dex_swaps
WHERE pool_name ='TOKE-WETH SLP' and date >= '2022-01-01'
GROUP BY date
ORDER BY date DESC),
five AS (SELECT DATE(block_timestamp) as date, avg(amount_usd) as WBTC_WETH_SLP_avg_swap_amount
FROM ethereum.dex_swaps
WHERE pool_name ='WBTC-WETH SLP' and date >= '2022-01-01'
GROUP BY date
ORDER BY date DESC),
six AS (SELECT DATE(block_timestamp) as date, avg(amount_usd) as OHM_DAI_LP_avg_swap_amount
FROM ethereum.dex_swaps
WHERE pool_name ='OHM-DAI LP' and date >= '2022-01-01'
GROUP BY date
ORDER BY date DESC),
Run a query to Download Data