PREVIEW / stock_1hour / 2003-11-04
file: by_date/stock_1hour/2003/2003-11-04.parquet size: 493 KB rows: 22,421 symbols: 1,658
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-04 09:00:00 | AAPL | Stock | 0.4134 | 0.4146 | 0.4071 | 0.4082 | 12859504.0 |
| 2003-11-04 10:00:00 | AAPL | Stock | 0.4084 | 0.4088 | 0.4041 | 0.4059 | 45595536.0 |
| 2003-11-04 11:00:00 | AAPL | Stock | 0.4059 | 0.4071 | 0.4051 | 0.4054 | 23706984.0 |
| 2003-11-04 12:00:00 | AAPL | Stock | 0.4054 | 0.4055 | 0.4034 | 0.4046 | 24362464.0 |
| 2003-11-04 13:00:00 | AAPL | Stock | 0.4048 | 0.4086 | 0.4039 | 0.4073 | 40521264.0 |
| 2003-11-04 14:00:00 | AAPL | Stock | 0.4075 | 0.4082 | 0.4059 | 0.408 | 23144464.0 |
| 2003-11-04 15:00:00 | AAPL | Stock | 0.408 | 0.4095 | 0.4071 | 0.4089 | 49349776.0 |
| 2003-11-04 16:00:00 | AAPL | Stock | 0.4089 | 0.4102 | 0.4089 | 0.4095 | 6372800.0 |
| 2003-11-04 17:00:00 | AAPL | Stock | 0.4096 | 0.4096 | 0.4087 | 0.4087 | 201600.0 |
| 2003-11-04 08:00:00 | MSFT | Stock | 26.68 | 26.75 | 26.54 | 26.57 | 275740.0 |
| 2003-11-04 09:00:00 | MSFT | Stock | 26.57 | 26.68 | 26.33 | 26.41 | 9792102.0 |
| 2003-11-04 10:00:00 | MSFT | Stock | 26.41 | 26.42 | 26.259 | 26.27 | 12515214.0 |
| 2003-11-04 11:00:00 | MSFT | Stock | 26.28 | 26.33 | 26.23 | 26.239 | 10820648.0 |
| 2003-11-04 12:00:00 | MSFT | Stock | 26.24 | 26.251 | 26.12 | 26.17 | 9508411.0 |
| 2003-11-04 13:00:00 | MSFT | Stock | 26.17 | 26.19 | 26.04 | 26.09 | 10295994.0 |
| 2003-11-04 14:00:00 | MSFT | Stock | 26.09 | 26.151 | 26.01 | 26.13 | 10461632.0 |
| 2003-11-04 15:00:00 | MSFT | Stock | 26.13 | 26.15 | 26.04 | 26.06 | 9875647.0 |
| 2003-11-04 16:00:00 | MSFT | Stock | 26.06 | 26.13 | 26.02 | 26.129 | 1669806.0 |
| 2003-11-04 17:00:00 | MSFT | Stock | 26.1 | 26.16 | 26.07 | 26.13 | 56827.0 |
| 2003-11-04 18:00:00 | MSFT | Stock | 26.11 | 26.14 | 26.11 | 26.111 | 8175.0 |
| 2003-11-04 08:00:00 | NVDA | Stock | 0.1506 | 0.1506 | 0.15 | 0.1501 | 540000.0 |
| 2003-11-04 09:00:00 | NVDA | Stock | 0.1501 | 0.1537 | 0.15 | 0.1519 | 116077080.0 |
| 2003-11-04 10:00:00 | NVDA | Stock | 0.152 | 0.1521 | 0.1504 | 0.1512 | 101385000.0 |
| 2003-11-04 11:00:00 | NVDA | Stock | 0.1512 | 0.1521 | 0.1509 | 0.1514 | 84358920.0 |
| 2003-11-04 12:00:00 | NVDA | Stock | 0.1514 | 0.1516 | 0.1511 | 0.1512 | 56883120.0 |
| 2003-11-04 13:00:00 | NVDA | Stock | 0.1513 | 0.1515 | 0.1502 | 0.1503 | 61183560.0 |
| 2003-11-04 14:00:00 | NVDA | Stock | 0.1503 | 0.1513 | 0.1496 | 0.151 | 85870560.0 |
| 2003-11-04 15:00:00 | NVDA | Stock | 0.151 | 0.1511 | 0.1496 | 0.1502 | 141316680.0 |
| 2003-11-04 16:00:00 | NVDA | Stock | 0.1508 | 0.151 | 0.1499 | 0.1502 | 1678440.0 |
| 2003-11-04 17:00:00 | NVDA | Stock | 0.15 | 0.1503 | 0.1493 | 0.1493 | 784920.0 |
| 2003-11-04 18:00:00 | NVDA | Stock | 0.1496 | 0.1496 | 0.1496 | 0.1496 | 12000.0 |
| 2003-11-04 08:00:00 | AMZN | Stock | 2.8465 | 2.8465 | 2.825 | 2.8265 | 113300.0 |
| 2003-11-04 09:00:00 | AMZN | Stock | 2.835 | 2.85 | 2.8105 | 2.8155 | 21755880.0 |
| 2003-11-04 10:00:00 | AMZN | Stock | 2.817 | 2.837 | 2.803 | 2.8355 | 22527940.0 |
| 2003-11-04 11:00:00 | AMZN | Stock | 2.8351 | 2.8745 | 2.8345 | 2.8625 | 25722880.0 |
| 2003-11-04 12:00:00 | AMZN | Stock | 2.8615 | 2.8635 | 2.845 | 2.8466 | 13632860.0 |
| 2003-11-04 13:00:00 | AMZN | Stock | 2.8465 | 2.8505 | 2.83 | 2.8365 | 11199600.0 |
| 2003-11-04 14:00:00 | AMZN | Stock | 2.8365 | 2.86 | 2.8235 | 2.8585 | 15080880.0 |
| 2003-11-04 15:00:00 | AMZN | Stock | 2.8585 | 2.859 | 2.83 | 2.8425 | 13597760.0 |
| 2003-11-04 16:00:00 | AMZN | Stock | 2.8425 | 2.8445 | 2.805 | 2.8145 | 3119900.0 |
| 2003-11-04 17:00:00 | AMZN | Stock | 2.8145 | 2.8367 | 2.81 | 2.8145 | 108000.0 |
| 2003-11-04 18:00:00 | AMZN | Stock | 2.8145 | 2.8155 | 2.8125 | 2.8125 | 57000.0 |
| 2003-11-04 09:00:00 | CL | Stock | 26.75 | 26.75 | 26.575 | 26.745 | 830378.0 |
| 2003-11-04 10:00:00 | CL | Stock | 26.735 | 26.8 | 26.65 | 26.706 | 707110.0 |
| 2003-11-04 11:00:00 | CL | Stock | 26.725 | 26.78 | 26.635 | 26.65 | 1060820.0 |
| 2003-11-04 12:00:00 | CL | Stock | 26.66 | 26.69 | 26.635 | 26.64 | 680560.0 |
| 2003-11-04 13:00:00 | CL | Stock | 26.645 | 26.685 | 26.61 | 26.67 | 363516.0 |
| 2003-11-04 14:00:00 | CL | Stock | 26.675 | 26.675 | 26.6 | 26.61 | 460150.0 |
| 2003-11-04 15:00:00 | CL | Stock | 26.61 | 26.67 | 26.6 | 26.65 | 875708.0 |
| 2003-11-04 16:00:00 | CL | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 114984.0 |
> showing 50 of 22,421 rows — these rows as CSV