some itch.io stats

gistfile1.sql

-- total games

itchio=# select count(*) from games where not deleted and published;
 count 
-------
   258
(1 row)


-- total downloads

itchio=# select sum(count) from downloads_daily;
  sum  
-------
 10079
(1 row)



-- download counts for the top 10 games

itchio=# select sum(count) from downloads_daily group by game_id order by total desc limit 10;         
  sum 
-------
  3183
  1459
   393
   387
   278
   253
   250
   213
   205
   176
(10 rows)



-- total money moved, truncated to USD, in cents

itchio=# select sum(price) from purchases where status = 1;
  sum   
--------
 309939
(1 row)



-- total money moved in past 30 days (well over half of total, so good growth):

itchio=# select sum(price) from purchases where status = 1 and created_at > current_date - interval '30 days';
  sum   
--------
 185547
(1 row)



-- perecent usage of currencies

itchio=# select currency, count(*)::float / (select count(*) from purchases where status = 1) as p from purchases where status = 1 group by currency order by p desc;
 currency |         p          
----------+--------------------
 USD      |  0.788059701492537
 GBP      | 0.0925373134328358
 CAD      | 0.0582089552238806
 EUR      | 0.0402985074626866
 AUD      | 0.0208955223880597
(5 rows)