PREVIEW / stock_1hour / 2000-02-02
file: by_date/stock_1hour/2000/2000-02-02.parquet size: 278 KB rows: 14,175 symbols: 1,130
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 |
|---|---|---|---|---|---|---|---|
| 2000-02-02 09:00:00 | AAPL | Stock | 0.8996 | 0.9118 | 0.8839 | 0.8917 | 55652800.0 |
| 2000-02-02 10:00:00 | AAPL | Stock | 0.8917 | 0.904 | 0.8862 | 0.8923 | 64590400.0 |
| 2000-02-02 11:00:00 | AAPL | Stock | 0.894 | 0.8996 | 0.8839 | 0.8867 | 59158400.0 |
| 2000-02-02 12:00:00 | AAPL | Stock | 0.8867 | 0.8895 | 0.875 | 0.885 | 49481600.0 |
| 2000-02-02 13:00:00 | AAPL | Stock | 0.885 | 0.8901 | 0.885 | 0.8895 | 30228800.0 |
| 2000-02-02 14:00:00 | AAPL | Stock | 0.8878 | 0.8895 | 0.8661 | 0.8767 | 120232000.0 |
| 2000-02-02 15:00:00 | AAPL | Stock | 0.8783 | 0.885 | 0.8717 | 0.8817 | 74648000.0 |
| 2000-02-02 16:00:00 | AAPL | Stock | 0.8823 | 0.8823 | 0.8795 | 0.8823 | 459200.0 |
| 2000-02-02 09:00:00 | MSFT | Stock | 51.2188 | 51.75 | 51.1562 | 51.4688 | 9254000.0 |
| 2000-02-02 10:00:00 | MSFT | Stock | 51.5 | 51.9688 | 51.3125 | 51.875 | 8360200.0 |
| 2000-02-02 11:00:00 | MSFT | Stock | 51.875 | 51.9375 | 51.4688 | 51.5938 | 3918000.0 |
| 2000-02-02 12:00:00 | MSFT | Stock | 51.5938 | 51.6875 | 50.9062 | 50.9375 | 4206600.0 |
| 2000-02-02 13:00:00 | MSFT | Stock | 50.9375 | 51.5 | 50.7812 | 51.4688 | 3681600.0 |
| 2000-02-02 14:00:00 | MSFT | Stock | 51.4688 | 51.625 | 50.75 | 51.4375 | 8297000.0 |
| 2000-02-02 15:00:00 | MSFT | Stock | 51.4531 | 51.9062 | 50.25 | 50.3906 | 10101000.0 |
| 2000-02-02 16:00:00 | MSFT | Stock | 50.4062 | 50.4062 | 50.375 | 50.4062 | 121800.0 |
| 2000-02-02 09:00:00 | NVDA | Stock | 0.0794 | 0.0807 | 0.079 | 0.0802 | 6432000.0 |
| 2000-02-02 10:00:00 | NVDA | Stock | 0.0805 | 0.0809 | 0.0792 | 0.0802 | 23616000.0 |
| 2000-02-02 11:00:00 | NVDA | Stock | 0.0802 | 0.0815 | 0.0799 | 0.0812 | 26880000.0 |
| 2000-02-02 12:00:00 | NVDA | Stock | 0.0815 | 0.0815 | 0.0801 | 0.0812 | 30144000.0 |
| 2000-02-02 13:00:00 | NVDA | Stock | 0.0807 | 0.0812 | 0.0805 | 0.081 | 16032000.0 |
| 2000-02-02 14:00:00 | NVDA | Stock | 0.0811 | 0.0823 | 0.081 | 0.082 | 20016000.0 |
| 2000-02-02 15:00:00 | NVDA | Stock | 0.082 | 0.0828 | 0.0812 | 0.0812 | 24576000.0 |
| 2000-02-02 16:00:00 | NVDA | Stock | 0.0812 | 0.0812 | 0.0812 | 0.0812 | 240000.0 |
| 2000-02-02 09:00:00 | AMZN | Stock | 3.3969 | 3.4812 | 3.3875 | 3.4469 | 26270000.0 |
| 2000-02-02 10:00:00 | AMZN | Stock | 3.4469 | 3.4688 | 3.425 | 3.45 | 24800000.0 |
| 2000-02-02 11:00:00 | AMZN | Stock | 3.45 | 3.5 | 3.4469 | 3.4781 | 22304000.0 |
| 2000-02-02 12:00:00 | AMZN | Stock | 3.4781 | 3.5156 | 3.475 | 3.4875 | 35222000.0 |
| 2000-02-02 13:00:00 | AMZN | Stock | 3.4906 | 3.525 | 3.4812 | 3.5125 | 18986000.0 |
| 2000-02-02 14:00:00 | AMZN | Stock | 3.5125 | 3.55 | 3.4688 | 3.5438 | 38916000.0 |
| 2000-02-02 15:00:00 | AMZN | Stock | 3.5422 | 3.6125 | 3.45 | 3.4719 | 73964000.0 |
| 2000-02-02 16:00:00 | AMZN | Stock | 3.4688 | 3.4812 | 3.4688 | 3.4719 | 464000.0 |
| 2000-02-02 09:00:00 | CL | Stock | 30.25 | 30.25 | 29.875 | 29.9062 | 326200.0 |
| 2000-02-02 10:00:00 | CL | Stock | 29.9062 | 30.0312 | 29.875 | 29.9688 | 291200.0 |
| 2000-02-02 11:00:00 | CL | Stock | 29.9688 | 29.9688 | 29.9062 | 29.9375 | 227200.0 |
| 2000-02-02 12:00:00 | CL | Stock | 29.9688 | 29.9688 | 29.875 | 29.9375 | 236000.0 |
| 2000-02-02 13:00:00 | CL | Stock | 29.9375 | 30.1562 | 29.9062 | 29.9688 | 270400.0 |
| 2000-02-02 14:00:00 | CL | Stock | 29.9375 | 30.75 | 29.9062 | 30.7188 | 835000.0 |
| 2000-02-02 15:00:00 | CL | Stock | 30.7188 | 30.8125 | 30.4688 | 30.625 | 768800.0 |
| 2000-02-02 16:00:00 | CL | Stock | 30.625 | 30.6562 | 30.625 | 30.6562 | 38600.0 |
> showing 40 of 14,175 rows — these rows as CSV