majidgholamiTotal Volume
Updated 2022-07-27
9
1
2
3
4
5
6
7
8
›
⌄
select (sum(INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:amount))/10e8 as total_from ,
(sum(INNER_INSTRUCTIONS[0]:instructions[1]:parsed:info:amount))/10e8 as total_to,
(total_from + total_to) as total_volume
from solana.core.fact_transactions
where instructions[1]:programId = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
or instructions[1]:programId = 'SWimmSE5hgWsEruwPBLBVAFi3KyVfe8URU2pb4w7GZs'
and succeeded ='true'
Run a query to Download Data