rain_syndicaWallets that Got All Airdrops Except RLB
Updated 2023-06-22
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 Wallets that Got All Airdrops @ https://flipsidecrypto.xyz/edit/queries/a4c7f558-cecb-4b7a-a427-e53a7a342026
WITH
rlb_airdrop AS (
SELECT
tx_to AS recipient,
tx_id AS rlb_tx
FROM solana.core.fact_transfers
WHERE 1=1
AND block_timestamp < '2022-02-01'
AND block_timestamp >= '2021-12-20'
AND tx_from = 'AAbcWqh1WGQkVaK6GrMae1dVGcriwCxPh8PrW69vAEp4'
AND mint = 'RLBxxFkseAZ4RgJH3Sqn8jXxhmGoz9jWxDNJMh8pL7a'
GROUP BY 1,2
),
mplx_airdrop AS (
SELECT
signers[0] AS recipient,
tx_id AS mplx_tx
FROM solana.core.fact_transactions
WHERE instructions[1]:programId = 'gdrpGjVffourzkdDRrQmySw4aTHr8a3xmQzzxSwFD1a'
AND log_messages[22] = 'Program log: Instruction: Claim'
AND instructions[0]:parsed:info:mint = 'METAewgxyPbgwsseH8T16a39CQ5VyVxZi9zXiDPY18m'
AND succeeded = 'True'
AND block_timestamp >= '2022-10-11'
AND block_timestamp <= '2022-10-15'
GROUP BY 1,2
),
bonk_airdrop AS (
select
tx_to AS recipient,
tx_id AS bonk_tx
from solana.core.fact_transfers
Run a query to Download Data