PREVIEW / stock_1hour / 2000-09-12
file: by_date/stock_1hour/2000/2000-09-12.parquet size: 302 KB rows: 15,522 symbols: 1,224
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-12 08:00:00 | AAPL | Stock | 1.0441 | 1.0597 | 1.0441 | 1.0597 | 246400.0 |
| 2000-09-12 09:00:00 | AAPL | Stock | 1.0513 | 1.0513 | 1.0234 | 1.0246 | 24567200.0 |
| 2000-09-12 10:00:00 | AAPL | Stock | 1.0234 | 1.0491 | 1.0212 | 1.0435 | 32653600.0 |
| 2000-09-12 11:00:00 | AAPL | Stock | 1.0435 | 1.0714 | 1.0424 | 1.0658 | 24421600.0 |
| 2000-09-12 12:00:00 | AAPL | Stock | 1.0653 | 1.0725 | 1.0647 | 1.0692 | 16766400.0 |
| 2000-09-12 13:00:00 | AAPL | Stock | 1.0692 | 1.0692 | 1.0536 | 1.0603 | 10438400.0 |
| 2000-09-12 14:00:00 | AAPL | Stock | 1.0614 | 1.0658 | 1.0446 | 1.0491 | 12706400.0 |
| 2000-09-12 15:00:00 | AAPL | Stock | 1.048 | 1.0536 | 1.0179 | 1.029 | 43097600.0 |
| 2000-09-12 16:00:00 | AAPL | Stock | 1.0296 | 1.0452 | 1.0223 | 1.0223 | 3460800.0 |
| 2000-09-12 08:00:00 | MSFT | Stock | 34.4219 | 34.5625 | 34.0 | 34.5156 | 32800.0 |
| 2000-09-12 09:00:00 | MSFT | Stock | 34.4688 | 34.6562 | 34.25 | 34.375 | 4699400.0 |
| 2000-09-12 10:00:00 | MSFT | Stock | 34.375 | 34.5625 | 34.2812 | 34.4375 | 6642000.0 |
| 2000-09-12 11:00:00 | MSFT | Stock | 34.4375 | 34.4688 | 34.25 | 34.25 | 6270400.0 |
| 2000-09-12 12:00:00 | MSFT | Stock | 34.2812 | 34.4062 | 34.25 | 34.3438 | 3615400.0 |
| 2000-09-12 13:00:00 | MSFT | Stock | 34.3438 | 34.375 | 34.0938 | 34.1875 | 6275000.0 |
| 2000-09-12 14:00:00 | MSFT | Stock | 34.1875 | 34.2812 | 34.0 | 34.0625 | 4632800.0 |
| 2000-09-12 15:00:00 | MSFT | Stock | 34.0625 | 34.2812 | 33.8125 | 34.0625 | 10943600.0 |
| 2000-09-12 16:00:00 | MSFT | Stock | 34.0625 | 34.2656 | 33.9375 | 34.0625 | 1779400.0 |
| 2000-09-12 17:00:00 | MSFT | Stock | 34.0625 | 34.0625 | 33.9688 | 33.9688 | 5600.0 |
| 2000-09-12 18:00:00 | MSFT | Stock | 33.9688 | 34.0625 | 33.9688 | 34.0 | 2800.0 |
| 2000-09-12 08:00:00 | NVDA | Stock | 0.2939 | 0.2939 | 0.2939 | 0.2939 | 240000.0 |
| 2000-09-12 09:00:00 | NVDA | Stock | 0.2953 | 0.3021 | 0.2938 | 0.3 | 14568000.0 |
| 2000-09-12 10:00:00 | NVDA | Stock | 0.3001 | 0.3094 | 0.299 | 0.3031 | 26832000.0 |
| 2000-09-12 11:00:00 | NVDA | Stock | 0.3031 | 0.3044 | 0.2977 | 0.3034 | 17304000.0 |
| 2000-09-12 12:00:00 | NVDA | Stock | 0.3018 | 0.3044 | 0.3005 | 0.3042 | 5808000.0 |
| 2000-09-12 13:00:00 | NVDA | Stock | 0.3042 | 0.3057 | 0.3021 | 0.3047 | 9840000.0 |
| 2000-09-12 14:00:00 | NVDA | Stock | 0.3049 | 0.3055 | 0.2948 | 0.2969 | 13032000.0 |
| 2000-09-12 15:00:00 | NVDA | Stock | 0.2969 | 0.2979 | 0.2875 | 0.2919 | 32424000.0 |
| 2000-09-12 16:00:00 | NVDA | Stock | 0.2919 | 0.2922 | 0.2919 | 0.2922 | 528000.0 |
| 2000-09-12 08:00:00 | AMZN | Stock | 2.15 | 2.15 | 2.1375 | 2.1438 | 228000.0 |
| 2000-09-12 09:00:00 | AMZN | Stock | 2.15 | 2.1812 | 2.1156 | 2.1562 | 13878000.0 |
| 2000-09-12 10:00:00 | AMZN | Stock | 2.1562 | 2.1875 | 2.1438 | 2.1625 | 13084000.0 |
| 2000-09-12 11:00:00 | AMZN | Stock | 2.1625 | 2.2094 | 2.1531 | 2.1969 | 7852000.0 |
| 2000-09-12 12:00:00 | AMZN | Stock | 2.1938 | 2.2 | 2.175 | 2.1844 | 4762000.0 |
| 2000-09-12 13:00:00 | AMZN | Stock | 2.1812 | 2.1906 | 2.1688 | 2.1781 | 5146000.0 |
| 2000-09-12 14:00:00 | AMZN | Stock | 2.1875 | 2.1906 | 2.1312 | 2.1406 | 10538000.0 |
| 2000-09-12 15:00:00 | AMZN | Stock | 2.1312 | 2.1688 | 2.1125 | 2.1375 | 16778000.0 |
| 2000-09-12 16:00:00 | AMZN | Stock | 2.1375 | 2.1703 | 2.1344 | 2.1469 | 1134000.0 |
| 2000-09-12 17:00:00 | AMZN | Stock | 2.1469 | 2.1469 | 2.1469 | 2.1469 | 10000.0 |
| 2000-09-12 09:00:00 | CL | Stock | 27.4375 | 27.4688 | 27.25 | 27.3438 | 178800.0 |
| 2000-09-12 10:00:00 | CL | Stock | 27.3438 | 27.4375 | 27.1875 | 27.3125 | 337800.0 |
| 2000-09-12 11:00:00 | CL | Stock | 27.3438 | 27.7812 | 27.2812 | 27.7812 | 524400.0 |
| 2000-09-12 12:00:00 | CL | Stock | 27.8125 | 27.875 | 27.5938 | 27.625 | 485200.0 |
| 2000-09-12 13:00:00 | CL | Stock | 27.625 | 27.6562 | 27.5 | 27.5625 | 311800.0 |
| 2000-09-12 14:00:00 | CL | Stock | 27.5938 | 27.6562 | 27.4375 | 27.625 | 348800.0 |
| 2000-09-12 15:00:00 | CL | Stock | 27.625 | 27.875 | 27.5312 | 27.8438 | 780000.0 |
| 2000-09-12 16:00:00 | CL | Stock | 27.8438 | 27.8438 | 27.5781 | 27.5781 | 37600.0 |
> showing 47 of 15,522 rows — these rows as CSV