PREVIEW / stock_1hour / 2003-10-28
file: by_date/stock_1hour/2003/2003-10-28.parquet size: 501 KB rows: 23,279 symbols: 1,655
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-10-28 08:00:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.4036 | 0.4036 | 28000.0 |
| 2003-10-28 09:00:00 | AAPL | Stock | 0.4032 | 0.4054 | 0.4 | 0.4036 | 19934040.0 |
| 2003-10-28 10:00:00 | AAPL | Stock | 0.4036 | 0.4061 | 0.402 | 0.4046 | 25297720.0 |
| 2003-10-28 11:00:00 | AAPL | Stock | 0.4046 | 0.4063 | 0.403 | 0.4063 | 14237104.0 |
| 2003-10-28 12:00:00 | AAPL | Stock | 0.4063 | 0.408 | 0.4055 | 0.4057 | 18423720.0 |
| 2003-10-28 13:00:00 | AAPL | Stock | 0.4061 | 0.4105 | 0.4055 | 0.4098 | 28328944.0 |
| 2003-10-28 14:00:00 | AAPL | Stock | 0.4098 | 0.4171 | 0.4084 | 0.4168 | 47076848.0 |
| 2003-10-28 15:00:00 | AAPL | Stock | 0.417 | 0.4245 | 0.4157 | 0.4229 | 74041968.0 |
| 2003-10-28 16:00:00 | AAPL | Stock | 0.4218 | 0.4261 | 0.4205 | 0.4241 | 3533152.0 |
| 2003-10-28 17:00:00 | AAPL | Stock | 0.425 | 0.425 | 0.4198 | 0.4225 | 985600.0 |
| 2003-10-28 08:00:00 | MSFT | Stock | 27.0 | 27.11 | 27.0 | 27.08 | 124053.0 |
| 2003-10-28 09:00:00 | MSFT | Stock | 27.07 | 27.17 | 26.989 | 27.09 | 7732060.0 |
| 2003-10-28 10:00:00 | MSFT | Stock | 27.09 | 27.22 | 27.05 | 27.09 | 9589115.0 |
| 2003-10-28 11:00:00 | MSFT | Stock | 27.08 | 27.13 | 27.0 | 27.05 | 6416633.0 |
| 2003-10-28 12:00:00 | MSFT | Stock | 27.059 | 27.15 | 27.01 | 27.05 | 6231873.0 |
| 2003-10-28 13:00:00 | MSFT | Stock | 27.05 | 27.07 | 27.0 | 27.02 | 4410907.0 |
| 2003-10-28 14:00:00 | MSFT | Stock | 27.029 | 27.05 | 26.88 | 26.98 | 12873103.0 |
| 2003-10-28 15:00:00 | MSFT | Stock | 26.98 | 27.21 | 26.92 | 27.21 | 15798710.0 |
| 2003-10-28 16:00:00 | MSFT | Stock | 27.19 | 27.25 | 27.09 | 27.2 | 1201495.0 |
| 2003-10-28 17:00:00 | MSFT | Stock | 27.18 | 27.263 | 27.15 | 27.2 | 380346.0 |
| 2003-10-28 18:00:00 | MSFT | Stock | 27.17 | 27.21 | 26.9548 | 27.161 | 29373.0 |
| 2003-10-28 08:00:00 | NVDA | Stock | 0.1439 | 0.145 | 0.1439 | 0.1449 | 528000.0 |
| 2003-10-28 09:00:00 | NVDA | Stock | 0.1443 | 0.1471 | 0.1443 | 0.1468 | 91201320.0 |
| 2003-10-28 10:00:00 | NVDA | Stock | 0.1469 | 0.1487 | 0.1465 | 0.1486 | 213661800.0 |
| 2003-10-28 11:00:00 | NVDA | Stock | 0.1486 | 0.1506 | 0.1484 | 0.1496 | 179406360.0 |
| 2003-10-28 12:00:00 | NVDA | Stock | 0.1496 | 0.15 | 0.1487 | 0.1492 | 56278320.0 |
| 2003-10-28 13:00:00 | NVDA | Stock | 0.1492 | 0.1502 | 0.1491 | 0.15 | 47403600.0 |
| 2003-10-28 14:00:00 | NVDA | Stock | 0.15 | 0.1509 | 0.1488 | 0.1507 | 91600200.0 |
| 2003-10-28 15:00:00 | NVDA | Stock | 0.1506 | 0.1529 | 0.1502 | 0.1525 | 173621640.0 |
| 2003-10-28 16:00:00 | NVDA | Stock | 0.1525 | 0.1532 | 0.1517 | 0.1524 | 23940000.0 |
| 2003-10-28 17:00:00 | NVDA | Stock | 0.1523 | 0.1536 | 0.1521 | 0.1536 | 684000.0 |
| 2003-10-28 18:00:00 | NVDA | Stock | 0.1523 | 0.1525 | 0.1521 | 0.1521 | 222720.0 |
| 2003-10-28 08:00:00 | AMZN | Stock | 2.7428 | 2.7635 | 2.7428 | 2.7545 | 721600.0 |
| 2003-10-28 09:00:00 | AMZN | Stock | 2.755 | 2.76 | 2.7275 | 2.7355 | 19543200.0 |
| 2003-10-28 10:00:00 | AMZN | Stock | 2.735 | 2.75 | 2.7274 | 2.7465 | 22195000.0 |
| 2003-10-28 11:00:00 | AMZN | Stock | 2.7465 | 2.7495 | 2.7355 | 2.7495 | 10966640.0 |
| 2003-10-28 12:00:00 | AMZN | Stock | 2.748 | 2.759 | 2.745 | 2.758 | 9588340.0 |
| 2003-10-28 13:00:00 | AMZN | Stock | 2.758 | 2.7625 | 2.75 | 2.757 | 8211560.0 |
| 2003-10-28 14:00:00 | AMZN | Stock | 2.757 | 2.773 | 2.7555 | 2.766 | 22449300.0 |
| 2003-10-28 15:00:00 | AMZN | Stock | 2.767 | 2.845 | 2.766 | 2.8365 | 63036440.0 |
| 2003-10-28 16:00:00 | AMZN | Stock | 2.8365 | 2.8415 | 2.8204 | 2.8285 | 9817460.0 |
| 2003-10-28 17:00:00 | AMZN | Stock | 2.833 | 2.8376 | 2.8255 | 2.8255 | 839520.0 |
| 2003-10-28 18:00:00 | AMZN | Stock | 2.8275 | 2.832 | 2.8275 | 2.832 | 96580.0 |
| 2003-10-28 09:00:00 | CL | Stock | 25.545 | 25.675 | 25.425 | 25.55 | 1021400.0 |
| 2003-10-28 10:00:00 | CL | Stock | 25.545 | 25.725 | 25.545 | 25.625 | 1353800.0 |
| 2003-10-28 11:00:00 | CL | Stock | 25.625 | 25.635 | 25.45 | 25.5 | 1105400.0 |
| 2003-10-28 12:00:00 | CL | Stock | 25.505 | 25.55 | 25.46 | 25.495 | 627800.0 |
| 2003-10-28 13:00:00 | CL | Stock | 25.495 | 25.505 | 25.255 | 25.395 | 1253800.0 |
| 2003-10-28 14:00:00 | CL | Stock | 25.395 | 25.395 | 25.255 | 25.325 | 1327800.0 |
| 2003-10-28 15:00:00 | CL | Stock | 25.325 | 25.68 | 25.325 | 25.575 | 3022600.0 |
> showing 50 of 23,279 rows — these rows as CSV