freemartianTotal JUP Swapped
Updated 2024-02-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with txs AS (
SELECT
*
FROM solana.core.fact_events
WHERE block_timestamp::date >= '2024-01-31'
-- AND tx_id = '3wWcrgvBLsuZBwVCeM2m78EJM7tv1VvsbqeHJmo52sPvKdLEKe4VNr75TAcbSSABzqTRTFaRs7vdEoXagYAJA1ta'
-- AND mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
AND program_id = 'meRjbQXFNf5En86FXT2YPz1dQzLj4Yb3xK8u1MVgqpb'
),
claim AS(
SELECT
block_timestamp,
tx_id,
tx_to,
amount
FROM solana.core.fact_transfers
WHERE tx_id IN (SELECT tx_id FROM txs)
AND block_timestamp::date >= '2024-01-31'
-- AND tx_id = '3wWcrgvBLsuZBwVCeM2m78EJM7tv1VvsbqeHJmo52sPvKdLEKe4VNr75TAcbSSABzqTRTFaRs7vdEoXagYAJA1ta'
AND mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
),
swap_from AS (
SELECT
tx_id,
tx_from,
tx_to,
amount,
mint AS mint_from,
RANK() OVER(PARTITION BY tx_id ORDER BY index ASC ) AS rank
FROM solana.core.fact_transfers
WHERE tx_from IN (SELECT tx_to FROM claim)
AND mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
AND block_timestamp >= '2024-01-31'
-- AND tx_id = '5HGXTmkrYsRnfR7BYC3Lrt1yT6ZrqwmriSXMMRD45qZNbHFi2vpEs2MHAVf3LN8z6DK3nKppw5VJ3hodidmRPpH'