PREVIEW / stock_5min / 2010-05-17
file: by_date/stock_5min/2010/2010-05-17.parquet size: 5.0 MB rows: 341,838 symbols: 3,475
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-05-17 04:30:00 | AAPL | Stock | 9.0354 | 9.0354 | 9.0354 | 9.0354 | 7000.0 |
| 2010-05-17 05:15:00 | AAPL | Stock | 9.0668 | 9.0668 | 9.0396 | 9.0396 | 11200.0 |
| 2010-05-17 05:35:00 | AAPL | Stock | 9.0675 | 9.0675 | 9.0675 | 9.0675 | 2800.0 |
| 2010-05-17 06:55:00 | AAPL | Stock | 9.0893 | 9.0893 | 9.0893 | 9.0893 | 5600.0 |
| 2010-05-17 07:00:00 | AAPL | Stock | 9.0818 | 9.0818 | 9.0786 | 9.0786 | 33600.0 |
| 2010-05-17 07:05:00 | AAPL | Stock | 9.0814 | 9.0818 | 9.0768 | 9.0818 | 8848.0 |
| 2010-05-17 07:10:00 | AAPL | Stock | 9.0882 | 9.0893 | 9.0882 | 9.0893 | 24080.0 |
| 2010-05-17 07:15:00 | AAPL | Stock | 9.0896 | 9.0896 | 9.0896 | 9.0896 | 2800.0 |
| 2010-05-17 07:20:00 | AAPL | Stock | 9.0982 | 9.1036 | 9.0982 | 9.1036 | 12600.0 |
| 2010-05-17 07:25:00 | AAPL | Stock | 9.1071 | 9.125 | 9.1071 | 9.125 | 14000.0 |
| 2010-05-17 07:30:00 | AAPL | Stock | 9.1254 | 9.1254 | 9.1179 | 9.1179 | 30800.0 |
| 2010-05-17 07:35:00 | AAPL | Stock | 9.1107 | 9.1175 | 9.1107 | 9.1175 | 28756.0 |
| 2010-05-17 07:45:00 | AAPL | Stock | 9.1171 | 9.1171 | 9.1171 | 9.1171 | 5600.0 |
| 2010-05-17 07:50:00 | AAPL | Stock | 9.1107 | 9.125 | 9.1096 | 9.1096 | 36596.0 |
| 2010-05-17 07:55:00 | AAPL | Stock | 9.1164 | 9.1196 | 9.1161 | 9.1196 | 25200.0 |
| 2010-05-17 08:00:00 | AAPL | Stock | 9.1111 | 9.1236 | 9.0982 | 9.1071 | 490840.0 |
| 2010-05-17 08:05:00 | AAPL | Stock | 9.1071 | 9.1179 | 9.1068 | 9.1143 | 119308.0 |
| 2010-05-17 08:10:00 | AAPL | Stock | 9.1143 | 9.1143 | 9.0932 | 9.0968 | 275968.0 |
| 2010-05-17 08:15:00 | AAPL | Stock | 9.0943 | 9.1021 | 9.0907 | 9.0907 | 281596.0 |
| 2010-05-17 08:20:00 | AAPL | Stock | 9.09 | 9.0918 | 9.0679 | 9.0704 | 468440.0 |
| 2010-05-17 08:25:00 | AAPL | Stock | 9.0679 | 9.0693 | 9.0486 | 9.0625 | 689864.0 |
| 2010-05-17 08:30:00 | AAPL | Stock | 9.0648 | 9.0654 | 9.0525 | 9.0582 | 267540.0 |
| 2010-05-17 08:35:00 | AAPL | Stock | 9.0607 | 9.0693 | 9.0589 | 9.0618 | 191240.0 |
| 2010-05-17 08:40:00 | AAPL | Stock | 9.0614 | 9.0625 | 9.0554 | 9.0607 | 99764.0 |
| 2010-05-17 08:45:00 | AAPL | Stock | 9.0589 | 9.0625 | 9.0554 | 9.0571 | 178780.0 |
| 2010-05-17 08:50:00 | AAPL | Stock | 9.0571 | 9.0689 | 9.0561 | 9.0646 | 189448.0 |
| 2010-05-17 08:55:00 | AAPL | Stock | 9.0646 | 9.0646 | 9.0607 | 9.0629 | 66220.0 |
| 2010-05-17 09:00:00 | AAPL | Stock | 9.0629 | 9.0968 | 9.0607 | 9.0893 | 215992.0 |
| 2010-05-17 09:05:00 | AAPL | Stock | 9.0893 | 9.0982 | 9.0893 | 9.0964 | 207900.0 |
| 2010-05-17 09:10:00 | AAPL | Stock | 9.0986 | 9.1179 | 9.0986 | 9.1057 | 847700.0 |
| 2010-05-17 09:15:00 | AAPL | Stock | 9.1071 | 9.1171 | 9.1021 | 9.1054 | 170660.0 |
| 2010-05-17 09:20:00 | AAPL | Stock | 9.105 | 9.1179 | 9.1029 | 9.1179 | 177212.0 |
| 2010-05-17 09:25:00 | AAPL | Stock | 9.1189 | 9.1246 | 9.0932 | 9.0982 | 413000.0 |
| 2010-05-17 09:30:00 | AAPL | Stock | 9.0964 | 9.1246 | 9.075 | 9.1089 | 20554884.0 |
| 2010-05-17 09:35:00 | AAPL | Stock | 9.1091 | 9.1493 | 9.1004 | 9.1389 | 16944592.0 |
| 2010-05-17 09:40:00 | AAPL | Stock | 9.1386 | 9.1482 | 9.1146 | 9.1239 | 15509144.0 |
| 2010-05-17 09:45:00 | AAPL | Stock | 9.1239 | 9.1279 | 9.0821 | 9.11 | 20057044.0 |
| 2010-05-17 09:50:00 | AAPL | Stock | 9.1079 | 9.1196 | 9.0521 | 9.0943 | 19787740.0 |
| 2010-05-17 09:55:00 | AAPL | Stock | 9.0939 | 9.0946 | 9.0579 | 9.0796 | 13272784.0 |
| 2010-05-17 10:00:00 | AAPL | Stock | 9.0796 | 9.0964 | 9.0611 | 9.0671 | 10225152.0 |
| 2010-05-17 10:05:00 | AAPL | Stock | 9.0671 | 9.0871 | 9.06 | 9.0696 | 7228900.0 |
| 2010-05-17 10:10:00 | AAPL | Stock | 9.0679 | 9.1 | 9.0589 | 9.0795 | 10398528.0 |
| 2010-05-17 10:15:00 | AAPL | Stock | 9.0806 | 9.1161 | 9.0796 | 9.1143 | 9512552.0 |
| 2010-05-17 10:20:00 | AAPL | Stock | 9.1121 | 9.1189 | 9.0946 | 9.1057 | 7387940.0 |
| 2010-05-17 10:25:00 | AAPL | Stock | 9.1036 | 9.1161 | 9.0936 | 9.1131 | 6750604.0 |
| 2010-05-17 10:30:00 | AAPL | Stock | 9.1146 | 9.1182 | 9.1004 | 9.1055 | 5054140.0 |
| 2010-05-17 10:35:00 | AAPL | Stock | 9.1071 | 9.1379 | 9.1054 | 9.1223 | 10203760.0 |
| 2010-05-17 10:40:00 | AAPL | Stock | 9.1227 | 9.125 | 9.0864 | 9.09 | 8379532.0 |
| 2010-05-17 10:45:00 | AAPL | Stock | 9.0889 | 9.1046 | 9.0782 | 9.0954 | 6369384.0 |
| 2010-05-17 10:50:00 | AAPL | Stock | 9.0954 | 9.1118 | 9.0839 | 9.105 | 5892908.0 |
> showing 50 of 341,838 rows — these rows as CSV