mmdrezaDaily Total sales Volume of Top 10 expensive players
Updated 2022-09-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with tab1 as (select player,count(tx_id) as transactions,avg(price) as avg_price
from flow.core.ez_nft_sales s
join flow.core.dim_allday_metadata m on m.nft_id = s.nft_id
where play_type is not null
and s.nft_collection like 'A.e4cf4bdc1751c65d.AllDay'
and play_type not like 'Pressure'
and player not like 'N/A'
group by player
order by avg_price desc
limit 10)
select date_trunc('day',block_timestamp)as date,player,count(tx_id) as transactions,sum(price) as volume
from flow.core.ez_nft_sales s
join flow.core.dim_allday_metadata m on m.nft_id = s.nft_id
where player in(select player from tab1)
and s.nft_collection like 'A.e4cf4bdc1751c65d.AllDay'
and player not like 'Pressure'
and player not like 'N/A'
group by date,player
order by date asc
Run a query to Download Data