Updated 2022-03-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- select *
-- from solana.transactions
-- where tx_id ='ngF3HJPi3g7WwkEXU7L4d8gRuggtLTq9cJ31tLXvhxqyet73oX23iaZiqL3cMv9o573xa4gjKqotrksB7N6unf1'
select
count(DISTINCT(inner_instruction:instructions[0]:parsed:info:destination) ) as coun,
-- instruction:programId,
-- inner_instruction:instructions[0]:parsed:info:source,
date_trunc('day', block_timestamp) as day
-- *
from solana.events
where date_trunc('day', block_timestamp) BETWEEN '2022-03-01 00:00:00.000' and '2022-03-11 00:00:00.000'
-- on Solana we *always* add a small date range for query efficiency!
-- where date_trunc('day', block_timestamp) > '2022-01-21 00:00:00.000'
and instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'
and inner_instruction:instructions[0]:parsed:info:source = '7GgPYjS5Dza89wV6FpZ23kUJRG5vbQ1GM25ezspYFSoE'
GROUP BY day
ORDER BY day
-- order by block_timestamp;
Run a query to Download Data