Find pump.fun rug pull transactions that are defined by these criteria:

  1. Transactions with initial pool liquidity of at least 1 SOL
  2. SOL liquidity in this transaction should drop by a factor of at least 10 (for example 10 SOL -> 0.5 SOL is 20x, is more than 10x drop)
  3. Only Pump.Fun swaps (not including mints graduated to Raydium and PumpSwap)

Select only transactions in this time window:

block_time >= CAST('2025-03-01 00:00:00' AS TIMESTAMP)
AND block_time < CAST('2025-03-02 00:00:00' AS TIMESTAMP)

The result should look as follows (it is a CSV file with one column):

First line is signature

The rest is a list of signatures for each transaction.

signature
4sNnHYdnu4vHyzkJXvxDe4Li75ZkTH5SMdpaGXTQdAQxXkzhpfYooWWeMxEPbYhQ4oGqzttT7m1MAULXXMApD4Pp
5yihETrPgmnBBzMmPCfrHxivgAv9g1gqSUW7PzEbzMPZifqkPCk8QiDoiS4JUvMxtuKFeYWkAgVG697f9PfQ56TT
228x8DVgD5uV4iVcV3388T1ppjCTQwm6AYdScufb7yGoCkMVZ8bmmMKaNK4FFSxw7DYW5NHjBf9VktDrHMf2zLab
...
3qRwGdYjYKAYa6zUcG8w8zvwJyNSnXB2CRRDFuXpoUDpG2ckH76SAHaF7o5Wa2bG33YM4q4ix2vTvctfwuEEj9sG

Solana data:

Relevant data is in solana.transactions and dex_solana.trades ****tables for Dune, but these tables aren’t ideal. You can benefit of looking for more convenient data representation in other sources.

Correctness criteria:

The score would depend on how many transactions you detected correctly.

image.png