PREVIEW / stock_5min / 2008-08-01
file: by_date/stock_5min/2008/2008-08-01.parquet size: 4.3 MB rows: 308,965 symbols: 3,300
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-01 06:50:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6786 | 5.6786 | 5600.0 |
| 2008-08-01 08:05:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6782 | 5.6782 | 10276.0 |
| 2008-08-01 08:10:00 | AAPL | Stock | 5.6632 | 5.6786 | 5.6632 | 5.6768 | 655200.0 |
| 2008-08-01 08:15:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6779 | 5.6786 | 35280.0 |
| 2008-08-01 08:20:00 | AAPL | Stock | 5.6782 | 5.6786 | 5.6686 | 5.6786 | 150780.0 |
| 2008-08-01 08:25:00 | AAPL | Stock | 5.6746 | 5.6786 | 5.6632 | 5.6718 | 129696.0 |
| 2008-08-01 08:30:00 | AAPL | Stock | 5.6779 | 5.7421 | 5.6779 | 5.7357 | 2580984.0 |
| 2008-08-01 08:35:00 | AAPL | Stock | 5.7325 | 5.735 | 5.7143 | 5.7211 | 649320.0 |
| 2008-08-01 08:40:00 | AAPL | Stock | 5.7193 | 5.7268 | 5.7125 | 5.7125 | 293300.0 |
| 2008-08-01 08:45:00 | AAPL | Stock | 5.7096 | 5.7261 | 5.7089 | 5.7143 | 266000.0 |
| 2008-08-01 08:50:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.6768 | 5.7125 | 264432.0 |
| 2008-08-01 08:55:00 | AAPL | Stock | 5.7107 | 5.7107 | 5.7086 | 5.7086 | 33600.0 |
| 2008-08-01 09:00:00 | AAPL | Stock | 5.7104 | 5.7214 | 5.7104 | 5.7214 | 154112.0 |
| 2008-08-01 09:05:00 | AAPL | Stock | 5.7211 | 5.7232 | 5.71 | 5.71 | 147924.0 |
| 2008-08-01 09:10:00 | AAPL | Stock | 5.7211 | 5.7211 | 5.7129 | 5.7179 | 60480.0 |
| 2008-08-01 09:15:00 | AAPL | Stock | 5.7179 | 5.7179 | 5.7114 | 5.7114 | 92260.0 |
| 2008-08-01 09:20:00 | AAPL | Stock | 5.7164 | 5.7196 | 5.7114 | 5.7179 | 113400.0 |
| 2008-08-01 09:25:00 | AAPL | Stock | 5.7246 | 5.7246 | 5.7107 | 5.7107 | 65800.0 |
| 2008-08-01 09:30:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.6596 | 5.6696 | 13944000.0 |
| 2008-08-01 09:35:00 | AAPL | Stock | 5.6686 | 5.6868 | 5.6354 | 5.6375 | 16214128.0 |
| 2008-08-01 09:40:00 | AAPL | Stock | 5.6361 | 5.655 | 5.6179 | 5.6464 | 15447152.0 |
| 2008-08-01 09:45:00 | AAPL | Stock | 5.6461 | 5.6482 | 5.6136 | 5.6205 | 13351604.0 |
| 2008-08-01 09:50:00 | AAPL | Stock | 5.6229 | 5.6361 | 5.5625 | 5.5875 | 24849636.0 |
| 2008-08-01 09:55:00 | AAPL | Stock | 5.5893 | 5.6011 | 5.58 | 5.6011 | 11776380.0 |
| 2008-08-01 10:00:00 | AAPL | Stock | 5.6011 | 5.6243 | 5.5968 | 5.6086 | 14080080.0 |
| 2008-08-01 10:05:00 | AAPL | Stock | 5.6086 | 5.6086 | 5.5682 | 5.5971 | 13213872.0 |
| 2008-08-01 10:10:00 | AAPL | Stock | 5.5975 | 5.6093 | 5.5893 | 5.5936 | 8986628.0 |
| 2008-08-01 10:15:00 | AAPL | Stock | 5.5937 | 5.6179 | 5.59 | 5.6082 | 9863588.0 |
| 2008-08-01 10:20:00 | AAPL | Stock | 5.6071 | 5.6154 | 5.5793 | 5.58 | 10280368.0 |
| 2008-08-01 10:25:00 | AAPL | Stock | 5.5796 | 5.6054 | 5.5775 | 5.5921 | 7119056.0 |
| 2008-08-01 10:30:00 | AAPL | Stock | 5.5929 | 5.6114 | 5.5896 | 5.6114 | 6986224.0 |
| 2008-08-01 10:35:00 | AAPL | Stock | 5.6114 | 5.6336 | 5.6096 | 5.6268 | 9687748.0 |
| 2008-08-01 10:40:00 | AAPL | Stock | 5.6259 | 5.6286 | 5.6093 | 5.6107 | 6326152.0 |
| 2008-08-01 10:45:00 | AAPL | Stock | 5.6104 | 5.6271 | 5.6043 | 5.6264 | 5964644.0 |
| 2008-08-01 10:50:00 | AAPL | Stock | 5.6257 | 5.6264 | 5.6025 | 5.6118 | 6206116.0 |
| 2008-08-01 10:55:00 | AAPL | Stock | 5.6125 | 5.6161 | 5.5914 | 5.6054 | 5069568.0 |
| 2008-08-01 11:00:00 | AAPL | Stock | 5.6054 | 5.6104 | 5.5796 | 5.5825 | 5471480.0 |
| 2008-08-01 11:05:00 | AAPL | Stock | 5.5821 | 5.5907 | 5.575 | 5.5814 | 5642924.0 |
| 2008-08-01 11:10:00 | AAPL | Stock | 5.5814 | 5.6009 | 5.5729 | 5.6009 | 6460272.0 |
| 2008-08-01 11:15:00 | AAPL | Stock | 5.6011 | 5.6132 | 5.5907 | 5.6129 | 6538812.0 |
| 2008-08-01 11:20:00 | AAPL | Stock | 5.6111 | 5.6121 | 5.5914 | 5.5982 | 4012708.0 |
| 2008-08-01 11:25:00 | AAPL | Stock | 5.5979 | 5.6237 | 5.5975 | 5.6104 | 4626384.0 |
| 2008-08-01 11:30:00 | AAPL | Stock | 5.6104 | 5.635 | 5.61 | 5.6343 | 8344728.0 |
| 2008-08-01 11:35:00 | AAPL | Stock | 5.6339 | 5.6464 | 5.6239 | 5.6404 | 8411004.0 |
| 2008-08-01 11:40:00 | AAPL | Stock | 5.64 | 5.6421 | 5.6314 | 5.6394 | 5581828.0 |
| 2008-08-01 11:45:00 | AAPL | Stock | 5.6382 | 5.6411 | 5.6239 | 5.6263 | 3448368.0 |
| 2008-08-01 11:50:00 | AAPL | Stock | 5.6271 | 5.6357 | 5.6243 | 5.6325 | 3205972.0 |
| 2008-08-01 11:55:00 | AAPL | Stock | 5.6325 | 5.6482 | 5.6314 | 5.6414 | 5256944.0 |
| 2008-08-01 12:00:00 | AAPL | Stock | 5.6393 | 5.6421 | 5.6107 | 5.6154 | 6998628.0 |
| 2008-08-01 12:05:00 | AAPL | Stock | 5.6154 | 5.6239 | 5.6118 | 5.6164 | 3525424.0 |
> showing 50 of 308,965 rows — these rows as CSV