DEBUT | NEW_BUYERS | TOTAL_BUYERS | |
|---|---|---|---|
1 | 2025-03-01 00:00:00.000 | 8297 | 52384 |
2 | 2025-02-01 00:00:00.000 | 4810 | 44087 |
3 | 2025-01-01 00:00:00.000 | 12847 | 39277 |
4 | 2024-12-01 00:00:00.000 | 17326 | 26430 |
5 | 2024-11-01 00:00:00.000 | 9104 | 9104 |
adriaparcerisasapp bz 2
Updated 2025-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with
news as (
select distinct event_data:NFTReceiver as buyer,
min(trunc(block_timestamp,'month')) as debut
from flow.core.fact_events
where block_timestamp>'2024-01-01' and tx_succeeded='TRUE' and event_contract='A.7d09be7121e058eb.NBAsageNFT' and event_type='NFTPurchased'
and event_data:name='NBAsage Yes'
group by 1
)
select
debut,
count(distinct buyer) as new_buyers,
sum(new_buyers) over (order by debut) as total_buyers
from news
group by 1 order by 1 desc
-- per saber volume, event_type='Deposited' and event_data:to <> '0xf919ee77447b7497' -- es nomes per fees
-- agafar el event_data:amount i el event_data:to com a seller i el event_data:type com a moneda
Last run: 14 days ago
5
197B
9s