PREVIEW / stock_1hour / 2025-09-02
file: by_date/stock_1hour/2025/2025-09-02.parquet size: 1.5 MB rows: 64,549 symbols: 323
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-02 04:00:00 | AAPL | Stock | 231.88 | 231.88 | 230.7 | 231.2 | 9638.0 |
| 2025-09-02 05:00:00 | AAPL | Stock | 231.06 | 231.2 | 230.92 | 230.92 | 5651.0 |
| 2025-09-02 06:00:00 | AAPL | Stock | 230.89 | 231.0 | 230.28 | 230.42 | 11321.0 |
| 2025-09-02 07:00:00 | AAPL | Stock | 230.49 | 230.77 | 230.35 | 230.63 | 24255.0 |
| 2025-09-02 08:00:00 | AAPL | Stock | 230.27 | 231.81 | 229.41 | 229.53 | 197724.0 |
| 2025-09-02 09:00:00 | AAPL | Stock | 229.38 | 230.455 | 227.68 | 230.19 | 4954688.0 |
| 2025-09-02 10:00:00 | AAPL | Stock | 230.13 | 230.78 | 228.0 | 228.09 | 4207055.0 |
| 2025-09-02 11:00:00 | AAPL | Stock | 228.095 | 228.4374 | 227.17 | 227.4154 | 3185761.0 |
| 2025-09-02 12:00:00 | AAPL | Stock | 227.41 | 228.15 | 227.38 | 228.0172 | 1823241.0 |
| 2025-09-02 13:00:00 | AAPL | Stock | 228.02 | 229.34 | 227.85 | 228.61 | 1810615.0 |
| 2025-09-02 14:00:00 | AAPL | Stock | 228.6 | 228.9 | 228.33 | 228.5715 | 1546649.0 |
| 2025-09-02 15:00:00 | AAPL | Stock | 228.57 | 230.85 | 226.97 | 229.73 | 5382719.0 |
| 2025-09-02 16:00:00 | AAPL | Stock | 229.72 | 239.5 | 228.81 | 238.04 | 9163077.0 |
| 2025-09-02 17:00:00 | AAPL | Stock | 238.11 | 238.6 | 236.8 | 236.8 | 539204.0 |
| 2025-09-02 18:00:00 | AAPL | Stock | 236.93 | 237.0212 | 235.5 | 235.56 | 143168.0 |
| 2025-09-02 19:00:00 | AAPL | Stock | 235.67 | 236.97 | 235.5 | 236.532 | 111618.0 |
| 2025-09-02 04:00:00 | MSFT | Stock | 505.24 | 505.24 | 504.2 | 504.5 | 5219.0 |
| 2025-09-02 05:00:00 | MSFT | Stock | 504.76 | 504.91 | 504.32 | 504.32 | 997.0 |
| 2025-09-02 06:00:00 | MSFT | Stock | 504.34 | 504.34 | 503.05 | 503.3 | 957.0 |
| 2025-09-02 07:00:00 | MSFT | Stock | 503.48 | 503.48 | 502.81 | 503.46 | 4183.0 |
| 2025-09-02 08:00:00 | MSFT | Stock | 502.8 | 506.24 | 501.1 | 501.28 | 48569.0 |
| 2025-09-02 09:00:00 | MSFT | Stock | 501.2 | 504.365 | 496.81 | 503.59 | 1885949.0 |
| 2025-09-02 10:00:00 | MSFT | Stock | 503.61 | 505.4292 | 502.465 | 502.875 | 1242113.0 |
| 2025-09-02 11:00:00 | MSFT | Stock | 502.862 | 503.3065 | 500.31 | 500.72 | 1040939.0 |
| 2025-09-02 12:00:00 | MSFT | Stock | 500.7 | 501.8 | 500.62 | 501.53 | 670227.0 |
| 2025-09-02 13:00:00 | MSFT | Stock | 501.56 | 503.07 | 500.2818 | 502.27 | 916743.0 |
| 2025-09-02 14:00:00 | MSFT | Stock | 502.27 | 503.39 | 501.39 | 502.8136 | 849818.0 |
| 2025-09-02 15:00:00 | MSFT | Stock | 502.86 | 506.0 | 502.86 | 505.08 | 1437631.0 |
| 2025-09-02 16:00:00 | MSFT | Stock | 505.12 | 505.12 | 501.7 | 502.12 | 3510111.0 |
| 2025-09-02 17:00:00 | MSFT | Stock | 502.2 | 505.12 | 502.2 | 504.03 | 33161.0 |
| 2025-09-02 18:00:00 | MSFT | Stock | 504.48 | 504.48 | 502.84 | 502.84 | 5200.0 |
| 2025-09-02 19:00:00 | MSFT | Stock | 502.75 | 502.8 | 502.0 | 502.8 | 7146.0 |
| 2025-09-02 04:00:00 | NVDA | Stock | 172.4 | 173.6 | 171.26 | 171.83 | 497317.0 |
| 2025-09-02 05:00:00 | NVDA | Stock | 171.84 | 172.25 | 171.6 | 171.82 | 260809.0 |
| 2025-09-02 06:00:00 | NVDA | Stock | 171.78 | 172.04 | 171.31 | 171.41 | 275155.0 |
| 2025-09-02 07:00:00 | NVDA | Stock | 171.43 | 171.79 | 169.89 | 170.24 | 1217220.0 |
| 2025-09-02 08:00:00 | NVDA | Stock | 171.48 | 173.76 | 168.55 | 169.97 | 4268634.0 |
| 2025-09-02 09:00:00 | NVDA | Stock | 169.99 | 172.379 | 168.65 | 171.65 | 31103097.0 |
| 2025-09-02 10:00:00 | NVDA | Stock | 171.64 | 172.01 | 168.7132 | 169.5153 | 31622850.0 |
| 2025-09-02 11:00:00 | NVDA | Stock | 169.515 | 169.7658 | 167.34 | 167.83 | 29953361.0 |
| 2025-09-02 12:00:00 | NVDA | Stock | 167.8399 | 169.03 | 167.22 | 169.015 | 20842659.0 |
| 2025-09-02 13:00:00 | NVDA | Stock | 169.01 | 169.63 | 168.315 | 169.2175 | 15638790.0 |
| 2025-09-02 14:00:00 | NVDA | Stock | 169.21 | 170.05 | 168.98 | 169.618 | 13524899.0 |
| 2025-09-02 15:00:00 | NVDA | Stock | 169.61 | 171.12 | 169.56 | 170.75 | 23129547.0 |
| 2025-09-02 16:00:00 | NVDA | Stock | 170.78 | 171.2097 | 169.0428 | 170.249 | 14417985.0 |
| 2025-09-02 17:00:00 | NVDA | Stock | 170.22 | 170.48 | 169.95 | 170.3964 | 316149.0 |
| 2025-09-02 18:00:00 | NVDA | Stock | 170.35 | 170.4 | 170.1 | 170.11 | 207808.0 |
| 2025-09-02 19:00:00 | NVDA | Stock | 170.11 | 170.19 | 169.5 | 169.6637 | 405269.0 |
| 2025-09-02 04:00:00 | AMZN | Stock | 228.47 | 228.48 | 226.6 | 227.09 | 16018.0 |
| 2025-09-02 05:00:00 | AMZN | Stock | 227.14 | 227.21 | 226.94 | 226.97 | 3682.0 |
> showing 50 of 64,549 rows — these rows as CSV