headitmanagerThe 10 largest transactions
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
›
⌄
with tbl as (select solana.transactions.tx_id,(inner_instruction:instructions[0]:parsed:info:amount/1e9) as amount
from solana.events
inner join solana.transactions
on solana.transactions.tx_id=solana.events.tx_id
where
inner_instruction:instructions[0]:parsed:type='transfer'
and inner_instruction:instructions[1]:parsed:type='transfer'
and inner_instruction:instructions[0]:programId='TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
and inner_instruction:instructions[1]:programId='11111111111111111111111111111111'
and program_Id = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'
and date(solana.events.block_timestamp) > '2022-02-01'
order by amount DESC
limit 10
)
select * from tbl
Run a query to Download Data