PREVIEW / stock_1hour / 2025-10-30
file: by_date/stock_1hour/2025/2025-10-30.parquet size: 1.5 MB rows: 64,837 symbols: 223
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-30 04:00:00 | AAPL | Stock | 271.05 | 272.39 | 270.0 | 271.63 | 30863.0 |
| 2025-10-30 05:00:00 | AAPL | Stock | 271.69 | 271.81 | 271.2 | 271.45 | 9732.0 |
| 2025-10-30 06:00:00 | AAPL | Stock | 271.39 | 271.89 | 271.17 | 271.86 | 24611.0 |
| 2025-10-30 07:00:00 | AAPL | Stock | 271.75 | 272.44 | 271.3 | 272.15 | 63624.0 |
| 2025-10-30 08:00:00 | AAPL | Stock | 271.52 | 273.0 | 270.3 | 271.0325 | 373228.0 |
| 2025-10-30 09:00:00 | AAPL | Stock | 271.19 | 274.14 | 270.61 | 271.06 | 5566501.0 |
| 2025-10-30 10:00:00 | AAPL | Stock | 271.1094 | 271.3799 | 268.48 | 268.9 | 4286867.0 |
| 2025-10-30 11:00:00 | AAPL | Stock | 268.9 | 271.748 | 268.89 | 271.175 | 4048705.0 |
| 2025-10-30 12:00:00 | AAPL | Stock | 271.17 | 272.39 | 271.17 | 271.3 | 3597698.0 |
| 2025-10-30 13:00:00 | AAPL | Stock | 271.31 | 272.07 | 271.04 | 272.0 | 2538762.0 |
| 2025-10-30 14:00:00 | AAPL | Stock | 272.0 | 272.3 | 271.18 | 271.37 | 3819414.0 |
| 2025-10-30 15:00:00 | AAPL | Stock | 271.35 | 271.86 | 270.995 | 271.38 | 8081643.0 |
| 2025-10-30 16:00:00 | AAPL | Stock | 271.43 | 284.48 | 261.79 | 282.21 | 15081286.0 |
| 2025-10-30 17:00:00 | AAPL | Stock | 282.7369 | 285.0 | 278.24 | 278.79 | 1963817.0 |
| 2025-10-30 18:00:00 | AAPL | Stock | 278.83 | 281.0 | 277.6 | 277.65 | 619506.0 |
| 2025-10-30 19:00:00 | AAPL | Stock | 277.6078 | 278.48 | 271.4 | 277.75 | 340684.0 |
| 2025-10-30 04:00:00 | MSFT | Stock | 524.3 | 528.39 | 522.5 | 525.59 | 68228.0 |
| 2025-10-30 05:00:00 | MSFT | Stock | 525.98 | 526.98 | 523.99 | 524.97 | 47131.0 |
| 2025-10-30 06:00:00 | MSFT | Stock | 524.88 | 530.26 | 524.5 | 527.79 | 85441.0 |
| 2025-10-30 07:00:00 | MSFT | Stock | 527.7 | 532.41 | 526.72 | 531.24 | 142741.0 |
| 2025-10-30 08:00:00 | MSFT | Stock | 531.0 | 532.4726 | 520.2 | 528.15 | 432898.0 |
| 2025-10-30 09:00:00 | MSFT | Stock | 528.11 | 541.55 | 525.0 | 527.88 | 5634900.0 |
| 2025-10-30 10:00:00 | MSFT | Stock | 528.005 | 531.59 | 524.11 | 528.14 | 4114224.0 |
| 2025-10-30 11:00:00 | MSFT | Stock | 528.22 | 528.3599 | 522.16 | 522.81 | 3076268.0 |
| 2025-10-30 12:00:00 | MSFT | Stock | 522.8 | 527.78 | 522.68 | 526.17 | 2372269.0 |
| 2025-10-30 13:00:00 | MSFT | Stock | 526.16 | 527.72 | 525.43 | 526.66 | 1389066.0 |
| 2025-10-30 14:00:00 | MSFT | Stock | 526.66 | 527.0 | 522.31 | 523.54 | 1464872.0 |
| 2025-10-30 15:00:00 | MSFT | Stock | 523.511 | 526.6486 | 522.12 | 525.78 | 2541427.0 |
| 2025-10-30 16:00:00 | MSFT | Stock | 525.78 | 527.2 | 524.0 | 526.9973 | 4180701.0 |
| 2025-10-30 17:00:00 | MSFT | Stock | 526.9 | 529.3756 | 526.58 | 527.9575 | 71139.0 |
| 2025-10-30 18:00:00 | MSFT | Stock | 527.43 | 527.43 | 525.69 | 525.87 | 29893.0 |
| 2025-10-30 19:00:00 | MSFT | Stock | 525.95 | 526.0 | 525.02 | 525.96 | 31350.0 |
| 2025-10-30 04:00:00 | NVDA | Stock | 207.04 | 208.73 | 206.7 | 207.36 | 300574.0 |
| 2025-10-30 05:00:00 | NVDA | Stock | 207.41 | 207.72 | 205.0 | 205.56 | 312592.0 |
| 2025-10-30 06:00:00 | NVDA | Stock | 205.57 | 206.22 | 205.05 | 205.94 | 242672.0 |
| 2025-10-30 07:00:00 | NVDA | Stock | 205.92 | 207.38 | 205.91 | 206.71 | 442772.0 |
| 2025-10-30 08:00:00 | NVDA | Stock | 205.88 | 210.0 | 202.76 | 203.1991 | 4123996.0 |
| 2025-10-30 09:00:00 | NVDA | Stock | 203.2 | 206.16 | 201.45 | 203.965 | 26825682.0 |
| 2025-10-30 10:00:00 | NVDA | Stock | 203.96 | 204.71 | 201.41 | 202.92 | 22401348.0 |
| 2025-10-30 11:00:00 | NVDA | Stock | 202.91 | 203.85 | 202.06 | 202.555 | 14493389.0 |
| 2025-10-30 12:00:00 | NVDA | Stock | 202.565 | 203.84 | 202.41 | 203.58 | 10850912.0 |
| 2025-10-30 13:00:00 | NVDA | Stock | 203.57 | 204.4799 | 202.4407 | 204.18 | 10539962.0 |
| 2025-10-30 14:00:00 | NVDA | Stock | 204.17 | 204.28 | 203.3652 | 203.505 | 8528523.0 |
| 2025-10-30 15:00:00 | NVDA | Stock | 203.505 | 203.61 | 201.88 | 202.78 | 17095779.0 |
| 2025-10-30 16:00:00 | NVDA | Stock | 202.89 | 204.27 | 201.7 | 204.05 | 16162577.0 |
| 2025-10-30 17:00:00 | NVDA | Stock | 204.02 | 204.5 | 203.5 | 204.0158 | 690137.0 |
| 2025-10-30 18:00:00 | NVDA | Stock | 204.01 | 204.84 | 203.91 | 204.43 | 363413.0 |
| 2025-10-30 19:00:00 | NVDA | Stock | 204.41 | 204.7 | 204.01 | 204.5499 | 299723.0 |
| 2025-10-30 04:00:00 | AMZN | Stock | 230.0 | 230.0 | 228.84 | 229.15 | 32242.0 |
| 2025-10-30 05:00:00 | AMZN | Stock | 229.06 | 229.29 | 228.37 | 228.37 | 24573.0 |
> showing 50 of 64,837 rows — these rows as CSV