PREVIEW / stock_1hour / 2025-05-15
file: by_date/stock_1hour/2025/2025-05-15.parquet size: 1.4 MB rows: 61,338 symbols: 414
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-05-15 04:00:00 | AAPL | Stock | 211.48 | 211.48 | 209.75 | 209.99 | 29897.0 |
| 2025-05-15 05:00:00 | AAPL | Stock | 210.0 | 210.32 | 209.5 | 210.3 | 17226.0 |
| 2025-05-15 06:00:00 | AAPL | Stock | 210.06 | 210.06 | 209.29 | 209.5 | 39269.0 |
| 2025-05-15 07:00:00 | AAPL | Stock | 209.58 | 210.39 | 209.51 | 210.03 | 36478.0 |
| 2025-05-15 08:00:00 | AAPL | Stock | 209.75 | 212.15 | 209.55 | 209.86 | 140400.0 |
| 2025-05-15 09:00:00 | AAPL | Stock | 209.8987 | 212.53 | 209.8987 | 210.42 | 4355723.0 |
| 2025-05-15 10:00:00 | AAPL | Stock | 210.45 | 211.94 | 209.54 | 211.92 | 4178587.0 |
| 2025-05-15 11:00:00 | AAPL | Stock | 211.93 | 212.96 | 211.27 | 211.96 | 3793736.0 |
| 2025-05-15 12:00:00 | AAPL | Stock | 211.9613 | 212.25 | 211.21 | 212.04 | 2446733.0 |
| 2025-05-15 13:00:00 | AAPL | Stock | 212.025 | 212.28 | 211.04 | 211.1801 | 2193087.0 |
| 2025-05-15 14:00:00 | AAPL | Stock | 211.18 | 211.3299 | 210.25 | 210.65 | 2869499.0 |
| 2025-05-15 15:00:00 | AAPL | Stock | 210.66 | 211.47 | 210.15 | 211.45 | 6039802.0 |
| 2025-05-15 16:00:00 | AAPL | Stock | 211.45 | 211.45 | 210.92 | 211.101 | 6666193.0 |
| 2025-05-15 17:00:00 | AAPL | Stock | 211.11 | 211.23 | 211.0292 | 211.13 | 16707.0 |
| 2025-05-15 18:00:00 | AAPL | Stock | 211.1378 | 211.1378 | 210.91 | 210.91 | 16207.0 |
| 2025-05-15 19:00:00 | AAPL | Stock | 210.91 | 211.25 | 210.8025 | 211.01 | 32524.0 |
| 2025-05-15 04:00:00 | MSFT | Stock | 450.61 | 450.61 | 448.7 | 449.67 | 5108.0 |
| 2025-05-15 05:00:00 | MSFT | Stock | 449.79 | 450.56 | 449.11 | 450.56 | 10076.0 |
| 2025-05-15 06:00:00 | MSFT | Stock | 450.3 | 451.17 | 450.17 | 450.67 | 2897.0 |
| 2025-05-15 07:00:00 | MSFT | Stock | 450.75 | 451.0 | 450.0 | 450.79 | 7990.0 |
| 2025-05-15 08:00:00 | MSFT | Stock | 450.0 | 452.5 | 449.75 | 451.55 | 24941.0 |
| 2025-05-15 09:00:00 | MSFT | Stock | 451.0628 | 453.47 | 450.4301 | 453.0 | 1225922.0 |
| 2025-05-15 10:00:00 | MSFT | Stock | 453.14 | 454.25 | 452.29 | 453.14 | 1295704.0 |
| 2025-05-15 11:00:00 | MSFT | Stock | 453.115 | 455.51 | 453.0076 | 455.35 | 1480896.0 |
| 2025-05-15 12:00:00 | MSFT | Stock | 455.35 | 456.0 | 454.7712 | 455.58 | 884056.0 |
| 2025-05-15 13:00:00 | MSFT | Stock | 455.56 | 456.19 | 453.95 | 454.31 | 1037548.0 |
| 2025-05-15 14:00:00 | MSFT | Stock | 454.33 | 454.36 | 452.69 | 453.07 | 932335.0 |
| 2025-05-15 15:00:00 | MSFT | Stock | 453.035 | 454.0 | 451.09 | 453.05 | 2336228.0 |
| 2025-05-15 16:00:00 | MSFT | Stock | 453.05 | 453.13 | 451.71 | 452.1 | 3747513.0 |
| 2025-05-15 17:00:00 | MSFT | Stock | 452.25 | 452.25 | 451.76 | 451.98 | 5734.0 |
| 2025-05-15 18:00:00 | MSFT | Stock | 452.0 | 452.2 | 451.75 | 451.75 | 10681.0 |
| 2025-05-15 19:00:00 | MSFT | Stock | 451.7 | 452.6824 | 451.5122 | 452.6824 | 2622.0 |
| 2025-05-15 04:00:00 | NVDA | Stock | 133.52 | 134.49 | 132.08 | 132.16 | 1454639.0 |
| 2025-05-15 05:00:00 | NVDA | Stock | 132.17 | 133.09 | 131.87 | 132.96 | 914751.0 |
| 2025-05-15 06:00:00 | NVDA | Stock | 132.94 | 133.6 | 132.5 | 133.11 | 655529.0 |
| 2025-05-15 07:00:00 | NVDA | Stock | 133.12 | 134.64 | 133.09 | 134.19 | 1382738.0 |
| 2025-05-15 08:00:00 | NVDA | Stock | 133.26 | 135.91 | 131.9 | 134.32 | 4460421.0 |
| 2025-05-15 09:00:00 | NVDA | Stock | 134.3 | 134.72 | 132.66 | 133.58 | 28916871.0 |
| 2025-05-15 10:00:00 | NVDA | Stock | 133.57 | 134.2 | 132.75 | 133.565 | 28776514.0 |
| 2025-05-15 11:00:00 | NVDA | Stock | 133.57 | 134.67 | 133.43 | 134.53 | 19041774.0 |
| 2025-05-15 12:00:00 | NVDA | Stock | 134.53 | 136.2454 | 134.5207 | 135.785 | 25948190.0 |
| 2025-05-15 13:00:00 | NVDA | Stock | 135.7851 | 136.3 | 135.72 | 135.9314 | 16320742.0 |
| 2025-05-15 14:00:00 | NVDA | Stock | 135.935 | 135.96 | 134.57 | 134.615 | 18429356.0 |
| 2025-05-15 15:00:00 | NVDA | Stock | 134.615 | 135.02 | 133.58 | 134.9 | 27700528.0 |
| 2025-05-15 16:00:00 | NVDA | Stock | 134.89 | 135.4 | 134.61 | 134.72 | 13990227.0 |
| 2025-05-15 17:00:00 | NVDA | Stock | 134.7 | 134.83 | 134.25 | 134.33 | 470088.0 |
| 2025-05-15 18:00:00 | NVDA | Stock | 134.36 | 134.4899 | 134.2812 | 134.38 | 228517.0 |
| 2025-05-15 19:00:00 | NVDA | Stock | 134.38 | 134.88 | 134.3 | 134.7 | 473930.0 |
| 2025-05-15 04:00:00 | AMZN | Stock | 209.46 | 209.46 | 207.1 | 207.31 | 33678.0 |
| 2025-05-15 05:00:00 | AMZN | Stock | 207.35 | 207.83 | 206.99 | 207.77 | 20193.0 |
> showing 50 of 61,338 rows — these rows as CSV