PREVIEW / stock_1hour / 2024-06-18
file: by_date/stock_1hour/2024/2024-06-18.parquet size: 1.3 MB rows: 58,982 symbols: 939
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 |
|---|---|---|---|---|---|---|---|
| 2024-06-18 04:00:00 | AAPL | Stock | 216.81 | 217.5 | 215.0 | 216.9 | 32106.0 |
| 2024-06-18 05:00:00 | AAPL | Stock | 216.96 | 218.36 | 216.93 | 218.2 | 85170.0 |
| 2024-06-18 06:00:00 | AAPL | Stock | 218.17 | 218.27 | 217.62 | 217.71 | 13435.0 |
| 2024-06-18 07:00:00 | AAPL | Stock | 217.77 | 218.07 | 217.38 | 217.83 | 76086.0 |
| 2024-06-18 08:00:00 | AAPL | Stock | 217.8 | 218.2189 | 216.61 | 217.3 | 283873.0 |
| 2024-06-18 09:00:00 | AAPL | Stock | 217.2 | 218.63 | 214.52 | 214.6666 | 11906160.0 |
| 2024-06-18 10:00:00 | AAPL | Stock | 214.68 | 215.96 | 214.44 | 215.495 | 9054799.0 |
| 2024-06-18 11:00:00 | AAPL | Stock | 215.4998 | 215.82 | 213.41 | 213.59 | 8765619.0 |
| 2024-06-18 12:00:00 | AAPL | Stock | 213.58 | 214.23 | 213.0 | 214.2 | 5718091.0 |
| 2024-06-18 13:00:00 | AAPL | Stock | 214.18 | 214.2 | 213.41 | 213.575 | 4754471.0 |
| 2024-06-18 14:00:00 | AAPL | Stock | 213.575 | 214.04 | 213.065 | 213.865 | 4599335.0 |
| 2024-06-18 15:00:00 | AAPL | Stock | 213.865 | 215.1 | 213.81 | 214.38 | 10119868.0 |
| 2024-06-18 16:00:00 | AAPL | Stock | 214.3301 | 214.58 | 213.9 | 214.17 | 9911831.0 |
| 2024-06-18 17:00:00 | AAPL | Stock | 214.21 | 214.29 | 214.06 | 214.06 | 90920.0 |
| 2024-06-18 18:00:00 | AAPL | Stock | 214.05 | 214.21 | 214.0011 | 214.15 | 45134.0 |
| 2024-06-18 19:00:00 | AAPL | Stock | 214.11 | 214.159 | 214.0 | 214.02 | 34733.0 |
| 2024-06-18 04:00:00 | MSFT | Stock | 449.44 | 449.92 | 449.1 | 449.92 | 4258.0 |
| 2024-06-18 05:00:00 | MSFT | Stock | 450.01 | 450.05 | 449.76 | 449.76 | 3383.0 |
| 2024-06-18 06:00:00 | MSFT | Stock | 450.05 | 450.4 | 449.76 | 449.81 | 2797.0 |
| 2024-06-18 07:00:00 | MSFT | Stock | 449.8 | 449.95 | 449.2 | 449.48 | 6875.0 |
| 2024-06-18 08:00:00 | MSFT | Stock | 449.66 | 450.5 | 447.25 | 449.3 | 39602.0 |
| 2024-06-18 09:00:00 | MSFT | Stock | 449.3 | 450.15 | 446.9 | 447.77 | 1387322.0 |
| 2024-06-18 10:00:00 | MSFT | Stock | 447.785 | 448.33 | 445.32 | 446.45 | 1500361.0 |
| 2024-06-18 11:00:00 | MSFT | Stock | 446.4401 | 446.54 | 444.89 | 446.49 | 960550.0 |
| 2024-06-18 12:00:00 | MSFT | Stock | 446.51 | 447.69 | 446.33 | 447.56 | 676666.0 |
| 2024-06-18 13:00:00 | MSFT | Stock | 447.5 | 447.9 | 446.78 | 447.33 | 632716.0 |
| 2024-06-18 14:00:00 | MSFT | Stock | 447.37 | 447.3899 | 445.63 | 446.05 | 924345.0 |
| 2024-06-18 15:00:00 | MSFT | Stock | 446.065 | 446.91 | 445.17 | 446.42 | 1435610.0 |
| 2024-06-18 16:00:00 | MSFT | Stock | 446.34 | 446.5199 | 445.5315 | 446.25 | 3466642.0 |
| 2024-06-18 17:00:00 | MSFT | Stock | 446.34 | 446.5167 | 445.7601 | 446.37 | 11483.0 |
| 2024-06-18 18:00:00 | MSFT | Stock | 446.48 | 447.6093 | 446.39 | 447.12 | 9739.0 |
| 2024-06-18 19:00:00 | MSFT | Stock | 447.26 | 447.26 | 446.36 | 446.42 | 8318.0 |
| 2024-06-18 04:00:00 | NVDA | Stock | 131.6 | 131.74 | 131.15 | 131.44 | 223391.0 |
| 2024-06-18 05:00:00 | NVDA | Stock | 131.44 | 131.6 | 131.0 | 131.2 | 209572.0 |
| 2024-06-18 06:00:00 | NVDA | Stock | 131.19 | 131.84 | 131.0 | 131.5 | 314975.0 |
| 2024-06-18 07:00:00 | NVDA | Stock | 131.45 | 132.3 | 131.4 | 131.95 | 1457714.0 |
| 2024-06-18 08:00:00 | NVDA | Stock | 131.93 | 132.29 | 130.9 | 131.3915 | 2533119.0 |
| 2024-06-18 09:00:00 | NVDA | Stock | 131.4 | 133.35 | 130.69 | 133.19 | 39517122.0 |
| 2024-06-18 10:00:00 | NVDA | Stock | 133.19 | 133.7199 | 132.7 | 133.1822 | 37252097.0 |
| 2024-06-18 11:00:00 | NVDA | Stock | 133.19 | 134.8 | 132.7 | 134.5838 | 35913111.0 |
| 2024-06-18 12:00:00 | NVDA | Stock | 134.58 | 134.99 | 134.02 | 134.97 | 22497000.0 |
| 2024-06-18 13:00:00 | NVDA | Stock | 134.965 | 136.25 | 134.9 | 135.74 | 33988028.0 |
| 2024-06-18 14:00:00 | NVDA | Stock | 135.75 | 136.33 | 135.07 | 136.13 | 30615536.0 |
| 2024-06-18 15:00:00 | NVDA | Stock | 136.14 | 136.14 | 135.02 | 135.68 | 34563173.0 |
| 2024-06-18 16:00:00 | NVDA | Stock | 135.58 | 136.24 | 133.6382 | 136.2 | 17598493.0 |
| 2024-06-18 17:00:00 | NVDA | Stock | 136.2 | 136.68 | 135.58 | 136.58 | 1744528.0 |
| 2024-06-18 18:00:00 | NVDA | Stock | 136.55 | 136.62 | 136.33 | 136.55 | 964911.0 |
| 2024-06-18 19:00:00 | NVDA | Stock | 136.56 | 136.59 | 136.07 | 136.4 | 1059625.0 |
| 2024-06-18 04:00:00 | AMZN | Stock | 183.01 | 184.1 | 182.7 | 183.85 | 13465.0 |
| 2024-06-18 05:00:00 | AMZN | Stock | 183.88 | 183.92 | 183.84 | 183.89 | 1920.0 |
> showing 50 of 58,982 rows — these rows as CSV