PREVIEW / stock_5min / 2008-09-03
file: by_date/stock_5min/2008/2008-09-03.parquet size: 4.4 MB rows: 312,682 symbols: 3,290
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-03 07:35:00 | AAPL | Stock | 5.9496 | 5.9496 | 5.9496 | 5.9496 | 5600.0 |
| 2008-09-03 07:40:00 | AAPL | Stock | 5.9461 | 5.9461 | 5.9357 | 5.9357 | 42000.0 |
| 2008-09-03 07:45:00 | AAPL | Stock | 5.9371 | 5.9371 | 5.9371 | 5.9371 | 5600.0 |
| 2008-09-03 08:00:00 | AAPL | Stock | 5.9414 | 5.9643 | 5.9393 | 5.9643 | 120400.0 |
| 2008-09-03 08:05:00 | AAPL | Stock | 5.9646 | 5.9696 | 5.9571 | 5.9571 | 284844.0 |
| 2008-09-03 08:10:00 | AAPL | Stock | 5.9546 | 5.9589 | 5.9446 | 5.95 | 255976.0 |
| 2008-09-03 08:15:00 | AAPL | Stock | 5.9429 | 5.9482 | 5.9418 | 5.9464 | 144116.0 |
| 2008-09-03 08:20:00 | AAPL | Stock | 5.9464 | 5.9557 | 5.9429 | 5.9446 | 116172.0 |
| 2008-09-03 08:25:00 | AAPL | Stock | 5.9518 | 5.9593 | 5.9518 | 5.9571 | 33600.0 |
| 2008-09-03 08:30:00 | AAPL | Stock | 5.9504 | 5.9564 | 5.9464 | 5.9496 | 48020.0 |
| 2008-09-03 08:35:00 | AAPL | Stock | 5.9489 | 5.95 | 5.9468 | 5.95 | 16800.0 |
| 2008-09-03 08:40:00 | AAPL | Stock | 5.95 | 5.9571 | 5.95 | 5.9571 | 82880.0 |
| 2008-09-03 08:45:00 | AAPL | Stock | 5.9571 | 5.9639 | 5.9571 | 5.9589 | 203056.0 |
| 2008-09-03 08:50:00 | AAPL | Stock | 5.9589 | 5.9679 | 5.9589 | 5.9643 | 283192.0 |
| 2008-09-03 08:55:00 | AAPL | Stock | 5.9629 | 5.9639 | 5.9518 | 5.9639 | 367052.0 |
| 2008-09-03 09:00:00 | AAPL | Stock | 5.9629 | 5.9643 | 5.9521 | 5.9621 | 192808.0 |
| 2008-09-03 09:05:00 | AAPL | Stock | 5.9643 | 5.9696 | 5.9625 | 5.9643 | 156100.0 |
| 2008-09-03 09:10:00 | AAPL | Stock | 5.9625 | 5.9625 | 5.9596 | 5.9625 | 76944.0 |
| 2008-09-03 09:15:00 | AAPL | Stock | 5.9632 | 5.9639 | 5.9614 | 5.9639 | 114044.0 |
| 2008-09-03 09:20:00 | AAPL | Stock | 5.9636 | 5.9639 | 5.9471 | 5.9471 | 124264.0 |
| 2008-09-03 09:25:00 | AAPL | Stock | 5.9486 | 5.9639 | 5.9486 | 5.9618 | 108332.0 |
| 2008-09-03 09:30:00 | AAPL | Stock | 5.9618 | 5.9989 | 5.9411 | 5.9746 | 20008408.0 |
| 2008-09-03 09:35:00 | AAPL | Stock | 5.9736 | 5.98 | 5.9536 | 5.9657 | 13394612.0 |
| 2008-09-03 09:40:00 | AAPL | Stock | 5.9664 | 5.9964 | 5.9661 | 5.9864 | 14527184.0 |
| 2008-09-03 09:45:00 | AAPL | Stock | 5.9879 | 5.9882 | 5.9643 | 5.975 | 10430784.0 |
| 2008-09-03 09:50:00 | AAPL | Stock | 5.9779 | 5.9857 | 5.9354 | 5.9417 | 17090108.0 |
| 2008-09-03 09:55:00 | AAPL | Stock | 5.9421 | 5.9796 | 5.94 | 5.9782 | 11687088.0 |
| 2008-09-03 10:00:00 | AAPL | Stock | 5.9771 | 5.995 | 5.9707 | 5.9739 | 15776236.0 |
| 2008-09-03 10:05:00 | AAPL | Stock | 5.9743 | 5.9832 | 5.9661 | 5.9689 | 9838024.0 |
| 2008-09-03 10:10:00 | AAPL | Stock | 5.9689 | 5.9821 | 5.9639 | 5.9821 | 10777816.0 |
| 2008-09-03 10:15:00 | AAPL | Stock | 5.9821 | 5.9875 | 5.9611 | 5.9675 | 9618112.0 |
| 2008-09-03 10:20:00 | AAPL | Stock | 5.9664 | 5.9779 | 5.9579 | 5.9711 | 9168012.0 |
| 2008-09-03 10:25:00 | AAPL | Stock | 5.9711 | 5.975 | 5.9607 | 5.9739 | 4623164.0 |
| 2008-09-03 10:30:00 | AAPL | Stock | 5.9739 | 5.9918 | 5.9721 | 5.9891 | 10631740.0 |
| 2008-09-03 10:35:00 | AAPL | Stock | 5.9893 | 6.0036 | 5.9875 | 6.0018 | 9490936.0 |
| 2008-09-03 10:40:00 | AAPL | Stock | 6.0018 | 6.0243 | 5.9947 | 6.0014 | 10198972.0 |
| 2008-09-03 10:45:00 | AAPL | Stock | 6.0014 | 6.0029 | 5.9836 | 5.9918 | 6657252.0 |
| 2008-09-03 10:50:00 | AAPL | Stock | 5.9914 | 5.9925 | 5.9771 | 5.9771 | 5275452.0 |
| 2008-09-03 10:55:00 | AAPL | Stock | 5.9771 | 5.9839 | 5.965 | 5.9675 | 5886440.0 |
| 2008-09-03 11:00:00 | AAPL | Stock | 5.9671 | 5.9882 | 5.9668 | 5.9839 | 6341748.0 |
| 2008-09-03 11:05:00 | AAPL | Stock | 5.9846 | 5.9975 | 5.9757 | 5.9757 | 5699400.0 |
| 2008-09-03 11:10:00 | AAPL | Stock | 5.9764 | 5.9793 | 5.9575 | 5.9614 | 8029588.0 |
| 2008-09-03 11:15:00 | AAPL | Stock | 5.9625 | 5.9779 | 5.9612 | 5.9718 | 5409404.0 |
| 2008-09-03 11:20:00 | AAPL | Stock | 5.9718 | 5.9768 | 5.95 | 5.9541 | 5902036.0 |
| 2008-09-03 11:25:00 | AAPL | Stock | 5.9529 | 5.9629 | 5.9464 | 5.9511 | 6381956.0 |
| 2008-09-03 11:30:00 | AAPL | Stock | 5.9511 | 5.9539 | 5.9143 | 5.9239 | 13342896.0 |
| 2008-09-03 11:35:00 | AAPL | Stock | 5.9236 | 5.9279 | 5.8929 | 5.8993 | 14124320.0 |
| 2008-09-03 11:40:00 | AAPL | Stock | 5.8996 | 5.9025 | 5.8707 | 5.8875 | 13957160.0 |
| 2008-09-03 11:45:00 | AAPL | Stock | 5.8874 | 5.9086 | 5.8843 | 5.9061 | 7129528.0 |
| 2008-09-03 11:50:00 | AAPL | Stock | 5.9064 | 5.9218 | 5.9036 | 5.9107 | 7996128.0 |
> showing 50 of 312,682 rows — these rows as CSV