PREVIEW / stock_5min / 2011-11-16
file: by_date/stock_5min/2011/2011-11-16.parquet size: 4.8 MB rows: 322,993 symbols: 3,526
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.9061 | 13.9057 | 13.9057 | 42000.0 |
| 2011-11-16 04:35:00 | AAPL | Stock | 13.9214 | 13.9271 | 13.9214 | 13.9271 | 5600.0 |
| 2011-11-16 04:45:00 | AAPL | Stock | 13.9261 | 13.9261 | 13.9261 | 13.9261 | 5600.0 |
| 2011-11-16 04:50: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:15:00 | AAPL | Stock | 13.9304 | 13.9304 | 13.9304 | 13.9304 | 5600.0 |
| 2011-11-16 05:30:00 | AAPL | Stock | 13.9304 | 13.9304 | 13.9286 | 13.9286 | 29400.0 |
| 2011-11-16 05:35:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.925 | 13.925 | 24640.0 |
| 2011-11-16 05:40:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 2800.0 |
| 2011-11-16 05:45:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8875 | 13.8875 | 11200.0 |
| 2011-11-16 05:55:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 11200.0 |
| 2011-11-16 06:00:00 | AAPL | Stock | 13.875 | 13.875 | 13.8704 | 13.8704 | 16800.0 |
| 2011-11-16 06:05:00 | AAPL | Stock | 13.87 | 13.87 | 13.87 | 13.87 | 6132.0 |
| 2011-11-16 06:10: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:55:00 | AAPL | Stock | 13.8571 | 13.8571 | 13.8571 | 13.8571 | 2800.0 |
| 2011-11-16 07:00:00 | AAPL | Stock | 13.8393 | 13.8482 | 13.8357 | 13.8482 | 26040.0 |
| 2011-11-16 07:05:00 | AAPL | Stock | 13.8396 | 13.8482 | 13.8332 | 13.8482 | 47600.0 |
| 2011-11-16 07:10:00 | AAPL | Stock | 13.8643 | 13.8643 | 13.8643 | 13.8643 | 8400.0 |
| 2011-11-16 07:15:00 | AAPL | Stock | 13.8836 | 13.8836 | 13.8686 | 13.8686 | 18900.0 |
| 2011-11-16 07:20:00 | AAPL | Stock | 13.8643 | 13.8843 | 13.8643 | 13.8843 | 16800.0 |
| 2011-11-16 07:25:00 | AAPL | Stock | 13.8868 | 13.9271 | 13.8743 | 13.8743 | 30800.0 |
| 2011-11-16 07:35:00 | AAPL | Stock | 13.8861 | 13.91 | 13.8857 | 13.8929 | 43960.0 |
| 2011-11-16 07:40:00 | AAPL | Stock | 13.8839 | 13.8982 | 13.8786 | 13.8786 | 21840.0 |
| 2011-11-16 07:45: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.8575 | 48076.0 |
| 2011-11-16 08:00:00 | AAPL | Stock | 13.8571 | 13.8571 | 13.8382 | 13.8539 | 115080.0 |
| 2011-11-16 08:05:00 | AAPL | Stock | 13.8446 | 13.8679 | 13.8339 | 13.8411 | 113932.0 |
| 2011-11-16 08:10:00 | AAPL | Stock | 13.8393 | 13.8529 | 13.8343 | 13.8529 | 50400.0 |
| 2011-11-16 08:15:00 | AAPL | Stock | 13.8525 | 13.8571 | 13.8482 | 13.8571 | 82544.0 |
| 2011-11-16 08:20:00 | AAPL | Stock | 13.8596 | 13.8661 | 13.8596 | 13.8643 | 28280.0 |
| 2011-11-16 08:25:00 | AAPL | Stock | 13.8593 | 13.8593 | 13.8571 | 13.8571 | 39200.0 |
| 2011-11-16 08:30:00 | AAPL | Stock | 13.8482 | 13.8482 | 13.8332 | 13.8339 | 73136.0 |
| 2011-11-16 08:35:00 | AAPL | Stock | 13.8339 | 13.8389 | 13.8225 | 13.8389 | 122724.0 |
| 2011-11-16 08:40:00 | AAPL | Stock | 13.8393 | 13.8393 | 13.8243 | 13.8321 | 75852.0 |
| 2011-11-16 08:45:00 | AAPL | Stock | 13.8264 | 13.8321 | 13.8143 | 13.8218 | 156604.0 |
| 2011-11-16 08:50:00 | AAPL | Stock | 13.8218 | 13.8286 | 13.8179 | 13.8179 | 128912.0 |
| 2011-11-16 08:55:00 | AAPL | Stock | 13.8236 | 13.8296 | 13.8221 | 13.8243 | 65800.0 |
| 2011-11-16 09:00:00 | AAPL | Stock | 13.8232 | 13.8318 | 13.8232 | 13.8314 | 11200.0 |
| 2011-11-16 09:05:00 | AAPL | Stock | 13.83 | 13.8439 | 13.8254 | 13.8393 | 188384.0 |
| 2011-11-16 09:10:00 | AAPL | Stock | 13.8393 | 13.8554 | 13.8393 | 13.85 | 105672.0 |
| 2011-11-16 09:15:00 | AAPL | Stock | 13.8518 | 13.8857 | 13.8518 | 13.88 | 338492.0 |
| 2011-11-16 09:20:00 | AAPL | Stock | 13.8804 | 13.8804 | 13.8682 | 13.8693 | 260624.0 |
| 2011-11-16 09:25:00 | AAPL | Stock | 13.875 | 13.9107 | 13.875 | 13.9021 | 806540.0 |
| 2011-11-16 09:30:00 | AAPL | Stock | 13.9041 | 13.9286 | 13.8604 | 13.8682 | 19432252.0 |
| 2011-11-16 09:35:00 | AAPL | Stock | 13.8718 | 13.9693 | 13.8682 | 13.9384 | 15549968.0 |
| 2011-11-16 09:40:00 | AAPL | Stock | 13.9414 | 13.9475 | 13.9136 | 13.9382 | 8153572.0 |
| 2011-11-16 09:45:00 | AAPL | Stock | 13.9382 | 13.9457 | 13.8793 | 13.8907 | 9276456.0 |
| 2011-11-16 09:50:00 | AAPL | Stock | 13.8901 | 13.9336 | 13.8879 | 13.9321 | 7835548.0 |
> showing 50 of 322,993 rows — these rows as CSV