BUYER | EARLIEST_PURCHASE | NEW_BUYER_COUNT | |
|---|---|---|---|
1 | 0x2a78babcff3389fb | 2024 2 | 1 |
2 | 0xf113a6cde6372cbd | 2024 1 | 1 |
3 | 0xacf920e25a1c11e7 | 2024 1 | 1 |
4 | 0x1188573f731b82bb | 2024 1 | 1 |
5 | 0xab5b258c97ba1a17 | 2024 1 | 1 |
6 | 0xabeb586c2265db9d | 2024 1 | 1 |
7 | 0xcf757ee9e5fae3d4 | 2024 1 | 1 |
8 | 0x5ef3b305f95ac255 | 2023 9 | 1 |
9 | 0xc65efaa534bb7019 | 2023 9 | 1 |
10 | 0xb5bfd888dddd2455 | 2023 9 | 1 |
11 | 0x03d5ee080d4d9fce | 2023 9 | 1 |
12 | 0x7d080e3177db9ca5 | 2023 9 | 1 |
13 | 0x37b42d58041450f9 | 2023 9 | 1 |
14 | 0xf0228b43657e372a | 2023 9 | 1 |
15 | 0xac6aff60aec60ee0 | 2023 9 | 1 |
16 | 0x226bdba0d8a2c4c6 | 2023 9 | 1 |
17 | 0x500144875171f39b | 2023 8 | 1 |
18 | 0x600858faac19d236 | 2023 8 | 1 |
19 | 0x3519b0a5efb59617 | 2023 8 | 1 |
20 | 0xb4dcb9b253907f82 | 2023 8 | 1 |
web3gameguidesNew Dimension X Buyers
Updated 2024-02-12
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
Buyer,
CONCAT(CAST(YEAR(Min(DATE(block_timestamp))) as varchar), ' ',CAST(MONTH(Min(DATE(block_timestamp))) as varchar) ) as earliest_purchase,
1 as new_buyer_count
FROM
flow.nft.ez_nft_sales flow
WHERE NFT_COLLECTION ='A.e3ad6030cbaff1c2.DimensionX'
AND DATE(block_timestamp) > '12/31/2021'
GROUP BY buyer
ORDER BY earliest_purchase DESC
Last run: over 1 year ago
...
1380
46KB
4s