MLDZMNmgf11
Updated 2023-03-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
case when first_transaction_stamp >= '2023-02-08' THEN 'After MarginFi' else 'Before MarginFi' end as Time_gp,
type,
count (distinct sender) as new_users,
new_users/count(distinct date_trunc(day, first_transaction_stamp)) as average_user_day
from (
select
distinct t.signers[0] as sender,
l.LABEL_TYPE as type,
min(block_timestamp) as first_transaction_stamp
from solana.core.fact_events t join solana.core.dim_labels l on t.PROGRAM_ID = l.address
where t.block_timestamp>='2023-01-01'
and l.label_subtype != 'token_contract'
and l.LABEL_TYPE in ('defi','nft','dex')
and l.label != 'solana'
and t.succeeded = TRUE
group by 1,2
)
group by 1,2
Run a query to Download Data