0xaimanUntitled Query
Updated 2022-09-13
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select date as month, vol_sales, vol_sales_usd,
sum(vol_sales) OVER(ORDER BY month asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_vol_sales,
sum(vol_sales_usd) OVER(ORDER BY month asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_vol_sales_usd
from (select date_trunc('month', block_timestamp) as date, currency_symbol, sum(price) as vol_sales, sum(price_usd) as vol_sales_usd
from ethereum.core.ez_nft_sales
where event_type = 'sale'
group by 1,2) where currency_symbol='ETH' or currency_symbol='WETH'
order by 1 desc
Run a query to Download Data