PREVIEW / stock_5min / 2008-01-03
file: by_date/stock_5min/2008/2008-01-03.parquet size: 4.4 MB rows: 325,541 symbols: 3,237
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-01-03 06:05:00 | AAPL | Stock | 6.9796 | 6.9807 | 6.9796 | 6.9807 | 11200.0 |
| 2008-01-03 06:45:00 | AAPL | Stock | 6.9557 | 6.9557 | 6.9557 | 6.9557 | 5600.0 |
| 2008-01-03 06:50:00 | AAPL | Stock | 6.9357 | 6.9389 | 6.9357 | 6.9389 | 8400.0 |
| 2008-01-03 07:00:00 | AAPL | Stock | 6.9389 | 6.9389 | 6.9389 | 6.9389 | 2800.0 |
| 2008-01-03 07:15:00 | AAPL | Stock | 6.9536 | 6.9554 | 6.9536 | 6.9554 | 22400.0 |
| 2008-01-03 07:25:00 | AAPL | Stock | 6.9821 | 6.9821 | 6.9821 | 6.9821 | 5600.0 |
| 2008-01-03 07:35:00 | AAPL | Stock | 6.9643 | 6.9696 | 6.9643 | 6.9696 | 72380.0 |
| 2008-01-03 07:40:00 | AAPL | Stock | 6.9696 | 6.9696 | 6.9629 | 6.9629 | 16800.0 |
| 2008-01-03 07:45:00 | AAPL | Stock | 6.9554 | 6.9554 | 6.9554 | 6.9554 | 8400.0 |
| 2008-01-03 07:50:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9554 | 6.9554 | 16800.0 |
| 2008-01-03 07:55:00 | AAPL | Stock | 6.9554 | 6.9554 | 6.9414 | 6.9429 | 58800.0 |
| 2008-01-03 08:00:00 | AAPL | Stock | 6.9482 | 6.9643 | 6.9289 | 6.9571 | 597688.0 |
| 2008-01-03 08:05:00 | AAPL | Stock | 6.9536 | 6.9536 | 6.94 | 6.94 | 222152.0 |
| 2008-01-03 08:10:00 | AAPL | Stock | 6.9393 | 6.9393 | 6.9068 | 6.9111 | 321440.0 |
| 2008-01-03 08:15:00 | AAPL | Stock | 6.9229 | 6.9536 | 6.9125 | 6.9464 | 461720.0 |
| 2008-01-03 08:20:00 | AAPL | Stock | 6.9454 | 6.9639 | 6.9411 | 6.9589 | 462252.0 |
| 2008-01-03 08:25:00 | AAPL | Stock | 6.9607 | 6.9668 | 6.95 | 6.95 | 574280.0 |
| 2008-01-03 08:30:00 | AAPL | Stock | 6.9611 | 6.9775 | 6.95 | 6.9764 | 936992.0 |
| 2008-01-03 08:35:00 | AAPL | Stock | 6.9786 | 6.9961 | 6.9732 | 6.9943 | 778848.0 |
| 2008-01-03 08:40:00 | AAPL | Stock | 6.9939 | 6.9957 | 6.9818 | 6.9907 | 496020.0 |
| 2008-01-03 08:45:00 | AAPL | Stock | 6.9893 | 6.9911 | 6.9821 | 6.9879 | 578284.0 |
| 2008-01-03 08:50:00 | AAPL | Stock | 6.9879 | 6.9911 | 6.9586 | 6.9821 | 281680.0 |
| 2008-01-03 08:55:00 | AAPL | Stock | 6.9821 | 6.9886 | 6.9786 | 6.9882 | 183400.0 |
| 2008-01-03 09:00:00 | AAPL | Stock | 6.985 | 6.9929 | 6.9786 | 6.9786 | 367920.0 |
| 2008-01-03 09:05:00 | AAPL | Stock | 6.9771 | 6.9821 | 6.9768 | 6.9786 | 128464.0 |
| 2008-01-03 09:10:00 | AAPL | Stock | 6.9821 | 6.9821 | 6.9732 | 6.9754 | 282296.0 |
| 2008-01-03 09:15:00 | AAPL | Stock | 6.975 | 6.975 | 6.9643 | 6.9693 | 307776.0 |
| 2008-01-03 09:20:00 | AAPL | Stock | 6.9661 | 6.9679 | 6.9629 | 6.9636 | 214144.0 |
| 2008-01-03 09:25:00 | AAPL | Stock | 6.9625 | 6.9796 | 6.9568 | 6.9796 | 600236.0 |
| 2008-01-03 09:30:00 | AAPL | Stock | 6.9804 | 6.9821 | 6.9404 | 6.9771 | 20311984.0 |
| 2008-01-03 09:35:00 | AAPL | Stock | 6.9771 | 6.9996 | 6.9771 | 6.9921 | 21885276.0 |
| 2008-01-03 09:40:00 | AAPL | Stock | 6.9918 | 7.0075 | 6.9768 | 6.9786 | 19204108.0 |
| 2008-01-03 09:45:00 | AAPL | Stock | 6.9779 | 6.9836 | 6.9425 | 6.945 | 22263808.0 |
| 2008-01-03 09:50:00 | AAPL | Stock | 6.9421 | 6.9489 | 6.9286 | 6.9336 | 22928248.0 |
| 2008-01-03 09:55:00 | AAPL | Stock | 6.9343 | 6.955 | 6.9336 | 6.9482 | 14460712.0 |
| 2008-01-03 10:00:00 | AAPL | Stock | 6.9475 | 6.9993 | 6.9471 | 6.9946 | 25531100.0 |
| 2008-01-03 10:05:00 | AAPL | Stock | 6.9946 | 7.0393 | 6.9879 | 7.0325 | 28642320.0 |
| 2008-01-03 10:10:00 | AAPL | Stock | 7.0318 | 7.0325 | 7.0096 | 7.0157 | 17509660.0 |
| 2008-01-03 10:15:00 | AAPL | Stock | 7.0154 | 7.0235 | 7.005 | 7.0179 | 14437584.0 |
| 2008-01-03 10:20:00 | AAPL | Stock | 7.0179 | 7.0189 | 6.9882 | 7.0018 | 14689640.0 |
| 2008-01-03 10:25:00 | AAPL | Stock | 7.0007 | 7.0029 | 6.9754 | 6.9846 | 12626404.0 |
| 2008-01-03 10:30:00 | AAPL | Stock | 6.9843 | 6.99 | 6.9539 | 6.9629 | 22019368.0 |
| 2008-01-03 10:35:00 | AAPL | Stock | 6.9632 | 6.9739 | 6.9414 | 6.9564 | 19444264.0 |
| 2008-01-03 10:40:00 | AAPL | Stock | 6.9568 | 6.9586 | 6.9414 | 6.9546 | 13700512.0 |
| 2008-01-03 10:45:00 | AAPL | Stock | 6.9536 | 6.9707 | 6.95 | 6.9618 | 12422956.0 |
| 2008-01-03 10:50:00 | AAPL | Stock | 6.9618 | 6.9668 | 6.9504 | 6.9511 | 8319248.0 |
| 2008-01-03 10:55:00 | AAPL | Stock | 6.9521 | 6.9679 | 6.9414 | 6.9593 | 9457448.0 |
| 2008-01-03 11:00:00 | AAPL | Stock | 6.96 | 6.9882 | 6.9561 | 6.9818 | 9873080.0 |
| 2008-01-03 11:05:00 | AAPL | Stock | 6.9818 | 6.9893 | 6.9721 | 6.9893 | 7847252.0 |
| 2008-01-03 11:10:00 | AAPL | Stock | 6.9893 | 6.9957 | 6.9732 | 6.9771 | 10395392.0 |
> showing 50 of 325,541 rows — these rows as CSV