PREVIEW / stock_5min / 2007-03-05
file: by_date/stock_5min/2007/2007-03-05.parquet size: 3.9 MB rows: 273,010 symbols: 2,539
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 |
|---|---|---|---|---|---|---|---|
| 2007-03-05 04:55:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 14700.0 |
| 2007-03-05 06:05:00 | AAPL | Stock | 2.9921 | 2.9921 | 2.9921 | 2.9921 | 28000.0 |
| 2007-03-05 06:20:00 | AAPL | Stock | 2.9893 | 2.9893 | 2.9893 | 2.9893 | 14000.0 |
| 2007-03-05 06:30:00 | AAPL | Stock | 2.9986 | 3.0018 | 2.9986 | 3.0018 | 11200.0 |
| 2007-03-05 06:35:00 | AAPL | Stock | 3.03 | 3.03 | 3.0232 | 3.0246 | 95200.0 |
| 2007-03-05 06:40:00 | AAPL | Stock | 3.0286 | 3.035 | 3.0111 | 3.0111 | 79240.0 |
| 2007-03-05 06:45:00 | AAPL | Stock | 3.0286 | 3.0321 | 3.0286 | 3.0321 | 5600.0 |
| 2007-03-05 06:50:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0257 | 3.0257 | 33600.0 |
| 2007-03-05 06:55:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 5600.0 |
| 2007-03-05 07:00:00 | AAPL | Stock | 3.035 | 3.0357 | 3.0214 | 3.0286 | 31220.0 |
| 2007-03-05 07:05:00 | AAPL | Stock | 3.0286 | 3.0357 | 3.025 | 3.0293 | 95676.0 |
| 2007-03-05 07:10:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0339 | 3.0339 | 19600.0 |
| 2007-03-05 07:20:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0286 | 3.0286 | 42000.0 |
| 2007-03-05 07:25:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 43400.0 |
| 2007-03-05 07:30:00 | AAPL | Stock | 3.0286 | 3.0329 | 3.0286 | 3.0329 | 63000.0 |
| 2007-03-05 07:35:00 | AAPL | Stock | 3.0332 | 3.0443 | 3.0321 | 3.0443 | 100128.0 |
| 2007-03-05 07:40:00 | AAPL | Stock | 3.0404 | 3.0446 | 3.0396 | 3.0443 | 296800.0 |
| 2007-03-05 07:45:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0429 | 3.0429 | 39340.0 |
| 2007-03-05 07:50:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0375 | 3.0379 | 44660.0 |
| 2007-03-05 07:55:00 | AAPL | Stock | 3.0411 | 3.0461 | 3.0375 | 3.0446 | 214340.0 |
| 2007-03-05 08:00:00 | AAPL | Stock | 3.04 | 3.0457 | 3.0357 | 3.0414 | 751800.0 |
| 2007-03-05 08:05:00 | AAPL | Stock | 3.0404 | 3.0418 | 3.0393 | 3.0404 | 473256.0 |
| 2007-03-05 08:10:00 | AAPL | Stock | 3.0407 | 3.0421 | 3.0382 | 3.0421 | 730436.0 |
| 2007-03-05 08:15:00 | AAPL | Stock | 3.0421 | 3.045 | 3.0418 | 3.0429 | 352184.0 |
| 2007-03-05 08:20:00 | AAPL | Stock | 3.0421 | 3.045 | 3.0418 | 3.045 | 75040.0 |
| 2007-03-05 08:25:00 | AAPL | Stock | 3.0429 | 3.0529 | 3.0429 | 3.05 | 1002624.0 |
| 2007-03-05 08:30:00 | AAPL | Stock | 3.05 | 3.0529 | 3.0479 | 3.0504 | 341040.0 |
| 2007-03-05 08:35:00 | AAPL | Stock | 3.0504 | 3.0679 | 3.0504 | 3.0661 | 817656.0 |
| 2007-03-05 08:40:00 | AAPL | Stock | 3.0643 | 3.0696 | 3.0625 | 3.0625 | 628572.0 |
| 2007-03-05 08:45:00 | AAPL | Stock | 3.0636 | 3.0636 | 3.0571 | 3.0607 | 83328.0 |
| 2007-03-05 08:50:00 | AAPL | Stock | 3.0607 | 3.0714 | 3.0589 | 3.0714 | 1012900.0 |
| 2007-03-05 08:55:00 | AAPL | Stock | 3.0714 | 3.0804 | 3.0696 | 3.0714 | 925540.0 |
| 2007-03-05 09:00:00 | AAPL | Stock | 3.0732 | 3.0732 | 3.0696 | 3.0707 | 291872.0 |
| 2007-03-05 09:05:00 | AAPL | Stock | 3.0704 | 3.0732 | 3.0643 | 3.0729 | 1021020.0 |
| 2007-03-05 09:10:00 | AAPL | Stock | 3.0725 | 3.0732 | 3.0661 | 3.0693 | 418460.0 |
| 2007-03-05 09:15:00 | AAPL | Stock | 3.0689 | 3.0754 | 3.0636 | 3.0754 | 721868.0 |
| 2007-03-05 09:20:00 | AAPL | Stock | 3.0732 | 3.0796 | 3.0732 | 3.0779 | 507612.0 |
| 2007-03-05 09:25:00 | AAPL | Stock | 3.0779 | 3.0779 | 3.065 | 3.0668 | 693560.0 |
| 2007-03-05 09:30:00 | AAPL | Stock | 3.0675 | 3.1429 | 3.0629 | 3.065 | 29469104.0 |
| 2007-03-05 09:35:00 | AAPL | Stock | 3.0654 | 3.0896 | 3.065 | 3.0871 | 25199496.0 |
| 2007-03-05 09:40:00 | AAPL | Stock | 3.0879 | 3.1661 | 3.0771 | 3.0904 | 20879096.0 |
| 2007-03-05 09:45:00 | AAPL | Stock | 3.0904 | 3.1032 | 3.0825 | 3.1011 | 17119284.0 |
| 2007-03-05 09:50:00 | AAPL | Stock | 3.1007 | 3.1139 | 3.0893 | 3.1139 | 22246196.0 |
| 2007-03-05 09:55:00 | AAPL | Stock | 3.1136 | 3.1189 | 3.1054 | 3.1182 | 21393232.0 |
| 2007-03-05 10:00:00 | AAPL | Stock | 3.1186 | 3.1186 | 3.1021 | 3.1071 | 23387224.0 |
| 2007-03-05 10:05:00 | AAPL | Stock | 3.1075 | 3.1143 | 3.0964 | 3.1132 | 17431064.0 |
| 2007-03-05 10:10:00 | AAPL | Stock | 3.1132 | 3.1282 | 3.1125 | 3.1218 | 28022680.0 |
| 2007-03-05 10:15:00 | AAPL | Stock | 3.1218 | 3.1236 | 3.1143 | 3.1157 | 14074872.0 |
| 2007-03-05 10:20:00 | AAPL | Stock | 3.1157 | 3.1232 | 3.1136 | 3.1218 | 13498408.0 |
| 2007-03-05 10:25:00 | AAPL | Stock | 3.1221 | 3.1221 | 3.1075 | 3.1121 | 13097588.0 |
> showing 50 of 273,010 rows — these rows as CSV