PREVIEW / stock_1hour / 2024-12-18
file: by_date/stock_1hour/2024/2024-12-18.parquet size: 1.5 MB rows: 65,505 symbols: 665
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-12-18 04:00:00 | AAPL | Stock | 253.6 | 253.61 | 253.03 | 253.3 | 7671.0 |
| 2024-12-18 05:00:00 | AAPL | Stock | 253.36 | 253.5 | 253.33 | 253.42 | 4583.0 |
| 2024-12-18 06:00:00 | AAPL | Stock | 253.45 | 253.45 | 253.15 | 253.16 | 3567.0 |
| 2024-12-18 07:00:00 | AAPL | Stock | 253.21 | 253.5 | 253.11 | 253.35 | 15892.0 |
| 2024-12-18 08:00:00 | AAPL | Stock | 253.28 | 253.97 | 252.421 | 252.421 | 135520.0 |
| 2024-12-18 09:00:00 | AAPL | Stock | 252.4207 | 253.4 | 251.33 | 252.02 | 3905803.0 |
| 2024-12-18 10:00:00 | AAPL | Stock | 252.035 | 253.8 | 251.98 | 253.4701 | 3451431.0 |
| 2024-12-18 11:00:00 | AAPL | Stock | 253.52 | 253.62 | 252.84 | 253.4309 | 1848115.0 |
| 2024-12-18 12:00:00 | AAPL | Stock | 253.43 | 254.04 | 253.3506 | 253.8535 | 2093442.0 |
| 2024-12-18 13:00:00 | AAPL | Stock | 253.85 | 254.28 | 253.61 | 254.09 | 2092944.0 |
| 2024-12-18 14:00:00 | AAPL | Stock | 254.08 | 254.1 | 250.92 | 251.05 | 4715426.0 |
| 2024-12-18 15:00:00 | AAPL | Stock | 251.02 | 251.38 | 247.74 | 247.86 | 10316774.0 |
| 2024-12-18 16:00:00 | AAPL | Stock | 247.83 | 248.49 | 246.0 | 246.95 | 14871102.0 |
| 2024-12-18 17:00:00 | AAPL | Stock | 246.97 | 248.05 | 246.41 | 246.6095 | 101264.0 |
| 2024-12-18 18:00:00 | AAPL | Stock | 246.65 | 247.98 | 246.5 | 246.77 | 76777.0 |
| 2024-12-18 19:00:00 | AAPL | Stock | 246.89 | 247.19 | 246.6 | 247.19 | 43405.0 |
| 2024-12-18 04:00:00 | MSFT | Stock | 455.22 | 455.22 | 454.41 | 454.78 | 5447.0 |
| 2024-12-18 05:00:00 | MSFT | Stock | 454.83 | 455.09 | 454.68 | 454.8 | 5367.0 |
| 2024-12-18 06:00:00 | MSFT | Stock | 454.77 | 455.0 | 454.59 | 454.65 | 5395.0 |
| 2024-12-18 07:00:00 | MSFT | Stock | 454.65 | 454.7 | 452.66 | 452.68 | 21474.0 |
| 2024-12-18 08:00:00 | MSFT | Stock | 454.6991 | 455.23 | 451.98 | 451.98 | 36226.0 |
| 2024-12-18 09:00:00 | MSFT | Stock | 451.65 | 452.32 | 446.1599 | 448.24 | 2036357.0 |
| 2024-12-18 10:00:00 | MSFT | Stock | 448.2975 | 451.75 | 447.77 | 450.9732 | 1155268.0 |
| 2024-12-18 11:00:00 | MSFT | Stock | 451.005 | 452.62 | 450.82 | 452.14 | 883020.0 |
| 2024-12-18 12:00:00 | MSFT | Stock | 452.195 | 452.65 | 451.2889 | 452.1 | 605634.0 |
| 2024-12-18 13:00:00 | MSFT | Stock | 452.08 | 452.322 | 451.14 | 451.6 | 511865.0 |
| 2024-12-18 14:00:00 | MSFT | Stock | 451.61 | 451.65 | 445.8 | 445.94 | 1227839.0 |
| 2024-12-18 15:00:00 | MSFT | Stock | 446.05 | 446.41 | 437.02 | 437.26 | 3927691.0 |
| 2024-12-18 16:00:00 | MSFT | Stock | 437.35 | 439.2008 | 435.5 | 438.07 | 5786939.0 |
| 2024-12-18 17:00:00 | MSFT | Stock | 438.07 | 440.51 | 437.39 | 440.51 | 38929.0 |
| 2024-12-18 18:00:00 | MSFT | Stock | 440.5 | 442.0 | 439.47 | 440.5 | 49563.0 |
| 2024-12-18 19:00:00 | MSFT | Stock | 440.36 | 441.69 | 439.8 | 441.1 | 11817.0 |
| 2024-12-18 04:00:00 | NVDA | Stock | 132.07 | 135.0 | 131.42 | 134.75 | 1304598.0 |
| 2024-12-18 05:00:00 | NVDA | Stock | 134.75 | 135.0 | 133.82 | 134.17 | 786035.0 |
| 2024-12-18 06:00:00 | NVDA | Stock | 134.17 | 134.32 | 133.31 | 133.53 | 471119.0 |
| 2024-12-18 07:00:00 | NVDA | Stock | 133.51 | 134.53 | 133.105 | 134.36 | 1256717.0 |
| 2024-12-18 08:00:00 | NVDA | Stock | 134.36 | 134.8604 | 131.15 | 133.69 | 3002220.0 |
| 2024-12-18 09:00:00 | NVDA | Stock | 133.68 | 135.78 | 132.81 | 134.86 | 33351812.0 |
| 2024-12-18 10:00:00 | NVDA | Stock | 134.86 | 136.2 | 134.225 | 135.95 | 28560201.0 |
| 2024-12-18 11:00:00 | NVDA | Stock | 135.95 | 136.7 | 134.66 | 135.1599 | 22642427.0 |
| 2024-12-18 12:00:00 | NVDA | Stock | 135.155 | 135.86 | 134.82 | 135.72 | 11903556.0 |
| 2024-12-18 13:00:00 | NVDA | Stock | 135.72 | 136.42 | 135.5 | 135.64 | 12490646.0 |
| 2024-12-18 14:00:00 | NVDA | Stock | 135.645 | 135.69 | 132.38 | 132.7 | 28605923.0 |
| 2024-12-18 15:00:00 | NVDA | Stock | 132.71 | 132.9 | 128.28 | 128.98 | 45962044.0 |
| 2024-12-18 16:00:00 | NVDA | Stock | 128.76 | 130.22 | 126.5 | 129.771 | 31334410.0 |
| 2024-12-18 17:00:00 | NVDA | Stock | 129.78 | 131.43 | 128.91 | 130.6 | 2088301.0 |
| 2024-12-18 18:00:00 | NVDA | Stock | 130.6 | 130.75 | 129.655 | 130.41 | 932124.0 |
| 2024-12-18 19:00:00 | NVDA | Stock | 130.46 | 131.5094 | 130.35 | 131.5 | 840565.0 |
| 2024-12-18 04:00:00 | AMZN | Stock | 231.6 | 231.85 | 231.6 | 231.74 | 7564.0 |
| 2024-12-18 05:00:00 | AMZN | Stock | 231.73 | 232.06 | 231.59 | 231.85 | 9681.0 |
> showing 50 of 65,505 rows — these rows as CSV