PREVIEW / stock_5min / 2009-12-10
file: by_date/stock_5min/2009/2009-12-10.parquet size: 4.6 MB rows: 313,334 symbols: 3,427
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-10 07:00:00 | AAPL | Stock | 7.0918 | 7.0918 | 7.0911 | 7.0911 | 13692.0 |
| 2009-12-10 07:05:00 | AAPL | Stock | 7.0918 | 7.0921 | 7.0764 | 7.0764 | 18648.0 |
| 2009-12-10 07:10:00 | AAPL | Stock | 7.0768 | 7.0789 | 7.0768 | 7.0789 | 8400.0 |
| 2009-12-10 07:15:00 | AAPL | Stock | 7.0804 | 7.0804 | 7.0804 | 7.0804 | 2800.0 |
| 2009-12-10 07:20:00 | AAPL | Stock | 7.0789 | 7.0929 | 7.0789 | 7.0893 | 78260.0 |
| 2009-12-10 07:25:00 | AAPL | Stock | 7.0929 | 7.1 | 7.0929 | 7.0964 | 54460.0 |
| 2009-12-10 07:30:00 | AAPL | Stock | 7.0982 | 7.1121 | 7.0982 | 7.1079 | 122304.0 |
| 2009-12-10 07:35:00 | AAPL | Stock | 7.1111 | 7.1179 | 7.1111 | 7.1179 | 174860.0 |
| 2009-12-10 07:40:00 | AAPL | Stock | 7.1214 | 7.1429 | 7.1182 | 7.1321 | 285656.0 |
| 2009-12-10 07:45:00 | AAPL | Stock | 7.1339 | 7.1379 | 7.1286 | 7.1286 | 144424.0 |
| 2009-12-10 07:50:00 | AAPL | Stock | 7.1286 | 7.1332 | 7.1264 | 7.1286 | 80836.0 |
| 2009-12-10 07:55:00 | AAPL | Stock | 7.1218 | 7.1221 | 7.1179 | 7.1189 | 105000.0 |
| 2009-12-10 08:00:00 | AAPL | Stock | 7.1232 | 7.1232 | 7.1043 | 7.1139 | 847224.0 |
| 2009-12-10 08:05:00 | AAPL | Stock | 7.1107 | 7.1143 | 7.1089 | 7.1114 | 242620.0 |
| 2009-12-10 08:10:00 | AAPL | Stock | 7.1129 | 7.1143 | 7.1107 | 7.1107 | 293384.0 |
| 2009-12-10 08:15:00 | AAPL | Stock | 7.1107 | 7.1161 | 7.1079 | 7.1118 | 386036.0 |
| 2009-12-10 08:20:00 | AAPL | Stock | 7.1118 | 7.1275 | 7.1114 | 7.125 | 655900.0 |
| 2009-12-10 08:25:00 | AAPL | Stock | 7.1273 | 7.1277 | 7.1157 | 7.1157 | 153664.0 |
| 2009-12-10 08:30:00 | AAPL | Stock | 7.1146 | 7.1375 | 7.1125 | 7.1368 | 1062152.0 |
| 2009-12-10 08:35:00 | AAPL | Stock | 7.1346 | 7.1375 | 7.1286 | 7.1318 | 732592.0 |
| 2009-12-10 08:40:00 | AAPL | Stock | 7.1296 | 7.1336 | 7.125 | 7.1336 | 467124.0 |
| 2009-12-10 08:45:00 | AAPL | Stock | 7.1307 | 7.1321 | 7.125 | 7.1257 | 284480.0 |
| 2009-12-10 08:50:00 | AAPL | Stock | 7.1257 | 7.1268 | 7.1139 | 7.1168 | 349720.0 |
| 2009-12-10 08:55:00 | AAPL | Stock | 7.1161 | 7.1196 | 7.1143 | 7.1196 | 294056.0 |
| 2009-12-10 09:00:00 | AAPL | Stock | 7.1204 | 7.1214 | 7.1114 | 7.1114 | 308308.0 |
| 2009-12-10 09:05:00 | AAPL | Stock | 7.1137 | 7.1225 | 7.1136 | 7.1168 | 404768.0 |
| 2009-12-10 09:10:00 | AAPL | Stock | 7.1179 | 7.1218 | 7.1179 | 7.1196 | 306936.0 |
| 2009-12-10 09:15:00 | AAPL | Stock | 7.1207 | 7.125 | 7.1196 | 7.1211 | 375200.0 |
| 2009-12-10 09:20:00 | AAPL | Stock | 7.1207 | 7.125 | 7.1146 | 7.1182 | 369572.0 |
| 2009-12-10 09:25:00 | AAPL | Stock | 7.1182 | 7.1282 | 7.1164 | 7.1246 | 645176.0 |
| 2009-12-10 09:30:00 | AAPL | Stock | 7.1246 | 7.1321 | 7.0804 | 7.1111 | 31901128.0 |
| 2009-12-10 09:35:00 | AAPL | Stock | 7.1129 | 7.1246 | 7.0979 | 7.105 | 16513756.0 |
| 2009-12-10 09:40:00 | AAPL | Stock | 7.1061 | 7.1104 | 7.0771 | 7.0779 | 17527188.0 |
| 2009-12-10 09:45:00 | AAPL | Stock | 7.08 | 7.0814 | 7.0625 | 7.0639 | 17122728.0 |
| 2009-12-10 09:50:00 | AAPL | Stock | 7.0675 | 7.0675 | 7.0425 | 7.0536 | 20619032.0 |
| 2009-12-10 09:55:00 | AAPL | Stock | 7.0539 | 7.0764 | 7.0525 | 7.0618 | 11971316.0 |
| 2009-12-10 10:00:00 | AAPL | Stock | 7.0618 | 7.0657 | 7.0464 | 7.06 | 9696232.0 |
| 2009-12-10 10:05:00 | AAPL | Stock | 7.0589 | 7.075 | 7.0475 | 7.0691 | 10608528.0 |
| 2009-12-10 10:10:00 | AAPL | Stock | 7.0696 | 7.0864 | 7.0539 | 7.0804 | 8424360.0 |
| 2009-12-10 10:15:00 | AAPL | Stock | 7.0787 | 7.0946 | 7.0732 | 7.0779 | 9574712.0 |
| 2009-12-10 10:20:00 | AAPL | Stock | 7.0779 | 7.0886 | 7.0739 | 7.0832 | 5439924.0 |
| 2009-12-10 10:25:00 | AAPL | Stock | 7.0839 | 7.0886 | 7.0718 | 7.0761 | 6226948.0 |
| 2009-12-10 10:30:00 | AAPL | Stock | 7.0761 | 7.0868 | 7.0733 | 7.0789 | 5521432.0 |
| 2009-12-10 10:35:00 | AAPL | Stock | 7.0789 | 7.0793 | 7.0625 | 7.0736 | 7088536.0 |
| 2009-12-10 10:40:00 | AAPL | Stock | 7.0737 | 7.0832 | 7.0696 | 7.0743 | 5399688.0 |
| 2009-12-10 10:45:00 | AAPL | Stock | 7.0732 | 7.0764 | 7.0636 | 7.0693 | 5372920.0 |
| 2009-12-10 10:50:00 | AAPL | Stock | 7.0693 | 7.0721 | 7.05 | 7.0521 | 6722744.0 |
| 2009-12-10 10:55:00 | AAPL | Stock | 7.0514 | 7.0546 | 7.0432 | 7.0539 | 7582148.0 |
| 2009-12-10 11:00:00 | AAPL | Stock | 7.0536 | 7.0664 | 7.0479 | 7.0643 | 4933460.0 |
| 2009-12-10 11:05:00 | AAPL | Stock | 7.0643 | 7.0729 | 7.0625 | 7.0664 | 4614344.0 |
> showing 50 of 313,334 rows — these rows as CSV