PREVIEW / stock_1hour / 2001-12-26
file: by_date/stock_1hour/2001/2001-12-26.parquet size: 375 KB rows: 17,939 symbols: 1,358
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-26 09:00:00 | AAPL | Stock | 0.382 | 0.3898 | 0.3795 | 0.3888 | 13927200.0 |
| 2001-12-26 10:00:00 | AAPL | Stock | 0.3889 | 0.3948 | 0.3886 | 0.3909 | 30895200.0 |
| 2001-12-26 11:00:00 | AAPL | Stock | 0.3907 | 0.3924 | 0.3902 | 0.392 | 15461600.0 |
| 2001-12-26 12:00:00 | AAPL | Stock | 0.392 | 0.392 | 0.3893 | 0.3914 | 11317600.0 |
| 2001-12-26 13:00:00 | AAPL | Stock | 0.3911 | 0.3916 | 0.3902 | 0.3905 | 7190400.0 |
| 2001-12-26 14:00:00 | AAPL | Stock | 0.3905 | 0.3907 | 0.387 | 0.3891 | 16559200.0 |
| 2001-12-26 15:00:00 | AAPL | Stock | 0.3891 | 0.3893 | 0.3775 | 0.3848 | 44598400.0 |
| 2001-12-26 16:00:00 | AAPL | Stock | 0.385 | 0.3863 | 0.3807 | 0.3838 | 4284000.0 |
| 2001-12-26 17:00:00 | AAPL | Stock | 0.3848 | 0.3848 | 0.3848 | 0.3848 | 67200.0 |
| 2001-12-26 08:00:00 | MSFT | Stock | 33.7 | 33.705 | 33.695 | 33.705 | 1800.0 |
| 2001-12-26 09:00:00 | MSFT | Stock | 33.725 | 34.195 | 33.655 | 34.1945 | 3487600.0 |
| 2001-12-26 10:00:00 | MSFT | Stock | 34.1805 | 34.445 | 34.145 | 34.3955 | 5883000.0 |
| 2001-12-26 11:00:00 | MSFT | Stock | 34.3905 | 34.505 | 34.355 | 34.46 | 3334000.0 |
| 2001-12-26 12:00:00 | MSFT | Stock | 34.46 | 34.495 | 34.4 | 34.41 | 2395600.0 |
| 2001-12-26 13:00:00 | MSFT | Stock | 34.405 | 34.435 | 34.315 | 34.35 | 3037800.0 |
| 2001-12-26 14:00:00 | MSFT | Stock | 34.355 | 34.43 | 34.34 | 34.425 | 2585400.0 |
| 2001-12-26 15:00:00 | MSFT | Stock | 34.425 | 34.45 | 33.83 | 33.835 | 6550000.0 |
| 2001-12-26 16:00:00 | MSFT | Stock | 33.835 | 34.4743 | 33.815 | 33.895 | 1438400.0 |
| 2001-12-26 17:00:00 | MSFT | Stock | 33.89 | 33.9 | 33.89 | 33.9 | 2200.0 |
| 2001-12-26 18:00:00 | MSFT | Stock | 33.9 | 33.9 | 33.9 | 33.9 | 1000.0 |
| 2001-12-26 08:00:00 | NVDA | Stock | 0.55 | 0.5562 | 0.55 | 0.5517 | 444000.0 |
| 2001-12-26 09:00:00 | NVDA | Stock | 0.5537 | 0.5682 | 0.5519 | 0.5662 | 123384000.0 |
| 2001-12-26 10:00:00 | NVDA | Stock | 0.5662 | 0.5727 | 0.5658 | 0.5713 | 150840000.0 |
| 2001-12-26 11:00:00 | NVDA | Stock | 0.5717 | 0.5745 | 0.5687 | 0.5735 | 79392000.0 |
| 2001-12-26 12:00:00 | NVDA | Stock | 0.5734 | 0.5736 | 0.5694 | 0.5707 | 35496000.0 |
| 2001-12-26 13:00:00 | NVDA | Stock | 0.5707 | 0.5716 | 0.5667 | 0.5683 | 51792000.0 |
| 2001-12-26 14:00:00 | NVDA | Stock | 0.5683 | 0.5717 | 0.5677 | 0.5704 | 42576000.0 |
| 2001-12-26 15:00:00 | NVDA | Stock | 0.5704 | 0.5717 | 0.5629 | 0.5652 | 114864000.0 |
| 2001-12-26 16:00:00 | NVDA | Stock | 0.5652 | 0.5697 | 0.5644 | 0.5667 | 4824000.0 |
| 2001-12-26 17:00:00 | NVDA | Stock | 0.5658 | 0.5667 | 0.5657 | 0.5667 | 204000.0 |
| 2001-12-26 18:00:00 | NVDA | Stock | 0.5672 | 0.5672 | 0.5672 | 0.5672 | 84000.0 |
| 2001-12-26 08:00:00 | AMZN | Stock | 0.511 | 0.5375 | 0.51 | 0.5315 | 2952000.0 |
| 2001-12-26 09:00:00 | AMZN | Stock | 0.5324 | 0.5644 | 0.5225 | 0.5565 | 102386000.0 |
| 2001-12-26 10:00:00 | AMZN | Stock | 0.5565 | 0.558 | 0.5435 | 0.548 | 70162000.0 |
| 2001-12-26 11:00:00 | AMZN | Stock | 0.548 | 0.5595 | 0.5455 | 0.556 | 46044000.0 |
| 2001-12-26 12:00:00 | AMZN | Stock | 0.5555 | 0.563 | 0.549 | 0.553 | 33122000.0 |
| 2001-12-26 13:00:00 | AMZN | Stock | 0.553 | 0.556 | 0.5495 | 0.554 | 21372000.0 |
| 2001-12-26 14:00:00 | AMZN | Stock | 0.554 | 0.5595 | 0.5525 | 0.559 | 20638000.0 |
| 2001-12-26 15:00:00 | AMZN | Stock | 0.5585 | 0.559 | 0.5505 | 0.555 | 43514000.0 |
| 2001-12-26 16:00:00 | AMZN | Stock | 0.555 | 0.5575 | 0.549 | 0.555 | 5280000.0 |
| 2001-12-26 17:00:00 | AMZN | Stock | 0.5575 | 0.5575 | 0.555 | 0.556 | 290000.0 |
| 2001-12-26 18:00:00 | AMZN | Stock | 0.5555 | 0.5555 | 0.5555 | 0.5555 | 20000.0 |
| 2001-12-26 09:00:00 | CL | Stock | 28.775 | 28.845 | 28.765 | 28.825 | 139000.0 |
| 2001-12-26 10:00:00 | CL | Stock | 28.825 | 29.25 | 28.825 | 29.195 | 244200.0 |
| 2001-12-26 11:00:00 | CL | Stock | 29.15 | 29.25 | 29.09 | 29.135 | 125200.0 |
| 2001-12-26 12:00:00 | CL | Stock | 29.125 | 29.185 | 29.11 | 29.18 | 154600.0 |
| 2001-12-26 13:00:00 | CL | Stock | 29.18 | 29.2 | 29.105 | 29.12 | 97600.0 |
| 2001-12-26 14:00:00 | CL | Stock | 29.12 | 29.25 | 29.115 | 29.195 | 263600.0 |
| 2001-12-26 15:00:00 | CL | Stock | 29.195 | 29.225 | 29.025 | 29.06 | 319600.0 |
| 2001-12-26 16:00:00 | CL | Stock | 29.025 | 29.09 | 29.025 | 29.025 | 182400.0 |
> showing 50 of 17,939 rows — these rows as CSV