PREVIEW / stock_1hour / 2004-08-10
file: by_date/stock_1hour/2004/2004-08-10.parquet size: 497 KB rows: 23,688 symbols: 1,826
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-10 08:00:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5393 | 0.5413 | 154560.0 |
| 2004-08-10 09:00:00 | AAPL | Stock | 0.5416 | 0.5471 | 0.5391 | 0.5436 | 20226472.0 |
| 2004-08-10 10:00:00 | AAPL | Stock | 0.5434 | 0.5491 | 0.5425 | 0.5486 | 44359280.0 |
| 2004-08-10 11:00:00 | AAPL | Stock | 0.5484 | 0.5554 | 0.5484 | 0.5532 | 44407048.0 |
| 2004-08-10 12:00:00 | AAPL | Stock | 0.5532 | 0.5543 | 0.552 | 0.553 | 13754496.0 |
| 2004-08-10 13:00:00 | AAPL | Stock | 0.553 | 0.5539 | 0.552 | 0.5521 | 19405120.0 |
| 2004-08-10 14:00:00 | AAPL | Stock | 0.552 | 0.5546 | 0.5463 | 0.5529 | 58048200.0 |
| 2004-08-10 15:00:00 | AAPL | Stock | 0.553 | 0.5632 | 0.5529 | 0.5618 | 88343864.0 |
| 2004-08-10 16:00:00 | AAPL | Stock | 0.5627 | 0.5636 | 0.5598 | 0.5598 | 32701424.0 |
| 2004-08-10 17:00:00 | AAPL | Stock | 0.5566 | 0.5566 | 0.5484 | 0.5491 | 1380400.0 |
| 2004-08-10 08:00:00 | MSFT | Stock | 27.2 | 27.27 | 27.19 | 27.24 | 7545.0 |
| 2004-08-10 09:00:00 | MSFT | Stock | 27.24 | 27.4 | 27.24 | 27.34 | 6017899.0 |
| 2004-08-10 10:00:00 | MSFT | Stock | 27.34 | 27.57 | 27.32 | 27.53 | 11656302.0 |
| 2004-08-10 11:00:00 | MSFT | Stock | 27.53 | 27.6 | 27.48 | 27.5 | 5769205.0 |
| 2004-08-10 12:00:00 | MSFT | Stock | 27.5 | 27.55 | 27.48 | 27.53 | 2500384.0 |
| 2004-08-10 13:00:00 | MSFT | Stock | 27.54 | 27.59 | 27.49 | 27.54 | 4084258.0 |
| 2004-08-10 14:00:00 | MSFT | Stock | 27.54 | 27.57 | 27.4 | 27.48 | 11267698.0 |
| 2004-08-10 15:00:00 | MSFT | Stock | 27.49 | 27.75 | 27.48 | 27.71 | 13163918.0 |
| 2004-08-10 16:00:00 | MSFT | Stock | 27.71 | 27.73 | 27.52 | 27.57 | 1033830.0 |
| 2004-08-10 17:00:00 | MSFT | Stock | 27.6 | 27.72 | 27.45 | 27.48 | 85969.0 |
| 2004-08-10 18:00:00 | MSFT | Stock | 27.48 | 27.48 | 27.27 | 27.46 | 5900.0 |
| 2004-08-10 08:00:00 | NVDA | Stock | 0.0859 | 0.0872 | 0.0848 | 0.0867 | 17922960.0 |
| 2004-08-10 09:00:00 | NVDA | Stock | 0.0867 | 0.0873 | 0.0852 | 0.0861 | 476441880.0 |
| 2004-08-10 10:00:00 | NVDA | Stock | 0.0861 | 0.0872 | 0.0861 | 0.0867 | 334551840.0 |
| 2004-08-10 11:00:00 | NVDA | Stock | 0.0866 | 0.0887 | 0.0865 | 0.0879 | 248712240.0 |
| 2004-08-10 12:00:00 | NVDA | Stock | 0.088 | 0.0883 | 0.0869 | 0.0875 | 173020320.0 |
| 2004-08-10 13:00:00 | NVDA | Stock | 0.0875 | 0.0876 | 0.0869 | 0.0872 | 71488560.0 |
| 2004-08-10 14:00:00 | NVDA | Stock | 0.0872 | 0.0875 | 0.0862 | 0.087 | 204538560.0 |
| 2004-08-10 15:00:00 | NVDA | Stock | 0.087 | 0.0894 | 0.0869 | 0.0886 | 446751960.0 |
| 2004-08-10 16:00:00 | NVDA | Stock | 0.0887 | 0.0893 | 0.0868 | 0.0874 | 38950920.0 |
| 2004-08-10 17:00:00 | NVDA | Stock | 0.0874 | 0.0874 | 0.0865 | 0.0871 | 3645120.0 |
| 2004-08-10 18:00:00 | NVDA | Stock | 0.0871 | 0.0871 | 0.0871 | 0.0871 | 61200.0 |
| 2004-08-10 09:00:00 | AMZN | Stock | 1.776 | 1.8115 | 1.7735 | 1.804 | 18623140.0 |
| 2004-08-10 10:00:00 | AMZN | Stock | 1.804 | 1.825 | 1.802 | 1.8235 | 31979260.0 |
| 2004-08-10 11:00:00 | AMZN | Stock | 1.8235 | 1.845 | 1.82 | 1.8342 | 26166500.0 |
| 2004-08-10 12:00:00 | AMZN | Stock | 1.834 | 1.8395 | 1.8255 | 1.834 | 11943760.0 |
| 2004-08-10 13:00:00 | AMZN | Stock | 1.834 | 1.8395 | 1.831 | 1.8365 | 9339360.0 |
| 2004-08-10 14:00:00 | AMZN | Stock | 1.836 | 1.836 | 1.811 | 1.8235 | 30879700.0 |
| 2004-08-10 15:00:00 | AMZN | Stock | 1.822 | 1.86 | 1.8215 | 1.8525 | 58275440.0 |
| 2004-08-10 16:00:00 | AMZN | Stock | 1.8515 | 1.8585 | 1.833 | 1.8335 | 4450980.0 |
| 2004-08-10 17:00:00 | AMZN | Stock | 1.8335 | 1.855 | 1.8225 | 1.8245 | 1180600.0 |
| 2004-08-10 18:00:00 | AMZN | Stock | 1.8345 | 1.8375 | 1.8345 | 1.837 | 127600.0 |
| 2004-08-10 09:00:00 | CL | Stock | 25.875 | 25.915 | 25.785 | 25.885 | 291200.0 |
| 2004-08-10 10:00:00 | CL | Stock | 25.885 | 25.995 | 25.875 | 25.955 | 492200.0 |
| 2004-08-10 11:00:00 | CL | Stock | 25.955 | 26.025 | 25.95 | 26.025 | 336600.0 |
| 2004-08-10 12:00:00 | CL | Stock | 26.02 | 26.03 | 25.935 | 25.98 | 136000.0 |
| 2004-08-10 13:00:00 | CL | Stock | 25.985 | 26.0 | 25.93 | 25.955 | 186400.0 |
| 2004-08-10 14:00:00 | CL | Stock | 25.955 | 26.025 | 25.845 | 26.0 | 358800.0 |
| 2004-08-10 15:00:00 | CL | Stock | 26.0 | 26.125 | 25.985 | 26.11 | 773000.0 |
| 2004-08-10 16:00:00 | CL | Stock | 26.115 | 26.115 | 26.115 | 26.115 | 13400.0 |
> showing 50 of 23,688 rows — these rows as CSV