PREVIEW / stock_1hour / 2022-12-30
file: by_date/stock_1hour/2022/2022-12-30.parquet size: 1.4 MB rows: 62,146 symbols: 1,975
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-12-30 04:00:00 | AAPL | Stock | 129.0 | 129.19 | 128.75 | 129.1 | 27873.0 |
| 2022-12-30 05:00:00 | AAPL | Stock | 129.1 | 129.18 | 128.85 | 129.14 | 15218.0 |
| 2022-12-30 06:00:00 | AAPL | Stock | 129.17 | 129.19 | 129.09 | 129.15 | 5826.0 |
| 2022-12-30 07:00:00 | AAPL | Stock | 129.17 | 129.22 | 128.4 | 128.47 | 44393.0 |
| 2022-12-30 08:00:00 | AAPL | Stock | 128.8583 | 129.72 | 127.84 | 128.19 | 304956.0 |
| 2022-12-30 09:00:00 | AAPL | Stock | 128.19 | 128.69 | 127.48 | 127.8801 | 7794484.0 |
| 2022-12-30 10:00:00 | AAPL | Stock | 127.881 | 129.25 | 127.43 | 128.8375 | 10749081.0 |
| 2022-12-30 11:00:00 | AAPL | Stock | 128.833 | 129.05 | 128.08 | 128.995 | 7707254.0 |
| 2022-12-30 12:00:00 | AAPL | Stock | 128.995 | 129.08 | 128.635 | 128.955 | 4644317.0 |
| 2022-12-30 13:00:00 | AAPL | Stock | 128.96 | 128.965 | 128.02 | 128.375 | 5848130.0 |
| 2022-12-30 14:00:00 | AAPL | Stock | 128.38 | 128.395 | 127.97 | 128.28 | 5421700.0 |
| 2022-12-30 15:00:00 | AAPL | Stock | 128.28 | 129.95 | 128.255 | 129.91 | 14810290.0 |
| 2022-12-30 16:00:00 | AAPL | Stock | 129.91 | 130.05 | 129.78 | 129.99 | 10339290.0 |
| 2022-12-30 17:00:00 | AAPL | Stock | 130.0 | 130.05 | 129.91 | 129.9487 | 66762.0 |
| 2022-12-30 18:00:00 | AAPL | Stock | 129.95 | 130.05 | 129.94 | 130.01 | 29132.0 |
| 2022-12-30 19:00:00 | AAPL | Stock | 129.99 | 130.04 | 129.97 | 129.97 | 34380.0 |
| 2022-12-30 04:00:00 | MSFT | Stock | 240.0 | 240.0 | 238.87 | 239.54 | 9670.0 |
| 2022-12-30 05:00:00 | MSFT | Stock | 239.81 | 240.48 | 239.69 | 240.01 | 2240.0 |
| 2022-12-30 06:00:00 | MSFT | Stock | 239.79 | 239.9 | 239.79 | 239.9 | 566.0 |
| 2022-12-30 07:00:00 | MSFT | Stock | 239.62 | 239.7 | 238.61 | 238.8 | 12031.0 |
| 2022-12-30 08:00:00 | MSFT | Stock | 239.6 | 239.7399 | 238.2 | 238.5 | 21240.0 |
| 2022-12-30 09:00:00 | MSFT | Stock | 238.5 | 238.94 | 236.66 | 238.025 | 1751660.0 |
| 2022-12-30 10:00:00 | MSFT | Stock | 238.0101 | 239.03 | 237.16 | 237.99 | 1823083.0 |
| 2022-12-30 11:00:00 | MSFT | Stock | 237.99 | 238.95 | 237.5 | 238.8662 | 1377177.0 |
| 2022-12-30 12:00:00 | MSFT | Stock | 238.86 | 239.39 | 238.4 | 239.22 | 1200576.0 |
| 2022-12-30 13:00:00 | MSFT | Stock | 239.23 | 239.24 | 237.3 | 237.5899 | 1577103.0 |
| 2022-12-30 14:00:00 | MSFT | Stock | 237.61 | 237.795 | 237.03 | 237.71 | 1281824.0 |
| 2022-12-30 15:00:00 | MSFT | Stock | 237.7 | 239.96 | 237.67 | 239.83 | 3733262.0 |
| 2022-12-30 16:00:00 | MSFT | Stock | 239.83 | 240.46 | 239.71 | 239.9498 | 5034596.0 |
| 2022-12-30 17:00:00 | MSFT | Stock | 239.9 | 239.92 | 239.8 | 239.89 | 1850.0 |
| 2022-12-30 18:00:00 | MSFT | Stock | 239.93 | 240.0 | 239.86 | 240.0 | 2211.0 |
| 2022-12-30 19:00:00 | MSFT | Stock | 240.0 | 240.2 | 239.92 | 240.2 | 2864.0 |
| 2022-12-30 04:00:00 | NVDA | Stock | 14.551 | 14.551 | 14.409 | 14.5 | 132700.0 |
| 2022-12-30 05:00:00 | NVDA | Stock | 14.51 | 14.56 | 14.508 | 14.56 | 51360.0 |
| 2022-12-30 06:00:00 | NVDA | Stock | 14.518 | 14.52 | 14.5 | 14.5 | 25660.0 |
| 2022-12-30 07:00:00 | NVDA | Stock | 14.49 | 14.49 | 14.377 | 14.38 | 275200.0 |
| 2022-12-30 08:00:00 | NVDA | Stock | 14.4711 | 14.499 | 14.315 | 14.351 | 689650.0 |
| 2022-12-30 09:00:00 | NVDA | Stock | 14.352 | 14.457 | 14.233 | 14.432 | 47804370.0 |
| 2022-12-30 10:00:00 | NVDA | Stock | 14.432 | 14.48 | 14.336 | 14.3965 | 53162840.0 |
| 2022-12-30 11:00:00 | NVDA | Stock | 14.395 | 14.4755 | 14.338 | 14.4652 | 29600210.0 |
| 2022-12-30 12:00:00 | NVDA | Stock | 14.467 | 14.517 | 14.4255 | 14.496 | 21028000.0 |
| 2022-12-30 13:00:00 | NVDA | Stock | 14.498 | 14.499 | 14.362 | 14.417 | 21429830.0 |
| 2022-12-30 14:00:00 | NVDA | Stock | 14.419 | 14.428 | 14.365 | 14.405 | 18406160.0 |
| 2022-12-30 15:00:00 | NVDA | Stock | 14.407 | 14.629 | 14.4033 | 14.6145 | 47243100.0 |
| 2022-12-30 16:00:00 | NVDA | Stock | 14.614 | 14.675 | 14.59 | 14.6238 | 25709390.0 |
| 2022-12-30 17:00:00 | NVDA | Stock | 14.63 | 14.642 | 14.623 | 14.633 | 93810.0 |
| 2022-12-30 18:00:00 | NVDA | Stock | 14.639 | 14.64 | 14.632 | 14.636 | 66920.0 |
| 2022-12-30 19:00:00 | NVDA | Stock | 14.636 | 14.648 | 14.636 | 14.64 | 95550.0 |
| 2022-12-30 04:00:00 | AMZN | Stock | 83.78 | 83.98 | 83.5 | 83.77 | 20256.0 |
| 2022-12-30 05:00:00 | AMZN | Stock | 83.98 | 84.0 | 83.83 | 83.87 | 9604.0 |
> showing 50 of 62,146 rows — these rows as CSV