PREVIEW / stock_30min / 2020-11-06
file: by_date/stock_30min/2020/2020-11-06.parquet size: 1.9 MB rows: 96,711 symbols: 2,501
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-11-06 04:00:00 | AAPL | Stock | 117.77 | 117.77 | 116.71 | 117.04 | 46407.0 |
| 2020-11-06 04:30:00 | AAPL | Stock | 117.05 | 117.13 | 116.7 | 116.76 | 30603.0 |
| 2020-11-06 05:00:00 | AAPL | Stock | 116.77 | 116.84 | 116.54 | 116.7 | 25768.0 |
| 2020-11-06 05:30:00 | AAPL | Stock | 116.69 | 117.03 | 116.6 | 116.81 | 15413.0 |
| 2020-11-06 06:00:00 | AAPL | Stock | 116.98 | 117.43 | 116.98 | 117.18 | 13890.0 |
| 2020-11-06 06:30:00 | AAPL | Stock | 117.16 | 117.34 | 116.9 | 117.1 | 11026.0 |
| 2020-11-06 07:00:00 | AAPL | Stock | 117.04 | 117.58 | 117.0 | 117.2 | 151989.0 |
| 2020-11-06 07:30:00 | AAPL | Stock | 117.23 | 117.26 | 116.96 | 116.96 | 160736.0 |
| 2020-11-06 08:00:00 | AAPL | Stock | 117.32 | 117.58 | 116.79 | 117.16 | 565820.0 |
| 2020-11-06 08:30:00 | AAPL | Stock | 117.17 | 118.2 | 117.16 | 118.1 | 607331.0 |
| 2020-11-06 09:00:00 | AAPL | Stock | 118.16 | 118.46 | 117.56 | 118.3 | 617311.0 |
| 2020-11-06 09:30:00 | AAPL | Stock | 118.32 | 118.64 | 116.13 | 116.29 | 16071265.0 |
| 2020-11-06 10:00:00 | AAPL | Stock | 116.3 | 117.6 | 116.131 | 117.466 | 8471865.0 |
| 2020-11-06 10:30:00 | AAPL | Stock | 117.46 | 117.9 | 117.14 | 117.42 | 6392812.0 |
| 2020-11-06 11:00:00 | AAPL | Stock | 117.414 | 118.14 | 117.308 | 118.13 | 6097951.0 |
| 2020-11-06 11:30:00 | AAPL | Stock | 118.13 | 118.82 | 118.02 | 118.74 | 6014438.0 |
| 2020-11-06 12:00:00 | AAPL | Stock | 118.74 | 119.19 | 118.28 | 118.43 | 6227518.0 |
| 2020-11-06 12:30:00 | AAPL | Stock | 118.435 | 118.97 | 118.435 | 118.884 | 4348130.0 |
| 2020-11-06 13:00:00 | AAPL | Stock | 118.885 | 119.2 | 118.83 | 119.105 | 3708660.0 |
| 2020-11-06 13:30:00 | AAPL | Stock | 119.11 | 119.12 | 118.84 | 119.002 | 2974271.0 |
| 2020-11-06 14:00:00 | AAPL | Stock | 119.0 | 119.17 | 118.85 | 118.89 | 3220088.0 |
| 2020-11-06 14:30:00 | AAPL | Stock | 118.89 | 119.04 | 118.22 | 118.47 | 5290037.0 |
| 2020-11-06 15:00:00 | AAPL | Stock | 118.47 | 118.57 | 118.09 | 118.366 | 5652253.0 |
| 2020-11-06 15:30:00 | AAPL | Stock | 118.365 | 119.06 | 118.26 | 118.685 | 9342788.0 |
| 2020-11-06 16:00:00 | AAPL | Stock | 118.68 | 118.702 | 118.5 | 118.65 | 7913990.0 |
| 2020-11-06 16:30:00 | AAPL | Stock | 118.65 | 118.68 | 118.42 | 118.52 | 57511.0 |
| 2020-11-06 17:00:00 | AAPL | Stock | 118.52 | 118.62 | 118.5 | 118.51 | 51964.0 |
| 2020-11-06 17:30:00 | AAPL | Stock | 118.51 | 118.55 | 118.5 | 118.53 | 36193.0 |
| 2020-11-06 18:00:00 | AAPL | Stock | 118.53 | 118.6 | 118.5 | 118.53 | 24485.0 |
| 2020-11-06 18:30:00 | AAPL | Stock | 118.53 | 118.53 | 118.42 | 118.43 | 38925.0 |
| 2020-11-06 19:00:00 | AAPL | Stock | 118.45 | 118.55 | 118.44 | 118.51 | 28652.0 |
| 2020-11-06 19:30:00 | AAPL | Stock | 118.53 | 118.54 | 118.5 | 118.52 | 74060.0 |
| 2020-11-06 04:00:00 | MSFT | Stock | 221.35 | 221.48 | 220.05 | 220.6 | 7048.0 |
| 2020-11-06 04:30:00 | MSFT | Stock | 220.6 | 220.6 | 219.43 | 219.43 | 5206.0 |
| 2020-11-06 05:00:00 | MSFT | Stock | 219.66 | 219.89 | 219.14 | 219.74 | 7172.0 |
| 2020-11-06 05:30:00 | MSFT | Stock | 219.73 | 220.38 | 219.56 | 220.12 | 4151.0 |
| 2020-11-06 06:00:00 | MSFT | Stock | 220.97 | 220.97 | 220.83 | 220.83 | 821.0 |
| 2020-11-06 06:30:00 | MSFT | Stock | 220.65 | 220.94 | 220.6 | 220.86 | 1686.0 |
| 2020-11-06 07:00:00 | MSFT | Stock | 220.74 | 221.48 | 220.4 | 220.59 | 18571.0 |
| 2020-11-06 07:30:00 | MSFT | Stock | 220.73 | 220.73 | 220.2 | 220.3 | 35384.0 |
| 2020-11-06 08:00:00 | MSFT | Stock | 221.194 | 221.58 | 220.0 | 220.6 | 44341.0 |
| 2020-11-06 08:30:00 | MSFT | Stock | 220.78 | 222.23 | 220.52 | 221.85 | 36277.0 |
| 2020-11-06 09:00:00 | MSFT | Stock | 221.95 | 223.0 | 221.3 | 222.11 | 84104.0 |
| 2020-11-06 09:30:00 | MSFT | Stock | 222.11 | 222.29 | 218.03 | 218.585 | 3564782.0 |
| 2020-11-06 10:00:00 | MSFT | Stock | 218.585 | 220.97 | 218.08 | 220.722 | 1790190.0 |
| 2020-11-06 10:30:00 | MSFT | Stock | 220.69 | 221.41 | 220.36 | 220.547 | 1167215.0 |
| 2020-11-06 11:00:00 | MSFT | Stock | 220.59 | 222.48 | 220.41 | 222.48 | 1069007.0 |
| 2020-11-06 11:30:00 | MSFT | Stock | 222.47 | 223.12 | 222.1 | 222.62 | 1054711.0 |
| 2020-11-06 12:00:00 | MSFT | Stock | 222.6 | 223.36 | 222.22 | 222.25 | 855145.0 |
| 2020-11-06 12:30:00 | MSFT | Stock | 222.25 | 223.14 | 222.23 | 222.98 | 717963.0 |
> showing 50 of 96,711 rows — these rows as CSV