PREVIEW / stock_1hour / 2021-10-29
file: by_date/stock_1hour/2021/2021-10-29.parquet size: 1.5 MB rows: 66,187 symbols: 2,695
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-29 04:00:00 | AAPL | Stock | 147.0 | 147.74 | 146.73 | 147.6 | 109316.0 |
| 2021-10-29 05:00:00 | AAPL | Stock | 147.59 | 147.73 | 147.21 | 147.51 | 30543.0 |
| 2021-10-29 06:00:00 | AAPL | Stock | 147.5 | 147.56 | 146.5 | 147.24 | 72725.0 |
| 2021-10-29 07:00:00 | AAPL | Stock | 147.28 | 147.5 | 146.95 | 147.3 | 337536.0 |
| 2021-10-29 08:00:00 | AAPL | Stock | 147.1101 | 147.48 | 146.8 | 147.2 | 1225374.0 |
| 2021-10-29 09:00:00 | AAPL | Stock | 147.2 | 148.7 | 146.4128 | 147.125 | 23183193.0 |
| 2021-10-29 10:00:00 | AAPL | Stock | 147.13 | 147.82 | 146.91 | 147.26 | 15595955.0 |
| 2021-10-29 11:00:00 | AAPL | Stock | 147.255 | 148.64 | 147.02 | 148.32 | 11261079.0 |
| 2021-10-29 12:00:00 | AAPL | Stock | 148.315 | 149.505 | 148.285 | 149.375 | 12572191.0 |
| 2021-10-29 13:00:00 | AAPL | Stock | 149.38 | 149.5 | 148.61 | 148.685 | 6812796.0 |
| 2021-10-29 14:00:00 | AAPL | Stock | 148.68 | 149.31 | 148.54 | 149.15 | 7478052.0 |
| 2021-10-29 15:00:00 | AAPL | Stock | 149.155 | 149.94 | 148.98 | 149.8 | 14653564.0 |
| 2021-10-29 16:00:00 | AAPL | Stock | 149.75 | 149.9 | 149.65 | 149.8 | 11129167.0 |
| 2021-10-29 17:00:00 | AAPL | Stock | 149.82 | 149.94 | 149.8 | 149.9 | 101985.0 |
| 2021-10-29 18:00:00 | AAPL | Stock | 149.88 | 149.9 | 149.81 | 149.84 | 50213.0 |
| 2021-10-29 19:00:00 | AAPL | Stock | 149.84 | 149.96 | 149.83 | 149.9201 | 44721.0 |
| 2021-10-29 04:00:00 | MSFT | Stock | 325.07 | 325.07 | 323.81 | 324.54 | 6230.0 |
| 2021-10-29 05:00:00 | MSFT | Stock | 324.99 | 324.99 | 324.02 | 324.34 | 9932.0 |
| 2021-10-29 06:00:00 | MSFT | Stock | 324.72 | 324.72 | 323.37 | 324.01 | 5606.0 |
| 2021-10-29 07:00:00 | MSFT | Stock | 324.0 | 324.46 | 323.65 | 324.21 | 31732.0 |
| 2021-10-29 08:00:00 | MSFT | Stock | 324.2877 | 325.18 | 323.8 | 324.5 | 62101.0 |
| 2021-10-29 09:00:00 | MSFT | Stock | 324.6 | 327.88 | 323.5 | 325.41 | 3920686.0 |
| 2021-10-29 10:00:00 | MSFT | Stock | 325.3801 | 329.52 | 325.0501 | 327.86 | 3234115.0 |
| 2021-10-29 11:00:00 | MSFT | Stock | 327.85 | 328.77 | 327.32 | 327.49 | 2380759.0 |
| 2021-10-29 12:00:00 | MSFT | Stock | 327.49 | 329.185 | 327.23 | 329.185 | 2003976.0 |
| 2021-10-29 13:00:00 | MSFT | Stock | 329.19 | 330.35 | 329.08 | 330.12 | 2107288.0 |
| 2021-10-29 14:00:00 | MSFT | Stock | 330.12 | 330.65 | 329.82 | 329.98 | 2169527.0 |
| 2021-10-29 15:00:00 | MSFT | Stock | 329.9952 | 332.0 | 329.74 | 331.62 | 4231529.0 |
| 2021-10-29 16:00:00 | MSFT | Stock | 331.62 | 331.99 | 330.8 | 331.8 | 6009913.0 |
| 2021-10-29 17:00:00 | MSFT | Stock | 331.85 | 331.85 | 331.62 | 331.85 | 225711.0 |
| 2021-10-29 18:00:00 | MSFT | Stock | 331.85 | 331.99 | 331.74 | 331.86 | 5450.0 |
| 2021-10-29 19:00:00 | MSFT | Stock | 331.86 | 332.0 | 331.76 | 331.76 | 9795.0 |
| 2021-10-29 04:00:00 | NVDA | Stock | 25.131 | 25.248 | 25.041 | 25.2 | 85200.0 |
| 2021-10-29 05:00:00 | NVDA | Stock | 25.221 | 25.223 | 25.087 | 25.11 | 64250.0 |
| 2021-10-29 06:00:00 | NVDA | Stock | 25.105 | 25.11 | 24.94 | 25.018 | 303890.0 |
| 2021-10-29 07:00:00 | NVDA | Stock | 25.018 | 25.07 | 24.95 | 25.05 | 344920.0 |
| 2021-10-29 08:00:00 | NVDA | Stock | 25.0 | 25.105 | 24.95 | 25.01 | 1073190.0 |
| 2021-10-29 09:00:00 | NVDA | Stock | 25.041 | 25.45 | 25.0 | 25.399 | 41065350.0 |
| 2021-10-29 10:00:00 | NVDA | Stock | 25.4 | 25.495 | 25.1532 | 25.213 | 34371890.0 |
| 2021-10-29 11:00:00 | NVDA | Stock | 25.221 | 25.461 | 25.207 | 25.4443 | 16523630.0 |
| 2021-10-29 12:00:00 | NVDA | Stock | 25.445 | 25.562 | 25.435 | 25.552 | 23755780.0 |
| 2021-10-29 13:00:00 | NVDA | Stock | 25.5526 | 25.655 | 25.51 | 25.621 | 24212260.0 |
| 2021-10-29 14:00:00 | NVDA | Stock | 25.621 | 25.709 | 25.467 | 25.588 | 26744280.0 |
| 2021-10-29 15:00:00 | NVDA | Stock | 25.588 | 25.598 | 25.442 | 25.568 | 29862090.0 |
| 2021-10-29 16:00:00 | NVDA | Stock | 25.567 | 25.599 | 25.2453 | 25.572 | 30357270.0 |
| 2021-10-29 17:00:00 | NVDA | Stock | 25.573 | 25.577 | 25.563 | 25.577 | 135110.0 |
| 2021-10-29 18:00:00 | NVDA | Stock | 25.584 | 25.594 | 25.567 | 25.582 | 183990.0 |
| 2021-10-29 19:00:00 | NVDA | Stock | 25.581 | 25.603 | 25.57 | 25.603 | 134730.0 |
| 2021-10-29 04:00:00 | AMZN | Stock | 165.24 | 165.24 | 164.0 | 164.25 | 77800.0 |
| 2021-10-29 05:00:00 | AMZN | Stock | 164.303 | 164.3135 | 164.0 | 164.0 | 140040.0 |
> showing 50 of 66,187 rows — these rows as CSV