PREVIEW / stock_5min / 2010-05-11
file: by_date/stock_5min/2010/2010-05-11.parquet size: 5.1 MB rows: 346,578 symbols: 3,484
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-11 04:15:00 | AAPL | Stock | 9.0536 | 9.0536 | 9.0536 | 9.0536 | 2800.0 |
| 2010-05-11 04:20:00 | AAPL | Stock | 9.0071 | 9.0071 | 9.0071 | 9.0071 | 2800.0 |
| 2010-05-11 04:40:00 | AAPL | Stock | 8.9982 | 8.9982 | 8.9982 | 8.9982 | 2800.0 |
| 2010-05-11 04:50:00 | AAPL | Stock | 8.9982 | 8.9982 | 8.9807 | 8.9807 | 19040.0 |
| 2010-05-11 05:30:00 | AAPL | Stock | 8.9493 | 8.9493 | 8.9293 | 8.9293 | 50120.0 |
| 2010-05-11 06:05:00 | AAPL | Stock | 8.9379 | 8.9379 | 8.9379 | 8.9379 | 2800.0 |
| 2010-05-11 06:15:00 | AAPL | Stock | 8.9639 | 8.9643 | 8.9639 | 8.9643 | 14000.0 |
| 2010-05-11 06:35:00 | AAPL | Stock | 8.9693 | 8.9693 | 8.9382 | 8.9382 | 6580.0 |
| 2010-05-11 06:55:00 | AAPL | Stock | 8.9793 | 8.9793 | 8.9793 | 8.9793 | 2800.0 |
| 2010-05-11 07:00:00 | AAPL | Stock | 8.9443 | 8.9643 | 8.9436 | 8.9643 | 72296.0 |
| 2010-05-11 07:05:00 | AAPL | Stock | 8.9411 | 8.9496 | 8.9411 | 8.9429 | 19600.0 |
| 2010-05-11 07:10:00 | AAPL | Stock | 8.9536 | 8.9582 | 8.9536 | 8.9582 | 11200.0 |
| 2010-05-11 07:15:00 | AAPL | Stock | 8.9539 | 8.9539 | 8.9432 | 8.9432 | 34916.0 |
| 2010-05-11 07:20:00 | AAPL | Stock | 8.9414 | 8.9496 | 8.9321 | 8.9464 | 228480.0 |
| 2010-05-11 07:25:00 | AAPL | Stock | 8.9518 | 8.9696 | 8.9464 | 8.9696 | 88984.0 |
| 2010-05-11 07:35:00 | AAPL | Stock | 8.9779 | 8.9782 | 8.9743 | 8.9743 | 17080.0 |
| 2010-05-11 07:40:00 | AAPL | Stock | 8.965 | 8.9893 | 8.965 | 8.975 | 130312.0 |
| 2010-05-11 07:45:00 | AAPL | Stock | 8.9732 | 8.9732 | 8.9625 | 8.9625 | 25200.0 |
| 2010-05-11 07:50:00 | AAPL | Stock | 8.9643 | 8.9643 | 8.9643 | 8.9643 | 16800.0 |
| 2010-05-11 07:55:00 | AAPL | Stock | 8.9729 | 8.9736 | 8.9661 | 8.9736 | 122640.0 |
| 2010-05-11 08:00:00 | AAPL | Stock | 8.9746 | 8.9932 | 8.9668 | 8.9914 | 602308.0 |
| 2010-05-11 08:05:00 | AAPL | Stock | 8.9929 | 9.0071 | 8.9854 | 8.9986 | 444192.0 |
| 2010-05-11 08:10:00 | AAPL | Stock | 9.0036 | 9.0043 | 8.9911 | 8.9943 | 338632.0 |
| 2010-05-11 08:15:00 | AAPL | Stock | 8.9979 | 8.9993 | 8.9879 | 8.9893 | 335888.0 |
| 2010-05-11 08:20:00 | AAPL | Stock | 8.9896 | 8.9929 | 8.9896 | 8.9911 | 93016.0 |
| 2010-05-11 08:25:00 | AAPL | Stock | 8.99 | 8.9964 | 8.9896 | 8.9921 | 78400.0 |
| 2010-05-11 08:30:00 | AAPL | Stock | 8.9932 | 8.9932 | 8.9704 | 8.9743 | 634424.0 |
| 2010-05-11 08:35:00 | AAPL | Stock | 8.9771 | 8.9814 | 8.9668 | 8.9696 | 418880.0 |
| 2010-05-11 08:40:00 | AAPL | Stock | 8.9671 | 8.9729 | 8.9568 | 8.9711 | 553840.0 |
| 2010-05-11 08:45:00 | AAPL | Stock | 8.9711 | 8.9729 | 8.9575 | 8.9582 | 337120.0 |
| 2010-05-11 08:50:00 | AAPL | Stock | 8.9575 | 8.9575 | 8.9486 | 8.9518 | 459172.0 |
| 2010-05-11 08:55:00 | AAPL | Stock | 8.9504 | 8.9575 | 8.9446 | 8.9554 | 384944.0 |
| 2010-05-11 09:00:00 | AAPL | Stock | 8.9514 | 8.9554 | 8.9425 | 8.9446 | 405804.0 |
| 2010-05-11 09:05:00 | AAPL | Stock | 8.9429 | 8.9471 | 8.94 | 8.9471 | 241136.0 |
| 2010-05-11 09:10:00 | AAPL | Stock | 8.9471 | 8.9564 | 8.9432 | 8.9539 | 364000.0 |
| 2010-05-11 09:15:00 | AAPL | Stock | 8.9532 | 8.9539 | 8.9439 | 8.9468 | 210000.0 |
| 2010-05-11 09:20:00 | AAPL | Stock | 8.9479 | 8.9596 | 8.9468 | 8.9575 | 180712.0 |
| 2010-05-11 09:25:00 | AAPL | Stock | 8.9589 | 8.9957 | 8.9589 | 8.9911 | 952196.0 |
| 2010-05-11 09:30:00 | AAPL | Stock | 8.9943 | 9.0071 | 8.9464 | 8.9736 | 23133600.0 |
| 2010-05-11 09:35:00 | AAPL | Stock | 8.9729 | 8.9929 | 8.9543 | 8.9561 | 19989256.0 |
| 2010-05-11 09:40:00 | AAPL | Stock | 8.9561 | 8.9811 | 8.9536 | 8.9729 | 20843060.0 |
| 2010-05-11 09:45:00 | AAPL | Stock | 8.9736 | 9.0196 | 8.9729 | 8.9959 | 18920076.0 |
| 2010-05-11 09:50:00 | AAPL | Stock | 8.9932 | 9.0493 | 8.9929 | 9.0243 | 19120052.0 |
| 2010-05-11 09:55:00 | AAPL | Stock | 9.0243 | 9.0285 | 8.9964 | 9.0091 | 11352096.0 |
| 2010-05-11 10:00:00 | AAPL | Stock | 9.0089 | 9.0282 | 8.9746 | 8.99 | 10261608.0 |
| 2010-05-11 10:05:00 | AAPL | Stock | 8.99 | 8.9982 | 8.975 | 8.9904 | 8235416.0 |
| 2010-05-11 10:10:00 | AAPL | Stock | 8.9907 | 9.0146 | 8.9796 | 9.0107 | 8279712.0 |
| 2010-05-11 10:15:00 | AAPL | Stock | 9.0107 | 9.0136 | 8.9961 | 8.9989 | 7663656.0 |
| 2010-05-11 10:20:00 | AAPL | Stock | 8.9993 | 9.0282 | 8.9993 | 9.0182 | 7958636.0 |
| 2010-05-11 10:25:00 | AAPL | Stock | 9.0175 | 9.0196 | 9.0 | 9.0104 | 6205080.0 |
> showing 50 of 346,578 rows — these rows as CSV