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