PREVIEW / stock_5min / 2009-08-13
file: by_date/stock_5min/2009/2009-08-13.parquet size: 4.6 MB rows: 317,046 symbols: 3,362
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-13 05:05:00 | AAPL | Stock | 5.9446 | 5.9446 | 5.9446 | 5.9446 | 2800.0 |
| 2009-08-13 05:20:00 | AAPL | Stock | 5.9446 | 5.9446 | 5.9446 | 5.9446 | 3080.0 |
| 2009-08-13 05:50:00 | AAPL | Stock | 5.9429 | 5.9607 | 5.9429 | 5.9607 | 17080.0 |
| 2009-08-13 05:55:00 | AAPL | Stock | 5.9464 | 5.9464 | 5.9464 | 5.9464 | 2800.0 |
| 2009-08-13 06:00:00 | AAPL | Stock | 5.9464 | 5.9464 | 5.9464 | 5.9464 | 14000.0 |
| 2009-08-13 06:15:00 | AAPL | Stock | 5.9464 | 5.9464 | 5.9464 | 5.9464 | 28000.0 |
| 2009-08-13 07:00:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 8400.0 |
| 2009-08-13 07:05:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 16800.0 |
| 2009-08-13 07:10:00 | AAPL | Stock | 5.9686 | 5.9686 | 5.9686 | 5.9686 | 5600.0 |
| 2009-08-13 07:15:00 | AAPL | Stock | 5.9686 | 5.9714 | 5.9643 | 5.9714 | 65800.0 |
| 2009-08-13 07:25:00 | AAPL | Stock | 5.9714 | 5.9718 | 5.9679 | 5.9679 | 47600.0 |
| 2009-08-13 07:30:00 | AAPL | Stock | 5.9646 | 5.9679 | 5.9643 | 5.9679 | 129360.0 |
| 2009-08-13 07:40:00 | AAPL | Stock | 5.9593 | 5.9593 | 5.9589 | 5.9593 | 19600.0 |
| 2009-08-13 07:50:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 5600.0 |
| 2009-08-13 07:55:00 | AAPL | Stock | 5.9589 | 5.9639 | 5.9589 | 5.9639 | 19768.0 |
| 2009-08-13 08:00:00 | AAPL | Stock | 5.9539 | 5.9671 | 5.9536 | 5.9596 | 317660.0 |
| 2009-08-13 08:05:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.96 | 5.9643 | 75600.0 |
| 2009-08-13 08:10:00 | AAPL | Stock | 5.9643 | 5.9679 | 5.9625 | 5.9675 | 294336.0 |
| 2009-08-13 08:15:00 | AAPL | Stock | 5.9675 | 5.9679 | 5.9643 | 5.9643 | 68824.0 |
| 2009-08-13 08:20:00 | AAPL | Stock | 5.9671 | 5.9736 | 5.9671 | 5.9718 | 319648.0 |
| 2009-08-13 08:25:00 | AAPL | Stock | 5.9718 | 5.9718 | 5.9643 | 5.9661 | 289828.0 |
| 2009-08-13 08:30:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9536 | 5.9536 | 546140.0 |
| 2009-08-13 08:35:00 | AAPL | Stock | 5.9532 | 5.9554 | 5.9429 | 5.9436 | 391804.0 |
| 2009-08-13 08:40:00 | AAPL | Stock | 5.9425 | 5.9461 | 5.9375 | 5.9407 | 193788.0 |
| 2009-08-13 08:45:00 | AAPL | Stock | 5.9407 | 5.9429 | 5.9296 | 5.9429 | 388836.0 |
| 2009-08-13 08:50:00 | AAPL | Stock | 5.9411 | 5.9496 | 5.9393 | 5.9482 | 407960.0 |
| 2009-08-13 08:55:00 | AAPL | Stock | 5.9482 | 5.9521 | 5.9464 | 5.9521 | 128800.0 |
| 2009-08-13 09:00:00 | AAPL | Stock | 5.9489 | 5.9554 | 5.9475 | 5.955 | 270200.0 |
| 2009-08-13 09:05:00 | AAPL | Stock | 5.9557 | 5.9643 | 5.9557 | 5.9607 | 434980.0 |
| 2009-08-13 09:10:00 | AAPL | Stock | 5.9596 | 5.9596 | 5.9554 | 5.9586 | 108500.0 |
| 2009-08-13 09:15:00 | AAPL | Stock | 5.9568 | 5.9575 | 5.9564 | 5.9571 | 25200.0 |
| 2009-08-13 09:20:00 | AAPL | Stock | 5.9607 | 5.9607 | 5.9571 | 5.9571 | 50400.0 |
| 2009-08-13 09:25:00 | AAPL | Stock | 5.9575 | 5.9579 | 5.9468 | 5.9496 | 871164.0 |
| 2009-08-13 09:30:00 | AAPL | Stock | 5.9514 | 5.9961 | 5.9464 | 5.9921 | 25422908.0 |
| 2009-08-13 09:35:00 | AAPL | Stock | 5.9921 | 5.9975 | 5.9661 | 5.9975 | 19751984.0 |
| 2009-08-13 09:40:00 | AAPL | Stock | 5.9964 | 5.9975 | 5.9761 | 5.9796 | 11448584.0 |
| 2009-08-13 09:45:00 | AAPL | Stock | 5.9793 | 5.9961 | 5.975 | 5.9914 | 10275636.0 |
| 2009-08-13 09:50:00 | AAPL | Stock | 5.9914 | 5.9936 | 5.9607 | 5.9632 | 21287224.0 |
| 2009-08-13 09:55:00 | AAPL | Stock | 5.9639 | 5.9761 | 5.9636 | 5.9754 | 9823408.0 |
| 2009-08-13 10:00:00 | AAPL | Stock | 5.9754 | 5.9818 | 5.9711 | 5.9811 | 7518728.0 |
| 2009-08-13 10:05:00 | AAPL | Stock | 5.9814 | 5.9864 | 5.9725 | 5.9754 | 6937560.0 |
| 2009-08-13 10:10:00 | AAPL | Stock | 5.975 | 5.9796 | 5.9682 | 5.9689 | 6175316.0 |
| 2009-08-13 10:15:00 | AAPL | Stock | 5.9686 | 5.9739 | 5.9621 | 5.9736 | 8398012.0 |
| 2009-08-13 10:20:00 | AAPL | Stock | 5.9743 | 5.9907 | 5.9743 | 5.9904 | 9019808.0 |
| 2009-08-13 10:25:00 | AAPL | Stock | 5.9904 | 5.9904 | 5.9811 | 5.983 | 6454532.0 |
| 2009-08-13 10:30:00 | AAPL | Stock | 5.9829 | 5.9854 | 5.9754 | 5.9804 | 3838016.0 |
| 2009-08-13 10:35:00 | AAPL | Stock | 5.9804 | 5.9946 | 5.9789 | 5.9939 | 5842284.0 |
| 2009-08-13 10:40:00 | AAPL | Stock | 5.9939 | 6.0 | 5.9936 | 5.9975 | 8116164.0 |
| 2009-08-13 10:45:00 | AAPL | Stock | 5.9982 | 5.9996 | 5.995 | 5.9979 | 4230128.0 |
| 2009-08-13 10:50:00 | AAPL | Stock | 5.9972 | 6.0207 | 5.9964 | 6.02 | 12620692.0 |
> showing 50 of 317,046 rows — these rows as CSV