skeogriffVUNCE INFLOWS
Updated 2024-07-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- forked from HEHE INFLOWS @ https://flipsidecrypto.xyz/edit/queries/97d889ba-54d2-4ce8-b0e0-39fb308b9f38
-- Use a CTE to get swaps from the last 24 hours from a specific mint, then sum the USD amounts and include the symbol, ranked by amount
WITH RecentSwaps AS (
SELECT *
FROM solana.defi.ez_dex_swaps
WHERE SWAP_TO_MINT = '5wVtmYfYeMu3KY3WfwdV7vQhE9ikUM8nyhbLqHH2pump'
AND BLOCK_TIMESTAMP >= DATEADD('hour', -24, CURRENT_TIMESTAMP())
)
SELECT
SWAP_FROM_MINT,
SWAP_FROM_SYMBOL,
SUM(SWAP_TO_AMOUNT_USD) AS TOTAL_SWAP_TO_AMOUNT_USD,
SUM(SWAP_TO_AMOUNT) AS TOTAL_SWAP_TO_AMOUNT
FROM
RecentSwaps
GROUP BY
SWAP_FROM_MINT, SWAP_FROM_SYMBOL
ORDER BY
TOTAL_SWAP_TO_AMOUNT DESC;
QueryRunArchived: QueryRun has been archived