PREVIEW / stock_5min / 2008-12-09
file: by_date/stock_5min/2008/2008-12-09.parquet size: 4.4 MB rows: 316,791 symbols: 3,344
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-12-09 07:15:00 | AAPL | Stock | 3.55 | 3.55 | 3.55 | 3.55 | 5600.0 |
| 2008-12-09 07:30:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5536 | 3.5536 | 9576.0 |
| 2008-12-09 07:55:00 | AAPL | Stock | 3.5393 | 3.5393 | 3.5393 | 3.5393 | 7000.0 |
| 2008-12-09 08:00:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.5271 | 3.5271 | 26572.0 |
| 2008-12-09 08:05:00 | AAPL | Stock | 3.5286 | 3.5321 | 3.5268 | 3.5286 | 25900.0 |
| 2008-12-09 08:10:00 | AAPL | Stock | 3.5286 | 3.5336 | 3.5286 | 3.5336 | 74060.0 |
| 2008-12-09 08:15:00 | AAPL | Stock | 3.5293 | 3.5357 | 3.5293 | 3.5357 | 161280.0 |
| 2008-12-09 08:20:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.53 | 3.53 | 31220.0 |
| 2008-12-09 08:30:00 | AAPL | Stock | 3.5314 | 3.5357 | 3.5293 | 3.5357 | 93800.0 |
| 2008-12-09 08:35:00 | AAPL | Stock | 3.5307 | 3.5343 | 3.5307 | 3.5343 | 15400.0 |
| 2008-12-09 08:40:00 | AAPL | Stock | 3.5293 | 3.5293 | 3.5286 | 3.5286 | 29960.0 |
| 2008-12-09 08:45:00 | AAPL | Stock | 3.5286 | 3.5286 | 3.5268 | 3.5268 | 35644.0 |
| 2008-12-09 08:50:00 | AAPL | Stock | 3.525 | 3.525 | 3.5118 | 3.5132 | 231000.0 |
| 2008-12-09 08:55:00 | AAPL | Stock | 3.5107 | 3.5132 | 3.5089 | 3.5107 | 86856.0 |
| 2008-12-09 09:00:00 | AAPL | Stock | 3.5114 | 3.5207 | 3.5114 | 3.5146 | 20860.0 |
| 2008-12-09 09:05:00 | AAPL | Stock | 3.5143 | 3.5143 | 3.5057 | 3.5061 | 138600.0 |
| 2008-12-09 09:10:00 | AAPL | Stock | 3.5064 | 3.5107 | 3.5064 | 3.5089 | 77532.0 |
| 2008-12-09 09:15:00 | AAPL | Stock | 3.51 | 3.5107 | 3.5057 | 3.5057 | 91532.0 |
| 2008-12-09 09:20:00 | AAPL | Stock | 3.5057 | 3.5136 | 3.5054 | 3.5129 | 157472.0 |
| 2008-12-09 09:25:00 | AAPL | Stock | 3.5129 | 3.5129 | 3.5 | 3.5061 | 385868.0 |
| 2008-12-09 09:30:00 | AAPL | Stock | 3.5043 | 3.5043 | 3.4718 | 3.4896 | 24649576.0 |
| 2008-12-09 09:35:00 | AAPL | Stock | 3.4886 | 3.5179 | 3.4729 | 3.5132 | 20048896.0 |
| 2008-12-09 09:40:00 | AAPL | Stock | 3.5139 | 3.5357 | 3.4946 | 3.5304 | 23604756.0 |
| 2008-12-09 09:45:00 | AAPL | Stock | 3.5304 | 3.5357 | 3.5129 | 3.5239 | 16562476.0 |
| 2008-12-09 09:50:00 | AAPL | Stock | 3.5239 | 3.5421 | 3.5132 | 3.5239 | 20302856.0 |
| 2008-12-09 09:55:00 | AAPL | Stock | 3.5243 | 3.5357 | 3.5136 | 3.5261 | 12380228.0 |
| 2008-12-09 10:00:00 | AAPL | Stock | 3.5198 | 3.5514 | 3.5154 | 3.5496 | 17237500.0 |
| 2008-12-09 10:05:00 | AAPL | Stock | 3.55 | 3.5564 | 3.5432 | 3.5471 | 16301292.0 |
| 2008-12-09 10:10:00 | AAPL | Stock | 3.5475 | 3.5779 | 3.5475 | 3.5771 | 19325180.0 |
| 2008-12-09 10:15:00 | AAPL | Stock | 3.5771 | 3.6179 | 3.5757 | 3.6175 | 34782944.0 |
| 2008-12-09 10:20:00 | AAPL | Stock | 3.6179 | 3.6411 | 3.6093 | 3.6301 | 26940816.0 |
| 2008-12-09 10:25:00 | AAPL | Stock | 3.6311 | 3.6464 | 3.6239 | 3.6289 | 26805492.0 |
| 2008-12-09 10:30:00 | AAPL | Stock | 3.6286 | 3.66 | 3.6236 | 3.6589 | 24148068.0 |
| 2008-12-09 10:35:00 | AAPL | Stock | 3.6589 | 3.6654 | 3.6489 | 3.6493 | 23408952.0 |
| 2008-12-09 10:40:00 | AAPL | Stock | 3.65 | 3.6636 | 3.6468 | 3.6546 | 16677472.0 |
| 2008-12-09 10:45:00 | AAPL | Stock | 3.655 | 3.6739 | 3.6543 | 3.6629 | 18495232.0 |
| 2008-12-09 10:50:00 | AAPL | Stock | 3.6639 | 3.6918 | 3.6632 | 3.6771 | 26675320.0 |
| 2008-12-09 10:55:00 | AAPL | Stock | 3.6775 | 3.7 | 3.6732 | 3.6821 | 19031040.0 |
| 2008-12-09 11:00:00 | AAPL | Stock | 3.6825 | 3.6893 | 3.6696 | 3.6757 | 18140640.0 |
| 2008-12-09 11:05:00 | AAPL | Stock | 3.6757 | 3.6779 | 3.6614 | 3.6682 | 14436968.0 |
| 2008-12-09 11:10:00 | AAPL | Stock | 3.6686 | 3.6693 | 3.6514 | 3.6546 | 13283480.0 |
| 2008-12-09 11:15:00 | AAPL | Stock | 3.6554 | 3.6604 | 3.6468 | 3.6518 | 17924452.0 |
| 2008-12-09 11:20:00 | AAPL | Stock | 3.6518 | 3.6635 | 3.6489 | 3.6543 | 14678832.0 |
| 2008-12-09 11:25:00 | AAPL | Stock | 3.6543 | 3.6596 | 3.6379 | 3.6379 | 12967164.0 |
| 2008-12-09 11:30:00 | AAPL | Stock | 3.6379 | 3.6489 | 3.6368 | 3.6368 | 11684652.0 |
| 2008-12-09 11:35:00 | AAPL | Stock | 3.6371 | 3.6429 | 3.6236 | 3.6322 | 16687496.0 |
| 2008-12-09 11:40:00 | AAPL | Stock | 3.6311 | 3.6393 | 3.6182 | 3.6286 | 14120204.0 |
| 2008-12-09 11:45:00 | AAPL | Stock | 3.6286 | 3.6357 | 3.625 | 3.6264 | 9570232.0 |
| 2008-12-09 11:50:00 | AAPL | Stock | 3.6268 | 3.6486 | 3.6268 | 3.6415 | 13232800.0 |
| 2008-12-09 11:55:00 | AAPL | Stock | 3.6414 | 3.6486 | 3.6332 | 3.6343 | 7152824.0 |
> showing 50 of 316,791 rows — these rows as CSV