PREVIEW / stock_5min / 2008-11-21
file: by_date/stock_5min/2008/2008-11-21.parquet size: 4.7 MB rows: 339,477 symbols: 3,379
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-11-21 04:55:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 5600.0 |
| 2008-11-21 05:50:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 2800.0 |
| 2008-11-21 06:10:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 2800.0 |
| 2008-11-21 06:45:00 | AAPL | Stock | 2.9693 | 2.9693 | 2.9629 | 2.9629 | 5600.0 |
| 2008-11-21 06:55:00 | AAPL | Stock | 2.9821 | 2.9821 | 2.9821 | 2.9821 | 2800.0 |
| 2008-11-21 07:10:00 | AAPL | Stock | 2.9643 | 2.9643 | 2.9643 | 2.9643 | 19600.0 |
| 2008-11-21 07:15:00 | AAPL | Stock | 2.975 | 2.9768 | 2.975 | 2.9768 | 27524.0 |
| 2008-11-21 07:20:00 | AAPL | Stock | 2.9646 | 2.9646 | 2.9646 | 2.9646 | 5880.0 |
| 2008-11-21 07:25:00 | AAPL | Stock | 2.9661 | 2.9661 | 2.9661 | 2.9661 | 84476.0 |
| 2008-11-21 07:30:00 | AAPL | Stock | 2.9664 | 2.9664 | 2.95 | 2.95 | 122444.0 |
| 2008-11-21 07:35:00 | AAPL | Stock | 2.9464 | 2.9464 | 2.9464 | 2.9464 | 2800.0 |
| 2008-11-21 07:40:00 | AAPL | Stock | 2.95 | 2.9529 | 2.9429 | 2.9429 | 78400.0 |
| 2008-11-21 07:45:00 | AAPL | Stock | 2.9393 | 2.9393 | 2.8968 | 2.9254 | 301420.0 |
| 2008-11-21 07:50:00 | AAPL | Stock | 2.9125 | 2.9304 | 2.9125 | 2.9304 | 159600.0 |
| 2008-11-21 07:55:00 | AAPL | Stock | 2.9286 | 2.9286 | 2.9107 | 2.9107 | 198800.0 |
| 2008-11-21 08:00:00 | AAPL | Stock | 2.9196 | 2.9214 | 2.8929 | 2.9046 | 824432.0 |
| 2008-11-21 08:05:00 | AAPL | Stock | 2.8982 | 2.9011 | 2.875 | 2.9 | 808948.0 |
| 2008-11-21 08:10:00 | AAPL | Stock | 2.8996 | 2.9107 | 2.8964 | 2.9104 | 327656.0 |
| 2008-11-21 08:15:00 | AAPL | Stock | 2.9107 | 2.9357 | 2.9107 | 2.9321 | 637700.0 |
| 2008-11-21 08:20:00 | AAPL | Stock | 2.9286 | 2.9382 | 2.9261 | 2.9382 | 421064.0 |
| 2008-11-21 08:25:00 | AAPL | Stock | 2.9382 | 2.9529 | 2.9382 | 2.9479 | 511028.0 |
| 2008-11-21 08:30:00 | AAPL | Stock | 2.9475 | 2.9589 | 2.9393 | 2.9589 | 771820.0 |
| 2008-11-21 08:35:00 | AAPL | Stock | 2.9571 | 2.9579 | 2.9464 | 2.95 | 642936.0 |
| 2008-11-21 08:40:00 | AAPL | Stock | 2.95 | 2.9607 | 2.95 | 2.9593 | 684516.0 |
| 2008-11-21 08:45:00 | AAPL | Stock | 2.9571 | 2.9621 | 2.9554 | 2.96 | 543480.0 |
| 2008-11-21 08:50:00 | AAPL | Stock | 2.9579 | 2.9607 | 2.9486 | 2.9489 | 369740.0 |
| 2008-11-21 08:55:00 | AAPL | Stock | 2.9464 | 2.9539 | 2.9464 | 2.9529 | 178836.0 |
| 2008-11-21 09:00:00 | AAPL | Stock | 2.9532 | 2.9607 | 2.9507 | 2.9507 | 209888.0 |
| 2008-11-21 09:05:00 | AAPL | Stock | 2.9554 | 2.9575 | 2.9546 | 2.9564 | 180404.0 |
| 2008-11-21 09:10:00 | AAPL | Stock | 2.9561 | 2.9579 | 2.95 | 2.9507 | 268016.0 |
| 2008-11-21 09:15:00 | AAPL | Stock | 2.9525 | 2.9536 | 2.945 | 2.9489 | 314272.0 |
| 2008-11-21 09:20:00 | AAPL | Stock | 2.9482 | 2.9489 | 2.9393 | 2.9429 | 455084.0 |
| 2008-11-21 09:25:00 | AAPL | Stock | 2.9429 | 2.9443 | 2.9261 | 2.9264 | 994364.0 |
| 2008-11-21 09:30:00 | AAPL | Stock | 2.9261 | 2.9539 | 2.9125 | 2.9264 | 29677060.0 |
| 2008-11-21 09:35:00 | AAPL | Stock | 2.9279 | 2.93 | 2.9018 | 2.9086 | 30887724.0 |
| 2008-11-21 09:40:00 | AAPL | Stock | 2.9079 | 2.9371 | 2.9057 | 2.9329 | 31558940.0 |
| 2008-11-21 09:45:00 | AAPL | Stock | 2.9332 | 3.0043 | 2.9304 | 2.9879 | 43254064.0 |
| 2008-11-21 09:50:00 | AAPL | Stock | 2.9886 | 2.9996 | 2.9025 | 2.9689 | 32485012.0 |
| 2008-11-21 09:55:00 | AAPL | Stock | 2.9689 | 2.9768 | 2.9525 | 2.9736 | 27823880.0 |
| 2008-11-21 10:00:00 | AAPL | Stock | 2.9736 | 2.9821 | 2.9382 | 2.96 | 28459844.0 |
| 2008-11-21 10:05:00 | AAPL | Stock | 2.96 | 2.9914 | 2.9596 | 2.9864 | 23765560.0 |
| 2008-11-21 10:10:00 | AAPL | Stock | 2.9871 | 2.9896 | 2.9511 | 2.9511 | 18422376.0 |
| 2008-11-21 10:15:00 | AAPL | Stock | 2.9515 | 2.9661 | 2.9379 | 2.9539 | 18206580.0 |
| 2008-11-21 10:20:00 | AAPL | Stock | 2.9557 | 2.9668 | 2.9518 | 2.9546 | 17167864.0 |
| 2008-11-21 10:25:00 | AAPL | Stock | 2.9536 | 2.9596 | 2.9364 | 2.9404 | 21911568.0 |
| 2008-11-21 10:30:00 | AAPL | Stock | 2.9404 | 2.9568 | 2.9339 | 2.9368 | 16765448.0 |
| 2008-11-21 10:35:00 | AAPL | Stock | 2.9371 | 2.9571 | 2.9321 | 2.955 | 19251260.0 |
| 2008-11-21 10:40:00 | AAPL | Stock | 2.9546 | 2.96 | 2.9486 | 2.9511 | 16040640.0 |
| 2008-11-21 10:45:00 | AAPL | Stock | 2.9516 | 2.9643 | 2.9371 | 2.9382 | 16352224.0 |
| 2008-11-21 10:50:00 | AAPL | Stock | 2.9389 | 2.9429 | 2.9204 | 2.9286 | 17020500.0 |
> showing 50 of 339,477 rows — these rows as CSV