PREVIEW / stock_1hour / 2002-12-18
file: by_date/stock_1hour/2002/2002-12-18.parquet size: 407 KB rows: 19,574 symbols: 1,527
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-18 08:00:00 | AAPL | Stock | 0.2655 | 0.2655 | 0.2655 | 0.2655 | 11200.0 |
| 2002-12-18 09:00:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2632 | 0.2643 | 17767232.0 |
| 2002-12-18 10:00:00 | AAPL | Stock | 0.2639 | 0.2641 | 0.2611 | 0.2613 | 28861336.0 |
| 2002-12-18 11:00:00 | AAPL | Stock | 0.2613 | 0.2623 | 0.2609 | 0.2618 | 15985032.0 |
| 2002-12-18 12:00:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2598 | 0.2605 | 10775072.0 |
| 2002-12-18 13:00:00 | AAPL | Stock | 0.2605 | 0.2607 | 0.2589 | 0.2595 | 17118696.0 |
| 2002-12-18 14:00:00 | AAPL | Stock | 0.2595 | 0.2632 | 0.2589 | 0.2595 | 16678648.0 |
| 2002-12-18 15:00:00 | AAPL | Stock | 0.2595 | 0.262 | 0.2593 | 0.26 | 23812152.0 |
| 2002-12-18 16:00:00 | AAPL | Stock | 0.2601 | 0.2621 | 0.26 | 0.2602 | 5533864.0 |
| 2002-12-18 17:00:00 | AAPL | Stock | 0.2602 | 0.2602 | 0.2602 | 0.2602 | 1937600.0 |
| 2002-12-18 08:00:00 | MSFT | Stock | 27.03 | 27.19 | 26.775 | 26.9 | 86100.0 |
| 2002-12-18 09:00:00 | MSFT | Stock | 26.94 | 27.19 | 26.76 | 26.832 | 6535890.0 |
| 2002-12-18 10:00:00 | MSFT | Stock | 26.835 | 26.845 | 26.405 | 26.42 | 14206288.0 |
| 2002-12-18 11:00:00 | MSFT | Stock | 26.415 | 26.615 | 26.41 | 26.55 | 6346374.0 |
| 2002-12-18 12:00:00 | MSFT | Stock | 26.545 | 26.655 | 26.525 | 26.585 | 4024534.0 |
| 2002-12-18 13:00:00 | MSFT | Stock | 26.59 | 26.68 | 26.425 | 26.4665 | 5761268.0 |
| 2002-12-18 14:00:00 | MSFT | Stock | 26.465 | 26.63 | 26.45 | 26.46 | 5858134.0 |
| 2002-12-18 15:00:00 | MSFT | Stock | 26.465 | 26.785 | 26.46 | 26.77 | 10889562.0 |
| 2002-12-18 16:00:00 | MSFT | Stock | 26.78 | 26.995 | 26.55 | 26.91 | 2444422.0 |
| 2002-12-18 17:00:00 | MSFT | Stock | 26.91 | 26.94 | 26.765 | 26.865 | 398600.0 |
| 2002-12-18 18:00:00 | MSFT | Stock | 26.88 | 26.91 | 26.825 | 26.9 | 9798.0 |
| 2002-12-18 08:00:00 | NVDA | Stock | 0.1154 | 0.1154 | 0.1126 | 0.1132 | 2668800.0 |
| 2002-12-18 09:00:00 | NVDA | Stock | 0.1132 | 0.1162 | 0.1089 | 0.1099 | 239695440.0 |
| 2002-12-18 10:00:00 | NVDA | Stock | 0.1099 | 0.1102 | 0.1077 | 0.1078 | 242505720.0 |
| 2002-12-18 11:00:00 | NVDA | Stock | 0.1077 | 0.1098 | 0.1076 | 0.1096 | 106037400.0 |
| 2002-12-18 12:00:00 | NVDA | Stock | 0.1097 | 0.1102 | 0.1092 | 0.1098 | 74121960.0 |
| 2002-12-18 13:00:00 | NVDA | Stock | 0.1098 | 0.1102 | 0.1083 | 0.1087 | 97573320.0 |
| 2002-12-18 14:00:00 | NVDA | Stock | 0.1088 | 0.1096 | 0.1081 | 0.1082 | 73687920.0 |
| 2002-12-18 15:00:00 | NVDA | Stock | 0.1082 | 0.1088 | 0.1075 | 0.1079 | 166031400.0 |
| 2002-12-18 16:00:00 | NVDA | Stock | 0.1079 | 0.1097 | 0.1075 | 0.1097 | 21312000.0 |
| 2002-12-18 17:00:00 | NVDA | Stock | 0.1095 | 0.1095 | 0.1077 | 0.1091 | 2958120.0 |
| 2002-12-18 18:00:00 | NVDA | Stock | 0.109 | 0.1096 | 0.1087 | 0.1096 | 783000.0 |
| 2002-12-18 08:00:00 | AMZN | Stock | 1.1125 | 1.121 | 1.1125 | 1.121 | 50000.0 |
| 2002-12-18 09:00:00 | AMZN | Stock | 1.115 | 1.121 | 1.099 | 1.1055 | 12673680.0 |
| 2002-12-18 10:00:00 | AMZN | Stock | 1.1055 | 1.1075 | 1.1025 | 1.103 | 13644960.0 |
| 2002-12-18 11:00:00 | AMZN | Stock | 1.103 | 1.1075 | 1.1025 | 1.1045 | 8724620.0 |
| 2002-12-18 12:00:00 | AMZN | Stock | 1.1045 | 1.107 | 1.1045 | 1.105 | 4595060.0 |
| 2002-12-18 13:00:00 | AMZN | Stock | 1.105 | 1.106 | 1.103 | 1.1045 | 5934920.0 |
| 2002-12-18 14:00:00 | AMZN | Stock | 1.1045 | 1.1075 | 1.1035 | 1.104 | 3721140.0 |
| 2002-12-18 15:00:00 | AMZN | Stock | 1.104 | 1.108 | 1.1025 | 1.105 | 11276120.0 |
| 2002-12-18 16:00:00 | AMZN | Stock | 1.105 | 1.11 | 1.1045 | 1.105 | 3605560.0 |
| 2002-12-18 17:00:00 | AMZN | Stock | 1.1095 | 1.11 | 1.105 | 1.1065 | 484000.0 |
| 2002-12-18 18:00:00 | AMZN | Stock | 1.1095 | 1.11 | 1.1095 | 1.11 | 4000.0 |
| 2002-12-18 09:00:00 | CL | Stock | 26.15 | 26.37 | 26.15 | 26.37 | 273000.0 |
| 2002-12-18 10:00:00 | CL | Stock | 26.37 | 26.375 | 26.195 | 26.2 | 288200.0 |
| 2002-12-18 11:00:00 | CL | Stock | 26.2 | 26.4 | 26.13 | 26.38 | 274200.0 |
| 2002-12-18 12:00:00 | CL | Stock | 26.38 | 26.425 | 26.275 | 26.29 | 257800.0 |
| 2002-12-18 13:00:00 | CL | Stock | 26.305 | 26.4 | 26.29 | 26.3 | 284200.0 |
| 2002-12-18 14:00:00 | CL | Stock | 26.3 | 26.375 | 26.2 | 26.205 | 415000.0 |
| 2002-12-18 15:00:00 | CL | Stock | 26.21 | 26.315 | 26.175 | 26.31 | 563400.0 |
> showing 50 of 19,574 rows — these rows as CSV