PREVIEW / stock_30min / 2021-11-12
file: by_date/stock_30min/2021/2021-11-12.parquet size: 2.3 MB rows: 114,335 symbols: 2,706
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-11-12 04:00:00 | AAPL | Stock | 148.26 | 148.32 | 147.95 | 147.95 | 4375.0 |
| 2021-11-12 04:30:00 | AAPL | Stock | 147.99 | 148.08 | 147.95 | 148.01 | 2606.0 |
| 2021-11-12 05:00:00 | AAPL | Stock | 148.04 | 148.08 | 148.01 | 148.03 | 2819.0 |
| 2021-11-12 05:30:00 | AAPL | Stock | 148.03 | 148.05 | 148.0 | 148.05 | 2318.0 |
| 2021-11-12 06:00:00 | AAPL | Stock | 148.09 | 148.09 | 148.05 | 148.05 | 1561.0 |
| 2021-11-12 06:30:00 | AAPL | Stock | 148.12 | 148.18 | 148.1 | 148.17 | 4975.0 |
| 2021-11-12 07:00:00 | AAPL | Stock | 148.23 | 148.3 | 148.12 | 148.18 | 21557.0 |
| 2021-11-12 07:30:00 | AAPL | Stock | 148.16 | 148.25 | 148.13 | 148.18 | 21169.0 |
| 2021-11-12 08:00:00 | AAPL | Stock | 148.16 | 148.35 | 147.501 | 148.34 | 108380.0 |
| 2021-11-12 08:30:00 | AAPL | Stock | 148.34 | 148.39 | 148.3 | 148.35 | 64185.0 |
| 2021-11-12 09:00:00 | AAPL | Stock | 148.36 | 148.63 | 147.87 | 148.42 | 415917.0 |
| 2021-11-12 09:30:00 | AAPL | Stock | 148.43 | 148.5 | 147.48 | 147.98 | 5359052.0 |
| 2021-11-12 10:00:00 | AAPL | Stock | 147.99 | 148.355 | 147.77 | 148.25 | 3243658.0 |
| 2021-11-12 10:30:00 | AAPL | Stock | 148.26 | 148.7779 | 148.12 | 148.57 | 2968568.0 |
| 2021-11-12 11:00:00 | AAPL | Stock | 148.57 | 150.055 | 148.52 | 149.945 | 6749588.0 |
| 2021-11-12 11:30:00 | AAPL | Stock | 149.95 | 150.09 | 149.655 | 149.8 | 3617299.0 |
| 2021-11-12 12:00:00 | AAPL | Stock | 149.805 | 149.88 | 149.61 | 149.7901 | 2029341.0 |
| 2021-11-12 12:30:00 | AAPL | Stock | 149.79 | 149.83 | 149.55 | 149.575 | 1737330.0 |
| 2021-11-12 13:00:00 | AAPL | Stock | 149.575 | 149.7699 | 149.292 | 149.69 | 2074155.0 |
| 2021-11-12 13:30:00 | AAPL | Stock | 149.7 | 149.96 | 149.675 | 149.94 | 2042388.0 |
| 2021-11-12 14:00:00 | AAPL | Stock | 149.935 | 150.03 | 149.75 | 149.76 | 1951167.0 |
| 2021-11-12 14:30:00 | AAPL | Stock | 149.76 | 150.02 | 149.74 | 149.9 | 1530626.0 |
| 2021-11-12 15:00:00 | AAPL | Stock | 149.9 | 150.19 | 149.75 | 150.175 | 2585416.0 |
| 2021-11-12 15:30:00 | AAPL | Stock | 150.18 | 150.4 | 149.845 | 149.99 | 5317845.0 |
| 2021-11-12 16:00:00 | AAPL | Stock | 149.99 | 150.06 | 149.95 | 150.06 | 6454845.0 |
| 2021-11-12 16:30:00 | AAPL | Stock | 150.03 | 150.03 | 149.96 | 149.99 | 90858.0 |
| 2021-11-12 17:00:00 | AAPL | Stock | 150.0 | 150.0 | 149.99 | 150.0 | 12271.0 |
| 2021-11-12 17:30:00 | AAPL | Stock | 149.99 | 150.0 | 149.97 | 149.98 | 62445.0 |
| 2021-11-12 18:00:00 | AAPL | Stock | 150.0 | 150.0 | 149.95 | 149.95 | 9884.0 |
| 2021-11-12 18:30:00 | AAPL | Stock | 149.99 | 149.99 | 149.87 | 149.94 | 11264.0 |
| 2021-11-12 19:00:00 | AAPL | Stock | 149.96 | 149.97 | 149.92 | 149.95 | 4447.0 |
| 2021-11-12 19:30:00 | AAPL | Stock | 149.95 | 149.98 | 149.73 | 149.73 | 50808.0 |
| 2021-11-12 04:00:00 | MSFT | Stock | 333.86 | 333.86 | 333.5 | 333.5 | 3223.0 |
| 2021-11-12 04:30:00 | MSFT | Stock | 333.05 | 333.1 | 333.02 | 333.1 | 1141.0 |
| 2021-11-12 05:30:00 | MSFT | Stock | 333.57 | 333.57 | 333.57 | 333.57 | 250.0 |
| 2021-11-12 06:00:00 | MSFT | Stock | 333.5 | 333.5 | 333.5 | 333.5 | 289.0 |
| 2021-11-12 06:30:00 | MSFT | Stock | 333.5 | 333.96 | 333.5 | 333.73 | 888.0 |
| 2021-11-12 07:00:00 | MSFT | Stock | 333.9 | 333.9 | 333.4 | 333.6 | 3016.0 |
| 2021-11-12 07:30:00 | MSFT | Stock | 333.65 | 333.85 | 333.44 | 333.47 | 4788.0 |
| 2021-11-12 08:00:00 | MSFT | Stock | 333.5108 | 333.9386 | 333.3 | 333.75 | 14285.0 |
| 2021-11-12 08:30:00 | MSFT | Stock | 333.75 | 334.0 | 333.69 | 333.809 | 14981.0 |
| 2021-11-12 09:00:00 | MSFT | Stock | 333.9837 | 334.5 | 332.43 | 333.82 | 114067.0 |
| 2021-11-12 09:30:00 | MSFT | Stock | 333.81 | 335.62 | 333.79 | 334.42 | 1448188.0 |
| 2021-11-12 10:00:00 | MSFT | Stock | 334.39 | 335.366 | 334.21 | 334.7701 | 751278.0 |
| 2021-11-12 10:30:00 | MSFT | Stock | 334.78 | 335.45 | 334.34 | 335.36 | 594083.0 |
| 2021-11-12 11:00:00 | MSFT | Stock | 335.39 | 336.717 | 335.07 | 336.58 | 1544790.0 |
| 2021-11-12 11:30:00 | MSFT | Stock | 336.6 | 336.97 | 336.2262 | 336.67 | 755292.0 |
| 2021-11-12 12:00:00 | MSFT | Stock | 336.69 | 336.97 | 336.52 | 336.81 | 620025.0 |
| 2021-11-12 12:30:00 | MSFT | Stock | 336.82 | 336.97 | 336.4 | 336.68 | 440248.0 |
| 2021-11-12 13:00:00 | MSFT | Stock | 336.6816 | 336.69 | 336.24 | 336.57 | 401862.0 |
> showing 50 of 114,335 rows — these rows as CSV