PREVIEW / stock_1hour / 2001-10-11
file: by_date/stock_1hour/2001/2001-10-11.parquet size: 383 KB rows: 18,440 symbols: 1,339
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-10-11 08:00:00 | AAPL | Stock | 0.3004 | 0.3054 | 0.3004 | 0.3038 | 257600.0 |
| 2001-10-11 09:00:00 | AAPL | Stock | 0.3038 | 0.3107 | 0.3013 | 0.3061 | 61941600.0 |
| 2001-10-11 10:00:00 | AAPL | Stock | 0.3068 | 0.3086 | 0.3009 | 0.3036 | 37245600.0 |
| 2001-10-11 11:00:00 | AAPL | Stock | 0.3034 | 0.307 | 0.302 | 0.3038 | 28582400.0 |
| 2001-10-11 12:00:00 | AAPL | Stock | 0.3038 | 0.308 | 0.303 | 0.308 | 29825600.0 |
| 2001-10-11 13:00:00 | AAPL | Stock | 0.3082 | 0.3159 | 0.3068 | 0.3127 | 53205600.0 |
| 2001-10-11 14:00:00 | AAPL | Stock | 0.3127 | 0.3127 | 0.3063 | 0.3093 | 47549600.0 |
| 2001-10-11 15:00:00 | AAPL | Stock | 0.3089 | 0.3168 | 0.3073 | 0.3168 | 53838400.0 |
| 2001-10-11 16:00:00 | AAPL | Stock | 0.3166 | 0.3214 | 0.3154 | 0.3161 | 4524800.0 |
| 2001-10-11 17:00:00 | AAPL | Stock | 0.3168 | 0.3168 | 0.3168 | 0.3168 | 1635200.0 |
| 2001-10-11 18:00:00 | AAPL | Stock | 0.3165 | 0.3205 | 0.3165 | 0.3205 | 1562400.0 |
| 2001-10-11 08:00:00 | MSFT | Stock | 28.02 | 28.03 | 27.7475 | 28.0 | 143600.0 |
| 2001-10-11 09:00:00 | MSFT | Stock | 28.0 | 28.42 | 27.825 | 28.125 | 11405000.0 |
| 2001-10-11 10:00:00 | MSFT | Stock | 28.1295 | 28.405 | 27.585 | 27.585 | 16931200.0 |
| 2001-10-11 11:00:00 | MSFT | Stock | 27.585 | 27.855 | 27.2995 | 27.39 | 12765800.0 |
| 2001-10-11 12:00:00 | MSFT | Stock | 27.39 | 27.7105 | 27.34 | 27.69 | 6839000.0 |
| 2001-10-11 13:00:00 | MSFT | Stock | 27.69 | 27.895 | 27.63 | 27.7 | 8201200.0 |
| 2001-10-11 14:00:00 | MSFT | Stock | 27.7 | 27.775 | 27.525 | 27.6551 | 6672200.0 |
| 2001-10-11 15:00:00 | MSFT | Stock | 27.66 | 28.185 | 27.595 | 28.155 | 12433000.0 |
| 2001-10-11 16:00:00 | MSFT | Stock | 28.155 | 28.375 | 27.6 | 27.8303 | 2160800.0 |
| 2001-10-11 17:00:00 | MSFT | Stock | 28.37 | 28.395 | 27.505 | 28.16 | 308000.0 |
| 2001-10-11 18:00:00 | MSFT | Stock | 28.365 | 28.42 | 28.1346 | 28.4 | 225000.0 |
| 2001-10-11 08:00:00 | NVDA | Stock | 0.2896 | 0.2933 | 0.2877 | 0.2921 | 1872000.0 |
| 2001-10-11 09:00:00 | NVDA | Stock | 0.2929 | 0.312 | 0.2925 | 0.3094 | 164028000.0 |
| 2001-10-11 10:00:00 | NVDA | Stock | 0.3094 | 0.3157 | 0.305 | 0.3089 | 163296000.0 |
| 2001-10-11 11:00:00 | NVDA | Stock | 0.3089 | 0.3154 | 0.3075 | 0.3105 | 119676000.0 |
| 2001-10-11 12:00:00 | NVDA | Stock | 0.3107 | 0.3137 | 0.3102 | 0.3137 | 39060000.0 |
| 2001-10-11 13:00:00 | NVDA | Stock | 0.3133 | 0.3155 | 0.3108 | 0.3117 | 76800000.0 |
| 2001-10-11 14:00:00 | NVDA | Stock | 0.3117 | 0.3136 | 0.3058 | 0.3086 | 126756000.0 |
| 2001-10-11 15:00:00 | NVDA | Stock | 0.3086 | 0.3172 | 0.3071 | 0.3163 | 149256000.0 |
| 2001-10-11 16:00:00 | NVDA | Stock | 0.3162 | 0.3242 | 0.3107 | 0.3242 | 24504000.0 |
| 2001-10-11 17:00:00 | NVDA | Stock | 0.3225 | 0.3242 | 0.3163 | 0.3163 | 2304000.0 |
| 2001-10-11 18:00:00 | NVDA | Stock | 0.3212 | 0.3229 | 0.316 | 0.3209 | 1224000.0 |
| 2001-10-11 09:00:00 | AMZN | Stock | 0.3725 | 0.398 | 0.3725 | 0.395 | 27296000.0 |
| 2001-10-11 10:00:00 | AMZN | Stock | 0.396 | 0.408 | 0.39 | 0.393 | 24612000.0 |
| 2001-10-11 11:00:00 | AMZN | Stock | 0.393 | 0.3935 | 0.381 | 0.3865 | 12070000.0 |
| 2001-10-11 12:00:00 | AMZN | Stock | 0.387 | 0.4025 | 0.386 | 0.4015 | 11796000.0 |
| 2001-10-11 13:00:00 | AMZN | Stock | 0.402 | 0.406 | 0.3955 | 0.3985 | 13126000.0 |
| 2001-10-11 14:00:00 | AMZN | Stock | 0.3985 | 0.399 | 0.389 | 0.395 | 7604000.0 |
| 2001-10-11 15:00:00 | AMZN | Stock | 0.395 | 0.3985 | 0.386 | 0.392 | 19812000.0 |
| 2001-10-11 16:00:00 | AMZN | Stock | 0.392 | 0.4005 | 0.39 | 0.4 | 2506000.0 |
| 2001-10-11 17:00:00 | AMZN | Stock | 0.4 | 0.408 | 0.3925 | 0.408 | 556000.0 |
| 2001-10-11 18:00:00 | AMZN | Stock | 0.3925 | 0.408 | 0.3921 | 0.4075 | 350000.0 |
| 2001-10-11 09:00:00 | CL | Stock | 29.0 | 29.165 | 28.875 | 29.015 | 274000.0 |
| 2001-10-11 10:00:00 | CL | Stock | 29.025 | 29.175 | 28.86 | 29.08 | 608000.0 |
| 2001-10-11 11:00:00 | CL | Stock | 29.05 | 29.05 | 28.75 | 28.835 | 664200.0 |
| 2001-10-11 12:00:00 | CL | Stock | 28.835 | 28.895 | 28.6 | 28.66 | 265000.0 |
| 2001-10-11 13:00:00 | CL | Stock | 28.66 | 28.745 | 28.565 | 28.6 | 210800.0 |
| 2001-10-11 14:00:00 | CL | Stock | 28.6 | 28.665 | 28.525 | 28.64 | 192200.0 |
| 2001-10-11 15:00:00 | CL | Stock | 28.635 | 28.85 | 28.59 | 28.83 | 474400.0 |
> showing 50 of 18,440 rows — these rows as CSV