query.sql

SELECT
 COUNT(*) AS downloads,
 file.filename
FROM
 TABLE_DATE_RANGE( [long-stack-762:pypi.downloads], TIMESTAMP("20160114"), CURRENT_TIMESTAMP() )
WHERE
 file.type = 'bdist_wheel'
 AND NOT REGEXP_MATCH(file.filename, '^.*-none-any.whl$')
GROUP BY
 file.filename
ORDER BY
 downloads DESC
LIMIT
 1000

results.md

downloads	filename
6646	numpy-1.10.4-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
5445	cryptography-1.2.1-cp27-none-win_amd64.whl
5243	matplotlib-1.4.0-cp34-none-win32.whl
5241	scikit_learn-0.15.1-cp34-none-win32.whl
4573	pandas-0.17.1-cp27-none-win_amd64.whl
4062	cffi-1.5.0-cp27-none-win_amd64.whl
4009	cffi-1.5.0-cp27-none-macosx_10_6_intel.whl
3467	Pillow-3.1.0-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
2799	matplotlib-1.5.1-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
2460	pyzmq-15.2.0-cp27-none-macosx_10_6_intel.whl
2368	cryptography-1.2.1-cp27-none-macosx_10_6_intel.whl
2325	scipy-0.16.1-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
2157	pandas-0.17.1-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
1975	cffi-1.5.0-cp27-none-win32.whl
1829	mistune-0.7.1-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
1734	gnureadline-6.3.3-cp27-none-macosx_10_6_intel.whl
1734	matplotlib-1.5.1-cp27-none-win32.whl
1616	cryptography-1.2.1-cp27-none-win32.whl
1593	numpy-1.10.4-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
1456	Pillow-3.1.0-cp27-none-win32.whl
1448	scikit_learn-0.17-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
1383	coverage-4.0.3-cp34-none-win32.whl
1170	pandas-0.17.1-cp27-none-win32.whl
1128	matplotlib-1.5.1-cp27-none-win_amd64.whl
982	gnureadline-6.3.3-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
966	gnureadline-6.3.3-cp27-none-macosx_10_5_x86_64.whl
957	Cython-0.23.4-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
954	pypiwin32-219-cp27-none-win_amd64.whl
947	cffi-1.5.0-cp27-none-macosx_10_10_intel.whl
925	pypiwin32-219-cp27-none-win32.whl
921	coverage-4.0.3-cp27-none-win32.whl
898	matplotlib-1.5.1-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
884	xxhash-0.4.1-cp27-none-macosx_10_10_x86_64.whl
862	pyodbc-3.0.10-cp27-none-win_amd64.whl
847	gnureadline-6.3.3-cp27-none-macosx_10_9_x86_64.whl
824	numpy-1.10.4-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
823	gevent-1.0.2-cp27-none-macosx_10_6_intel.whl
754	billiard-3.3.0.22-cp27-none-macosx_10_6_intel.whl
725	cryptography-1.2.1-cp27-none-macosx_10_10_intel.whl
722	Pillow-3.1.0-cp27-none-win_amd64.whl
707	pyzmq-15.2.0-cp35-cp35m-macosx_10_6_intel.whl
675	pyzmq-15.2.0-cp27-none-win32.whl
666	Pillow-3.1.0-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
657	Pillow-3.1.0-cp35-none-win32.whl
656	Twisted-15.5.0-cp27-none-win_amd64.whl
634	pymongo-3.2-cp27-none-macosx_10_8_intel.whl
601	scipy-0.16.1-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
596	matplotlib-1.5.1-cp34-none-win_amd64.whl
594	coverage-4.0.3-cp27-none-macosx_10_10_x86_64.whl
587	matplotlib-1.5.1-cp35-none-win32.whl
565	GraphLab_Create-1.8-cp27-none-win_amd64.whl
564	coverage-4.0.3-cp35-none-win32.whl
562	pymongo-3.2-cp27-none-win_amd64.whl
544	scikit_learn-0.17-cp27-none-win32.whl
543	matplotlib-1.5.1-cp35-none-win_amd64.whl
531	psutil-3.4.1-cp27-none-win32.whl
530	matplotlib-1.5.1-cp34-none-win32.whl
509	Cython-0.23.4-cp27-none-win32.whl
506	Pillow-3.1.0-cp35-none-win_amd64.whl
497	GraphLab_Create-1.8-cp27-none-macosx_10_5_x86_64.macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.macosx_10_11_intel.macosx_10_11_x86_64.whl
459	Pillow-3.1.0-cp34-none-win32.whl
454	pandas-0.17.1-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
450	lxml-3.4.0-cp27-none-win_amd64.whl
448	Pillow-3.0.0-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
448	Pillow-3.1.0-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
439	cffi-1.5.0-cp35-cp35m-macosx_10_6_intel.whl
429	coverage-4.0.3-cp33-none-win32.whl
428	pymongo-3.2-cp27-none-win32.whl
418	coverage-4.0.3-cp34-none-win_amd64.whl
418	psycopg2-2.6.1-cp27-none-win32.whl
413	scipy-0.16.1-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
411	pyzmq-15.2.0-cp34-cp34m-macosx_10_6_intel.whl
410	pandas-0.17.1-cp34-none-win_amd64.whl
402	h5py-2.5.0-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
400	lazy_object_proxy-1.2.1-cp27-none-win32.whl
392	scikit_image-0.11.3-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
383	PySide-1.2.4-cp27-none-win32.whl
379	Cython-0.23.4-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
377	coverage-4.0.3-cp27-none-win_amd64.whl
376	greenlet-0.4.9-cp27-none-win32.whl
365	scikit_learn-0.17-cp27-none-win_amd64.whl
357	mistune-0.7.1-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
350	Pillow-3.1.0-cp34-none-win_amd64.whl
334	Cython-0.23.4-cp27-none-win_amd64.whl
332	psutil-3.4.1-cp27-none-win_amd64.whl
330	psutil-3.4.2-cp27-none-win32.whl
313	gnureadline-6.3.3-cp34-cp34m-macosx_10_6_intel.whl
310	matplotlib-1.5.1-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
307	gnureadline-6.3.3-cp27-none-macosx_10_9_intel.whl
303	psycopg2-2.6.1-cp27-none-win_amd64.whl
293	cffi-1.5.0-cp35-none-win32.whl
289	tornado-4.3-cp35-none-win32.whl
283	cffi-1.5.0-cp34-cp34m-macosx_10_6_intel.whl
282	cffi-1.5.0-cp34-none-win_amd64.whl
280	pypiwin32-219-cp34-none-win_amd64.whl
279	cryptography-1.1.2-cp27-none-macosx_10_6_intel.whl
277	pandas-0.17.1-cp34-none-win32.whl
274	pandas-0.17.1-cp35-none-win32.whl
274	cffi-1.5.0-cp35-none-win_amd64.whl
271	pypiwin32-219-cp34-none-win32.whl
270	Cython-0.23.4-cp35-none-win32.whl
266	cffi-1.5.0-cp34-none-win32.whl
261	kivy.deps.sdl2-0.1.12-cp27-none-win32.whl
260	lxml-3.4.4-cp27-none-win32.whl
257	Kivy-1.9.1-cp27-none-win32.whl
257	PySide-1.2.4-cp27-none-win_amd64.whl
254	pymssql-2.1.1-cp27-none-win32.whl
251	cryptography-1.2.1-cp35-cp35m-macosx_10_6_intel.whl
248	numpy-1.9.2-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
247	gensim-0.12.3-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
247	scikit_learn-0.17-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
245	psutil-3.4.2-cp27-none-win_amd64.whl
241	rasterio-0.31.0-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
241	pandas-0.17.1-cp35-none-win_amd64.whl
238	tornado-4.3-cp35-none-win_amd64.whl
235	mysqlclient-1.3.7-cp27-none-win_amd64.whl
233	Cython-0.23.4-cp35-none-win_amd64.whl
233	lazy_object_proxy-1.2.1-cp27-none-win_amd64.whl
230	Pillow-3.0.0-cp27-none-win32.whl
229	Cython-0.23.4-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
229	reportlab-3.2.0-cp27-none-win32.whl
222	Pillow-2.9.0-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
222	pypiwin32-219-cp35-none-win32.whl
220	pyodbc-3.0.10-cp27-none-win32.whl
219	gmpy2-2.0.7-cp26-none-win32.whl
218	pymssql-2.1.1-cp27-none-win_amd64.whl
218	statsmodels-0.6.1-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
217	mysqlclient-1.3.7-cp27-none-win32.whl
216	msgpack_python-0.4.6-cp27-none-win32.whl
214	greenlet-0.4.9-cp27-none-win_amd64.whl
209	coverage-4.0.3-cp35-cp35m-macosx_10_10_x86_64.whl
209	billiard-3.3.0.22-cp27-none-win32.whl
205	lazy_object_proxy-1.2.1-cp34-none-win32.whl
204	cx_Freeze-4.3.4-cp27-none-win32.whl
203	coverage-4.0.3-cp35-none-win_amd64.whl
197	cryptography-1.2.1-cp35-none-win32.whl
196	pandas-0.17.1-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
196	Pillow-2.7.0-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
195	kivy.deps.glew-0.1.4-cp27-none-win32.whl
190	pypiwin32-219-cp35-none-win_amd64.whl
190	PyAudio-0.2.9-cp27-none-win32.whl
189	kivy.deps.sdl2-0.1.12-cp27-none-win_amd64.whl
179	Cython-0.23.4-cp34-none-win32.whl
177	Shapely-1.5.13-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
176	kivy.deps.sdl2-0.1.12-cp34-none-win_amd64.whl
175	Cython-0.23.4-cp34-none-win_amd64.whl
175	pycryptodome-3.3.1-cp27-none-win32.whl
174	cryptography-1.2.1-cp35-none-win_amd64.whl
174	cryptography-1.2.1-cp34-none-win_amd64.whl
173	coverage-3.7.1-cp27-none-win32.whl
172	kivy.deps.sdl2-0.1.12-cp34-none-win32.whl
170	pymongo-3.2-cp27-none-macosx_10_11_intel.whl
169	Kivy-1.9.1-cp27-none-win_amd64.whl
167	h5py-2.5.0-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
165	cryptography-1.2.1-cp34-none-win32.whl
161	cx_Freeze-4.3.4-cp34-none-win32.whl
159	lazy_object_proxy-1.2.1-cp34-none-win_amd64.whl
159	reportlab-3.2.0-cp27-none-win_amd64.whl
158	cryptography-1.1.2-cp27-none-win32.whl
154	PySide-1.2.4-cp34-none-win32.whl
153	gevent-1.0.2-cp27-none-macosx_10_11_x86_64.whl
151	psutil-2.1.3-cp27-none-win32.whl
150	psutil-3.4.2-cp34-none-win_amd64.whl
149	psutil-3.4.2-cp35-none-win_amd64.whl
149	netifaces-0.10.4-cp27-none-win32.whl
149	gnureadline-6.3.3-cp34-cp34m-macosx_10_9_x86_64.whl
147	psycopg2-2.6.1-cp34-none-win_amd64.whl
145	pymongo-3.2-cp35-cp35m-macosx_10_6_intel.whl
145	psutil-3.4.2-cp34-none-win32.whl
140	Kivy-1.9.1-cp34-none-win32.whl
140	coverage-3.7.1-cp27-none-win_amd64.whl
140	numexpr-2.4.6-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
140	pycosat-0.6.1-cp27-none-win32.whl
139	Kivy-1.9.1-cp34-none-win_amd64.whl
139	cx_Freeze-4.3.4-cp34-none-win_amd64.whl
138	kivy.deps.sdl2-0.1.11-cp27-none-win32.whl
136	psutil-3.4.1-cp34-none-win_amd64.whl
135	kivy.deps.sdl2-0.1.11-cp27-none-win_amd64.whl
134	astropy-1.1.1-cp27-none-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
134	cryptography-1.2.1-cp34-cp34m-macosx_10_6_intel.whl
134	kivy.deps.sdl2_dev-0.1.12-cp27-none-win32.whl
133	kivy.deps.sdl2-0.1.11-cp34-none-win32.whl
130	billiard-3.3.0.22-cp27-none-win_amd64.whl
129	guiqwt-3.0.2-cp27-none-win32.whl
129	kivy.deps.sdl2-0.1.11-cp34-none-win_amd64.whl
128	cffi-1.5.0-cp33-none-win_amd64.whl
127	guiqwt-3.0.2-cp27-none-win_amd64.whl
127	Pillow-3.1.0-cp26-none-win_amd64.whl
127	kivy.deps.glew-0.1.4-cp27-none-win_amd64.whl
126	guiqwt-3.0.2-cp35-none-win_amd64.whl
126	h5py-2.5.0-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
124	ELiDE-0.0.0a5-cp34-none-win_amd64.whl
124	guiqwt-3.0.2-cp34-none-win_amd64.whl
124	psutil-3.4.2-cp33-none-win32.whl
123	p4python-2015.2.1322851-cp27-none-win32.whl
122	coverage-4.0.3-cp34-cp34m-macosx_10_10_x86_64.whl
121	kivy.deps.sdl2_dev-0.1.12-cp34-none-win32.whl
121	pycryptodome-3.3.1-cp27-none-win_amd64.whl
121	psutil-3.4.2-cp35-none-win32.whl
121	scikit_learn-0.17-cp34-none-win_amd64.whl