PREVIEW / stock_1hour / 2003-11-05
file: by_date/stock_1hour/2003/2003-11-05.parquet size: 486 KB rows: 22,712 symbols: 1,654
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-11-05 08:00:00 | AAPL | Stock | 0.4091 | 0.4091 | 0.4063 | 0.4063 | 106400.0 |
| 2003-11-05 09:00:00 | AAPL | Stock | 0.4089 | 0.4124 | 0.4063 | 0.4098 | 29002064.0 |
| 2003-11-05 10:00:00 | AAPL | Stock | 0.4098 | 0.4098 | 0.4013 | 0.4052 | 30762256.0 |
| 2003-11-05 11:00:00 | AAPL | Stock | 0.4051 | 0.4066 | 0.4039 | 0.4054 | 56655200.0 |
| 2003-11-05 12:00:00 | AAPL | Stock | 0.4054 | 0.4071 | 0.4048 | 0.4066 | 14020160.0 |
| 2003-11-05 13:00:00 | AAPL | Stock | 0.4064 | 0.4091 | 0.4064 | 0.4091 | 30166752.0 |
| 2003-11-05 14:00:00 | AAPL | Stock | 0.4091 | 0.4102 | 0.408 | 0.4089 | 34146168.0 |
| 2003-11-05 15:00:00 | AAPL | Stock | 0.4089 | 0.413 | 0.4082 | 0.4089 | 88206608.0 |
| 2003-11-05 16:00:00 | AAPL | Stock | 0.4111 | 0.4161 | 0.408 | 0.4108 | 13633760.0 |
| 2003-11-05 17:00:00 | AAPL | Stock | 0.4143 | 0.4155 | 0.4143 | 0.4155 | 151200.0 |
| 2003-11-05 18:00:00 | AAPL | Stock | 0.4155 | 0.4159 | 0.4152 | 0.4159 | 526400.0 |
| 2003-11-05 08:00:00 | MSFT | Stock | 26.15 | 26.18 | 26.07 | 26.137 | 46163.0 |
| 2003-11-05 09:00:00 | MSFT | Stock | 26.138 | 26.19 | 26.01 | 26.11 | 8060840.0 |
| 2003-11-05 10:00:00 | MSFT | Stock | 26.11 | 26.15 | 26.0 | 26.04 | 11126994.0 |
| 2003-11-05 11:00:00 | MSFT | Stock | 26.04 | 26.28 | 26.039 | 26.22 | 8480407.0 |
| 2003-11-05 12:00:00 | MSFT | Stock | 26.22 | 26.24 | 26.15 | 26.21 | 2948236.0 |
| 2003-11-05 13:00:00 | MSFT | Stock | 26.22 | 26.24 | 26.16 | 26.19 | 3409419.0 |
| 2003-11-05 14:00:00 | MSFT | Stock | 26.19 | 26.26 | 26.15 | 26.171 | 7018816.0 |
| 2003-11-05 15:00:00 | MSFT | Stock | 26.18 | 26.32 | 26.1 | 26.13 | 12592947.0 |
| 2003-11-05 16:00:00 | MSFT | Stock | 26.12 | 26.38 | 26.1 | 26.33 | 2637453.0 |
| 2003-11-05 17:00:00 | MSFT | Stock | 26.34 | 26.38 | 26.28 | 26.34 | 343100.0 |
| 2003-11-05 18:00:00 | MSFT | Stock | 26.32 | 26.34 | 26.3 | 26.32 | 14900.0 |
| 2003-11-05 08:00:00 | NVDA | Stock | 0.1472 | 0.1509 | 0.1459 | 0.1475 | 13606800.0 |
| 2003-11-05 09:00:00 | NVDA | Stock | 0.1475 | 0.1493 | 0.1464 | 0.1475 | 193878000.0 |
| 2003-11-05 10:00:00 | NVDA | Stock | 0.1476 | 0.1482 | 0.1451 | 0.1459 | 183306720.0 |
| 2003-11-05 11:00:00 | NVDA | Stock | 0.1459 | 0.1482 | 0.1458 | 0.1478 | 79243440.0 |
| 2003-11-05 12:00:00 | NVDA | Stock | 0.1478 | 0.1481 | 0.1469 | 0.1478 | 34544400.0 |
| 2003-11-05 13:00:00 | NVDA | Stock | 0.1479 | 0.1486 | 0.1475 | 0.1481 | 63156480.0 |
| 2003-11-05 14:00:00 | NVDA | Stock | 0.148 | 0.1511 | 0.1479 | 0.1509 | 78200520.0 |
| 2003-11-05 15:00:00 | NVDA | Stock | 0.1509 | 0.1527 | 0.1504 | 0.1504 | 157537560.0 |
| 2003-11-05 16:00:00 | NVDA | Stock | 0.1504 | 0.1526 | 0.1504 | 0.1525 | 15837480.0 |
| 2003-11-05 17:00:00 | NVDA | Stock | 0.1525 | 0.1525 | 0.1521 | 0.1525 | 1356000.0 |
| 2003-11-05 18:00:00 | NVDA | Stock | 0.1526 | 0.1527 | 0.1517 | 0.1518 | 392400.0 |
| 2003-11-05 08:00:00 | AMZN | Stock | 2.83 | 2.8375 | 2.796 | 2.8075 | 146000.0 |
| 2003-11-05 09:00:00 | AMZN | Stock | 2.8075 | 2.8235 | 2.781 | 2.8215 | 21086940.0 |
| 2003-11-05 10:00:00 | AMZN | Stock | 2.8215 | 2.8295 | 2.805 | 2.817 | 21939900.0 |
| 2003-11-05 11:00:00 | AMZN | Stock | 2.8165 | 2.82 | 2.8075 | 2.8145 | 10357840.0 |
| 2003-11-05 12:00:00 | AMZN | Stock | 2.8145 | 2.8175 | 2.806 | 2.813 | 4759020.0 |
| 2003-11-05 13:00:00 | AMZN | Stock | 2.813 | 2.8175 | 2.8055 | 2.809 | 7507680.0 |
| 2003-11-05 14:00:00 | AMZN | Stock | 2.809 | 2.823 | 2.806 | 2.8175 | 9237940.0 |
| 2003-11-05 15:00:00 | AMZN | Stock | 2.8175 | 2.8495 | 2.8125 | 2.8385 | 18968000.0 |
| 2003-11-05 16:00:00 | AMZN | Stock | 2.8385 | 2.862 | 2.811 | 2.8574 | 2217100.0 |
| 2003-11-05 17:00:00 | AMZN | Stock | 2.855 | 2.8575 | 2.84 | 2.8525 | 233840.0 |
| 2003-11-05 09:00:00 | CL | Stock | 26.725 | 26.79 | 26.66 | 26.74 | 477200.0 |
| 2003-11-05 10:00:00 | CL | Stock | 26.74 | 26.75 | 26.55 | 26.575 | 1208200.0 |
| 2003-11-05 11:00:00 | CL | Stock | 26.575 | 26.575 | 26.485 | 26.515 | 1107600.0 |
| 2003-11-05 12:00:00 | CL | Stock | 26.52 | 26.545 | 26.38 | 26.415 | 744000.0 |
| 2003-11-05 13:00:00 | CL | Stock | 26.425 | 26.44 | 26.25 | 26.265 | 784200.0 |
| 2003-11-05 14:00:00 | CL | Stock | 26.265 | 26.3 | 26.12 | 26.265 | 706800.0 |
| 2003-11-05 15:00:00 | CL | Stock | 26.26 | 26.295 | 26.19 | 26.19 | 1321600.0 |
> showing 50 of 22,712 rows — these rows as CSV