nsa2000evm19
Updated 2023-01-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
--distinct PLATFORM_NAME,
--PROJECT_NAME,
date_trunc('day', block_timestamp) as date,
CASE
when date < '2023-01-01' then 'Before'
when date >= '2023-01-01' then 'After'
end as new_year,
count(distinct TX_HASH) as sales,
count(distinct seller_address) as sellers,
count(distinct buyer_address ) as buyers,
sum(PRICE_USD) as USD
from ethereum.core.ez_nft_sales
where event_type = 'sale'
and date between'2022-12-17' and '2023-01-13'
and CURRENCY_SYMBOL ilike 'ETH'
group by 1,2
order by 1 asc