PREVIEW / stock_5min / 2008-09-04
file: by_date/stock_5min/2008/2008-09-04.parquet size: 4.5 MB rows: 321,297 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-09-04 07:05:00 | AAPL | Stock | 5.9629 | 5.9629 | 5.9629 | 5.9629 | 10556.0 |
| 2008-09-04 07:10:00 | AAPL | Stock | 5.9429 | 5.9429 | 5.9429 | 5.9429 | 2800.0 |
| 2008-09-04 07:15:00 | AAPL | Stock | 5.9464 | 5.9568 | 5.9464 | 5.9568 | 11200.0 |
| 2008-09-04 07:40:00 | AAPL | Stock | 5.9575 | 5.9575 | 5.9575 | 5.9575 | 8400.0 |
| 2008-09-04 08:00:00 | AAPL | Stock | 5.9568 | 5.9646 | 5.9536 | 5.9536 | 102760.0 |
| 2008-09-04 08:05:00 | AAPL | Stock | 5.9557 | 5.9557 | 5.9554 | 5.9554 | 14000.0 |
| 2008-09-04 08:10:00 | AAPL | Stock | 5.9557 | 5.9557 | 5.95 | 5.95 | 115024.0 |
| 2008-09-04 08:15:00 | AAPL | Stock | 5.9525 | 5.9593 | 5.9525 | 5.9554 | 218596.0 |
| 2008-09-04 08:20:00 | AAPL | Stock | 5.9475 | 5.9475 | 5.9429 | 5.9457 | 53200.0 |
| 2008-09-04 08:25:00 | AAPL | Stock | 5.9411 | 5.9461 | 5.9411 | 5.9411 | 43736.0 |
| 2008-09-04 08:30:00 | AAPL | Stock | 5.9411 | 5.955 | 5.9361 | 5.955 | 110964.0 |
| 2008-09-04 08:35:00 | AAPL | Stock | 5.9443 | 5.9479 | 5.9439 | 5.9479 | 16800.0 |
| 2008-09-04 08:40:00 | AAPL | Stock | 5.9404 | 5.9404 | 5.9357 | 5.9364 | 50400.0 |
| 2008-09-04 08:45:00 | AAPL | Stock | 5.9425 | 5.9429 | 5.9371 | 5.9371 | 121800.0 |
| 2008-09-04 08:50:00 | AAPL | Stock | 5.9368 | 5.9371 | 5.935 | 5.9371 | 61600.0 |
| 2008-09-04 09:00:00 | AAPL | Stock | 5.9411 | 5.9411 | 5.9336 | 5.9339 | 77672.0 |
| 2008-09-04 09:05:00 | AAPL | Stock | 5.9357 | 5.9357 | 5.9329 | 5.9329 | 25144.0 |
| 2008-09-04 09:10:00 | AAPL | Stock | 5.9293 | 5.9357 | 5.9275 | 5.9357 | 85260.0 |
| 2008-09-04 09:15:00 | AAPL | Stock | 5.9286 | 5.9354 | 5.925 | 5.9354 | 72380.0 |
| 2008-09-04 09:20:00 | AAPL | Stock | 5.9289 | 5.9375 | 5.9289 | 5.9375 | 58800.0 |
| 2008-09-04 09:25:00 | AAPL | Stock | 5.9314 | 5.9389 | 5.9125 | 5.9246 | 538160.0 |
| 2008-09-04 09:30:00 | AAPL | Stock | 5.9236 | 5.9611 | 5.9136 | 5.9414 | 14362908.0 |
| 2008-09-04 09:35:00 | AAPL | Stock | 5.9418 | 5.9889 | 5.9396 | 5.9796 | 20958056.0 |
| 2008-09-04 09:40:00 | AAPL | Stock | 5.9786 | 5.9969 | 5.9736 | 5.9811 | 10614632.0 |
| 2008-09-04 09:45:00 | AAPL | Stock | 5.9821 | 5.985 | 5.9596 | 5.9707 | 12347972.0 |
| 2008-09-04 09:50:00 | AAPL | Stock | 5.97 | 5.9779 | 5.9632 | 5.9675 | 9971948.0 |
| 2008-09-04 09:55:00 | AAPL | Stock | 5.9677 | 5.9829 | 5.9482 | 5.955 | 13597612.0 |
| 2008-09-04 10:00:00 | AAPL | Stock | 5.9554 | 5.965 | 5.9371 | 5.9414 | 18433212.0 |
| 2008-09-04 10:05:00 | AAPL | Stock | 5.9407 | 5.9679 | 5.9396 | 5.9499 | 10941448.0 |
| 2008-09-04 10:10:00 | AAPL | Stock | 5.9482 | 5.9761 | 5.9461 | 5.9654 | 8585752.0 |
| 2008-09-04 10:15:00 | AAPL | Stock | 5.965 | 5.9664 | 5.9446 | 5.9485 | 5656056.0 |
| 2008-09-04 10:20:00 | AAPL | Stock | 5.9485 | 5.9721 | 5.9375 | 5.9643 | 10030636.0 |
| 2008-09-04 10:25:00 | AAPL | Stock | 5.9632 | 5.9643 | 5.9521 | 5.955 | 3284092.0 |
| 2008-09-04 10:30:00 | AAPL | Stock | 5.9554 | 5.9554 | 5.9121 | 5.9193 | 12064444.0 |
| 2008-09-04 10:35:00 | AAPL | Stock | 5.9193 | 5.9325 | 5.8954 | 5.8996 | 13669180.0 |
| 2008-09-04 10:40:00 | AAPL | Stock | 5.8996 | 5.9146 | 5.8861 | 5.8982 | 12103280.0 |
| 2008-09-04 10:45:00 | AAPL | Stock | 5.8979 | 5.9154 | 5.8939 | 5.9011 | 8611176.0 |
| 2008-09-04 10:50:00 | AAPL | Stock | 5.9011 | 5.915 | 5.8893 | 5.905 | 7555940.0 |
| 2008-09-04 10:55:00 | AAPL | Stock | 5.9043 | 5.9189 | 5.9029 | 5.9168 | 4952640.0 |
| 2008-09-04 11:00:00 | AAPL | Stock | 5.9161 | 5.9286 | 5.9057 | 5.9121 | 7192780.0 |
| 2008-09-04 11:05:00 | AAPL | Stock | 5.9118 | 5.9268 | 5.9021 | 5.9214 | 6878592.0 |
| 2008-09-04 11:10:00 | AAPL | Stock | 5.9214 | 5.9393 | 5.9175 | 5.9243 | 5691392.0 |
| 2008-09-04 11:15:00 | AAPL | Stock | 5.9236 | 5.9239 | 5.895 | 5.9004 | 7435624.0 |
| 2008-09-04 11:20:00 | AAPL | Stock | 5.8989 | 5.9064 | 5.8696 | 5.8857 | 10203620.0 |
| 2008-09-04 11:25:00 | AAPL | Stock | 5.8857 | 5.8989 | 5.8832 | 5.8943 | 5390084.0 |
| 2008-09-04 11:30:00 | AAPL | Stock | 5.8946 | 5.8956 | 5.8725 | 5.8775 | 6915972.0 |
| 2008-09-04 11:35:00 | AAPL | Stock | 5.8779 | 5.8839 | 5.8643 | 5.8818 | 6951616.0 |
| 2008-09-04 11:40:00 | AAPL | Stock | 5.8821 | 5.9025 | 5.8792 | 5.9004 | 6115396.0 |
| 2008-09-04 11:45:00 | AAPL | Stock | 5.9004 | 5.9043 | 5.8893 | 5.8961 | 4376456.0 |
| 2008-09-04 11:50:00 | AAPL | Stock | 5.8961 | 5.9161 | 5.8961 | 5.9054 | 5233592.0 |
> showing 50 of 321,297 rows — these rows as CSV