rw2023Airdrop/Spent your wallet
Updated 2024-03-29
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 UsedInPlatform AS (
SELECT
DATE(block_timestamp) AS day,
SUM(-(amount * 50)) AS rkt_spent -- Asumiendo que deseas sumar el gasto total por día
FROM
solana.core.fact_transfers
WHERE
mint = 'RKT69NZHN5uovcan3q5hRbZzfJuXiGEuPmGANoBJLLz'
AND tx_to = 'rktaXbHouvPnCBbvEHEiaEXLitsPFT133UHhugjrhrL'
AND tx_from = '8Apw2ohL61SsykbqYqaZmhgwvWPHATBVaKAx1BCgL9oT'
AND block_timestamp >= '2023-12-05'
GROUP BY
DATE(block_timestamp)
),
Airdrop AS (
SELECT
DATE(block_timestamp) AS day,
SUM(amount) AS airdrop_received -- Asumiendo que deseas sumar la cantidad total recibida por día
FROM
solana.core.fact_transfers
WHERE
MINT = 'RKT69NZHN5uovcan3q5hRbZzfJuXiGEuPmGANoBJLLz'
AND TX_FROM IN ('BdMANnELKmZLfE94pHrKzGUFn7sGXqfPkq3kHAwZd2S4','AE6G66YP8y3QAWz3QbPSMQYL7USSdiWXXehn58ANJSmG')
AND tx_to = '8Apw2ohL61SsykbqYqaZmhgwvWPHATBVaKAx1BCgL9oT'
AND DATE(block_timestamp) >= '2023-12-05'
GROUP BY
DATE(block_timestamp)
),
CombinedData AS (
SELECT
COALESCE(uip.day, a.day) AS day,
COALESCE(uip.rkt_spent, 0) AS rkt_spent,
COALESCE(a.airdrop_received, 0) AS airdrop_received,
COALESCE(a.airdrop_received, 0) + COALESCE(uip.rkt_spent, 0) AS net_position
QueryRunArchived: QueryRun has been archived