PREVIEW / stock_1hour / 2025-01-13
file: by_date/stock_1hour/2025/2025-01-13.parquet size: 1.5 MB rows: 65,835 symbols: 591
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-01-13 04:00:00 | AAPL | Stock | 235.0 | 235.0 | 233.77 | 234.2 | 43724.0 |
| 2025-01-13 05:00:00 | AAPL | Stock | 234.23 | 234.94 | 233.76 | 234.1 | 40743.0 |
| 2025-01-13 06:00:00 | AAPL | Stock | 234.21 | 234.76 | 234.0 | 234.35 | 14447.0 |
| 2025-01-13 07:00:00 | AAPL | Stock | 234.25 | 234.97 | 233.33 | 234.55 | 83591.0 |
| 2025-01-13 08:00:00 | AAPL | Stock | 234.22 | 235.98 | 233.3302 | 234.19 | 128614.0 |
| 2025-01-13 09:00:00 | AAPL | Stock | 234.33 | 234.33 | 230.2 | 230.32 | 7196600.0 |
| 2025-01-13 10:00:00 | AAPL | Stock | 230.325 | 231.8 | 229.72 | 231.115 | 5622568.0 |
| 2025-01-13 11:00:00 | AAPL | Stock | 231.14 | 231.72 | 230.37 | 230.6495 | 2969508.0 |
| 2025-01-13 12:00:00 | AAPL | Stock | 230.67 | 233.235 | 230.4 | 233.1501 | 2736055.0 |
| 2025-01-13 13:00:00 | AAPL | Stock | 233.15 | 233.9 | 232.84 | 233.88 | 2165233.0 |
| 2025-01-13 14:00:00 | AAPL | Stock | 233.86 | 234.2 | 233.27 | 233.93 | 1907902.0 |
| 2025-01-13 15:00:00 | AAPL | Stock | 233.93 | 234.67 | 233.43 | 234.4 | 4865040.0 |
| 2025-01-13 16:00:00 | AAPL | Stock | 234.4 | 235.0 | 234.23 | 234.56 | 7761158.0 |
| 2025-01-13 17:00:00 | AAPL | Stock | 234.56 | 234.89 | 234.54 | 234.8583 | 18086.0 |
| 2025-01-13 18:00:00 | AAPL | Stock | 234.86 | 235.47 | 234.86 | 235.43 | 30908.0 |
| 2025-01-13 19:00:00 | AAPL | Stock | 235.33 | 235.56 | 235.22 | 235.45 | 17221.0 |
| 2025-01-13 04:00:00 | MSFT | Stock | 417.0 | 417.0 | 413.6 | 414.54 | 13723.0 |
| 2025-01-13 05:00:00 | MSFT | Stock | 414.43 | 415.9 | 414.43 | 415.42 | 7429.0 |
| 2025-01-13 06:00:00 | MSFT | Stock | 415.3 | 415.69 | 415.25 | 415.33 | 5528.0 |
| 2025-01-13 07:00:00 | MSFT | Stock | 415.99 | 417.39 | 415.6 | 417.36 | 13922.0 |
| 2025-01-13 08:00:00 | MSFT | Stock | 415.75 | 417.54 | 414.0535 | 416.29 | 35590.0 |
| 2025-01-13 09:00:00 | MSFT | Stock | 416.39 | 418.5 | 414.0307 | 415.0195 | 1431440.0 |
| 2025-01-13 10:00:00 | MSFT | Stock | 415.025 | 416.2 | 413.83 | 414.66 | 1134495.0 |
| 2025-01-13 11:00:00 | MSFT | Stock | 414.65 | 415.0072 | 412.29 | 412.7687 | 1073180.0 |
| 2025-01-13 12:00:00 | MSFT | Stock | 412.8 | 415.63 | 412.5658 | 415.5 | 804789.0 |
| 2025-01-13 13:00:00 | MSFT | Stock | 415.4687 | 415.7 | 414.07 | 414.98 | 638516.0 |
| 2025-01-13 14:00:00 | MSFT | Stock | 414.9 | 417.05 | 414.6 | 416.81 | 787345.0 |
| 2025-01-13 15:00:00 | MSFT | Stock | 416.815 | 417.63 | 415.96 | 417.23 | 1313776.0 |
| 2025-01-13 16:00:00 | MSFT | Stock | 417.16 | 418.0 | 417.16 | 417.3369 | 4152279.0 |
| 2025-01-13 17:00:00 | MSFT | Stock | 417.6 | 418.25 | 417.6 | 417.95 | 2141.0 |
| 2025-01-13 18:00:00 | MSFT | Stock | 418.07 | 418.71 | 417.75 | 418.1483 | 7553.0 |
| 2025-01-13 19:00:00 | MSFT | Stock | 418.5 | 418.7 | 417.72 | 418.7 | 7820.0 |
| 2025-01-13 04:00:00 | NVDA | Stock | 133.2 | 134.31 | 131.67 | 131.95 | 1304492.0 |
| 2025-01-13 05:00:00 | NVDA | Stock | 131.99 | 132.13 | 131.45 | 131.7 | 928231.0 |
| 2025-01-13 06:00:00 | NVDA | Stock | 131.67 | 131.96 | 131.36 | 131.7 | 870093.0 |
| 2025-01-13 07:00:00 | NVDA | Stock | 131.7 | 132.45 | 131.0 | 132.04 | 1799175.0 |
| 2025-01-13 08:00:00 | NVDA | Stock | 132.05 | 134.4 | 131.01 | 131.45 | 3415955.0 |
| 2025-01-13 09:00:00 | NVDA | Stock | 131.45 | 132.61 | 129.11 | 132.16 | 40865452.0 |
| 2025-01-13 10:00:00 | NVDA | Stock | 132.16 | 133.11 | 130.62 | 131.875 | 29361019.0 |
| 2025-01-13 11:00:00 | NVDA | Stock | 131.88 | 132.64 | 131.27 | 131.6001 | 17633449.0 |
| 2025-01-13 12:00:00 | NVDA | Stock | 131.6099 | 132.84 | 131.14 | 132.5016 | 14032843.0 |
| 2025-01-13 13:00:00 | NVDA | Stock | 132.51 | 132.91 | 132.01 | 132.1312 | 10559629.0 |
| 2025-01-13 14:00:00 | NVDA | Stock | 132.14 | 132.53 | 131.57 | 132.4612 | 12252852.0 |
| 2025-01-13 15:00:00 | NVDA | Stock | 132.46 | 133.49 | 132.09 | 133.24 | 17873513.0 |
| 2025-01-13 16:00:00 | NVDA | Stock | 133.23 | 134.4 | 133.0 | 134.13 | 18151936.0 |
| 2025-01-13 17:00:00 | NVDA | Stock | 134.13 | 134.58 | 134.0717 | 134.57 | 417211.0 |
| 2025-01-13 18:00:00 | NVDA | Stock | 134.57 | 135.59 | 134.57 | 135.19 | 970543.0 |
| 2025-01-13 19:00:00 | NVDA | Stock | 135.15 | 135.19 | 134.46 | 134.93 | 670602.0 |
| 2025-01-13 04:00:00 | AMZN | Stock | 217.73 | 218.3 | 215.55 | 215.68 | 32145.0 |
| 2025-01-13 05:00:00 | AMZN | Stock | 215.76 | 216.45 | 215.72 | 216.19 | 5098.0 |
> showing 50 of 65,835 rows — these rows as CSV