PREVIEW / stock_1hour / 2003-10-08
file: by_date/stock_1hour/2003/2003-10-08.parquet size: 470 KB rows: 22,253 symbols: 1,637
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-08 08:00:00 | AAPL | Stock | 0.4188 | 0.4188 | 0.4188 | 0.4188 | 5600.0 |
| 2003-10-08 09:00:00 | AAPL | Stock | 0.4188 | 0.4204 | 0.4125 | 0.4145 | 44433144.0 |
| 2003-10-08 10:00:00 | AAPL | Stock | 0.4145 | 0.4159 | 0.413 | 0.413 | 88429152.0 |
| 2003-10-08 11:00:00 | AAPL | Stock | 0.4134 | 0.4161 | 0.4109 | 0.4155 | 77039816.0 |
| 2003-10-08 12:00:00 | AAPL | Stock | 0.4155 | 0.4157 | 0.4109 | 0.4127 | 23934736.0 |
| 2003-10-08 13:00:00 | AAPL | Stock | 0.413 | 0.4132 | 0.4091 | 0.4098 | 53035920.0 |
| 2003-10-08 14:00:00 | AAPL | Stock | 0.4098 | 0.4114 | 0.4059 | 0.4109 | 39946088.0 |
| 2003-10-08 15:00:00 | AAPL | Stock | 0.4109 | 0.4134 | 0.4105 | 0.4111 | 38552304.0 |
| 2003-10-08 16:00:00 | AAPL | Stock | 0.4113 | 0.4127 | 0.4107 | 0.4113 | 2352168.0 |
| 2003-10-08 17:00:00 | AAPL | Stock | 0.412 | 0.412 | 0.4111 | 0.4111 | 100800.0 |
| 2003-10-08 08:00:00 | MSFT | Stock | 29.13 | 29.29 | 29.13 | 29.17 | 169091.0 |
| 2003-10-08 09:00:00 | MSFT | Stock | 29.17 | 29.6 | 29.06 | 29.23 | 8136321.0 |
| 2003-10-08 10:00:00 | MSFT | Stock | 29.23 | 29.297 | 28.9 | 28.92 | 10405508.0 |
| 2003-10-08 11:00:00 | MSFT | Stock | 28.92 | 29.0 | 28.86 | 28.94 | 5463362.0 |
| 2003-10-08 12:00:00 | MSFT | Stock | 28.94 | 28.99 | 28.89 | 28.95 | 2754222.0 |
| 2003-10-08 13:00:00 | MSFT | Stock | 28.95 | 28.97 | 28.78 | 28.82 | 2984875.0 |
| 2003-10-08 14:00:00 | MSFT | Stock | 28.82 | 28.85 | 28.68 | 28.781 | 4374938.0 |
| 2003-10-08 15:00:00 | MSFT | Stock | 28.79 | 28.86 | 28.7 | 28.82 | 6087912.0 |
| 2003-10-08 16:00:00 | MSFT | Stock | 28.82 | 28.94 | 28.74 | 28.75 | 532364.0 |
| 2003-10-08 17:00:00 | MSFT | Stock | 28.75 | 28.89 | 28.75 | 28.86 | 15994.0 |
| 2003-10-08 18:00:00 | MSFT | Stock | 28.85 | 28.85 | 28.8 | 28.84 | 5700.0 |
| 2003-10-08 08:00:00 | NVDA | Stock | 0.1399 | 0.14 | 0.1399 | 0.14 | 371880.0 |
| 2003-10-08 09:00:00 | NVDA | Stock | 0.14 | 0.1412 | 0.1375 | 0.1382 | 74886360.0 |
| 2003-10-08 10:00:00 | NVDA | Stock | 0.1382 | 0.1384 | 0.1354 | 0.1356 | 136872480.0 |
| 2003-10-08 11:00:00 | NVDA | Stock | 0.1357 | 0.1369 | 0.1344 | 0.1365 | 93127200.0 |
| 2003-10-08 12:00:00 | NVDA | Stock | 0.1365 | 0.1369 | 0.1362 | 0.1364 | 32539680.0 |
| 2003-10-08 13:00:00 | NVDA | Stock | 0.1364 | 0.1365 | 0.1346 | 0.1351 | 83581440.0 |
| 2003-10-08 14:00:00 | NVDA | Stock | 0.1352 | 0.1359 | 0.1342 | 0.1353 | 81792720.0 |
| 2003-10-08 15:00:00 | NVDA | Stock | 0.1353 | 0.1364 | 0.1349 | 0.1352 | 127429200.0 |
| 2003-10-08 16:00:00 | NVDA | Stock | 0.1351 | 0.136 | 0.1351 | 0.1357 | 11032200.0 |
| 2003-10-08 17:00:00 | NVDA | Stock | 0.1357 | 0.1357 | 0.1251 | 0.1337 | 3975600.0 |
| 2003-10-08 18:00:00 | NVDA | Stock | 0.1345 | 0.1353 | 0.1345 | 0.1353 | 180000.0 |
| 2003-10-08 08:00:00 | AMZN | Stock | 2.7448 | 2.7745 | 2.7448 | 2.7745 | 1436960.0 |
| 2003-10-08 09:00:00 | AMZN | Stock | 2.77 | 2.7925 | 2.756 | 2.788 | 37853520.0 |
| 2003-10-08 10:00:00 | AMZN | Stock | 2.788 | 2.814 | 2.776 | 2.795 | 48581960.0 |
| 2003-10-08 11:00:00 | AMZN | Stock | 2.7945 | 2.8115 | 2.7725 | 2.7775 | 37934300.0 |
| 2003-10-08 12:00:00 | AMZN | Stock | 2.7775 | 2.79 | 2.77 | 2.785 | 15411780.0 |
| 2003-10-08 13:00:00 | AMZN | Stock | 2.7845 | 2.786 | 2.769 | 2.78 | 22148800.0 |
| 2003-10-08 14:00:00 | AMZN | Stock | 2.78 | 2.7975 | 2.7655 | 2.7962 | 31936740.0 |
| 2003-10-08 15:00:00 | AMZN | Stock | 2.7965 | 2.8025 | 2.783 | 2.785 | 31538400.0 |
| 2003-10-08 16:00:00 | AMZN | Stock | 2.7835 | 2.8285 | 2.7735 | 2.7775 | 4630760.0 |
| 2003-10-08 17:00:00 | AMZN | Stock | 2.7755 | 2.8135 | 2.7755 | 2.8135 | 1291460.0 |
| 2003-10-08 18:00:00 | AMZN | Stock | 2.8075 | 2.8075 | 2.803 | 2.806 | 74000.0 |
| 2003-10-08 09:00:00 | CL | Stock | 28.975 | 28.975 | 28.78 | 28.825 | 324600.0 |
| 2003-10-08 10:00:00 | CL | Stock | 28.825 | 28.89 | 28.76 | 28.805 | 256800.0 |
| 2003-10-08 11:00:00 | CL | Stock | 28.8 | 28.86 | 28.775 | 28.805 | 172200.0 |
| 2003-10-08 12:00:00 | CL | Stock | 28.8 | 28.865 | 28.79 | 28.815 | 144200.0 |
| 2003-10-08 13:00:00 | CL | Stock | 28.805 | 28.81 | 28.755 | 28.765 | 206200.0 |
| 2003-10-08 14:00:00 | CL | Stock | 28.765 | 28.86 | 28.73 | 28.86 | 478400.0 |
| 2003-10-08 15:00:00 | CL | Stock | 28.865 | 28.915 | 28.84 | 28.88 | 414800.0 |
> showing 50 of 22,253 rows — these rows as CSV