keshanSaber and daoSOL
Updated 2022-02-18
9
1
2
3
4
5
6
7
8
9
›
⌄
select block_timestamp::date as day, sum(inner_instruction:instructions[2]:parsed:info:amount)/1e9 as amount, count(distinct inner_instruction:instructions[0]:parsed:info:authority) as new_users
from solana.events
where day >= '2022-02-01'
and succeeded = 'TRUE'
and inner_instruction:instructions[2]:parsed:info:mint = 'monKYjV2bHTjbJVWCCcwhxE8C96sdTKR2HUNUHCjh4z'
and index = 4
and inner_instruction:instructions[2]:parsed:info:mintAuthority = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr'
group by day
Run a query to Download Data