mrnnptrcSMP OKR
Updated 2023-11-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
select platform_name, currency_symbol, count(*)
-- nft_address,
-- project_name,
-- platform_name,
-- case
-- when block_timestamp >= getdate() - interval '7 days' then 'L7D'
-- else 'P7D'
-- end as interval_tag,
-- count(*) as sales_count,
-- sum(price) as sales_volume_eth,
-- min(price) as min_price_eth,
-- count(distinct seller_address) as sellers,
-- count(distinct buyer_address) as buyers,
-- max(block_number) as latest_block
from
ethereum.nft.ez_nft_sales
where
nft_address = '0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38'
-- and currency_symbol in ('ETH', 'WETH')
and block_timestamp >= getdate() - interval '14 days'
group by
1,
2
-- 3,
-- 4,
-- 5
-- order by
-- 1,
-- 2,
-- 3,
-- 4,
-- 5
Run a query to Download Data