PREVIEW / stock_1hour / 2002-05-23
file: by_date/stock_1hour/2002/2002-05-23.parquet size: 411 KB rows: 19,689 symbols: 1,424
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-23 08:00:00 | AAPL | Stock | 0.4347 | 0.4359 | 0.4345 | 0.4355 | 156800.0 |
| 2002-05-23 09:00:00 | AAPL | Stock | 0.4359 | 0.4384 | 0.4298 | 0.4366 | 44732800.0 |
| 2002-05-23 10:00:00 | AAPL | Stock | 0.4368 | 0.4418 | 0.4339 | 0.4363 | 53088000.0 |
| 2002-05-23 11:00:00 | AAPL | Stock | 0.4363 | 0.4373 | 0.4313 | 0.4346 | 27647200.0 |
| 2002-05-23 12:00:00 | AAPL | Stock | 0.4346 | 0.4425 | 0.4346 | 0.4396 | 41535200.0 |
| 2002-05-23 13:00:00 | AAPL | Stock | 0.4395 | 0.4429 | 0.4382 | 0.4403 | 18463200.0 |
| 2002-05-23 14:00:00 | AAPL | Stock | 0.4404 | 0.4473 | 0.4375 | 0.4411 | 72486400.0 |
| 2002-05-23 15:00:00 | AAPL | Stock | 0.4411 | 0.4507 | 0.4409 | 0.4495 | 82986400.0 |
| 2002-05-23 16:00:00 | AAPL | Stock | 0.4496 | 0.4509 | 0.4356 | 0.4495 | 6456800.0 |
| 2002-05-23 17:00:00 | AAPL | Stock | 0.45 | 0.45 | 0.45 | 0.45 | 33600.0 |
| 2002-05-23 18:00:00 | AAPL | Stock | 0.4496 | 0.4496 | 0.4496 | 0.4496 | 33600.0 |
| 2002-05-23 08:00:00 | MSFT | Stock | 26.6 | 27.05 | 26.6 | 26.975 | 144800.0 |
| 2002-05-23 09:00:00 | MSFT | Stock | 26.975 | 27.0 | 26.61 | 26.85 | 7544800.0 |
| 2002-05-23 10:00:00 | MSFT | Stock | 26.8575 | 26.97 | 26.675 | 26.794 | 8258000.0 |
| 2002-05-23 11:00:00 | MSFT | Stock | 26.794 | 26.795 | 26.505 | 26.595 | 5992400.0 |
| 2002-05-23 12:00:00 | MSFT | Stock | 26.595 | 26.835 | 26.55 | 26.675 | 4064200.0 |
| 2002-05-23 13:00:00 | MSFT | Stock | 26.675 | 26.745 | 26.55 | 26.662 | 3856800.0 |
| 2002-05-23 14:00:00 | MSFT | Stock | 26.665 | 27.235 | 26.6 | 27.2 | 9121200.0 |
| 2002-05-23 15:00:00 | MSFT | Stock | 27.2 | 27.42 | 27.0445 | 27.41 | 10695200.0 |
| 2002-05-23 16:00:00 | MSFT | Stock | 27.4 | 27.44 | 26.7421 | 27.325 | 1292200.0 |
| 2002-05-23 17:00:00 | MSFT | Stock | 27.325 | 27.41 | 27.325 | 27.36 | 11800.0 |
| 2002-05-23 18:00:00 | MSFT | Stock | 27.41 | 27.41 | 27.375 | 27.385 | 21000.0 |
| 2002-05-23 08:00:00 | NVDA | Stock | 0.3133 | 0.3187 | 0.3104 | 0.316 | 15612000.0 |
| 2002-05-23 09:00:00 | NVDA | Stock | 0.3161 | 0.3187 | 0.2979 | 0.3 | 552084000.0 |
| 2002-05-23 10:00:00 | NVDA | Stock | 0.3004 | 0.3029 | 0.2923 | 0.2954 | 527904000.0 |
| 2002-05-23 11:00:00 | NVDA | Stock | 0.2954 | 0.2957 | 0.2883 | 0.2927 | 387228000.0 |
| 2002-05-23 12:00:00 | NVDA | Stock | 0.2927 | 0.2956 | 0.2917 | 0.2917 | 205608000.0 |
| 2002-05-23 13:00:00 | NVDA | Stock | 0.2917 | 0.2944 | 0.2902 | 0.2938 | 226476000.0 |
| 2002-05-23 14:00:00 | NVDA | Stock | 0.294 | 0.3008 | 0.2922 | 0.2974 | 314592000.0 |
| 2002-05-23 15:00:00 | NVDA | Stock | 0.2973 | 0.3005 | 0.2955 | 0.2977 | 277764000.0 |
| 2002-05-23 16:00:00 | NVDA | Stock | 0.2977 | 0.2979 | 0.2953 | 0.2962 | 38052000.0 |
| 2002-05-23 17:00:00 | NVDA | Stock | 0.2966 | 0.2972 | 0.2959 | 0.2972 | 1032000.0 |
| 2002-05-23 18:00:00 | NVDA | Stock | 0.2971 | 0.2977 | 0.2967 | 0.2971 | 408000.0 |
| 2002-05-23 08:00:00 | AMZN | Stock | 0.9415 | 0.95 | 0.9375 | 0.95 | 188000.0 |
| 2002-05-23 09:00:00 | AMZN | Stock | 0.946 | 0.95 | 0.9305 | 0.944 | 15504000.0 |
| 2002-05-23 10:00:00 | AMZN | Stock | 0.944 | 0.9525 | 0.936 | 0.9485 | 18420000.0 |
| 2002-05-23 11:00:00 | AMZN | Stock | 0.9495 | 0.955 | 0.9405 | 0.9495 | 15432000.0 |
| 2002-05-23 12:00:00 | AMZN | Stock | 0.9495 | 0.9525 | 0.9475 | 0.9475 | 13306000.0 |
| 2002-05-23 13:00:00 | AMZN | Stock | 0.9475 | 0.95 | 0.943 | 0.95 | 7170000.0 |
| 2002-05-23 14:00:00 | AMZN | Stock | 0.9495 | 0.9675 | 0.9475 | 0.966 | 17510000.0 |
| 2002-05-23 15:00:00 | AMZN | Stock | 0.9645 | 0.9775 | 0.9575 | 0.973 | 23534000.0 |
| 2002-05-23 16:00:00 | AMZN | Stock | 0.9725 | 0.98 | 0.9452 | 0.972 | 1786000.0 |
| 2002-05-23 17:00:00 | AMZN | Stock | 0.975 | 0.975 | 0.9725 | 0.973 | 116000.0 |
| 2002-05-23 18:00:00 | AMZN | Stock | 0.9725 | 0.975 | 0.9725 | 0.973 | 62000.0 |
| 2002-05-23 09:00:00 | CL | Stock | 27.075 | 27.1 | 26.8 | 26.835 | 350600.0 |
| 2002-05-23 10:00:00 | CL | Stock | 26.85 | 26.89 | 26.745 | 26.79 | 517400.0 |
| 2002-05-23 11:00:00 | CL | Stock | 26.75 | 26.83 | 26.66 | 26.755 | 489400.0 |
| 2002-05-23 12:00:00 | CL | Stock | 26.755 | 26.755 | 26.575 | 26.635 | 644600.0 |
| 2002-05-23 13:00:00 | CL | Stock | 26.63 | 26.65 | 26.56 | 26.595 | 591000.0 |
| 2002-05-23 14:00:00 | CL | Stock | 26.6 | 26.79 | 26.57 | 26.775 | 553400.0 |
> showing 50 of 19,689 rows — these rows as CSV