majidgholamiUntitled Query
Updated 2022-07-27
9
1
2
3
4
5
6
7
8
›
⌄
select (INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:source) as top_user,
(INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:amount) as Volume
from solana.core.fact_transactions
where instructions[1]:programId = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
or instructions[1]:programId = 'SWimmSE5hgWsEruwPBLBVAFi3KyVfe8URU2pb4w7GZs'
and succeeded ='true'
order by Volume desc
limit 10
Run a query to Download Data