MLDZMNmgf12
Updated 2023-03-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
date_trunc('day',first_transaction_stamp) as date,
games,
count (distinct sender) as new_users
from (
select
distinct signers[0] as sender,
case
when PROGRAM_ID in ('So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo') then 'Solend'
when PROGRAM_ID in ('MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA') then 'MarginFi'
when PROGRAM_ID in ('JPPooLEqRo3NCSx82EdE2VZY5vUaSsgskpZPBHNGVLZ') then 'Jet'
end as games,
min(block_timestamp) as first_transaction_stamp
from solana.core.fact_events
where SUCCEEDED='TRUE'
and BLOCK_TIMESTAMP>='2023-01-01'
group by 1,2 having games is not null
)
where first_transaction_stamp>='2023-01-01'
group by 1,2
Run a query to Download Data