nitsFriktion Crab Startegy - 2
Updated 2022-05-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT date(first_use) as day, COUNT(participants) as total_unique_users, sum(total_unique_users) over (order by day ) as cumulative_users
from
(SELECT ( inner_instruction:instructions[0]:parsed:info:source) as participants , min(date(block_timestamp)) as first_use
from solana.fact_events
where
instruction:accounts[3] ilike '86nx2WyrdC6VuWyfdG1gMLiiBduktBTJgToKZAYwcbct'
-- program_id ilike 'VoLT1mJz1sbnxwq5Fv2SXjdVDgPXrb9tJyC8WpMDkSp'
and block_timestamp >= '2022-04-11'
GROUP by 1 )
GROUP by 1
limit 1000
Run a query to Download Data