PREVIEW / stock_30min / 2020-11-11
file: by_date/stock_30min/2020/2020-11-11.parquet size: 2.0 MB rows: 97,847 symbols: 2,514
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-11 04:00:00 | AAPL | Stock | 117.67 | 117.67 | 117.02 | 117.2 | 28871.0 |
| 2020-11-11 04:30:00 | AAPL | Stock | 117.19 | 117.46 | 116.85 | 117.16 | 22272.0 |
| 2020-11-11 05:00:00 | AAPL | Stock | 117.16 | 117.2 | 117.03 | 117.15 | 6221.0 |
| 2020-11-11 05:30:00 | AAPL | Stock | 117.15 | 117.2 | 116.66 | 117.17 | 14775.0 |
| 2020-11-11 06:00:00 | AAPL | Stock | 117.17 | 117.5 | 117.09 | 117.36 | 26713.0 |
| 2020-11-11 06:30:00 | AAPL | Stock | 117.37 | 117.4 | 116.85 | 117.2 | 22314.0 |
| 2020-11-11 07:00:00 | AAPL | Stock | 117.18 | 117.4 | 116.95 | 117.33 | 199640.0 |
| 2020-11-11 07:30:00 | AAPL | Stock | 117.31 | 117.61 | 117.21 | 117.54 | 149390.0 |
| 2020-11-11 08:00:00 | AAPL | Stock | 117.1 | 117.91 | 116.93 | 117.55 | 404334.0 |
| 2020-11-11 08:30:00 | AAPL | Stock | 117.55 | 117.55 | 117.1 | 117.331 | 243288.0 |
| 2020-11-11 09:00:00 | AAPL | Stock | 117.4 | 117.45 | 117.16 | 117.19 | 245670.0 |
| 2020-11-11 09:30:00 | AAPL | Stock | 117.18 | 118.08 | 116.44 | 117.71 | 15073524.0 |
| 2020-11-11 10:00:00 | AAPL | Stock | 117.705 | 118.4 | 117.64 | 118.206 | 8931926.0 |
| 2020-11-11 10:30:00 | AAPL | Stock | 118.205 | 118.5 | 117.795 | 118.18 | 6840546.0 |
| 2020-11-11 11:00:00 | AAPL | Stock | 118.17 | 118.4 | 117.835 | 118.24 | 4708438.0 |
| 2020-11-11 11:30:00 | AAPL | Stock | 118.24 | 118.78 | 118.095 | 118.776 | 4982281.0 |
| 2020-11-11 12:00:00 | AAPL | Stock | 118.775 | 119.11 | 118.53 | 118.99 | 5607949.0 |
| 2020-11-11 12:30:00 | AAPL | Stock | 119.0 | 119.48 | 118.995 | 119.23 | 5703168.0 |
| 2020-11-11 13:00:00 | AAPL | Stock | 119.22 | 119.52 | 119.04 | 119.215 | 4345168.0 |
| 2020-11-11 13:30:00 | AAPL | Stock | 119.21 | 119.56 | 119.08 | 119.12 | 4360280.0 |
| 2020-11-11 14:00:00 | AAPL | Stock | 119.11 | 119.54 | 119.02 | 119.15 | 4383357.0 |
| 2020-11-11 14:30:00 | AAPL | Stock | 119.15 | 119.41 | 118.71 | 118.925 | 5167815.0 |
| 2020-11-11 15:00:00 | AAPL | Stock | 118.93 | 119.23 | 118.81 | 118.895 | 4915558.0 |
| 2020-11-11 15:30:00 | AAPL | Stock | 118.9 | 119.63 | 118.86 | 119.495 | 8097146.0 |
| 2020-11-11 16:00:00 | AAPL | Stock | 119.49 | 119.69 | 119.47 | 119.66 | 6011643.0 |
| 2020-11-11 16:30:00 | AAPL | Stock | 119.66 | 119.73 | 119.58 | 119.59 | 84135.0 |
| 2020-11-11 17:00:00 | AAPL | Stock | 119.59 | 120.06 | 119.56 | 120.02 | 358515.0 |
| 2020-11-11 17:30:00 | AAPL | Stock | 120.07 | 120.07 | 119.0 | 119.57 | 296029.0 |
| 2020-11-11 18:00:00 | AAPL | Stock | 119.5 | 119.6 | 119.35 | 119.4 | 73120.0 |
| 2020-11-11 18:30:00 | AAPL | Stock | 119.41 | 119.71 | 119.4 | 119.61 | 77711.0 |
| 2020-11-11 19:00:00 | AAPL | Stock | 119.64 | 119.64 | 119.4 | 119.44 | 38124.0 |
| 2020-11-11 19:30:00 | AAPL | Stock | 119.48 | 119.56 | 119.35 | 119.35 | 83259.0 |
| 2020-11-11 04:00:00 | MSFT | Stock | 212.69 | 213.78 | 212.69 | 213.31 | 5228.0 |
| 2020-11-11 04:30:00 | MSFT | Stock | 213.67 | 213.88 | 213.67 | 213.7 | 1160.0 |
| 2020-11-11 05:00:00 | MSFT | Stock | 213.9 | 214.2 | 213.8 | 214.0 | 3383.0 |
| 2020-11-11 05:30:00 | MSFT | Stock | 213.67 | 213.71 | 213.2 | 213.44 | 4185.0 |
| 2020-11-11 06:00:00 | MSFT | Stock | 213.4 | 213.9 | 213.34 | 213.9 | 6687.0 |
| 2020-11-11 06:30:00 | MSFT | Stock | 214.0 | 214.26 | 213.56 | 214.25 | 7785.0 |
| 2020-11-11 07:00:00 | MSFT | Stock | 213.92 | 214.05 | 213.23 | 214.01 | 32624.0 |
| 2020-11-11 07:30:00 | MSFT | Stock | 213.66 | 214.19 | 213.38 | 213.92 | 16173.0 |
| 2020-11-11 08:00:00 | MSFT | Stock | 213.31 | 214.5 | 213.2 | 213.65 | 121512.0 |
| 2020-11-11 08:30:00 | MSFT | Stock | 213.7 | 213.7 | 213.0 | 213.15 | 36698.0 |
| 2020-11-11 09:00:00 | MSFT | Stock | 213.1 | 213.15 | 212.4 | 212.4 | 54661.0 |
| 2020-11-11 09:30:00 | MSFT | Stock | 212.4 | 215.69 | 212.2 | 215.37 | 3381961.0 |
| 2020-11-11 10:00:00 | MSFT | Stock | 215.38 | 216.63 | 215.31 | 216.35 | 2077410.0 |
| 2020-11-11 10:30:00 | MSFT | Stock | 216.37 | 216.68 | 214.7 | 215.64 | 1452717.0 |
| 2020-11-11 11:00:00 | MSFT | Stock | 215.62 | 216.58 | 215.15 | 215.978 | 1244318.0 |
| 2020-11-11 11:30:00 | MSFT | Stock | 215.99 | 216.93 | 215.73 | 216.915 | 857286.0 |
| 2020-11-11 12:00:00 | MSFT | Stock | 216.928 | 217.41 | 216.38 | 216.71 | 1063785.0 |
| 2020-11-11 12:30:00 | MSFT | Stock | 216.73 | 217.29 | 216.6 | 216.98 | 771492.0 |
> showing 50 of 97,847 rows — these rows as CSV