mz0111opti 9
Updated 2023-02-23Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
SELLER_ADDRESS,
count(distinct tx_hash) as "sales count",
sum (price_usd) as "Total USD amount"
from optimism.core.ez_nft_sales
join optimism.core.dim_labels b on NFT_ADDRESS = address
where BLOCK_TIMESTAMP >= CURRENT_DATE - {{period}}
and PROJECT_NAME = 'project galaxy'
and PRICE_USD is not null
and project_name is not null
group by 1
order by 3 DESC
limit 5
Run a query to Download Data