PREVIEW / stock_1hour / 2025-03-17
file: by_date/stock_1hour/2025/2025-03-17.parquet size: 1.4 MB rows: 61,965 symbols: 489
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-03-17 04:00:00 | AAPL | Stock | 212.86 | 213.35 | 212.0 | 212.55 | 20008.0 |
| 2025-03-17 05:00:00 | AAPL | Stock | 212.49 | 212.68 | 212.1 | 212.37 | 9938.0 |
| 2025-03-17 06:00:00 | AAPL | Stock | 212.37 | 212.96 | 212.34 | 212.73 | 15185.0 |
| 2025-03-17 07:00:00 | AAPL | Stock | 212.77 | 213.18 | 212.69 | 212.79 | 27498.0 |
| 2025-03-17 08:00:00 | AAPL | Stock | 212.94 | 214.0 | 212.2 | 213.82 | 140635.0 |
| 2025-03-17 09:00:00 | AAPL | Stock | 213.75 | 214.97 | 212.17 | 213.72 | 4512066.0 |
| 2025-03-17 10:00:00 | AAPL | Stock | 213.73 | 214.0 | 211.3075 | 211.39 | 4415577.0 |
| 2025-03-17 11:00:00 | AAPL | Stock | 211.39 | 211.67 | 209.97 | 210.915 | 4199391.0 |
| 2025-03-17 12:00:00 | AAPL | Stock | 210.9157 | 211.89 | 210.57 | 211.5662 | 2559607.0 |
| 2025-03-17 13:00:00 | AAPL | Stock | 211.55 | 213.7478 | 211.09 | 213.665 | 3013696.0 |
| 2025-03-17 14:00:00 | AAPL | Stock | 213.66 | 214.7968 | 213.51 | 214.55 | 2921761.0 |
| 2025-03-17 15:00:00 | AAPL | Stock | 214.541 | 215.22 | 213.67 | 214.15 | 6366496.0 |
| 2025-03-17 16:00:00 | AAPL | Stock | 214.0 | 214.26 | 213.6 | 213.99 | 7047565.0 |
| 2025-03-17 17:00:00 | AAPL | Stock | 213.95 | 213.95 | 213.75 | 213.78 | 19596.0 |
| 2025-03-17 18:00:00 | AAPL | Stock | 213.8096 | 214.0 | 213.78 | 214.0 | 13549.0 |
| 2025-03-17 19:00:00 | AAPL | Stock | 214.02 | 214.05 | 213.73 | 213.93 | 10065.0 |
| 2025-03-17 04:00:00 | MSFT | Stock | 386.1 | 386.4 | 385.5 | 386.29 | 5491.0 |
| 2025-03-17 05:00:00 | MSFT | Stock | 386.01 | 386.03 | 385.79 | 385.81 | 3050.0 |
| 2025-03-17 06:00:00 | MSFT | Stock | 385.82 | 387.2 | 385.82 | 386.99 | 5470.0 |
| 2025-03-17 07:00:00 | MSFT | Stock | 387.05 | 387.3 | 385.86 | 386.15 | 19632.0 |
| 2025-03-17 08:00:00 | MSFT | Stock | 386.14 | 387.589 | 385.3 | 386.69 | 42278.0 |
| 2025-03-17 09:00:00 | MSFT | Stock | 386.56 | 389.93 | 385.93 | 388.79 | 1276591.0 |
| 2025-03-17 10:00:00 | MSFT | Stock | 388.84 | 390.3107 | 387.37 | 388.025 | 1370647.0 |
| 2025-03-17 11:00:00 | MSFT | Stock | 388.07 | 388.27 | 385.57 | 386.64 | 941854.0 |
| 2025-03-17 12:00:00 | MSFT | Stock | 386.66 | 387.97 | 386.14 | 387.64 | 691500.0 |
| 2025-03-17 13:00:00 | MSFT | Stock | 387.64 | 390.28 | 386.96 | 389.875 | 944121.0 |
| 2025-03-17 14:00:00 | MSFT | Stock | 389.87 | 392.705 | 389.8549 | 392.22 | 1059182.0 |
| 2025-03-17 15:00:00 | MSFT | Stock | 392.21 | 392.21 | 388.58 | 388.78 | 2177002.0 |
| 2025-03-17 16:00:00 | MSFT | Stock | 388.81 | 388.96 | 387.92 | 388.96 | 5201024.0 |
| 2025-03-17 17:00:00 | MSFT | Stock | 388.96 | 388.98 | 388.74 | 388.98 | 3487.0 |
| 2025-03-17 18:00:00 | MSFT | Stock | 389.0 | 389.64 | 389.0 | 389.58 | 2512.0 |
| 2025-03-17 19:00:00 | MSFT | Stock | 389.06 | 389.48 | 388.82 | 388.95 | 2217.0 |
| 2025-03-17 04:00:00 | NVDA | Stock | 121.1 | 123.04 | 120.96 | 122.71 | 920976.0 |
| 2025-03-17 05:00:00 | NVDA | Stock | 122.79 | 122.92 | 122.34 | 122.68 | 499858.0 |
| 2025-03-17 06:00:00 | NVDA | Stock | 122.67 | 122.76 | 122.4 | 122.49 | 457489.0 |
| 2025-03-17 07:00:00 | NVDA | Stock | 122.47 | 123.7 | 122.44 | 123.47 | 1250897.0 |
| 2025-03-17 08:00:00 | NVDA | Stock | 122.53 | 123.7 | 120.83 | 123.09 | 3264961.0 |
| 2025-03-17 09:00:00 | NVDA | Stock | 123.09 | 123.48 | 120.05 | 121.12 | 37155393.0 |
| 2025-03-17 10:00:00 | NVDA | Stock | 121.13 | 121.3 | 119.08 | 119.33 | 37429701.0 |
| 2025-03-17 11:00:00 | NVDA | Stock | 119.345 | 119.87 | 118.88 | 119.3054 | 23995817.0 |
| 2025-03-17 12:00:00 | NVDA | Stock | 119.31 | 119.59 | 118.03 | 118.66 | 24224167.0 |
| 2025-03-17 13:00:00 | NVDA | Stock | 118.655 | 119.65 | 118.35 | 119.2001 | 19750294.0 |
| 2025-03-17 14:00:00 | NVDA | Stock | 119.2 | 121.08 | 119.13 | 120.6998 | 24309182.0 |
| 2025-03-17 15:00:00 | NVDA | Stock | 120.69 | 120.86 | 119.42 | 119.48 | 28668844.0 |
| 2025-03-17 16:00:00 | NVDA | Stock | 119.48 | 120.0701 | 119.17 | 119.65 | 15904344.0 |
| 2025-03-17 17:00:00 | NVDA | Stock | 119.6499 | 119.86 | 119.55 | 119.77 | 323880.0 |
| 2025-03-17 18:00:00 | NVDA | Stock | 119.77 | 119.99 | 119.71 | 119.74 | 352983.0 |
| 2025-03-17 19:00:00 | NVDA | Stock | 119.74 | 119.8 | 119.436 | 119.5101 | 368404.0 |
| 2025-03-17 04:00:00 | AMZN | Stock | 196.8 | 197.77 | 196.8 | 197.3 | 28472.0 |
| 2025-03-17 05:00:00 | AMZN | Stock | 197.3 | 197.43 | 197.12 | 197.43 | 6158.0 |
> showing 50 of 61,965 rows — these rows as CSV