PREVIEW / stock_1hour / 2025-06-27
file: by_date/stock_1hour/2025/2025-06-27.parquet size: 1.4 MB rows: 62,408 symbols: 392
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 |
|---|---|---|---|---|---|---|---|
| 2025-06-27 04:00:00 | AAPL | Stock | 201.88 | 202.09 | 201.66 | 202.05 | 21813.0 |
| 2025-06-27 05:00:00 | AAPL | Stock | 202.0 | 202.03 | 201.75 | 201.99 | 6398.0 |
| 2025-06-27 06:00:00 | AAPL | Stock | 201.91 | 201.97 | 201.7 | 201.7 | 5440.0 |
| 2025-06-27 07:00:00 | AAPL | Stock | 201.67 | 202.01 | 201.58 | 201.98 | 61376.0 |
| 2025-06-27 08:00:00 | AAPL | Stock | 201.84 | 202.09 | 201.18 | 201.77 | 210547.0 |
| 2025-06-27 09:00:00 | AAPL | Stock | 201.71 | 203.22 | 201.25 | 202.7974 | 5445197.0 |
| 2025-06-27 10:00:00 | AAPL | Stock | 202.85 | 202.99 | 200.85 | 201.1987 | 6269074.0 |
| 2025-06-27 11:00:00 | AAPL | Stock | 201.2 | 202.05 | 200.955 | 201.88 | 3445520.0 |
| 2025-06-27 12:00:00 | AAPL | Stock | 201.88 | 202.63 | 201.57 | 202.6 | 3163626.0 |
| 2025-06-27 13:00:00 | AAPL | Stock | 202.58 | 202.7 | 200.93 | 201.3736 | 3990181.0 |
| 2025-06-27 14:00:00 | AAPL | Stock | 201.38 | 201.6568 | 200.79 | 200.905 | 3708126.0 |
| 2025-06-27 15:00:00 | AAPL | Stock | 200.91 | 201.44 | 200.0 | 201.1 | 6859784.0 |
| 2025-06-27 16:00:00 | AAPL | Stock | 201.06 | 201.35 | 200.8998 | 201.27 | 19168351.0 |
| 2025-06-27 17:00:00 | AAPL | Stock | 201.22 | 201.31 | 201.1 | 201.14 | 32096.0 |
| 2025-06-27 18:00:00 | AAPL | Stock | 201.15 | 201.25 | 201.15 | 201.15 | 35548.0 |
| 2025-06-27 19:00:00 | AAPL | Stock | 201.1501 | 201.2297 | 201.15 | 201.1869 | 19707.0 |
| 2025-06-27 04:00:00 | MSFT | Stock | 498.04 | 498.04 | 497.18 | 497.57 | 4718.0 |
| 2025-06-27 05:00:00 | MSFT | Stock | 497.4 | 497.4 | 496.99 | 497.21 | 1749.0 |
| 2025-06-27 06:00:00 | MSFT | Stock | 497.3 | 497.3 | 497.3 | 497.3 | 222.0 |
| 2025-06-27 07:00:00 | MSFT | Stock | 497.02 | 497.94 | 497.02 | 497.89 | 3638.0 |
| 2025-06-27 08:00:00 | MSFT | Stock | 497.6 | 498.53 | 496.207 | 497.21 | 29250.0 |
| 2025-06-27 09:00:00 | MSFT | Stock | 497.0 | 499.0 | 494.0 | 496.98 | 1828797.0 |
| 2025-06-27 10:00:00 | MSFT | Stock | 497.055 | 498.08 | 496.588 | 496.86 | 1276617.0 |
| 2025-06-27 11:00:00 | MSFT | Stock | 496.83 | 499.3 | 496.31 | 499.08 | 968014.0 |
| 2025-06-27 12:00:00 | MSFT | Stock | 499.05 | 499.24 | 497.74 | 497.987 | 1168569.0 |
| 2025-06-27 13:00:00 | MSFT | Stock | 497.9999 | 498.17 | 496.65 | 497.22 | 961272.0 |
| 2025-06-27 14:00:00 | MSFT | Stock | 497.19 | 497.19 | 494.4642 | 494.89 | 1218964.0 |
| 2025-06-27 15:00:00 | MSFT | Stock | 494.93 | 496.72 | 493.03 | 495.88 | 2410609.0 |
| 2025-06-27 16:00:00 | MSFT | Stock | 495.87 | 497.0 | 495.5 | 496.4 | 9642396.0 |
| 2025-06-27 17:00:00 | MSFT | Stock | 495.94 | 497.0 | 495.77 | 496.3 | 6354.0 |
| 2025-06-27 18:00:00 | MSFT | Stock | 496.0 | 496.2199 | 495.67 | 495.67 | 1092.0 |
| 2025-06-27 19:00:00 | MSFT | Stock | 495.844 | 495.85 | 495.65 | 495.8235 | 1831.0 |
| 2025-06-27 04:00:00 | NVDA | Stock | 155.69 | 155.94 | 155.4 | 155.94 | 258739.0 |
| 2025-06-27 05:00:00 | NVDA | Stock | 155.92 | 155.93 | 155.74 | 155.85 | 128068.0 |
| 2025-06-27 06:00:00 | NVDA | Stock | 155.88 | 155.9 | 155.66 | 155.84 | 125009.0 |
| 2025-06-27 07:00:00 | NVDA | Stock | 155.81 | 156.49 | 155.78 | 156.39 | 497513.0 |
| 2025-06-27 08:00:00 | NVDA | Stock | 155.79 | 156.49 | 155.32 | 155.87 | 1857800.0 |
| 2025-06-27 09:00:00 | NVDA | Stock | 155.86 | 157.0 | 155.255 | 156.1332 | 22996943.0 |
| 2025-06-27 10:00:00 | NVDA | Stock | 156.14 | 157.67 | 156.05 | 157.16 | 30342221.0 |
| 2025-06-27 11:00:00 | NVDA | Stock | 157.17 | 158.71 | 156.78 | 158.2148 | 24230673.0 |
| 2025-06-27 12:00:00 | NVDA | Stock | 158.21 | 158.3499 | 156.96 | 157.365 | 17531602.0 |
| 2025-06-27 13:00:00 | NVDA | Stock | 157.36 | 157.8 | 156.5 | 157.03 | 14961636.0 |
| 2025-06-27 14:00:00 | NVDA | Stock | 157.04 | 157.35 | 155.45 | 155.62 | 19264277.0 |
| 2025-06-27 15:00:00 | NVDA | Stock | 155.615 | 158.2 | 155.535 | 157.74 | 27672186.0 |
| 2025-06-27 16:00:00 | NVDA | Stock | 157.74 | 157.7513 | 156.27 | 157.51 | 36079946.0 |
| 2025-06-27 17:00:00 | NVDA | Stock | 157.48 | 157.64 | 157.2505 | 157.38 | 479178.0 |
| 2025-06-27 18:00:00 | NVDA | Stock | 157.38 | 157.7 | 157.37 | 157.56 | 298627.0 |
| 2025-06-27 19:00:00 | NVDA | Stock | 157.58 | 157.64 | 157.49 | 157.59 | 252315.0 |
| 2025-06-27 04:00:00 | AMZN | Stock | 218.93 | 219.4 | 218.55 | 219.39 | 29395.0 |
| 2025-06-27 05:00:00 | AMZN | Stock | 219.35 | 219.38 | 218.83 | 219.05 | 22902.0 |
> showing 50 of 62,408 rows — these rows as CSV