PREVIEW / stock_1hour / 2024-09-23
file: by_date/stock_1hour/2024/2024-09-23.parquet size: 1.3 MB rows: 59,463 symbols: 782
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-09-23 04:00:00 | AAPL | Stock | 228.4 | 228.48 | 227.35 | 227.7 | 43816.0 |
| 2024-09-23 05:00:00 | AAPL | Stock | 227.71 | 227.98 | 227.55 | 227.98 | 19589.0 |
| 2024-09-23 06:00:00 | AAPL | Stock | 227.87 | 228.37 | 227.8 | 228.2 | 23883.0 |
| 2024-09-23 07:00:00 | AAPL | Stock | 228.05 | 228.44 | 227.81 | 228.27 | 59110.0 |
| 2024-09-23 08:00:00 | AAPL | Stock | 228.125 | 228.66 | 226.6 | 227.1995 | 273570.0 |
| 2024-09-23 09:00:00 | AAPL | Stock | 227.18 | 227.84 | 225.85 | 226.935 | 6281323.0 |
| 2024-09-23 10:00:00 | AAPL | Stock | 226.935 | 229.45 | 226.29 | 228.705 | 5939565.0 |
| 2024-09-23 11:00:00 | AAPL | Stock | 228.7001 | 228.9 | 228.1 | 228.34 | 2584176.0 |
| 2024-09-23 12:00:00 | AAPL | Stock | 228.3389 | 228.3389 | 226.66 | 226.7605 | 2585669.0 |
| 2024-09-23 13:00:00 | AAPL | Stock | 226.77 | 227.14 | 226.51 | 227.1 | 2375181.0 |
| 2024-09-23 14:00:00 | AAPL | Stock | 227.08 | 227.18 | 226.485 | 226.68 | 1703769.0 |
| 2024-09-23 15:00:00 | AAPL | Stock | 226.68 | 226.705 | 225.81 | 226.45 | 5047546.0 |
| 2024-09-23 16:00:00 | AAPL | Stock | 226.47 | 226.6 | 226.27 | 226.29 | 9174623.0 |
| 2024-09-23 17:00:00 | AAPL | Stock | 226.3 | 226.47 | 226.22 | 226.24 | 1482437.0 |
| 2024-09-23 18:00:00 | AAPL | Stock | 226.26 | 226.276 | 226.12 | 226.22 | 13992.0 |
| 2024-09-23 19:00:00 | AAPL | Stock | 226.18 | 226.393 | 226.0 | 226.23 | 16348.0 |
| 2024-09-23 04:00:00 | MSFT | Stock | 436.56 | 436.79 | 435.38 | 436.0 | 3951.0 |
| 2024-09-23 05:00:00 | MSFT | Stock | 436.35 | 436.55 | 435.9 | 436.4 | 4812.0 |
| 2024-09-23 06:00:00 | MSFT | Stock | 436.59 | 436.59 | 431.5 | 432.29 | 38457.0 |
| 2024-09-23 07:00:00 | MSFT | Stock | 432.68 | 434.0 | 432.31 | 433.9 | 36361.0 |
| 2024-09-23 08:00:00 | MSFT | Stock | 434.09 | 437.46 | 432.4 | 433.65 | 63363.0 |
| 2024-09-23 09:00:00 | MSFT | Stock | 433.58 | 434.68 | 430.3889 | 432.74 | 1479898.0 |
| 2024-09-23 10:00:00 | MSFT | Stock | 432.72 | 435.9 | 432.21 | 435.27 | 790011.0 |
| 2024-09-23 11:00:00 | MSFT | Stock | 435.27 | 436.46 | 434.2501 | 435.352 | 505130.0 |
| 2024-09-23 12:00:00 | MSFT | Stock | 435.38 | 435.4649 | 433.05 | 433.24 | 508302.0 |
| 2024-09-23 13:00:00 | MSFT | Stock | 433.22 | 434.16 | 432.5 | 433.875 | 539898.0 |
| 2024-09-23 14:00:00 | MSFT | Stock | 433.8601 | 434.3824 | 433.415 | 434.165 | 349663.0 |
| 2024-09-23 15:00:00 | MSFT | Stock | 434.16 | 434.43 | 433.115 | 433.37 | 762651.0 |
| 2024-09-23 16:00:00 | MSFT | Stock | 433.51 | 433.51 | 432.47 | 432.47 | 4274289.0 |
| 2024-09-23 17:00:00 | MSFT | Stock | 432.73 | 432.8661 | 432.5143 | 432.5143 | 2153.0 |
| 2024-09-23 18:00:00 | MSFT | Stock | 432.51 | 432.56 | 432.45 | 432.45 | 4430.0 |
| 2024-09-23 19:00:00 | MSFT | Stock | 432.49 | 432.61 | 432.49 | 432.6 | 5640.0 |
| 2024-09-23 04:00:00 | NVDA | Stock | 116.4 | 116.95 | 116.0 | 116.34 | 328620.0 |
| 2024-09-23 05:00:00 | NVDA | Stock | 116.3 | 116.52 | 116.18 | 116.35 | 153553.0 |
| 2024-09-23 06:00:00 | NVDA | Stock | 116.38 | 116.46 | 116.15 | 116.27 | 166993.0 |
| 2024-09-23 07:00:00 | NVDA | Stock | 116.28 | 116.35 | 115.82 | 116.22 | 679453.0 |
| 2024-09-23 08:00:00 | NVDA | Stock | 116.17 | 117.42 | 115.75 | 116.26 | 1913965.0 |
| 2024-09-23 09:00:00 | NVDA | Stock | 116.26 | 116.99 | 115.45 | 116.27 | 28252227.0 |
| 2024-09-23 10:00:00 | NVDA | Stock | 116.27 | 116.83 | 114.86 | 115.6106 | 36686057.0 |
| 2024-09-23 11:00:00 | NVDA | Stock | 115.6101 | 116.35 | 115.1 | 116.2 | 22664789.0 |
| 2024-09-23 12:00:00 | NVDA | Stock | 116.21 | 116.28 | 115.32 | 115.59 | 20474417.0 |
| 2024-09-23 13:00:00 | NVDA | Stock | 115.59 | 115.98 | 115.27 | 115.93 | 14313616.0 |
| 2024-09-23 14:00:00 | NVDA | Stock | 115.93 | 116.26 | 115.71 | 116.22 | 13468343.0 |
| 2024-09-23 15:00:00 | NVDA | Stock | 116.21 | 116.605 | 116.01 | 116.23 | 19876869.0 |
| 2024-09-23 16:00:00 | NVDA | Stock | 116.26 | 116.31 | 116.03 | 116.06 | 22502870.0 |
| 2024-09-23 17:00:00 | NVDA | Stock | 116.05 | 116.13 | 116.02 | 116.1 | 170639.0 |
| 2024-09-23 18:00:00 | NVDA | Stock | 116.09 | 116.1 | 115.9601 | 115.99 | 154472.0 |
| 2024-09-23 19:00:00 | NVDA | Stock | 115.97 | 116.11 | 115.91 | 116.1 | 248883.0 |
| 2024-09-23 04:00:00 | AMZN | Stock | 191.27 | 191.56 | 191.04 | 191.15 | 11772.0 |
| 2024-09-23 05:00:00 | AMZN | Stock | 191.17 | 191.51 | 191.06 | 191.47 | 4853.0 |
> showing 50 of 59,463 rows — these rows as CSV