PREVIEW / stock_1hour / 2025-10-29
file: by_date/stock_1hour/2025/2025-10-29.parquet size: 1.5 MB rows: 65,365 symbols: 222
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-10-29 04:00:00 | AAPL | Stock | 269.4 | 269.7 | 268.38 | 268.65 | 23100.0 |
| 2025-10-29 05:00:00 | AAPL | Stock | 268.55 | 270.0 | 268.12 | 269.84 | 114805.0 |
| 2025-10-29 06:00:00 | AAPL | Stock | 269.84 | 270.34 | 269.51 | 269.58 | 39406.0 |
| 2025-10-29 07:00:00 | AAPL | Stock | 269.64 | 269.88 | 269.27 | 269.64 | 56317.0 |
| 2025-10-29 08:00:00 | AAPL | Stock | 269.55 | 270.34 | 268.12 | 269.2 | 166564.0 |
| 2025-10-29 09:00:00 | AAPL | Stock | 269.2893 | 271.3 | 268.61 | 270.91 | 4878547.0 |
| 2025-10-29 10:00:00 | AAPL | Stock | 270.94 | 271.41 | 268.615 | 268.85 | 4394037.0 |
| 2025-10-29 11:00:00 | AAPL | Stock | 268.84 | 269.21 | 267.11 | 267.77 | 3816740.0 |
| 2025-10-29 12:00:00 | AAPL | Stock | 267.78 | 269.11 | 267.7 | 268.87 | 1908701.0 |
| 2025-10-29 13:00:00 | AAPL | Stock | 268.88 | 270.66 | 268.8683 | 270.445 | 3628755.0 |
| 2025-10-29 14:00:00 | AAPL | Stock | 270.47 | 270.93 | 268.6 | 269.51 | 4074324.0 |
| 2025-10-29 15:00:00 | AAPL | Stock | 269.5299 | 270.38 | 267.8 | 269.71 | 4607061.0 |
| 2025-10-29 16:00:00 | AAPL | Stock | 269.83 | 270.2 | 269.0 | 270.0693 | 5190122.0 |
| 2025-10-29 17:00:00 | AAPL | Stock | 269.97 | 270.25 | 269.9 | 270.06 | 68553.0 |
| 2025-10-29 18:00:00 | AAPL | Stock | 270.24 | 270.5 | 270.0 | 270.23 | 45799.0 |
| 2025-10-29 19:00:00 | AAPL | Stock | 270.26 | 270.91 | 270.15 | 270.91 | 49097.0 |
| 2025-10-29 04:00:00 | MSFT | Stock | 544.65 | 546.49 | 543.61 | 543.92 | 14773.0 |
| 2025-10-29 05:00:00 | MSFT | Stock | 543.55 | 543.97 | 542.89 | 543.18 | 15310.0 |
| 2025-10-29 06:00:00 | MSFT | Stock | 543.3 | 544.1 | 543.11 | 543.4 | 12396.0 |
| 2025-10-29 07:00:00 | MSFT | Stock | 543.97 | 545.3 | 543.45 | 544.5 | 27991.0 |
| 2025-10-29 08:00:00 | MSFT | Stock | 544.6 | 546.2 | 543.1 | 544.94 | 124673.0 |
| 2025-10-29 09:00:00 | MSFT | Stock | 544.81 | 546.9 | 538.23 | 538.74 | 2499243.0 |
| 2025-10-29 10:00:00 | MSFT | Stock | 538.74 | 539.11 | 537.1701 | 537.92 | 1697312.0 |
| 2025-10-29 11:00:00 | MSFT | Stock | 537.935 | 539.57 | 536.7287 | 538.655 | 1753107.0 |
| 2025-10-29 12:00:00 | MSFT | Stock | 538.64 | 539.42 | 538.11 | 538.83 | 1099843.0 |
| 2025-10-29 13:00:00 | MSFT | Stock | 538.8 | 539.5799 | 537.9 | 538.92 | 1206035.0 |
| 2025-10-29 14:00:00 | MSFT | Stock | 538.92 | 540.55 | 536.91 | 538.815 | 1836542.0 |
| 2025-10-29 15:00:00 | MSFT | Stock | 538.89 | 543.15 | 538.13 | 542.56 | 3014830.0 |
| 2025-10-29 16:00:00 | MSFT | Stock | 541.55 | 546.97 | 513.5 | 525.88 | 5823177.0 |
| 2025-10-29 17:00:00 | MSFT | Stock | 525.34 | 538.85 | 514.5 | 516.67 | 1047641.0 |
| 2025-10-29 18:00:00 | MSFT | Stock | 516.76 | 525.0 | 515.24 | 522.6988 | 584199.0 |
| 2025-10-29 19:00:00 | MSFT | Stock | 522.52 | 523.42 | 519.1432 | 519.99 | 225018.0 |
| 2025-10-29 04:00:00 | NVDA | Stock | 206.02 | 208.05 | 205.3 | 207.36 | 1683550.0 |
| 2025-10-29 05:00:00 | NVDA | Stock | 207.35 | 207.95 | 207.06 | 207.25 | 810208.0 |
| 2025-10-29 06:00:00 | NVDA | Stock | 207.31 | 208.88 | 207.2 | 207.72 | 1140804.0 |
| 2025-10-29 07:00:00 | NVDA | Stock | 207.72 | 209.37 | 207.41 | 208.04 | 1727401.0 |
| 2025-10-29 08:00:00 | NVDA | Stock | 207.73 | 209.37 | 205.2 | 208.1 | 5727104.0 |
| 2025-10-29 09:00:00 | NVDA | Stock | 208.1 | 212.01 | 207.09 | 211.975 | 55539045.0 |
| 2025-10-29 10:00:00 | NVDA | Stock | 211.975 | 212.1899 | 208.57 | 208.9 | 41143920.0 |
| 2025-10-29 11:00:00 | NVDA | Stock | 208.895 | 209.18 | 206.36 | 207.49 | 26837863.0 |
| 2025-10-29 12:00:00 | NVDA | Stock | 207.49 | 207.5 | 205.03 | 206.927 | 23695626.0 |
| 2025-10-29 13:00:00 | NVDA | Stock | 206.93 | 208.025 | 206.23 | 207.36 | 15848369.0 |
| 2025-10-29 14:00:00 | NVDA | Stock | 207.355 | 207.65 | 204.775 | 206.59 | 24716636.0 |
| 2025-10-29 15:00:00 | NVDA | Stock | 206.595 | 208.05 | 205.4 | 207.05 | 23945595.0 |
| 2025-10-29 16:00:00 | NVDA | Stock | 207.03 | 208.5 | 206.33 | 207.7394 | 14913675.0 |
| 2025-10-29 17:00:00 | NVDA | Stock | 207.62 | 207.75 | 204.58 | 204.9782 | 1323137.0 |
| 2025-10-29 18:00:00 | NVDA | Stock | 204.99 | 207.5 | 204.99 | 207.47 | 855172.0 |
| 2025-10-29 19:00:00 | NVDA | Stock | 207.47 | 207.98 | 207.12 | 207.65 | 631127.0 |
| 2025-10-29 04:00:00 | AMZN | Stock | 230.22 | 230.61 | 229.32 | 229.44 | 33681.0 |
| 2025-10-29 05:00:00 | AMZN | Stock | 229.41 | 229.5 | 228.74 | 229.1 | 22995.0 |
> showing 50 of 65,365 rows — these rows as CSV