PYPI downloads statistic from Google Big Query

pypi_queries

#MONTHLY PYPI PACKAGE DOWNLOADS 
SELECT
  COUNT(*) AS num_downloads,
  SUBSTR(_TABLE_SUFFIX, 1, 6) AS `day`
FROM `the-psf.pypi.downloads*`
WHERE
  file.project = 'mindsdb'
  -- Only query the last 6 months of history
  AND _TABLE_SUFFIX
    BETWEEN FORMAT_DATE(
      '%Y%m01', DATE_SUB(CURRENT_DATE(), INTERVAL 6 MONTH))
    AND FORMAT_DATE('%Y%m%d', CURRENT_DATE())
GROUP BY `day`
ORDER BY `day` DESC

#Filtered PYPI Downloads
SELECT 
    details.installer.name,
    COUNT(*) as donwload_count,
FROM `the-psf.pypi.downloads*`
WHERE
file.project = 'mindsdb'
AND _TABLE_SUFFIX
BETWEEN FORMAT_DATE('%Y%m%d', DATE('2020-01-04'))
AND FORMAT_DATE('%Y%m%d', DATE('2020-02-25'))
GROUP BY details.installer.name