Query editor
WITH excluded_transactions AS (SELECT DISTINCT tx_idFROM solana.account_activityWHERE tx_success = TRUEAND block_date <= DATE '2024-04-27'AND address IN ('49AdQfhKyVgWKb1HPi6maQxm5tqJasePR9K6Mn67hEYA','EkuimaBYybHvviYjtMXcnC7eg6WQmzLriDPtvh98fjRg','CL9jPThhYnxvPSWNLhR4J7in13WvtMXXBGCe8LEhipmj','94qWNrtmfn42h3ZjUZwWvK1MEo9uVmmrBPd2hpNjYDjb','7xQYoUjUJF1Kg6WVczoTAkaNhn5syQYcbvjmFrhjWpx','BWXT6RUhit9FfJQM3pBmqeFLPYmuxgmyhMGC5sGr8RbA','Bvtgim23rfocUzxVX9j9QFxTbBnH8JZxnaGLCEkXvjKS','FGptqdxjahafaCzpZ1T6EDtCzYMv7Dyn5MgBLyB3VUFW','X5QPJcpph4mBAJDzc4hRziFftSbcygV59kRb2Fu6Je1','7GFUN3bWzJMKMRZ34JLsvcqdssDbXnp589SiE33KVwcC')AND balance_change < 0),early_revenue AS (SELECTsa.block_date AS dt,SUM(sa.balance_change) / 1e9 AS rev_solFROM solana.account_activity saLEFT JOIN excluded_transactions et ON sa.tx_id = et.tx_idWHERE sa.tx_success = TRUEAND sa.block_date <= DATE '2024-04-27'AND sa.address IN ('CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM','62qc2CNXwrYqQScmEdiZFFAnJR262PxWEuNQtxfafNgV','FWsW1xNtWscwNmKv6wVsU1iTzRN6wmmk3MjxRP5tT7hz','7hTckgnGnLQR6sdH7YkqFTAA7VwTfYFaZ6EhEsU3saCX','AVmoTthdrX6tKt4nDjco2D775W2YK3sDhxPcMmzUAmTY','9rPYyANsfQZw3DnDmKE3YCQF5E8oD89UXoHn9JFEhJUz','G5UZAVbAf46s7cKWoyKu8kYTip9DGTpbLZ2qa9Aq69dP','7VtfL8fvgNfhz17qKRMjzQEXgbdpnHHHQRh54R9jP2RJ')AND sa.balance_change > 0AND et.tx_id IS NULLGROUP BY sa.block_date),early_usd AS (SELECTer.dt,'pumpdotfun' AS project,'wallet_inflow' AS source,er.rev_sol * e.price AS fee_usd,CAST(NULL AS BIGINT) AS tradesFROM early_revenue erJOIN prices.usd_daily eON e.day = er.dtAND e.symbol = 'SOL'AND e.blockchain = 'solana'),late_usd AS (SELECTblock_date AS dt,project,'dex_trades' AS source,SUM(fee_usd) AS fee_usd,