LTirrellhoneypot user mint_type_full
    Updated 2023-07-01
    -- 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
    )
    SELECT
    tx_from,
    mint_type,
    count(distinct tx_id) as tx_count
    from
    base
    group by
    tx_from,
    Run a query to Download Data