PREVIEW / stock_1hour / 2008-08-06
file: by_date/stock_1hour/2008/2008-08-06.parquet size: 824 KB rows: 40,003 symbols: 3,322
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-06 07:00:00 | AAPL | Stock | 5.7411 | 5.7518 | 5.7411 | 5.75 | 40880.0 |
| 2008-08-06 08:00:00 | AAPL | Stock | 5.7171 | 5.735 | 5.7107 | 5.7143 | 1676668.0 |
| 2008-08-06 09:00:00 | AAPL | Stock | 5.7164 | 5.7268 | 5.6668 | 5.6882 | 83356336.0 |
| 2008-08-06 10:00:00 | AAPL | Stock | 5.6882 | 5.7089 | 5.6429 | 5.6821 | 117382384.0 |
| 2008-08-06 11:00:00 | AAPL | Stock | 5.6814 | 5.8243 | 5.6621 | 5.8229 | 143128412.0 |
| 2008-08-06 12:00:00 | AAPL | Stock | 5.8227 | 5.8929 | 5.8161 | 5.8364 | 126491904.0 |
| 2008-08-06 13:00:00 | AAPL | Stock | 5.8361 | 5.8679 | 5.81 | 5.8296 | 77478296.0 |
| 2008-08-06 14:00:00 | AAPL | Stock | 5.83 | 5.8929 | 5.8196 | 5.8654 | 99800652.0 |
| 2008-08-06 15:00:00 | AAPL | Stock | 5.8654 | 5.8821 | 5.8304 | 5.8639 | 121648324.0 |
| 2008-08-06 16:00:00 | AAPL | Stock | 5.864 | 5.8821 | 5.79 | 5.87 | 9112236.0 |
| 2008-08-06 17:00:00 | AAPL | Stock | 5.8711 | 5.875 | 5.8575 | 5.8579 | 654192.0 |
| 2008-08-06 18:00:00 | AAPL | Stock | 5.8575 | 5.8575 | 5.8482 | 5.8482 | 43120.0 |
| 2008-08-06 19:00:00 | AAPL | Stock | 5.8429 | 5.8464 | 5.8414 | 5.8461 | 45640.0 |
| 2008-08-06 07:00:00 | MSFT | Stock | 26.88 | 27.0 | 26.26 | 26.61 | 176965.0 |
| 2008-08-06 08:00:00 | MSFT | Stock | 26.55 | 26.7 | 26.21 | 26.57 | 468187.0 |
| 2008-08-06 09:00:00 | MSFT | Stock | 26.57 | 27.03 | 26.38 | 26.46 | 11930352.0 |
| 2008-08-06 10:00:00 | MSFT | Stock | 26.46 | 26.58 | 26.39 | 26.47 | 13895909.0 |
| 2008-08-06 11:00:00 | MSFT | Stock | 26.47 | 26.95 | 26.45 | 26.811 | 14686040.0 |
| 2008-08-06 12:00:00 | MSFT | Stock | 26.81 | 26.95 | 26.66 | 26.7 | 9214931.0 |
| 2008-08-06 13:00:00 | MSFT | Stock | 26.7 | 26.82 | 26.65 | 26.732 | 7456441.0 |
| 2008-08-06 14:00:00 | MSFT | Stock | 26.74 | 27.07 | 26.73 | 27.05 | 10338022.0 |
| 2008-08-06 15:00:00 | MSFT | Stock | 27.05 | 27.16 | 26.99 | 26.99 | 21569296.0 |
| 2008-08-06 16:00:00 | MSFT | Stock | 27.01 | 27.125 | 26.774 | 26.98 | 2901221.0 |
| 2008-08-06 17:00:00 | MSFT | Stock | 26.98 | 27.15 | 26.98 | 27.0 | 8247.0 |
| 2008-08-06 18:00:00 | MSFT | Stock | 26.97 | 27.09 | 26.97 | 27.01 | 34180.0 |
| 2008-08-06 19:00:00 | MSFT | Stock | 26.98 | 26.98 | 26.98 | 26.98 | 200.0 |
| 2008-08-06 08:00:00 | NVDA | Stock | 0.2812 | 0.2845 | 0.2768 | 0.283 | 479200.0 |
| 2008-08-06 09:00:00 | NVDA | Stock | 0.2798 | 0.2812 | 0.2772 | 0.2778 | 45893440.0 |
| 2008-08-06 10:00:00 | NVDA | Stock | 0.278 | 0.2783 | 0.2715 | 0.2737 | 135399320.0 |
| 2008-08-06 11:00:00 | NVDA | Stock | 0.2735 | 0.2785 | 0.2723 | 0.2772 | 122373440.0 |
| 2008-08-06 12:00:00 | NVDA | Stock | 0.2772 | 0.282 | 0.2772 | 0.28 | 93556160.0 |
| 2008-08-06 13:00:00 | NVDA | Stock | 0.2798 | 0.2825 | 0.2785 | 0.2822 | 109863680.0 |
| 2008-08-06 14:00:00 | NVDA | Stock | 0.282 | 0.2898 | 0.2818 | 0.2881 | 128920160.0 |
| 2008-08-06 15:00:00 | NVDA | Stock | 0.2882 | 0.2885 | 0.285 | 0.287 | 153689080.0 |
| 2008-08-06 16:00:00 | NVDA | Stock | 0.287 | 0.288 | 0.2806 | 0.2862 | 13525560.0 |
| 2008-08-06 17:00:00 | NVDA | Stock | 0.2862 | 0.2872 | 0.282 | 0.2825 | 372000.0 |
| 2008-08-06 18:00:00 | NVDA | Stock | 0.286 | 0.2862 | 0.2838 | 0.2862 | 136000.0 |
| 2008-08-06 19:00:00 | NVDA | Stock | 0.285 | 0.285 | 0.285 | 0.285 | 32000.0 |
| 2008-08-06 06:00:00 | AMZN | Stock | 3.925 | 3.925 | 3.925 | 3.925 | 4000.0 |
| 2008-08-06 08:00:00 | AMZN | Stock | 3.932 | 3.936 | 3.9315 | 3.936 | 20000.0 |
| 2008-08-06 09:00:00 | AMZN | Stock | 3.9355 | 3.9365 | 3.8765 | 3.901 | 21685800.0 |
| 2008-08-06 10:00:00 | AMZN | Stock | 3.9013 | 3.9045 | 3.839 | 3.8495 | 22234060.0 |
| 2008-08-06 11:00:00 | AMZN | Stock | 3.85 | 3.9005 | 3.8365 | 3.885 | 15945760.0 |
| 2008-08-06 12:00:00 | AMZN | Stock | 3.885 | 3.893 | 3.8635 | 3.877 | 10930940.0 |
| 2008-08-06 13:00:00 | AMZN | Stock | 3.876 | 3.9035 | 3.862 | 3.8735 | 11314340.0 |
| 2008-08-06 14:00:00 | AMZN | Stock | 3.8735 | 3.925 | 3.8735 | 3.908 | 16527020.0 |
| 2008-08-06 15:00:00 | AMZN | Stock | 3.908 | 3.922 | 3.8815 | 3.904 | 23609000.0 |
| 2008-08-06 16:00:00 | AMZN | Stock | 3.904 | 3.9045 | 3.8855 | 3.8892 | 3336660.0 |
| 2008-08-06 17:00:00 | AMZN | Stock | 3.895 | 3.895 | 3.895 | 3.895 | 2000.0 |
| 2008-08-06 18:00:00 | AMZN | Stock | 3.889 | 3.889 | 3.8885 | 3.8885 | 10000.0 |
> showing 50 of 40,003 rows — these rows as CSV