PREVIEW / stock_1hour / 2003-01-03
file: by_date/stock_1hour/2003/2003-01-03.parquet size: 419 KB rows: 19,976 symbols: 1,528
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-01-03 08:00:00 | AAPL | Stock | 0.2643 | 0.2643 | 0.2643 | 0.2643 | 16800.0 |
| 2003-01-03 09:00:00 | AAPL | Stock | 0.2648 | 0.2648 | 0.2605 | 0.263 | 16354464.0 |
| 2003-01-03 10:00:00 | AAPL | Stock | 0.263 | 0.2661 | 0.2607 | 0.2618 | 19707520.0 |
| 2003-01-03 11:00:00 | AAPL | Stock | 0.2616 | 0.2645 | 0.2607 | 0.2629 | 19784184.0 |
| 2003-01-03 12:00:00 | AAPL | Stock | 0.2629 | 0.263 | 0.2613 | 0.2627 | 14201432.0 |
| 2003-01-03 13:00:00 | AAPL | Stock | 0.2627 | 0.2655 | 0.2621 | 0.2645 | 9780008.0 |
| 2003-01-03 14:00:00 | AAPL | Stock | 0.2645 | 0.265 | 0.262 | 0.2638 | 16112320.0 |
| 2003-01-03 15:00:00 | AAPL | Stock | 0.2636 | 0.2666 | 0.2629 | 0.2661 | 24591560.0 |
| 2003-01-03 16:00:00 | AAPL | Stock | 0.2661 | 0.2679 | 0.2645 | 0.2679 | 4426744.0 |
| 2003-01-03 17:00:00 | AAPL | Stock | 0.2646 | 0.2661 | 0.2646 | 0.2661 | 89600.0 |
| 2003-01-03 08:00:00 | MSFT | Stock | 26.905 | 27.03 | 26.45 | 26.85 | 94878.0 |
| 2003-01-03 09:00:00 | MSFT | Stock | 26.83 | 26.85 | 26.6 | 26.795 | 7721290.0 |
| 2003-01-03 10:00:00 | MSFT | Stock | 26.795 | 26.87 | 26.52 | 26.6 | 12038266.0 |
| 2003-01-03 11:00:00 | MSFT | Stock | 26.61 | 26.62 | 26.485 | 26.56 | 6236406.0 |
| 2003-01-03 12:00:00 | MSFT | Stock | 26.565 | 26.585 | 26.44 | 26.55 | 4280980.0 |
| 2003-01-03 13:00:00 | MSFT | Stock | 26.55 | 26.775 | 26.52 | 26.6995 | 4294752.0 |
| 2003-01-03 14:00:00 | MSFT | Stock | 26.7 | 26.735 | 26.48 | 26.565 | 4999720.0 |
| 2003-01-03 15:00:00 | MSFT | Stock | 26.565 | 26.9 | 26.48 | 26.9 | 7938698.0 |
| 2003-01-03 16:00:00 | MSFT | Stock | 26.89 | 27.025 | 26.88 | 27.015 | 1298400.0 |
| 2003-01-03 17:00:00 | MSFT | Stock | 27.005 | 27.0495 | 26.8416 | 27.045 | 66440.0 |
| 2003-01-03 18:00:00 | MSFT | Stock | 27.065 | 27.065 | 27.01 | 27.01 | 8800.0 |
| 2003-01-03 08:00:00 | NVDA | Stock | 0.1107 | 0.1107 | 0.1022 | 0.1032 | 4709760.0 |
| 2003-01-03 09:00:00 | NVDA | Stock | 0.1032 | 0.1049 | 0.1017 | 0.1049 | 123028440.0 |
| 2003-01-03 10:00:00 | NVDA | Stock | 0.1049 | 0.1062 | 0.1029 | 0.1032 | 218147520.0 |
| 2003-01-03 11:00:00 | NVDA | Stock | 0.1031 | 0.1042 | 0.1027 | 0.1037 | 121431120.0 |
| 2003-01-03 12:00:00 | NVDA | Stock | 0.1037 | 0.1037 | 0.1025 | 0.1029 | 96906120.0 |
| 2003-01-03 13:00:00 | NVDA | Stock | 0.1029 | 0.1042 | 0.1027 | 0.1037 | 143473320.0 |
| 2003-01-03 14:00:00 | NVDA | Stock | 0.1037 | 0.1037 | 0.1008 | 0.1016 | 103908480.0 |
| 2003-01-03 15:00:00 | NVDA | Stock | 0.1016 | 0.1025 | 0.1012 | 0.1025 | 126046320.0 |
| 2003-01-03 16:00:00 | NVDA | Stock | 0.1023 | 0.1032 | 0.1018 | 0.1032 | 11772960.0 |
| 2003-01-03 17:00:00 | NVDA | Stock | 0.1032 | 0.1032 | 0.1022 | 0.1029 | 510960.0 |
| 2003-01-03 18:00:00 | NVDA | Stock | 0.1029 | 0.1032 | 0.1029 | 0.1032 | 882000.0 |
| 2003-01-03 08:00:00 | AMZN | Stock | 0.9765 | 0.9844 | 0.975 | 0.975 | 68000.0 |
| 2003-01-03 09:00:00 | AMZN | Stock | 0.9795 | 0.9805 | 0.971 | 0.975 | 12403780.0 |
| 2003-01-03 10:00:00 | AMZN | Stock | 0.975 | 0.987 | 0.973 | 0.986 | 24800260.0 |
| 2003-01-03 11:00:00 | AMZN | Stock | 0.986 | 0.9865 | 0.9795 | 0.985 | 15141360.0 |
| 2003-01-03 12:00:00 | AMZN | Stock | 0.9835 | 0.995 | 0.9835 | 0.992 | 17747640.0 |
| 2003-01-03 13:00:00 | AMZN | Stock | 0.9916 | 1.011 | 0.9915 | 1.0065 | 24919800.0 |
| 2003-01-03 14:00:00 | AMZN | Stock | 1.0066 | 1.016 | 1.001 | 1.015 | 23855220.0 |
| 2003-01-03 15:00:00 | AMZN | Stock | 1.014 | 1.0265 | 1.009 | 1.0255 | 30677980.0 |
| 2003-01-03 16:00:00 | AMZN | Stock | 1.025 | 1.0265 | 0.9972 | 1.025 | 6717340.0 |
| 2003-01-03 17:00:00 | AMZN | Stock | 1.0265 | 1.027 | 1.0155 | 1.0265 | 420200.0 |
| 2003-01-03 18:00:00 | AMZN | Stock | 1.0265 | 1.0265 | 1.025 | 1.025 | 34000.0 |
| 2003-01-03 09:00:00 | CL | Stock | 26.625 | 26.8 | 26.625 | 26.7 | 137000.0 |
| 2003-01-03 10:00:00 | CL | Stock | 26.7 | 26.825 | 26.6 | 26.655 | 269800.0 |
| 2003-01-03 11:00:00 | CL | Stock | 26.65 | 26.775 | 26.6 | 26.705 | 178000.0 |
| 2003-01-03 12:00:00 | CL | Stock | 26.69 | 26.725 | 26.665 | 26.675 | 196000.0 |
| 2003-01-03 13:00:00 | CL | Stock | 26.675 | 26.69 | 26.625 | 26.64 | 200000.0 |
| 2003-01-03 14:00:00 | CL | Stock | 26.65 | 26.65 | 26.51 | 26.56 | 199400.0 |
| 2003-01-03 15:00:00 | CL | Stock | 26.56 | 26.69 | 26.535 | 26.595 | 493600.0 |
> showing 50 of 19,976 rows — these rows as CSV