PREVIEW / stock_1hour / 2002-12-26
file: by_date/stock_1hour/2002/2002-12-26.parquet size: 389 KB rows: 18,711 symbols: 1,523
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-12-26 09:00:00 | AAPL | Stock | 0.2575 | 0.2594 | 0.2571 | 0.2586 | 8426432.0 |
| 2002-12-26 10:00:00 | AAPL | Stock | 0.2586 | 0.2645 | 0.2586 | 0.2638 | 13088488.0 |
| 2002-12-26 11:00:00 | AAPL | Stock | 0.2638 | 0.2641 | 0.2618 | 0.262 | 5555760.0 |
| 2002-12-26 12:00:00 | AAPL | Stock | 0.262 | 0.2629 | 0.2609 | 0.2614 | 4271568.0 |
| 2002-12-26 13:00:00 | AAPL | Stock | 0.2614 | 0.2614 | 0.26 | 0.2602 | 3203200.0 |
| 2002-12-26 14:00:00 | AAPL | Stock | 0.26 | 0.2604 | 0.2554 | 0.2571 | 15476720.0 |
| 2002-12-26 15:00:00 | AAPL | Stock | 0.2571 | 0.2586 | 0.255 | 0.2573 | 17778992.0 |
| 2002-12-26 16:00:00 | AAPL | Stock | 0.2573 | 0.2573 | 0.2571 | 0.2571 | 3287200.0 |
| 2002-12-26 17:00:00 | AAPL | Stock | 0.2571 | 0.2571 | 0.2571 | 0.2571 | 285600.0 |
| 2002-12-26 08:00:00 | MSFT | Stock | 26.975 | 27.1 | 26.95 | 27.035 | 37000.0 |
| 2002-12-26 09:00:00 | MSFT | Stock | 27.0105 | 27.275 | 26.965 | 27.17 | 5531592.0 |
| 2002-12-26 10:00:00 | MSFT | Stock | 27.165 | 27.345 | 27.165 | 27.295 | 5512442.0 |
| 2002-12-26 11:00:00 | MSFT | Stock | 27.2975 | 27.305 | 27.16 | 27.18 | 3300472.0 |
| 2002-12-26 12:00:00 | MSFT | Stock | 27.18 | 27.255 | 27.16 | 27.21 | 2394418.0 |
| 2002-12-26 13:00:00 | MSFT | Stock | 27.21 | 27.22 | 27.085 | 27.105 | 2550498.0 |
| 2002-12-26 14:00:00 | MSFT | Stock | 27.105 | 27.13 | 26.73 | 26.83 | 6085484.0 |
| 2002-12-26 15:00:00 | MSFT | Stock | 26.8305 | 26.85 | 26.585 | 26.695 | 6624588.0 |
| 2002-12-26 16:00:00 | MSFT | Stock | 26.695 | 26.7625 | 26.65 | 26.75 | 495826.0 |
| 2002-12-26 17:00:00 | MSFT | Stock | 26.75 | 26.76 | 26.69 | 26.76 | 41400.0 |
| 2002-12-26 18:00:00 | MSFT | Stock | 26.75 | 26.75 | 26.75 | 26.75 | 400.0 |
| 2002-12-26 08:00:00 | NVDA | Stock | 0.1062 | 0.1076 | 0.1062 | 0.1071 | 1848600.0 |
| 2002-12-26 09:00:00 | NVDA | Stock | 0.1071 | 0.1087 | 0.1057 | 0.1077 | 73967880.0 |
| 2002-12-26 10:00:00 | NVDA | Stock | 0.1078 | 0.1086 | 0.1077 | 0.108 | 98813280.0 |
| 2002-12-26 11:00:00 | NVDA | Stock | 0.1079 | 0.1082 | 0.1067 | 0.1067 | 83600160.0 |
| 2002-12-26 12:00:00 | NVDA | Stock | 0.1067 | 0.1071 | 0.1053 | 0.1059 | 85690680.0 |
| 2002-12-26 13:00:00 | NVDA | Stock | 0.1058 | 0.1059 | 0.1037 | 0.1038 | 99653880.0 |
| 2002-12-26 14:00:00 | NVDA | Stock | 0.1039 | 0.1043 | 0.1031 | 0.1037 | 107237400.0 |
| 2002-12-26 15:00:00 | NVDA | Stock | 0.1037 | 0.1045 | 0.1027 | 0.1033 | 89384520.0 |
| 2002-12-26 16:00:00 | NVDA | Stock | 0.1033 | 0.1038 | 0.1027 | 0.1034 | 4884000.0 |
| 2002-12-26 17:00:00 | NVDA | Stock | 0.1033 | 0.1033 | 0.1033 | 0.1033 | 84000.0 |
| 2002-12-26 18:00:00 | NVDA | Stock | 0.1037 | 0.104 | 0.1037 | 0.104 | 811800.0 |
| 2002-12-26 08:00:00 | AMZN | Stock | 1.094 | 1.094 | 1.069 | 1.0725 | 210000.0 |
| 2002-12-26 09:00:00 | AMZN | Stock | 1.075 | 1.094 | 1.0535 | 1.0615 | 22034820.0 |
| 2002-12-26 10:00:00 | AMZN | Stock | 1.0605 | 1.061 | 1.0175 | 1.023 | 43070680.0 |
| 2002-12-26 11:00:00 | AMZN | Stock | 1.0215 | 1.023 | 1.001 | 1.0135 | 66738160.0 |
| 2002-12-26 12:00:00 | AMZN | Stock | 1.0135 | 1.021 | 1.0125 | 1.016 | 30428680.0 |
| 2002-12-26 13:00:00 | AMZN | Stock | 1.016 | 1.016 | 1.0015 | 1.0075 | 24077860.0 |
| 2002-12-26 14:00:00 | AMZN | Stock | 1.0075 | 1.0125 | 1.0005 | 1.0075 | 24280400.0 |
| 2002-12-26 15:00:00 | AMZN | Stock | 1.0075 | 1.0165 | 1.007 | 1.0165 | 37057580.0 |
| 2002-12-26 16:00:00 | AMZN | Stock | 1.017 | 1.017 | 1.0135 | 1.015 | 2795860.0 |
| 2002-12-26 17:00:00 | AMZN | Stock | 1.015 | 1.016 | 1.0125 | 1.0125 | 148000.0 |
| 2002-12-26 09:00:00 | CL | Stock | 26.3 | 26.35 | 26.265 | 26.315 | 57400.0 |
| 2002-12-26 10:00:00 | CL | Stock | 26.315 | 26.525 | 26.315 | 26.495 | 153400.0 |
| 2002-12-26 11:00:00 | CL | Stock | 26.495 | 26.5 | 26.38 | 26.38 | 140600.0 |
| 2002-12-26 12:00:00 | CL | Stock | 26.385 | 26.5 | 26.38 | 26.425 | 181000.0 |
| 2002-12-26 13:00:00 | CL | Stock | 26.425 | 26.44 | 26.39 | 26.425 | 178000.0 |
| 2002-12-26 14:00:00 | CL | Stock | 26.46 | 26.46 | 26.3 | 26.375 | 299000.0 |
| 2002-12-26 15:00:00 | CL | Stock | 26.375 | 26.415 | 26.28 | 26.305 | 300600.0 |
| 2002-12-26 16:00:00 | CL | Stock | 26.305 | 26.315 | 26.305 | 26.315 | 54200.0 |
> showing 49 of 18,711 rows — these rows as CSV