PREVIEW / stock_5min / 2010-02-04
file: by_date/stock_5min/2010/2010-02-04.parquet size: 4.9 MB rows: 332,484 symbols: 3,441
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-02-04 04:15:00 | AAPL | Stock | 7.1325 | 7.1325 | 7.1325 | 7.1325 | 3640.0 |
| 2010-02-04 05:05:00 | AAPL | Stock | 7.1089 | 7.1089 | 7.1089 | 7.1089 | 2800.0 |
| 2010-02-04 05:30:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1179 | 7.1179 | 15792.0 |
| 2010-02-04 05:35:00 | AAPL | Stock | 7.1032 | 7.1032 | 7.1029 | 7.1029 | 19600.0 |
| 2010-02-04 05:40:00 | AAPL | Stock | 7.0929 | 7.0929 | 7.0929 | 7.0929 | 2800.0 |
| 2010-02-04 06:00:00 | AAPL | Stock | 7.0929 | 7.0929 | 7.0896 | 7.0896 | 5600.0 |
| 2010-02-04 06:45:00 | AAPL | Stock | 7.0871 | 7.0871 | 7.0871 | 7.0871 | 5600.0 |
| 2010-02-04 06:50:00 | AAPL | Stock | 7.0875 | 7.0875 | 7.0875 | 7.0875 | 4200.0 |
| 2010-02-04 07:00:00 | AAPL | Stock | 7.1143 | 7.1143 | 7.1054 | 7.1054 | 17612.0 |
| 2010-02-04 07:05:00 | AAPL | Stock | 7.0929 | 7.0929 | 7.0643 | 7.0643 | 81200.0 |
| 2010-02-04 07:10:00 | AAPL | Stock | 7.0643 | 7.0643 | 7.0643 | 7.0643 | 2800.0 |
| 2010-02-04 07:15:00 | AAPL | Stock | 7.0643 | 7.0714 | 7.0643 | 7.0714 | 23800.0 |
| 2010-02-04 07:20:00 | AAPL | Stock | 7.0929 | 7.0929 | 7.0929 | 7.0929 | 19628.0 |
| 2010-02-04 07:25:00 | AAPL | Stock | 7.0893 | 7.0893 | 7.0893 | 7.0893 | 14000.0 |
| 2010-02-04 07:30:00 | AAPL | Stock | 7.0896 | 7.0896 | 7.0661 | 7.0661 | 71092.0 |
| 2010-02-04 07:35:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0714 | 7.0714 | 2800.0 |
| 2010-02-04 07:45:00 | AAPL | Stock | 7.0893 | 7.0893 | 7.0714 | 7.0714 | 67564.0 |
| 2010-02-04 07:50:00 | AAPL | Stock | 7.0714 | 7.0721 | 7.0682 | 7.0714 | 112000.0 |
| 2010-02-04 07:55:00 | AAPL | Stock | 7.0714 | 7.0718 | 7.0643 | 7.07 | 75628.0 |
| 2010-02-04 08:00:00 | AAPL | Stock | 7.0718 | 7.0821 | 7.0671 | 7.0696 | 426496.0 |
| 2010-02-04 08:05:00 | AAPL | Stock | 7.0736 | 7.0736 | 7.0536 | 7.0607 | 751100.0 |
| 2010-02-04 08:10:00 | AAPL | Stock | 7.0607 | 7.0654 | 7.0536 | 7.0654 | 383488.0 |
| 2010-02-04 08:15:00 | AAPL | Stock | 7.0625 | 7.0654 | 7.0614 | 7.0643 | 170380.0 |
| 2010-02-04 08:20:00 | AAPL | Stock | 7.0643 | 7.0657 | 7.0632 | 7.0643 | 101892.0 |
| 2010-02-04 08:25:00 | AAPL | Stock | 7.0643 | 7.0661 | 7.0629 | 7.0661 | 138600.0 |
| 2010-02-04 08:30:00 | AAPL | Stock | 7.0657 | 7.0657 | 7.0293 | 7.045 | 1238916.0 |
| 2010-02-04 08:35:00 | AAPL | Stock | 7.0446 | 7.0446 | 7.0382 | 7.0389 | 223944.0 |
| 2010-02-04 08:40:00 | AAPL | Stock | 7.0411 | 7.0411 | 7.035 | 7.0411 | 346612.0 |
| 2010-02-04 08:45:00 | AAPL | Stock | 7.0421 | 7.0461 | 7.0382 | 7.0393 | 292208.0 |
| 2010-02-04 08:50:00 | AAPL | Stock | 7.0396 | 7.0446 | 7.0375 | 7.0375 | 129892.0 |
| 2010-02-04 08:55:00 | AAPL | Stock | 7.0421 | 7.0443 | 7.0361 | 7.0443 | 154924.0 |
| 2010-02-04 09:00:00 | AAPL | Stock | 7.0439 | 7.0443 | 7.0321 | 7.0339 | 553056.0 |
| 2010-02-04 09:05:00 | AAPL | Stock | 7.0325 | 7.0325 | 7.025 | 7.0286 | 540176.0 |
| 2010-02-04 09:10:00 | AAPL | Stock | 7.0286 | 7.0286 | 7.025 | 7.0286 | 563780.0 |
| 2010-02-04 09:15:00 | AAPL | Stock | 7.0286 | 7.0286 | 7.0157 | 7.0279 | 474068.0 |
| 2010-02-04 09:20:00 | AAPL | Stock | 7.0271 | 7.0286 | 7.025 | 7.0268 | 398804.0 |
| 2010-02-04 09:25:00 | AAPL | Stock | 7.0268 | 7.0289 | 7.025 | 7.0282 | 349020.0 |
| 2010-02-04 09:30:00 | AAPL | Stock | 7.0279 | 7.0632 | 7.0221 | 7.0629 | 18443684.0 |
| 2010-02-04 09:35:00 | AAPL | Stock | 7.0632 | 7.0793 | 7.0511 | 7.0771 | 17350144.0 |
| 2010-02-04 09:40:00 | AAPL | Stock | 7.0793 | 7.0846 | 7.0464 | 7.0504 | 16332064.0 |
| 2010-02-04 09:45:00 | AAPL | Stock | 7.0468 | 7.0625 | 7.0214 | 7.0457 | 21437808.0 |
| 2010-02-04 09:50:00 | AAPL | Stock | 7.0446 | 7.0454 | 7.0232 | 7.0368 | 11058180.0 |
| 2010-02-04 09:55:00 | AAPL | Stock | 7.0343 | 7.0389 | 6.9714 | 6.9839 | 22772036.0 |
| 2010-02-04 10:00:00 | AAPL | Stock | 6.9839 | 7.0036 | 6.9757 | 7.0018 | 13727140.0 |
| 2010-02-04 10:05:00 | AAPL | Stock | 7.0021 | 7.0046 | 6.9807 | 6.9825 | 12524288.0 |
| 2010-02-04 10:10:00 | AAPL | Stock | 6.9832 | 6.9864 | 6.9643 | 6.9775 | 15172192.0 |
| 2010-02-04 10:15:00 | AAPL | Stock | 6.9773 | 6.9893 | 6.9668 | 6.9789 | 10745672.0 |
| 2010-02-04 10:20:00 | AAPL | Stock | 6.9786 | 6.9864 | 6.9714 | 6.9804 | 7247212.0 |
| 2010-02-04 10:25:00 | AAPL | Stock | 6.9789 | 6.9896 | 6.9736 | 6.975 | 9950808.0 |
| 2010-02-04 10:30:00 | AAPL | Stock | 6.9754 | 6.9896 | 6.965 | 6.9825 | 11726652.0 |
> showing 50 of 332,484 rows — these rows as CSV