PREVIEW / stock_5min / 2007-09-12
file: by_date/stock_5min/2007/2007-09-12.parquet size: 3.9 MB rows: 291,351 symbols: 3,114
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-12 09:30:00 | AAPL | Stock | 4.8571 | 4.8889 | 4.8482 | 4.8679 | 28874972.0 |
| 2007-09-12 09:35:00 | AAPL | Stock | 4.8696 | 4.8793 | 4.8571 | 4.8718 | 16119516.0 |
| 2007-09-12 09:40:00 | AAPL | Stock | 4.8725 | 4.9 | 4.8682 | 4.8982 | 26827360.0 |
| 2007-09-12 09:45:00 | AAPL | Stock | 4.8964 | 4.9071 | 4.8907 | 4.8975 | 21867580.0 |
| 2007-09-12 09:50:00 | AAPL | Stock | 4.8975 | 4.9032 | 4.8846 | 4.8857 | 19483576.0 |
| 2007-09-12 09:55:00 | AAPL | Stock | 4.8854 | 4.9018 | 4.8852 | 4.8986 | 13002808.0 |
| 2007-09-12 10:00:00 | AAPL | Stock | 4.8986 | 4.9161 | 4.8971 | 4.9143 | 23552368.0 |
| 2007-09-12 10:05:00 | AAPL | Stock | 4.9146 | 4.9325 | 4.9086 | 4.9214 | 25420584.0 |
| 2007-09-12 10:10:00 | AAPL | Stock | 4.9214 | 4.9268 | 4.9143 | 4.9193 | 14911428.0 |
| 2007-09-12 10:15:00 | AAPL | Stock | 4.9193 | 4.9225 | 4.9061 | 4.9086 | 16897104.0 |
| 2007-09-12 10:20:00 | AAPL | Stock | 4.9089 | 4.9261 | 4.9068 | 4.92 | 12852756.0 |
| 2007-09-12 10:25:00 | AAPL | Stock | 4.9211 | 4.9357 | 4.9204 | 4.9257 | 17532088.0 |
| 2007-09-12 10:30:00 | AAPL | Stock | 4.9254 | 4.9304 | 4.9207 | 4.9257 | 12404588.0 |
| 2007-09-12 10:35:00 | AAPL | Stock | 4.9261 | 4.945 | 4.9221 | 4.9443 | 16428076.0 |
| 2007-09-12 10:40:00 | AAPL | Stock | 4.9443 | 4.9539 | 4.9425 | 4.9504 | 24212552.0 |
| 2007-09-12 10:45:00 | AAPL | Stock | 4.9504 | 4.9568 | 4.9436 | 4.9505 | 17666432.0 |
| 2007-09-12 10:50:00 | AAPL | Stock | 4.9511 | 4.9511 | 4.9411 | 4.9421 | 11631312.0 |
| 2007-09-12 10:55:00 | AAPL | Stock | 4.942 | 4.9511 | 4.9396 | 4.9414 | 12141024.0 |
| 2007-09-12 11:00:00 | AAPL | Stock | 4.9411 | 4.9446 | 4.9321 | 4.9382 | 13842948.0 |
| 2007-09-12 11:05:00 | AAPL | Stock | 4.9382 | 4.9479 | 4.9379 | 4.9475 | 9745484.0 |
| 2007-09-12 11:10:00 | AAPL | Stock | 4.9475 | 4.9582 | 4.9471 | 4.9539 | 11443740.0 |
| 2007-09-12 11:15:00 | AAPL | Stock | 4.9536 | 4.9661 | 4.9532 | 4.9579 | 14894824.0 |
| 2007-09-12 11:20:00 | AAPL | Stock | 4.9579 | 4.9786 | 4.9571 | 4.975 | 18289180.0 |
| 2007-09-12 11:25:00 | AAPL | Stock | 4.975 | 4.9764 | 4.965 | 4.9668 | 9032688.0 |
| 2007-09-12 11:30:00 | AAPL | Stock | 4.9671 | 4.9725 | 4.965 | 4.9686 | 7856884.0 |
| 2007-09-12 11:35:00 | AAPL | Stock | 4.9682 | 4.97 | 4.9561 | 4.9575 | 11482436.0 |
| 2007-09-12 11:40:00 | AAPL | Stock | 4.9579 | 4.9607 | 4.955 | 4.9603 | 5937148.0 |
| 2007-09-12 11:45:00 | AAPL | Stock | 4.9597 | 4.9661 | 4.9571 | 4.9607 | 6247444.0 |
| 2007-09-12 11:50:00 | AAPL | Stock | 4.9611 | 4.9639 | 4.9532 | 4.9568 | 8179528.0 |
| 2007-09-12 11:55:00 | AAPL | Stock | 4.9568 | 4.9593 | 4.9429 | 4.9446 | 10369688.0 |
| 2007-09-12 12:00:00 | AAPL | Stock | 4.9446 | 4.9454 | 4.9382 | 4.9411 | 7885052.0 |
| 2007-09-12 12:05:00 | AAPL | Stock | 4.9411 | 4.9525 | 4.9411 | 4.9454 | 8715056.0 |
| 2007-09-12 12:10:00 | AAPL | Stock | 4.9454 | 4.9495 | 4.9393 | 4.9471 | 6782916.0 |
| 2007-09-12 12:15:00 | AAPL | Stock | 4.9479 | 4.9493 | 4.9379 | 4.9379 | 5365920.0 |
| 2007-09-12 12:20:00 | AAPL | Stock | 4.9382 | 4.9389 | 4.9157 | 4.9193 | 20258924.0 |
| 2007-09-12 12:25:00 | AAPL | Stock | 4.9211 | 4.9279 | 4.9132 | 4.9218 | 11646488.0 |
| 2007-09-12 12:30:00 | AAPL | Stock | 4.9221 | 4.9261 | 4.9111 | 4.925 | 9886604.0 |
| 2007-09-12 12:35:00 | AAPL | Stock | 4.925 | 4.9354 | 4.925 | 4.9318 | 9099664.0 |
| 2007-09-12 12:40:00 | AAPL | Stock | 4.9311 | 4.9318 | 4.9182 | 4.9286 | 8864184.0 |
| 2007-09-12 12:45:00 | AAPL | Stock | 4.9286 | 4.9382 | 4.9261 | 4.9325 | 7270788.0 |
| 2007-09-12 12:50:00 | AAPL | Stock | 4.9321 | 4.9357 | 4.9221 | 4.9264 | 5641048.0 |
| 2007-09-12 12:55:00 | AAPL | Stock | 4.9261 | 4.9321 | 4.9243 | 4.9318 | 4520376.0 |
| 2007-09-12 13:00:00 | AAPL | Stock | 4.9315 | 4.9375 | 4.9264 | 4.9264 | 5130160.0 |
| 2007-09-12 13:05:00 | AAPL | Stock | 4.9264 | 4.9268 | 4.9075 | 4.9132 | 13055476.0 |
| 2007-09-12 13:10:00 | AAPL | Stock | 4.9132 | 4.9225 | 4.9125 | 4.9193 | 8847580.0 |
| 2007-09-12 13:15:00 | AAPL | Stock | 4.9189 | 4.9239 | 4.9186 | 4.9204 | 5819492.0 |
| 2007-09-12 13:20:00 | AAPL | Stock | 4.9204 | 4.9229 | 4.9179 | 4.9179 | 3736404.0 |
| 2007-09-12 13:25:00 | AAPL | Stock | 4.9179 | 4.9232 | 4.9171 | 4.9232 | 4091024.0 |
| 2007-09-12 13:30:00 | AAPL | Stock | 4.9229 | 4.9229 | 4.9125 | 4.9164 | 5384820.0 |
| 2007-09-12 13:35:00 | AAPL | Stock | 4.9161 | 4.9307 | 4.9121 | 4.9296 | 11725000.0 |
> showing 50 of 291,351 rows — these rows as CSV