JUP pump be 4

Updated 2024-06-21

-- forked from JUP pump be 3 @ https://flipsidecrypto.xyz/edit/queries/9ad13e62-9a62-49e8-9897-cd6016f01b08

-- forked from JUP pump be 1 @ https://flipsidecrypto.xyz/edit/queries/5664f3e0-3545-45f7-91d1-096899914a68

with tab0 as (

SELECT

DISTINCT mint

FROM solana.core.fact_transfers

WHERE not mint LIKE 'So11111111111111111111111111111111111111112'

AND tx_to LIKE '5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1'

AND tx_from in ('39azUYFWPz3VHgKCf3VChUwbpURdCHRxjWVowf5jUJjg', '5PXxuZkvftsg5CAGjv5LL5tEtvBRskdx1AAjxw8hK2Qx')

AND block_timestamp > '2024-01-01'

)

SELECT

date(block_timestamp) as day,

'Pump.Fun Swap' as swap_type,

count(DISTINCT tx_id) as events,

count(DISTINCT swapper) as swappers,

sum(

CASE when SWAP_TO_MINT in (

'So11111111111111111111111111111111111111112',

'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN',

'85VBFQZC9TZkfaptBWjvUw7YbZjy52A6mjtPGjstQAmQ',

'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3',

'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',

'jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL',

'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB',

'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263',

'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm',

'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn',

'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So',

'hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux',

'DriFtupJYLTosbwoN8koMbEYSx54aFAVLddWsbksjwg7',

'27G8MtK7VtTcCHkpASjSDdkWWYfoqT6ggEuKidVJidD4',

QueryRunArchived: QueryRun has been archived