PREVIEW / stock_1hour / 2003-02-25
file: by_date/stock_1hour/2003/2003-02-25.parquet size: 407 KB rows: 19,946 symbols: 1,547
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 |
|---|---|---|---|---|---|---|---|
| 2003-02-25 08:00:00 | AAPL | Stock | 0.2614 | 0.2614 | 0.2614 | 0.2614 | 5600.0 |
| 2003-02-25 09:00:00 | AAPL | Stock | 0.2616 | 0.2639 | 0.2607 | 0.2623 | 23203656.0 |
| 2003-02-25 10:00:00 | AAPL | Stock | 0.2623 | 0.2636 | 0.2605 | 0.2627 | 37230200.0 |
| 2003-02-25 11:00:00 | AAPL | Stock | 0.2625 | 0.2629 | 0.2616 | 0.2625 | 14875000.0 |
| 2003-02-25 12:00:00 | AAPL | Stock | 0.2623 | 0.2636 | 0.2621 | 0.2629 | 9922864.0 |
| 2003-02-25 13:00:00 | AAPL | Stock | 0.263 | 0.2639 | 0.2625 | 0.2636 | 7627648.0 |
| 2003-02-25 14:00:00 | AAPL | Stock | 0.2636 | 0.267 | 0.2636 | 0.2661 | 24424400.0 |
| 2003-02-25 15:00:00 | AAPL | Stock | 0.2661 | 0.2693 | 0.265 | 0.2684 | 42746536.0 |
| 2003-02-25 16:00:00 | AAPL | Stock | 0.2684 | 0.2688 | 0.2661 | 0.2663 | 6241928.0 |
| 2003-02-25 17:00:00 | AAPL | Stock | 0.2682 | 0.2682 | 0.267 | 0.267 | 89600.0 |
| 2003-02-25 08:00:00 | MSFT | Stock | 24.065 | 24.07 | 23.7 | 23.779 | 470816.0 |
| 2003-02-25 09:00:00 | MSFT | Stock | 23.779 | 24.04 | 23.53 | 23.62 | 6798532.0 |
| 2003-02-25 10:00:00 | MSFT | Stock | 23.619 | 23.72 | 23.4 | 23.63 | 11799895.0 |
| 2003-02-25 11:00:00 | MSFT | Stock | 23.65 | 23.65 | 23.47 | 23.51 | 5628090.0 |
| 2003-02-25 12:00:00 | MSFT | Stock | 23.5085 | 23.54 | 23.38 | 23.472 | 4455973.0 |
| 2003-02-25 13:00:00 | MSFT | Stock | 23.47 | 23.63 | 23.46 | 23.58 | 3928957.0 |
| 2003-02-25 14:00:00 | MSFT | Stock | 23.588 | 24.0 | 23.57 | 23.86 | 10151876.0 |
| 2003-02-25 15:00:00 | MSFT | Stock | 23.86 | 24.27 | 23.78 | 24.17 | 14394974.0 |
| 2003-02-25 16:00:00 | MSFT | Stock | 24.19 | 24.213 | 23.78 | 24.02 | 1374842.0 |
| 2003-02-25 17:00:00 | MSFT | Stock | 24.02 | 24.19 | 24.01 | 24.02 | 178800.0 |
| 2003-02-25 18:00:00 | MSFT | Stock | 24.02 | 24.06 | 24.01 | 24.04 | 18750.0 |
| 2003-02-25 08:00:00 | NVDA | Stock | 0.1083 | 0.1087 | 0.106 | 0.1073 | 5235600.0 |
| 2003-02-25 09:00:00 | NVDA | Stock | 0.1072 | 0.1083 | 0.1037 | 0.1046 | 323127000.0 |
| 2003-02-25 10:00:00 | NVDA | Stock | 0.1046 | 0.1057 | 0.1033 | 0.1054 | 235732200.0 |
| 2003-02-25 11:00:00 | NVDA | Stock | 0.1053 | 0.1054 | 0.1039 | 0.1042 | 112245240.0 |
| 2003-02-25 12:00:00 | NVDA | Stock | 0.1043 | 0.1047 | 0.1039 | 0.1043 | 62284080.0 |
| 2003-02-25 13:00:00 | NVDA | Stock | 0.1043 | 0.1049 | 0.1042 | 0.1047 | 65460720.0 |
| 2003-02-25 14:00:00 | NVDA | Stock | 0.1049 | 0.1063 | 0.1047 | 0.1062 | 152922840.0 |
| 2003-02-25 15:00:00 | NVDA | Stock | 0.1062 | 0.1083 | 0.1058 | 0.1077 | 176287560.0 |
| 2003-02-25 16:00:00 | NVDA | Stock | 0.1077 | 0.1082 | 0.1071 | 0.1071 | 7512480.0 |
| 2003-02-25 17:00:00 | NVDA | Stock | 0.1072 | 0.1079 | 0.1072 | 0.1078 | 2486400.0 |
| 2003-02-25 18:00:00 | NVDA | Stock | 0.1073 | 0.1073 | 0.1072 | 0.1072 | 132000.0 |
| 2003-02-25 08:00:00 | AMZN | Stock | 1.08 | 1.089 | 1.075 | 1.075 | 148000.0 |
| 2003-02-25 09:00:00 | AMZN | Stock | 1.077 | 1.089 | 1.074 | 1.075 | 17162000.0 |
| 2003-02-25 10:00:00 | AMZN | Stock | 1.075 | 1.077 | 1.07 | 1.074 | 17435820.0 |
| 2003-02-25 11:00:00 | AMZN | Stock | 1.074 | 1.077 | 1.072 | 1.0755 | 8914200.0 |
| 2003-02-25 12:00:00 | AMZN | Stock | 1.075 | 1.0796 | 1.074 | 1.075 | 11925360.0 |
| 2003-02-25 13:00:00 | AMZN | Stock | 1.0752 | 1.08 | 1.0735 | 1.0785 | 7218720.0 |
| 2003-02-25 14:00:00 | AMZN | Stock | 1.0785 | 1.0875 | 1.076 | 1.0795 | 12793340.0 |
| 2003-02-25 15:00:00 | AMZN | Stock | 1.079 | 1.1 | 1.076 | 1.0925 | 23014160.0 |
| 2003-02-25 16:00:00 | AMZN | Stock | 1.093 | 1.097 | 1.0885 | 1.094 | 1141600.0 |
| 2003-02-25 17:00:00 | AMZN | Stock | 1.094 | 1.094 | 1.094 | 1.094 | 286000.0 |
| 2003-02-25 09:00:00 | CL | Stock | 25.185 | 25.185 | 25.05 | 25.11 | 245600.0 |
| 2003-02-25 10:00:00 | CL | Stock | 25.105 | 25.135 | 24.95 | 25.055 | 375800.0 |
| 2003-02-25 11:00:00 | CL | Stock | 25.05 | 25.175 | 25.025 | 25.05 | 357200.0 |
| 2003-02-25 12:00:00 | CL | Stock | 25.04 | 25.14 | 24.975 | 25.125 | 205200.0 |
| 2003-02-25 13:00:00 | CL | Stock | 25.13 | 25.335 | 25.125 | 25.325 | 267800.0 |
| 2003-02-25 14:00:00 | CL | Stock | 25.315 | 25.45 | 25.285 | 25.41 | 377800.0 |
| 2003-02-25 15:00:00 | CL | Stock | 25.4 | 25.5 | 25.26 | 25.485 | 481600.0 |
| 2003-02-25 16:00:00 | CL | Stock | 25.485 | 25.485 | 25.25 | 25.25 | 193000.0 |
> showing 50 of 19,946 rows — these rows as CSV