PREVIEW / stock_1hour / 2000-01-25
file: by_date/stock_1hour/2000/2000-01-25.parquet size: 278 KB rows: 14,463 symbols: 1,129
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-01-25 09:00:00 | AAPL | Stock | 0.9375 | 0.9397 | 0.9141 | 0.9369 | 54835200.0 |
| 2000-01-25 10:00:00 | AAPL | Stock | 0.9369 | 0.9621 | 0.9308 | 0.9554 | 88356800.0 |
| 2000-01-25 11:00:00 | AAPL | Stock | 0.9548 | 0.9732 | 0.9509 | 0.9559 | 65576000.0 |
| 2000-01-25 12:00:00 | AAPL | Stock | 0.9554 | 0.9665 | 0.9515 | 0.9643 | 24920000.0 |
| 2000-01-25 13:00:00 | AAPL | Stock | 0.9637 | 0.9688 | 0.9598 | 0.9598 | 26286400.0 |
| 2000-01-25 14:00:00 | AAPL | Stock | 0.9598 | 0.9967 | 0.9598 | 0.9855 | 95883200.0 |
| 2000-01-25 15:00:00 | AAPL | Stock | 0.9866 | 1.01 | 0.9827 | 1.0022 | 102704000.0 |
| 2000-01-25 16:00:00 | AAPL | Stock | 1.0022 | 1.0022 | 1.0022 | 1.0022 | 526400.0 |
| 2000-01-25 09:00:00 | MSFT | Stock | 50.5 | 50.625 | 49.7812 | 50.4375 | 7854400.0 |
| 2000-01-25 10:00:00 | MSFT | Stock | 50.4375 | 50.8438 | 49.9688 | 50.3125 | 8886600.0 |
| 2000-01-25 11:00:00 | MSFT | Stock | 50.125 | 51.0625 | 50.125 | 50.4062 | 6974800.0 |
| 2000-01-25 12:00:00 | MSFT | Stock | 50.375 | 50.9375 | 50.1875 | 50.6562 | 4497000.0 |
| 2000-01-25 13:00:00 | MSFT | Stock | 50.625 | 50.8125 | 50.4062 | 50.4688 | 5525000.0 |
| 2000-01-25 14:00:00 | MSFT | Stock | 50.5 | 51.5 | 50.375 | 51.2188 | 11361000.0 |
| 2000-01-25 15:00:00 | MSFT | Stock | 51.2188 | 51.9375 | 51.0312 | 51.4062 | 11257400.0 |
| 2000-01-25 16:00:00 | MSFT | Stock | 51.4062 | 51.4062 | 51.375 | 51.4062 | 84800.0 |
| 2000-01-25 09:00:00 | NVDA | Stock | 0.0895 | 0.0898 | 0.0872 | 0.0872 | 8976000.0 |
| 2000-01-25 10:00:00 | NVDA | Stock | 0.0872 | 0.0898 | 0.0872 | 0.0888 | 66816000.0 |
| 2000-01-25 11:00:00 | NVDA | Stock | 0.0893 | 0.0898 | 0.0888 | 0.0898 | 2160000.0 |
| 2000-01-25 12:00:00 | NVDA | Stock | 0.0898 | 0.0904 | 0.0891 | 0.0898 | 20592000.0 |
| 2000-01-25 13:00:00 | NVDA | Stock | 0.0896 | 0.0902 | 0.0888 | 0.0891 | 20976000.0 |
| 2000-01-25 14:00:00 | NVDA | Stock | 0.0891 | 0.0892 | 0.0863 | 0.0874 | 49392000.0 |
| 2000-01-25 15:00:00 | NVDA | Stock | 0.0866 | 0.0897 | 0.0854 | 0.0875 | 58320000.0 |
| 2000-01-25 16:00:00 | NVDA | Stock | 0.0883 | 0.0883 | 0.0883 | 0.0883 | 2880000.0 |
| 2000-01-25 09:00:00 | AMZN | Stock | 3.5 | 3.5094 | 3.3031 | 3.3844 | 28382000.0 |
| 2000-01-25 10:00:00 | AMZN | Stock | 3.3875 | 3.5625 | 3.375 | 3.4656 | 43836000.0 |
| 2000-01-25 11:00:00 | AMZN | Stock | 3.4688 | 3.5125 | 3.4 | 3.4031 | 17262000.0 |
| 2000-01-25 12:00:00 | AMZN | Stock | 3.4 | 3.45 | 3.3875 | 3.425 | 10980000.0 |
| 2000-01-25 13:00:00 | AMZN | Stock | 3.4281 | 3.4406 | 3.35 | 3.35 | 13800000.0 |
| 2000-01-25 14:00:00 | AMZN | Stock | 3.35 | 3.4875 | 3.3344 | 3.4688 | 30226000.0 |
| 2000-01-25 15:00:00 | AMZN | Stock | 3.45 | 3.5062 | 3.4 | 3.4594 | 32866000.0 |
| 2000-01-25 16:00:00 | AMZN | Stock | 3.4609 | 3.4656 | 3.4594 | 3.4625 | 290000.0 |
| 2000-01-25 09:00:00 | CL | Stock | 30.875 | 30.9062 | 30.4688 | 30.4688 | 148000.0 |
| 2000-01-25 10:00:00 | CL | Stock | 30.4688 | 30.4688 | 29.9375 | 30.0625 | 370200.0 |
| 2000-01-25 11:00:00 | CL | Stock | 30.125 | 30.25 | 30.0312 | 30.0625 | 133000.0 |
| 2000-01-25 12:00:00 | CL | Stock | 30.0938 | 30.2812 | 29.9062 | 30.0625 | 187200.0 |
| 2000-01-25 13:00:00 | CL | Stock | 30.0625 | 30.0625 | 29.625 | 29.75 | 349000.0 |
| 2000-01-25 14:00:00 | CL | Stock | 29.7188 | 29.9375 | 29.7188 | 29.8125 | 329400.0 |
| 2000-01-25 15:00:00 | CL | Stock | 29.7812 | 29.875 | 29.625 | 29.7188 | 343600.0 |
| 2000-01-25 16:00:00 | CL | Stock | 29.8125 | 29.8125 | 29.8125 | 29.8125 | 67200.0 |
> showing 40 of 14,463 rows — these rows as CSV