zpencerUntitled Query
Updated 2022-10-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
select date(block_timestamp) as block_date, marketplace, count(distinct tx_id) txns, count(distinct purchaser) buyers, count(distinct seller) sellers, sum(sales_amount) as sales_volume
from solana.core.fact_nft_sales
where succeeded = true
and block_timestamp >= '2022-10-01'
group by date(block_timestamp), marketplace
order by 1;
select *
from ethereum.core.ez_nft_sales
where nft_address in (
'0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205',
'0xc43c97cfebfe912906c52a268ed5b6e21c8cc39d',
'0x06bc6bf1432c4f28da6ad2bee7d6e62f91b1b669',
'0x06bc6bf1432c4f28da6ad2bee7d6e62f91b1b669'
)
and price_usd > 0
order by price_usd desc
limit 100;
Run a query to Download Data