PREVIEW / stock_1hour / 2004-10-06
file: by_date/stock_1hour/2004/2004-10-06.parquet size: 511 KB rows: 23,834 symbols: 1,837
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-06 08:00:00 | AAPL | Stock | 0.7023 | 0.7071 | 0.7009 | 0.7066 | 216160.0 |
| 2004-10-06 09:00:00 | AAPL | Stock | 0.7063 | 0.7139 | 0.7045 | 0.7104 | 47324816.0 |
| 2004-10-06 10:00:00 | AAPL | Stock | 0.7104 | 0.7141 | 0.7088 | 0.7113 | 66972472.0 |
| 2004-10-06 11:00:00 | AAPL | Stock | 0.7114 | 0.7134 | 0.7082 | 0.7118 | 36512056.0 |
| 2004-10-06 12:00:00 | AAPL | Stock | 0.7116 | 0.7141 | 0.7107 | 0.7107 | 26574240.0 |
| 2004-10-06 13:00:00 | AAPL | Stock | 0.7109 | 0.7132 | 0.7102 | 0.7113 | 30003288.0 |
| 2004-10-06 14:00:00 | AAPL | Stock | 0.7113 | 0.7143 | 0.7109 | 0.7123 | 28967624.0 |
| 2004-10-06 15:00:00 | AAPL | Stock | 0.7123 | 0.7279 | 0.7121 | 0.7255 | 167527584.0 |
| 2004-10-06 16:00:00 | AAPL | Stock | 0.7255 | 0.7266 | 0.7241 | 0.7257 | 24378424.0 |
| 2004-10-06 17:00:00 | AAPL | Stock | 0.7263 | 0.7268 | 0.7263 | 0.7266 | 132664.0 |
| 2004-10-06 18:00:00 | AAPL | Stock | 0.7266 | 0.7268 | 0.7266 | 0.7268 | 51464.0 |
| 2004-10-06 08:00:00 | MSFT | Stock | 28.36 | 28.4 | 28.36 | 28.36 | 239025.0 |
| 2004-10-06 09:00:00 | MSFT | Stock | 28.38 | 28.48 | 28.27 | 28.3 | 6781951.0 |
| 2004-10-06 10:00:00 | MSFT | Stock | 28.29 | 28.4 | 28.23 | 28.27 | 7869733.0 |
| 2004-10-06 11:00:00 | MSFT | Stock | 28.27 | 28.4 | 28.26 | 28.36 | 6301489.0 |
| 2004-10-06 12:00:00 | MSFT | Stock | 28.37 | 28.45 | 28.36 | 28.4 | 4177701.0 |
| 2004-10-06 13:00:00 | MSFT | Stock | 28.39 | 28.401 | 28.29 | 28.33 | 3632837.0 |
| 2004-10-06 14:00:00 | MSFT | Stock | 28.33 | 28.4 | 28.31 | 28.37 | 6655883.0 |
| 2004-10-06 15:00:00 | MSFT | Stock | 28.37 | 28.551 | 28.35 | 28.53 | 12653288.0 |
| 2004-10-06 16:00:00 | MSFT | Stock | 28.52 | 28.59 | 28.5 | 28.53 | 1071785.0 |
| 2004-10-06 17:00:00 | MSFT | Stock | 28.54 | 28.54 | 28.3648 | 28.54 | 963091.0 |
| 2004-10-06 18:00:00 | MSFT | Stock | 28.54 | 28.54 | 28.48 | 28.53 | 3037.0 |
| 2004-10-06 08:00:00 | NVDA | Stock | 0.1273 | 0.1273 | 0.1273 | 0.1273 | 48000.0 |
| 2004-10-06 09:00:00 | NVDA | Stock | 0.1267 | 0.1277 | 0.1257 | 0.1266 | 33481320.0 |
| 2004-10-06 10:00:00 | NVDA | Stock | 0.1267 | 0.1268 | 0.1235 | 0.1245 | 106048320.0 |
| 2004-10-06 11:00:00 | NVDA | Stock | 0.1245 | 0.1248 | 0.1239 | 0.1246 | 49741440.0 |
| 2004-10-06 12:00:00 | NVDA | Stock | 0.1246 | 0.1254 | 0.1245 | 0.1248 | 53671680.0 |
| 2004-10-06 13:00:00 | NVDA | Stock | 0.1247 | 0.125 | 0.1243 | 0.1248 | 32254200.0 |
| 2004-10-06 14:00:00 | NVDA | Stock | 0.1248 | 0.1256 | 0.1247 | 0.1247 | 67943520.0 |
| 2004-10-06 15:00:00 | NVDA | Stock | 0.1248 | 0.1275 | 0.1248 | 0.1271 | 115619520.0 |
| 2004-10-06 16:00:00 | NVDA | Stock | 0.1271 | 0.1274 | 0.1267 | 0.1272 | 6054360.0 |
| 2004-10-06 17:00:00 | NVDA | Stock | 0.1282 | 0.1282 | 0.1277 | 0.1277 | 144000.0 |
| 2004-10-06 18:00:00 | NVDA | Stock | 0.1277 | 0.1277 | 0.1277 | 0.1277 | 120000.0 |
| 2004-10-06 08:00:00 | AMZN | Stock | 2.0478 | 2.0478 | 2.043 | 2.045 | 550000.0 |
| 2004-10-06 09:00:00 | AMZN | Stock | 2.042 | 2.042 | 2.0265 | 2.029 | 15459780.0 |
| 2004-10-06 10:00:00 | AMZN | Stock | 2.029 | 2.052 | 2.02 | 2.035 | 24403320.0 |
| 2004-10-06 11:00:00 | AMZN | Stock | 2.0345 | 2.0415 | 2.0275 | 2.031 | 8692400.0 |
| 2004-10-06 12:00:00 | AMZN | Stock | 2.032 | 2.045 | 2.031 | 2.0385 | 7290140.0 |
| 2004-10-06 13:00:00 | AMZN | Stock | 2.039 | 2.043 | 2.034 | 2.038 | 5520020.0 |
| 2004-10-06 14:00:00 | AMZN | Stock | 2.038 | 2.0465 | 2.0375 | 2.042 | 8980300.0 |
| 2004-10-06 15:00:00 | AMZN | Stock | 2.043 | 2.0705 | 2.0415 | 2.067 | 26699540.0 |
| 2004-10-06 16:00:00 | AMZN | Stock | 2.067 | 2.0815 | 2.0645 | 2.077 | 1279100.0 |
| 2004-10-06 17:00:00 | AMZN | Stock | 2.0785 | 2.08 | 2.0405 | 2.0677 | 675880.0 |
| 2004-10-06 18:00:00 | AMZN | Stock | 2.074 | 2.074 | 2.054 | 2.054 | 18580.0 |
| 2004-10-06 09:00:00 | CL | Stock | 22.3 | 22.325 | 22.24 | 22.295 | 899800.0 |
| 2004-10-06 10:00:00 | CL | Stock | 22.3 | 22.425 | 22.25 | 22.275 | 1306600.0 |
| 2004-10-06 11:00:00 | CL | Stock | 22.25 | 22.4 | 22.2 | 22.245 | 1392800.0 |
| 2004-10-06 12:00:00 | CL | Stock | 22.25 | 22.345 | 22.245 | 22.305 | 686800.0 |
| 2004-10-06 13:00:00 | CL | Stock | 22.31 | 22.315 | 22.23 | 22.255 | 809200.0 |
| 2004-10-06 14:00:00 | CL | Stock | 22.25 | 22.295 | 22.225 | 22.25 | 745400.0 |
> showing 50 of 23,834 rows — these rows as CSV