PREVIEW / stock_1hour / 2022-11-25
file: by_date/stock_1hour/2022/2022-11-25.parquet size: 928 KB rows: 38,314 symbols: 1,910
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-25 04:00:00 | AAPL | Stock | 151.16 | 151.16 | 150.14 | 150.34 | 40933.0 |
| 2022-11-25 05:00:00 | AAPL | Stock | 150.35 | 150.42 | 150.16 | 150.36 | 30443.0 |
| 2022-11-25 06:00:00 | AAPL | Stock | 150.34 | 150.5 | 150.02 | 150.06 | 27827.0 |
| 2022-11-25 07:00:00 | AAPL | Stock | 150.06 | 150.25 | 149.47 | 149.49 | 102212.0 |
| 2022-11-25 08:00:00 | AAPL | Stock | 150.2283 | 151.15 | 149.09 | 149.13 | 358390.0 |
| 2022-11-25 09:00:00 | AAPL | Stock | 149.15 | 149.2 | 147.12 | 148.65 | 8378235.0 |
| 2022-11-25 10:00:00 | AAPL | Stock | 148.645 | 148.88 | 147.95 | 148.155 | 5982198.0 |
| 2022-11-25 11:00:00 | AAPL | Stock | 148.151 | 148.4 | 147.6 | 148.295 | 5332155.0 |
| 2022-11-25 12:00:00 | AAPL | Stock | 148.29 | 148.4099 | 147.8 | 148.16 | 6701809.0 |
| 2022-11-25 13:00:00 | AAPL | Stock | 148.11 | 148.16 | 147.9 | 148.12 | 3637844.0 |
| 2022-11-25 14:00:00 | AAPL | Stock | 148.1299 | 148.15 | 148.11 | 148.12 | 31927.0 |
| 2022-11-25 15:00:00 | AAPL | Stock | 148.115 | 148.12 | 148.11 | 148.115 | 19543.0 |
| 2022-11-25 16:00:00 | AAPL | Stock | 148.11 | 148.12 | 148.11 | 148.12 | 77182.0 |
| 2022-11-25 04:00:00 | MSFT | Stock | 248.22 | 248.4 | 247.65 | 247.81 | 4694.0 |
| 2022-11-25 05:00:00 | MSFT | Stock | 247.66 | 248.26 | 247.66 | 248.26 | 648.0 |
| 2022-11-25 06:00:00 | MSFT | Stock | 247.83 | 247.98 | 247.58 | 247.61 | 3189.0 |
| 2022-11-25 07:00:00 | MSFT | Stock | 247.59 | 247.59 | 247.07 | 247.1 | 3826.0 |
| 2022-11-25 08:00:00 | MSFT | Stock | 247.5 | 247.74 | 246.962 | 247.1 | 17316.0 |
| 2022-11-25 09:00:00 | MSFT | Stock | 247.11 | 248.7 | 246.42 | 247.82 | 1657266.0 |
| 2022-11-25 10:00:00 | MSFT | Stock | 247.8421 | 248.15 | 247.41 | 247.9758 | 1183867.0 |
| 2022-11-25 11:00:00 | MSFT | Stock | 247.97 | 248.19 | 246.73 | 247.51 | 1130815.0 |
| 2022-11-25 12:00:00 | MSFT | Stock | 247.51 | 248.04 | 247.16 | 247.58 | 1460094.0 |
| 2022-11-25 13:00:00 | MSFT | Stock | 247.66 | 247.67 | 247.0 | 247.25 | 1393212.0 |
| 2022-11-25 14:00:00 | MSFT | Stock | 247.42 | 247.8 | 247.42 | 247.51 | 11250.0 |
| 2022-11-25 15:00:00 | MSFT | Stock | 247.55 | 247.68 | 247.4 | 247.4 | 1091.0 |
| 2022-11-25 16:00:00 | MSFT | Stock | 247.49 | 247.69 | 247.49 | 247.69 | 1864.0 |
| 2022-11-25 04:00:00 | NVDA | Stock | 16.455 | 16.568 | 16.455 | 16.509 | 42770.0 |
| 2022-11-25 05:00:00 | NVDA | Stock | 16.511 | 16.53 | 16.511 | 16.529 | 10210.0 |
| 2022-11-25 06:00:00 | NVDA | Stock | 16.535 | 16.56 | 16.515 | 16.515 | 23650.0 |
| 2022-11-25 07:00:00 | NVDA | Stock | 16.52 | 16.561 | 16.446 | 16.447 | 147270.0 |
| 2022-11-25 08:00:00 | NVDA | Stock | 16.535 | 16.62 | 16.4111 | 16.425 | 648510.0 |
| 2022-11-25 09:00:00 | NVDA | Stock | 16.435 | 16.444 | 16.172 | 16.4133 | 41824890.0 |
| 2022-11-25 10:00:00 | NVDA | Stock | 16.41 | 16.487 | 16.328 | 16.356 | 39175370.0 |
| 2022-11-25 11:00:00 | NVDA | Stock | 16.355 | 16.426 | 16.291 | 16.37 | 24889410.0 |
| 2022-11-25 12:00:00 | NVDA | Stock | 16.37 | 16.377 | 16.262 | 16.277 | 27337250.0 |
| 2022-11-25 13:00:00 | NVDA | Stock | 16.249 | 16.295 | 16.249 | 16.271 | 9702350.0 |
| 2022-11-25 14:00:00 | NVDA | Stock | 16.275 | 16.29 | 16.261 | 16.288 | 92910.0 |
| 2022-11-25 15:00:00 | NVDA | Stock | 16.281 | 16.288 | 16.274 | 16.28 | 28440.0 |
| 2022-11-25 16:00:00 | NVDA | Stock | 16.27 | 16.291 | 16.27 | 16.291 | 131010.0 |
| 2022-11-25 04:00:00 | AMZN | Stock | 95.06 | 95.06 | 94.42 | 94.48 | 25693.0 |
| 2022-11-25 05:00:00 | AMZN | Stock | 94.48 | 94.69 | 94.41 | 94.51 | 15970.0 |
| 2022-11-25 06:00:00 | AMZN | Stock | 94.51 | 94.56 | 94.21 | 94.21 | 25585.0 |
| 2022-11-25 07:00:00 | AMZN | Stock | 94.26 | 94.3 | 94.06 | 94.14 | 87247.0 |
| 2022-11-25 08:00:00 | AMZN | Stock | 94.26 | 94.9185 | 93.84 | 93.93 | 241178.0 |
| 2022-11-25 09:00:00 | AMZN | Stock | 93.94 | 94.0 | 93.065 | 93.445 | 5034348.0 |
| 2022-11-25 10:00:00 | AMZN | Stock | 93.45 | 94.3019 | 93.35 | 93.8225 | 7909165.0 |
| 2022-11-25 11:00:00 | AMZN | Stock | 93.83 | 94.43 | 93.37 | 93.675 | 6910421.0 |
| 2022-11-25 12:00:00 | AMZN | Stock | 93.6703 | 94.13 | 93.43 | 93.44 | 7891407.0 |
| 2022-11-25 13:00:00 | AMZN | Stock | 93.475 | 93.7172 | 93.15 | 93.3699 | 3200847.0 |
| 2022-11-25 14:00:00 | AMZN | Stock | 93.37 | 93.7001 | 93.3 | 93.59 | 74565.0 |
> showing 50 of 38,314 rows — these rows as CSV