PREVIEW / stock_1hour / 2001-10-05
file: by_date/stock_1hour/2001/2001-10-05.parquet size: 360 KB rows: 17,509 symbols: 1,334
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-05 08:00:00 | AAPL | Stock | 0.2834 | 0.2854 | 0.2804 | 0.2804 | 168000.0 |
| 2001-10-05 09:00:00 | AAPL | Stock | 0.2795 | 0.2836 | 0.2677 | 0.2686 | 63235200.0 |
| 2001-10-05 10:00:00 | AAPL | Stock | 0.2688 | 0.2752 | 0.2679 | 0.2745 | 86329600.0 |
| 2001-10-05 11:00:00 | AAPL | Stock | 0.2743 | 0.2839 | 0.2725 | 0.2814 | 52427200.0 |
| 2001-10-05 12:00:00 | AAPL | Stock | 0.2816 | 0.2832 | 0.2779 | 0.282 | 21050400.0 |
| 2001-10-05 13:00:00 | AAPL | Stock | 0.2821 | 0.2854 | 0.2818 | 0.2832 | 30486400.0 |
| 2001-10-05 14:00:00 | AAPL | Stock | 0.2834 | 0.2884 | 0.283 | 0.2871 | 24729600.0 |
| 2001-10-05 15:00:00 | AAPL | Stock | 0.2868 | 0.2884 | 0.2832 | 0.2882 | 33387200.0 |
| 2001-10-05 16:00:00 | AAPL | Stock | 0.2882 | 0.2886 | 0.2869 | 0.2882 | 5135200.0 |
| 2001-10-05 17:00:00 | AAPL | Stock | 0.2882 | 0.2882 | 0.2882 | 0.2882 | 84000.0 |
| 2001-10-05 18:00:00 | AAPL | Stock | 0.2882 | 0.2882 | 0.2882 | 0.2882 | 28000.0 |
| 2001-10-05 08:00:00 | MSFT | Stock | 28.16 | 28.435 | 28.0 | 28.175 | 281800.0 |
| 2001-10-05 09:00:00 | MSFT | Stock | 28.14 | 28.32 | 27.61 | 27.645 | 9308000.0 |
| 2001-10-05 10:00:00 | MSFT | Stock | 27.645 | 27.875 | 27.47 | 27.58 | 15434600.0 |
| 2001-10-05 11:00:00 | MSFT | Stock | 27.595 | 28.165 | 27.5 | 28.085 | 8983600.0 |
| 2001-10-05 12:00:00 | MSFT | Stock | 28.0705 | 28.75 | 28.055 | 28.6445 | 11552200.0 |
| 2001-10-05 13:00:00 | MSFT | Stock | 28.64 | 28.785 | 28.33 | 28.575 | 7377400.0 |
| 2001-10-05 14:00:00 | MSFT | Stock | 28.575 | 28.91 | 28.33 | 28.8801 | 10553600.0 |
| 2001-10-05 15:00:00 | MSFT | Stock | 28.885 | 28.95 | 28.535 | 28.86 | 10768000.0 |
| 2001-10-05 16:00:00 | MSFT | Stock | 28.825 | 28.895 | 28.2454 | 28.2515 | 2338400.0 |
| 2001-10-05 17:00:00 | MSFT | Stock | 28.85 | 28.875 | 28.245 | 28.86 | 140600.0 |
| 2001-10-05 18:00:00 | MSFT | Stock | 28.875 | 28.875 | 28.875 | 28.875 | 400.0 |
| 2001-10-05 08:00:00 | NVDA | Stock | 0.2708 | 0.2708 | 0.265 | 0.265 | 1728000.0 |
| 2001-10-05 09:00:00 | NVDA | Stock | 0.2657 | 0.2691 | 0.2573 | 0.2581 | 182292000.0 |
| 2001-10-05 10:00:00 | NVDA | Stock | 0.2578 | 0.2617 | 0.255 | 0.2551 | 229968000.0 |
| 2001-10-05 11:00:00 | NVDA | Stock | 0.2551 | 0.2678 | 0.2549 | 0.2636 | 175512000.0 |
| 2001-10-05 12:00:00 | NVDA | Stock | 0.2635 | 0.2669 | 0.2596 | 0.2652 | 52092000.0 |
| 2001-10-05 13:00:00 | NVDA | Stock | 0.2654 | 0.2722 | 0.2646 | 0.2667 | 86148000.0 |
| 2001-10-05 14:00:00 | NVDA | Stock | 0.2662 | 0.2807 | 0.2658 | 0.2779 | 125484000.0 |
| 2001-10-05 15:00:00 | NVDA | Stock | 0.278 | 0.2792 | 0.27 | 0.2742 | 174276000.0 |
| 2001-10-05 16:00:00 | NVDA | Stock | 0.2742 | 0.2792 | 0.2652 | 0.2767 | 6600000.0 |
| 2001-10-05 17:00:00 | NVDA | Stock | 0.2767 | 0.2768 | 0.2742 | 0.2768 | 228000.0 |
| 2001-10-05 18:00:00 | NVDA | Stock | 0.2775 | 0.2775 | 0.2767 | 0.2767 | 156000.0 |
| 2001-10-05 08:00:00 | AMZN | Stock | 0.359 | 0.359 | 0.352 | 0.3525 | 36000.0 |
| 2001-10-05 09:00:00 | AMZN | Stock | 0.3452 | 0.359 | 0.339 | 0.3505 | 9298000.0 |
| 2001-10-05 10:00:00 | AMZN | Stock | 0.3505 | 0.3565 | 0.337 | 0.341 | 12342000.0 |
| 2001-10-05 11:00:00 | AMZN | Stock | 0.3405 | 0.3545 | 0.3395 | 0.3485 | 8882000.0 |
| 2001-10-05 12:00:00 | AMZN | Stock | 0.3485 | 0.355 | 0.345 | 0.3535 | 6476000.0 |
| 2001-10-05 13:00:00 | AMZN | Stock | 0.353 | 0.372 | 0.3525 | 0.37 | 16362000.0 |
| 2001-10-05 14:00:00 | AMZN | Stock | 0.37 | 0.395 | 0.37 | 0.3865 | 31498000.0 |
| 2001-10-05 15:00:00 | AMZN | Stock | 0.3865 | 0.3875 | 0.353 | 0.3595 | 23856000.0 |
| 2001-10-05 16:00:00 | AMZN | Stock | 0.3595 | 0.3685 | 0.359 | 0.36 | 2446000.0 |
| 2001-10-05 18:00:00 | AMZN | Stock | 0.355 | 0.355 | 0.355 | 0.355 | 20000.0 |
| 2001-10-05 09:00:00 | CL | Stock | 28.075 | 28.275 | 28.075 | 28.225 | 247600.0 |
| 2001-10-05 10:00:00 | CL | Stock | 28.225 | 28.4 | 27.975 | 28.025 | 476200.0 |
| 2001-10-05 11:00:00 | CL | Stock | 28.09 | 28.3 | 28.05 | 28.245 | 338800.0 |
| 2001-10-05 12:00:00 | CL | Stock | 28.245 | 28.45 | 28.245 | 28.395 | 273000.0 |
| 2001-10-05 13:00:00 | CL | Stock | 28.415 | 28.625 | 28.415 | 28.51 | 454400.0 |
| 2001-10-05 14:00:00 | CL | Stock | 28.525 | 28.765 | 28.515 | 28.625 | 469800.0 |
| 2001-10-05 15:00:00 | CL | Stock | 28.625 | 29.0 | 28.535 | 28.885 | 714200.0 |
> showing 50 of 17,509 rows — these rows as CSV