cnallenzhaoparticular-teal copy
Updated 2025-02-08
999
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
›
⌄
-- forked from particular-teal @ https://flipsidecrypto.xyz/studio/queries/9b2e4e95-5b5b-4ed6-9dad-2f12b58088cd
WITH NON_UNI_LP_ADDRESS AS (
SELECT
DISTINCT(NF_POSITION_MANAGER_ADDRESS) as lps
FROM
ethereum.uniswapv3.ez_lp_actions
WHERE
pool_address IN (
'0x11b815efb8f581194ae79006d24e0d814b7697f6',
'0x4e68ccd3e89f51c3074ca5072bbac773960dfa36',
'0x69d91b94f0aaf8e8a2586909fa77a5c2c89818d5',
'0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640',
'0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8',
'0x99ac8ca7087fa4a2a1fb6357269965a2014abc35',
'0xc2e9f25be6257c210d7adf0d4cd6e3e881ba25f8'
)
AND NF_POSITION_MANAGER_ADDRESS IN (
'0x33544f36e5424edff6769445a9ce3890f6b7457c',
'0x4ef5947b7c8904c5a4094361c00b7f9421602e7b',
'0x7caec5e4a3906d0919895d113f7ed9b3a0cbf826',
'0x026ebe349f96077660138f0e7d7d448a3320c866',
'0x0ed85894924bf06d72d77e306dc62bf1a5fcd0a9',
'0x3365bf42bbd2e1be52ae8d2c2c71416a0ea30675',
'0x471d932a8593754c8f0f6d86e537b0ed59385d9a',
'0x4f65c0f7285d647e3b156c73cc5ebdc393d5aad6',
'0x614775d11b6209fcc12147e111a308eab684e438',
'0x91c7d7b70e1361cbfc0d3d1d3375582f5f91354c',
'0xb2041768490cb1e189a484cbaa7d252e57b69104',
'0xb6f1a307a0c9a03c67f8d646809e472014a3ee65',
'0xc972c18acd67ac760b82e05de6d21730321f9619',
'0xcfcb0f7d3ec17157b1e8b3b70c09dba4207d5054',
'0xd47a40c7fea4e5aa160e4729baa7f5896c1144ee',
'0xe24b8954ea4dc117193da404ac81b2c14ac7ff3a',
'0xe6b0bf4c33da96cda9a9b973ee5277fffc38aa60',
'0xf056374dd1201fdddc00a54ad92f68e48580c83c',
'0xf05a2cb0ed7656d6d1a0cd84d8f2468e89ed7fe5',
QueryRunArchived: QueryRun has been archived