theericstoneUntitled Query
Updated 2021-10-05
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select sum(price_usd) as usd_volume,
sum(price) as eth_volume,
date_trunc('day',block_timestamp) as date,
coalesce(project_name,'unlabeled') as project_name
from ethereum.nft_events
where event_platform = 'opensea'
and price_usd < 100000000
and tx_currency in ('ETH','WETH')
and block_timestamp > '2021-09-15'
group by 3,4;
Run a query to Download Data