Discover

Get unique count of all token_mint_address with outer_executing_account

tokens_solana.transfers distinct action

Map revenues from method ID

Select distinct methods called by Pump.fun program

tokens_solana.transfers transfers for Sell

tokens_solana.transfers transfers for Buy

tokens_solana.transfers transfers for create

Select distinct methods called by Pump.fun program with example tx

analysis: dex.trades for block

analysis: tsx for block

most profitable blocks

most profitable blocks

most profitable block and their breakdown

compute revenue with dex.trades only with gas costs GROUP OVER BLOCKS

block profits

sum gas costs

gas costs block by block

analysis: dex.trades for block raw

compute revenue with dex.trades only with gas costs GROUP OVER BLOCKS #2

compute revenue with dex.trades only with gas costs ETHEREUM group over tx