flipside

    Metaplex Bot Taxes
    MilesFinchMetaplex Bot Taxes
    Updated 2022-05-03
    SELECT count(*) * 0.01 AS BOT_TAX_PAST_3_DAYS
    FROM solana.fact_transactions
    WHERE block_timestamp >= '2022-04-30'
    AND CAST(log_messages as string) ILIKE '%Candy Machine Botting is taxed at%'

    select signers, count(*)
    from solana.fact_transactions
    WHERE block_timestamp >= '2022-04-30'
    AND CAST(log_messages as string) ILIKE '%Candy Machine Botting is taxed at%'
    group by signers
    order by signers desc


    Run a query to Download Data