COUNT(*) | FROM_ADDRESS | TO_ADDRESS | |
|---|---|---|---|
1 | 143 | 0xed39ac51cb58769dbd95fa10ee28cec3f005b284 | 0xcd9e13b2f3bfc26cd99989fb849a2751932595c4 |
2 | 5326 | 0xb37eff819cd627055f00fa3dbcace046d4a7876f | 0x8aff5ca996f77487a4f04f1ce905bf3d27455580 |
3 | 5089 | 0xe3f90e9fd46ea7ef19b399eee1ab27b557cc0d69 | 0x8aff5ca996f77487a4f04f1ce905bf3d27455580 |
4 | 4 | 0x0ca0f3930f23b47ac525ac3590f57b024cc416f4 | 0x7caec5e4a3906d0919895d113f7ed9b3a0cbf826 |
5 | 1 | 0xb7863dda153de48e56a50e4f864cb4f9b72f1004 | 0x33cb657e7fd57f1f2d5f392fb78d5fa80806d1b4 |
6 | 5326 | 0xd5f8599710a3d1403587931b7770e6677b4e9821 | 0x8aff5ca996f77487a4f04f1ce905bf3d27455580 |
7 | 3 | 0xfdfe4cee47d2e91694d2c346f2966e39d691bb4b | 0x7caec5e4a3906d0919895d113f7ed9b3a0cbf826 |
8 | 2 | 0xa88f6372d3871f9eccd999e270a88337ae6a5b6d | 0x7caec5e4a3906d0919895d113f7ed9b3a0cbf826 |
9 | 9 | 0x04b9c88465f89f6097ee5e49968112ea3092a086 | 0xe6b0bf4c33da96cda9a9b973ee5277fffc38aa60 |
10 | 1 | 0xd0388e34a0589e8109a13064aa3c4a1fa646f9c4 | 0xcf746ffdbd4886d48942e460a5013fa6cc799434 |
11 | 1 | 0x0cd207d2d9780c365ac8b5fe9f18387441584233 | 0xae5bf69e3bb01374a8d9b794d81146a228565996 |
12 | 3 | 0x4035918d8e0231d6bf5ffb72add9edc917dcfcfa | 0x7caec5e4a3906d0919895d113f7ed9b3a0cbf826 |
13 | 1 | 0xa8c5d6384425694bc8210410921785ec89feec04 | 0xa7979d0592ecfc59b082552828ff36209ec94b11 |
14 | 2 | 0x6eab4fe4bd7fb26ee33e4cf6f30e27c5f2f29002 | 0xb5087f95643a9a4069471a28d32c569d9bd57fe4 |
15 | 2 | 0xb9db5a37663d2004ea251281753aae75b30431d7 | 0xc91b65fd40820f33b71c56bc00f80e1ac49ea98e |
16 | 1 | 0x4ac5d281e580da02688359f498da98652a5f6bb0 | 0x24416cba1772c283de3b41eb99e850e8321322bc |
17 | 1 | 0xa860d41d99cb9a71da517c3e777cff3ebd352768 | 0xb6f5f9381fda35f94035c6df8f42d5dda3ee3fc1 |
18 | 3659 | 0x562e6802e5a7ac16c5cfa7debc9022b3b125aea9 | 0xcd9e13b2f3bfc26cd99989fb849a2751932595c4 |
19 | 5404 | 0x83c553bc43f4062c1516d1b65de10f5e8d225d70 | 0x8aff5ca996f77487a4f04f1ce905bf3d27455580 |
20 | 125 | 0xaed25625f93a6494c25575e75df9634d0aa8f306 | 0x0f7b93c7b855e667fe4ae29f45d473803727ea98 |
cnallenzhaounderlying-tomato
Updated 2025-03-05
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 NF_POSITION_MANAGERS AS (
SELECT
DISTINCT(NF_POSITION_MANAGER_ADDRESS)
FROM
ethereum.uniswapv3.ez_lp_actions
WHERE
POOL_ADDRESS IN (
'0x11b815efb8f581194ae79006d24e0d814b7697f6',
'0x4e68ccd3e89f51c3074ca5072bbac773960dfa36',
'0x69d91b94f0aaf8e8a2586909fa77a5c2c89818d5',
'0x84383fb05f610222430f69727aa638f8fdbf5cc1',
'0x99ac8ca7087fa4a2a1fb6357269965a2014abc35',
'0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640',
'0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8',
'0xc2e9f25be6257c210d7adf0d4cd6e3e881ba25f8'
)
AND BLOCK_NUMBER >= 12369854
AND BLOCK_NUMBER <= 16308240
AND NF_POSITION_MANAGER_ADDRESS != '0xc36442b4a4522e871399cd717abdd847ab11fe88'
),
contract_creation AS (
SELECT
*
FROM
ethereum.core.dim_contracts
WHERE
1 = 1
AND ADDRESS IN (
SELECT
*
FROM
NF_POSITION_MANAGERS
)
),
creator_ens AS (
SELECT
Last run: 11 days ago
...
1150
106KB
18s