PREVIEW / stock_5min / 2008-06-11
file: by_date/stock_5min/2008/2008-06-11.parquet size: 4.4 MB rows: 316,044 symbols: 3,314
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-06-11 04:15:00 | AAPL | Stock | 6.6239 | 6.6239 | 6.6239 | 6.6239 | 2800.0 |
| 2008-06-11 05:10:00 | AAPL | Stock | 6.6568 | 6.6568 | 6.6568 | 6.6568 | 2800.0 |
| 2008-06-11 06:25:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 8400.0 |
| 2008-06-11 07:00:00 | AAPL | Stock | 6.6618 | 6.6621 | 6.6432 | 6.6432 | 130200.0 |
| 2008-06-11 07:05:00 | AAPL | Stock | 6.6432 | 6.6607 | 6.6432 | 6.6607 | 22400.0 |
| 2008-06-11 07:10:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 2800.0 |
| 2008-06-11 07:15:00 | AAPL | Stock | 6.65 | 6.65 | 6.65 | 6.65 | 2800.0 |
| 2008-06-11 07:20:00 | AAPL | Stock | 6.66 | 6.6607 | 6.66 | 6.6607 | 19600.0 |
| 2008-06-11 07:30:00 | AAPL | Stock | 6.6643 | 6.6657 | 6.6643 | 6.6657 | 5600.0 |
| 2008-06-11 07:45:00 | AAPL | Stock | 6.6657 | 6.6657 | 6.6507 | 6.6507 | 15400.0 |
| 2008-06-11 07:50:00 | AAPL | Stock | 6.6536 | 6.6571 | 6.6536 | 6.6571 | 19600.0 |
| 2008-06-11 07:55:00 | AAPL | Stock | 6.6582 | 6.6654 | 6.6582 | 6.6654 | 42000.0 |
| 2008-06-11 08:00:00 | AAPL | Stock | 6.6625 | 6.6661 | 6.65 | 6.6518 | 785764.0 |
| 2008-06-11 08:05:00 | AAPL | Stock | 6.6546 | 6.6546 | 6.6321 | 6.6393 | 877520.0 |
| 2008-06-11 08:10:00 | AAPL | Stock | 6.6393 | 6.6446 | 6.6321 | 6.6321 | 393764.0 |
| 2008-06-11 08:15:00 | AAPL | Stock | 6.635 | 6.6382 | 6.6329 | 6.6379 | 76300.0 |
| 2008-06-11 08:20:00 | AAPL | Stock | 6.6361 | 6.6407 | 6.6179 | 6.6214 | 450940.0 |
| 2008-06-11 08:25:00 | AAPL | Stock | 6.6232 | 6.6404 | 6.6218 | 6.6336 | 365988.0 |
| 2008-06-11 08:30:00 | AAPL | Stock | 6.6357 | 6.6357 | 6.6304 | 6.6304 | 117908.0 |
| 2008-06-11 08:35:00 | AAPL | Stock | 6.6289 | 6.6332 | 6.6257 | 6.6332 | 174244.0 |
| 2008-06-11 08:40:00 | AAPL | Stock | 6.6311 | 6.6354 | 6.6225 | 6.6225 | 208544.0 |
| 2008-06-11 08:45:00 | AAPL | Stock | 6.6221 | 6.6268 | 6.6221 | 6.625 | 146832.0 |
| 2008-06-11 08:50:00 | AAPL | Stock | 6.6271 | 6.6325 | 6.6271 | 6.6275 | 331240.0 |
| 2008-06-11 08:55:00 | AAPL | Stock | 6.6271 | 6.6314 | 6.6232 | 6.6314 | 212884.0 |
| 2008-06-11 09:00:00 | AAPL | Stock | 6.6314 | 6.6321 | 6.6232 | 6.6264 | 257124.0 |
| 2008-06-11 09:05:00 | AAPL | Stock | 6.625 | 6.6264 | 6.6071 | 6.6093 | 687988.0 |
| 2008-06-11 09:10:00 | AAPL | Stock | 6.6079 | 6.6107 | 6.5714 | 6.5861 | 2912196.0 |
| 2008-06-11 09:15:00 | AAPL | Stock | 6.5875 | 6.5904 | 6.5632 | 6.5686 | 1506316.0 |
| 2008-06-11 09:20:00 | AAPL | Stock | 6.5689 | 6.5839 | 6.5621 | 6.5746 | 772016.0 |
| 2008-06-11 09:25:00 | AAPL | Stock | 6.5746 | 6.5832 | 6.5646 | 6.5829 | 1373316.0 |
| 2008-06-11 09:30:00 | AAPL | Stock | 6.5829 | 6.6429 | 6.5732 | 6.5918 | 25405660.0 |
| 2008-06-11 09:35:00 | AAPL | Stock | 6.59 | 6.5961 | 6.5511 | 6.58 | 23742488.0 |
| 2008-06-11 09:40:00 | AAPL | Stock | 6.5796 | 6.6004 | 6.5654 | 6.5797 | 19045152.0 |
| 2008-06-11 09:45:00 | AAPL | Stock | 6.58 | 6.6214 | 6.5789 | 6.6079 | 17917312.0 |
| 2008-06-11 09:50:00 | AAPL | Stock | 6.6079 | 6.6082 | 6.5804 | 6.5814 | 16448012.0 |
| 2008-06-11 09:55:00 | AAPL | Stock | 6.5814 | 6.5829 | 6.5575 | 6.5658 | 18986828.0 |
| 2008-06-11 10:00:00 | AAPL | Stock | 6.5654 | 6.5661 | 6.5446 | 6.5493 | 16945488.0 |
| 2008-06-11 10:05:00 | AAPL | Stock | 6.5489 | 6.5504 | 6.5132 | 6.5164 | 26013708.0 |
| 2008-06-11 10:10:00 | AAPL | Stock | 6.5164 | 6.5604 | 6.4786 | 6.4836 | 32609276.0 |
| 2008-06-11 10:15:00 | AAPL | Stock | 6.4836 | 6.5039 | 6.4743 | 6.5 | 22668436.0 |
| 2008-06-11 10:20:00 | AAPL | Stock | 6.4993 | 6.5179 | 6.4971 | 6.5068 | 21679896.0 |
| 2008-06-11 10:25:00 | AAPL | Stock | 6.5069 | 6.5339 | 6.5057 | 6.5125 | 16631580.0 |
| 2008-06-11 10:30:00 | AAPL | Stock | 6.5126 | 6.5357 | 6.5068 | 6.5318 | 11064592.0 |
| 2008-06-11 10:35:00 | AAPL | Stock | 6.5318 | 6.5418 | 6.5218 | 6.5375 | 14786464.0 |
| 2008-06-11 10:40:00 | AAPL | Stock | 6.5375 | 6.5411 | 6.5093 | 6.5104 | 11976020.0 |
| 2008-06-11 10:45:00 | AAPL | Stock | 6.5107 | 6.5357 | 6.5104 | 6.5296 | 9057496.0 |
| 2008-06-11 10:50:00 | AAPL | Stock | 6.5304 | 6.5414 | 6.5206 | 6.537 | 7143024.0 |
| 2008-06-11 10:55:00 | AAPL | Stock | 6.537 | 6.5571 | 6.5225 | 6.5482 | 10110884.0 |
| 2008-06-11 11:00:00 | AAPL | Stock | 6.5475 | 6.555 | 6.5357 | 6.5493 | 11666844.0 |
| 2008-06-11 11:05:00 | AAPL | Stock | 6.5507 | 6.58 | 6.5482 | 6.5636 | 20389992.0 |
> showing 50 of 316,044 rows — these rows as CSV