PREVIEW / stock_1hour / 2025-08-14
file: by_date/stock_1hour/2025/2025-08-14.parquet size: 1.4 MB rows: 63,523 symbols: 333
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-08-14 04:00:00 | AAPL | Stock | 233.0 | 233.22 | 232.75 | 232.77 | 12795.0 |
| 2025-08-14 05:00:00 | AAPL | Stock | 232.72 | 232.75 | 232.58 | 232.7 | 6696.0 |
| 2025-08-14 06:00:00 | AAPL | Stock | 232.67 | 232.71 | 232.56 | 232.59 | 4299.0 |
| 2025-08-14 07:00:00 | AAPL | Stock | 232.75 | 234.99 | 232.75 | 234.27 | 58713.0 |
| 2025-08-14 08:00:00 | AAPL | Stock | 234.2 | 234.9 | 232.21 | 232.9452 | 287679.0 |
| 2025-08-14 09:00:00 | AAPL | Stock | 232.84 | 235.12 | 232.2 | 233.41 | 6734886.0 |
| 2025-08-14 10:00:00 | AAPL | Stock | 233.395 | 233.42 | 231.54 | 231.65 | 5660366.0 |
| 2025-08-14 11:00:00 | AAPL | Stock | 231.655 | 232.295 | 230.85 | 231.32 | 4767823.0 |
| 2025-08-14 12:00:00 | AAPL | Stock | 231.325 | 232.545 | 231.31 | 232.4906 | 2474382.0 |
| 2025-08-14 13:00:00 | AAPL | Stock | 232.495 | 233.14 | 232.4584 | 232.705 | 2476627.0 |
| 2025-08-14 14:00:00 | AAPL | Stock | 232.72 | 233.37 | 232.32 | 232.99 | 2591996.0 |
| 2025-08-14 15:00:00 | AAPL | Stock | 232.99 | 233.59 | 232.69 | 232.83 | 5072759.0 |
| 2025-08-14 16:00:00 | AAPL | Stock | 232.78 | 232.9077 | 232.43 | 232.78 | 7215861.0 |
| 2025-08-14 17:00:00 | AAPL | Stock | 232.7801 | 233.0 | 232.55 | 232.57 | 33296.0 |
| 2025-08-14 18:00:00 | AAPL | Stock | 232.6 | 232.7 | 232.3 | 232.5204 | 21638.0 |
| 2025-08-14 19:00:00 | AAPL | Stock | 232.63 | 232.77 | 232.23 | 232.3999 | 24007.0 |
| 2025-08-14 04:00:00 | MSFT | Stock | 522.0 | 522.2 | 521.85 | 522.09 | 3765.0 |
| 2025-08-14 05:00:00 | MSFT | Stock | 522.04 | 522.9 | 522.03 | 522.69 | 5786.0 |
| 2025-08-14 06:00:00 | MSFT | Stock | 522.6 | 522.7 | 522.41 | 522.55 | 4069.0 |
| 2025-08-14 07:00:00 | MSFT | Stock | 522.55 | 522.9 | 522.13 | 522.4 | 7382.0 |
| 2025-08-14 08:00:00 | MSFT | Stock | 522.29 | 522.73 | 520.38 | 521.59 | 72253.0 |
| 2025-08-14 09:00:00 | MSFT | Stock | 521.71 | 524.3698 | 520.15 | 523.24 | 1540071.0 |
| 2025-08-14 10:00:00 | MSFT | Stock | 523.28 | 525.9499 | 521.8202 | 524.26 | 1435110.0 |
| 2025-08-14 11:00:00 | MSFT | Stock | 524.26 | 524.8099 | 521.8 | 523.405 | 1055623.0 |
| 2025-08-14 12:00:00 | MSFT | Stock | 523.41 | 525.07 | 522.54 | 523.91 | 1042713.0 |
| 2025-08-14 13:00:00 | MSFT | Stock | 523.92 | 524.19 | 522.295 | 522.5 | 963456.0 |
| 2025-08-14 14:00:00 | MSFT | Stock | 522.5 | 522.87 | 520.14 | 520.98 | 1385863.0 |
| 2025-08-14 15:00:00 | MSFT | Stock | 520.975 | 523.25 | 520.52 | 522.56 | 2091471.0 |
| 2025-08-14 16:00:00 | MSFT | Stock | 522.29 | 524.96 | 521.63 | 522.48 | 2452175.0 |
| 2025-08-14 17:00:00 | MSFT | Stock | 523.4 | 523.7766 | 523.0 | 523.15 | 7557.0 |
| 2025-08-14 18:00:00 | MSFT | Stock | 523.12 | 523.5 | 523.1001 | 523.16 | 2747.0 |
| 2025-08-14 19:00:00 | MSFT | Stock | 523.7 | 523.87 | 523.26 | 523.26 | 5847.0 |
| 2025-08-14 04:00:00 | NVDA | Stock | 181.28 | 181.74 | 181.23 | 181.33 | 132429.0 |
| 2025-08-14 05:00:00 | NVDA | Stock | 181.32 | 181.5 | 181.27 | 181.4 | 57295.0 |
| 2025-08-14 06:00:00 | NVDA | Stock | 181.44 | 181.5 | 181.26 | 181.48 | 72177.0 |
| 2025-08-14 07:00:00 | NVDA | Stock | 181.47 | 182.07 | 181.3 | 181.97 | 278664.0 |
| 2025-08-14 08:00:00 | NVDA | Stock | 181.35 | 182.058 | 180.05 | 180.2 | 2214613.0 |
| 2025-08-14 09:00:00 | NVDA | Stock | 180.2 | 182.38 | 179.46 | 181.9573 | 21134666.0 |
| 2025-08-14 10:00:00 | NVDA | Stock | 181.9596 | 183.02 | 181.72 | 182.25 | 19635917.0 |
| 2025-08-14 11:00:00 | NVDA | Stock | 182.25 | 182.43 | 181.01 | 181.9444 | 13724762.0 |
| 2025-08-14 12:00:00 | NVDA | Stock | 181.95 | 182.05 | 180.96 | 182.005 | 11028443.0 |
| 2025-08-14 13:00:00 | NVDA | Stock | 182.01 | 182.2 | 181.59 | 182.0172 | 7546415.0 |
| 2025-08-14 14:00:00 | NVDA | Stock | 182.01 | 182.055 | 181.4217 | 181.96 | 7584524.0 |
| 2025-08-14 15:00:00 | NVDA | Stock | 181.965 | 182.24 | 181.695 | 182.0 | 12361301.0 |
| 2025-08-14 16:00:00 | NVDA | Stock | 181.96 | 182.02 | 181.52 | 181.68 | 8665619.0 |
| 2025-08-14 17:00:00 | NVDA | Stock | 181.68 | 181.71 | 181.55 | 181.64 | 115192.0 |
| 2025-08-14 18:00:00 | NVDA | Stock | 181.67 | 181.8 | 181.63 | 181.76 | 94304.0 |
| 2025-08-14 19:00:00 | NVDA | Stock | 181.7792 | 181.88 | 181.72 | 181.87 | 127866.0 |
| 2025-08-14 04:00:00 | AMZN | Stock | 224.54 | 224.54 | 224.39 | 224.48 | 5742.0 |
| 2025-08-14 05:00:00 | AMZN | Stock | 224.52 | 224.92 | 224.5 | 224.88 | 5430.0 |
> showing 50 of 63,523 rows — these rows as CSV