dammyzuks[20] MDAO 101: CTEs copy
Updated 2023-10-25
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
›
⌄
-- forked from metricsdao / [20] MDAO 101: CTEs @ https://flipsidecrypto.xyz/metricsdao/q/p96UqgFruZ89/20]-mdao-101-ctes
-- MetricsDAO Blockchain Analytics 101
-- https://docs.metricsdao.xyz/analyst-resources/blockchain-data-101
WITH
opensea_sales AS (
SELECT
*
FROM ethereum.core.ez_nft_sales
WHERE block_timestamp::DATE BETWEEN '2022-06-01' AND '2022-06-30'
AND platform_name = 'opensea'
)
SELECT
DATE_TRUNC('day', block_timestamp) as _date,
CASE
WHEN currency_symbol = 'ETH' THEN 'ETH'
WHEN currency_symbol = 'WETH' THEN 'WETH'
WHEN currency_symbol = 'USDC' THEN 'USDC'
ELSE 'Other'
END AS currency_symbol,
SUM(platform_fee) AS total_platform_fee,
SUM(platform_fee_usd) AS total_platform_fees_usd
FROM opensea_sales
GROUP BY 1, 2
ORDER BY 1, 4 DESC;
Run a query to Download Data