LTirrellhoneypot user mint_type_limit_all mad list mint
    Updated 2023-04-22
    -- forked from honeypot user mint_type_limit_all copy @ https://flipsidecrypto.xyz/edit/queries/208e635c-66cb-4880-9a27-a9a3e76a90cf

    -- forked from honeypot user mint_type_limit_all @ https://flipsidecrypto.xyz/edit/queries/de163cc0-c8c4-48d9-9a1b-f9a0942bad51

    -- forked from honeypot user mint_type_full @ https://flipsidecrypto.xyz/edit/queries/3e92bb36-9f71-4796-bbf4-409c357791cc
    -- forked from honeypot @ https://flipsidecrypto.xyz/edit/queries/e7c743f7-1e80-48bd-b8f3-0a00ae481d2c
    with
    base as (
    select
    block_timestamp,
    case
    when tx_to = '6Sj47sKP8wpCJ5XfBzFmzKvDk7VdvaXoLDa1KthxD57X' then 'honeypot'
    when (
    tx_to = '2RtGg6fsFiiF1EQzHqbd66AhW7R5bWeQGpTbv2UMkCdW'
    and block_timestamp::date < '2023-04-21'
    ) then 'mad list mint'
    when (
    tx_to = '2RtGg6fsFiiF1EQzHqbd66AhW7R5bWeQGpTbv2UMkCdW'
    and block_timestamp::date >= '2023-04-21'
    ) then 'public mint'
    end as mint_type,
    tx_from,
    tx_id
    from
    solana.core.fact_transfers
    WHERE
    (
    tx_to = '6Sj47sKP8wpCJ5XfBzFmzKvDk7VdvaXoLDa1KthxD57X'
    or tx_to = '2RtGg6fsFiiF1EQzHqbd66AhW7R5bWeQGpTbv2UMkCdW'
    )
    and mint = 'So11111111111111111111111111111111111111112'
    and amount = 6.9
    ),
    top_addresses as (
    select
    tx_from,
    Run a query to Download Data