PREVIEW / stock_30min / 2020-12-28
file: by_date/stock_30min/2020/2020-12-28.parquet size: 2.2 MB rows: 115,782 symbols: 2,687
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-12-28 04:00:00 | AAPL | Stock | 132.72 | 132.99 | 132.6 | 132.85 | 10152.0 |
| 2020-12-28 04:30:00 | AAPL | Stock | 132.88 | 133.0 | 132.84 | 132.99 | 9354.0 |
| 2020-12-28 05:00:00 | AAPL | Stock | 133.0 | 133.0 | 132.67 | 132.67 | 12752.0 |
| 2020-12-28 05:30:00 | AAPL | Stock | 132.68 | 132.88 | 132.57 | 132.8 | 15802.0 |
| 2020-12-28 06:00:00 | AAPL | Stock | 132.87 | 132.93 | 132.75 | 132.92 | 5321.0 |
| 2020-12-28 06:30:00 | AAPL | Stock | 132.9 | 132.99 | 132.87 | 132.87 | 6296.0 |
| 2020-12-28 07:00:00 | AAPL | Stock | 132.88 | 133.6 | 132.81 | 133.54 | 275417.0 |
| 2020-12-28 07:30:00 | AAPL | Stock | 133.55 | 133.65 | 133.5 | 133.65 | 93162.0 |
| 2020-12-28 08:00:00 | AAPL | Stock | 133.18 | 133.77 | 132.915 | 133.65 | 504102.0 |
| 2020-12-28 08:30:00 | AAPL | Stock | 133.66 | 134.0 | 133.61 | 133.98 | 459280.0 |
| 2020-12-28 09:00:00 | AAPL | Stock | 133.99 | 134.14 | 133.74 | 133.98 | 419790.0 |
| 2020-12-28 09:30:00 | AAPL | Stock | 133.99 | 135.74 | 133.51 | 135.44 | 21257039.0 |
| 2020-12-28 10:00:00 | AAPL | Stock | 135.43 | 135.53 | 134.15 | 134.918 | 10296784.0 |
| 2020-12-28 10:30:00 | AAPL | Stock | 134.92 | 135.58 | 134.86 | 134.975 | 7101927.0 |
| 2020-12-28 11:00:00 | AAPL | Stock | 134.98 | 136.0 | 134.95 | 135.79 | 7678016.0 |
| 2020-12-28 11:30:00 | AAPL | Stock | 135.79 | 136.39 | 135.77 | 136.29 | 7772851.0 |
| 2020-12-28 12:00:00 | AAPL | Stock | 136.29 | 136.4 | 135.79 | 136.075 | 6032979.0 |
| 2020-12-28 12:30:00 | AAPL | Stock | 136.08 | 136.35 | 135.97 | 136.309 | 4792547.0 |
| 2020-12-28 13:00:00 | AAPL | Stock | 136.31 | 136.44 | 136.04 | 136.247 | 4773655.0 |
| 2020-12-28 13:30:00 | AAPL | Stock | 136.25 | 136.269 | 135.985 | 136.155 | 3180661.0 |
| 2020-12-28 14:00:00 | AAPL | Stock | 136.155 | 136.77 | 136.15 | 136.745 | 5960753.0 |
| 2020-12-28 14:30:00 | AAPL | Stock | 136.745 | 136.98 | 136.67 | 136.885 | 5145249.0 |
| 2020-12-28 15:00:00 | AAPL | Stock | 136.885 | 137.34 | 136.72 | 136.845 | 7439243.0 |
| 2020-12-28 15:30:00 | AAPL | Stock | 136.845 | 136.99 | 136.34 | 136.73 | 10535035.0 |
| 2020-12-28 16:00:00 | AAPL | Stock | 136.73 | 136.9 | 136.67 | 136.84 | 6551765.0 |
| 2020-12-28 16:30:00 | AAPL | Stock | 136.83 | 137.25 | 136.69 | 137.07 | 235009.0 |
| 2020-12-28 17:00:00 | AAPL | Stock | 137.05 | 137.24 | 136.69 | 137.08 | 216263.0 |
| 2020-12-28 17:30:00 | AAPL | Stock | 137.06 | 137.12 | 137.0 | 137.03 | 72023.0 |
| 2020-12-28 18:00:00 | AAPL | Stock | 137.05 | 137.18 | 136.69 | 136.95 | 268696.0 |
| 2020-12-28 18:30:00 | AAPL | Stock | 136.95 | 137.03 | 136.91 | 137.0 | 49415.0 |
| 2020-12-28 19:00:00 | AAPL | Stock | 136.98 | 137.15 | 136.96 | 136.99 | 48067.0 |
| 2020-12-28 19:30:00 | AAPL | Stock | 137.0 | 137.2 | 136.92 | 137.2 | 124952.0 |
| 2020-12-28 04:00:00 | MSFT | Stock | 223.44 | 223.98 | 223.44 | 223.98 | 1218.0 |
| 2020-12-28 04:30:00 | MSFT | Stock | 223.98 | 223.98 | 223.98 | 223.98 | 523.0 |
| 2020-12-28 05:00:00 | MSFT | Stock | 223.96 | 223.96 | 223.9 | 223.9 | 321.0 |
| 2020-12-28 05:30:00 | MSFT | Stock | 223.96 | 223.97 | 223.77 | 223.95 | 2189.0 |
| 2020-12-28 06:00:00 | MSFT | Stock | 223.96 | 223.98 | 223.9 | 223.95 | 2170.0 |
| 2020-12-28 06:30:00 | MSFT | Stock | 223.91 | 223.91 | 222.9 | 223.3 | 5195.0 |
| 2020-12-28 07:00:00 | MSFT | Stock | 223.0 | 223.85 | 223.0 | 223.8 | 10030.0 |
| 2020-12-28 07:30:00 | MSFT | Stock | 223.79 | 224.36 | 223.76 | 224.36 | 10159.0 |
| 2020-12-28 08:00:00 | MSFT | Stock | 224.21 | 224.5 | 222.2 | 224.4 | 22082.0 |
| 2020-12-28 08:30:00 | MSFT | Stock | 224.31 | 224.45 | 224.13 | 224.4 | 7428.0 |
| 2020-12-28 09:00:00 | MSFT | Stock | 224.45 | 224.5 | 224.14 | 224.32 | 13870.0 |
| 2020-12-28 09:30:00 | MSFT | Stock | 224.45 | 224.55 | 223.15 | 223.74 | 1544848.0 |
| 2020-12-28 10:00:00 | MSFT | Stock | 223.75 | 224.2 | 223.02 | 223.98 | 1112456.0 |
| 2020-12-28 10:30:00 | MSFT | Stock | 223.98 | 226.03 | 223.95 | 225.922 | 1974363.0 |
| 2020-12-28 11:00:00 | MSFT | Stock | 225.93 | 225.95 | 225.152 | 225.435 | 1036835.0 |
| 2020-12-28 11:30:00 | MSFT | Stock | 225.43 | 225.48 | 224.81 | 225.165 | 702271.0 |
| 2020-12-28 12:00:00 | MSFT | Stock | 225.17 | 225.32 | 224.83 | 225.13 | 573929.0 |
| 2020-12-28 12:30:00 | MSFT | Stock | 225.137 | 225.4 | 224.89 | 225.24 | 647127.0 |
> showing 50 of 115,782 rows — these rows as CSV