niloCopy of mint copy
Updated 2023-06-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH
BASE AS (
SELECT
MIN(BLOCK_TIMESTAMP) AS MINT,
NFT_ID
FROM
flow.core.ez_nft_sales SALES
WHERE
NFT_COLLECTION = 'A.e3ad6030cbaff1c2.DimensionX'
AND TX_SUCCEEDED = 'TRUE'
GROUP BY
2
),
FINAL as (
SELECT
COUNT(DISTINCT MINT) AS MINT_SALES,
COUNT(DISTINCT TX_ID) AS TOTAL_SALES,
TOTAL_SALES - MINT_SALES AS SECONDARY_SALES
FROM
flow.core.ez_nft_sales SALES
LEFT JOIN BASE ON BLOCK_TIMESTAMP = MINT
WHERE
NFT_COLLECTION = 'A.e3ad6030cbaff1c2.DimensionX'
AND TX_SUCCEEDED = 'TRUE'
)
SELECT
'MINT SALES' AS
type,
MINT_SALES
FROM
FINAL
UNION
SELECT
'SECONDARY SALES' AS
type,
SECONDARY_SALES
Run a query to Download Data