PREVIEW / stock_5min / 2008-03-26
file: by_date/stock_5min/2008/2008-03-26.parquet size: 4.3 MB rows: 313,552 symbols: 3,289
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-03-26 05:25:00 | AAPL | Stock | 5.02 | 5.02 | 5.02 | 5.02 | 2800.0 |
| 2008-03-26 05:40:00 | AAPL | Stock | 5.0357 | 5.0357 | 5.0357 | 5.0357 | 2800.0 |
| 2008-03-26 06:35:00 | AAPL | Stock | 5.0493 | 5.0493 | 5.0493 | 5.0493 | 2800.0 |
| 2008-03-26 07:00:00 | AAPL | Stock | 5.0407 | 5.0464 | 5.0268 | 5.0268 | 67200.0 |
| 2008-03-26 07:05:00 | AAPL | Stock | 5.0268 | 5.0268 | 5.0268 | 5.0268 | 28000.0 |
| 2008-03-26 07:25:00 | AAPL | Stock | 5.0114 | 5.0114 | 5.0114 | 5.0114 | 5600.0 |
| 2008-03-26 07:35:00 | AAPL | Stock | 5.0207 | 5.0211 | 5.0207 | 5.0211 | 40600.0 |
| 2008-03-26 07:50:00 | AAPL | Stock | 5.0093 | 5.0093 | 5.0093 | 5.0093 | 2800.0 |
| 2008-03-26 07:55:00 | AAPL | Stock | 5.0146 | 5.0171 | 5.0146 | 5.0146 | 68600.0 |
| 2008-03-26 08:00:00 | AAPL | Stock | 5.0146 | 5.0268 | 5.005 | 5.0207 | 334012.0 |
| 2008-03-26 08:05:00 | AAPL | Stock | 5.0236 | 5.0243 | 5.0179 | 5.0214 | 84756.0 |
| 2008-03-26 08:10:00 | AAPL | Stock | 5.0214 | 5.035 | 5.0179 | 5.0214 | 7387352.0 |
| 2008-03-26 08:15:00 | AAPL | Stock | 5.0214 | 5.0271 | 5.0214 | 5.0268 | 242564.0 |
| 2008-03-26 08:20:00 | AAPL | Stock | 5.0268 | 5.0268 | 5.015 | 5.0179 | 440468.0 |
| 2008-03-26 08:25:00 | AAPL | Stock | 5.0225 | 5.0232 | 5.0179 | 5.0179 | 78484.0 |
| 2008-03-26 08:30:00 | AAPL | Stock | 5.0136 | 5.0136 | 5.0 | 5.0025 | 599424.0 |
| 2008-03-26 08:35:00 | AAPL | Stock | 5.0029 | 5.0039 | 5.0 | 5.0007 | 74060.0 |
| 2008-03-26 08:40:00 | AAPL | Stock | 5.0021 | 5.0068 | 5.0 | 5.0 | 317688.0 |
| 2008-03-26 08:45:00 | AAPL | Stock | 5.0 | 5.0143 | 4.9993 | 5.0139 | 365120.0 |
| 2008-03-26 08:50:00 | AAPL | Stock | 5.0132 | 5.0143 | 5.0054 | 5.01 | 84980.0 |
| 2008-03-26 08:55:00 | AAPL | Stock | 5.005 | 5.0068 | 5.0014 | 5.0046 | 134820.0 |
| 2008-03-26 09:00:00 | AAPL | Stock | 5.0011 | 5.0036 | 5.0 | 5.0036 | 69160.0 |
| 2008-03-26 09:05:00 | AAPL | Stock | 5.0036 | 5.0057 | 5.0007 | 5.0036 | 160104.0 |
| 2008-03-26 09:10:00 | AAPL | Stock | 5.0061 | 5.0175 | 5.0061 | 5.0107 | 290724.0 |
| 2008-03-26 09:15:00 | AAPL | Stock | 5.0111 | 5.0182 | 5.0111 | 5.0179 | 164444.0 |
| 2008-03-26 09:20:00 | AAPL | Stock | 5.0179 | 5.0311 | 5.0179 | 5.0196 | 451920.0 |
| 2008-03-26 09:25:00 | AAPL | Stock | 5.0229 | 5.035 | 5.0182 | 5.0304 | 519708.0 |
| 2008-03-26 09:30:00 | AAPL | Stock | 5.0307 | 5.0707 | 5.0229 | 5.0543 | 25315108.0 |
| 2008-03-26 09:35:00 | AAPL | Stock | 5.0546 | 5.0846 | 5.0396 | 5.0807 | 30317168.0 |
| 2008-03-26 09:40:00 | AAPL | Stock | 5.08 | 5.1122 | 5.0789 | 5.0986 | 30306612.0 |
| 2008-03-26 09:45:00 | AAPL | Stock | 5.1007 | 5.1025 | 5.0786 | 5.085 | 23586724.0 |
| 2008-03-26 09:50:00 | AAPL | Stock | 5.085 | 5.1011 | 5.0793 | 5.0925 | 19703572.0 |
| 2008-03-26 09:55:00 | AAPL | Stock | 5.0925 | 5.0968 | 5.075 | 5.0764 | 18695600.0 |
| 2008-03-26 10:00:00 | AAPL | Stock | 5.0757 | 5.0943 | 5.0646 | 5.0779 | 23279032.0 |
| 2008-03-26 10:05:00 | AAPL | Stock | 5.0782 | 5.1039 | 5.0743 | 5.1021 | 18016908.0 |
| 2008-03-26 10:10:00 | AAPL | Stock | 5.1018 | 5.1161 | 5.0975 | 5.1071 | 21980896.0 |
| 2008-03-26 10:15:00 | AAPL | Stock | 5.1079 | 5.1304 | 5.1068 | 5.1259 | 23451932.0 |
| 2008-03-26 10:20:00 | AAPL | Stock | 5.1246 | 5.1454 | 5.1232 | 5.1379 | 24060120.0 |
| 2008-03-26 10:25:00 | AAPL | Stock | 5.1377 | 5.1411 | 5.1189 | 5.1368 | 19230624.0 |
| 2008-03-26 10:30:00 | AAPL | Stock | 5.1364 | 5.1368 | 5.1129 | 5.1161 | 18831260.0 |
| 2008-03-26 10:35:00 | AAPL | Stock | 5.116 | 5.1343 | 5.115 | 5.1164 | 14764316.0 |
| 2008-03-26 10:40:00 | AAPL | Stock | 5.1164 | 5.1264 | 5.1036 | 5.1193 | 15899716.0 |
| 2008-03-26 10:45:00 | AAPL | Stock | 5.1182 | 5.1196 | 5.11 | 5.1114 | 15623076.0 |
| 2008-03-26 10:50:00 | AAPL | Stock | 5.1114 | 5.1357 | 5.1111 | 5.1341 | 14352576.0 |
| 2008-03-26 10:55:00 | AAPL | Stock | 5.1343 | 5.1596 | 5.1336 | 5.1593 | 25354812.0 |
| 2008-03-26 11:00:00 | AAPL | Stock | 5.1582 | 5.1586 | 5.1429 | 5.1454 | 18308948.0 |
| 2008-03-26 11:05:00 | AAPL | Stock | 5.145 | 5.15 | 5.1375 | 5.1475 | 16480744.0 |
| 2008-03-26 11:10:00 | AAPL | Stock | 5.1479 | 5.1575 | 5.1439 | 5.1475 | 9595152.0 |
| 2008-03-26 11:15:00 | AAPL | Stock | 5.1489 | 5.1525 | 5.1357 | 5.1496 | 9843988.0 |
| 2008-03-26 11:20:00 | AAPL | Stock | 5.1486 | 5.1554 | 5.1446 | 5.1528 | 9064244.0 |
> showing 50 of 313,552 rows — these rows as CSV