Ali3NDaily Sales Stats Laliga Golazos vs Topshot vs Allday vs FIFA+ Stats First Week
Updated 2022-12-06
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
›
⌄
with maintable as (
select 'LaLiga Golazos' as project_name,
date_trunc (day,block_timestamp) as date,
count (distinct tx_id) as Sales_Count,
count (distinct buyer) as Buyers_Count,
count (distinct nft_Id) as Tokens_Count,
sum (price) as Total_Volume,
avg (price) as Average_Volume,
median (price) as Median_Volume,
min (price) as Minimum_Volume,
max (price) as Maximum_Volume,
sum (sales_count) over (order by date) as Cumulative_Sales_count,
sum (total_volume) over (order by date) as Cumulative_Sale_volume,
row_number () over (order by date) as Day_Counter
from flow.core.ez_nft_sales
where nft_collection = 'A.87ca73a41bb50ad5.Golazos'
and tx_succeeded = 'TRUE'
group by 1,2
union ALL
select 'TopShot' as project_name,
date_trunc (day,block_timestamp) as date,
count (distinct tx_id) as Sales_Count,
count (distinct buyer) as Buyers_Count,
count (distinct nft_Id) as Tokens_Count,
sum (price) as Total_Volume,
avg (price) as Average_Volume,
median (price) as Median_Volume,
min (price) as Minimum_Volume,
max (price) as Maximum_Volume,
sum (sales_count) over (order by date) as Cumulative_Sales_count,
sum (total_volume) over (order by date) as Cumulative_Sale_volume,
row_number () over (order by date) as Day_Counter
from flow.core.ez_nft_sales
where nft_collection = 'A.0b2a3299cc857e29.TopShot'
Run a query to Download Data