Rocky_sTotal ETH mint based on sales
Updated 2023-05-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with sales AS (
SELECT date_trunc('day', block_timestamp) AS date,
nft_address, sum(price) AS total_eth_sales
FROM ethereum.core.ez_nft_sales
WHERE date > current_date() - 30
GROUP BY 1,2),
mints AS (
SELECT date_trunc('day', block_timestamp) AS date,
nft_address, sum(mint_price_eth) AS total_eth_mint
FROM ethereum.core.ez_nft_mints
WHERE date > current_date() - 30
GROUP BY 1,2)
SELECT s.date, s.nft_address, s.total_eth_sales, m.total_eth_mint
FROM sales AS s LEFT JOIN mints AS m
on s.date = m.date AND s.nft_address = m.nft_address
WHERE total_eth_sales > 0 AND total_eth_mint > 0
ORDER BY 1,3
Run a query to Download Data