PREVIEW / stock_1hour / 2025-07-22
file: by_date/stock_1hour/2025/2025-07-22.parquet size: 1.4 MB rows: 63,480 symbols: 366
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-07-22 04:00:00 | AAPL | Stock | 212.88 | 212.96 | 212.41 | 212.8 | 11830.0 |
| 2025-07-22 05:00:00 | AAPL | Stock | 212.8 | 213.04 | 212.72 | 212.72 | 8691.0 |
| 2025-07-22 06:00:00 | AAPL | Stock | 212.86 | 212.86 | 212.65 | 212.8 | 2323.0 |
| 2025-07-22 07:00:00 | AAPL | Stock | 212.78 | 213.15 | 212.69 | 213.05 | 22297.0 |
| 2025-07-22 08:00:00 | AAPL | Stock | 212.92 | 213.2 | 212.4 | 213.1001 | 103284.0 |
| 2025-07-22 09:00:00 | AAPL | Stock | 213.12 | 214.03 | 212.2301 | 213.58 | 5638856.0 |
| 2025-07-22 10:00:00 | AAPL | Stock | 213.58 | 213.77 | 212.68 | 213.2129 | 4827878.0 |
| 2025-07-22 11:00:00 | AAPL | Stock | 213.21 | 213.83 | 212.76 | 213.265 | 4087998.0 |
| 2025-07-22 12:00:00 | AAPL | Stock | 213.265 | 213.74 | 212.84 | 213.41 | 3097171.0 |
| 2025-07-22 13:00:00 | AAPL | Stock | 213.4 | 214.48 | 213.37 | 213.86 | 3179334.0 |
| 2025-07-22 14:00:00 | AAPL | Stock | 213.8634 | 214.21 | 213.44 | 214.17 | 2269962.0 |
| 2025-07-22 15:00:00 | AAPL | Stock | 214.15 | 214.95 | 213.825 | 214.39 | 5428853.0 |
| 2025-07-22 16:00:00 | AAPL | Stock | 214.4 | 214.56 | 214.28 | 214.5003 | 5202590.0 |
| 2025-07-22 17:00:00 | AAPL | Stock | 214.5006 | 214.74 | 214.4 | 214.73 | 53742.0 |
| 2025-07-22 18:00:00 | AAPL | Stock | 214.73 | 215.0 | 214.61 | 214.7 | 31673.0 |
| 2025-07-22 19:00:00 | AAPL | Stock | 214.7 | 215.0 | 214.55 | 214.85 | 42146.0 |
| 2025-07-22 04:00:00 | MSFT | Stock | 508.71 | 509.2 | 508.7 | 508.98 | 1350.0 |
| 2025-07-22 05:00:00 | MSFT | Stock | 508.75 | 509.33 | 508.75 | 509.33 | 1946.0 |
| 2025-07-22 06:00:00 | MSFT | Stock | 509.47 | 509.8 | 509.22 | 509.22 | 1342.0 |
| 2025-07-22 07:00:00 | MSFT | Stock | 509.34 | 510.0 | 509.3 | 509.9 | 2768.0 |
| 2025-07-22 08:00:00 | MSFT | Stock | 509.7522 | 511.0 | 508.6713 | 510.8 | 23498.0 |
| 2025-07-22 09:00:00 | MSFT | Stock | 510.88 | 511.2 | 507.66 | 508.06 | 1018737.0 |
| 2025-07-22 10:00:00 | MSFT | Stock | 507.99 | 509.59 | 507.43 | 508.76 | 946637.0 |
| 2025-07-22 11:00:00 | MSFT | Stock | 508.8 | 509.31 | 506.95 | 506.98 | 682413.0 |
| 2025-07-22 12:00:00 | MSFT | Stock | 507.0 | 507.725 | 506.35 | 506.9683 | 508167.0 |
| 2025-07-22 13:00:00 | MSFT | Stock | 506.95 | 507.72 | 506.235 | 506.575 | 461681.0 |
| 2025-07-22 14:00:00 | MSFT | Stock | 506.545 | 506.9096 | 505.46 | 506.26 | 539785.0 |
| 2025-07-22 15:00:00 | MSFT | Stock | 506.22 | 508.22 | 505.27 | 505.46 | 1269455.0 |
| 2025-07-22 16:00:00 | MSFT | Stock | 505.27 | 506.76 | 505.27 | 506.4 | 2347594.0 |
| 2025-07-22 17:00:00 | MSFT | Stock | 506.6 | 506.79 | 505.27 | 506.45 | 11966.0 |
| 2025-07-22 18:00:00 | MSFT | Stock | 506.7755 | 506.7755 | 506.2 | 506.4 | 6267.0 |
| 2025-07-22 19:00:00 | MSFT | Stock | 506.65 | 507.45 | 506.65 | 507.41 | 2329.0 |
| 2025-07-22 04:00:00 | NVDA | Stock | 170.85 | 171.09 | 169.04 | 169.07 | 422547.0 |
| 2025-07-22 05:00:00 | NVDA | Stock | 169.09 | 169.61 | 169.09 | 169.53 | 303246.0 |
| 2025-07-22 06:00:00 | NVDA | Stock | 169.55 | 170.24 | 169.54 | 169.98 | 391630.0 |
| 2025-07-22 07:00:00 | NVDA | Stock | 169.96 | 170.5 | 169.8 | 170.36 | 418023.0 |
| 2025-07-22 08:00:00 | NVDA | Stock | 170.34 | 171.16 | 169.05 | 170.83 | 1295206.0 |
| 2025-07-22 09:00:00 | NVDA | Stock | 170.8003 | 171.4 | 164.58 | 165.625 | 36669987.0 |
| 2025-07-22 10:00:00 | NVDA | Stock | 165.63 | 167.855 | 165.37 | 167.76 | 33014091.0 |
| 2025-07-22 11:00:00 | NVDA | Stock | 167.76 | 168.64 | 167.63 | 168.155 | 18097587.0 |
| 2025-07-22 12:00:00 | NVDA | Stock | 168.16 | 168.43 | 167.35 | 167.755 | 15396473.0 |
| 2025-07-22 13:00:00 | NVDA | Stock | 167.755 | 168.42 | 167.735 | 168.12 | 8558568.0 |
| 2025-07-22 14:00:00 | NVDA | Stock | 168.12 | 168.16 | 167.3601 | 168.0952 | 8597829.0 |
| 2025-07-22 15:00:00 | NVDA | Stock | 168.095 | 168.29 | 165.92 | 167.01 | 16066901.0 |
| 2025-07-22 16:00:00 | NVDA | Stock | 167.03 | 167.19 | 166.28 | 166.43 | 11253620.0 |
| 2025-07-22 17:00:00 | NVDA | Stock | 166.46 | 167.03 | 166.03 | 166.5597 | 545216.0 |
| 2025-07-22 18:00:00 | NVDA | Stock | 166.56 | 166.6 | 166.3 | 166.3401 | 243773.0 |
| 2025-07-22 19:00:00 | NVDA | Stock | 166.32 | 167.87 | 166.32 | 167.77 | 608195.0 |
| 2025-07-22 04:00:00 | AMZN | Stock | 229.17 | 229.41 | 228.85 | 228.91 | 9129.0 |
| 2025-07-22 05:00:00 | AMZN | Stock | 228.85 | 229.47 | 228.85 | 229.47 | 8244.0 |
> showing 50 of 63,480 rows — these rows as CSV