dammyzuks2023-10-25 07:24 PM copy copy copy
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from 2023-10-25 07:24 PM copy copy @ https://flipsidecrypto.xyz/edit/queries/1d5d62e6-fd59-4511-8ae5-cc129af2b1c6
-- forked from 2023-10-25 07:24 PM copy @ https://flipsidecrypto.xyz/edit/queries/d8d4237d-e128-4ae9-bf8f-328625f0387e
-- forked from 2023-10-25 07:24 PM @ https://flipsidecrypto.xyz/edit/queries/2a97eaae-af58-42c3-9749-ee6824a5780e
SELECT
DATE_TRUNC('day', block_timestamp) AS _date,
AMOUNT,
MINT_TOKEN_SYMBOL,
SUM(MINT_PRICE_USD) AS MINT PRICE USD
SUM(NFT_COUNT) AS Total Nft
FROM
ethereum.nft.ez_nft_mints
WHERE
block_timestamp :: DATE BETWEEN '2022-04-01'
AND '2022-08-30'
and MINT_TOKEN_SYMBOL = 'ENS'
GROUP BY
1;
Run a query to Download Data