permarypumpfun
Updated 2024-11-03
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 sol_transfers AS (
-- Step 1: Select transfers from Pump Fun fee account to Kraken for 2024
SELECT
tx_id,
block_timestamp,
tx_from AS from_address,
tx_to AS to_address,
amount AS sol_amount
FROM
solana.core.fact_transfers
WHERE
tx_from = 'CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM' -- Pump Fun Fee Account
AND tx_to = '5x2knY4Mx9rfvtumZm7WaaBS24SMe2bmCncsGaTSSiQq' -- Kraken Address
AND block_timestamp >= '2024-01-01' -- Only transfers from January 1, 2024, onward
)
-- Final Output
SELECT
tx_id,
block_timestamp,
from_address,
to_address,
sol_amount
FROM
sol_transfers
ORDER BY
block_timestamp ASC;
WITH sol_transfers AS (
-- Step 1: Select transfers from Pump Fun fee account to Kraken for 2024
SELECT
tx_id,
block_timestamp,
tx_from AS from_address,
tx_to AS to_address,
QueryRunArchived: QueryRun has been archived