PREVIEW / stock_5min / 2009-10-01
file: by_date/stock_5min/2009/2009-10-01.parquet size: 4.9 MB rows: 331,408 symbols: 3,379
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-01 07:20:00 | AAPL | Stock | 6.59 | 6.59 | 6.59 | 6.59 | 6860.0 |
| 2009-10-01 07:25:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5982 | 6.5982 | 2800.0 |
| 2009-10-01 07:45:00 | AAPL | Stock | 6.6004 | 6.6043 | 6.6 | 6.6043 | 19600.0 |
| 2009-10-01 07:50:00 | AAPL | Stock | 6.6025 | 6.6029 | 6.6025 | 6.6029 | 26040.0 |
| 2009-10-01 07:55:00 | AAPL | Stock | 6.6025 | 6.6025 | 6.6025 | 6.6025 | 5600.0 |
| 2009-10-01 08:00:00 | AAPL | Stock | 6.6204 | 6.6204 | 6.6039 | 6.6071 | 90300.0 |
| 2009-10-01 08:05:00 | AAPL | Stock | 6.6075 | 6.6143 | 6.6075 | 6.6107 | 14000.0 |
| 2009-10-01 08:10:00 | AAPL | Stock | 6.6143 | 6.6143 | 6.6143 | 6.6143 | 4340.0 |
| 2009-10-01 08:15:00 | AAPL | Stock | 6.6082 | 6.6082 | 6.6057 | 6.6057 | 92540.0 |
| 2009-10-01 08:20:00 | AAPL | Stock | 6.6057 | 6.6129 | 6.605 | 6.6129 | 64960.0 |
| 2009-10-01 08:25:00 | AAPL | Stock | 6.6139 | 6.6429 | 6.6129 | 6.6386 | 294700.0 |
| 2009-10-01 08:30:00 | AAPL | Stock | 6.6339 | 6.6382 | 6.6036 | 6.6036 | 386876.0 |
| 2009-10-01 08:35:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.5982 | 6.6 | 297024.0 |
| 2009-10-01 08:40:00 | AAPL | Stock | 6.6043 | 6.6071 | 6.6007 | 6.6071 | 163996.0 |
| 2009-10-01 08:45:00 | AAPL | Stock | 6.6111 | 6.6136 | 6.6071 | 6.6121 | 145600.0 |
| 2009-10-01 08:50:00 | AAPL | Stock | 6.6118 | 6.6125 | 6.6089 | 6.61 | 54600.0 |
| 2009-10-01 08:55:00 | AAPL | Stock | 6.6114 | 6.6114 | 6.6071 | 6.6107 | 96516.0 |
| 2009-10-01 09:00:00 | AAPL | Stock | 6.6118 | 6.6143 | 6.6107 | 6.6129 | 58212.0 |
| 2009-10-01 09:05:00 | AAPL | Stock | 6.6196 | 6.6196 | 6.6104 | 6.6143 | 140980.0 |
| 2009-10-01 09:10:00 | AAPL | Stock | 6.615 | 6.6314 | 6.6143 | 6.6275 | 121324.0 |
| 2009-10-01 09:15:00 | AAPL | Stock | 6.6225 | 6.6275 | 6.6175 | 6.6239 | 219828.0 |
| 2009-10-01 09:20:00 | AAPL | Stock | 6.62 | 6.62 | 6.6164 | 6.62 | 49280.0 |
| 2009-10-01 09:25:00 | AAPL | Stock | 6.6164 | 6.6264 | 6.6139 | 6.6239 | 212072.0 |
| 2009-10-01 09:30:00 | AAPL | Stock | 6.6196 | 6.6386 | 6.6 | 6.6293 | 16357404.0 |
| 2009-10-01 09:35:00 | AAPL | Stock | 6.6296 | 6.6404 | 6.6036 | 6.6256 | 14020160.0 |
| 2009-10-01 09:40:00 | AAPL | Stock | 6.6239 | 6.6375 | 6.6161 | 6.6311 | 8928864.0 |
| 2009-10-01 09:45:00 | AAPL | Stock | 6.6314 | 6.6504 | 6.6254 | 6.6482 | 10117660.0 |
| 2009-10-01 09:50:00 | AAPL | Stock | 6.6482 | 6.6507 | 6.6329 | 6.6404 | 9382940.0 |
| 2009-10-01 09:55:00 | AAPL | Stock | 6.6407 | 6.6432 | 6.6186 | 6.63 | 6158432.0 |
| 2009-10-01 10:00:00 | AAPL | Stock | 6.6275 | 6.6493 | 6.5893 | 6.6139 | 16493036.0 |
| 2009-10-01 10:05:00 | AAPL | Stock | 6.6139 | 6.6214 | 6.5639 | 6.5757 | 19487832.0 |
| 2009-10-01 10:10:00 | AAPL | Stock | 6.5754 | 6.5957 | 6.5743 | 6.58 | 10263764.0 |
| 2009-10-01 10:15:00 | AAPL | Stock | 6.5804 | 6.5818 | 6.5682 | 6.579 | 8333752.0 |
| 2009-10-01 10:20:00 | AAPL | Stock | 6.5793 | 6.5921 | 6.5789 | 6.5889 | 7239456.0 |
| 2009-10-01 10:25:00 | AAPL | Stock | 6.5896 | 6.59 | 6.5789 | 6.5832 | 5438860.0 |
| 2009-10-01 10:30:00 | AAPL | Stock | 6.5832 | 6.5879 | 6.5789 | 6.5821 | 8556772.0 |
| 2009-10-01 10:35:00 | AAPL | Stock | 6.5829 | 6.5964 | 6.5829 | 6.5832 | 6427596.0 |
| 2009-10-01 10:40:00 | AAPL | Stock | 6.5843 | 6.5879 | 6.5729 | 6.5766 | 4804660.0 |
| 2009-10-01 10:45:00 | AAPL | Stock | 6.5766 | 6.5796 | 6.5625 | 6.5639 | 7186256.0 |
| 2009-10-01 10:50:00 | AAPL | Stock | 6.5632 | 6.5732 | 6.5536 | 6.5686 | 7233016.0 |
| 2009-10-01 10:55:00 | AAPL | Stock | 6.5689 | 6.5749 | 6.5557 | 6.5614 | 4825604.0 |
| 2009-10-01 11:00:00 | AAPL | Stock | 6.5611 | 6.5643 | 6.5379 | 6.5461 | 9895452.0 |
| 2009-10-01 11:05:00 | AAPL | Stock | 6.5454 | 6.5489 | 6.5246 | 6.5268 | 9427992.0 |
| 2009-10-01 11:10:00 | AAPL | Stock | 6.5271 | 6.5379 | 6.5218 | 6.5314 | 6586160.0 |
| 2009-10-01 11:15:00 | AAPL | Stock | 6.5321 | 6.5404 | 6.5282 | 6.5318 | 5332628.0 |
| 2009-10-01 11:20:00 | AAPL | Stock | 6.5321 | 6.5443 | 6.5286 | 6.5364 | 4438112.0 |
| 2009-10-01 11:25:00 | AAPL | Stock | 6.5357 | 6.5414 | 6.525 | 6.5336 | 6914236.0 |
| 2009-10-01 11:30:00 | AAPL | Stock | 6.5321 | 6.5364 | 6.5196 | 6.5211 | 5005168.0 |
| 2009-10-01 11:35:00 | AAPL | Stock | 6.521 | 6.5243 | 6.5121 | 6.5196 | 5729584.0 |
| 2009-10-01 11:40:00 | AAPL | Stock | 6.5196 | 6.5354 | 6.5179 | 6.5268 | 4847472.0 |
> showing 50 of 331,408 rows — these rows as CSV