KaskoazulTop 20 wallets activity programs
Updated 2022-03-09
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 TOP20_ACTIVITY AS (
SELECT
t.tx_id,
t.tx_from_address as wallet,
t.program_id,
l.address_name,
l.label,
l.label_subtype,
l.label_type
FROM
solana.transactions t
INNER JOIN solana.labels l
ON t.program_id = l.address
WHERE
block_timestamp >= '2022-02-01'
AND wallet IN ('5vzjFqyZ2mgm7EryL82EWCeGwykJCC6FkqyXEx3MTPsu',
'6HFxHT4tFVB19weeMGYQrepa51rzxjydkhWAaomsf6g4',
'9qZwCKnNCTbZD91B34gk8XX3aPn4wALbUZiL3YpVBEvK',
'DyLrwLtfhFGo2mbr2Dx4LPDcTvrgsV6wZsdpphHUgH3r',
'2asR4HQHhZrMHq4vGykzSHhRqhMZq9Q6C6Wb3JKgjg55',
'CkkKEC59UsmfxZTGmsgfSdy1UEox69NNhuD5nPjitqKM',
'8xg9H6GfxBN2nmbEkf4LBD1sWJct2LfsVpCDKKn8tc3M',
'D3KNHjYntZcZtQrCjJkT1nmMpCirvTZCbLf2t9y4FnR6',
'2j1554XSRq9ByBb2m1xoxQf2FaA1mAv9UZLoD7dgedt1',
'B9ytpw6fHdGVDGxY9NhwJeKQyqStRGzcWkaEaRQb4LT1',
'4zYicQNY8FGdNcimLr9RAY8Q6eGN6SyQHu4ssC8MoG1o',
'DHDRgcrqY7VWd6kzbD7GogJAeetcMrVH2u6xqEn83KNU',
'HCMezjwENhcgPfxpTfUhL4USCXNC8cHCYe191qx4sQYZ',
'9fkenN9cVyYgdmuRiPKGUbm88dDih9YxFMjXNJsHgrrJ',
'C3DGZ4yMo6PU1vJ47hLJAxDoUjJpms6TFPTnKFGwMWuL',
'D2y6VMajt6yS4a2Kek3pUqDxerDQWhF8FJNgEsaVD4dy',
'3MPBiNkw8u4Hf2vL4NpRQkatbpde14eLBjjenzpTLNR5',
'55J4kCCGa8D5mcmpTYZi6868a35gN3JhHr1tNWR6Topg',
'99FrbDQBhdFbnoji8LiTMgVahMUSwM12xgk68d8oC5XK',
'2vqqAXy1b7adhu4oYZNgrgeW5m1efaLuo86DTZFNyX84')
)
Run a query to Download Data