cnallenzhaoAll particiapted LPs copy
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
›
⌄
-- forked from All particiapted LPs @ https://flipsidecrypto.xyz/edit/queries/284ab1ba-c781-4326-8442-30db9bb98f3e
-- SELECT COUNT(DISTINCT(LIQUIDITY_PROVIDER)) FROM
-- ethereum.uniswapv3.ez_lp_actions
-- WHERE BLOCK_TIMESTAMP <= '2023-01-01'
WITH SAMPLE_DATA AS(
SELECT COUNT(DISTINCT(LIQUIDITY_PROVIDER)) As sample_lp_cnts FROM
ethereum.uniswapv3.ez_lp_actions
WHERE BLOCK_TIMESTAMP <= '2023-01-01' AND POOL_ADDRESS IN (
'0x11b815efb8f581194ae79006d24e0d814b7697f6',
'0x4e68ccd3e89f51c3074ca5072bbac773960dfa36',
'0x69d91b94f0aaf8e8a2586909fa77a5c2c89818d5',
'0x84383fb05f610222430f69727aa638f8fdbf5cc1',
'0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640',
'0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8',
'0x99ac8ca7087fa4a2a1fb6357269965a2014abc35',
'0xc2e9f25be6257c210d7adf0d4cd6e3e881ba25f8'
)
),
FULL_DATA AS(
SELECT COUNT(DISTINCT(LIQUIDITY_PROVIDER)) AS full_lp_cnts FROM
ethereum.uniswapv3.ez_lp_actions
WHERE BLOCK_TIMESTAMP <= '2023-01-01'
)
SELECT s.yr, s.month, s.sample_lp_cnts, f.full_lp_cnts FROM SAMPLE_DATA s
LEFT JOIN FULL_DATA f
ON s.yr = f.yr AND s.month=f.month
ORDER BY 1,2
Run a query to Download Data