takamoritrying to get veefriends
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
33
34
35
36
›
⌄
select
A.date, B.median, B.avg, max(sales-buys)
from
(select date(block_timestamp) as date, seller_address, count(*) as sales from ethereum.core.ez_nft_sales where nft_address = {{nft}} and platform_name = 'blur'
and block_timestamp > {{date}}
group by 1, 2, 3) as A
left join
(select date(block_timestamp) as date, buyer_address, count(*) as buys from ethereum.core.ez_nft_sales where nft_address = {{nft}} and platform_name = 'blur'
and block_timestamp > {{date}}
group by 1, 2) as C
on A.date = C.date and A.seller_address = C.buyer_address
JOIN
(select date(block_timestamp) as date, median(price) as median, sum(price)/count(price) as avg
from ethereum.core.ez_nft_sales where nft_address = {{nft}} and platform_name = 'blur'
and block_timestamp > {{date}}
group by 1
) as B
on
A.date = B.date
group by 1 order by 1 desc
Run a query to Download Data