PREVIEW / stock_1hour / 2025-02-27
file: by_date/stock_1hour/2025/2025-02-27.parquet size: 1.4 MB rows: 62,235 symbols: 517
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-02-27 04:00:00 | AAPL | Stock | 240.12 | 241.65 | 240.12 | 240.91 | 19485.0 |
| 2025-02-27 05:00:00 | AAPL | Stock | 240.91 | 240.91 | 240.38 | 240.38 | 9432.0 |
| 2025-02-27 06:00:00 | AAPL | Stock | 240.4 | 240.56 | 240.19 | 240.34 | 9245.0 |
| 2025-02-27 07:00:00 | AAPL | Stock | 240.32 | 240.36 | 239.1 | 239.16 | 30130.0 |
| 2025-02-27 08:00:00 | AAPL | Stock | 239.95 | 241.34 | 238.65 | 239.0 | 143410.0 |
| 2025-02-27 09:00:00 | AAPL | Stock | 238.95 | 242.284 | 238.79 | 240.58 | 3719008.0 |
| 2025-02-27 10:00:00 | AAPL | Stock | 240.62 | 241.8 | 238.47 | 241.24 | 3346304.0 |
| 2025-02-27 11:00:00 | AAPL | Stock | 241.23 | 242.46 | 240.2501 | 240.435 | 2256466.0 |
| 2025-02-27 12:00:00 | AAPL | Stock | 240.46 | 241.345 | 239.585 | 240.775 | 1534122.0 |
| 2025-02-27 13:00:00 | AAPL | Stock | 240.82 | 242.19 | 240.76 | 241.61 | 1415657.0 |
| 2025-02-27 14:00:00 | AAPL | Stock | 241.6001 | 241.76 | 239.54 | 239.71 | 2049566.0 |
| 2025-02-27 15:00:00 | AAPL | Stock | 239.71 | 239.93 | 237.06 | 237.39 | 6326262.0 |
| 2025-02-27 16:00:00 | AAPL | Stock | 237.38 | 237.74 | 236.96 | 237.312 | 5791295.0 |
| 2025-02-27 17:00:00 | AAPL | Stock | 237.36 | 237.44 | 236.75 | 236.8283 | 19518.0 |
| 2025-02-27 18:00:00 | AAPL | Stock | 236.98 | 238.5 | 236.98 | 237.7 | 36524.0 |
| 2025-02-27 19:00:00 | AAPL | Stock | 238.0 | 238.2375 | 237.3 | 237.3 | 13990.0 |
| 2025-02-27 04:00:00 | MSFT | Stock | 401.93 | 402.1 | 401.36 | 401.41 | 3832.0 |
| 2025-02-27 05:00:00 | MSFT | Stock | 401.3 | 401.41 | 400.92 | 401.11 | 4347.0 |
| 2025-02-27 06:00:00 | MSFT | Stock | 401.23 | 401.29 | 400.88 | 400.9 | 3532.0 |
| 2025-02-27 07:00:00 | MSFT | Stock | 401.0 | 402.15 | 400.53 | 400.9 | 17891.0 |
| 2025-02-27 08:00:00 | MSFT | Stock | 401.47 | 402.07 | 400.09 | 401.2 | 48400.0 |
| 2025-02-27 09:00:00 | MSFT | Stock | 401.15 | 405.74 | 399.36 | 399.9 | 1742745.0 |
| 2025-02-27 10:00:00 | MSFT | Stock | 399.85 | 400.3999 | 397.7 | 397.8208 | 1323235.0 |
| 2025-02-27 11:00:00 | MSFT | Stock | 397.8 | 399.6299 | 396.98 | 397.21 | 851466.0 |
| 2025-02-27 12:00:00 | MSFT | Stock | 397.22 | 398.48 | 396.63 | 397.0801 | 778203.0 |
| 2025-02-27 13:00:00 | MSFT | Stock | 397.135 | 398.745 | 396.8722 | 397.82 | 580430.0 |
| 2025-02-27 14:00:00 | MSFT | Stock | 397.87 | 397.9 | 394.6003 | 395.02 | 1084483.0 |
| 2025-02-27 15:00:00 | MSFT | Stock | 395.08 | 395.184 | 392.17 | 392.58 | 3073336.0 |
| 2025-02-27 16:00:00 | MSFT | Stock | 392.6 | 393.0412 | 391.74 | 392.25 | 3312673.0 |
| 2025-02-27 17:00:00 | MSFT | Stock | 391.93 | 393.0 | 391.86 | 392.8315 | 13134.0 |
| 2025-02-27 18:00:00 | MSFT | Stock | 392.84 | 393.24 | 392.53 | 392.9418 | 10047.0 |
| 2025-02-27 19:00:00 | MSFT | Stock | 392.99 | 393.26 | 392.0 | 392.0 | 18238.0 |
| 2025-02-27 04:00:00 | NVDA | Stock | 131.55 | 132.06 | 129.79 | 132.05 | 1036380.0 |
| 2025-02-27 05:00:00 | NVDA | Stock | 132.03 | 133.32 | 132.0 | 132.48 | 912821.0 |
| 2025-02-27 06:00:00 | NVDA | Stock | 132.5 | 133.09 | 132.05 | 132.7 | 674663.0 |
| 2025-02-27 07:00:00 | NVDA | Stock | 132.7 | 135.5 | 132.5 | 135.21 | 4141901.0 |
| 2025-02-27 08:00:00 | NVDA | Stock | 133.12 | 135.5 | 129.64 | 133.869 | 6955978.0 |
| 2025-02-27 09:00:00 | NVDA | Stock | 133.83 | 135.35 | 126.2701 | 126.73 | 67627507.0 |
| 2025-02-27 10:00:00 | NVDA | Stock | 126.73 | 129.0 | 125.28 | 126.02 | 56602651.0 |
| 2025-02-27 11:00:00 | NVDA | Stock | 126.025 | 128.0699 | 125.51 | 125.9715 | 32833296.0 |
| 2025-02-27 12:00:00 | NVDA | Stock | 125.98 | 127.3 | 125.65 | 127.07 | 23565990.0 |
| 2025-02-27 13:00:00 | NVDA | Stock | 127.06 | 128.45 | 126.0301 | 126.11 | 25687577.0 |
| 2025-02-27 14:00:00 | NVDA | Stock | 126.1 | 126.23 | 122.62 | 124.215 | 49555368.0 |
| 2025-02-27 15:00:00 | NVDA | Stock | 124.21 | 124.435 | 120.01 | 120.01 | 64987885.0 |
| 2025-02-27 16:00:00 | NVDA | Stock | 120.08 | 121.5 | 119.32 | 120.86 | 31849055.0 |
| 2025-02-27 17:00:00 | NVDA | Stock | 120.88 | 121.1 | 120.6 | 121.0 | 1433165.0 |
| 2025-02-27 18:00:00 | NVDA | Stock | 121.0 | 121.95 | 120.96 | 121.64 | 1244439.0 |
| 2025-02-27 19:00:00 | NVDA | Stock | 121.64 | 121.88 | 120.9 | 121.15 | 1026384.0 |
| 2025-02-27 04:00:00 | AMZN | Stock | 216.9 | 217.08 | 216.38 | 216.92 | 22465.0 |
| 2025-02-27 05:00:00 | AMZN | Stock | 216.87 | 217.44 | 216.83 | 217.29 | 18132.0 |
> showing 50 of 62,235 rows — these rows as CSV