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
QueryRunArchived: QueryRun has been archived