PREVIEW / stock_5min / 2009-07-13
file: by_date/stock_5min/2009/2009-07-13.parquet size: 4.5 MB rows: 314,157 symbols: 3,339
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-07-13 07:20:00 | AAPL | Stock | 4.9475 | 4.9475 | 4.9475 | 4.9475 | 11200.0 |
| 2009-07-13 07:25:00 | AAPL | Stock | 4.9468 | 4.9468 | 4.9468 | 4.9468 | 14000.0 |
| 2009-07-13 07:40:00 | AAPL | Stock | 4.9375 | 4.9375 | 4.9375 | 4.9375 | 14000.0 |
| 2009-07-13 08:00:00 | AAPL | Stock | 4.9375 | 4.9482 | 4.9375 | 4.9482 | 12180.0 |
| 2009-07-13 08:10:00 | AAPL | Stock | 4.95 | 4.9571 | 4.95 | 4.9571 | 14700.0 |
| 2009-07-13 08:15:00 | AAPL | Stock | 4.9593 | 4.9611 | 4.9593 | 4.9607 | 107660.0 |
| 2009-07-13 08:20:00 | AAPL | Stock | 4.9607 | 4.9711 | 4.9607 | 4.9643 | 302932.0 |
| 2009-07-13 08:25:00 | AAPL | Stock | 4.9643 | 4.97 | 4.9643 | 4.9682 | 158480.0 |
| 2009-07-13 08:30:00 | AAPL | Stock | 4.9682 | 4.97 | 4.9643 | 4.9646 | 98980.0 |
| 2009-07-13 08:35:00 | AAPL | Stock | 4.9646 | 4.9696 | 4.9646 | 4.9696 | 169820.0 |
| 2009-07-13 08:40:00 | AAPL | Stock | 4.97 | 4.9779 | 4.9696 | 4.9771 | 339920.0 |
| 2009-07-13 08:45:00 | AAPL | Stock | 4.9775 | 4.9857 | 4.9739 | 4.9768 | 326396.0 |
| 2009-07-13 08:50:00 | AAPL | Stock | 4.9771 | 4.9846 | 4.9768 | 4.9839 | 291200.0 |
| 2009-07-13 08:55:00 | AAPL | Stock | 4.9821 | 4.9854 | 4.9821 | 4.9821 | 47040.0 |
| 2009-07-13 09:00:00 | AAPL | Stock | 4.9832 | 4.9857 | 4.9821 | 4.9839 | 76216.0 |
| 2009-07-13 09:05:00 | AAPL | Stock | 4.9829 | 4.9829 | 4.9804 | 4.9804 | 285852.0 |
| 2009-07-13 09:10:00 | AAPL | Stock | 4.9821 | 4.9821 | 4.9804 | 4.9804 | 229600.0 |
| 2009-07-13 09:15:00 | AAPL | Stock | 4.9804 | 4.9821 | 4.9804 | 4.9804 | 118160.0 |
| 2009-07-13 09:20:00 | AAPL | Stock | 4.9811 | 4.9857 | 4.9811 | 4.9821 | 226800.0 |
| 2009-07-13 09:25:00 | AAPL | Stock | 4.9814 | 4.9829 | 4.9764 | 4.9821 | 1064308.0 |
| 2009-07-13 09:30:00 | AAPL | Stock | 4.9825 | 5.0014 | 4.9786 | 4.9939 | 22647184.0 |
| 2009-07-13 09:35:00 | AAPL | Stock | 4.9939 | 4.9957 | 4.9518 | 4.9573 | 15033004.0 |
| 2009-07-13 09:40:00 | AAPL | Stock | 4.9575 | 4.9632 | 4.9464 | 4.9629 | 11836496.0 |
| 2009-07-13 09:45:00 | AAPL | Stock | 4.9621 | 4.9639 | 4.9254 | 4.9421 | 13621104.0 |
| 2009-07-13 09:50:00 | AAPL | Stock | 4.9414 | 4.9414 | 4.9118 | 4.9214 | 11729760.0 |
| 2009-07-13 09:55:00 | AAPL | Stock | 4.9211 | 4.9518 | 4.9155 | 4.9457 | 11947264.0 |
| 2009-07-13 10:00:00 | AAPL | Stock | 4.9461 | 4.95 | 4.9246 | 4.9339 | 10149356.0 |
| 2009-07-13 10:05:00 | AAPL | Stock | 4.9342 | 4.9629 | 4.934 | 4.9589 | 11175108.0 |
| 2009-07-13 10:10:00 | AAPL | Stock | 4.9582 | 4.9607 | 4.9489 | 4.9588 | 6003788.0 |
| 2009-07-13 10:15:00 | AAPL | Stock | 4.9593 | 4.9743 | 4.9589 | 4.9727 | 8983968.0 |
| 2009-07-13 10:20:00 | AAPL | Stock | 4.9732 | 4.9739 | 4.9614 | 4.9693 | 6300672.0 |
| 2009-07-13 10:25:00 | AAPL | Stock | 4.97 | 4.9907 | 4.9682 | 4.9821 | 11565568.0 |
| 2009-07-13 10:30:00 | AAPL | Stock | 4.9821 | 4.9964 | 4.98 | 4.9918 | 7956088.0 |
| 2009-07-13 10:35:00 | AAPL | Stock | 4.9918 | 5.0018 | 4.9886 | 5.0007 | 8212456.0 |
| 2009-07-13 10:40:00 | AAPL | Stock | 4.9993 | 5.0118 | 4.9993 | 5.0018 | 10091676.0 |
| 2009-07-13 10:45:00 | AAPL | Stock | 5.0031 | 5.01 | 4.9982 | 5.0061 | 6864676.0 |
| 2009-07-13 10:50:00 | AAPL | Stock | 5.0068 | 5.0095 | 5.0004 | 5.0032 | 4353692.0 |
| 2009-07-13 10:55:00 | AAPL | Stock | 5.0032 | 5.0221 | 5.0025 | 5.0196 | 9991604.0 |
| 2009-07-13 11:00:00 | AAPL | Stock | 5.02 | 5.0211 | 5.0118 | 5.0125 | 7097244.0 |
| 2009-07-13 11:05:00 | AAPL | Stock | 5.0118 | 5.0182 | 5.0111 | 5.0146 | 3919496.0 |
| 2009-07-13 11:10:00 | AAPL | Stock | 5.0143 | 5.0296 | 5.0143 | 5.0254 | 7236096.0 |
| 2009-07-13 11:15:00 | AAPL | Stock | 5.025 | 5.0275 | 5.0214 | 5.025 | 5033532.0 |
| 2009-07-13 11:20:00 | AAPL | Stock | 5.0263 | 5.0318 | 5.0221 | 5.0286 | 3765216.0 |
| 2009-07-13 11:25:00 | AAPL | Stock | 5.0284 | 5.0307 | 5.0229 | 5.0286 | 3890740.0 |
| 2009-07-13 11:30:00 | AAPL | Stock | 5.0292 | 5.0536 | 5.0282 | 5.0454 | 14069356.0 |
| 2009-07-13 11:35:00 | AAPL | Stock | 5.0461 | 5.0621 | 5.0429 | 5.0468 | 7394464.0 |
| 2009-07-13 11:40:00 | AAPL | Stock | 5.0464 | 5.0493 | 5.0421 | 5.0457 | 3613708.0 |
| 2009-07-13 11:45:00 | AAPL | Stock | 5.0446 | 5.0596 | 5.0443 | 5.0471 | 6840624.0 |
| 2009-07-13 11:50:00 | AAPL | Stock | 5.0475 | 5.0568 | 5.0464 | 5.0521 | 4346132.0 |
| 2009-07-13 11:55:00 | AAPL | Stock | 5.0525 | 5.0596 | 5.0504 | 5.0579 | 2556708.0 |
> showing 50 of 314,157 rows — these rows as CSV