PREVIEW / stock_1hour / 2002-12-16
file: by_date/stock_1hour/2002/2002-12-16.parquet size: 432 KB rows: 20,606 symbols: 1,525
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-16 09:00:00 | AAPL | Stock | 0.2657 | 0.2661 | 0.2609 | 0.2654 | 15259552.0 |
| 2002-12-16 10:00:00 | AAPL | Stock | 0.265 | 0.2688 | 0.2643 | 0.2671 | 18022704.0 |
| 2002-12-16 11:00:00 | AAPL | Stock | 0.2675 | 0.2696 | 0.267 | 0.2694 | 17249736.0 |
| 2002-12-16 12:00:00 | AAPL | Stock | 0.2695 | 0.2696 | 0.2632 | 0.2639 | 29537480.0 |
| 2002-12-16 13:00:00 | AAPL | Stock | 0.2639 | 0.2657 | 0.2627 | 0.2645 | 32754456.0 |
| 2002-12-16 14:00:00 | AAPL | Stock | 0.2646 | 0.2662 | 0.2638 | 0.2643 | 23949464.0 |
| 2002-12-16 15:00:00 | AAPL | Stock | 0.2645 | 0.2654 | 0.2627 | 0.265 | 68533640.0 |
| 2002-12-16 16:00:00 | AAPL | Stock | 0.2652 | 0.2661 | 0.2634 | 0.2652 | 6018600.0 |
| 2002-12-16 17:00:00 | AAPL | Stock | 0.2652 | 0.2652 | 0.2652 | 0.2652 | 705600.0 |
| 2002-12-16 18:00:00 | AAPL | Stock | 0.2652 | 0.2652 | 0.2652 | 0.2652 | 11200.0 |
| 2002-12-16 08:00:00 | MSFT | Stock | 26.47 | 28.805 | 26.0 | 26.44 | 82598.0 |
| 2002-12-16 09:00:00 | MSFT | Stock | 26.405 | 26.67 | 26.35 | 26.57 | 4949358.0 |
| 2002-12-16 10:00:00 | MSFT | Stock | 26.5605 | 26.85 | 26.535 | 26.75 | 8551860.0 |
| 2002-12-16 11:00:00 | MSFT | Stock | 26.755 | 26.93 | 26.695 | 26.91 | 7099080.0 |
| 2002-12-16 12:00:00 | MSFT | Stock | 26.91 | 27.0055 | 26.885 | 26.9845 | 5361506.0 |
| 2002-12-16 13:00:00 | MSFT | Stock | 26.995 | 27.07 | 26.9 | 27.03 | 5401134.0 |
| 2002-12-16 14:00:00 | MSFT | Stock | 27.0325 | 27.165 | 27.01 | 27.07 | 5582004.0 |
| 2002-12-16 15:00:00 | MSFT | Stock | 27.065 | 27.275 | 27.055 | 27.25 | 9914358.0 |
| 2002-12-16 16:00:00 | MSFT | Stock | 27.26 | 27.28 | 27.0 | 27.24 | 3135230.0 |
| 2002-12-16 17:00:00 | MSFT | Stock | 27.24 | 27.25 | 27.225 | 27.245 | 443902.0 |
| 2002-12-16 18:00:00 | MSFT | Stock | 27.245 | 27.275 | 27.245 | 27.275 | 3000.0 |
| 2002-12-16 08:00:00 | NVDA | Stock | 0.1111 | 0.1142 | 0.1104 | 0.1139 | 2999040.0 |
| 2002-12-16 09:00:00 | NVDA | Stock | 0.1133 | 0.1142 | 0.1113 | 0.1124 | 85263840.0 |
| 2002-12-16 10:00:00 | NVDA | Stock | 0.1124 | 0.116 | 0.1122 | 0.1153 | 170929200.0 |
| 2002-12-16 11:00:00 | NVDA | Stock | 0.1153 | 0.1167 | 0.1144 | 0.1166 | 152781240.0 |
| 2002-12-16 12:00:00 | NVDA | Stock | 0.1165 | 0.1167 | 0.1155 | 0.1163 | 82397640.0 |
| 2002-12-16 13:00:00 | NVDA | Stock | 0.1164 | 0.1171 | 0.116 | 0.1167 | 89320440.0 |
| 2002-12-16 14:00:00 | NVDA | Stock | 0.1167 | 0.1171 | 0.1163 | 0.1165 | 89389920.0 |
| 2002-12-16 15:00:00 | NVDA | Stock | 0.1166 | 0.1175 | 0.1162 | 0.1169 | 150284400.0 |
| 2002-12-16 16:00:00 | NVDA | Stock | 0.117 | 0.1172 | 0.1167 | 0.1168 | 14010120.0 |
| 2002-12-16 17:00:00 | NVDA | Stock | 0.1168 | 0.1174 | 0.1168 | 0.1173 | 1536000.0 |
| 2002-12-16 18:00:00 | NVDA | Stock | 0.1173 | 0.1173 | 0.1168 | 0.1173 | 581280.0 |
| 2002-12-16 08:00:00 | AMZN | Stock | 1.112 | 1.1165 | 1.112 | 1.115 | 56000.0 |
| 2002-12-16 09:00:00 | AMZN | Stock | 1.115 | 1.115 | 1.102 | 1.1095 | 6345180.0 |
| 2002-12-16 10:00:00 | AMZN | Stock | 1.1095 | 1.1265 | 1.108 | 1.1235 | 15826100.0 |
| 2002-12-16 11:00:00 | AMZN | Stock | 1.124 | 1.1255 | 1.121 | 1.1225 | 8786300.0 |
| 2002-12-16 12:00:00 | AMZN | Stock | 1.1225 | 1.1235 | 1.116 | 1.1196 | 8714000.0 |
| 2002-12-16 13:00:00 | AMZN | Stock | 1.12 | 1.121 | 1.1155 | 1.116 | 10762440.0 |
| 2002-12-16 14:00:00 | AMZN | Stock | 1.1155 | 1.1175 | 1.114 | 1.1155 | 12705400.0 |
| 2002-12-16 15:00:00 | AMZN | Stock | 1.1155 | 1.1265 | 1.115 | 1.125 | 16106460.0 |
| 2002-12-16 16:00:00 | AMZN | Stock | 1.125 | 1.1285 | 1.123 | 1.1255 | 3253860.0 |
| 2002-12-16 17:00:00 | AMZN | Stock | 1.1255 | 1.14 | 1.124 | 1.14 | 262000.0 |
| 2002-12-16 18:00:00 | AMZN | Stock | 1.1255 | 1.1375 | 1.1255 | 1.1375 | 404000.0 |
| 2002-12-16 09:00:00 | CL | Stock | 26.4 | 26.49 | 26.32 | 26.325 | 165600.0 |
| 2002-12-16 10:00:00 | CL | Stock | 26.34 | 26.385 | 26.075 | 26.14 | 416200.0 |
| 2002-12-16 11:00:00 | CL | Stock | 26.14 | 26.46 | 26.14 | 26.425 | 481000.0 |
| 2002-12-16 12:00:00 | CL | Stock | 26.43 | 26.445 | 26.255 | 26.265 | 275200.0 |
| 2002-12-16 13:00:00 | CL | Stock | 26.265 | 26.4 | 26.215 | 26.31 | 490000.0 |
| 2002-12-16 14:00:00 | CL | Stock | 26.32 | 26.34 | 26.285 | 26.29 | 577800.0 |
| 2002-12-16 15:00:00 | CL | Stock | 26.285 | 26.355 | 26.275 | 26.35 | 649600.0 |
> showing 50 of 20,606 rows — these rows as CSV