PREVIEW / stock_30min / 2020-10-28
file: by_date/stock_30min/2020/2020-10-28.parquet size: 2.0 MB rows: 101,796 symbols: 2,523
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 |
|---|---|---|---|---|---|---|---|
| 2020-10-28 04:00:00 | AAPL | Stock | 115.9 | 116.25 | 115.21 | 115.38 | 26570.0 |
| 2020-10-28 04:30:00 | AAPL | Stock | 115.32 | 115.6 | 115.2 | 115.6 | 38873.0 |
| 2020-10-28 05:00:00 | AAPL | Stock | 115.54 | 115.87 | 115.45 | 115.55 | 34169.0 |
| 2020-10-28 05:30:00 | AAPL | Stock | 115.43 | 115.72 | 115.34 | 115.56 | 21369.0 |
| 2020-10-28 06:00:00 | AAPL | Stock | 115.62 | 115.75 | 115.16 | 115.18 | 23406.0 |
| 2020-10-28 06:30:00 | AAPL | Stock | 115.29 | 115.82 | 115.13 | 115.17 | 25348.0 |
| 2020-10-28 07:00:00 | AAPL | Stock | 115.28 | 115.7 | 115.13 | 115.55 | 150404.0 |
| 2020-10-28 07:30:00 | AAPL | Stock | 115.48 | 115.54 | 115.15 | 115.2 | 87098.0 |
| 2020-10-28 08:00:00 | AAPL | Stock | 115.5 | 116.89 | 114.75 | 114.89 | 286412.0 |
| 2020-10-28 08:30:00 | AAPL | Stock | 114.847 | 116.06 | 114.51 | 114.88 | 311939.0 |
| 2020-10-28 09:00:00 | AAPL | Stock | 114.88 | 115.19 | 114.68 | 115.04 | 355942.0 |
| 2020-10-28 09:30:00 | AAPL | Stock | 115.04 | 115.43 | 112.44 | 112.98 | 16021194.0 |
| 2020-10-28 10:00:00 | AAPL | Stock | 112.99 | 113.12 | 111.95 | 112.38 | 11874583.0 |
| 2020-10-28 10:30:00 | AAPL | Stock | 112.37 | 112.87 | 112.1 | 112.535 | 8471500.0 |
| 2020-10-28 11:00:00 | AAPL | Stock | 112.53 | 112.65 | 112.05 | 112.2 | 7229037.0 |
| 2020-10-28 11:30:00 | AAPL | Stock | 112.2 | 113.07 | 112.0 | 112.91 | 7776407.0 |
| 2020-10-28 12:00:00 | AAPL | Stock | 112.9 | 113.37 | 112.83 | 112.96 | 6630306.0 |
| 2020-10-28 12:30:00 | AAPL | Stock | 112.965 | 113.18 | 112.5 | 112.51 | 4945611.0 |
| 2020-10-28 13:00:00 | AAPL | Stock | 112.5 | 112.65 | 112.05 | 112.54 | 5641787.0 |
| 2020-10-28 13:30:00 | AAPL | Stock | 112.54 | 113.24 | 112.42 | 113.178 | 5587639.0 |
| 2020-10-28 14:00:00 | AAPL | Stock | 113.175 | 113.26 | 112.6 | 113.245 | 5714830.0 |
| 2020-10-28 14:30:00 | AAPL | Stock | 113.243 | 113.38 | 112.48 | 112.91 | 6125074.0 |
| 2020-10-28 15:00:00 | AAPL | Stock | 112.91 | 113.07 | 112.5 | 112.725 | 5708313.0 |
| 2020-10-28 15:30:00 | AAPL | Stock | 112.725 | 113.2 | 111.1 | 111.15 | 16483928.0 |
| 2020-10-28 16:00:00 | AAPL | Stock | 111.15 | 111.9 | 111.13 | 111.75 | 12639670.0 |
| 2020-10-28 16:30:00 | AAPL | Stock | 111.73 | 111.91 | 111.59 | 111.7 | 248936.0 |
| 2020-10-28 17:00:00 | AAPL | Stock | 111.74 | 111.87 | 111.2 | 111.84 | 133375.0 |
| 2020-10-28 17:30:00 | AAPL | Stock | 111.83 | 112.0 | 111.8 | 111.99 | 113156.0 |
| 2020-10-28 18:00:00 | AAPL | Stock | 111.98 | 112.0 | 111.77 | 111.96 | 95092.0 |
| 2020-10-28 18:30:00 | AAPL | Stock | 111.96 | 112.18 | 111.94 | 112.13 | 111887.0 |
| 2020-10-28 19:00:00 | AAPL | Stock | 112.14 | 112.2 | 111.88 | 111.9 | 84377.0 |
| 2020-10-28 19:30:00 | AAPL | Stock | 111.93 | 112.1 | 111.9 | 112.09 | 109297.0 |
| 2020-10-28 04:00:00 | MSFT | Stock | 209.82 | 210.5 | 209.01 | 209.3 | 16986.0 |
| 2020-10-28 04:30:00 | MSFT | Stock | 209.28 | 209.96 | 209.28 | 209.89 | 3177.0 |
| 2020-10-28 05:00:00 | MSFT | Stock | 209.83 | 210.27 | 209.52 | 209.72 | 6028.0 |
| 2020-10-28 05:30:00 | MSFT | Stock | 209.61 | 209.89 | 209.6 | 209.8 | 4194.0 |
| 2020-10-28 06:00:00 | MSFT | Stock | 209.8 | 209.82 | 209.01 | 209.03 | 4108.0 |
| 2020-10-28 06:30:00 | MSFT | Stock | 209.03 | 209.44 | 208.7 | 209.04 | 6138.0 |
| 2020-10-28 07:00:00 | MSFT | Stock | 209.0 | 209.5 | 208.88 | 209.15 | 43564.0 |
| 2020-10-28 07:30:00 | MSFT | Stock | 209.11 | 209.19 | 208.53 | 208.53 | 37620.0 |
| 2020-10-28 08:00:00 | MSFT | Stock | 209.09 | 209.5 | 208.04 | 208.397 | 121413.0 |
| 2020-10-28 08:30:00 | MSFT | Stock | 208.35 | 210.13 | 207.0 | 207.41 | 165267.0 |
| 2020-10-28 09:00:00 | MSFT | Stock | 207.41 | 207.7 | 206.6 | 207.6 | 299777.0 |
| 2020-10-28 09:30:00 | MSFT | Stock | 207.6 | 208.84 | 205.33 | 206.165 | 6421752.0 |
| 2020-10-28 10:00:00 | MSFT | Stock | 206.14 | 206.26 | 204.4 | 204.89 | 3908391.0 |
| 2020-10-28 10:30:00 | MSFT | Stock | 204.842 | 206.64 | 204.42 | 205.07 | 3737303.0 |
| 2020-10-28 11:00:00 | MSFT | Stock | 205.05 | 205.73 | 204.49 | 204.94 | 2487954.0 |
| 2020-10-28 11:30:00 | MSFT | Stock | 204.92 | 205.88 | 204.58 | 205.265 | 2004396.0 |
| 2020-10-28 12:00:00 | MSFT | Stock | 205.26 | 205.54 | 204.9 | 205.03 | 1534551.0 |
| 2020-10-28 12:30:00 | MSFT | Stock | 205.03 | 205.28 | 204.6 | 204.7 | 1385694.0 |
> showing 50 of 101,796 rows — these rows as CSV