PREVIEW / stock_1hour / 2002-05-22
file: by_date/stock_1hour/2002/2002-05-22.parquet size: 409 KB rows: 18,986 symbols: 1,425
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-22 08:00:00 | AAPL | Stock | 0.4188 | 0.4188 | 0.417 | 0.417 | 565600.0 |
| 2002-05-22 09:00:00 | AAPL | Stock | 0.4168 | 0.428 | 0.4161 | 0.4273 | 59052000.0 |
| 2002-05-22 10:00:00 | AAPL | Stock | 0.4273 | 0.4329 | 0.4241 | 0.4282 | 72402400.0 |
| 2002-05-22 11:00:00 | AAPL | Stock | 0.4286 | 0.4318 | 0.4257 | 0.4279 | 46155200.0 |
| 2002-05-22 12:00:00 | AAPL | Stock | 0.4275 | 0.4313 | 0.4275 | 0.4277 | 19684000.0 |
| 2002-05-22 13:00:00 | AAPL | Stock | 0.4275 | 0.4321 | 0.4264 | 0.4307 | 17337600.0 |
| 2002-05-22 14:00:00 | AAPL | Stock | 0.4307 | 0.4329 | 0.4257 | 0.4277 | 19196800.0 |
| 2002-05-22 15:00:00 | AAPL | Stock | 0.4276 | 0.4352 | 0.4261 | 0.4343 | 40969600.0 |
| 2002-05-22 16:00:00 | AAPL | Stock | 0.4343 | 0.4364 | 0.4278 | 0.4278 | 6053600.0 |
| 2002-05-22 17:00:00 | AAPL | Stock | 0.4343 | 0.4343 | 0.4343 | 0.4343 | 128800.0 |
| 2002-05-22 08:00:00 | MSFT | Stock | 26.005 | 26.025 | 25.9 | 25.975 | 144600.0 |
| 2002-05-22 09:00:00 | MSFT | Stock | 25.95 | 26.525 | 25.91 | 26.5095 | 10058200.0 |
| 2002-05-22 10:00:00 | MSFT | Stock | 26.5095 | 26.585 | 26.15 | 26.285 | 10616200.0 |
| 2002-05-22 11:00:00 | MSFT | Stock | 26.28 | 26.41 | 26.099 | 26.26 | 7580400.0 |
| 2002-05-22 12:00:00 | MSFT | Stock | 26.24 | 26.42 | 26.165 | 26.26 | 3940000.0 |
| 2002-05-22 13:00:00 | MSFT | Stock | 26.274 | 26.365 | 26.23 | 26.29 | 3612600.0 |
| 2002-05-22 14:00:00 | MSFT | Stock | 26.29 | 26.375 | 26.05 | 26.085 | 4928200.0 |
| 2002-05-22 15:00:00 | MSFT | Stock | 26.1 | 26.86 | 26.045 | 26.845 | 10687600.0 |
| 2002-05-22 16:00:00 | MSFT | Stock | 26.845 | 26.86 | 25.995 | 26.81 | 1411800.0 |
| 2002-05-22 17:00:00 | MSFT | Stock | 26.825 | 26.845 | 26.3386 | 26.825 | 133800.0 |
| 2002-05-22 18:00:00 | MSFT | Stock | 26.81 | 26.825 | 26.79 | 26.825 | 2400.0 |
| 2002-05-22 08:00:00 | NVDA | Stock | 0.3034 | 0.3048 | 0.3003 | 0.3028 | 6360000.0 |
| 2002-05-22 09:00:00 | NVDA | Stock | 0.3028 | 0.3142 | 0.3025 | 0.3142 | 249864000.0 |
| 2002-05-22 10:00:00 | NVDA | Stock | 0.3141 | 0.319 | 0.3101 | 0.3117 | 397764000.0 |
| 2002-05-22 11:00:00 | NVDA | Stock | 0.3117 | 0.3142 | 0.3092 | 0.3128 | 152868000.0 |
| 2002-05-22 12:00:00 | NVDA | Stock | 0.3128 | 0.3153 | 0.3112 | 0.3129 | 95184000.0 |
| 2002-05-22 13:00:00 | NVDA | Stock | 0.3125 | 0.3146 | 0.3114 | 0.3134 | 93744000.0 |
| 2002-05-22 14:00:00 | NVDA | Stock | 0.3135 | 0.3146 | 0.3084 | 0.309 | 103464000.0 |
| 2002-05-22 15:00:00 | NVDA | Stock | 0.309 | 0.3179 | 0.3085 | 0.3171 | 241944000.0 |
| 2002-05-22 16:00:00 | NVDA | Stock | 0.3168 | 0.3229 | 0.3086 | 0.3152 | 118764000.0 |
| 2002-05-22 17:00:00 | NVDA | Stock | 0.3156 | 0.3204 | 0.3086 | 0.3107 | 68928000.0 |
| 2002-05-22 18:00:00 | NVDA | Stock | 0.3108 | 0.3119 | 0.3092 | 0.3107 | 5208000.0 |
| 2002-05-22 08:00:00 | AMZN | Stock | 0.9378 | 0.9378 | 0.9225 | 0.93 | 198000.0 |
| 2002-05-22 09:00:00 | AMZN | Stock | 0.925 | 0.95 | 0.9245 | 0.949 | 14584000.0 |
| 2002-05-22 10:00:00 | AMZN | Stock | 0.949 | 0.9565 | 0.9395 | 0.9396 | 21070000.0 |
| 2002-05-22 11:00:00 | AMZN | Stock | 0.9395 | 0.9425 | 0.921 | 0.923 | 15068000.0 |
| 2002-05-22 12:00:00 | AMZN | Stock | 0.923 | 0.93 | 0.9145 | 0.9245 | 10888000.0 |
| 2002-05-22 13:00:00 | AMZN | Stock | 0.9245 | 0.9255 | 0.9125 | 0.9185 | 10626000.0 |
| 2002-05-22 14:00:00 | AMZN | Stock | 0.919 | 0.9225 | 0.911 | 0.911 | 6112000.0 |
| 2002-05-22 15:00:00 | AMZN | Stock | 0.9115 | 0.941 | 0.911 | 0.9375 | 19602000.0 |
| 2002-05-22 16:00:00 | AMZN | Stock | 0.9385 | 0.943 | 0.9309 | 0.935 | 980000.0 |
| 2002-05-22 17:00:00 | AMZN | Stock | 0.936 | 0.936 | 0.936 | 0.936 | 62000.0 |
| 2002-05-22 18:00:00 | AMZN | Stock | 0.936 | 0.936 | 0.936 | 0.936 | 2000.0 |
| 2002-05-22 09:00:00 | CL | Stock | 26.825 | 27.0 | 26.8 | 27.0 | 353600.0 |
| 2002-05-22 10:00:00 | CL | Stock | 27.0 | 27.09 | 26.86 | 26.865 | 765200.0 |
| 2002-05-22 11:00:00 | CL | Stock | 26.86 | 26.9 | 26.81 | 26.885 | 740800.0 |
| 2002-05-22 12:00:00 | CL | Stock | 26.89 | 26.95 | 26.8 | 26.83 | 538600.0 |
| 2002-05-22 13:00:00 | CL | Stock | 26.83 | 26.875 | 26.8 | 26.84 | 286400.0 |
| 2002-05-22 14:00:00 | CL | Stock | 26.85 | 26.865 | 26.775 | 26.805 | 400800.0 |
| 2002-05-22 15:00:00 | CL | Stock | 26.805 | 27.015 | 26.8 | 27.01 | 647800.0 |
> showing 50 of 18,986 rows — these rows as CSV