kentoindirect-maroon
Updated 2025-03-24
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
›
⌄
-- 1️⃣ Total NFT Sales Volume ($)
WITH eth_sales AS (
SELECT DATE_TRUNC('day', block_timestamp) AS date,
SUM(price_usd) AS eth_sales_volume
FROM ethereum.nft.ez_nft_sales
WHERE block_timestamp >= '2025-01-01'
GROUP BY 1
),
arb_sales AS (
SELECT DATE_TRUNC('day', block_timestamp) AS date,
SUM(price_usd) AS arb_sales_volume
FROM arbitrum.nft.ez_nft_sales
WHERE block_timestamp >= '2025-01-01'
GROUP BY 1
),
avax_sales AS (
SELECT DATE_TRUNC('day', block_timestamp) AS date,
SUM(price_usd) AS avax_sales_volume
FROM avalanche.nft.ez_nft_sales
WHERE block_timestamp >= '2025-01-01'
GROUP BY 1
),
sol_sales AS (
SELECT DATE_TRUNC('day', block_timestamp) AS date,
SUM(price_usd) AS sol_sales_volume
FROM solana.nft.ez_nft_sales
WHERE block_timestamp >= '2025-01-01'
GROUP BY 1
),
poly_sales AS (
SELECT DATE_TRUNC('day', block_timestamp) AS date,
SUM(price_usd) AS poly_sales_volume
FROM polygon.nft.ez_nft_sales
WHERE block_timestamp >= '2025-01-01'
GROUP BY 1
)
QueryRunArchived: QueryRun has been archived