PREVIEW / stock_1hour / 2000-09-11
file: by_date/stock_1hour/2000/2000-09-11.parquet size: 299 KB rows: 15,472 symbols: 1,214
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-09-11 08:00:00 | AAPL | Stock | 1.0491 | 1.0491 | 1.0424 | 1.0424 | 61600.0 |
| 2000-09-11 09:00:00 | AAPL | Stock | 1.0424 | 1.0636 | 1.0424 | 1.0491 | 26689600.0 |
| 2000-09-11 10:00:00 | AAPL | Stock | 1.0491 | 1.0781 | 1.0458 | 1.0714 | 35638400.0 |
| 2000-09-11 11:00:00 | AAPL | Stock | 1.0714 | 1.0759 | 1.0558 | 1.0614 | 21800800.0 |
| 2000-09-11 12:00:00 | AAPL | Stock | 1.0603 | 1.0614 | 1.0446 | 1.058 | 16721600.0 |
| 2000-09-11 13:00:00 | AAPL | Stock | 1.058 | 1.067 | 1.0525 | 1.0614 | 17948000.0 |
| 2000-09-11 14:00:00 | AAPL | Stock | 1.0625 | 1.0625 | 1.0391 | 1.0424 | 25944800.0 |
| 2000-09-11 15:00:00 | AAPL | Stock | 1.0424 | 1.0603 | 1.0379 | 1.0446 | 32715200.0 |
| 2000-09-11 16:00:00 | AAPL | Stock | 1.0435 | 1.0569 | 1.0435 | 1.0435 | 4435200.0 |
| 2000-09-11 17:00:00 | AAPL | Stock | 1.0402 | 1.0402 | 1.0379 | 1.0402 | 22400.0 |
| 2000-09-11 18:00:00 | AAPL | Stock | 1.0558 | 1.0558 | 1.0558 | 1.0558 | 5600.0 |
| 2000-09-11 08:00:00 | MSFT | Stock | 34.625 | 34.6875 | 34.4688 | 34.5312 | 28200.0 |
| 2000-09-11 09:00:00 | MSFT | Stock | 34.625 | 34.6562 | 34.4375 | 34.5 | 5397200.0 |
| 2000-09-11 10:00:00 | MSFT | Stock | 34.5 | 34.8438 | 34.4375 | 34.8125 | 8168400.0 |
| 2000-09-11 11:00:00 | MSFT | Stock | 34.7812 | 34.8125 | 34.5 | 34.5625 | 5310800.0 |
| 2000-09-11 12:00:00 | MSFT | Stock | 34.5312 | 34.5625 | 34.375 | 34.4062 | 5253000.0 |
| 2000-09-11 13:00:00 | MSFT | Stock | 34.4062 | 34.4375 | 34.2188 | 34.375 | 4351400.0 |
| 2000-09-11 14:00:00 | MSFT | Stock | 34.375 | 34.375 | 34.0312 | 34.0938 | 7468800.0 |
| 2000-09-11 15:00:00 | MSFT | Stock | 34.0938 | 34.4688 | 34.0625 | 34.4375 | 10352600.0 |
| 2000-09-11 16:00:00 | MSFT | Stock | 34.4375 | 34.5 | 34.2031 | 34.375 | 854800.0 |
| 2000-09-11 17:00:00 | MSFT | Stock | 34.375 | 34.375 | 34.375 | 34.375 | 3000.0 |
| 2000-09-11 18:00:00 | MSFT | Stock | 34.375 | 34.375 | 34.375 | 34.375 | 1200.0 |
| 2000-09-11 09:00:00 | NVDA | Stock | 0.3047 | 0.306 | 0.2833 | 0.2852 | 56208000.0 |
| 2000-09-11 10:00:00 | NVDA | Stock | 0.2833 | 0.3042 | 0.2823 | 0.3013 | 81360000.0 |
| 2000-09-11 11:00:00 | NVDA | Stock | 0.3013 | 0.3042 | 0.2979 | 0.301 | 21048000.0 |
| 2000-09-11 12:00:00 | NVDA | Stock | 0.2984 | 0.301 | 0.2964 | 0.299 | 13512000.0 |
| 2000-09-11 13:00:00 | NVDA | Stock | 0.2997 | 0.3 | 0.2958 | 0.2964 | 30576000.0 |
| 2000-09-11 14:00:00 | NVDA | Stock | 0.2969 | 0.2979 | 0.2875 | 0.2906 | 29616000.0 |
| 2000-09-11 15:00:00 | NVDA | Stock | 0.2909 | 0.2987 | 0.2854 | 0.2938 | 36912000.0 |
| 2000-09-11 16:00:00 | NVDA | Stock | 0.293 | 0.294 | 0.2917 | 0.2938 | 1608000.0 |
| 2000-09-11 17:00:00 | NVDA | Stock | 0.2928 | 0.2928 | 0.2928 | 0.2928 | 48000.0 |
| 2000-09-11 08:00:00 | AMZN | Stock | 2.1438 | 2.1469 | 2.0719 | 2.0875 | 332000.0 |
| 2000-09-11 09:00:00 | AMZN | Stock | 2.0875 | 2.1938 | 2.05 | 2.1688 | 16862000.0 |
| 2000-09-11 10:00:00 | AMZN | Stock | 2.1688 | 2.2609 | 2.1656 | 2.2312 | 24500000.0 |
| 2000-09-11 11:00:00 | AMZN | Stock | 2.2312 | 2.2344 | 2.1812 | 2.2219 | 12238000.0 |
| 2000-09-11 12:00:00 | AMZN | Stock | 2.2219 | 2.225 | 2.1812 | 2.2094 | 7288000.0 |
| 2000-09-11 13:00:00 | AMZN | Stock | 2.2125 | 2.2156 | 2.1781 | 2.2156 | 7322000.0 |
| 2000-09-11 14:00:00 | AMZN | Stock | 2.2156 | 2.2312 | 2.1406 | 2.1469 | 12760000.0 |
| 2000-09-11 15:00:00 | AMZN | Stock | 2.1469 | 2.1531 | 2.1094 | 2.1219 | 21668000.0 |
| 2000-09-11 16:00:00 | AMZN | Stock | 2.1156 | 2.1469 | 2.1 | 2.1188 | 1320000.0 |
| 2000-09-11 17:00:00 | AMZN | Stock | 2.1188 | 2.2219 | 2.1188 | 2.2219 | 42000.0 |
| 2000-09-11 18:00:00 | AMZN | Stock | 2.1188 | 2.1188 | 2.1188 | 2.1188 | 10000.0 |
| 2000-09-11 09:00:00 | CL | Stock | 27.0 | 27.0 | 26.8438 | 26.9062 | 194600.0 |
| 2000-09-11 10:00:00 | CL | Stock | 26.9062 | 26.9062 | 26.7812 | 26.8438 | 700800.0 |
| 2000-09-11 11:00:00 | CL | Stock | 26.875 | 26.9375 | 26.8125 | 26.8125 | 243000.0 |
| 2000-09-11 12:00:00 | CL | Stock | 26.8438 | 27.125 | 26.8125 | 27.0625 | 415400.0 |
| 2000-09-11 13:00:00 | CL | Stock | 27.0625 | 27.3125 | 27.0625 | 27.2812 | 431000.0 |
| 2000-09-11 14:00:00 | CL | Stock | 27.2812 | 27.3438 | 27.0625 | 27.1875 | 382800.0 |
| 2000-09-11 15:00:00 | CL | Stock | 27.2188 | 27.5312 | 27.1875 | 27.5312 | 1059200.0 |
| 2000-09-11 16:00:00 | CL | Stock | 27.5312 | 27.5312 | 27.1406 | 27.5 | 75200.0 |
> showing 50 of 15,472 rows — these rows as CSV