SELECT date_trunc('day', block_timestamp) as date, tx_id, swapper, SWAP_FROM_AMOUNT, SWAP_TO_AMOUNT, SWAP_TO_MINT

-- SELECT *

FROM solana.swaps

WHERE SWAP_PROGRAM = 'jupiter aggregator v2' and SUCCEEDED = 'TRUE' and date >= '2022-01-01' and SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112'

SELECT date, COUNT(DISTINCT tx_id) as num_swaps, SUM(SWAP_FROM_AMOUNT) as SOL_swapped, COUNT(DISTINCT swapper) as num_swapper,

num_swaps / num_swapper as num_swaps_per_swapper,

SOL_swapped / num_swaps as SOL_swapped_per_swap,

SUM(SOL_swapped) OVER (ORDER BY date ASC) as total_swapped_from

FROM tx

GROUP BY 1