talebimorteza_72amount of msol
Updated 2022-03-11
9
1
2
3
4
5
6
›
⌄
select block_timestamp::date as date, sum(inner_instruction:instructions[0]:parsed:info:amount/POW(10,9)) as amount_of_msol
from solana.events
where block_timestamp::date >= '2022-03-01' and instruction:programId = 'QMNeHCGYnLVDn1icRAfQZpjPLBNkfGbSKRB83G5d8KB'
and instruction:accounts[2] = 'Hs2XmWQFw3ExawMQkCsBGQGX73JG1n2Qpjm8G7dYRw7m' and instruction:accounts[6] = 'J829VB5Fi7DMoMLK7bsVGFM82cRU61BKtiPz9PNFdL7b'
group by date
order by date Asc
Run a query to Download Data