PREVIEW / stock_1hour / 2025-09-24
file: by_date/stock_1hour/2025/2025-09-24.parquet size: 1.5 MB rows: 64,146 symbols: 307
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-09-24 04:00:00 | AAPL | Stock | 254.21 | 254.52 | 254.14 | 254.52 | 11079.0 |
| 2025-09-24 05:00:00 | AAPL | Stock | 254.61 | 254.94 | 254.5 | 254.55 | 11615.0 |
| 2025-09-24 06:00:00 | AAPL | Stock | 254.6 | 254.68 | 254.26 | 254.41 | 8888.0 |
| 2025-09-24 07:00:00 | AAPL | Stock | 254.42 | 255.0 | 254.42 | 255.0 | 23464.0 |
| 2025-09-24 08:00:00 | AAPL | Stock | 254.51 | 255.45 | 253.794 | 255.11 | 104430.0 |
| 2025-09-24 09:00:00 | AAPL | Stock | 255.1164 | 255.74 | 252.28 | 253.25 | 4471092.0 |
| 2025-09-24 10:00:00 | AAPL | Stock | 253.28 | 253.2995 | 251.72 | 252.2101 | 4549474.0 |
| 2025-09-24 11:00:00 | AAPL | Stock | 252.22 | 252.31 | 251.28 | 251.405 | 3046252.0 |
| 2025-09-24 12:00:00 | AAPL | Stock | 251.41 | 252.261 | 251.04 | 251.5397 | 2786267.0 |
| 2025-09-24 13:00:00 | AAPL | Stock | 251.54 | 252.11 | 251.32 | 251.5 | 1352477.0 |
| 2025-09-24 14:00:00 | AAPL | Stock | 251.4938 | 251.84 | 251.25 | 251.725 | 1599232.0 |
| 2025-09-24 15:00:00 | AAPL | Stock | 251.72 | 252.5 | 251.24 | 252.24 | 4033352.0 |
| 2025-09-24 16:00:00 | AAPL | Stock | 252.2 | 252.47 | 252.01 | 252.32 | 9034588.0 |
| 2025-09-24 17:00:00 | AAPL | Stock | 252.31 | 252.47 | 252.26 | 252.32 | 21404.0 |
| 2025-09-24 18:00:00 | AAPL | Stock | 252.36 | 252.36 | 252.2 | 252.25 | 9222.0 |
| 2025-09-24 19:00:00 | AAPL | Stock | 252.2732 | 252.28 | 252.02 | 252.08 | 18534.0 |
| 2025-09-24 04:00:00 | MSFT | Stock | 509.3 | 510.53 | 509.3 | 509.93 | 1248.0 |
| 2025-09-24 05:00:00 | MSFT | Stock | 510.31 | 510.49 | 510.31 | 510.49 | 698.0 |
| 2025-09-24 06:00:00 | MSFT | Stock | 510.49 | 510.75 | 510.0 | 510.16 | 2475.0 |
| 2025-09-24 07:00:00 | MSFT | Stock | 510.08 | 510.62 | 509.85 | 510.52 | 5813.0 |
| 2025-09-24 08:00:00 | MSFT | Stock | 510.5 | 510.6915 | 508.4 | 510.55 | 16992.0 |
| 2025-09-24 09:00:00 | MSFT | Stock | 510.61 | 512.48 | 507.2 | 508.62 | 1344431.0 |
| 2025-09-24 10:00:00 | MSFT | Stock | 508.74 | 510.8 | 508.03 | 509.37 | 813883.0 |
| 2025-09-24 11:00:00 | MSFT | Stock | 509.39 | 510.89 | 508.2 | 508.27 | 698288.0 |
| 2025-09-24 12:00:00 | MSFT | Stock | 508.275 | 508.86 | 507.4301 | 507.51 | 639300.0 |
| 2025-09-24 13:00:00 | MSFT | Stock | 507.51 | 508.32 | 506.92 | 507.63 | 485802.0 |
| 2025-09-24 14:00:00 | MSFT | Stock | 507.65 | 509.71 | 507.52 | 509.68 | 394084.0 |
| 2025-09-24 15:00:00 | MSFT | Stock | 509.63 | 510.525 | 509.0201 | 509.98 | 1202929.0 |
| 2025-09-24 16:00:00 | MSFT | Stock | 510.15 | 510.4 | 509.91 | 510.1 | 2819413.0 |
| 2025-09-24 17:00:00 | MSFT | Stock | 510.12 | 510.19 | 509.75 | 509.91 | 6330.0 |
| 2025-09-24 18:00:00 | MSFT | Stock | 510.15 | 510.3988 | 510.01 | 510.3988 | 3151.0 |
| 2025-09-24 19:00:00 | MSFT | Stock | 510.15 | 510.18 | 510.04 | 510.04 | 2471.0 |
| 2025-09-24 04:00:00 | NVDA | Stock | 179.4 | 180.21 | 178.54 | 179.77 | 305446.0 |
| 2025-09-24 05:00:00 | NVDA | Stock | 179.78 | 179.82 | 179.34 | 179.69 | 195085.0 |
| 2025-09-24 06:00:00 | NVDA | Stock | 179.7 | 179.92 | 179.47 | 179.6 | 173568.0 |
| 2025-09-24 07:00:00 | NVDA | Stock | 179.58 | 179.85 | 179.1 | 179.28 | 353764.0 |
| 2025-09-24 08:00:00 | NVDA | Stock | 177.6 | 180.21 | 177.58 | 179.2014 | 1826720.0 |
| 2025-09-24 09:00:00 | NVDA | Stock | 179.2 | 179.8 | 177.6 | 178.3393 | 16391478.0 |
| 2025-09-24 10:00:00 | NVDA | Stock | 178.33 | 179.11 | 177.98 | 178.065 | 15404889.0 |
| 2025-09-24 11:00:00 | NVDA | Stock | 178.0644 | 178.51 | 176.18 | 176.25 | 15990449.0 |
| 2025-09-24 12:00:00 | NVDA | Stock | 176.26 | 176.51 | 175.4 | 176.375 | 16354018.0 |
| 2025-09-24 13:00:00 | NVDA | Stock | 176.38 | 177.34 | 176.3416 | 176.915 | 10454941.0 |
| 2025-09-24 14:00:00 | NVDA | Stock | 176.91 | 177.34 | 176.4801 | 177.155 | 9171684.0 |
| 2025-09-24 15:00:00 | NVDA | Stock | 177.155 | 177.34 | 176.705 | 176.88 | 11779977.0 |
| 2025-09-24 16:00:00 | NVDA | Stock | 176.862 | 176.97 | 176.44 | 176.6514 | 12330487.0 |
| 2025-09-24 17:00:00 | NVDA | Stock | 176.65 | 176.97 | 176.53 | 176.71 | 170897.0 |
| 2025-09-24 18:00:00 | NVDA | Stock | 176.72 | 176.7399 | 176.62 | 176.6806 | 97487.0 |
| 2025-09-24 19:00:00 | NVDA | Stock | 176.6988 | 176.6999 | 176.48 | 176.52 | 145447.0 |
| 2025-09-24 04:00:00 | AMZN | Stock | 222.15 | 222.98 | 222.15 | 222.48 | 53053.0 |
| 2025-09-24 05:00:00 | AMZN | Stock | 222.48 | 224.99 | 222.48 | 224.35 | 197614.0 |
> showing 50 of 64,146 rows — these rows as CSV