PREVIEW / stock_1hour / 2000-03-14
file: by_date/stock_1hour/2000/2000-03-14.parquet size: 289 KB rows: 14,798 symbols: 1,142
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-03-14 09:00:00 | AAPL | Stock | 1.0823 | 1.0982 | 1.0759 | 1.0943 | 30016000.0 |
| 2000-03-14 10:00:00 | AAPL | Stock | 1.0943 | 1.1094 | 1.0904 | 1.091 | 66438400.0 |
| 2000-03-14 11:00:00 | AAPL | Stock | 1.0915 | 1.0926 | 1.0759 | 1.0759 | 56033600.0 |
| 2000-03-14 12:00:00 | AAPL | Stock | 1.0759 | 1.0826 | 1.0558 | 1.0569 | 43321600.0 |
| 2000-03-14 13:00:00 | AAPL | Stock | 1.0558 | 1.067 | 1.0396 | 1.0552 | 52830400.0 |
| 2000-03-14 14:00:00 | AAPL | Stock | 1.0547 | 1.0625 | 1.0346 | 1.0346 | 42291200.0 |
| 2000-03-14 15:00:00 | AAPL | Stock | 1.0346 | 1.0357 | 1.0179 | 1.0218 | 120993600.0 |
| 2000-03-14 16:00:00 | AAPL | Stock | 1.0206 | 1.0206 | 1.0201 | 1.0201 | 1097600.0 |
| 2000-03-14 09:00:00 | MSFT | Stock | 49.3125 | 49.4375 | 48.9062 | 49.0 | 12427400.0 |
| 2000-03-14 10:00:00 | MSFT | Stock | 49.0 | 49.5 | 48.8125 | 49.2656 | 10832600.0 |
| 2000-03-14 11:00:00 | MSFT | Stock | 49.2656 | 49.5 | 49.0625 | 49.0625 | 9045600.0 |
| 2000-03-14 12:00:00 | MSFT | Stock | 49.0625 | 49.1875 | 47.5625 | 47.8594 | 11974600.0 |
| 2000-03-14 13:00:00 | MSFT | Stock | 47.875 | 48.8438 | 47.8438 | 48.25 | 6636400.0 |
| 2000-03-14 14:00:00 | MSFT | Stock | 48.25 | 48.75 | 47.7188 | 47.9375 | 7973000.0 |
| 2000-03-14 15:00:00 | MSFT | Stock | 47.9688 | 48.3125 | 47.5625 | 47.5625 | 9348600.0 |
| 2000-03-14 16:00:00 | MSFT | Stock | 47.5938 | 47.7188 | 47.5625 | 47.5625 | 273600.0 |
| 2000-03-14 09:00:00 | NVDA | Stock | 0.3092 | 0.3092 | 0.2831 | 0.2854 | 241824000.0 |
| 2000-03-14 10:00:00 | NVDA | Stock | 0.2854 | 0.2971 | 0.2835 | 0.2839 | 196032000.0 |
| 2000-03-14 11:00:00 | NVDA | Stock | 0.2835 | 0.2854 | 0.2635 | 0.2635 | 204528000.0 |
| 2000-03-14 12:00:00 | NVDA | Stock | 0.2638 | 0.274 | 0.2604 | 0.2656 | 119856000.0 |
| 2000-03-14 13:00:00 | NVDA | Stock | 0.2656 | 0.2672 | 0.2625 | 0.2664 | 113856000.0 |
| 2000-03-14 14:00:00 | NVDA | Stock | 0.2647 | 0.2664 | 0.238 | 0.2385 | 240864000.0 |
| 2000-03-14 15:00:00 | NVDA | Stock | 0.2385 | 0.2521 | 0.2275 | 0.2303 | 327792000.0 |
| 2000-03-14 16:00:00 | NVDA | Stock | 0.2292 | 0.2294 | 0.2283 | 0.2294 | 2016000.0 |
| 2000-03-14 09:00:00 | AMZN | Stock | 3.3031 | 3.3469 | 3.2875 | 3.2906 | 7806000.0 |
| 2000-03-14 10:00:00 | AMZN | Stock | 3.2906 | 3.2969 | 3.2406 | 3.2688 | 12244000.0 |
| 2000-03-14 11:00:00 | AMZN | Stock | 3.2719 | 3.3438 | 3.2656 | 3.2812 | 13712000.0 |
| 2000-03-14 12:00:00 | AMZN | Stock | 3.2812 | 3.3 | 3.1813 | 3.2562 | 15082000.0 |
| 2000-03-14 13:00:00 | AMZN | Stock | 3.2562 | 3.2875 | 3.2 | 3.2719 | 8360000.0 |
| 2000-03-14 14:00:00 | AMZN | Stock | 3.2688 | 3.2875 | 3.1875 | 3.2 | 10946000.0 |
| 2000-03-14 15:00:00 | AMZN | Stock | 3.1969 | 3.3 | 3.1688 | 3.2875 | 23072000.0 |
| 2000-03-14 16:00:00 | AMZN | Stock | 3.2812 | 3.3 | 3.275 | 3.2812 | 228000.0 |
| 2000-03-14 09:00:00 | CL | Stock | 21.125 | 21.6562 | 21.0 | 21.4375 | 955200.0 |
| 2000-03-14 10:00:00 | CL | Stock | 21.4688 | 21.5938 | 21.3125 | 21.5 | 364200.0 |
| 2000-03-14 11:00:00 | CL | Stock | 21.5625 | 21.6562 | 21.5 | 21.5 | 344200.0 |
| 2000-03-14 12:00:00 | CL | Stock | 21.5 | 21.625 | 21.375 | 21.5312 | 478200.0 |
| 2000-03-14 13:00:00 | CL | Stock | 21.5625 | 21.5938 | 21.4062 | 21.5 | 234400.0 |
| 2000-03-14 14:00:00 | CL | Stock | 21.5312 | 21.625 | 21.4688 | 21.5938 | 248200.0 |
| 2000-03-14 15:00:00 | CL | Stock | 21.5938 | 21.7812 | 21.5 | 21.5625 | 475200.0 |
| 2000-03-14 16:00:00 | CL | Stock | 21.5938 | 21.625 | 21.5312 | 21.5312 | 79400.0 |
| 2000-03-14 18:00:00 | CL | Stock | 21.5938 | 21.5938 | 21.5938 | 21.5938 | 200.0 |
> showing 41 of 14,798 rows — these rows as CSV