USER | BAL | |
---|---|---|
1 | HXGCUzrTXYq2otRnZ49dFDBeLoMygsfL2LFA4mrgZfoz | 0.00001700000212 |
2 | BPiunxZKqnVjfyGwxEGDJ8fo2Anc9KZW2w81gpbPRJV3 | 0.100024 |
3 | FWUdYakbRb4prFnLUJSrkNojoFucL3KKwBy5F5MfKsAr | 4.547473509e-13 |
4 | ADr56VbaDAVEwCUUCWs2PTsaVNGo2YEA19ybJnAtzPK | 0.034506 |
5 | GdpYY4sTeg9pBQmAer7kQ24diVcm3T1HxDa5P4XJdZhv | 9.999985195e-7 |
6 | DstmYRmgTRKr5UzgepqXoHzoRo5T4CPS5Ky1cHiCPP1g | 3.637978807e-12 |
7 | 7TXMSKhZRbu1AQyNJyDauwqE3bzzwJpZwcFAyYEnHcUn | 5.820766091e-11 |
8 | 22K33dFGRvQmavyrk1PqUeSC7t9GHUy7Cf52oGsTr5YM | 0.0000189999846 |
9 | ANvPZkc49VdRf6TaDU1CixfZd8NHpeqhfQwLZazRSZiq | 0.373012 |
10 | D6wh3WS66LqAa5ya4fTCvYRKaZDScC5d54H3ijbSAg3Z | 0.041589 |
11 | RWn4DQQ8M7eCm5mUZLZ6SGGMpHc5fSE3ihxCMbPXq4h | 0.757589 |
12 | 2Ffk7bo7fG2vopaKq8xwpTEj4iN9uT22TqZDFvsXQo3s | 3.637978807e-12 |
13 | bck8n1tcBdvgwkWVcBmsX29hEjvgkHZU5BfaScbQUKi | 2.273736754e-13 |
14 | CGr71RLiKRJ9xNeZ49Zv6RUTYSvbqWEq1c1DxgdAVLoy | 9.094947018e-13 |
15 | 6vCNEeCUHVyCfQ9wgQeVnpnF97gtJcFqNdoWGxFUhGcF | 0.929963 |
16 | FmPkASPzybdLZBsdrqTmT8k7v5BpXWERE9Hhazv1hktX | 1.455191523e-11 |
17 | 9jGWT4YJCxbkTEGRc1jmGBXnEDCXKBhJfx4GGy8ZeFN4 | 0.00006800000028 |
18 | H6HnRJ5X2mmtVgUAuGzgmyXXGwAQUwZZy3SYcCMmtWui | 5.684341886e-14 |
19 | BoC8ZvF8JMc2JzVddjZdrnbLT2RLZA1gjYYLPwrByQ3R | 9.999999975e-7 |
20 | HRbvwPmivADgLAT6gC3bxbpKgCy7KGZuT5bMSsZsSgYj | 1.136868377e-13 |
33crescoJup Airdrop 2 copy copy
Updated 2024-02-02Copy Reference Fork
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
›
⌄
-- forked from jackguy / Jup Airdrop 2 copy @ https://flipsidecrypto.xyz/jackguy/q/QECNszgj2bVF/jup-airdrop-2-copy
-- forked from Jup Airdrop 2 @ https://flipsidecrypto.xyz/edit/queries/0d64d718-13ee-405c-9867-d34c74e16d23
WITH claim_txs AS (
SELECT DISTINCT
block_timestamp,
tx_id
FROM solana.core.fact_events
WHERE succeeded
AND program_id = 'meRjbQXFNf5En86FXT2YPz1dQzLj4Yb3xK8u1MVgqpb'
AND block_timestamp > '2024-01-29'
),
transfers AS (
SELECT
block_timestamp,
tx_id,
tx_to,
amount
FROM solana.core.fact_transfers
WHERE mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
AND tx_id IN (SELECT tx_id FROM claim_txs)
AND block_timestamp > '2024-01-29'
),
tab1 AS (
SELECT
user,
SUM(
CASE WHEN flow = 'in' THEN amt
ELSE -amt END
) AS bal
FROM (
SELECT
tx_to AS user,
Last run: over 1 year ago
7131
432KB
19s