MLDZMNhold2
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date_trunc('day', first_transaction_stamp) as date,
case when date>='2023-06-05' then 'After classification' else 'Before classification' end as time_gp,
count (distinct receiver) as new_holders
from (
select
tx_to as receiver,
min(block_timestamp) as first_transaction_stamp
from solana.core.fact_transfers
where MINT = 'So11111111111111111111111111111111111111112'
and block_timestamp>='2023-05-15'
group by 1
)
group by 1,2
Run a query to Download Data