PREVIEW / stock_1hour / 2003-08-11
file: by_date/stock_1hour/2003/2003-08-11.parquet size: 442 KB rows: 21,231 symbols: 1,600
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-08-11 09:00:00 | AAPL | Stock | 0.3511 | 0.3557 | 0.3504 | 0.3529 | 15561336.0 |
| 2003-08-11 10:00:00 | AAPL | Stock | 0.3529 | 0.3559 | 0.352 | 0.3539 | 22036728.0 |
| 2003-08-11 11:00:00 | AAPL | Stock | 0.3543 | 0.3546 | 0.3486 | 0.3521 | 16116856.0 |
| 2003-08-11 12:00:00 | AAPL | Stock | 0.3521 | 0.3527 | 0.35 | 0.35 | 10629528.0 |
| 2003-08-11 13:00:00 | AAPL | Stock | 0.35 | 0.3514 | 0.35 | 0.3504 | 6485360.0 |
| 2003-08-11 14:00:00 | AAPL | Stock | 0.3502 | 0.3509 | 0.3491 | 0.3491 | 14370664.0 |
| 2003-08-11 15:00:00 | AAPL | Stock | 0.3491 | 0.3516 | 0.3484 | 0.3509 | 30233280.0 |
| 2003-08-11 16:00:00 | AAPL | Stock | 0.3509 | 0.3511 | 0.3489 | 0.3511 | 778400.0 |
| 2003-08-11 17:00:00 | AAPL | Stock | 0.3511 | 0.3511 | 0.3511 | 0.3511 | 470400.0 |
| 2003-08-11 08:00:00 | MSFT | Stock | 25.55 | 25.62 | 25.39 | 25.6 | 17131.0 |
| 2003-08-11 09:00:00 | MSFT | Stock | 25.6 | 25.78 | 25.54 | 25.74 | 3980637.0 |
| 2003-08-11 10:00:00 | MSFT | Stock | 25.73 | 25.99 | 25.71 | 25.89 | 6718971.0 |
| 2003-08-11 11:00:00 | MSFT | Stock | 25.9 | 25.93 | 25.55 | 25.65 | 6840087.0 |
| 2003-08-11 12:00:00 | MSFT | Stock | 25.65 | 25.721 | 25.56 | 25.59 | 2809296.0 |
| 2003-08-11 13:00:00 | MSFT | Stock | 25.597 | 25.721 | 25.58 | 25.66 | 2656554.0 |
| 2003-08-11 14:00:00 | MSFT | Stock | 25.66 | 25.72 | 25.56 | 25.609 | 4181098.0 |
| 2003-08-11 15:00:00 | MSFT | Stock | 25.61 | 25.71 | 25.57 | 25.6 | 5515475.0 |
| 2003-08-11 16:00:00 | MSFT | Stock | 25.61 | 25.7 | 25.56 | 25.69 | 585858.0 |
| 2003-08-11 17:00:00 | MSFT | Stock | 25.67 | 25.69 | 25.63 | 25.64 | 9700.0 |
| 2003-08-11 18:00:00 | MSFT | Stock | 25.64 | 25.66 | 25.632 | 25.65 | 2570.0 |
| 2003-08-11 08:00:00 | NVDA | Stock | 0.13 | 0.1308 | 0.1283 | 0.13 | 9750600.0 |
| 2003-08-11 09:00:00 | NVDA | Stock | 0.1298 | 0.1361 | 0.1298 | 0.1353 | 412822440.0 |
| 2003-08-11 10:00:00 | NVDA | Stock | 0.1355 | 0.1366 | 0.1346 | 0.1354 | 425559120.0 |
| 2003-08-11 11:00:00 | NVDA | Stock | 0.1354 | 0.1373 | 0.1349 | 0.1359 | 237527160.0 |
| 2003-08-11 12:00:00 | NVDA | Stock | 0.1358 | 0.1364 | 0.1354 | 0.1359 | 102039120.0 |
| 2003-08-11 13:00:00 | NVDA | Stock | 0.1359 | 0.1367 | 0.1358 | 0.1365 | 71202480.0 |
| 2003-08-11 14:00:00 | NVDA | Stock | 0.1365 | 0.1372 | 0.1359 | 0.1363 | 115405800.0 |
| 2003-08-11 15:00:00 | NVDA | Stock | 0.1362 | 0.1369 | 0.1355 | 0.1362 | 183231240.0 |
| 2003-08-11 16:00:00 | NVDA | Stock | 0.1362 | 0.1373 | 0.1344 | 0.1369 | 8296800.0 |
| 2003-08-11 17:00:00 | NVDA | Stock | 0.1369 | 0.1371 | 0.1368 | 0.1369 | 861600.0 |
| 2003-08-11 18:00:00 | NVDA | Stock | 0.1372 | 0.1372 | 0.1367 | 0.1367 | 2226000.0 |
| 2003-08-11 08:00:00 | AMZN | Stock | 1.9575 | 1.9575 | 1.955 | 1.955 | 22000.0 |
| 2003-08-11 09:00:00 | AMZN | Stock | 1.9545 | 1.9545 | 1.9375 | 1.9425 | 14572760.0 |
| 2003-08-11 10:00:00 | AMZN | Stock | 1.9435 | 1.9505 | 1.9175 | 1.9362 | 28713760.0 |
| 2003-08-11 11:00:00 | AMZN | Stock | 1.936 | 1.943 | 1.922 | 1.9235 | 13486140.0 |
| 2003-08-11 12:00:00 | AMZN | Stock | 1.9235 | 1.9345 | 1.923 | 1.928 | 9500140.0 |
| 2003-08-11 13:00:00 | AMZN | Stock | 1.928 | 1.94 | 1.928 | 1.9325 | 8090160.0 |
| 2003-08-11 14:00:00 | AMZN | Stock | 1.9325 | 1.938 | 1.9315 | 1.937 | 6099920.0 |
| 2003-08-11 15:00:00 | AMZN | Stock | 1.937 | 1.95 | 1.9338 | 1.946 | 15836220.0 |
| 2003-08-11 16:00:00 | AMZN | Stock | 1.9465 | 1.9515 | 1.9385 | 1.9435 | 892440.0 |
| 2003-08-11 17:00:00 | AMZN | Stock | 1.951 | 1.9515 | 1.951 | 1.9515 | 36000.0 |
| 2003-08-11 09:00:00 | CL | Stock | 27.575 | 27.64 | 27.55 | 27.62 | 228600.0 |
| 2003-08-11 10:00:00 | CL | Stock | 27.615 | 27.81 | 27.57 | 27.755 | 529800.0 |
| 2003-08-11 11:00:00 | CL | Stock | 27.745 | 27.75 | 27.675 | 27.73 | 333200.0 |
| 2003-08-11 12:00:00 | CL | Stock | 27.735 | 27.745 | 27.66 | 27.67 | 163000.0 |
| 2003-08-11 13:00:00 | CL | Stock | 27.67 | 27.73 | 27.64 | 27.645 | 731800.0 |
| 2003-08-11 14:00:00 | CL | Stock | 27.645 | 27.67 | 27.585 | 27.615 | 223200.0 |
| 2003-08-11 15:00:00 | CL | Stock | 27.62 | 27.7 | 27.585 | 27.62 | 458400.0 |
| 2003-08-11 16:00:00 | CL | Stock | 27.62 | 27.62 | 27.62 | 27.62 | 34600.0 |
> showing 49 of 21,231 rows — these rows as CSV