jonome[13] MDAO 101: SQL SUM copy
Updated 2023-06-04Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from metricsdao / [13] MDAO 101: SQL SUM @ https://flipsidecrypto.xyz/metricsdao/q/12-mdao-101-sql-count-GmQEFk
-- MetricsDAO Blockchain Analytics 101
-- https://docs.metricsdao.xyz/analyst-resources/blockchain-data-101
SELECT
DATE_TRUNC('week', block_timestamp) as _date,
currency_symbol,
SUM(platform_fee) AS total_platform_fee,
SUM(platform_fee_usd) AS total_platform_fees_usd
FROM ethereum.core.ez_nft_sales
WHERE block_timestamp::DATE BETWEEN '2022-01-01' AND '2022-06-30'
AND platform_name = 'opensea'
GROUP BY 1, 2
ORDER BY 1, 4 DESC;
Run a query to Download Data