DATE | NFT_SALES | TOTAL_NFT_SALES | NFT_TRADERS | |
|---|---|---|---|---|
1 | 2025-04-14 00:00:00.000 | 1 | 763 | 1 |
2 | 2025-04-02 00:00:00.000 | 6 | 762 | 1 |
3 | 2025-03-24 00:00:00.000 | 10 | 756 | 1 |
4 | 2025-03-13 00:00:00.000 | 1 | 746 | 1 |
5 | 2025-03-11 00:00:00.000 | 3 | 745 | 1 |
6 | 2025-03-07 00:00:00.000 | 2 | 742 | 1 |
7 | 2025-03-06 00:00:00.000 | 19 | 740 | 7 |
8 | 2025-03-03 00:00:00.000 | 1 | 721 | 1 |
9 | 2025-03-01 00:00:00.000 | 3 | 720 | 1 |
10 | 2025-02-28 00:00:00.000 | 1 | 717 | 1 |
11 | 2025-02-27 00:00:00.000 | 3 | 716 | 1 |
12 | 2025-02-24 00:00:00.000 | 1 | 713 | 1 |
13 | 2025-02-01 00:00:00.000 | 93 | 712 | 2 |
14 | 2025-01-31 00:00:00.000 | 3 | 619 | 1 |
15 | 2025-01-24 00:00:00.000 | 1 | 616 | 1 |
16 | 2025-01-16 00:00:00.000 | 2 | 615 | 1 |
17 | 2025-01-12 00:00:00.000 | 1 | 613 | 1 |
18 | 2025-01-08 00:00:00.000 | 2 | 612 | 1 |
19 | 2024-12-30 00:00:00.000 | 1 | 610 | 1 |
20 | 2024-12-29 00:00:00.000 | 1 | 609 | 1 |
adriaparcerisasmintify sales
Updated 6 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
--select * from flow.core_evm.fact_event_logs where tx_hash in ('0xc3e09ef5619d49e01586fc34d61a9841a6dba0ef009146eaa64b9feddb7f7563' ,'0xbeb7e344960e0655a523a319ec9cac3eadaf69bb759d1844f695890a88db3590')
select trunc(block_timestamp,'day') as date,
count(*) as nft_sales,
sum(nft_sales) over (order by date) as total_nft_sales,
count(distinct origin_from_address) as nft_traders
from flow.core_evm.fact_event_logs
where origin_function_signature in ('0xe7acab24','0x87201b41') and lower(origin_to_address)=lower('0x00000003cf2c206e1fdA7fd032b2f9bdE12Ec6Cc') and tx_succeeded='TRUE'
and data='0x'
group by 1 order by 1 desc
Last run: about 6 hours ago
59
2KB
1s