PREVIEW / stock_1hour / 2002-04-30
file: by_date/stock_1hour/2002/2002-04-30.parquet size: 420 KB rows: 19,874 symbols: 1,403
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-04-30 08:00:00 | AAPL | Stock | 0.4279 | 0.4279 | 0.4279 | 0.4279 | 974400.0 |
| 2002-04-30 09:00:00 | AAPL | Stock | 0.4263 | 0.4286 | 0.4241 | 0.425 | 24315200.0 |
| 2002-04-30 10:00:00 | AAPL | Stock | 0.4255 | 0.4329 | 0.4255 | 0.4313 | 54622400.0 |
| 2002-04-30 11:00:00 | AAPL | Stock | 0.4313 | 0.4348 | 0.4277 | 0.4307 | 52522400.0 |
| 2002-04-30 12:00:00 | AAPL | Stock | 0.4311 | 0.4323 | 0.4282 | 0.4311 | 28392000.0 |
| 2002-04-30 13:00:00 | AAPL | Stock | 0.4311 | 0.4311 | 0.4279 | 0.4307 | 20552000.0 |
| 2002-04-30 14:00:00 | AAPL | Stock | 0.4309 | 0.4329 | 0.4288 | 0.4329 | 30525600.0 |
| 2002-04-30 15:00:00 | AAPL | Stock | 0.433 | 0.4354 | 0.4289 | 0.4332 | 46054400.0 |
| 2002-04-30 16:00:00 | AAPL | Stock | 0.433 | 0.4361 | 0.4301 | 0.4361 | 18692800.0 |
| 2002-04-30 17:00:00 | AAPL | Stock | 0.4368 | 0.4384 | 0.4334 | 0.4334 | 364000.0 |
| 2002-04-30 08:00:00 | MSFT | Stock | 26.295 | 26.345 | 26.065 | 26.1 | 157800.0 |
| 2002-04-30 09:00:00 | MSFT | Stock | 26.095 | 26.29 | 25.96 | 26.0345 | 8984400.0 |
| 2002-04-30 10:00:00 | MSFT | Stock | 26.03 | 26.65 | 26.03 | 26.205 | 16924800.0 |
| 2002-04-30 11:00:00 | MSFT | Stock | 26.185 | 26.42 | 26.18 | 26.305 | 10304800.0 |
| 2002-04-30 12:00:00 | MSFT | Stock | 26.31 | 26.345 | 26.07 | 26.235 | 7904000.0 |
| 2002-04-30 13:00:00 | MSFT | Stock | 26.24 | 26.325 | 26.185 | 26.23 | 6576000.0 |
| 2002-04-30 14:00:00 | MSFT | Stock | 26.23 | 26.61 | 26.22 | 26.55 | 9040600.0 |
| 2002-04-30 15:00:00 | MSFT | Stock | 26.555 | 26.6 | 26.0435 | 26.125 | 11421400.0 |
| 2002-04-30 16:00:00 | MSFT | Stock | 26.124 | 26.3224 | 26.05 | 26.1 | 4220400.0 |
| 2002-04-30 17:00:00 | MSFT | Stock | 26.095 | 26.15 | 26.065 | 26.1 | 52400.0 |
| 2002-04-30 18:00:00 | MSFT | Stock | 26.15 | 26.18 | 26.075 | 26.15 | 9000.0 |
| 2002-04-30 08:00:00 | NVDA | Stock | 0.3017 | 0.305 | 0.2969 | 0.2992 | 6288000.0 |
| 2002-04-30 09:00:00 | NVDA | Stock | 0.2984 | 0.3062 | 0.2925 | 0.2929 | 361296000.0 |
| 2002-04-30 10:00:00 | NVDA | Stock | 0.2929 | 0.3022 | 0.2881 | 0.295 | 445188000.0 |
| 2002-04-30 11:00:00 | NVDA | Stock | 0.2947 | 0.2992 | 0.2927 | 0.2957 | 216192000.0 |
| 2002-04-30 12:00:00 | NVDA | Stock | 0.2958 | 0.2974 | 0.2883 | 0.2885 | 175440000.0 |
| 2002-04-30 13:00:00 | NVDA | Stock | 0.2885 | 0.2904 | 0.2854 | 0.2878 | 177096000.0 |
| 2002-04-30 14:00:00 | NVDA | Stock | 0.2876 | 0.29 | 0.2837 | 0.2881 | 142680000.0 |
| 2002-04-30 15:00:00 | NVDA | Stock | 0.2882 | 0.2917 | 0.2867 | 0.29 | 184416000.0 |
| 2002-04-30 16:00:00 | NVDA | Stock | 0.2902 | 0.2959 | 0.2875 | 0.2901 | 62172000.0 |
| 2002-04-30 17:00:00 | NVDA | Stock | 0.2901 | 0.2902 | 0.2899 | 0.29 | 1776000.0 |
| 2002-04-30 18:00:00 | NVDA | Stock | 0.2902 | 0.2902 | 0.2902 | 0.2902 | 12000.0 |
| 2002-04-30 08:00:00 | AMZN | Stock | 0.811 | 0.811 | 0.8025 | 0.8025 | 22000.0 |
| 2002-04-30 09:00:00 | AMZN | Stock | 0.804 | 0.819 | 0.7965 | 0.8095 | 15906000.0 |
| 2002-04-30 10:00:00 | AMZN | Stock | 0.8095 | 0.835 | 0.8095 | 0.8335 | 33206000.0 |
| 2002-04-30 11:00:00 | AMZN | Stock | 0.8335 | 0.8365 | 0.8285 | 0.8325 | 19090000.0 |
| 2002-04-30 12:00:00 | AMZN | Stock | 0.8325 | 0.8355 | 0.83 | 0.832 | 9068000.0 |
| 2002-04-30 13:00:00 | AMZN | Stock | 0.832 | 0.837 | 0.829 | 0.8335 | 7524000.0 |
| 2002-04-30 14:00:00 | AMZN | Stock | 0.8335 | 0.8345 | 0.8215 | 0.827 | 13822000.0 |
| 2002-04-30 15:00:00 | AMZN | Stock | 0.827 | 0.838 | 0.827 | 0.8345 | 21768000.0 |
| 2002-04-30 16:00:00 | AMZN | Stock | 0.8345 | 0.838 | 0.8268 | 0.838 | 2714000.0 |
| 2002-04-30 17:00:00 | AMZN | Stock | 0.838 | 0.8395 | 0.8345 | 0.8375 | 336000.0 |
| 2002-04-30 18:00:00 | AMZN | Stock | 0.8375 | 0.8375 | 0.8375 | 0.8375 | 2000.0 |
| 2002-04-30 09:00:00 | CL | Stock | 26.75 | 26.85 | 26.725 | 26.85 | 543400.0 |
| 2002-04-30 10:00:00 | CL | Stock | 26.875 | 27.075 | 26.75 | 26.755 | 497400.0 |
| 2002-04-30 11:00:00 | CL | Stock | 26.75 | 26.95 | 26.695 | 26.7 | 1245400.0 |
| 2002-04-30 12:00:00 | CL | Stock | 26.7 | 26.755 | 26.625 | 26.685 | 652000.0 |
| 2002-04-30 13:00:00 | CL | Stock | 26.685 | 26.725 | 26.66 | 26.7 | 553800.0 |
| 2002-04-30 14:00:00 | CL | Stock | 26.695 | 26.7 | 26.55 | 26.665 | 691400.0 |
| 2002-04-30 15:00:00 | CL | Stock | 26.685 | 26.7 | 26.52 | 26.525 | 1016800.0 |
> showing 50 of 19,874 rows — these rows as CSV