PREVIEW / stock_1hour / 2002-12-23
file: by_date/stock_1hour/2002/2002-12-23.parquet size: 415 KB rows: 19,944 symbols: 1,535
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-23 09:00:00 | AAPL | Stock | 0.253 | 0.2557 | 0.2521 | 0.2552 | 15521240.0 |
| 2002-12-23 10:00:00 | AAPL | Stock | 0.2552 | 0.2598 | 0.255 | 0.2589 | 28025424.0 |
| 2002-12-23 11:00:00 | AAPL | Stock | 0.2589 | 0.2595 | 0.2577 | 0.2584 | 12174512.0 |
| 2002-12-23 12:00:00 | AAPL | Stock | 0.2586 | 0.2589 | 0.2575 | 0.2582 | 8455384.0 |
| 2002-12-23 13:00:00 | AAPL | Stock | 0.2582 | 0.2584 | 0.2568 | 0.257 | 9816296.0 |
| 2002-12-23 14:00:00 | AAPL | Stock | 0.2569 | 0.258 | 0.2568 | 0.2571 | 9736496.0 |
| 2002-12-23 15:00:00 | AAPL | Stock | 0.2573 | 0.2593 | 0.2571 | 0.2593 | 21114800.0 |
| 2002-12-23 16:00:00 | AAPL | Stock | 0.2595 | 0.2595 | 0.2588 | 0.2588 | 4474400.0 |
| 2002-12-23 18:00:00 | AAPL | Stock | 0.2589 | 0.2593 | 0.2589 | 0.2589 | 201600.0 |
| 2002-12-23 08:00:00 | MSFT | Stock | 26.475 | 26.55 | 26.275 | 26.45 | 126400.0 |
| 2002-12-23 09:00:00 | MSFT | Stock | 26.45 | 26.725 | 26.45 | 26.6745 | 7456012.0 |
| 2002-12-23 10:00:00 | MSFT | Stock | 26.675 | 27.06 | 26.635 | 27.04 | 8250652.0 |
| 2002-12-23 11:00:00 | MSFT | Stock | 27.0355 | 27.14 | 27.01 | 27.044 | 6588410.0 |
| 2002-12-23 12:00:00 | MSFT | Stock | 27.045 | 27.105 | 27.0055 | 27.065 | 3426156.0 |
| 2002-12-23 13:00:00 | MSFT | Stock | 27.06 | 27.095 | 26.9 | 26.935 | 3321872.0 |
| 2002-12-23 14:00:00 | MSFT | Stock | 26.935 | 27.025 | 26.815 | 26.92 | 4989440.0 |
| 2002-12-23 15:00:00 | MSFT | Stock | 26.915 | 27.07 | 26.88 | 27.0 | 6710202.0 |
| 2002-12-23 16:00:00 | MSFT | Stock | 27.0 | 27.02 | 26.7855 | 26.85 | 2652098.0 |
| 2002-12-23 17:00:00 | MSFT | Stock | 26.875 | 26.945 | 26.855 | 26.91 | 20770.0 |
| 2002-12-23 18:00:00 | MSFT | Stock | 26.95 | 26.95 | 26.95 | 26.95 | 600.0 |
| 2002-12-23 08:00:00 | NVDA | Stock | 0.1068 | 0.1068 | 0.1062 | 0.1062 | 720000.0 |
| 2002-12-23 09:00:00 | NVDA | Stock | 0.1068 | 0.1092 | 0.1062 | 0.1077 | 99023040.0 |
| 2002-12-23 10:00:00 | NVDA | Stock | 0.1077 | 0.1102 | 0.1077 | 0.1097 | 99377400.0 |
| 2002-12-23 11:00:00 | NVDA | Stock | 0.1097 | 0.11 | 0.1077 | 0.1079 | 58085040.0 |
| 2002-12-23 12:00:00 | NVDA | Stock | 0.108 | 0.1086 | 0.1077 | 0.1079 | 56894520.0 |
| 2002-12-23 13:00:00 | NVDA | Stock | 0.1079 | 0.1081 | 0.1074 | 0.1074 | 36676200.0 |
| 2002-12-23 14:00:00 | NVDA | Stock | 0.1074 | 0.1079 | 0.1071 | 0.1077 | 33016080.0 |
| 2002-12-23 15:00:00 | NVDA | Stock | 0.1076 | 0.1081 | 0.1073 | 0.1077 | 59376120.0 |
| 2002-12-23 16:00:00 | NVDA | Stock | 0.1077 | 0.1081 | 0.1075 | 0.1076 | 7689120.0 |
| 2002-12-23 17:00:00 | NVDA | Stock | 0.1081 | 0.1081 | 0.1077 | 0.1077 | 720000.0 |
| 2002-12-23 08:00:00 | AMZN | Stock | 1.09 | 1.1 | 1.087 | 1.0945 | 628000.0 |
| 2002-12-23 09:00:00 | AMZN | Stock | 1.0925 | 1.1025 | 1.089 | 1.097 | 10501380.0 |
| 2002-12-23 10:00:00 | AMZN | Stock | 1.0966 | 1.1035 | 1.0965 | 1.103 | 13047520.0 |
| 2002-12-23 11:00:00 | AMZN | Stock | 1.1026 | 1.105 | 1.1 | 1.103 | 6092800.0 |
| 2002-12-23 12:00:00 | AMZN | Stock | 1.1025 | 1.115 | 1.1005 | 1.1125 | 14842380.0 |
| 2002-12-23 13:00:00 | AMZN | Stock | 1.1125 | 1.1235 | 1.112 | 1.112 | 9115560.0 |
| 2002-12-23 14:00:00 | AMZN | Stock | 1.112 | 1.1135 | 1.1085 | 1.11 | 7589340.0 |
| 2002-12-23 15:00:00 | AMZN | Stock | 1.11 | 1.114 | 1.1095 | 1.113 | 12722080.0 |
| 2002-12-23 16:00:00 | AMZN | Stock | 1.1125 | 1.1135 | 1.11 | 1.112 | 3102280.0 |
| 2002-12-23 17:00:00 | AMZN | Stock | 1.1145 | 1.1145 | 1.112 | 1.112 | 56000.0 |
| 2002-12-23 09:00:00 | CL | Stock | 26.195 | 26.2 | 26.12 | 26.145 | 182200.0 |
| 2002-12-23 10:00:00 | CL | Stock | 26.14 | 26.35 | 26.095 | 26.345 | 346600.0 |
| 2002-12-23 11:00:00 | CL | Stock | 26.35 | 26.545 | 26.35 | 26.44 | 440000.0 |
| 2002-12-23 12:00:00 | CL | Stock | 26.425 | 26.51 | 26.365 | 26.425 | 192800.0 |
| 2002-12-23 13:00:00 | CL | Stock | 26.42 | 26.425 | 26.32 | 26.35 | 167000.0 |
| 2002-12-23 14:00:00 | CL | Stock | 26.35 | 26.35 | 26.3 | 26.305 | 132800.0 |
| 2002-12-23 15:00:00 | CL | Stock | 26.31 | 26.345 | 26.27 | 26.335 | 310000.0 |
| 2002-12-23 16:00:00 | CL | Stock | 26.325 | 26.325 | 26.32 | 26.32 | 76600.0 |
> showing 48 of 19,944 rows — these rows as CSV