PREVIEW / stock_5min / 2010-10-28
file: by_date/stock_5min/2010/2010-10-28.parquet size: 4.7 MB rows: 324,605 symbols: 3,470
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-10-28 04:00:00 | AAPL | Stock | 10.93 | 10.93 | 10.93 | 10.93 | 2800.0 |
| 2010-10-28 05:15:00 | AAPL | Stock | 10.9657 | 10.9657 | 10.9657 | 10.9657 | 2800.0 |
| 2010-10-28 05:30:00 | AAPL | Stock | 10.9596 | 10.9596 | 10.9596 | 10.9596 | 2800.0 |
| 2010-10-28 05:35:00 | AAPL | Stock | 10.9629 | 10.9629 | 10.9629 | 10.9629 | 2800.0 |
| 2010-10-28 05:40:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 2800.0 |
| 2010-10-28 06:30:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 2800.0 |
| 2010-10-28 07:05:00 | AAPL | Stock | 10.9286 | 10.9286 | 10.9286 | 10.9286 | 2800.0 |
| 2010-10-28 07:10:00 | AAPL | Stock | 10.9625 | 10.9625 | 10.9625 | 10.9625 | 2800.0 |
| 2010-10-28 07:20:00 | AAPL | Stock | 10.9482 | 10.9554 | 10.9482 | 10.9554 | 5600.0 |
| 2010-10-28 07:25:00 | AAPL | Stock | 10.9536 | 10.9536 | 10.9536 | 10.9536 | 11200.0 |
| 2010-10-28 07:30:00 | AAPL | Stock | 10.955 | 10.955 | 10.9536 | 10.955 | 244440.0 |
| 2010-10-28 07:35:00 | AAPL | Stock | 10.9543 | 10.955 | 10.9543 | 10.9546 | 116760.0 |
| 2010-10-28 07:40:00 | AAPL | Stock | 10.9543 | 10.9543 | 10.9375 | 10.9375 | 49000.0 |
| 2010-10-28 07:45:00 | AAPL | Stock | 10.9379 | 10.9379 | 10.9379 | 10.9379 | 2800.0 |
| 2010-10-28 07:50:00 | AAPL | Stock | 10.9464 | 10.9529 | 10.9464 | 10.9529 | 74480.0 |
| 2010-10-28 07:55:00 | AAPL | Stock | 10.95 | 10.95 | 10.95 | 10.95 | 9800.0 |
| 2010-10-28 08:00:00 | AAPL | Stock | 10.9518 | 10.9529 | 10.9411 | 10.9411 | 578256.0 |
| 2010-10-28 08:05:00 | AAPL | Stock | 10.9411 | 10.9429 | 10.9329 | 10.9429 | 142296.0 |
| 2010-10-28 08:10:00 | AAPL | Stock | 10.9375 | 10.9454 | 10.9375 | 10.9454 | 27720.0 |
| 2010-10-28 08:15:00 | AAPL | Stock | 10.9411 | 10.9643 | 10.9411 | 10.9643 | 595420.0 |
| 2010-10-28 08:20:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9511 | 10.9632 | 452284.0 |
| 2010-10-28 08:25:00 | AAPL | Stock | 10.9632 | 10.9639 | 10.9554 | 10.9579 | 192836.0 |
| 2010-10-28 08:30:00 | AAPL | Stock | 10.9589 | 10.9786 | 10.9518 | 10.9761 | 1630636.0 |
| 2010-10-28 08:35:00 | AAPL | Stock | 10.9736 | 10.9925 | 10.9721 | 10.9821 | 916748.0 |
| 2010-10-28 08:40:00 | AAPL | Stock | 10.9857 | 10.9925 | 10.9793 | 10.9864 | 367752.0 |
| 2010-10-28 08:45:00 | AAPL | Stock | 10.9879 | 10.9993 | 10.9857 | 10.9982 | 653436.0 |
| 2010-10-28 08:50:00 | AAPL | Stock | 10.9971 | 11.0071 | 10.9964 | 11.0018 | 947100.0 |
| 2010-10-28 08:55:00 | AAPL | Stock | 11.0004 | 11.0071 | 10.9846 | 10.9914 | 901684.0 |
| 2010-10-28 09:00:00 | AAPL | Stock | 10.9921 | 10.9939 | 10.9811 | 10.9893 | 354648.0 |
| 2010-10-28 09:05:00 | AAPL | Stock | 10.9932 | 10.9982 | 10.9896 | 10.9939 | 171360.0 |
| 2010-10-28 09:10:00 | AAPL | Stock | 10.9939 | 10.9943 | 10.9821 | 10.985 | 203140.0 |
| 2010-10-28 09:15:00 | AAPL | Stock | 10.9857 | 10.9929 | 10.9857 | 10.9904 | 109760.0 |
| 2010-10-28 09:20:00 | AAPL | Stock | 10.9939 | 10.9979 | 10.9932 | 10.9961 | 56000.0 |
| 2010-10-28 09:25:00 | AAPL | Stock | 10.9964 | 11.0175 | 10.9964 | 10.9993 | 697732.0 |
| 2010-10-28 09:30:00 | AAPL | Stock | 11.0004 | 11.0004 | 10.9525 | 10.9646 | 15866116.0 |
| 2010-10-28 09:35:00 | AAPL | Stock | 10.9643 | 10.9821 | 10.9529 | 10.9621 | 9332372.0 |
| 2010-10-28 09:40:00 | AAPL | Stock | 10.9621 | 10.9621 | 10.9304 | 10.9406 | 12122236.0 |
| 2010-10-28 09:45:00 | AAPL | Stock | 10.9404 | 10.9536 | 10.9232 | 10.9332 | 9640176.0 |
| 2010-10-28 09:50:00 | AAPL | Stock | 10.9343 | 10.9357 | 10.9204 | 10.9257 | 8483608.0 |
| 2010-10-28 09:55:00 | AAPL | Stock | 10.9268 | 10.9289 | 10.9082 | 10.9229 | 12071388.0 |
| 2010-10-28 10:00:00 | AAPL | Stock | 10.9246 | 10.9425 | 10.9179 | 10.9357 | 9874228.0 |
| 2010-10-28 10:05:00 | AAPL | Stock | 10.9368 | 10.9579 | 10.9246 | 10.9481 | 8838480.0 |
| 2010-10-28 10:10:00 | AAPL | Stock | 10.9457 | 10.9465 | 10.9164 | 10.9257 | 5521404.0 |
| 2010-10-28 10:15:00 | AAPL | Stock | 10.9257 | 10.9296 | 10.8946 | 10.9029 | 11087216.0 |
| 2010-10-28 10:20:00 | AAPL | Stock | 10.9029 | 10.9096 | 10.8982 | 10.8996 | 6139420.0 |
| 2010-10-28 10:25:00 | AAPL | Stock | 10.8996 | 10.9061 | 10.8589 | 10.8668 | 15879696.0 |
| 2010-10-28 10:30:00 | AAPL | Stock | 10.8682 | 10.8707 | 10.8471 | 10.8696 | 14811972.0 |
| 2010-10-28 10:35:00 | AAPL | Stock | 10.8704 | 10.8814 | 10.8364 | 10.85 | 10098788.0 |
| 2010-10-28 10:40:00 | AAPL | Stock | 10.8489 | 10.8557 | 10.8411 | 10.8532 | 8064980.0 |
| 2010-10-28 10:45:00 | AAPL | Stock | 10.8529 | 10.865 | 10.8411 | 10.8627 | 6937224.0 |
> showing 50 of 324,605 rows — these rows as CSV