PREVIEW / stock_1hour / 2000-09-07
file: by_date/stock_1hour/2000/2000-09-07.parquet size: 304 KB rows: 15,642 symbols: 1,219
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-07 08:00:00 | AAPL | Stock | 1.0536 | 1.0558 | 1.0435 | 1.0536 | 212800.0 |
| 2000-09-07 09:00:00 | AAPL | Stock | 1.0536 | 1.0737 | 1.0402 | 1.0625 | 26308800.0 |
| 2000-09-07 10:00:00 | AAPL | Stock | 1.0658 | 1.0938 | 1.0647 | 1.0859 | 32457600.0 |
| 2000-09-07 11:00:00 | AAPL | Stock | 1.0859 | 1.0926 | 1.0826 | 1.0882 | 17214400.0 |
| 2000-09-07 12:00:00 | AAPL | Stock | 1.0893 | 1.0993 | 1.0859 | 1.0982 | 18272800.0 |
| 2000-09-07 13:00:00 | AAPL | Stock | 1.0993 | 1.1094 | 1.0982 | 1.1027 | 26572000.0 |
| 2000-09-07 14:00:00 | AAPL | Stock | 1.1027 | 1.1172 | 1.1004 | 1.1116 | 39194400.0 |
| 2000-09-07 15:00:00 | AAPL | Stock | 1.1138 | 1.1172 | 1.1049 | 1.1077 | 43243200.0 |
| 2000-09-07 16:00:00 | AAPL | Stock | 1.1083 | 1.1094 | 1.1038 | 1.1071 | 7968800.0 |
| 2000-09-07 17:00:00 | AAPL | Stock | 1.1049 | 1.1049 | 1.1049 | 1.1049 | 16800.0 |
| 2000-09-07 18:00:00 | AAPL | Stock | 1.1038 | 1.1038 | 1.1038 | 1.1038 | 28000.0 |
| 2000-09-07 08:00:00 | MSFT | Stock | 34.75 | 34.9375 | 34.7188 | 34.9062 | 64000.0 |
| 2000-09-07 09:00:00 | MSFT | Stock | 34.875 | 35.0469 | 34.7188 | 34.8125 | 3902400.0 |
| 2000-09-07 10:00:00 | MSFT | Stock | 34.7812 | 35.1875 | 34.7812 | 35.125 | 12851400.0 |
| 2000-09-07 11:00:00 | MSFT | Stock | 35.0938 | 36.0312 | 35.0938 | 35.4688 | 42574200.0 |
| 2000-09-07 12:00:00 | MSFT | Stock | 35.4688 | 35.5156 | 35.0625 | 35.0625 | 17108800.0 |
| 2000-09-07 13:00:00 | MSFT | Stock | 35.0625 | 35.1875 | 34.9375 | 35.0625 | 14013400.0 |
| 2000-09-07 14:00:00 | MSFT | Stock | 35.0312 | 35.1562 | 34.9062 | 35.0625 | 7441400.0 |
| 2000-09-07 15:00:00 | MSFT | Stock | 35.0625 | 35.1875 | 34.9062 | 35.0 | 10264400.0 |
| 2000-09-07 16:00:00 | MSFT | Stock | 35.0 | 35.9375 | 34.9375 | 35.0312 | 2083200.0 |
| 2000-09-07 17:00:00 | MSFT | Stock | 35.0 | 35.0625 | 34.9375 | 35.0625 | 8000.0 |
| 2000-09-07 08:00:00 | NVDA | Stock | 0.3104 | 0.325 | 0.3104 | 0.3167 | 192000.0 |
| 2000-09-07 09:00:00 | NVDA | Stock | 0.3094 | 0.3135 | 0.3052 | 0.3052 | 27432000.0 |
| 2000-09-07 10:00:00 | NVDA | Stock | 0.306 | 0.3224 | 0.3005 | 0.3217 | 56832000.0 |
| 2000-09-07 11:00:00 | NVDA | Stock | 0.3219 | 0.3223 | 0.3141 | 0.3172 | 20928000.0 |
| 2000-09-07 12:00:00 | NVDA | Stock | 0.3177 | 0.3185 | 0.3167 | 0.3182 | 20016000.0 |
| 2000-09-07 13:00:00 | NVDA | Stock | 0.318 | 0.3198 | 0.3156 | 0.3169 | 12672000.0 |
| 2000-09-07 14:00:00 | NVDA | Stock | 0.3169 | 0.3208 | 0.3167 | 0.3198 | 28008000.0 |
| 2000-09-07 15:00:00 | NVDA | Stock | 0.3182 | 0.326 | 0.3182 | 0.325 | 56400000.0 |
| 2000-09-07 16:00:00 | NVDA | Stock | 0.325 | 0.3255 | 0.325 | 0.3255 | 3816000.0 |
| 2000-09-07 17:00:00 | NVDA | Stock | 0.3263 | 0.3263 | 0.3253 | 0.3253 | 144000.0 |
| 2000-09-07 08:00:00 | AMZN | Stock | 2.25 | 2.35 | 2.25 | 2.3125 | 1092000.0 |
| 2000-09-07 09:00:00 | AMZN | Stock | 2.3125 | 2.35 | 2.2219 | 2.2281 | 21438000.0 |
| 2000-09-07 10:00:00 | AMZN | Stock | 2.225 | 2.2531 | 2.1688 | 2.2281 | 46372000.0 |
| 2000-09-07 11:00:00 | AMZN | Stock | 2.2281 | 2.2438 | 2.1844 | 2.1906 | 12152000.0 |
| 2000-09-07 12:00:00 | AMZN | Stock | 2.1906 | 2.2 | 2.175 | 2.2 | 8830000.0 |
| 2000-09-07 13:00:00 | AMZN | Stock | 2.1969 | 2.2 | 2.1625 | 2.1625 | 12136000.0 |
| 2000-09-07 14:00:00 | AMZN | Stock | 2.1656 | 2.175 | 2.15 | 2.1656 | 21244000.0 |
| 2000-09-07 15:00:00 | AMZN | Stock | 2.1656 | 2.175 | 2.15 | 2.175 | 17480000.0 |
| 2000-09-07 16:00:00 | AMZN | Stock | 2.175 | 2.225 | 2.1688 | 2.1781 | 3276000.0 |
| 2000-09-07 17:00:00 | AMZN | Stock | 2.1781 | 2.1875 | 2.1625 | 2.1875 | 394000.0 |
| 2000-09-07 09:00:00 | CL | Stock | 27.2812 | 27.2812 | 27.0 | 27.0312 | 351200.0 |
| 2000-09-07 10:00:00 | CL | Stock | 27.0312 | 27.0312 | 26.3438 | 26.6875 | 946400.0 |
| 2000-09-07 11:00:00 | CL | Stock | 26.6875 | 27.0938 | 26.6562 | 26.75 | 403800.0 |
| 2000-09-07 12:00:00 | CL | Stock | 26.7188 | 26.75 | 26.4688 | 26.5 | 291400.0 |
| 2000-09-07 13:00:00 | CL | Stock | 26.4688 | 26.5625 | 26.375 | 26.5 | 510000.0 |
| 2000-09-07 14:00:00 | CL | Stock | 26.5 | 26.5938 | 26.4375 | 26.5625 | 532200.0 |
| 2000-09-07 15:00:00 | CL | Stock | 26.5312 | 26.625 | 26.4375 | 26.625 | 494600.0 |
| 2000-09-07 16:00:00 | CL | Stock | 26.625 | 26.6562 | 26.625 | 26.6406 | 147800.0 |
> showing 49 of 15,642 rows — these rows as CSV