cnallenzhaounderlying-tomato
    Updated 2025-03-05
    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
    COUNT(*)
    FROM_ADDRESS
    TO_ADDRESS
    1
    1430xed39ac51cb58769dbd95fa10ee28cec3f005b2840xcd9e13b2f3bfc26cd99989fb849a2751932595c4
    2
    53260xb37eff819cd627055f00fa3dbcace046d4a7876f0x8aff5ca996f77487a4f04f1ce905bf3d27455580
    3
    50890xe3f90e9fd46ea7ef19b399eee1ab27b557cc0d690x8aff5ca996f77487a4f04f1ce905bf3d27455580
    4
    40x0ca0f3930f23b47ac525ac3590f57b024cc416f40x7caec5e4a3906d0919895d113f7ed9b3a0cbf826
    5
    10xb7863dda153de48e56a50e4f864cb4f9b72f10040x33cb657e7fd57f1f2d5f392fb78d5fa80806d1b4
    6
    53260xd5f8599710a3d1403587931b7770e6677b4e98210x8aff5ca996f77487a4f04f1ce905bf3d27455580
    7
    30xfdfe4cee47d2e91694d2c346f2966e39d691bb4b0x7caec5e4a3906d0919895d113f7ed9b3a0cbf826
    8
    20xa88f6372d3871f9eccd999e270a88337ae6a5b6d0x7caec5e4a3906d0919895d113f7ed9b3a0cbf826
    9
    90x04b9c88465f89f6097ee5e49968112ea3092a0860xe6b0bf4c33da96cda9a9b973ee5277fffc38aa60
    10
    10xd0388e34a0589e8109a13064aa3c4a1fa646f9c40xcf746ffdbd4886d48942e460a5013fa6cc799434
    11
    10x0cd207d2d9780c365ac8b5fe9f183874415842330xae5bf69e3bb01374a8d9b794d81146a228565996
    12
    30x4035918d8e0231d6bf5ffb72add9edc917dcfcfa0x7caec5e4a3906d0919895d113f7ed9b3a0cbf826
    13
    10xa8c5d6384425694bc8210410921785ec89feec040xa7979d0592ecfc59b082552828ff36209ec94b11
    14
    20x6eab4fe4bd7fb26ee33e4cf6f30e27c5f2f290020xb5087f95643a9a4069471a28d32c569d9bd57fe4
    15
    20xb9db5a37663d2004ea251281753aae75b30431d70xc91b65fd40820f33b71c56bc00f80e1ac49ea98e
    16
    10x4ac5d281e580da02688359f498da98652a5f6bb00x24416cba1772c283de3b41eb99e850e8321322bc
    17
    10xa860d41d99cb9a71da517c3e777cff3ebd3527680xb6f5f9381fda35f94035c6df8f42d5dda3ee3fc1
    18
    36590x562e6802e5a7ac16c5cfa7debc9022b3b125aea90xcd9e13b2f3bfc26cd99989fb849a2751932595c4
    19
    54040x83c553bc43f4062c1516d1b65de10f5e8d225d700x8aff5ca996f77487a4f04f1ce905bf3d27455580
    20
    1250xaed25625f93a6494c25575e75df9634d0aa8f3060x0f7b93c7b855e667fe4ae29f45d473803727ea98
    ...
    1150
    106KB
    18s