PREVIEW / stock_1hour / 2000-05-08
file: by_date/stock_1hour/2000/2000-05-08.parquet size: 278 KB rows: 14,209 symbols: 1,156
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-05-08 09:00:00 | AAPL | Stock | 1.0008 | 1.0151 | 0.9911 | 0.9933 | 35268800.0 |
| 2000-05-08 10:00:00 | AAPL | Stock | 0.9922 | 0.9978 | 0.9821 | 0.9944 | 37083200.0 |
| 2000-05-08 11:00:00 | AAPL | Stock | 0.9916 | 1.0011 | 0.9888 | 0.9922 | 13059200.0 |
| 2000-05-08 12:00:00 | AAPL | Stock | 0.9922 | 0.9955 | 0.9877 | 0.99 | 6361600.0 |
| 2000-05-08 13:00:00 | AAPL | Stock | 0.99 | 0.9916 | 0.9844 | 0.9916 | 23912000.0 |
| 2000-05-08 14:00:00 | AAPL | Stock | 0.99 | 0.9916 | 0.9827 | 0.9855 | 20809600.0 |
| 2000-05-08 15:00:00 | AAPL | Stock | 0.9855 | 0.9939 | 0.9821 | 0.9838 | 36164800.0 |
| 2000-05-08 16:00:00 | AAPL | Stock | 0.9838 | 0.9838 | 0.9833 | 0.9833 | 2385600.0 |
| 2000-05-08 09:00:00 | MSFT | Stock | 35.4688 | 35.6875 | 35.25 | 35.5312 | 5647200.0 |
| 2000-05-08 10:00:00 | MSFT | Stock | 35.5312 | 35.5625 | 35.3125 | 35.4375 | 5669200.0 |
| 2000-05-08 11:00:00 | MSFT | Stock | 35.4375 | 35.5625 | 35.375 | 35.4688 | 3687600.0 |
| 2000-05-08 12:00:00 | MSFT | Stock | 35.4375 | 35.5312 | 35.375 | 35.4375 | 3017800.0 |
| 2000-05-08 13:00:00 | MSFT | Stock | 35.4375 | 35.4688 | 35.1875 | 35.2812 | 2755800.0 |
| 2000-05-08 14:00:00 | MSFT | Stock | 35.25 | 35.2812 | 34.875 | 34.875 | 4287200.0 |
| 2000-05-08 15:00:00 | MSFT | Stock | 34.875 | 35.1875 | 34.8438 | 34.9062 | 8141600.0 |
| 2000-05-08 16:00:00 | MSFT | Stock | 34.9062 | 34.9062 | 34.9062 | 34.9062 | 298600.0 |
| 2000-05-08 09:00:00 | NVDA | Stock | 0.187 | 0.1937 | 0.1862 | 0.1909 | 22032000.0 |
| 2000-05-08 10:00:00 | NVDA | Stock | 0.1906 | 0.1908 | 0.187 | 0.19 | 25680000.0 |
| 2000-05-08 11:00:00 | NVDA | Stock | 0.19 | 0.1909 | 0.1884 | 0.1884 | 15360000.0 |
| 2000-05-08 12:00:00 | NVDA | Stock | 0.1884 | 0.1896 | 0.1883 | 0.1884 | 15552000.0 |
| 2000-05-08 13:00:00 | NVDA | Stock | 0.1884 | 0.1898 | 0.1878 | 0.188 | 19488000.0 |
| 2000-05-08 14:00:00 | NVDA | Stock | 0.188 | 0.1913 | 0.188 | 0.1891 | 11760000.0 |
| 2000-05-08 15:00:00 | NVDA | Stock | 0.1889 | 0.1893 | 0.1846 | 0.1856 | 56640000.0 |
| 2000-05-08 16:00:00 | NVDA | Stock | 0.1849 | 0.1849 | 0.1849 | 0.1849 | 5952000.0 |
| 2000-05-08 09:00:00 | AMZN | Stock | 2.8406 | 2.9625 | 2.8188 | 2.9438 | 15034000.0 |
| 2000-05-08 10:00:00 | AMZN | Stock | 2.9469 | 2.9625 | 2.8281 | 2.8906 | 14122000.0 |
| 2000-05-08 11:00:00 | AMZN | Stock | 2.8875 | 2.8938 | 2.8438 | 2.8594 | 5616000.0 |
| 2000-05-08 12:00:00 | AMZN | Stock | 2.8531 | 2.8594 | 2.8313 | 2.8531 | 6022000.0 |
| 2000-05-08 13:00:00 | AMZN | Stock | 2.8562 | 2.875 | 2.8063 | 2.875 | 7272000.0 |
| 2000-05-08 14:00:00 | AMZN | Stock | 2.875 | 2.8781 | 2.8 | 2.8125 | 9996000.0 |
| 2000-05-08 15:00:00 | AMZN | Stock | 2.8094 | 2.8812 | 2.7969 | 2.8031 | 15262000.0 |
| 2000-05-08 16:00:00 | AMZN | Stock | 2.8031 | 2.8031 | 2.8 | 2.8031 | 136000.0 |
| 2000-05-08 09:00:00 | CL | Stock | 28.75 | 29.125 | 28.625 | 29.0 | 299000.0 |
| 2000-05-08 10:00:00 | CL | Stock | 29.0312 | 29.75 | 29.0312 | 29.4375 | 334000.0 |
| 2000-05-08 11:00:00 | CL | Stock | 29.4062 | 29.4062 | 29.125 | 29.3125 | 215200.0 |
| 2000-05-08 12:00:00 | CL | Stock | 29.3125 | 29.3125 | 29.125 | 29.1875 | 402200.0 |
| 2000-05-08 13:00:00 | CL | Stock | 29.125 | 29.125 | 28.8125 | 28.9688 | 140200.0 |
| 2000-05-08 14:00:00 | CL | Stock | 28.9688 | 28.9688 | 28.6875 | 28.8125 | 256800.0 |
| 2000-05-08 15:00:00 | CL | Stock | 28.8125 | 28.8438 | 28.4688 | 28.7188 | 392800.0 |
| 2000-05-08 16:00:00 | CL | Stock | 28.7188 | 28.8125 | 28.6562 | 28.8125 | 78800.0 |
> showing 40 of 14,209 rows — these rows as CSV