Afonso_Diaz2023-10-18 06:18 PM
Updated 2023-10-18
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 LP_Activity AS (
SELECT
LIQUIDITY_PROVIDER,
COUNT(*) AS TotalActions,
SUM(AMOUNT0_USD + AMOUNT1_USD) AS TotalLiquidityUSD
FROM
ethereum.uniswapv3.ez_lp_actions
WHERE
action = 'INCREASE_LIQUIDITY'
GROUP BY
LIQUIDITY_PROVIDER
HAVING
TotalLiquidityUSD BETWEEN 0.1 AND 1e9
),
t AS (
SELECT
LP_Activity.LIQUIDITY_PROVIDER,
LP_Activity.TotalActions,
LP_Activity.TotalLiquidityUSD,
LP_Activity.TotalActions / LP_Activity.TotalLiquidityUSD AS ActionPerSize
FROM
LP_Activity
)
SELECT
sum(TotalActions) as total_actions,
AVG(TotalActions) AS average_actions,
MEDIAN(TotalActions) AS median_actions,
STDDEV_POP(TotalActions) AS std_dev_actions_pop,
STDDEV_SAMP(TotalActions) AS std_dev_actions_samp,
AVG(ActionPerSize) AS average_action_per_size,
MEDIAN(ActionPerSize) AS median_action_per_size,
STDDEV_POP(ActionPerSize) AS std_dev_action_per_size_pop,
STDDEV_SAMP(ActionPerSize) AS std_dev_action_per_size_samp,
STDDEV_POP(TotalActions) AS std_dev_total_actions__pop,
STDDEV_SAMP(TotalActions) AS std_dev_total_actions_samp
FROM
Run a query to Download Data