jackiehighnoonsingle wallet coin buys
Updated 2024-04-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
SUM(SWAP_FROM_AMOUNT) as SOL_SPENT,
SWAP_TO_MINT as TOKEN,
DATE_TRUNC('day', BLOCK_TIMESTAMP) as Date,
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 - 7
GROUP BY swap_to_mint, Date, swapper
ORDER BY Date
QueryRunArchived: QueryRun has been archived