PREVIEW / stock_30min / 2021-10-21
file: by_date/stock_30min/2021/2021-10-21.parquet size: 2.2 MB rows: 109,208 symbols: 2,660
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-21 04:00:00 | AAPL | Stock | 148.92 | 148.99 | 148.75 | 148.8 | 3712.0 |
| 2021-10-21 04:30:00 | AAPL | Stock | 148.82 | 148.83 | 148.78 | 148.83 | 1964.0 |
| 2021-10-21 05:00:00 | AAPL | Stock | 148.87 | 148.9 | 148.87 | 148.88 | 2385.0 |
| 2021-10-21 05:30:00 | AAPL | Stock | 148.89 | 148.95 | 148.89 | 148.95 | 2123.0 |
| 2021-10-21 06:00:00 | AAPL | Stock | 148.93 | 148.96 | 148.92 | 148.93 | 2972.0 |
| 2021-10-21 06:30:00 | AAPL | Stock | 148.88 | 148.98 | 148.85 | 148.85 | 2340.0 |
| 2021-10-21 07:00:00 | AAPL | Stock | 148.85 | 148.95 | 148.81 | 148.85 | 37455.0 |
| 2021-10-21 07:30:00 | AAPL | Stock | 148.85 | 148.86 | 148.61 | 148.65 | 49223.0 |
| 2021-10-21 08:00:00 | AAPL | Stock | 148.6799 | 148.95 | 148.6 | 148.7 | 204324.0 |
| 2021-10-21 08:30:00 | AAPL | Stock | 148.75 | 148.9 | 148.75 | 148.8 | 130920.0 |
| 2021-10-21 09:00:00 | AAPL | Stock | 148.8 | 148.88 | 148.71 | 148.76 | 116256.0 |
| 2021-10-21 09:30:00 | AAPL | Stock | 148.76 | 149.6 | 148.76 | 149.3689 | 6772306.0 |
| 2021-10-21 10:00:00 | AAPL | Stock | 149.36 | 149.62 | 149.12 | 149.515 | 3710528.0 |
| 2021-10-21 10:30:00 | AAPL | Stock | 149.52 | 149.53 | 149.09 | 149.31 | 2756221.0 |
| 2021-10-21 11:00:00 | AAPL | Stock | 149.315 | 149.52 | 149.1 | 149.19 | 2935765.0 |
| 2021-10-21 11:30:00 | AAPL | Stock | 149.195 | 149.3 | 149.11 | 149.273 | 1867899.0 |
| 2021-10-21 12:00:00 | AAPL | Stock | 149.2799 | 149.41 | 147.87 | 148.735 | 8059438.0 |
| 2021-10-21 12:30:00 | AAPL | Stock | 148.735 | 148.755 | 148.33 | 148.57 | 2583901.0 |
| 2021-10-21 13:00:00 | AAPL | Stock | 148.57 | 148.6 | 148.37 | 148.545 | 1478397.0 |
| 2021-10-21 13:30:00 | AAPL | Stock | 148.545 | 148.59 | 148.37 | 148.46 | 1351909.0 |
| 2021-10-21 14:00:00 | AAPL | Stock | 148.46 | 148.72 | 148.37 | 148.695 | 1837439.0 |
| 2021-10-21 14:30:00 | AAPL | Stock | 148.7 | 149.1 | 148.7 | 149.04 | 2360581.0 |
| 2021-10-21 15:00:00 | AAPL | Stock | 149.05 | 149.41 | 149.05 | 149.36 | 3470432.0 |
| 2021-10-21 15:30:00 | AAPL | Stock | 149.36 | 149.64 | 149.315 | 149.46 | 4764559.0 |
| 2021-10-21 16:00:00 | AAPL | Stock | 149.46 | 149.99 | 149.42 | 149.5 | 4492304.0 |
| 2021-10-21 16:30:00 | AAPL | Stock | 149.5 | 149.66 | 149.21 | 149.31 | 78642.0 |
| 2021-10-21 17:00:00 | AAPL | Stock | 149.28 | 149.34 | 149.16 | 149.2 | 47661.0 |
| 2021-10-21 17:30:00 | AAPL | Stock | 149.21 | 149.24 | 149.06 | 149.1899 | 18791.0 |
| 2021-10-21 18:00:00 | AAPL | Stock | 149.1 | 149.27 | 149.1 | 149.24 | 22638.0 |
| 2021-10-21 18:30:00 | AAPL | Stock | 149.22 | 149.37 | 149.18 | 149.19 | 30596.0 |
| 2021-10-21 19:00:00 | AAPL | Stock | 149.17 | 149.32 | 149.14 | 149.2 | 24054.0 |
| 2021-10-21 19:30:00 | AAPL | Stock | 149.24 | 149.33 | 149.14 | 149.15 | 21220.0 |
| 2021-10-21 04:00:00 | MSFT | Stock | 306.84 | 306.89 | 306.72 | 306.72 | 1140.0 |
| 2021-10-21 04:30:00 | MSFT | Stock | 306.51 | 306.81 | 306.51 | 306.81 | 931.0 |
| 2021-10-21 05:30:00 | MSFT | Stock | 307.24 | 307.33 | 307.24 | 307.33 | 1613.0 |
| 2021-10-21 06:00:00 | MSFT | Stock | 307.25 | 307.3 | 307.12 | 307.12 | 319.0 |
| 2021-10-21 06:30:00 | MSFT | Stock | 307.01 | 307.02 | 307.0 | 307.0 | 707.0 |
| 2021-10-21 07:00:00 | MSFT | Stock | 306.91 | 306.92 | 306.91 | 306.92 | 218.0 |
| 2021-10-21 07:30:00 | MSFT | Stock | 306.85 | 306.85 | 306.54 | 306.54 | 818.0 |
| 2021-10-21 08:00:00 | MSFT | Stock | 307.0 | 307.0 | 306.44 | 306.8 | 11892.0 |
| 2021-10-21 08:30:00 | MSFT | Stock | 306.9999 | 307.22 | 306.9999 | 307.01 | 12020.0 |
| 2021-10-21 09:00:00 | MSFT | Stock | 306.86 | 307.68 | 306.65 | 307.05 | 18283.0 |
| 2021-10-21 09:30:00 | MSFT | Stock | 307.1 | 308.75 | 306.36 | 308.0251 | 1537283.0 |
| 2021-10-21 10:00:00 | MSFT | Stock | 308.04 | 308.885 | 307.79 | 308.8788 | 818881.0 |
| 2021-10-21 10:30:00 | MSFT | Stock | 308.86 | 309.2 | 308.17 | 309.005 | 683054.0 |
| 2021-10-21 11:00:00 | MSFT | Stock | 309.01 | 309.38 | 308.27 | 308.29 | 823899.0 |
| 2021-10-21 11:30:00 | MSFT | Stock | 308.27 | 308.96 | 308.12 | 308.82 | 632633.0 |
| 2021-10-21 12:00:00 | MSFT | Stock | 308.8399 | 309.24 | 308.8173 | 309.16 | 572298.0 |
| 2021-10-21 12:30:00 | MSFT | Stock | 309.15 | 309.46 | 308.86 | 309.4491 | 556880.0 |
| 2021-10-21 13:00:00 | MSFT | Stock | 309.42 | 309.61 | 309.24 | 309.5 | 480963.0 |
> showing 50 of 109,208 rows — these rows as CSV