PREVIEW / stock_1hour / 2024-12-24
file: by_date/stock_1hour/2024/2024-12-24.parquet size: 1.0 MB rows: 42,507 symbols: 607
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 |
|---|---|---|---|---|---|---|---|
| 2024-12-24 04:00:00 | AAPL | Stock | 255.05 | 255.53 | 255.0 | 255.53 | 6280.0 |
| 2024-12-24 05:00:00 | AAPL | Stock | 255.54 | 255.59 | 255.38 | 255.52 | 3427.0 |
| 2024-12-24 06:00:00 | AAPL | Stock | 255.57 | 255.7 | 255.47 | 255.47 | 2588.0 |
| 2024-12-24 07:00:00 | AAPL | Stock | 255.41 | 255.5 | 255.0 | 255.3 | 12571.0 |
| 2024-12-24 08:00:00 | AAPL | Stock | 255.0 | 255.5 | 254.95 | 255.35 | 29523.0 |
| 2024-12-24 09:00:00 | AAPL | Stock | 255.38 | 257.0 | 255.0 | 256.765 | 2927492.0 |
| 2024-12-24 10:00:00 | AAPL | Stock | 256.79 | 258.01 | 256.56 | 257.55 | 3069446.0 |
| 2024-12-24 11:00:00 | AAPL | Stock | 257.54 | 257.72 | 256.8701 | 257.08 | 1867463.0 |
| 2024-12-24 12:00:00 | AAPL | Stock | 257.11 | 258.21 | 257.0 | 258.21 | 3471633.0 |
| 2024-12-24 13:00:00 | AAPL | Stock | 258.178 | 258.36 | 257.98 | 258.0 | 4174941.0 |
| 2024-12-24 14:00:00 | AAPL | Stock | 257.98 | 258.11 | 257.72 | 257.7989 | 17465.0 |
| 2024-12-24 15:00:00 | AAPL | Stock | 257.72 | 257.9791 | 257.7 | 257.9 | 20029.0 |
| 2024-12-24 16:00:00 | AAPL | Stock | 257.82 | 258.18 | 257.82 | 258.1 | 9859.0 |
| 2024-12-24 04:00:00 | MSFT | Stock | 434.6 | 435.0 | 434.4 | 434.98 | 3043.0 |
| 2024-12-24 05:00:00 | MSFT | Stock | 434.71 | 435.0 | 434.59 | 435.0 | 606.0 |
| 2024-12-24 06:00:00 | MSFT | Stock | 434.94 | 434.94 | 434.64 | 434.64 | 826.0 |
| 2024-12-24 07:00:00 | MSFT | Stock | 434.72 | 434.72 | 434.6 | 434.6 | 761.0 |
| 2024-12-24 08:00:00 | MSFT | Stock | 434.5 | 434.81 | 433.72 | 434.74 | 13428.0 |
| 2024-12-24 09:00:00 | MSFT | Stock | 434.89 | 436.35 | 434.0 | 436.09 | 720362.0 |
| 2024-12-24 10:00:00 | MSFT | Stock | 436.11 | 438.67 | 435.885 | 438.18 | 956044.0 |
| 2024-12-24 11:00:00 | MSFT | Stock | 438.1994 | 438.35 | 437.2308 | 437.51 | 455671.0 |
| 2024-12-24 12:00:00 | MSFT | Stock | 437.5 | 439.6 | 437.4 | 439.24 | 1062415.0 |
| 2024-12-24 13:00:00 | MSFT | Stock | 439.23 | 439.79 | 439.12 | 439.33 | 1891365.0 |
| 2024-12-24 14:00:00 | MSFT | Stock | 439.33 | 439.33 | 439.08 | 439.08 | 2196.0 |
| 2024-12-24 15:00:00 | MSFT | Stock | 439.05 | 439.0509 | 439.05 | 439.0509 | 391.0 |
| 2024-12-24 16:00:00 | MSFT | Stock | 439.13 | 439.246 | 439.11 | 439.246 | 1054.0 |
| 2024-12-24 04:00:00 | NVDA | Stock | 139.69 | 140.2 | 139.29 | 139.87 | 314960.0 |
| 2024-12-24 05:00:00 | NVDA | Stock | 139.88 | 139.9 | 139.4 | 139.6 | 145776.0 |
| 2024-12-24 06:00:00 | NVDA | Stock | 139.58 | 139.73 | 139.23 | 139.35 | 142563.0 |
| 2024-12-24 07:00:00 | NVDA | Stock | 139.38 | 140.5 | 139.34 | 140.34 | 873329.0 |
| 2024-12-24 08:00:00 | NVDA | Stock | 139.55 | 140.55 | 139.25 | 140.23 | 1517207.0 |
| 2024-12-24 09:00:00 | NVDA | Stock | 140.24 | 141.8 | 139.3103 | 141.6419 | 22846651.0 |
| 2024-12-24 10:00:00 | NVDA | Stock | 141.66 | 141.9 | 140.26 | 141.2 | 21191265.0 |
| 2024-12-24 11:00:00 | NVDA | Stock | 141.2 | 141.4099 | 140.46 | 140.5 | 12890281.0 |
| 2024-12-24 12:00:00 | NVDA | Stock | 140.5 | 141.0 | 138.65 | 140.35 | 18872432.0 |
| 2024-12-24 13:00:00 | NVDA | Stock | 140.22 | 140.25 | 139.9103 | 139.95 | 7375078.0 |
| 2024-12-24 14:00:00 | NVDA | Stock | 139.95 | 140.02 | 139.6 | 139.63 | 279078.0 |
| 2024-12-24 15:00:00 | NVDA | Stock | 139.6 | 139.66 | 139.5 | 139.6201 | 206302.0 |
| 2024-12-24 16:00:00 | NVDA | Stock | 139.63 | 139.78 | 139.51 | 139.7799 | 159381.0 |
| 2024-12-24 04:00:00 | AMZN | Stock | 225.05 | 225.36 | 225.05 | 225.24 | 2978.0 |
| 2024-12-24 05:00:00 | AMZN | Stock | 225.29 | 225.49 | 225.21 | 225.49 | 1431.0 |
| 2024-12-24 06:00:00 | AMZN | Stock | 225.5 | 225.5 | 225.22 | 225.22 | 2142.0 |
| 2024-12-24 07:00:00 | AMZN | Stock | 225.26 | 225.64 | 225.15 | 225.6 | 12665.0 |
| 2024-12-24 08:00:00 | AMZN | Stock | 225.28 | 225.7 | 224.498 | 225.68 | 48396.0 |
| 2024-12-24 09:00:00 | AMZN | Stock | 225.6495 | 228.6 | 225.52 | 228.3601 | 2263098.0 |
| 2024-12-24 10:00:00 | AMZN | Stock | 228.4 | 229.14 | 227.27 | 228.52 | 2598569.0 |
| 2024-12-24 11:00:00 | AMZN | Stock | 228.49 | 228.915 | 228.1 | 228.5653 | 1406048.0 |
| 2024-12-24 12:00:00 | AMZN | Stock | 228.574 | 229.1 | 228.1601 | 228.9 | 2124330.0 |
| 2024-12-24 13:00:00 | AMZN | Stock | 229.05 | 229.13 | 228.9 | 228.91 | 2663609.0 |
| 2024-12-24 14:00:00 | AMZN | Stock | 228.9 | 228.9 | 228.75 | 228.87 | 23602.0 |
> showing 50 of 42,507 rows — these rows as CSV