Skip to content

Instantly share code, notes, and snippets.

@dstufft
Last active Jan 21, 2016
Embed
What would you like to do?
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
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment