datavortexDaily Liquidity Utilization Per Platform
Updated 2024-10-20
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 LiquidityUtilization AS (
SELECT
platform AS PlatformName,
DATE_TRUNC('day', block_timestamp) AS Day,
COALESCE((SUM(amount_in_usd) / COUNT(DISTINCT tx_hash)), 0) AS AvgLiquidityUtilization
FROM
polygon.defi.ez_dex_swaps
WHERE
platform IN (
'uniswap-v3',
'quickswap-v3',
'sushiswap',
'woofi',
'quickswap-v2',
'dodo-v2',
'curve',
'balancer',
'dodo-v1',
'uniswap-v2',
'hashflow-v3',
'kyberswap-v1',
'fraxswap',
'kyberswap-v2'
)
AND block_timestamp >= DATEADD(MONTH, -3, CURRENT_DATE)
GROUP BY
PlatformName,
Day
)
SELECT
Day AS Date,
PlatformName,
AvgLiquidityUtilization
FROM
LiquidityUtilization
ORDER BY
QueryRunArchived: QueryRun has been archived