PREVIEW / stock_5min / 2010-12-30
file: by_date/stock_5min/2010/2010-12-30.parquet size: 4.6 MB rows: 319,300 symbols: 3,532
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-12-30 04:00:00 | AAPL | Stock | 11.6286 | 11.6286 | 11.6286 | 11.6286 | 2800.0 |
| 2010-12-30 04:15:00 | AAPL | Stock | 11.6425 | 11.6425 | 11.6425 | 11.6425 | 2800.0 |
| 2010-12-30 04:30:00 | AAPL | Stock | 11.6425 | 11.6425 | 11.6425 | 11.6425 | 5600.0 |
| 2010-12-30 05:10:00 | AAPL | Stock | 11.6239 | 11.6239 | 11.6239 | 11.6239 | 2800.0 |
| 2010-12-30 06:25:00 | AAPL | Stock | 11.6239 | 11.6239 | 11.6239 | 11.6239 | 8400.0 |
| 2010-12-30 06:40:00 | AAPL | Stock | 11.6239 | 11.6239 | 11.6239 | 11.6239 | 2800.0 |
| 2010-12-30 06:45:00 | AAPL | Stock | 11.6136 | 11.6136 | 11.6136 | 11.6136 | 2800.0 |
| 2010-12-30 07:15:00 | AAPL | Stock | 11.6139 | 11.6139 | 11.6139 | 11.6139 | 5600.0 |
| 2010-12-30 07:20:00 | AAPL | Stock | 11.6139 | 11.6139 | 11.6139 | 11.6139 | 5600.0 |
| 2010-12-30 07:45:00 | AAPL | Stock | 11.6175 | 11.6175 | 11.6175 | 11.6175 | 5600.0 |
| 2010-12-30 07:50:00 | AAPL | Stock | 11.6075 | 11.6075 | 11.6075 | 11.6075 | 5600.0 |
| 2010-12-30 08:00:00 | AAPL | Stock | 11.6114 | 11.6207 | 11.6107 | 11.6207 | 71932.0 |
| 2010-12-30 08:05:00 | AAPL | Stock | 11.6207 | 11.6279 | 11.6207 | 11.6268 | 182000.0 |
| 2010-12-30 08:10:00 | AAPL | Stock | 11.6286 | 11.6311 | 11.6204 | 11.6239 | 278684.0 |
| 2010-12-30 08:15:00 | AAPL | Stock | 11.625 | 11.6296 | 11.625 | 11.6268 | 105252.0 |
| 2010-12-30 08:20:00 | AAPL | Stock | 11.6225 | 11.6225 | 11.6211 | 11.6211 | 82040.0 |
| 2010-12-30 08:25:00 | AAPL | Stock | 11.6214 | 11.6214 | 11.6211 | 11.6211 | 30800.0 |
| 2010-12-30 08:30:00 | AAPL | Stock | 11.6214 | 11.6318 | 11.6214 | 11.6296 | 127988.0 |
| 2010-12-30 08:35:00 | AAPL | Stock | 11.6286 | 11.6286 | 11.6221 | 11.6221 | 91392.0 |
| 2010-12-30 08:40:00 | AAPL | Stock | 11.6236 | 11.6236 | 11.6232 | 11.6232 | 16800.0 |
| 2010-12-30 08:45:00 | AAPL | Stock | 11.6225 | 11.6282 | 11.6221 | 11.6221 | 98112.0 |
| 2010-12-30 08:50:00 | AAPL | Stock | 11.6243 | 11.6243 | 11.6239 | 11.6239 | 5600.0 |
| 2010-12-30 08:55:00 | AAPL | Stock | 11.6257 | 11.6257 | 11.625 | 11.625 | 11200.0 |
| 2010-12-30 09:00:00 | AAPL | Stock | 11.6246 | 11.6246 | 11.6246 | 11.6246 | 5600.0 |
| 2010-12-30 09:05:00 | AAPL | Stock | 11.625 | 11.6257 | 11.625 | 11.6257 | 47600.0 |
| 2010-12-30 09:15:00 | AAPL | Stock | 11.6243 | 11.6243 | 11.6218 | 11.6221 | 39200.0 |
| 2010-12-30 09:25:00 | AAPL | Stock | 11.6214 | 11.6318 | 11.6214 | 11.6214 | 180152.0 |
| 2010-12-30 09:30:00 | AAPL | Stock | 11.6207 | 11.6254 | 11.5906 | 11.5993 | 5700128.0 |
| 2010-12-30 09:35:00 | AAPL | Stock | 11.5996 | 11.6029 | 11.5943 | 11.6 | 3143112.0 |
| 2010-12-30 09:40:00 | AAPL | Stock | 11.6011 | 11.6107 | 11.5911 | 11.6067 | 4135544.0 |
| 2010-12-30 09:45:00 | AAPL | Stock | 11.6064 | 11.6086 | 11.5979 | 11.605 | 2650844.0 |
| 2010-12-30 09:50:00 | AAPL | Stock | 11.605 | 11.6057 | 11.5936 | 11.595 | 1739052.0 |
| 2010-12-30 09:55:00 | AAPL | Stock | 11.5954 | 11.5961 | 11.5757 | 11.5796 | 4633608.0 |
| 2010-12-30 10:00:00 | AAPL | Stock | 11.5779 | 11.5821 | 11.554 | 11.5693 | 8904168.0 |
| 2010-12-30 10:05:00 | AAPL | Stock | 11.5689 | 11.5768 | 11.5614 | 11.5718 | 3941504.0 |
| 2010-12-30 10:10:00 | AAPL | Stock | 11.5739 | 11.5814 | 11.5643 | 11.5679 | 5924968.0 |
| 2010-12-30 10:15:00 | AAPL | Stock | 11.5671 | 11.575 | 11.5643 | 11.5693 | 2160816.0 |
| 2010-12-30 10:20:00 | AAPL | Stock | 11.5696 | 11.5715 | 11.5646 | 11.5674 | 2996364.0 |
| 2010-12-30 10:25:00 | AAPL | Stock | 11.5689 | 11.5804 | 11.5689 | 11.5782 | 2189488.0 |
| 2010-12-30 10:30:00 | AAPL | Stock | 11.5779 | 11.5821 | 11.5724 | 11.5743 | 2040136.0 |
| 2010-12-30 10:35:00 | AAPL | Stock | 11.5743 | 11.5783 | 11.5729 | 11.5775 | 1033984.0 |
| 2010-12-30 10:40:00 | AAPL | Stock | 11.5774 | 11.5789 | 11.5736 | 11.5754 | 2052148.0 |
| 2010-12-30 10:45:00 | AAPL | Stock | 11.575 | 11.5771 | 11.5729 | 11.5748 | 2034956.0 |
| 2010-12-30 10:50:00 | AAPL | Stock | 11.575 | 11.5754 | 11.5714 | 11.5734 | 1165108.0 |
| 2010-12-30 10:55:00 | AAPL | Stock | 11.5739 | 11.5746 | 11.5686 | 11.5696 | 1343328.0 |
| 2010-12-30 11:00:00 | AAPL | Stock | 11.5696 | 11.5739 | 11.5686 | 11.5707 | 1132488.0 |
| 2010-12-30 11:05:00 | AAPL | Stock | 11.5696 | 11.5714 | 11.5661 | 11.5674 | 1306648.0 |
| 2010-12-30 11:10:00 | AAPL | Stock | 11.5678 | 11.5679 | 11.5607 | 11.5671 | 2146648.0 |
| 2010-12-30 11:15:00 | AAPL | Stock | 11.5664 | 11.5671 | 11.5618 | 11.5654 | 980532.0 |
| 2010-12-30 11:20:00 | AAPL | Stock | 11.565 | 11.5671 | 11.5593 | 11.5614 | 1486968.0 |
> showing 50 of 319,300 rows — these rows as CSV