WITH buy as (

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) as Date,

SUM(SWAP_FROM_AMOUNT) as SOL_SPENT,

SWAP_TO_MINT as TOKEN,

SWAPPER

FROM

solana.defi.fact_swaps

WHERE

SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112' --ONLY SOL TO SPL

AND SWAPPER = '{{wallet}}' --WALLET DOING SWAPPING

--AND SWAP_TO_MINT = 'F7tFuW9GGkxNp8HeLgDYV5Z7EDkQUvhknhkN9TqCXaVx' --SPECIFIC COIN

AND DATE >= current_date - 30

GROUP BY

swap_to_mint,

Date,

SWAPPER

ORDER BY

Date

),

sell as (

SELECT

SUM(SWAP_TO_AMOUNT) as SOL_GAIN,

SWAP_FROM_MINT as TOKEN,

DATE_TRUNC('day', BLOCK_TIMESTAMP) as Date,

SWAPPER

FROM

solana.defi.fact_swaps

WHERE

SWAP_TO_MINT = 'So11111111111111111111111111111111111111112' --ONLY SOL TO SPL

AND SWAPPER = '{{wallet}}' --WALLET DOING SWAPPING

--AND SWAP_TO_MINT = 'F7tFuW9GGkxNp8HeLgDYV5Z7EDkQUvhknhkN9TqCXaVx' --SPECIFIC COIN

AND DATE >= current_date - 30

GROUP BY

swap_from_mint,