PREVIEW / stock_1hour / 2002-12-06
file: by_date/stock_1hour/2002/2002-12-06.parquet size: 407 KB rows: 19,250 symbols: 1,512
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-06 08:00:00 | AAPL | Stock | 0.2668 | 0.267 | 0.2589 | 0.2595 | 686840.0 |
| 2002-12-06 09:00:00 | AAPL | Stock | 0.2595 | 0.2695 | 0.2588 | 0.2691 | 45476088.0 |
| 2002-12-06 10:00:00 | AAPL | Stock | 0.2688 | 0.2713 | 0.2661 | 0.2671 | 58032688.0 |
| 2002-12-06 11:00:00 | AAPL | Stock | 0.267 | 0.2682 | 0.2661 | 0.2677 | 29189440.0 |
| 2002-12-06 12:00:00 | AAPL | Stock | 0.2675 | 0.2689 | 0.2668 | 0.268 | 24210704.0 |
| 2002-12-06 13:00:00 | AAPL | Stock | 0.2682 | 0.2702 | 0.2675 | 0.2688 | 18206048.0 |
| 2002-12-06 14:00:00 | AAPL | Stock | 0.2691 | 0.2696 | 0.2675 | 0.2675 | 19685736.0 |
| 2002-12-06 15:00:00 | AAPL | Stock | 0.2675 | 0.2686 | 0.2661 | 0.267 | 26220320.0 |
| 2002-12-06 16:00:00 | AAPL | Stock | 0.2675 | 0.2679 | 0.265 | 0.267 | 5000800.0 |
| 2002-12-06 17:00:00 | AAPL | Stock | 0.267 | 0.267 | 0.267 | 0.267 | 112000.0 |
| 2002-12-06 18:00:00 | AAPL | Stock | 0.267 | 0.267 | 0.267 | 0.267 | 56000.0 |
| 2002-12-06 08:00:00 | MSFT | Stock | 27.655 | 27.85 | 27.3 | 27.33 | 468194.0 |
| 2002-12-06 09:00:00 | MSFT | Stock | 27.325 | 27.74 | 27.115 | 27.235 | 13113958.0 |
| 2002-12-06 10:00:00 | MSFT | Stock | 27.229 | 27.755 | 27.165 | 27.61 | 17012142.0 |
| 2002-12-06 11:00:00 | MSFT | Stock | 27.61 | 27.865 | 27.5 | 27.7755 | 7796588.0 |
| 2002-12-06 12:00:00 | MSFT | Stock | 27.775 | 27.8 | 27.625 | 27.655 | 7087924.0 |
| 2002-12-06 13:00:00 | MSFT | Stock | 27.655 | 27.85 | 27.54 | 27.745 | 5439504.0 |
| 2002-12-06 14:00:00 | MSFT | Stock | 27.75 | 27.87 | 27.595 | 27.605 | 6171900.0 |
| 2002-12-06 15:00:00 | MSFT | Stock | 27.596 | 27.745 | 27.52 | 27.735 | 8239908.0 |
| 2002-12-06 16:00:00 | MSFT | Stock | 27.73 | 27.8 | 27.22 | 27.8 | 1126886.0 |
| 2002-12-06 17:00:00 | MSFT | Stock | 27.76 | 27.76 | 27.735 | 27.75 | 14800.0 |
| 2002-12-06 08:00:00 | NVDA | Stock | 0.1183 | 0.1217 | 0.1125 | 0.1138 | 13572360.0 |
| 2002-12-06 09:00:00 | NVDA | Stock | 0.1142 | 0.1181 | 0.1107 | 0.1181 | 206582640.0 |
| 2002-12-06 10:00:00 | NVDA | Stock | 0.1179 | 0.12 | 0.1163 | 0.1171 | 323413440.0 |
| 2002-12-06 11:00:00 | NVDA | Stock | 0.117 | 0.1193 | 0.1163 | 0.1192 | 133026600.0 |
| 2002-12-06 12:00:00 | NVDA | Stock | 0.1192 | 0.12 | 0.1179 | 0.1186 | 107374320.0 |
| 2002-12-06 13:00:00 | NVDA | Stock | 0.1185 | 0.1195 | 0.1179 | 0.119 | 74543040.0 |
| 2002-12-06 14:00:00 | NVDA | Stock | 0.119 | 0.1194 | 0.1171 | 0.1173 | 85021920.0 |
| 2002-12-06 15:00:00 | NVDA | Stock | 0.1173 | 0.1185 | 0.1166 | 0.1177 | 128258040.0 |
| 2002-12-06 16:00:00 | NVDA | Stock | 0.1178 | 0.1183 | 0.117 | 0.1182 | 8987160.0 |
| 2002-12-06 17:00:00 | NVDA | Stock | 0.1182 | 0.1182 | 0.1178 | 0.1178 | 1308000.0 |
| 2002-12-06 18:00:00 | NVDA | Stock | 0.1182 | 0.1182 | 0.1177 | 0.1177 | 156000.0 |
| 2002-12-06 08:00:00 | AMZN | Stock | 1.1 | 1.112 | 1.085 | 1.085 | 1182400.0 |
| 2002-12-06 09:00:00 | AMZN | Stock | 1.087 | 1.1285 | 1.0755 | 1.0985 | 44052940.0 |
| 2002-12-06 10:00:00 | AMZN | Stock | 1.098 | 1.1125 | 1.0925 | 1.096 | 40551260.0 |
| 2002-12-06 11:00:00 | AMZN | Stock | 1.0955 | 1.098 | 1.091 | 1.0975 | 18131840.0 |
| 2002-12-06 12:00:00 | AMZN | Stock | 1.0975 | 1.105 | 1.097 | 1.103 | 13236460.0 |
| 2002-12-06 13:00:00 | AMZN | Stock | 1.1035 | 1.125 | 1.1025 | 1.119 | 13397000.0 |
| 2002-12-06 14:00:00 | AMZN | Stock | 1.119 | 1.1235 | 1.113 | 1.113 | 14037900.0 |
| 2002-12-06 15:00:00 | AMZN | Stock | 1.1131 | 1.1345 | 1.1125 | 1.1345 | 24975900.0 |
| 2002-12-06 16:00:00 | AMZN | Stock | 1.1305 | 1.1345 | 1.1085 | 1.1315 | 3114400.0 |
| 2002-12-06 17:00:00 | AMZN | Stock | 1.1315 | 1.1325 | 1.1305 | 1.1315 | 246000.0 |
| 2002-12-06 18:00:00 | AMZN | Stock | 1.1315 | 1.1315 | 1.1305 | 1.1305 | 14000.0 |
| 2002-12-06 09:00:00 | CL | Stock | 26.28 | 26.51 | 26.21 | 26.5 | 338200.0 |
| 2002-12-06 10:00:00 | CL | Stock | 26.55 | 26.595 | 26.25 | 26.28 | 618800.0 |
| 2002-12-06 11:00:00 | CL | Stock | 26.3 | 26.6 | 26.25 | 26.47 | 296600.0 |
| 2002-12-06 12:00:00 | CL | Stock | 26.48 | 26.62 | 26.425 | 26.55 | 203800.0 |
| 2002-12-06 13:00:00 | CL | Stock | 26.565 | 26.62 | 26.45 | 26.525 | 369800.0 |
| 2002-12-06 14:00:00 | CL | Stock | 26.54 | 26.7 | 26.54 | 26.68 | 558200.0 |
| 2002-12-06 15:00:00 | CL | Stock | 26.675 | 26.675 | 26.6 | 26.665 | 627600.0 |
> showing 50 of 19,250 rows — these rows as CSV