PREVIEW / stock_1hour / 2024-10-30
file: by_date/stock_1hour/2024/2024-10-30.parquet size: 1.4 MB rows: 60,400 symbols: 742
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-10-30 04:00:00 | AAPL | Stock | 233.03 | 233.31 | 232.5 | 233.12 | 24948.0 |
| 2024-10-30 05:00:00 | AAPL | Stock | 233.03 | 233.2 | 232.92 | 233.13 | 4171.0 |
| 2024-10-30 06:00:00 | AAPL | Stock | 233.15 | 233.16 | 232.95 | 233.02 | 12165.0 |
| 2024-10-30 07:00:00 | AAPL | Stock | 233.0 | 233.4 | 232.89 | 233.07 | 41431.0 |
| 2024-10-30 08:00:00 | AAPL | Stock | 233.25 | 233.4 | 232.71 | 232.753 | 80688.0 |
| 2024-10-30 09:00:00 | AAPL | Stock | 232.89 | 233.2299 | 231.85 | 232.58 | 3446911.0 |
| 2024-10-30 10:00:00 | AAPL | Stock | 232.599 | 232.782 | 231.14 | 231.156 | 3713886.0 |
| 2024-10-30 11:00:00 | AAPL | Stock | 231.16 | 231.665 | 230.505 | 231.3899 | 3365134.0 |
| 2024-10-30 12:00:00 | AAPL | Stock | 231.385 | 231.55 | 230.92 | 230.92 | 1712719.0 |
| 2024-10-30 13:00:00 | AAPL | Stock | 230.9183 | 231.05 | 229.8704 | 230.2188 | 2526551.0 |
| 2024-10-30 14:00:00 | AAPL | Stock | 230.215 | 231.03 | 230.2111 | 230.505 | 2135047.0 |
| 2024-10-30 15:00:00 | AAPL | Stock | 230.51 | 230.94 | 229.55 | 230.22 | 5584631.0 |
| 2024-10-30 16:00:00 | AAPL | Stock | 229.91 | 230.69 | 229.52 | 229.68 | 10023720.0 |
| 2024-10-30 17:00:00 | AAPL | Stock | 229.65 | 230.16 | 229.6 | 229.95 | 96515.0 |
| 2024-10-30 18:00:00 | AAPL | Stock | 229.66 | 230.7 | 229.6 | 230.61 | 87143.0 |
| 2024-10-30 19:00:00 | AAPL | Stock | 230.5 | 230.86 | 230.36 | 230.7 | 36298.0 |
| 2024-10-30 04:00:00 | MSFT | Stock | 437.5 | 441.26 | 437.5 | 441.25 | 42157.0 |
| 2024-10-30 05:00:00 | MSFT | Stock | 441.44 | 441.49 | 440.2 | 440.3 | 33450.0 |
| 2024-10-30 06:00:00 | MSFT | Stock | 440.4 | 441.22 | 440.3 | 440.51 | 17806.0 |
| 2024-10-30 07:00:00 | MSFT | Stock | 440.55 | 441.0 | 440.02 | 440.6 | 46938.0 |
| 2024-10-30 08:00:00 | MSFT | Stock | 440.21 | 441.0 | 437.09 | 440.15 | 141198.0 |
| 2024-10-30 09:00:00 | MSFT | Stock | 440.04 | 440.45 | 432.58 | 434.905 | 2666290.0 |
| 2024-10-30 10:00:00 | MSFT | Stock | 434.835 | 438.29 | 434.81 | 436.31 | 1994404.0 |
| 2024-10-30 11:00:00 | MSFT | Stock | 436.31 | 437.14 | 435.41 | 436.61 | 1349436.0 |
| 2024-10-30 12:00:00 | MSFT | Stock | 436.57 | 437.45 | 436.12 | 437.2 | 976999.0 |
| 2024-10-30 13:00:00 | MSFT | Stock | 437.19 | 437.59 | 434.236 | 434.275 | 1602403.0 |
| 2024-10-30 14:00:00 | MSFT | Stock | 434.3 | 435.3599 | 434.09 | 434.64 | 981473.0 |
| 2024-10-30 15:00:00 | MSFT | Stock | 434.62 | 435.37 | 432.1 | 433.63 | 3096473.0 |
| 2024-10-30 16:00:00 | MSFT | Stock | 433.63 | 444.95 | 419.34 | 435.4999 | 5218197.0 |
| 2024-10-30 17:00:00 | MSFT | Stock | 435.48 | 436.9 | 427.3 | 427.48 | 373790.0 |
| 2024-10-30 18:00:00 | MSFT | Stock | 427.35 | 428.0 | 409.7746 | 416.75 | 1038689.0 |
| 2024-10-30 19:00:00 | MSFT | Stock | 416.85 | 418.75 | 416.1534 | 416.5 | 176357.0 |
| 2024-10-30 04:00:00 | NVDA | Stock | 140.85 | 141.37 | 139.82 | 139.89 | 407374.0 |
| 2024-10-30 05:00:00 | NVDA | Stock | 139.86 | 140.52 | 139.75 | 140.07 | 207137.0 |
| 2024-10-30 06:00:00 | NVDA | Stock | 140.07 | 140.39 | 139.98 | 140.3 | 112199.0 |
| 2024-10-30 07:00:00 | NVDA | Stock | 140.29 | 141.09 | 140.23 | 140.28 | 590157.0 |
| 2024-10-30 08:00:00 | NVDA | Stock | 140.4 | 141.17 | 139.53 | 139.95 | 2113571.0 |
| 2024-10-30 09:00:00 | NVDA | Stock | 139.85 | 139.94 | 136.81 | 139.0422 | 35546480.0 |
| 2024-10-30 10:00:00 | NVDA | Stock | 139.04 | 139.915 | 138.83 | 139.125 | 24504303.0 |
| 2024-10-30 11:00:00 | NVDA | Stock | 139.125 | 140.18 | 139.01 | 139.8499 | 15423149.0 |
| 2024-10-30 12:00:00 | NVDA | Stock | 139.83 | 140.33 | 139.36 | 140.0496 | 10843454.0 |
| 2024-10-30 13:00:00 | NVDA | Stock | 140.0399 | 140.2395 | 138.96 | 139.45 | 12050956.0 |
| 2024-10-30 14:00:00 | NVDA | Stock | 139.45 | 140.28 | 139.37 | 139.865 | 9925676.0 |
| 2024-10-30 15:00:00 | NVDA | Stock | 139.85 | 140.0 | 139.02 | 139.47 | 18587705.0 |
| 2024-10-30 16:00:00 | NVDA | Stock | 139.4 | 139.6 | 138.49 | 138.98 | 16383219.0 |
| 2024-10-30 17:00:00 | NVDA | Stock | 139.02 | 139.68 | 138.9 | 139.07 | 624277.0 |
| 2024-10-30 18:00:00 | NVDA | Stock | 139.07 | 139.24 | 137.35 | 137.4852 | 1610174.0 |
| 2024-10-30 19:00:00 | NVDA | Stock | 137.48 | 138.0 | 137.36 | 137.85 | 574134.0 |
| 2024-10-30 04:00:00 | AMZN | Stock | 194.0 | 194.5 | 193.52 | 194.17 | 50150.0 |
| 2024-10-30 05:00:00 | AMZN | Stock | 194.17 | 194.8 | 194.1 | 194.45 | 30165.0 |
> showing 50 of 60,400 rows — these rows as CSV