headitmanagerHave these top wallets added to their locked SBR
Updated 2022-03-08
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 temp as (select count(*) as tcount ,inner_instruction:instructions[0]:parsed:info:destination as wallet
from solana.events
inner join solana.transactions
on solana.transactions.tx_id=solana.events.tx_id
where program_id ='LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
and (pre_mint ='Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1' or post_mint='Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1')
and date(solana.transactions.block_timestamp) >= '2022-02-01'
and date(solana.transactions.block_timestamp) <= '2022-02-28'
and wallet in (
'Gb3Hi2csYA7i4Z1aBqycdqA3aCU1L3mjFrDqKwUAV3JE',
'7qNEu6dQqgiHijriC987jMhgoctiJmXa9hStfWYQVk11',
'AD1V7SkazkCwe6Jgp8ZujhNGoeiLsYDkDoXnxgZqXJPV',
'8CAiyN76TSezexNp3pqZNNca2sP3shqj1qsFF3xspcCM',
'DN15LBU1n97t9B4LGYY988AfnHt3k2fAC3Uo3VFni2jT',
'C3skDAmVx8yQiQCkTPexW8VkgHg5okUb2ng2VD2ntUug',
'J3e2SujZKyCVLCoY3QgyCtjvUDKXSwBMLcyQsuZhy6my',
'2FjabrUJ8tryW3n8wqohdm22s5uxU3dMoXKbsTR95vsE',
'DyDVe9Wbj9BnMA73bUcscMsxi46NtkAonBBydoxDBzPP',
'39C1bzrPpATawf96qbjQDnNEPbzcJr4mCw7UKVmJ75dq',
'9G7cdDbJHmMjh4aMKtoHe5WJ3xYWQFKWY5ywvBDQsVT4',
'6xE4VV76QpQphFwPEsQy9ddsm6a4WSYhVaq4MfVE39C3',
'5vNZ1Ae68puDt6vcMcwFrXFq281pNffAASHXiL1iwaCg',
'A9LfseEGPdBkeD1qvkNqRnSfPo1oYWj9kvEPYZyZzjM2',
'4CBpmjDDuo1xDoT8BXjDUqGkEViQUDwjkoMZPfRWNtkV',
'7wwsW6GpoQciPUNzaV7Prf4CjAogPV2oSAqzYkgBTMVS',
'GymvfokQjHp4hmhiXdQgYnAv3qMPATeNNsJchWhTAS9d',
'4ggsc2fs6kyv4WsrEZ5nQQUCdSNTDPeZ4dEznNSDXT23',
'HXtoYeaXPGrU56ojZXVBXjQpMzbfx5ZVpei9A4ijLzNX',
'123t1P1D96U1Lv1QKgVN8tx3Sunky87sbWxeNsZwQv7p')
group by wallet
)
select * from temp
Run a query to Download Data