PREVIEW / stock_1min / 2011-11-16
file: by_date/stock_1min/2011/2011-11-16.parquet size: 13.1 MB rows: 971,915 symbols: 2,853
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2011-11-16 04:25:00 | AAPL | Stock | 13.9057 | 13.9057 | 13.9057 | 13.9057 | 2800.0 |
| 2011-11-16 04:27:00 | AAPL | Stock | 13.9057 | 13.9061 | 13.9057 | 13.9057 | 39200.0 |
| 2011-11-16 04:37:00 | AAPL | Stock | 13.9214 | 13.9271 | 13.9214 | 13.9271 | 5600.0 |
| 2011-11-16 04:48:00 | AAPL | Stock | 13.9261 | 13.9261 | 13.9261 | 13.9261 | 5600.0 |
| 2011-11-16 04:53:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 2800.0 |
| 2011-11-16 04:55:00 | AAPL | Stock | 13.9304 | 13.9304 | 13.9304 | 13.9304 | 2800.0 |
| 2011-11-16 05:17:00 | AAPL | Stock | 13.9304 | 13.9304 | 13.9304 | 13.9304 | 5600.0 |
| 2011-11-16 05:32:00 | AAPL | Stock | 13.9304 | 13.9304 | 13.9304 | 13.9304 | 8400.0 |
| 2011-11-16 05:33:00 | AAPL | Stock | 13.9304 | 13.9304 | 13.9286 | 13.9286 | 12600.0 |
| 2011-11-16 05:34:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 8400.0 |
| 2011-11-16 05:36:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.925 | 13.925 | 16240.0 |
| 2011-11-16 05:39:00 | AAPL | Stock | 13.925 | 13.925 | 13.925 | 13.925 | 8400.0 |
| 2011-11-16 05:41:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 2800.0 |
| 2011-11-16 05:46:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 5600.0 |
| 2011-11-16 05:48:00 | AAPL | Stock | 13.8875 | 13.8875 | 13.8875 | 13.8875 | 5600.0 |
| 2011-11-16 05:56:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 11200.0 |
| 2011-11-16 06:01:00 | AAPL | Stock | 13.875 | 13.875 | 13.875 | 13.875 | 14000.0 |
| 2011-11-16 06:03:00 | AAPL | Stock | 13.8704 | 13.8704 | 13.8704 | 13.8704 | 2800.0 |
| 2011-11-16 06:07:00 | AAPL | Stock | 13.87 | 13.87 | 13.87 | 13.87 | 3332.0 |
| 2011-11-16 06:08:00 | AAPL | Stock | 13.87 | 13.87 | 13.87 | 13.87 | 2800.0 |
| 2011-11-16 06:11:00 | AAPL | Stock | 13.8625 | 13.8625 | 13.8625 | 13.8625 | 2800.0 |
| 2011-11-16 06:30:00 | AAPL | Stock | 13.8875 | 13.8929 | 13.885 | 13.885 | 16240.0 |
| 2011-11-16 06:59:00 | AAPL | Stock | 13.8571 | 13.8571 | 13.8571 | 13.8571 | 2800.0 |
| 2011-11-16 07:00:00 | AAPL | Stock | 13.8393 | 13.8393 | 13.8357 | 13.8357 | 12040.0 |
| 2011-11-16 07:02:00 | AAPL | Stock | 13.8393 | 13.8457 | 13.8393 | 13.8457 | 8400.0 |
| 2011-11-16 07:04:00 | AAPL | Stock | 13.8482 | 13.8482 | 13.8482 | 13.8482 | 5600.0 |
| 2011-11-16 07:05:00 | AAPL | Stock | 13.8396 | 13.8396 | 13.8332 | 13.8332 | 28000.0 |
| 2011-11-16 07:06:00 | AAPL | Stock | 13.8364 | 13.8364 | 13.8364 | 13.8364 | 2800.0 |
| 2011-11-16 07:07:00 | AAPL | Stock | 13.8368 | 13.8393 | 13.8368 | 13.8393 | 5600.0 |
| 2011-11-16 07:09:00 | AAPL | Stock | 13.8482 | 13.8482 | 13.8482 | 13.8482 | 11200.0 |
| 2011-11-16 07:13:00 | AAPL | Stock | 13.8643 | 13.8643 | 13.8643 | 13.8643 | 8400.0 |
| 2011-11-16 07:16:00 | AAPL | Stock | 13.8836 | 13.8836 | 13.8836 | 13.8836 | 2800.0 |
| 2011-11-16 07:17:00 | AAPL | Stock | 13.8832 | 13.8832 | 13.8832 | 13.8832 | 5600.0 |
| 2011-11-16 07:19:00 | AAPL | Stock | 13.8686 | 13.8686 | 13.8686 | 13.8686 | 10500.0 |
| 2011-11-16 07:21:00 | AAPL | Stock | 13.8643 | 13.8643 | 13.8643 | 13.8643 | 5600.0 |
| 2011-11-16 07:22:00 | AAPL | Stock | 13.8711 | 13.8796 | 13.8711 | 13.8796 | 5600.0 |
| 2011-11-16 07:24:00 | AAPL | Stock | 13.8836 | 13.8843 | 13.8836 | 13.8843 | 5600.0 |
| 2011-11-16 07:25:00 | AAPL | Stock | 13.8868 | 13.9271 | 13.8868 | 13.9236 | 16800.0 |
| 2011-11-16 07:28:00 | AAPL | Stock | 13.8768 | 13.8843 | 13.8743 | 13.8743 | 14000.0 |
| 2011-11-16 07:35:00 | AAPL | Stock | 13.8861 | 13.8861 | 13.8861 | 13.8861 | 2800.0 |
| 2011-11-16 07:37:00 | AAPL | Stock | 13.8857 | 13.91 | 13.8857 | 13.8929 | 38360.0 |
| 2011-11-16 07:38:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 2800.0 |
| 2011-11-16 07:40:00 | AAPL | Stock | 13.8839 | 13.8839 | 13.8839 | 13.8839 | 7840.0 |
| 2011-11-16 07:42:00 | AAPL | Stock | 13.8982 | 13.8982 | 13.8982 | 13.8982 | 2800.0 |
| 2011-11-16 07:44:00 | AAPL | Stock | 13.8804 | 13.8811 | 13.8786 | 13.8786 | 11200.0 |
| 2011-11-16 07:48:00 | AAPL | Stock | 13.8771 | 13.8771 | 13.875 | 13.875 | 23800.0 |
| 2011-11-16 07:50:00 | AAPL | Stock | 13.8771 | 13.8771 | 13.8771 | 13.8771 | 5600.0 |
| 2011-11-16 07:55:00 | AAPL | Stock | 13.8711 | 13.8725 | 13.8443 | 13.8661 | 33600.0 |
| 2011-11-16 07:57:00 | AAPL | Stock | 13.8593 | 13.8593 | 13.8589 | 13.8589 | 5600.0 |
| 2011-11-16 07:58:00 | AAPL | Stock | 13.8586 | 13.8586 | 13.8586 | 13.8586 | 2800.0 |
> showing 50 of 971,915 rows — these rows as CSV