DATE | NEW_NFT_TRADERS | TOTAL_NFT_TRADERS | |
|---|---|---|---|
1 | 2025-03-23 00:00:00.000 | 1 | 90 |
2 | 2025-03-13 00:00:00.000 | 2 | 89 |
3 | 2025-03-12 00:00:00.000 | 4 | 87 |
4 | 2025-03-11 00:00:00.000 | 2 | 83 |
5 | 2025-03-10 00:00:00.000 | 1 | 81 |
6 | 2025-03-09 00:00:00.000 | 1 | 80 |
7 | 2025-03-08 00:00:00.000 | 1 | 79 |
8 | 2025-03-05 00:00:00.000 | 1 | 78 |
9 | 2025-03-04 00:00:00.000 | 1 | 77 |
10 | 2025-03-03 00:00:00.000 | 2 | 76 |
11 | 2025-03-01 00:00:00.000 | 2 | 74 |
12 | 2025-02-28 00:00:00.000 | 1 | 72 |
13 | 2025-02-26 00:00:00.000 | 3 | 71 |
14 | 2025-02-25 00:00:00.000 | 1 | 68 |
15 | 2025-02-21 00:00:00.000 | 1 | 67 |
16 | 2025-02-20 00:00:00.000 | 1 | 66 |
17 | 2025-02-14 00:00:00.000 | 1 | 65 |
18 | 2025-02-13 00:00:00.000 | 1 | 64 |
19 | 2025-02-12 00:00:00.000 | 2 | 63 |
20 | 2025-02-11 00:00:00.000 | 1 | 61 |
adriaparcerisasbeezie sales 2: new buyers
Updated 2025-03-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with news as (
select distinct topics[2] as buyer, min(trunc(block_timestamp,'day')) as debut
from flow.core_evm.fact_event_logs
where origin_function_signature in ('0x052eb226','0x09c56431') and contract_address='0xd112634f06902a977db1d596c77715d72f8da8a9' and tx_succeeded='TRUE'
and data='0x' and event_index=12
group by 1
)
select debut as date,
count(distinct buyer) as new_nft_traders,
sum(new_nft_traders) over (order by date) as total_nft_traders
from news
group by 1 order by 1 desc
Last run: 11 days ago
52
2KB
1s