flipside

    polygon_spam_tokens_transfers_all
    oscarqpolygon_spam_tokens_transfers_all
    Updated 2024-10-22
    WITH table_1 AS (SELECT
    pc.address
    FROM
    polygon.core.dim_contracts pc
    LEFT JOIN polygon.defi.dim_dex_liquidity_pools lp ON pc.address = lp.pool_address
    LEFT JOIN polygon.core.ez_token_transfers tr ON pc.address = tr.contract_address
    WHERE
    len(pc.symbol) > 11
    AND lp.pool_address IS NULL
    AND pc.created_block_timestamp BETWEEN CAST('{{initial_date}}' AS timestamp) AND CAST('{{final_date}}' AS timestamp)
    AND tr.block_timestamp BETWEEN CAST('{{initial_date}}' AS timestamp) AND CAST('{{final_date}}' AS timestamp)
    AND from_address != '0x0000000000000000000000000000000000000000'
    GROUP BY
    1
    HAVING
    count(*) > 500
    AND count(distinct to_address) > 500
    )

    SELECT
    *
    FROM
    polygon.core.ez_token_transfers
    WHERE
    contract_address IN (select address FROM table_1)
    QueryRunArchived: QueryRun has been archived