DATE | NFT_SALES | TOTAL_NFT_SALES | DISTINCT_NFTS_PURCHASED | TOTAL_UNIQUE_NFT_PURCHASED | NFT_BUYERS | |
|---|---|---|---|---|---|---|
1 | 2025-03-01 00:00:00.000 | 10927 | 66759 | 21847 | 133997 | 10603 |
2 | 2025-02-01 00:00:00.000 | 7371 | 55832 | 14862 | 112150 | 7100 |
3 | 2025-01-01 00:00:00.000 | 17646 | 48461 | 35452 | 97288 | 16383 |
4 | 2024-12-01 00:00:00.000 | 20785 | 30815 | 41689 | 61836 | 18968 |
5 | 2024-11-01 00:00:00.000 | 10030 | 10030 | 20147 | 20147 | 9104 |
adriaparcerisasapp bz
Updated 8 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
trunc(block_timestamp,'month') as date,
count(distinct tx_id) as nft_sales,
sum(nft_sales) over (order by date) as total_nft_sales,
count(distinct event_data:nftID) as distinct_nfts_purchased,
sum(distinct_nfts_purchased) over (order by date) as total_unique_nft_purchased,
count(distinct event_data:NFTReceiver) as nft_buyers
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 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: 8 days ago
5
290B
9s