PREVIEW / stock_1hour / 2025-08-13
file: by_date/stock_1hour/2025/2025-08-13.parquet size: 1.5 MB rows: 64,269 symbols: 343
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-13 04:00:00 | AAPL | Stock | 229.6 | 230.09 | 229.5 | 229.92 | 12307.0 |
| 2025-08-13 05:00:00 | AAPL | Stock | 229.81 | 229.97 | 229.76 | 229.94 | 3413.0 |
| 2025-08-13 06:00:00 | AAPL | Stock | 229.87 | 230.06 | 229.85 | 230.06 | 9987.0 |
| 2025-08-13 07:00:00 | AAPL | Stock | 230.03 | 230.1 | 229.82 | 230.0 | 22542.0 |
| 2025-08-13 08:00:00 | AAPL | Stock | 229.94 | 230.9 | 228.0 | 230.8306 | 158834.0 |
| 2025-08-13 09:00:00 | AAPL | Stock | 230.83 | 232.19 | 230.43 | 231.7775 | 6207954.0 |
| 2025-08-13 10:00:00 | AAPL | Stock | 231.75 | 234.55 | 231.16 | 233.6 | 10055921.0 |
| 2025-08-13 11:00:00 | AAPL | Stock | 233.53 | 233.915 | 231.68 | 232.665 | 5804032.0 |
| 2025-08-13 12:00:00 | AAPL | Stock | 232.68 | 233.4 | 232.07 | 232.1068 | 3379801.0 |
| 2025-08-13 13:00:00 | AAPL | Stock | 232.12 | 233.19 | 231.56 | 233.11 | 3049194.0 |
| 2025-08-13 14:00:00 | AAPL | Stock | 233.1001 | 235.0 | 230.8 | 233.12 | 8760619.0 |
| 2025-08-13 15:00:00 | AAPL | Stock | 233.12 | 234.33 | 233.06 | 233.32 | 6854474.0 |
| 2025-08-13 16:00:00 | AAPL | Stock | 233.33 | 233.85 | 233.18 | 233.44 | 6576966.0 |
| 2025-08-13 17:00:00 | AAPL | Stock | 233.43 | 233.57 | 233.33 | 233.34 | 24612.0 |
| 2025-08-13 18:00:00 | AAPL | Stock | 233.35 | 233.35 | 233.1 | 233.18 | 18691.0 |
| 2025-08-13 19:00:00 | AAPL | Stock | 233.21 | 233.25 | 233.1 | 233.1 | 16566.0 |
| 2025-08-13 04:00:00 | MSFT | Stock | 531.72 | 531.72 | 529.7 | 529.7 | 6109.0 |
| 2025-08-13 05:00:00 | MSFT | Stock | 529.61 | 530.5 | 529.0 | 530.5 | 1984.0 |
| 2025-08-13 06:00:00 | MSFT | Stock | 530.66 | 530.73 | 530.19 | 530.19 | 3093.0 |
| 2025-08-13 07:00:00 | MSFT | Stock | 530.0 | 530.0 | 529.48 | 529.68 | 7320.0 |
| 2025-08-13 08:00:00 | MSFT | Stock | 530.0 | 531.0 | 528.83 | 530.6 | 38012.0 |
| 2025-08-13 09:00:00 | MSFT | Stock | 530.5001 | 532.83 | 528.88 | 530.24 | 1301388.0 |
| 2025-08-13 10:00:00 | MSFT | Stock | 530.215 | 531.84 | 529.51 | 530.36 | 1192933.0 |
| 2025-08-13 11:00:00 | MSFT | Stock | 530.335 | 530.3392 | 526.86 | 527.94 | 1068136.0 |
| 2025-08-13 12:00:00 | MSFT | Stock | 527.93 | 528.6 | 524.96 | 525.195 | 868952.0 |
| 2025-08-13 13:00:00 | MSFT | Stock | 525.18 | 525.87 | 523.65 | 523.87 | 1049435.0 |
| 2025-08-13 14:00:00 | MSFT | Stock | 523.85 | 524.5999 | 522.35 | 522.69 | 1052758.0 |
| 2025-08-13 15:00:00 | MSFT | Stock | 522.6376 | 523.07 | 519.37 | 520.58 | 3749883.0 |
| 2025-08-13 16:00:00 | MSFT | Stock | 520.668 | 521.39 | 519.87 | 521.2303 | 2853521.0 |
| 2025-08-13 17:00:00 | MSFT | Stock | 521.32 | 521.83 | 521.23 | 521.5962 | 9402.0 |
| 2025-08-13 18:00:00 | MSFT | Stock | 521.243 | 521.9 | 521.2 | 521.7983 | 8153.0 |
| 2025-08-13 19:00:00 | MSFT | Stock | 521.86 | 522.0 | 521.8 | 521.946 | 7420.0 |
| 2025-08-13 04:00:00 | NVDA | Stock | 183.15 | 183.57 | 182.93 | 183.36 | 229066.0 |
| 2025-08-13 05:00:00 | NVDA | Stock | 183.37 | 183.37 | 182.53 | 182.94 | 278791.0 |
| 2025-08-13 06:00:00 | NVDA | Stock | 182.97 | 182.97 | 181.75 | 181.97 | 530620.0 |
| 2025-08-13 07:00:00 | NVDA | Stock | 182.0 | 183.2 | 181.98 | 182.95 | 500623.0 |
| 2025-08-13 08:00:00 | NVDA | Stock | 182.51 | 183.57 | 181.795 | 182.89 | 1641108.0 |
| 2025-08-13 09:00:00 | NVDA | Stock | 182.9 | 183.97 | 182.175 | 182.62 | 22083009.0 |
| 2025-08-13 10:00:00 | NVDA | Stock | 182.625 | 182.71 | 180.885 | 181.54 | 28339681.0 |
| 2025-08-13 11:00:00 | NVDA | Stock | 181.535 | 181.64 | 179.35 | 180.4335 | 22883161.0 |
| 2025-08-13 12:00:00 | NVDA | Stock | 180.435 | 180.76 | 179.4 | 179.8042 | 13548681.0 |
| 2025-08-13 13:00:00 | NVDA | Stock | 179.8 | 181.34 | 179.775 | 181.29 | 12309657.0 |
| 2025-08-13 14:00:00 | NVDA | Stock | 181.295 | 181.92 | 181.061 | 181.8605 | 9854454.0 |
| 2025-08-13 15:00:00 | NVDA | Stock | 181.865 | 181.92 | 180.63 | 181.57 | 16307369.0 |
| 2025-08-13 16:00:00 | NVDA | Stock | 181.55 | 181.89 | 180.8 | 181.33 | 10336635.0 |
| 2025-08-13 17:00:00 | NVDA | Stock | 181.31 | 181.5 | 181.18 | 181.33 | 209315.0 |
| 2025-08-13 18:00:00 | NVDA | Stock | 181.3152 | 181.33 | 181.11 | 181.29 | 203468.0 |
| 2025-08-13 19:00:00 | NVDA | Stock | 181.29 | 181.36 | 181.11 | 181.28 | 201076.0 |
| 2025-08-13 04:00:00 | AMZN | Stock | 221.65 | 222.2 | 221.65 | 221.93 | 18642.0 |
| 2025-08-13 05:00:00 | AMZN | Stock | 221.93 | 222.0 | 221.7 | 221.93 | 6333.0 |
> showing 50 of 64,269 rows — these rows as CSV