PREVIEW / stock_1hour / 2001-04-26
file: by_date/stock_1hour/2001/2001-04-26.parquet size: 353 KB rows: 16,543 symbols: 1,279
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 |
|---|---|---|---|---|---|---|---|
| 2001-04-26 08:00:00 | AAPL | Stock | 0.4413 | 0.4461 | 0.4413 | 0.4461 | 980000.0 |
| 2001-04-26 09:00:00 | AAPL | Stock | 0.4464 | 0.4571 | 0.4455 | 0.4557 | 118182400.0 |
| 2001-04-26 10:00:00 | AAPL | Stock | 0.4563 | 0.4661 | 0.4543 | 0.4634 | 221272800.0 |
| 2001-04-26 11:00:00 | AAPL | Stock | 0.4634 | 0.4643 | 0.4545 | 0.4621 | 57892800.0 |
| 2001-04-26 12:00:00 | AAPL | Stock | 0.4616 | 0.4657 | 0.4607 | 0.4641 | 75773600.0 |
| 2001-04-26 13:00:00 | AAPL | Stock | 0.4634 | 0.4652 | 0.4614 | 0.4638 | 59768800.0 |
| 2001-04-26 14:00:00 | AAPL | Stock | 0.4638 | 0.4639 | 0.45 | 0.4521 | 68073600.0 |
| 2001-04-26 15:00:00 | AAPL | Stock | 0.4521 | 0.458 | 0.4407 | 0.4413 | 101679200.0 |
| 2001-04-26 16:00:00 | AAPL | Stock | 0.4411 | 0.4643 | 0.4384 | 0.442 | 10869600.0 |
| 2001-04-26 17:00:00 | AAPL | Stock | 0.4438 | 0.4438 | 0.44 | 0.44 | 856800.0 |
| 2001-04-26 18:00:00 | AAPL | Stock | 0.442 | 0.442 | 0.442 | 0.442 | 11200.0 |
| 2001-04-26 08:00:00 | MSFT | Stock | 34.9 | 35.37 | 34.84 | 35.125 | 507800.0 |
| 2001-04-26 09:00:00 | MSFT | Stock | 35.125 | 35.375 | 34.56 | 35.375 | 16838600.0 |
| 2001-04-26 10:00:00 | MSFT | Stock | 35.36 | 35.5 | 35.245 | 35.43 | 17410800.0 |
| 2001-04-26 11:00:00 | MSFT | Stock | 35.435 | 35.44 | 34.735 | 35.06 | 20010400.0 |
| 2001-04-26 12:00:00 | MSFT | Stock | 35.045 | 35.38 | 34.935 | 35.325 | 9629200.0 |
| 2001-04-26 13:00:00 | MSFT | Stock | 35.35 | 35.36 | 34.945 | 35.0 | 9560400.0 |
| 2001-04-26 14:00:00 | MSFT | Stock | 34.99 | 35.02 | 34.195 | 34.405 | 13404600.0 |
| 2001-04-26 15:00:00 | MSFT | Stock | 34.4 | 34.59 | 34.265 | 34.56 | 14125000.0 |
| 2001-04-26 16:00:00 | MSFT | Stock | 34.565 | 35.015 | 34.405 | 34.565 | 6610600.0 |
| 2001-04-26 17:00:00 | MSFT | Stock | 34.935 | 35.17 | 34.475 | 34.6 | 12600.0 |
| 2001-04-26 18:00:00 | MSFT | Stock | 34.6 | 34.6 | 34.545 | 34.545 | 2000.0 |
| 2001-04-26 08:00:00 | NVDA | Stock | 0.3375 | 0.3396 | 0.3334 | 0.3356 | 720000.0 |
| 2001-04-26 09:00:00 | NVDA | Stock | 0.3358 | 0.3417 | 0.3271 | 0.3323 | 161928000.0 |
| 2001-04-26 10:00:00 | NVDA | Stock | 0.3323 | 0.3354 | 0.3188 | 0.3271 | 259344000.0 |
| 2001-04-26 11:00:00 | NVDA | Stock | 0.3271 | 0.3282 | 0.3156 | 0.3216 | 258168000.0 |
| 2001-04-26 12:00:00 | NVDA | Stock | 0.3216 | 0.3289 | 0.3198 | 0.3237 | 88008000.0 |
| 2001-04-26 13:00:00 | NVDA | Stock | 0.3237 | 0.326 | 0.3204 | 0.325 | 121584000.0 |
| 2001-04-26 14:00:00 | NVDA | Stock | 0.3252 | 0.3257 | 0.3106 | 0.3106 | 170736000.0 |
| 2001-04-26 15:00:00 | NVDA | Stock | 0.3107 | 0.317 | 0.3042 | 0.308 | 229848000.0 |
| 2001-04-26 16:00:00 | NVDA | Stock | 0.3083 | 0.322 | 0.3069 | 0.3125 | 20064000.0 |
| 2001-04-26 08:00:00 | AMZN | Stock | 0.804 | 0.804 | 0.8 | 0.8025 | 294000.0 |
| 2001-04-26 09:00:00 | AMZN | Stock | 0.805 | 0.825 | 0.804 | 0.8155 | 17304000.0 |
| 2001-04-26 10:00:00 | AMZN | Stock | 0.8165 | 0.825 | 0.8095 | 0.82 | 19298000.0 |
| 2001-04-26 11:00:00 | AMZN | Stock | 0.82 | 0.8205 | 0.811 | 0.816 | 14944000.0 |
| 2001-04-26 12:00:00 | AMZN | Stock | 0.8155 | 0.8215 | 0.8125 | 0.82 | 7392000.0 |
| 2001-04-26 13:00:00 | AMZN | Stock | 0.8195 | 0.8245 | 0.8155 | 0.8195 | 9098000.0 |
| 2001-04-26 14:00:00 | AMZN | Stock | 0.819 | 0.82 | 0.776 | 0.7775 | 14814000.0 |
| 2001-04-26 15:00:00 | AMZN | Stock | 0.778 | 0.7825 | 0.7635 | 0.772 | 18664000.0 |
| 2001-04-26 16:00:00 | AMZN | Stock | 0.772 | 0.775 | 0.7685 | 0.7705 | 1962000.0 |
| 2001-04-26 17:00:00 | AMZN | Stock | 0.799 | 0.799 | 0.79 | 0.79 | 26000.0 |
| 2001-04-26 18:00:00 | AMZN | Stock | 0.7705 | 0.775 | 0.7705 | 0.775 | 6000.0 |
| 2001-04-26 09:00:00 | CL | Stock | 26.75 | 26.75 | 26.5 | 26.625 | 331800.0 |
| 2001-04-26 10:00:00 | CL | Stock | 26.63 | 26.975 | 26.625 | 26.88 | 368000.0 |
| 2001-04-26 11:00:00 | CL | Stock | 26.88 | 26.92 | 26.7 | 26.825 | 270400.0 |
| 2001-04-26 12:00:00 | CL | Stock | 26.825 | 27.0 | 26.825 | 26.935 | 278800.0 |
| 2001-04-26 13:00:00 | CL | Stock | 26.935 | 27.265 | 26.935 | 27.2 | 357200.0 |
| 2001-04-26 14:00:00 | CL | Stock | 27.205 | 27.33 | 27.05 | 27.05 | 300400.0 |
| 2001-04-26 15:00:00 | CL | Stock | 27.055 | 27.145 | 26.985 | 27.01 | 612000.0 |
| 2001-04-26 16:00:00 | CL | Stock | 27.03 | 27.03 | 26.14 | 26.9 | 1721600.0 |
> showing 50 of 16,543 rows — these rows as CSV