PREVIEW / stock_5min / 2008-07-16
file: by_date/stock_5min/2008/2008-07-16.parquet size: 4.6 MB rows: 324,868 symbols: 3,356
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-07-16 06:10:00 | AAPL | Stock | 6.0736 | 6.0736 | 6.0736 | 6.0736 | 13692.0 |
| 2008-07-16 06:50:00 | AAPL | Stock | 6.0039 | 6.0039 | 6.0039 | 6.0039 | 5600.0 |
| 2008-07-16 07:00:00 | AAPL | Stock | 6.005 | 6.005 | 6.005 | 6.005 | 2800.0 |
| 2008-07-16 07:15:00 | AAPL | Stock | 6.0268 | 6.0268 | 6.0268 | 6.0268 | 2800.0 |
| 2008-07-16 07:25:00 | AAPL | Stock | 6.0446 | 6.0446 | 6.0446 | 6.0446 | 14000.0 |
| 2008-07-16 07:30:00 | AAPL | Stock | 6.0539 | 6.0539 | 6.0539 | 6.0539 | 2800.0 |
| 2008-07-16 07:35:00 | AAPL | Stock | 6.0707 | 6.0714 | 6.0707 | 6.0714 | 26040.0 |
| 2008-07-16 07:40:00 | AAPL | Stock | 6.0704 | 6.0786 | 6.0704 | 6.0786 | 36400.0 |
| 2008-07-16 07:45:00 | AAPL | Stock | 6.0786 | 6.0786 | 6.0714 | 6.0714 | 8400.0 |
| 2008-07-16 07:55:00 | AAPL | Stock | 6.0714 | 6.0786 | 6.0714 | 6.0786 | 18060.0 |
| 2008-07-16 08:00:00 | AAPL | Stock | 6.0714 | 6.1032 | 6.0711 | 6.0982 | 222348.0 |
| 2008-07-16 08:05:00 | AAPL | Stock | 6.0964 | 6.1 | 6.0768 | 6.0943 | 459200.0 |
| 2008-07-16 08:10:00 | AAPL | Stock | 6.0925 | 6.1225 | 6.0911 | 6.1136 | 211932.0 |
| 2008-07-16 08:15:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1 | 6.1046 | 49140.0 |
| 2008-07-16 08:20:00 | AAPL | Stock | 6.1018 | 6.1018 | 6.0964 | 6.0968 | 109340.0 |
| 2008-07-16 08:25:00 | AAPL | Stock | 6.1 | 6.1071 | 6.1 | 6.1071 | 78568.0 |
| 2008-07-16 08:30:00 | AAPL | Stock | 6.1075 | 6.1075 | 6.0714 | 6.0843 | 646856.0 |
| 2008-07-16 08:35:00 | AAPL | Stock | 6.0864 | 6.1068 | 6.0864 | 6.1036 | 276864.0 |
| 2008-07-16 08:40:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.0921 | 6.095 | 253036.0 |
| 2008-07-16 08:45:00 | AAPL | Stock | 6.1014 | 6.1054 | 6.0964 | 6.105 | 240940.0 |
| 2008-07-16 08:50:00 | AAPL | Stock | 6.0982 | 6.0993 | 6.0843 | 6.0904 | 584192.0 |
| 2008-07-16 08:55:00 | AAPL | Stock | 6.0893 | 6.1 | 6.0821 | 6.1 | 76160.0 |
| 2008-07-16 09:00:00 | AAPL | Stock | 6.1018 | 6.1143 | 6.1018 | 6.1143 | 361480.0 |
| 2008-07-16 09:05:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1061 | 6.1107 | 117572.0 |
| 2008-07-16 09:10:00 | AAPL | Stock | 6.11 | 6.1111 | 6.1071 | 6.1079 | 164780.0 |
| 2008-07-16 09:15:00 | AAPL | Stock | 6.1075 | 6.11 | 6.1071 | 6.1071 | 162400.0 |
| 2008-07-16 09:20:00 | AAPL | Stock | 6.1071 | 6.1075 | 6.1043 | 6.1043 | 198268.0 |
| 2008-07-16 09:25:00 | AAPL | Stock | 6.1021 | 6.1021 | 6.0714 | 6.0761 | 1008028.0 |
| 2008-07-16 09:30:00 | AAPL | Stock | 6.0786 | 6.0854 | 6.0214 | 6.0421 | 23568860.0 |
| 2008-07-16 09:35:00 | AAPL | Stock | 6.0425 | 6.1071 | 6.03 | 6.0679 | 22241324.0 |
| 2008-07-16 09:40:00 | AAPL | Stock | 6.0679 | 6.0961 | 6.0357 | 6.0357 | 14283780.0 |
| 2008-07-16 09:45:00 | AAPL | Stock | 6.0357 | 6.0714 | 6.0318 | 6.0332 | 13321924.0 |
| 2008-07-16 09:50:00 | AAPL | Stock | 6.0337 | 6.0804 | 6.0279 | 6.0718 | 17666824.0 |
| 2008-07-16 09:55:00 | AAPL | Stock | 6.0701 | 6.0993 | 6.0701 | 6.0782 | 14221620.0 |
| 2008-07-16 10:00:00 | AAPL | Stock | 6.0786 | 6.1054 | 6.0732 | 6.1029 | 13972420.0 |
| 2008-07-16 10:05:00 | AAPL | Stock | 6.1036 | 6.1143 | 6.0857 | 6.0946 | 11468408.0 |
| 2008-07-16 10:10:00 | AAPL | Stock | 6.095 | 6.0982 | 6.0557 | 6.0661 | 11097016.0 |
| 2008-07-16 10:15:00 | AAPL | Stock | 6.0668 | 6.075 | 6.0536 | 6.0539 | 7520296.0 |
| 2008-07-16 10:20:00 | AAPL | Stock | 6.0536 | 6.0871 | 6.0536 | 6.0779 | 8915200.0 |
| 2008-07-16 10:25:00 | AAPL | Stock | 6.0775 | 6.0854 | 6.0643 | 6.0761 | 5956300.0 |
| 2008-07-16 10:30:00 | AAPL | Stock | 6.0758 | 6.0871 | 6.0682 | 6.0718 | 6712748.0 |
| 2008-07-16 10:35:00 | AAPL | Stock | 6.0729 | 6.1193 | 6.0714 | 6.1175 | 18637752.0 |
| 2008-07-16 10:40:00 | AAPL | Stock | 6.1171 | 6.1354 | 6.1071 | 6.1079 | 14320768.0 |
| 2008-07-16 10:45:00 | AAPL | Stock | 6.1086 | 6.1225 | 6.1018 | 6.1071 | 11339496.0 |
| 2008-07-16 10:50:00 | AAPL | Stock | 6.1082 | 6.1129 | 6.095 | 6.1054 | 8388576.0 |
| 2008-07-16 10:55:00 | AAPL | Stock | 6.1057 | 6.1125 | 6.0779 | 6.0889 | 11134144.0 |
| 2008-07-16 11:00:00 | AAPL | Stock | 6.0879 | 6.1154 | 6.0871 | 6.115 | 11275460.0 |
| 2008-07-16 11:05:00 | AAPL | Stock | 6.1143 | 6.1175 | 6.0986 | 6.0993 | 10386600.0 |
| 2008-07-16 11:10:00 | AAPL | Stock | 6.0993 | 6.1071 | 6.0914 | 6.0957 | 9534532.0 |
| 2008-07-16 11:15:00 | AAPL | Stock | 6.0954 | 6.0982 | 6.0789 | 6.0871 | 7904456.0 |
> showing 50 of 324,868 rows — these rows as CSV