Sbhn_NPdecisive-emerald
Updated 2024-10-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select date_trunc('day',block_timestamp) as date,
count(DISTINCT tx_hash) as sales,
sum(sales) over (order by date) as cumulative_sales,
count(DISTINCT buyer_address) as buyers,
count(DISTINCT seller_address) as sellers,
sum(price) as volume,
sum(price_usd) as usd_volume,
avg(price_usd) as avg_volume
from near.nft.ez_nft_sales
where nft_address='aa-harvest-moon-relics.near'
group by 1
-- select *
-- from near.nft.ez_nft_sales
-- where nft_address='aa-harvest-moon-relics.near'
-- and method_name = 'resolve_offer'
-- limit 10
QueryRunArchived: QueryRun has been archived