anomoneWhat other activities are these top 20 wallets doing in the month of February
Updated 2022-03-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH top20 as (
SELECT
INNER_INSTRUCTION:instructions[0]:parsed:info:authority as Wallet,
sum((INNER_INSTRUCTION:instructions[0]:parsed:info:amount )/1e6) as Locked_Amount FROM solana.events
WHERE ---TX_ID = '5m3cXquqMncfCgEArC5AHnoZMYUckPzJcJ3FFDhiEuDjBNRB9odCmVDygBk22C7AivGMF4yM157NaPbpR3ekkebH'
PRETOKENBALANCES[0]:mint = 'Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1'
AND Instruction:programId = 'LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
AND INNER_INSTRUCTION:instructions[0]:programId = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
AND SUCCEEDED = 'True'
AND date_trunc('month', BLOCK_TIMESTAMP) like '2022-02-01 %' --Filtering for the month of Feb
GROUP BY Wallet
ORDER BY Locked_Amount DESC
LIMIT 20)
Select
Instruction:programId as program,
sum((INNER_INSTRUCTION:instructions[0]:parsed:info:amount )/1e6) as Amount FROM solana.events
WHERE date_trunc('month', BLOCK_TIMESTAMP) like '2022-02-01 %'
AND SUCCEEDED = 'True'
AND INNER_INSTRUCTION is not null
GROUP BY program
ORDER BY Amount desc
Run a query to Download Data