PREVIEW / stock_1hour / 2024-12-27
file: by_date/stock_1hour/2024/2024-12-27.parquet size: 1.4 MB rows: 63,907 symbols: 613
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-27 04:00:00 | AAPL | Stock | 258.37 | 258.83 | 258.37 | 258.78 | 5583.0 |
| 2024-12-27 05:00:00 | AAPL | Stock | 258.81 | 258.9 | 258.81 | 258.9 | 1680.0 |
| 2024-12-27 06:00:00 | AAPL | Stock | 258.93 | 258.95 | 258.89 | 258.95 | 2895.0 |
| 2024-12-27 07:00:00 | AAPL | Stock | 258.95 | 259.51 | 258.95 | 259.28 | 14252.0 |
| 2024-12-27 08:00:00 | AAPL | Stock | 258.9996 | 259.59 | 258.38 | 258.57 | 69661.0 |
| 2024-12-27 09:00:00 | AAPL | Stock | 258.55 | 258.7 | 256.11 | 256.6197 | 2956356.0 |
| 2024-12-27 10:00:00 | AAPL | Stock | 256.64 | 256.66 | 254.5 | 254.95 | 4657581.0 |
| 2024-12-27 11:00:00 | AAPL | Stock | 254.95 | 255.04 | 253.36 | 253.635 | 3548532.0 |
| 2024-12-27 12:00:00 | AAPL | Stock | 253.62 | 254.55 | 253.06 | 254.5 | 2759973.0 |
| 2024-12-27 13:00:00 | AAPL | Stock | 254.48 | 255.34 | 254.29 | 255.3 | 1890592.0 |
| 2024-12-27 14:00:00 | AAPL | Stock | 255.29 | 255.5599 | 254.9701 | 255.465 | 1668294.0 |
| 2024-12-27 15:00:00 | AAPL | Stock | 255.4501 | 255.82 | 254.95 | 255.73 | 5370519.0 |
| 2024-12-27 16:00:00 | AAPL | Stock | 255.72 | 256.38 | 254.94 | 255.11 | 8992562.0 |
| 2024-12-27 17:00:00 | AAPL | Stock | 255.07 | 255.59 | 254.5401 | 254.95 | 97109.0 |
| 2024-12-27 18:00:00 | AAPL | Stock | 254.84 | 254.9405 | 254.72 | 254.77 | 16456.0 |
| 2024-12-27 19:00:00 | AAPL | Stock | 254.83 | 254.9783 | 254.77 | 254.77 | 12234.0 |
| 2024-12-27 04:00:00 | MSFT | Stock | 437.0 | 437.1 | 436.31 | 436.73 | 3592.0 |
| 2024-12-27 05:00:00 | MSFT | Stock | 436.89 | 437.33 | 436.89 | 437.1 | 2096.0 |
| 2024-12-27 06:00:00 | MSFT | Stock | 437.05 | 437.05 | 436.98 | 436.98 | 808.0 |
| 2024-12-27 07:00:00 | MSFT | Stock | 437.0 | 437.77 | 437.0 | 437.3 | 4561.0 |
| 2024-12-27 08:00:00 | MSFT | Stock | 436.9 | 437.75 | 436.48 | 437.0 | 12509.0 |
| 2024-12-27 09:00:00 | MSFT | Stock | 436.6 | 436.72 | 429.24 | 430.47 | 1168468.0 |
| 2024-12-27 10:00:00 | MSFT | Stock | 430.47 | 430.7 | 427.36 | 429.3 | 1356527.0 |
| 2024-12-27 11:00:00 | MSFT | Stock | 429.3 | 429.9164 | 426.71 | 427.7199 | 997620.0 |
| 2024-12-27 12:00:00 | MSFT | Stock | 427.655 | 427.87 | 426.35 | 427.75 | 774122.0 |
| 2024-12-27 13:00:00 | MSFT | Stock | 427.75 | 430.0 | 427.41 | 429.61 | 533394.0 |
| 2024-12-27 14:00:00 | MSFT | Stock | 429.6 | 430.78 | 429.55 | 430.73 | 483120.0 |
| 2024-12-27 15:00:00 | MSFT | Stock | 430.665 | 430.99 | 428.73 | 430.7 | 2139526.0 |
| 2024-12-27 16:00:00 | MSFT | Stock | 430.53 | 431.87 | 430.0 | 430.25 | 4482871.0 |
| 2024-12-27 17:00:00 | MSFT | Stock | 430.12 | 430.39 | 429.7291 | 429.92 | 8579.0 |
| 2024-12-27 18:00:00 | MSFT | Stock | 430.1499 | 430.1499 | 429.84 | 430.1 | 2833.0 |
| 2024-12-27 19:00:00 | MSFT | Stock | 429.75 | 430.78 | 429.703 | 430.59 | 12726.0 |
| 2024-12-27 04:00:00 | NVDA | Stock | 138.99 | 139.5 | 138.5 | 138.77 | 260390.0 |
| 2024-12-27 05:00:00 | NVDA | Stock | 138.76 | 139.33 | 138.7 | 139.28 | 139103.0 |
| 2024-12-27 06:00:00 | NVDA | Stock | 139.28 | 139.33 | 139.11 | 139.3 | 79404.0 |
| 2024-12-27 07:00:00 | NVDA | Stock | 139.27 | 139.67 | 139.27 | 139.37 | 189159.0 |
| 2024-12-27 08:00:00 | NVDA | Stock | 139.37 | 139.67 | 138.5183 | 139.1 | 791282.0 |
| 2024-12-27 09:00:00 | NVDA | Stock | 139.1 | 139.1699 | 136.2 | 136.485 | 22389752.0 |
| 2024-12-27 10:00:00 | NVDA | Stock | 136.48 | 136.6499 | 134.71 | 135.9601 | 31654712.0 |
| 2024-12-27 11:00:00 | NVDA | Stock | 135.95 | 136.93 | 135.575 | 136.03 | 15417558.0 |
| 2024-12-27 12:00:00 | NVDA | Stock | 136.03 | 136.24 | 135.18 | 136.0489 | 13724693.0 |
| 2024-12-27 13:00:00 | NVDA | Stock | 136.04 | 136.78 | 135.855 | 136.69 | 12409074.0 |
| 2024-12-27 14:00:00 | NVDA | Stock | 136.6808 | 136.9699 | 136.16 | 136.8935 | 10509944.0 |
| 2024-12-27 15:00:00 | NVDA | Stock | 136.8901 | 137.15 | 136.3 | 137.12 | 20936790.0 |
| 2024-12-27 16:00:00 | NVDA | Stock | 137.01 | 137.18 | 136.96 | 136.98 | 19058906.0 |
| 2024-12-27 17:00:00 | NVDA | Stock | 136.99 | 137.02 | 136.7 | 136.7703 | 232538.0 |
| 2024-12-27 18:00:00 | NVDA | Stock | 136.77 | 136.83 | 136.63 | 136.7 | 129095.0 |
| 2024-12-27 19:00:00 | NVDA | Stock | 136.7 | 136.73 | 136.6 | 136.62 | 128107.0 |
| 2024-12-27 04:00:00 | AMZN | Stock | 226.0 | 226.35 | 225.9 | 225.9 | 16766.0 |
| 2024-12-27 05:00:00 | AMZN | Stock | 226.03 | 226.08 | 225.88 | 226.0 | 7186.0 |
> showing 50 of 63,907 rows — these rows as CSV