yasmin-- 10 NFT Mints and Sales Volume Count of NFT mints, sales and sum of sales in USD
Updated 2025-03-11Copy Reference Fork
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
›
⌄
-- forked from cloudr3n / Avax NFT Trading Volume @ https://flipsidecrypto.xyz/cloudr3n/q/YNNC6_TfoAoe/avax-nft-trading-volume
-- 7 Stablecoin to Non-Stable Sales Dex sell of an asset NOT in the stablecoin list to an asset in the stablecoin list
-- 8 Primary Asset Deposits Gas token or proprietary token lending deposits
-- 9 Stablecoin borrows Borrows of tokens in the list of stablecoins
-- 10 NFT Mints and Sales Volume Count of NFT mints, sales and sum of sales in USD
-- 11 Developer Contract/Program depolyments Count of daily contract deployments
----------10-----------------
WITH nft_mint AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
COUNT(DISTINCT ez_nft_transfers_id) AS nft_mint
FROM avalanche.nft.ez_nft_transfers
WHERE EVENT_TYPE = 'mint'
and block_timestamp >= DATEADD(month, -1, CURRENT_DATE())
GROUP BY day
),
nft_sales AS (
SELECT day,
SUM(nft_sale_usd) AS nft_sale_usd,
SUM(tx) AS tx,
SUM(SUM(nft_sale_usd)) OVER (ORDER BY day) AS cumulative_nft_sales_usd
FROM (SELECT DATE(block_timestamp) AS day,
SUM(price_usd) AS nft_sale_usd,
COUNT(*) AS tx
FROM avalanche.nft.ez_nft_sales
WHERE block_timestamp >= DATEADD(month, -1, CURRENT_DATE())
GROUP BY 1
UNION ALL
-- Hyperspace Sales--------------
SELECT DATE(l.block_timestamp) AS day,
SUM(l.decoded_log:erc20TokenAmount * POW(10, -18) * p.price) AS nft_sale_usd,
COUNT(*) AS tx
FROM avalanche.core.ez_decoded_event_logs l
LEFT JOIN avalanche.price.ez_prices_hourly p
ON DATE_TRUNC('hour', l.block_timestamp) = p.hour
QueryRunArchived: QueryRun has been archived