PREVIEW / stock_1hour / 2003-10-14
file: by_date/stock_1hour/2003/2003-10-14.parquet size: 474 KB rows: 22,747 symbols: 1,649
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-14 08:00:00 | AAPL | Stock | 0.4348 | 0.4357 | 0.4348 | 0.4357 | 61600.0 |
| 2003-10-14 09:00:00 | AAPL | Stock | 0.4345 | 0.4375 | 0.4323 | 0.4326 | 27249488.0 |
| 2003-10-14 10:00:00 | AAPL | Stock | 0.4327 | 0.4368 | 0.4323 | 0.4361 | 29070552.0 |
| 2003-10-14 11:00:00 | AAPL | Stock | 0.4361 | 0.4362 | 0.4332 | 0.4334 | 21503608.0 |
| 2003-10-14 12:00:00 | AAPL | Stock | 0.4334 | 0.4357 | 0.4323 | 0.4323 | 16231488.0 |
| 2003-10-14 13:00:00 | AAPL | Stock | 0.4323 | 0.4366 | 0.4319 | 0.4354 | 19779704.0 |
| 2003-10-14 14:00:00 | AAPL | Stock | 0.4354 | 0.4377 | 0.4341 | 0.4363 | 22177624.0 |
| 2003-10-14 15:00:00 | AAPL | Stock | 0.4363 | 0.4418 | 0.4359 | 0.4391 | 69325032.0 |
| 2003-10-14 16:00:00 | AAPL | Stock | 0.4391 | 0.4404 | 0.4366 | 0.4402 | 53502400.0 |
| 2003-10-14 08:00:00 | MSFT | Stock | 28.6 | 28.75 | 28.6 | 28.75 | 50819.0 |
| 2003-10-14 09:00:00 | MSFT | Stock | 28.75 | 28.779 | 28.41 | 28.6 | 5392629.0 |
| 2003-10-14 10:00:00 | MSFT | Stock | 28.6 | 28.63 | 28.509 | 28.59 | 4563296.0 |
| 2003-10-14 11:00:00 | MSFT | Stock | 28.59 | 28.64 | 28.5 | 28.53 | 3713035.0 |
| 2003-10-14 12:00:00 | MSFT | Stock | 28.53 | 28.61 | 28.48 | 28.51 | 2910875.0 |
| 2003-10-14 13:00:00 | MSFT | Stock | 28.51 | 28.65 | 28.51 | 28.6 | 4086332.0 |
| 2003-10-14 14:00:00 | MSFT | Stock | 28.61 | 28.69 | 28.59 | 28.62 | 3498354.0 |
| 2003-10-14 15:00:00 | MSFT | Stock | 28.62 | 28.72 | 28.59 | 28.68 | 6087934.0 |
| 2003-10-14 16:00:00 | MSFT | Stock | 28.67 | 28.85 | 28.51 | 28.83 | 1430932.0 |
| 2003-10-14 17:00:00 | MSFT | Stock | 28.84 | 28.9 | 28.81 | 28.88 | 423899.0 |
| 2003-10-14 18:00:00 | MSFT | Stock | 28.88 | 28.91 | 28.87 | 28.9 | 11430.0 |
| 2003-10-14 08:00:00 | NVDA | Stock | 0.1404 | 0.1404 | 0.1387 | 0.1396 | 1580520.0 |
| 2003-10-14 09:00:00 | NVDA | Stock | 0.14 | 0.1403 | 0.1385 | 0.1395 | 65919360.0 |
| 2003-10-14 10:00:00 | NVDA | Stock | 0.1395 | 0.1424 | 0.1394 | 0.1412 | 113446320.0 |
| 2003-10-14 11:00:00 | NVDA | Stock | 0.1412 | 0.1421 | 0.141 | 0.1413 | 84660360.0 |
| 2003-10-14 12:00:00 | NVDA | Stock | 0.1412 | 0.1417 | 0.1408 | 0.1415 | 68580360.0 |
| 2003-10-14 13:00:00 | NVDA | Stock | 0.1413 | 0.1429 | 0.1411 | 0.1425 | 54257520.0 |
| 2003-10-14 14:00:00 | NVDA | Stock | 0.1425 | 0.1433 | 0.1422 | 0.1431 | 76660440.0 |
| 2003-10-14 15:00:00 | NVDA | Stock | 0.1432 | 0.1438 | 0.1428 | 0.1437 | 104795040.0 |
| 2003-10-14 16:00:00 | NVDA | Stock | 0.1437 | 0.1453 | 0.143 | 0.1441 | 3413280.0 |
| 2003-10-14 17:00:00 | NVDA | Stock | 0.1441 | 0.1448 | 0.1441 | 0.1446 | 1920000.0 |
| 2003-10-14 18:00:00 | NVDA | Stock | 0.145 | 0.1453 | 0.1448 | 0.1453 | 348000.0 |
| 2003-10-14 08:00:00 | AMZN | Stock | 2.915 | 2.9225 | 2.9094 | 2.9095 | 170040.0 |
| 2003-10-14 09:00:00 | AMZN | Stock | 2.91 | 2.915 | 2.89 | 2.91 | 20605080.0 |
| 2003-10-14 10:00:00 | AMZN | Stock | 2.91 | 2.9325 | 2.8925 | 2.928 | 24722660.0 |
| 2003-10-14 11:00:00 | AMZN | Stock | 2.9295 | 2.9395 | 2.922 | 2.928 | 20330360.0 |
| 2003-10-14 12:00:00 | AMZN | Stock | 2.9285 | 2.9605 | 2.925 | 2.9475 | 24268340.0 |
| 2003-10-14 13:00:00 | AMZN | Stock | 2.947 | 2.9775 | 2.9415 | 2.9775 | 25389520.0 |
| 2003-10-14 14:00:00 | AMZN | Stock | 2.9775 | 2.999 | 2.974 | 2.9895 | 38352840.0 |
| 2003-10-14 15:00:00 | AMZN | Stock | 2.988 | 2.9955 | 2.9775 | 2.9955 | 29531600.0 |
| 2003-10-14 16:00:00 | AMZN | Stock | 2.9935 | 3.004 | 2.9875 | 3.001 | 2052840.0 |
| 2003-10-14 17:00:00 | AMZN | Stock | 3.004 | 3.015 | 2.9632 | 3.01 | 1051000.0 |
| 2003-10-14 18:00:00 | AMZN | Stock | 3.011 | 3.0175 | 3.0105 | 3.0165 | 256000.0 |
| 2003-10-14 09:00:00 | CL | Stock | 29.225 | 29.225 | 29.1 | 29.105 | 299400.0 |
| 2003-10-14 10:00:00 | CL | Stock | 29.1 | 29.13 | 29.025 | 29.105 | 368000.0 |
| 2003-10-14 11:00:00 | CL | Stock | 29.11 | 29.12 | 29.015 | 29.04 | 429000.0 |
| 2003-10-14 12:00:00 | CL | Stock | 29.035 | 29.105 | 29.0 | 29.065 | 429600.0 |
| 2003-10-14 13:00:00 | CL | Stock | 29.06 | 29.135 | 29.025 | 29.13 | 183200.0 |
| 2003-10-14 14:00:00 | CL | Stock | 29.135 | 29.17 | 29.095 | 29.1 | 300000.0 |
| 2003-10-14 15:00:00 | CL | Stock | 29.1 | 29.19 | 29.08 | 29.14 | 468800.0 |
| 2003-10-14 16:00:00 | CL | Stock | 29.135 | 29.135 | 29.13 | 29.13 | 426200.0 |
> showing 50 of 22,747 rows — these rows as CSV