PREVIEW / stock_1hour / 2003-06-23
file: by_date/stock_1hour/2003/2003-06-23.parquet size: 459 KB rows: 22,532 symbols: 1,581
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 |
|---|---|---|---|---|---|---|---|
| 2003-06-23 08:00:00 | AAPL | Stock | 0.3455 | 0.3504 | 0.343 | 0.3464 | 3029600.0 |
| 2003-06-23 09:00:00 | AAPL | Stock | 0.3452 | 0.3516 | 0.3429 | 0.3502 | 47396104.0 |
| 2003-06-23 10:00:00 | AAPL | Stock | 0.3502 | 0.3504 | 0.3379 | 0.3398 | 70807408.0 |
| 2003-06-23 11:00:00 | AAPL | Stock | 0.3398 | 0.3436 | 0.3386 | 0.3411 | 32452616.0 |
| 2003-06-23 12:00:00 | AAPL | Stock | 0.3413 | 0.3427 | 0.3386 | 0.3402 | 20092632.0 |
| 2003-06-23 13:00:00 | AAPL | Stock | 0.34 | 0.3438 | 0.3395 | 0.3396 | 23959768.0 |
| 2003-06-23 14:00:00 | AAPL | Stock | 0.3398 | 0.3414 | 0.3348 | 0.3355 | 34765024.0 |
| 2003-06-23 15:00:00 | AAPL | Stock | 0.3354 | 0.3393 | 0.3354 | 0.3386 | 37516472.0 |
| 2003-06-23 16:00:00 | AAPL | Stock | 0.3391 | 0.3404 | 0.3382 | 0.34 | 2514400.0 |
| 2003-06-23 17:00:00 | AAPL | Stock | 0.3404 | 0.3404 | 0.34 | 0.34 | 123200.0 |
| 2003-06-23 18:00:00 | AAPL | Stock | 0.3404 | 0.3404 | 0.3399 | 0.3404 | 1635200.0 |
| 2003-06-23 08:00:00 | MSFT | Stock | 26.22 | 26.22 | 26.1 | 26.15 | 47075.0 |
| 2003-06-23 09:00:00 | MSFT | Stock | 26.15 | 26.24 | 25.05 | 26.18 | 6911852.0 |
| 2003-06-23 10:00:00 | MSFT | Stock | 26.18 | 26.22 | 25.9 | 25.96 | 9319085.0 |
| 2003-06-23 11:00:00 | MSFT | Stock | 25.96 | 25.97 | 25.51 | 25.59 | 8613348.0 |
| 2003-06-23 12:00:00 | MSFT | Stock | 25.59 | 25.7 | 25.5 | 25.61 | 4607462.0 |
| 2003-06-23 13:00:00 | MSFT | Stock | 25.61 | 25.74 | 25.585 | 25.71 | 3336650.0 |
| 2003-06-23 14:00:00 | MSFT | Stock | 25.71 | 25.74 | 25.55 | 25.56 | 5572799.0 |
| 2003-06-23 15:00:00 | MSFT | Stock | 25.56 | 25.792 | 25.49 | 25.77 | 8084666.0 |
| 2003-06-23 16:00:00 | MSFT | Stock | 25.75 | 26.065 | 25.6 | 25.78 | 986417.0 |
| 2003-06-23 17:00:00 | MSFT | Stock | 25.77 | 25.82 | 25.75 | 25.78 | 205224.0 |
| 2003-06-23 18:00:00 | MSFT | Stock | 25.78 | 25.82 | 25.78 | 25.79 | 214586.0 |
| 2003-06-23 08:00:00 | NVDA | Stock | 0.1983 | 0.1983 | 0.1975 | 0.1977 | 566160.0 |
| 2003-06-23 09:00:00 | NVDA | Stock | 0.1977 | 0.1982 | 0.1947 | 0.1973 | 137398920.0 |
| 2003-06-23 10:00:00 | NVDA | Stock | 0.1972 | 0.1972 | 0.1923 | 0.1936 | 112730280.0 |
| 2003-06-23 11:00:00 | NVDA | Stock | 0.1936 | 0.1937 | 0.1912 | 0.1917 | 84967680.0 |
| 2003-06-23 12:00:00 | NVDA | Stock | 0.1917 | 0.1919 | 0.1899 | 0.1905 | 64834200.0 |
| 2003-06-23 13:00:00 | NVDA | Stock | 0.1905 | 0.1913 | 0.1902 | 0.1907 | 32281320.0 |
| 2003-06-23 14:00:00 | NVDA | Stock | 0.1907 | 0.1909 | 0.1882 | 0.1882 | 83417760.0 |
| 2003-06-23 15:00:00 | NVDA | Stock | 0.1882 | 0.1902 | 0.1864 | 0.1902 | 139466760.0 |
| 2003-06-23 16:00:00 | NVDA | Stock | 0.1903 | 0.1916 | 0.1892 | 0.1911 | 9504240.0 |
| 2003-06-23 17:00:00 | NVDA | Stock | 0.191 | 0.191 | 0.189 | 0.189 | 664320.0 |
| 2003-06-23 18:00:00 | NVDA | Stock | 0.1903 | 0.1906 | 0.1903 | 0.1904 | 1236000.0 |
| 2003-06-23 08:00:00 | AMZN | Stock | 1.76 | 1.775 | 1.757 | 1.76 | 66000.0 |
| 2003-06-23 09:00:00 | AMZN | Stock | 1.759 | 1.793 | 1.7525 | 1.785 | 31173320.0 |
| 2003-06-23 10:00:00 | AMZN | Stock | 1.785 | 1.7875 | 1.762 | 1.766 | 35117520.0 |
| 2003-06-23 11:00:00 | AMZN | Stock | 1.7665 | 1.7695 | 1.753 | 1.7565 | 18536620.0 |
| 2003-06-23 12:00:00 | AMZN | Stock | 1.7565 | 1.779 | 1.7515 | 1.775 | 20569200.0 |
| 2003-06-23 13:00:00 | AMZN | Stock | 1.775 | 1.7785 | 1.771 | 1.7745 | 10816440.0 |
| 2003-06-23 14:00:00 | AMZN | Stock | 1.775 | 1.776 | 1.7615 | 1.762 | 11273520.0 |
| 2003-06-23 15:00:00 | AMZN | Stock | 1.7626 | 1.775 | 1.7575 | 1.775 | 18665520.0 |
| 2003-06-23 16:00:00 | AMZN | Stock | 1.775 | 1.79 | 1.768 | 1.785 | 5210000.0 |
| 2003-06-23 17:00:00 | AMZN | Stock | 1.7775 | 1.7825 | 1.7706 | 1.778 | 3438000.0 |
| 2003-06-23 18:00:00 | AMZN | Stock | 1.7825 | 1.7825 | 1.7791 | 1.7795 | 302000.0 |
| 2003-06-23 09:00:00 | CL | Stock | 29.75 | 29.8 | 29.58 | 29.69 | 404800.0 |
| 2003-06-23 10:00:00 | CL | Stock | 29.695 | 29.77 | 29.62 | 29.665 | 385600.0 |
| 2003-06-23 11:00:00 | CL | Stock | 29.66 | 29.7 | 29.6 | 29.675 | 191800.0 |
| 2003-06-23 12:00:00 | CL | Stock | 29.675 | 29.69 | 29.595 | 29.61 | 208800.0 |
| 2003-06-23 13:00:00 | CL | Stock | 29.615 | 29.69 | 29.595 | 29.685 | 172600.0 |
| 2003-06-23 14:00:00 | CL | Stock | 29.6875 | 29.735 | 29.655 | 29.735 | 195400.0 |
> showing 50 of 22,532 rows — these rows as CSV