PREVIEW / stock_1hour / 2024-12-11
file: by_date/stock_1hour/2024/2024-12-11.parquet size: 1.4 MB rows: 63,613 symbols: 684
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-11 04:00:00 | AAPL | Stock | 247.72 | 247.8 | 247.13 | 247.53 | 10121.0 |
| 2024-12-11 05:00:00 | AAPL | Stock | 247.54 | 247.59 | 247.42 | 247.48 | 9047.0 |
| 2024-12-11 06:00:00 | AAPL | Stock | 247.49 | 247.49 | 247.45 | 247.45 | 5345.0 |
| 2024-12-11 07:00:00 | AAPL | Stock | 247.49 | 247.65 | 247.47 | 247.47 | 12894.0 |
| 2024-12-11 08:00:00 | AAPL | Stock | 247.4892 | 248.56 | 247.12 | 248.06 | 133440.0 |
| 2024-12-11 09:00:00 | AAPL | Stock | 248.0 | 249.8 | 247.55 | 249.305 | 4595175.0 |
| 2024-12-11 10:00:00 | AAPL | Stock | 249.305 | 250.2 | 249.13 | 250.1405 | 4525850.0 |
| 2024-12-11 11:00:00 | AAPL | Stock | 250.15 | 250.8 | 249.34 | 249.51 | 3413041.0 |
| 2024-12-11 12:00:00 | AAPL | Stock | 249.52 | 249.84 | 249.09 | 249.22 | 1651840.0 |
| 2024-12-11 13:00:00 | AAPL | Stock | 249.225 | 249.48 | 248.35 | 248.3711 | 1999078.0 |
| 2024-12-11 14:00:00 | AAPL | Stock | 248.375 | 248.5799 | 247.58 | 247.815 | 2269440.0 |
| 2024-12-11 15:00:00 | AAPL | Stock | 247.815 | 247.9199 | 246.2601 | 246.43 | 5880145.0 |
| 2024-12-11 16:00:00 | AAPL | Stock | 246.41 | 247.12 | 246.02 | 246.49 | 7103358.0 |
| 2024-12-11 17:00:00 | AAPL | Stock | 246.66 | 246.88 | 246.49 | 246.79 | 529590.0 |
| 2024-12-11 18:00:00 | AAPL | Stock | 246.79 | 246.82 | 246.31 | 246.42 | 22858.0 |
| 2024-12-11 19:00:00 | AAPL | Stock | 246.5648 | 246.5648 | 246.36 | 246.41 | 23728.0 |
| 2024-12-11 04:00:00 | MSFT | Stock | 442.79 | 443.48 | 441.53 | 442.0 | 9103.0 |
| 2024-12-11 05:00:00 | MSFT | Stock | 441.72 | 442.2 | 441.24 | 441.34 | 4229.0 |
| 2024-12-11 06:00:00 | MSFT | Stock | 441.46 | 442.1 | 441.45 | 441.87 | 4190.0 |
| 2024-12-11 07:00:00 | MSFT | Stock | 441.88 | 443.38 | 441.88 | 443.05 | 11239.0 |
| 2024-12-11 08:00:00 | MSFT | Stock | 442.5 | 445.24 | 441.65 | 444.3001 | 37574.0 |
| 2024-12-11 09:00:00 | MSFT | Stock | 444.18 | 446.44 | 443.34 | 446.15 | 1161576.0 |
| 2024-12-11 10:00:00 | MSFT | Stock | 446.08 | 449.39 | 445.45 | 448.44 | 1513707.0 |
| 2024-12-11 11:00:00 | MSFT | Stock | 448.49 | 450.35 | 448.4 | 449.24 | 1426109.0 |
| 2024-12-11 12:00:00 | MSFT | Stock | 449.2781 | 450.0 | 448.96 | 449.4167 | 547574.0 |
| 2024-12-11 13:00:00 | MSFT | Stock | 449.44 | 449.93 | 448.67 | 449.33 | 432865.0 |
| 2024-12-11 14:00:00 | MSFT | Stock | 449.26 | 449.56 | 447.8501 | 448.44 | 520536.0 |
| 2024-12-11 15:00:00 | MSFT | Stock | 448.42 | 449.72 | 448.4078 | 449.0 | 1221262.0 |
| 2024-12-11 16:00:00 | MSFT | Stock | 448.99 | 449.25 | 447.7 | 448.85 | 4072689.0 |
| 2024-12-11 17:00:00 | MSFT | Stock | 448.99 | 449.0 | 448.6 | 448.7769 | 2518.0 |
| 2024-12-11 18:00:00 | MSFT | Stock | 448.7 | 448.98 | 448.51 | 448.51 | 6019.0 |
| 2024-12-11 19:00:00 | MSFT | Stock | 448.79 | 448.79 | 448.12 | 448.4 | 6254.0 |
| 2024-12-11 04:00:00 | NVDA | Stock | 136.5 | 136.73 | 135.67 | 136.59 | 294650.0 |
| 2024-12-11 05:00:00 | NVDA | Stock | 136.59 | 136.68 | 136.22 | 136.57 | 147486.0 |
| 2024-12-11 06:00:00 | NVDA | Stock | 136.59 | 136.89 | 136.58 | 136.61 | 171439.0 |
| 2024-12-11 07:00:00 | NVDA | Stock | 136.59 | 136.61 | 136.18 | 136.24 | 356051.0 |
| 2024-12-11 08:00:00 | NVDA | Stock | 136.36 | 137.59 | 135.2 | 137.4807 | 2703282.0 |
| 2024-12-11 09:00:00 | NVDA | Stock | 137.48 | 138.05 | 135.21 | 137.7391 | 25659068.0 |
| 2024-12-11 10:00:00 | NVDA | Stock | 137.73 | 137.815 | 135.43 | 135.915 | 22313155.0 |
| 2024-12-11 11:00:00 | NVDA | Stock | 135.91 | 138.34 | 135.8701 | 138.34 | 19025273.0 |
| 2024-12-11 12:00:00 | NVDA | Stock | 138.33 | 139.05 | 138.06 | 138.8686 | 16191657.0 |
| 2024-12-11 13:00:00 | NVDA | Stock | 138.8662 | 139.77 | 138.63 | 139.7416 | 13567278.0 |
| 2024-12-11 14:00:00 | NVDA | Stock | 139.75 | 140.13 | 139.28 | 139.78 | 14057875.0 |
| 2024-12-11 15:00:00 | NVDA | Stock | 139.78 | 140.17 | 138.94 | 139.26 | 19417614.0 |
| 2024-12-11 16:00:00 | NVDA | Stock | 139.31 | 139.31 | 138.8 | 138.97 | 19270474.0 |
| 2024-12-11 17:00:00 | NVDA | Stock | 138.97 | 139.15 | 138.95 | 139.04 | 204983.0 |
| 2024-12-11 18:00:00 | NVDA | Stock | 139.07 | 139.16 | 138.95 | 138.98 | 243297.0 |
| 2024-12-11 19:00:00 | NVDA | Stock | 138.96 | 139.04 | 138.88 | 138.99 | 272098.0 |
| 2024-12-11 04:00:00 | AMZN | Stock | 226.0 | 226.18 | 225.42 | 225.42 | 19329.0 |
| 2024-12-11 05:00:00 | AMZN | Stock | 225.49 | 225.53 | 225.36 | 225.36 | 5495.0 |
> showing 50 of 63,613 rows — these rows as CSV