PREVIEW / stock_5min / 2010-08-20
file: by_date/stock_5min/2010/2010-08-20.parquet size: 4.6 MB rows: 319,067 symbols: 3,464
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-20 06:10:00 | AAPL | Stock | 8.8929 | 8.8929 | 8.8879 | 8.8879 | 5600.0 |
| 2010-08-20 06:15:00 | AAPL | Stock | 8.8814 | 8.8814 | 8.8814 | 8.8814 | 2800.0 |
| 2010-08-20 06:30:00 | AAPL | Stock | 8.8571 | 8.8571 | 8.8571 | 8.8571 | 2800.0 |
| 2010-08-20 07:00:00 | AAPL | Stock | 8.8418 | 8.8418 | 8.8418 | 8.8418 | 2800.0 |
| 2010-08-20 07:10:00 | AAPL | Stock | 8.8696 | 8.8696 | 8.8696 | 8.8696 | 2800.0 |
| 2010-08-20 07:15:00 | AAPL | Stock | 8.87 | 8.87 | 8.87 | 8.87 | 8400.0 |
| 2010-08-20 07:30:00 | AAPL | Stock | 8.8604 | 8.875 | 8.8604 | 8.875 | 14140.0 |
| 2010-08-20 07:35:00 | AAPL | Stock | 8.8768 | 8.8768 | 8.8768 | 8.8768 | 4200.0 |
| 2010-08-20 07:45:00 | AAPL | Stock | 8.8746 | 8.8746 | 8.8746 | 8.8746 | 2940.0 |
| 2010-08-20 07:50:00 | AAPL | Stock | 8.875 | 8.8768 | 8.875 | 8.8768 | 19460.0 |
| 2010-08-20 08:00:00 | AAPL | Stock | 8.8768 | 8.8839 | 8.875 | 8.8757 | 121352.0 |
| 2010-08-20 08:05:00 | AAPL | Stock | 8.8814 | 8.8857 | 8.8804 | 8.8857 | 39844.0 |
| 2010-08-20 08:10:00 | AAPL | Stock | 8.8857 | 8.8875 | 8.8839 | 8.8857 | 85624.0 |
| 2010-08-20 08:15:00 | AAPL | Stock | 8.8843 | 8.8857 | 8.8839 | 8.8857 | 32396.0 |
| 2010-08-20 08:20:00 | AAPL | Stock | 8.8868 | 8.8893 | 8.8804 | 8.8807 | 160692.0 |
| 2010-08-20 08:25:00 | AAPL | Stock | 8.8821 | 8.8821 | 8.8821 | 8.8821 | 2800.0 |
| 2010-08-20 08:30:00 | AAPL | Stock | 8.8789 | 8.8804 | 8.8754 | 8.8754 | 43680.0 |
| 2010-08-20 08:35:00 | AAPL | Stock | 8.8757 | 8.8757 | 8.8725 | 8.8732 | 14000.0 |
| 2010-08-20 08:40:00 | AAPL | Stock | 8.8732 | 8.8746 | 8.8704 | 8.8714 | 32368.0 |
| 2010-08-20 08:45:00 | AAPL | Stock | 8.875 | 8.875 | 8.8707 | 8.8732 | 108752.0 |
| 2010-08-20 08:50:00 | AAPL | Stock | 8.8732 | 8.8886 | 8.8732 | 8.8871 | 129136.0 |
| 2010-08-20 08:55:00 | AAPL | Stock | 8.8857 | 8.9014 | 8.8839 | 8.8839 | 150500.0 |
| 2010-08-20 09:00:00 | AAPL | Stock | 8.8914 | 8.8921 | 8.8839 | 8.8839 | 32200.0 |
| 2010-08-20 09:05:00 | AAPL | Stock | 8.8875 | 8.8946 | 8.8871 | 8.8946 | 138600.0 |
| 2010-08-20 09:10:00 | AAPL | Stock | 8.89 | 8.8929 | 8.8836 | 8.8896 | 168812.0 |
| 2010-08-20 09:15:00 | AAPL | Stock | 8.8886 | 8.8896 | 8.8875 | 8.8875 | 95200.0 |
| 2010-08-20 09:20:00 | AAPL | Stock | 8.8879 | 8.9068 | 8.8879 | 8.8936 | 130760.0 |
| 2010-08-20 09:25:00 | AAPL | Stock | 8.9 | 8.9075 | 8.8932 | 8.9036 | 269360.0 |
| 2010-08-20 09:30:00 | AAPL | Stock | 8.9046 | 8.9536 | 8.8929 | 8.9525 | 15364692.0 |
| 2010-08-20 09:35:00 | AAPL | Stock | 8.9514 | 8.9607 | 8.9361 | 8.9432 | 10141152.0 |
| 2010-08-20 09:40:00 | AAPL | Stock | 8.9439 | 8.9493 | 8.9204 | 8.9286 | 9046016.0 |
| 2010-08-20 09:45:00 | AAPL | Stock | 8.9282 | 8.9304 | 8.9146 | 8.9207 | 8598520.0 |
| 2010-08-20 09:50:00 | AAPL | Stock | 8.9207 | 8.9286 | 8.9107 | 8.9236 | 9670304.0 |
| 2010-08-20 09:55:00 | AAPL | Stock | 8.9243 | 8.9429 | 8.9236 | 8.9404 | 8756160.0 |
| 2010-08-20 10:00:00 | AAPL | Stock | 8.94 | 8.9682 | 8.9393 | 8.9675 | 13495664.0 |
| 2010-08-20 10:05:00 | AAPL | Stock | 8.9668 | 8.9771 | 8.9389 | 8.9414 | 15120420.0 |
| 2010-08-20 10:10:00 | AAPL | Stock | 8.9421 | 8.9468 | 8.9282 | 8.9325 | 7128268.0 |
| 2010-08-20 10:15:00 | AAPL | Stock | 8.9318 | 8.9532 | 8.93 | 8.9479 | 4963784.0 |
| 2010-08-20 10:20:00 | AAPL | Stock | 8.9479 | 8.9504 | 8.9314 | 8.9407 | 4249308.0 |
| 2010-08-20 10:25:00 | AAPL | Stock | 8.9409 | 8.9418 | 8.925 | 8.9279 | 6014316.0 |
| 2010-08-20 10:30:00 | AAPL | Stock | 8.9275 | 8.9359 | 8.9257 | 8.9325 | 3113516.0 |
| 2010-08-20 10:35:00 | AAPL | Stock | 8.9329 | 9.0686 | 8.9243 | 8.9254 | 5726560.0 |
| 2010-08-20 10:40:00 | AAPL | Stock | 8.9246 | 8.94 | 8.9246 | 8.9346 | 3926356.0 |
| 2010-08-20 10:45:00 | AAPL | Stock | 8.9346 | 8.9404 | 8.9282 | 8.9293 | 3832528.0 |
| 2010-08-20 10:50:00 | AAPL | Stock | 8.9286 | 8.9329 | 8.9257 | 8.9268 | 2904804.0 |
| 2010-08-20 10:55:00 | AAPL | Stock | 8.9257 | 8.9371 | 8.9257 | 8.9332 | 2826376.0 |
| 2010-08-20 11:00:00 | AAPL | Stock | 8.9321 | 8.9329 | 8.9261 | 8.9286 | 2254308.0 |
| 2010-08-20 11:05:00 | AAPL | Stock | 8.9286 | 8.9404 | 8.9257 | 8.9386 | 4347196.0 |
| 2010-08-20 11:10:00 | AAPL | Stock | 8.9386 | 8.9386 | 8.9275 | 8.9309 | 2158464.0 |
| 2010-08-20 11:15:00 | AAPL | Stock | 8.93 | 8.9325 | 8.9254 | 8.9289 | 1857688.0 |
> showing 50 of 319,067 rows — these rows as CSV