PREVIEW / stock_5min / 2008-07-15
file: by_date/stock_5min/2008/2008-07-15.parquet size: 4.7 MB rows: 332,083 symbols: 3,365
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-15 04:20:00 | AAPL | Stock | 6.1786 | 6.1786 | 6.1786 | 6.1786 | 2800.0 |
| 2008-07-15 05:20:00 | AAPL | Stock | 6.1607 | 6.1607 | 6.1607 | 6.1607 | 2800.0 |
| 2008-07-15 06:35:00 | AAPL | Stock | 6.1325 | 6.1325 | 6.1321 | 6.1321 | 36400.0 |
| 2008-07-15 06:45:00 | AAPL | Stock | 6.1168 | 6.1168 | 6.0946 | 6.0946 | 145600.0 |
| 2008-07-15 06:50:00 | AAPL | Stock | 6.095 | 6.095 | 6.0911 | 6.0911 | 106400.0 |
| 2008-07-15 07:05:00 | AAPL | Stock | 6.1161 | 6.1225 | 6.1161 | 6.1225 | 15400.0 |
| 2008-07-15 07:10:00 | AAPL | Stock | 6.1207 | 6.1207 | 6.0761 | 6.095 | 231000.0 |
| 2008-07-15 07:15:00 | AAPL | Stock | 6.0768 | 6.0768 | 6.0661 | 6.0661 | 130200.0 |
| 2008-07-15 07:20:00 | AAPL | Stock | 6.1029 | 6.1029 | 6.1029 | 6.1029 | 5600.0 |
| 2008-07-15 07:30:00 | AAPL | Stock | 6.1029 | 6.1029 | 6.0893 | 6.0911 | 30800.0 |
| 2008-07-15 07:35:00 | AAPL | Stock | 6.0893 | 6.0893 | 6.0893 | 6.0893 | 8400.0 |
| 2008-07-15 07:45:00 | AAPL | Stock | 6.0821 | 6.0893 | 6.0821 | 6.0893 | 38920.0 |
| 2008-07-15 07:50:00 | AAPL | Stock | 6.0893 | 6.0929 | 6.0857 | 6.0929 | 65212.0 |
| 2008-07-15 07:55:00 | AAPL | Stock | 6.0961 | 6.1054 | 6.0929 | 6.1054 | 253428.0 |
| 2008-07-15 08:00:00 | AAPL | Stock | 6.0868 | 6.1071 | 6.0857 | 6.0964 | 334040.0 |
| 2008-07-15 08:05:00 | AAPL | Stock | 6.0961 | 6.0964 | 6.0854 | 6.0964 | 268352.0 |
| 2008-07-15 08:10:00 | AAPL | Stock | 6.0946 | 6.1175 | 6.0946 | 6.1075 | 594496.0 |
| 2008-07-15 08:15:00 | AAPL | Stock | 6.1107 | 6.1143 | 6.1036 | 6.1075 | 557200.0 |
| 2008-07-15 08:20:00 | AAPL | Stock | 6.1075 | 6.1139 | 6.0893 | 6.1086 | 398720.0 |
| 2008-07-15 08:25:00 | AAPL | Stock | 6.1075 | 6.1143 | 6.1039 | 6.1089 | 214900.0 |
| 2008-07-15 08:30:00 | AAPL | Stock | 6.1089 | 6.1214 | 6.1018 | 6.1114 | 917840.0 |
| 2008-07-15 08:35:00 | AAPL | Stock | 6.1121 | 6.1311 | 6.1104 | 6.1204 | 353500.0 |
| 2008-07-15 08:40:00 | AAPL | Stock | 6.1232 | 6.1339 | 6.1232 | 6.1289 | 327320.0 |
| 2008-07-15 08:45:00 | AAPL | Stock | 6.1268 | 6.1357 | 6.1268 | 6.1289 | 220220.0 |
| 2008-07-15 08:50:00 | AAPL | Stock | 6.1264 | 6.1264 | 6.125 | 6.125 | 47600.0 |
| 2008-07-15 08:55:00 | AAPL | Stock | 6.125 | 6.1275 | 6.1125 | 6.1275 | 153832.0 |
| 2008-07-15 09:00:00 | AAPL | Stock | 6.1286 | 6.1318 | 6.125 | 6.1254 | 178192.0 |
| 2008-07-15 09:05:00 | AAPL | Stock | 6.1271 | 6.13 | 6.1107 | 6.1125 | 437612.0 |
| 2008-07-15 09:10:00 | AAPL | Stock | 6.1125 | 6.1286 | 6.1107 | 6.1232 | 385084.0 |
| 2008-07-15 09:15:00 | AAPL | Stock | 6.1275 | 6.135 | 6.125 | 6.1325 | 194040.0 |
| 2008-07-15 09:20:00 | AAPL | Stock | 6.1289 | 6.1389 | 6.1286 | 6.1389 | 253568.0 |
| 2008-07-15 09:25:00 | AAPL | Stock | 6.1393 | 6.1643 | 6.1386 | 6.1596 | 1728496.0 |
| 2008-07-15 09:30:00 | AAPL | Stock | 6.16 | 6.1782 | 6.0929 | 6.1161 | 29226512.0 |
| 2008-07-15 09:35:00 | AAPL | Stock | 6.1171 | 6.1304 | 6.075 | 6.1279 | 26118988.0 |
| 2008-07-15 09:40:00 | AAPL | Stock | 6.1279 | 6.1389 | 6.1046 | 6.1218 | 14192864.0 |
| 2008-07-15 09:45:00 | AAPL | Stock | 6.1218 | 6.1464 | 6.1032 | 6.12 | 15207500.0 |
| 2008-07-15 09:50:00 | AAPL | Stock | 6.1196 | 6.1196 | 6.0675 | 6.0731 | 25809980.0 |
| 2008-07-15 09:55:00 | AAPL | Stock | 6.0729 | 6.0882 | 6.0393 | 6.0821 | 21860860.0 |
| 2008-07-15 10:00:00 | AAPL | Stock | 6.0821 | 6.0854 | 6.0079 | 6.0346 | 32469668.0 |
| 2008-07-15 10:05:00 | AAPL | Stock | 6.0336 | 6.0343 | 5.9425 | 5.9725 | 36871296.0 |
| 2008-07-15 10:10:00 | AAPL | Stock | 5.9725 | 6.0 | 5.9546 | 5.9921 | 24691856.0 |
| 2008-07-15 10:15:00 | AAPL | Stock | 5.9882 | 6.0325 | 5.9825 | 6.0261 | 21262808.0 |
| 2008-07-15 10:20:00 | AAPL | Stock | 6.0274 | 6.0386 | 5.9939 | 6.0143 | 16747892.0 |
| 2008-07-15 10:25:00 | AAPL | Stock | 6.0143 | 6.0189 | 5.9775 | 6.0096 | 14622300.0 |
| 2008-07-15 10:30:00 | AAPL | Stock | 6.0089 | 6.0161 | 5.9568 | 5.965 | 16259516.0 |
| 2008-07-15 10:35:00 | AAPL | Stock | 5.9668 | 6.0061 | 5.9643 | 6.0061 | 12475484.0 |
| 2008-07-15 10:40:00 | AAPL | Stock | 6.0061 | 6.0514 | 6.0027 | 6.0482 | 13159804.0 |
| 2008-07-15 10:45:00 | AAPL | Stock | 6.0489 | 6.0496 | 6.0043 | 6.0425 | 17864616.0 |
| 2008-07-15 10:50:00 | AAPL | Stock | 6.0425 | 6.0757 | 6.0257 | 6.06 | 20646444.0 |
| 2008-07-15 10:55:00 | AAPL | Stock | 6.0596 | 6.0607 | 6.0429 | 6.0471 | 8565956.0 |
> showing 50 of 332,083 rows — these rows as CSV