PREVIEW / stock_1hour / 2002-05-14
file: by_date/stock_1hour/2002/2002-05-14.parquet size: 422 KB rows: 19,324 symbols: 1,417
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 |
|---|---|---|---|---|---|---|---|
| 2002-05-14 08:00:00 | AAPL | Stock | 0.4274 | 0.4348 | 0.425 | 0.4348 | 576800.0 |
| 2002-05-14 09:00:00 | AAPL | Stock | 0.4346 | 0.4384 | 0.4325 | 0.4375 | 41580000.0 |
| 2002-05-14 10:00:00 | AAPL | Stock | 0.4373 | 0.4432 | 0.4348 | 0.442 | 54084800.0 |
| 2002-05-14 11:00:00 | AAPL | Stock | 0.4425 | 0.4463 | 0.4413 | 0.4452 | 68062400.0 |
| 2002-05-14 12:00:00 | AAPL | Stock | 0.4452 | 0.4464 | 0.4448 | 0.4457 | 53810400.0 |
| 2002-05-14 13:00:00 | AAPL | Stock | 0.4463 | 0.4482 | 0.4441 | 0.4457 | 77330400.0 |
| 2002-05-14 14:00:00 | AAPL | Stock | 0.4461 | 0.4548 | 0.4457 | 0.4538 | 71159200.0 |
| 2002-05-14 15:00:00 | AAPL | Stock | 0.4536 | 0.4586 | 0.4518 | 0.4571 | 111893600.0 |
| 2002-05-14 16:00:00 | AAPL | Stock | 0.4573 | 0.4577 | 0.4468 | 0.4573 | 18804800.0 |
| 2002-05-14 17:00:00 | AAPL | Stock | 0.4573 | 0.4589 | 0.4573 | 0.4589 | 112000.0 |
| 2002-05-14 08:00:00 | MSFT | Stock | 26.505 | 27.12 | 26.35 | 27.05 | 228000.0 |
| 2002-05-14 09:00:00 | MSFT | Stock | 27.05 | 27.455 | 27.025 | 27.2 | 12807400.0 |
| 2002-05-14 10:00:00 | MSFT | Stock | 27.21 | 27.385 | 26.9935 | 27.365 | 11169400.0 |
| 2002-05-14 11:00:00 | MSFT | Stock | 27.375 | 27.425 | 27.18 | 27.39 | 6601000.0 |
| 2002-05-14 12:00:00 | MSFT | Stock | 27.39 | 27.475 | 27.255 | 27.28 | 5169000.0 |
| 2002-05-14 13:00:00 | MSFT | Stock | 27.28 | 27.44 | 27.2 | 27.21 | 4849800.0 |
| 2002-05-14 14:00:00 | MSFT | Stock | 27.235 | 27.5 | 27.22 | 27.465 | 6888200.0 |
| 2002-05-14 15:00:00 | MSFT | Stock | 27.46 | 27.55 | 27.395 | 27.49 | 9928000.0 |
| 2002-05-14 16:00:00 | MSFT | Stock | 27.47 | 27.915 | 27.3029 | 27.85 | 3981200.0 |
| 2002-05-14 17:00:00 | MSFT | Stock | 27.83 | 27.895 | 27.5 | 27.775 | 139000.0 |
| 2002-05-14 18:00:00 | MSFT | Stock | 27.755 | 27.755 | 27.7 | 27.725 | 27200.0 |
| 2002-05-14 08:00:00 | NVDA | Stock | 0.2818 | 0.2967 | 0.2818 | 0.2958 | 7620000.0 |
| 2002-05-14 09:00:00 | NVDA | Stock | 0.2958 | 0.3017 | 0.2938 | 0.2995 | 234192000.0 |
| 2002-05-14 10:00:00 | NVDA | Stock | 0.2994 | 0.3033 | 0.2946 | 0.3008 | 239400000.0 |
| 2002-05-14 11:00:00 | NVDA | Stock | 0.3006 | 0.3052 | 0.2979 | 0.3051 | 191076000.0 |
| 2002-05-14 12:00:00 | NVDA | Stock | 0.3051 | 0.3079 | 0.3051 | 0.307 | 164628000.0 |
| 2002-05-14 13:00:00 | NVDA | Stock | 0.3069 | 0.3079 | 0.305 | 0.3054 | 119892000.0 |
| 2002-05-14 14:00:00 | NVDA | Stock | 0.3057 | 0.3129 | 0.305 | 0.3111 | 197100000.0 |
| 2002-05-14 15:00:00 | NVDA | Stock | 0.3111 | 0.3125 | 0.3075 | 0.3097 | 208356000.0 |
| 2002-05-14 16:00:00 | NVDA | Stock | 0.3097 | 0.3127 | 0.3043 | 0.3127 | 111456000.0 |
| 2002-05-14 17:00:00 | NVDA | Stock | 0.3125 | 0.3142 | 0.3125 | 0.3141 | 1308000.0 |
| 2002-05-14 18:00:00 | NVDA | Stock | 0.3142 | 0.3142 | 0.3133 | 0.3142 | 900000.0 |
| 2002-05-14 08:00:00 | AMZN | Stock | 0.8615 | 0.8975 | 0.8615 | 0.8875 | 504000.0 |
| 2002-05-14 09:00:00 | AMZN | Stock | 0.8845 | 0.9425 | 0.8845 | 0.9405 | 63312000.0 |
| 2002-05-14 10:00:00 | AMZN | Stock | 0.9405 | 0.95 | 0.936 | 0.9415 | 46308000.0 |
| 2002-05-14 11:00:00 | AMZN | Stock | 0.941 | 0.95 | 0.94 | 0.9455 | 22678000.0 |
| 2002-05-14 12:00:00 | AMZN | Stock | 0.945 | 0.9725 | 0.9405 | 0.959 | 44590000.0 |
| 2002-05-14 13:00:00 | AMZN | Stock | 0.9595 | 0.9625 | 0.9415 | 0.942 | 32858000.0 |
| 2002-05-14 14:00:00 | AMZN | Stock | 0.942 | 0.9545 | 0.938 | 0.95 | 32272000.0 |
| 2002-05-14 15:00:00 | AMZN | Stock | 0.95 | 0.9555 | 0.935 | 0.9424 | 30664000.0 |
| 2002-05-14 16:00:00 | AMZN | Stock | 0.9404 | 0.9525 | 0.9365 | 0.9505 | 4344000.0 |
| 2002-05-14 17:00:00 | AMZN | Stock | 0.95 | 0.9535 | 0.9405 | 0.9535 | 204000.0 |
| 2002-05-14 18:00:00 | AMZN | Stock | 0.953 | 0.954 | 0.953 | 0.953 | 134000.0 |
| 2002-05-14 09:00:00 | CL | Stock | 27.805 | 27.85 | 27.63 | 27.645 | 436800.0 |
| 2002-05-14 10:00:00 | CL | Stock | 27.645 | 27.78 | 27.645 | 27.735 | 541000.0 |
| 2002-05-14 11:00:00 | CL | Stock | 27.725 | 27.855 | 27.725 | 27.845 | 354400.0 |
| 2002-05-14 12:00:00 | CL | Stock | 27.84 | 27.85 | 27.75 | 27.79 | 358200.0 |
| 2002-05-14 13:00:00 | CL | Stock | 27.79 | 27.9 | 27.785 | 27.795 | 235400.0 |
| 2002-05-14 14:00:00 | CL | Stock | 27.795 | 27.9 | 27.745 | 27.875 | 259400.0 |
| 2002-05-14 15:00:00 | CL | Stock | 27.875 | 27.9 | 27.805 | 27.85 | 423800.0 |
> showing 50 of 19,324 rows — these rows as CSV