PREVIEW / stock_1hour / 2003-04-02
file: by_date/stock_1hour/2003/2003-04-02.parquet size: 423 KB rows: 21,042 symbols: 1,568
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-04-02 08:00:00 | AAPL | Stock | 0.2552 | 0.257 | 0.2552 | 0.257 | 795200.0 |
| 2003-04-02 09:00:00 | AAPL | Stock | 0.2566 | 0.2595 | 0.252 | 0.2588 | 34595792.0 |
| 2003-04-02 10:00:00 | AAPL | Stock | 0.2588 | 0.2607 | 0.2584 | 0.2602 | 27240584.0 |
| 2003-04-02 11:00:00 | AAPL | Stock | 0.2604 | 0.2611 | 0.2596 | 0.2596 | 23344328.0 |
| 2003-04-02 12:00:00 | AAPL | Stock | 0.2598 | 0.2605 | 0.2589 | 0.26 | 11229792.0 |
| 2003-04-02 13:00:00 | AAPL | Stock | 0.2604 | 0.2613 | 0.2596 | 0.2609 | 12516448.0 |
| 2003-04-02 14:00:00 | AAPL | Stock | 0.2613 | 0.262 | 0.2604 | 0.2616 | 11924584.0 |
| 2003-04-02 15:00:00 | AAPL | Stock | 0.2618 | 0.2623 | 0.2588 | 0.2607 | 26191256.0 |
| 2003-04-02 16:00:00 | AAPL | Stock | 0.2607 | 0.2621 | 0.2582 | 0.2615 | 3964240.0 |
| 2003-04-02 17:00:00 | AAPL | Stock | 0.2614 | 0.2614 | 0.2605 | 0.2607 | 2794400.0 |
| 2003-04-02 08:00:00 | MSFT | Stock | 24.62 | 25.15 | 24.4 | 25.06 | 1197944.0 |
| 2003-04-02 09:00:00 | MSFT | Stock | 25.06 | 26.0 | 24.55 | 25.502 | 12528656.0 |
| 2003-04-02 10:00:00 | MSFT | Stock | 25.51 | 25.78 | 25.44 | 25.6733 | 10559949.0 |
| 2003-04-02 11:00:00 | MSFT | Stock | 25.68 | 25.83 | 25.62 | 25.73 | 7004673.0 |
| 2003-04-02 12:00:00 | MSFT | Stock | 25.73 | 25.83 | 25.63 | 25.7 | 4669871.0 |
| 2003-04-02 13:00:00 | MSFT | Stock | 25.7 | 25.72 | 25.54 | 25.659 | 6495389.0 |
| 2003-04-02 14:00:00 | MSFT | Stock | 25.659 | 25.75 | 25.569 | 25.689 | 5830255.0 |
| 2003-04-02 15:00:00 | MSFT | Stock | 25.68 | 25.78 | 25.53 | 25.73 | 10891215.0 |
| 2003-04-02 16:00:00 | MSFT | Stock | 25.73 | 25.73 | 25.55 | 25.68 | 1319761.0 |
| 2003-04-02 17:00:00 | MSFT | Stock | 25.67 | 25.72 | 25.5835 | 25.72 | 418656.0 |
| 2003-04-02 18:00:00 | MSFT | Stock | 25.72 | 25.77 | 25.7 | 25.749 | 17370.0 |
| 2003-04-02 08:00:00 | NVDA | Stock | 0.1105 | 0.1162 | 0.1105 | 0.1142 | 5913480.0 |
| 2003-04-02 09:00:00 | NVDA | Stock | 0.1138 | 0.1146 | 0.1105 | 0.1137 | 126065880.0 |
| 2003-04-02 10:00:00 | NVDA | Stock | 0.1137 | 0.1162 | 0.1136 | 0.1153 | 119387880.0 |
| 2003-04-02 11:00:00 | NVDA | Stock | 0.1152 | 0.1162 | 0.1148 | 0.1154 | 76637040.0 |
| 2003-04-02 12:00:00 | NVDA | Stock | 0.1153 | 0.1164 | 0.1153 | 0.1164 | 70780200.0 |
| 2003-04-02 13:00:00 | NVDA | Stock | 0.1163 | 0.1165 | 0.1157 | 0.1162 | 59246880.0 |
| 2003-04-02 14:00:00 | NVDA | Stock | 0.1161 | 0.1162 | 0.1148 | 0.1154 | 90353040.0 |
| 2003-04-02 15:00:00 | NVDA | Stock | 0.1154 | 0.1155 | 0.1138 | 0.1146 | 145272720.0 |
| 2003-04-02 16:00:00 | NVDA | Stock | 0.1146 | 0.1146 | 0.1141 | 0.1146 | 6198840.0 |
| 2003-04-02 17:00:00 | NVDA | Stock | 0.1146 | 0.1149 | 0.1144 | 0.1144 | 1785000.0 |
| 2003-04-02 18:00:00 | NVDA | Stock | 0.1144 | 0.1144 | 0.1144 | 0.1144 | 24000.0 |
| 2003-04-02 08:00:00 | AMZN | Stock | 1.291 | 1.3095 | 1.291 | 1.299 | 644780.0 |
| 2003-04-02 09:00:00 | AMZN | Stock | 1.3 | 1.3005 | 1.277 | 1.299 | 18399560.0 |
| 2003-04-02 10:00:00 | AMZN | Stock | 1.299 | 1.324 | 1.295 | 1.315 | 33000320.0 |
| 2003-04-02 11:00:00 | AMZN | Stock | 1.3155 | 1.3195 | 1.3085 | 1.3122 | 15172340.0 |
| 2003-04-02 12:00:00 | AMZN | Stock | 1.312 | 1.32 | 1.3105 | 1.315 | 12214660.0 |
| 2003-04-02 13:00:00 | AMZN | Stock | 1.314 | 1.3165 | 1.3095 | 1.314 | 8365960.0 |
| 2003-04-02 14:00:00 | AMZN | Stock | 1.3145 | 1.3225 | 1.313 | 1.321 | 12886780.0 |
| 2003-04-02 15:00:00 | AMZN | Stock | 1.321 | 1.323 | 1.3125 | 1.3195 | 18323520.0 |
| 2003-04-02 16:00:00 | AMZN | Stock | 1.319 | 1.325 | 1.316 | 1.3191 | 1880500.0 |
| 2003-04-02 17:00:00 | AMZN | Stock | 1.3188 | 1.319 | 1.3185 | 1.319 | 616000.0 |
| 2003-04-02 09:00:00 | CL | Stock | 27.65 | 27.715 | 27.525 | 27.715 | 356800.0 |
| 2003-04-02 10:00:00 | CL | Stock | 27.72 | 27.815 | 27.57 | 27.785 | 455200.0 |
| 2003-04-02 11:00:00 | CL | Stock | 27.79 | 27.9 | 27.73 | 27.73 | 346800.0 |
| 2003-04-02 12:00:00 | CL | Stock | 27.73 | 27.825 | 27.695 | 27.74 | 547000.0 |
| 2003-04-02 13:00:00 | CL | Stock | 27.745 | 27.78 | 27.69 | 27.76 | 275600.0 |
| 2003-04-02 14:00:00 | CL | Stock | 27.765 | 27.825 | 27.665 | 27.8 | 428000.0 |
| 2003-04-02 15:00:00 | CL | Stock | 27.8 | 27.86 | 27.735 | 27.755 | 897200.0 |
| 2003-04-02 16:00:00 | CL | Stock | 27.75 | 27.755 | 27.725 | 27.725 | 130200.0 |
> showing 50 of 21,042 rows — these rows as CSV