PREVIEW / stock_1hour / 2005-12-22
file: by_date/stock_1hour/2005/2005-12-22.parquet size: 572 KB rows: 27,279 symbols: 2,160
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-22 08:00:00 | AAPL | Stock | 2.6336 | 2.6382 | 2.6296 | 2.6332 | 1158052.0 |
| 2005-12-22 09:00:00 | AAPL | Stock | 2.6332 | 2.65 | 2.6332 | 2.6389 | 57213576.0 |
| 2005-12-22 10:00:00 | AAPL | Stock | 2.6396 | 2.6604 | 2.6286 | 2.6575 | 102167240.0 |
| 2005-12-22 11:00:00 | AAPL | Stock | 2.6575 | 2.6586 | 2.6475 | 2.6547 | 46815244.0 |
| 2005-12-22 12:00:00 | AAPL | Stock | 2.655 | 2.6557 | 2.6432 | 2.6515 | 32892524.0 |
| 2005-12-22 13:00:00 | AAPL | Stock | 2.6518 | 2.6536 | 2.6454 | 2.6475 | 25405604.0 |
| 2005-12-22 14:00:00 | AAPL | Stock | 2.6471 | 2.6479 | 2.6364 | 2.6439 | 34215076.0 |
| 2005-12-22 15:00:00 | AAPL | Stock | 2.6439 | 2.6564 | 2.6421 | 2.6432 | 64301048.0 |
| 2005-12-22 16:00:00 | AAPL | Stock | 2.6432 | 2.6443 | 2.6393 | 2.6429 | 1893332.0 |
| 2005-12-22 17:00:00 | AAPL | Stock | 2.6429 | 2.6443 | 2.6429 | 2.6443 | 19600.0 |
| 2005-12-22 18:00:00 | AAPL | Stock | 2.6436 | 2.6454 | 2.6414 | 2.6414 | 77140.0 |
| 2005-12-22 07:00:00 | MSFT | Stock | 26.73 | 26.73 | 26.72 | 26.72 | 13900.0 |
| 2005-12-22 08:00:00 | MSFT | Stock | 26.72 | 26.78 | 26.72 | 26.78 | 29219.0 |
| 2005-12-22 09:00:00 | MSFT | Stock | 26.75 | 26.78 | 26.52 | 26.58 | 10150086.0 |
| 2005-12-22 10:00:00 | MSFT | Stock | 26.59 | 26.6 | 26.44 | 26.52 | 19046883.0 |
| 2005-12-22 11:00:00 | MSFT | Stock | 26.52 | 26.78 | 26.45 | 26.56 | 14922310.0 |
| 2005-12-22 12:00:00 | MSFT | Stock | 26.56 | 26.57 | 26.48 | 26.528 | 9741561.0 |
| 2005-12-22 13:00:00 | MSFT | Stock | 26.52 | 26.57 | 26.52 | 26.531 | 5101675.0 |
| 2005-12-22 14:00:00 | MSFT | Stock | 26.53 | 26.734 | 26.48 | 26.499 | 12935879.0 |
| 2005-12-22 15:00:00 | MSFT | Stock | 26.49 | 26.61 | 26.419 | 26.6 | 17716207.0 |
| 2005-12-22 16:00:00 | MSFT | Stock | 26.6 | 26.63 | 26.5 | 26.57 | 542101.0 |
| 2005-12-22 17:00:00 | MSFT | Stock | 26.59 | 26.59 | 26.58 | 26.58 | 5296.0 |
| 2005-12-22 18:00:00 | MSFT | Stock | 26.58 | 26.58 | 26.57 | 26.57 | 30200.0 |
| 2005-12-22 09:00:00 | NVDA | Stock | 0.3017 | 0.3062 | 0.3009 | 0.3051 | 34387440.0 |
| 2005-12-22 10:00:00 | NVDA | Stock | 0.3052 | 0.3074 | 0.3035 | 0.307 | 39539280.0 |
| 2005-12-22 11:00:00 | NVDA | Stock | 0.3071 | 0.3083 | 0.3062 | 0.308 | 37435560.0 |
| 2005-12-22 12:00:00 | NVDA | Stock | 0.308 | 0.3083 | 0.3063 | 0.3073 | 26711280.0 |
| 2005-12-22 13:00:00 | NVDA | Stock | 0.3073 | 0.3081 | 0.3067 | 0.3076 | 22676040.0 |
| 2005-12-22 14:00:00 | NVDA | Stock | 0.3076 | 0.3082 | 0.3017 | 0.3079 | 20208480.0 |
| 2005-12-22 15:00:00 | NVDA | Stock | 0.3079 | 0.3107 | 0.3079 | 0.3103 | 84277200.0 |
| 2005-12-22 16:00:00 | NVDA | Stock | 0.3103 | 0.3125 | 0.3092 | 0.31 | 895200.0 |
| 2005-12-22 17:00:00 | NVDA | Stock | 0.3104 | 0.3104 | 0.3104 | 0.3104 | 402480.0 |
| 2005-12-22 08:00:00 | AMZN | Stock | 2.445 | 2.445 | 2.445 | 2.445 | 10000.0 |
| 2005-12-22 09:00:00 | AMZN | Stock | 2.45 | 2.464 | 2.434 | 2.436 | 12466900.0 |
| 2005-12-22 10:00:00 | AMZN | Stock | 2.4365 | 2.452 | 2.418 | 2.45 | 20156320.0 |
| 2005-12-22 11:00:00 | AMZN | Stock | 2.45 | 2.4585 | 2.4425 | 2.4435 | 12121200.0 |
| 2005-12-22 12:00:00 | AMZN | Stock | 2.443 | 2.4445 | 2.431 | 2.431 | 6215340.0 |
| 2005-12-22 13:00:00 | AMZN | Stock | 2.4315 | 2.445 | 2.4275 | 2.4425 | 7890780.0 |
| 2005-12-22 14:00:00 | AMZN | Stock | 2.4425 | 2.4555 | 2.44 | 2.4475 | 9526940.0 |
| 2005-12-22 15:00:00 | AMZN | Stock | 2.4475 | 2.4625 | 2.4445 | 2.461 | 15984600.0 |
| 2005-12-22 16:00:00 | AMZN | Stock | 2.459 | 2.462 | 2.457 | 2.4595 | 1025640.0 |
| 2005-12-22 17:00:00 | AMZN | Stock | 2.4595 | 2.462 | 2.4595 | 2.46 | 44800.0 |
| 2005-12-22 09:00:00 | CL | Stock | 27.58 | 27.615 | 27.505 | 27.57 | 259200.0 |
| 2005-12-22 10:00:00 | CL | Stock | 27.565 | 27.685 | 27.535 | 27.675 | 386600.0 |
| 2005-12-22 11:00:00 | CL | Stock | 27.675 | 27.695 | 27.595 | 27.66 | 398400.0 |
| 2005-12-22 12:00:00 | CL | Stock | 27.655 | 27.655 | 27.605 | 27.65 | 300000.0 |
| 2005-12-22 13:00:00 | CL | Stock | 27.645 | 27.66 | 27.625 | 27.65 | 282600.0 |
| 2005-12-22 14:00:00 | CL | Stock | 27.6545 | 27.67 | 27.62 | 27.66 | 345200.0 |
| 2005-12-22 15:00:00 | CL | Stock | 27.66 | 27.745 | 27.655 | 27.71 | 867800.0 |
> showing 49 of 27,279 rows — these rows as CSV