PREVIEW / stock_1hour / 2025-12-18
file: by_date/stock_1hour/2025/2025-12-18.parquet size: 1.4 MB rows: 59,966 symbols: 180
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-12-18 04:00:00 | AAPL | Stock | 271.35 | 271.99 | 271.35 | 271.81 | 13860.0 |
| 2025-12-18 05:00:00 | AAPL | Stock | 271.85 | 271.85 | 271.45 | 271.49 | 6480.0 |
| 2025-12-18 06:00:00 | AAPL | Stock | 271.5 | 271.77 | 271.39 | 271.69 | 2671.0 |
| 2025-12-18 07:00:00 | AAPL | Stock | 271.79 | 271.89 | 271.32 | 271.32 | 11067.0 |
| 2025-12-18 08:00:00 | AAPL | Stock | 271.69 | 272.78 | 271.32 | 272.3 | 98540.0 |
| 2025-12-18 09:00:00 | AAPL | Stock | 272.38 | 273.75 | 266.95 | 268.82 | 7163954.0 |
| 2025-12-18 10:00:00 | AAPL | Stock | 268.82 | 272.225 | 268.38 | 272.02 | 5076967.0 |
| 2025-12-18 11:00:00 | AAPL | Stock | 272.0 | 273.164 | 271.93 | 272.86 | 2844812.0 |
| 2025-12-18 12:00:00 | AAPL | Stock | 272.855 | 272.86 | 269.94 | 272.4 | 2285194.0 |
| 2025-12-18 13:00:00 | AAPL | Stock | 272.37 | 272.96 | 271.61 | 271.75 | 1724079.0 |
| 2025-12-18 14:00:00 | AAPL | Stock | 271.715 | 271.9 | 270.5 | 270.865 | 2446515.0 |
| 2025-12-18 15:00:00 | AAPL | Stock | 270.88 | 273.21 | 270.67 | 272.16 | 4346828.0 |
| 2025-12-18 16:00:00 | AAPL | Stock | 272.13 | 272.19 | 271.01 | 271.54 | 10965676.0 |
| 2025-12-18 17:00:00 | AAPL | Stock | 271.68 | 272.19 | 271.4208 | 271.4208 | 10902.0 |
| 2025-12-18 18:00:00 | AAPL | Stock | 271.42 | 271.68 | 271.01 | 271.52 | 19380.0 |
| 2025-12-18 19:00:00 | AAPL | Stock | 271.52 | 271.82 | 271.04 | 271.39 | 10577.0 |
| 2025-12-18 04:00:00 | MSFT | Stock | 479.0 | 479.75 | 478.4 | 479.75 | 8687.0 |
| 2025-12-18 05:00:00 | MSFT | Stock | 479.61 | 479.85 | 479.0 | 479.17 | 4183.0 |
| 2025-12-18 06:00:00 | MSFT | Stock | 479.27 | 479.5 | 479.13 | 479.36 | 1542.0 |
| 2025-12-18 07:00:00 | MSFT | Stock | 479.24 | 479.25 | 478.41 | 478.61 | 5326.0 |
| 2025-12-18 08:00:00 | MSFT | Stock | 478.88 | 480.46 | 476.61 | 479.74 | 52618.0 |
| 2025-12-18 09:00:00 | MSFT | Stock | 479.8 | 483.83 | 477.78 | 483.45 | 1983274.0 |
| 2025-12-18 10:00:00 | MSFT | Stock | 483.445 | 487.58 | 482.94 | 487.58 | 3043919.0 |
| 2025-12-18 11:00:00 | MSFT | Stock | 487.555 | 489.6 | 487.06 | 487.19 | 1763066.0 |
| 2025-12-18 12:00:00 | MSFT | Stock | 487.17 | 487.34 | 484.19 | 486.83 | 1309389.0 |
| 2025-12-18 13:00:00 | MSFT | Stock | 486.83 | 487.4355 | 485.96 | 486.385 | 857148.0 |
| 2025-12-18 14:00:00 | MSFT | Stock | 486.35 | 486.38 | 483.855 | 484.08 | 1016131.0 |
| 2025-12-18 15:00:00 | MSFT | Stock | 484.08 | 486.02 | 483.39 | 483.88 | 2077199.0 |
| 2025-12-18 16:00:00 | MSFT | Stock | 483.84 | 484.02 | 482.41 | 482.95 | 7545775.0 |
| 2025-12-18 17:00:00 | MSFT | Stock | 482.95 | 484.36 | 482.9 | 483.95 | 25683.0 |
| 2025-12-18 18:00:00 | MSFT | Stock | 483.76 | 483.76 | 482.49 | 483.24 | 7173.0 |
| 2025-12-18 19:00:00 | MSFT | Stock | 483.01 | 483.5 | 482.05 | 482.51 | 16109.0 |
| 2025-12-18 04:00:00 | NVDA | Stock | 172.39 | 173.01 | 172.3 | 172.95 | 170382.0 |
| 2025-12-18 05:00:00 | NVDA | Stock | 172.93 | 173.3 | 172.69 | 173.2 | 135628.0 |
| 2025-12-18 06:00:00 | NVDA | Stock | 173.16 | 173.56 | 172.97 | 173.15 | 151663.0 |
| 2025-12-18 07:00:00 | NVDA | Stock | 173.14 | 173.21 | 172.75 | 172.8 | 245260.0 |
| 2025-12-18 08:00:00 | NVDA | Stock | 173.07 | 174.45 | 171.24 | 173.68 | 2213943.0 |
| 2025-12-18 09:00:00 | NVDA | Stock | 173.7 | 174.89 | 171.82 | 173.85 | 21359911.0 |
| 2025-12-18 10:00:00 | NVDA | Stock | 173.85 | 176.15 | 172.72 | 175.415 | 25715634.0 |
| 2025-12-18 11:00:00 | NVDA | Stock | 175.415 | 176.04 | 174.81 | 175.68 | 14465601.0 |
| 2025-12-18 12:00:00 | NVDA | Stock | 175.68 | 175.73 | 173.73 | 175.28 | 15110396.0 |
| 2025-12-18 13:00:00 | NVDA | Stock | 175.28 | 175.38 | 174.71 | 174.9199 | 8531849.0 |
| 2025-12-18 14:00:00 | NVDA | Stock | 174.91 | 175.04 | 173.76 | 173.9 | 10111042.0 |
| 2025-12-18 15:00:00 | NVDA | Stock | 173.8915 | 175.0 | 172.05 | 174.01 | 15320853.0 |
| 2025-12-18 16:00:00 | NVDA | Stock | 174.0 | 174.39 | 173.6501 | 174.0568 | 21313569.0 |
| 2025-12-18 17:00:00 | NVDA | Stock | 174.1 | 174.95 | 174.06 | 174.81 | 326540.0 |
| 2025-12-18 18:00:00 | NVDA | Stock | 174.8 | 175.13 | 174.5207 | 175.12 | 265017.0 |
| 2025-12-18 19:00:00 | NVDA | Stock | 175.11 | 175.17 | 174.78 | 174.81 | 250467.0 |
| 2025-12-18 04:00:00 | AMZN | Stock | 222.64 | 223.0 | 222.43 | 222.9 | 14768.0 |
| 2025-12-18 05:00:00 | AMZN | Stock | 222.9 | 223.1 | 222.54 | 222.95 | 13667.0 |
> showing 50 of 59,966 rows — these rows as CSV