token_constants AS (

SELECT

'7S2R1dU8w3JdU63Etq2h81yJhV89YF4r78QJdBtWpump' AS token_program,

'So11111111111111111111111111111111111111112' AS purchase_token

),

overall_first_block AS (

SELECT

MIN(block_id) AS first_listing_block

FROM

solana.defi.ez_dex_swaps

WHERE

swap_from_mint = (SELECT purchase_token FROM token_constants)

AND swap_to_mint = (SELECT token_program FROM token_constants)

),

investments AS (

SELECT

swapper,

MIN(block_timestamp) AS first_purchase_timestamp,

MIN(block_id) AS first_purchase_block,

SUM(swap_from_amount_usd) AS total_investment

FROM

solana.defi.ez_dex_swaps

WHERE

swap_from_mint = (SELECT purchase_token FROM token_constants)

AND swap_to_mint = (SELECT token_program FROM token_constants)

GROUP BY

swapper

),

sales AS (

SELECT

swapper,

MIN(block_timestamp) AS first_sale_timestamp,

MIN(block_id) AS first_sale_block,

SUM(swap_to_amount_usd) AS total_return

FROM