PREVIEW / stock_1hour / 2002-10-22
file: by_date/stock_1hour/2002/2002-10-22.parquet size: 402 KB rows: 19,277 symbols: 1,492
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-10-22 08:00:00 | AAPL | Stock | 0.2601 | 0.2601 | 0.2601 | 0.2601 | 168000.0 |
| 2002-10-22 09:00:00 | AAPL | Stock | 0.2575 | 0.2604 | 0.2546 | 0.2604 | 23734816.0 |
| 2002-10-22 10:00:00 | AAPL | Stock | 0.26 | 0.2657 | 0.2595 | 0.2641 | 51627464.0 |
| 2002-10-22 11:00:00 | AAPL | Stock | 0.2641 | 0.2643 | 0.258 | 0.2598 | 42529816.0 |
| 2002-10-22 12:00:00 | AAPL | Stock | 0.26 | 0.2613 | 0.2589 | 0.2598 | 14010864.0 |
| 2002-10-22 13:00:00 | AAPL | Stock | 0.2605 | 0.2618 | 0.2573 | 0.2586 | 26159224.0 |
| 2002-10-22 14:00:00 | AAPL | Stock | 0.2586 | 0.2614 | 0.2573 | 0.2605 | 16664032.0 |
| 2002-10-22 15:00:00 | AAPL | Stock | 0.2607 | 0.2634 | 0.26 | 0.2625 | 33217296.0 |
| 2002-10-22 16:00:00 | AAPL | Stock | 0.2625 | 0.2643 | 0.262 | 0.2625 | 6460216.0 |
| 2002-10-22 17:00:00 | AAPL | Stock | 0.263 | 0.263 | 0.2625 | 0.2625 | 1002400.0 |
| 2002-10-22 08:00:00 | MSFT | Stock | 25.755 | 25.8995 | 25.7 | 25.8005 | 102950.0 |
| 2002-10-22 09:00:00 | MSFT | Stock | 25.85 | 26.255 | 25.515 | 25.545 | 14975640.0 |
| 2002-10-22 10:00:00 | MSFT | Stock | 25.55 | 25.9 | 25.53 | 25.865 | 19342590.0 |
| 2002-10-22 11:00:00 | MSFT | Stock | 25.865 | 25.965 | 25.65 | 25.78 | 12221828.0 |
| 2002-10-22 12:00:00 | MSFT | Stock | 25.78 | 25.895 | 25.69 | 25.765 | 5676116.0 |
| 2002-10-22 13:00:00 | MSFT | Stock | 25.765 | 25.825 | 25.595 | 25.62 | 8425008.0 |
| 2002-10-22 14:00:00 | MSFT | Stock | 25.62 | 25.725 | 25.515 | 25.6555 | 8567118.0 |
| 2002-10-22 15:00:00 | MSFT | Stock | 25.7 | 25.83 | 25.565 | 25.825 | 11952656.0 |
| 2002-10-22 16:00:00 | MSFT | Stock | 25.825 | 25.995 | 25.75 | 25.885 | 3600816.0 |
| 2002-10-22 17:00:00 | MSFT | Stock | 25.895 | 25.9 | 25.65 | 25.65 | 41680.0 |
| 2002-10-22 08:00:00 | NVDA | Stock | 0.0824 | 0.0833 | 0.0804 | 0.0811 | 1851600.0 |
| 2002-10-22 09:00:00 | NVDA | Stock | 0.0811 | 0.0865 | 0.0803 | 0.0863 | 187007280.0 |
| 2002-10-22 10:00:00 | NVDA | Stock | 0.0863 | 0.0933 | 0.0849 | 0.0907 | 496928160.0 |
| 2002-10-22 11:00:00 | NVDA | Stock | 0.0907 | 0.0912 | 0.0887 | 0.0901 | 136362240.0 |
| 2002-10-22 12:00:00 | NVDA | Stock | 0.0901 | 0.0906 | 0.0892 | 0.0904 | 44741400.0 |
| 2002-10-22 13:00:00 | NVDA | Stock | 0.0903 | 0.0904 | 0.0871 | 0.0876 | 97115880.0 |
| 2002-10-22 14:00:00 | NVDA | Stock | 0.0877 | 0.0882 | 0.0865 | 0.0871 | 92963640.0 |
| 2002-10-22 15:00:00 | NVDA | Stock | 0.0872 | 0.0896 | 0.0871 | 0.0877 | 158643360.0 |
| 2002-10-22 16:00:00 | NVDA | Stock | 0.088 | 0.0896 | 0.0878 | 0.0883 | 10632000.0 |
| 2002-10-22 17:00:00 | NVDA | Stock | 0.0884 | 0.0892 | 0.0882 | 0.0884 | 558000.0 |
| 2002-10-22 08:00:00 | AMZN | Stock | 0.9635 | 0.9635 | 0.9498 | 0.9498 | 134000.0 |
| 2002-10-22 09:00:00 | AMZN | Stock | 0.95 | 0.972 | 0.945 | 0.971 | 15976500.0 |
| 2002-10-22 10:00:00 | AMZN | Stock | 0.971 | 0.9955 | 0.964 | 0.9875 | 55113280.0 |
| 2002-10-22 11:00:00 | AMZN | Stock | 0.9885 | 0.9924 | 0.9725 | 0.9815 | 28913360.0 |
| 2002-10-22 12:00:00 | AMZN | Stock | 0.982 | 0.985 | 0.968 | 0.9805 | 16098840.0 |
| 2002-10-22 13:00:00 | AMZN | Stock | 0.981 | 0.985 | 0.97 | 0.975 | 14371660.0 |
| 2002-10-22 14:00:00 | AMZN | Stock | 0.9735 | 0.9755 | 0.969 | 0.9735 | 11982120.0 |
| 2002-10-22 15:00:00 | AMZN | Stock | 0.9735 | 0.9805 | 0.9675 | 0.9685 | 21831060.0 |
| 2002-10-22 16:00:00 | AMZN | Stock | 0.969 | 0.9775 | 0.967 | 0.97 | 5129380.0 |
| 2002-10-22 17:00:00 | AMZN | Stock | 0.969 | 0.9722 | 0.969 | 0.969 | 924000.0 |
| 2002-10-22 18:00:00 | AMZN | Stock | 0.97 | 0.97 | 0.97 | 0.97 | 2000.0 |
| 2002-10-22 09:00:00 | CL | Stock | 28.63 | 28.635 | 28.455 | 28.565 | 731400.0 |
| 2002-10-22 10:00:00 | CL | Stock | 28.575 | 28.65 | 28.23 | 28.23 | 942000.0 |
| 2002-10-22 11:00:00 | CL | Stock | 28.235 | 28.375 | 28.19 | 28.345 | 495000.0 |
| 2002-10-22 12:00:00 | CL | Stock | 28.345 | 28.365 | 28.1 | 28.27 | 392200.0 |
| 2002-10-22 13:00:00 | CL | Stock | 28.25 | 28.355 | 28.105 | 28.265 | 565200.0 |
| 2002-10-22 14:00:00 | CL | Stock | 28.28 | 28.385 | 28.215 | 28.345 | 407400.0 |
| 2002-10-22 15:00:00 | CL | Stock | 28.345 | 28.495 | 28.21 | 28.32 | 776000.0 |
| 2002-10-22 16:00:00 | CL | Stock | 28.33 | 28.335 | 28.305 | 28.305 | 409400.0 |
| 2002-10-22 17:00:00 | CL | Stock | 28.32 | 28.32 | 28.32 | 28.32 | 3400.0 |
> showing 50 of 19,277 rows — these rows as CSV