peiw-ethMarinade Deposit
Updated 2022-03-11
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
block_timestamp::date as date,
sum(posttokenbalances[0]:uiTokenAmount:uiAmount) as mSOLamount
from solana.events
where block_timestamp::date >= '2022-03-01'
and instruction:programId = 'QMNeHCGYnLVDn1icRAfQZpjPLBNkfGbSKRB83G5d8KB'
--and instruction:accounts[2] = 'CrQ2xKzTRUe8VRsZAhNsJhdpbdgYwqi3r3G74Xzy8zb2'
-- and instruction:accounts[5] = 'FJLn5iZPtGQCRMY1yX2PtWRbq15zRZtTMdeTSSXqeEBX'
group by 1
order by 1
Run a query to Download Data