PREVIEW / stock_30min / 2021-03-08
file: by_date/stock_30min/2021/2021-03-08.parquet size: 2.3 MB rows: 119,192 symbols: 2,886
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-03-08 04:00:00 | AAPL | Stock | 119.24 | 119.9 | 118.52 | 118.7 | 53729.0 |
| 2021-03-08 04:30:00 | AAPL | Stock | 118.7 | 119.09 | 118.66 | 119.08 | 22214.0 |
| 2021-03-08 05:00:00 | AAPL | Stock | 119.03 | 119.29 | 119.02 | 119.18 | 14957.0 |
| 2021-03-08 05:30:00 | AAPL | Stock | 119.2 | 119.59 | 119.03 | 119.26 | 13356.0 |
| 2021-03-08 06:00:00 | AAPL | Stock | 119.37 | 119.8 | 119.21 | 119.21 | 29322.0 |
| 2021-03-08 06:30:00 | AAPL | Stock | 119.32 | 119.75 | 119.02 | 119.42 | 25658.0 |
| 2021-03-08 07:00:00 | AAPL | Stock | 119.54 | 120.1 | 119.4 | 119.88 | 168097.0 |
| 2021-03-08 07:30:00 | AAPL | Stock | 119.84 | 119.95 | 119.31 | 119.58 | 188539.0 |
| 2021-03-08 08:00:00 | AAPL | Stock | 119.58 | 120.5 | 119.3 | 120.38 | 471260.0 |
| 2021-03-08 08:30:00 | AAPL | Stock | 120.36 | 120.97 | 120.18 | 120.93 | 434183.0 |
| 2021-03-08 09:00:00 | AAPL | Stock | 120.9 | 121.02 | 120.5 | 120.97 | 473911.0 |
| 2021-03-08 09:30:00 | AAPL | Stock | 120.96 | 121.0 | 118.26 | 118.47 | 19530373.0 |
| 2021-03-08 10:00:00 | AAPL | Stock | 118.46 | 119.3187 | 118.06 | 119.0 | 11674222.0 |
| 2021-03-08 10:30:00 | AAPL | Stock | 119.02 | 119.48 | 118.5 | 118.635 | 8677211.0 |
| 2021-03-08 11:00:00 | AAPL | Stock | 118.635 | 119.03 | 118.165 | 118.503 | 7893855.0 |
| 2021-03-08 11:30:00 | AAPL | Stock | 118.5 | 118.531 | 117.63 | 117.63 | 9566869.0 |
| 2021-03-08 12:00:00 | AAPL | Stock | 117.64 | 118.26 | 117.4 | 118.2193 | 8033274.0 |
| 2021-03-08 12:30:00 | AAPL | Stock | 118.21 | 118.2595 | 117.72 | 117.73 | 4665752.0 |
| 2021-03-08 13:00:00 | AAPL | Stock | 117.73 | 118.25 | 117.66 | 118.18 | 4989617.0 |
| 2021-03-08 13:30:00 | AAPL | Stock | 118.175 | 118.22 | 116.76 | 116.81 | 8150831.0 |
| 2021-03-08 14:00:00 | AAPL | Stock | 116.8 | 117.55 | 116.78 | 117.515 | 6614040.0 |
| 2021-03-08 14:30:00 | AAPL | Stock | 117.52 | 117.8199 | 116.97 | 117.24 | 5666552.0 |
| 2021-03-08 15:00:00 | AAPL | Stock | 117.24 | 117.245 | 116.65 | 116.8184 | 7585146.0 |
| 2021-03-08 15:30:00 | AAPL | Stock | 116.815 | 117.39 | 116.21 | 116.4 | 14101730.0 |
| 2021-03-08 16:00:00 | AAPL | Stock | 116.36 | 121.42 | 116.11 | 116.49 | 11501094.0 |
| 2021-03-08 16:30:00 | AAPL | Stock | 116.49 | 116.66 | 116.4 | 116.5001 | 143583.0 |
| 2021-03-08 17:00:00 | AAPL | Stock | 116.54 | 116.64 | 116.36 | 116.58 | 262691.0 |
| 2021-03-08 17:30:00 | AAPL | Stock | 116.58 | 116.6 | 116.38 | 116.5 | 108053.0 |
| 2021-03-08 18:00:00 | AAPL | Stock | 116.55 | 117.14 | 116.5 | 117.04 | 185543.0 |
| 2021-03-08 18:30:00 | AAPL | Stock | 117.04 | 117.1 | 116.8 | 116.94 | 132773.0 |
| 2021-03-08 19:00:00 | AAPL | Stock | 116.96 | 117.0 | 116.8 | 116.84 | 78508.0 |
| 2021-03-08 19:30:00 | AAPL | Stock | 116.83 | 116.91 | 116.59 | 116.84 | 114893.0 |
| 2021-03-08 04:00:00 | MSFT | Stock | 222.48 | 227.02 | 222.48 | 226.75 | 17506.0 |
| 2021-03-08 04:30:00 | MSFT | Stock | 226.6 | 227.53 | 226.43 | 226.6 | 4439.0 |
| 2021-03-08 05:00:00 | MSFT | Stock | 226.6 | 227.0 | 226.3 | 226.3 | 14444.0 |
| 2021-03-08 05:30:00 | MSFT | Stock | 226.49 | 227.2 | 226.49 | 227.19 | 7263.0 |
| 2021-03-08 06:00:00 | MSFT | Stock | 227.23 | 227.23 | 226.72 | 226.72 | 3018.0 |
| 2021-03-08 06:30:00 | MSFT | Stock | 227.48 | 229.72 | 227.0 | 229.21 | 18345.0 |
| 2021-03-08 07:00:00 | MSFT | Stock | 229.21 | 229.52 | 228.56 | 229.3 | 34330.0 |
| 2021-03-08 07:30:00 | MSFT | Stock | 229.2 | 229.48 | 228.53 | 228.89 | 28134.0 |
| 2021-03-08 08:00:00 | MSFT | Stock | 229.01 | 231.021 | 228.63 | 230.49 | 56118.0 |
| 2021-03-08 08:30:00 | MSFT | Stock | 230.3 | 230.9699 | 229.76 | 230.7 | 54113.0 |
| 2021-03-08 09:00:00 | MSFT | Stock | 230.1459 | 231.69 | 230.04 | 231.67 | 83464.0 |
| 2021-03-08 09:30:00 | MSFT | Stock | 231.42 | 232.34 | 229.37 | 230.145 | 3633362.0 |
| 2021-03-08 10:00:00 | MSFT | Stock | 230.145 | 233.27 | 229.47 | 232.75 | 2429271.0 |
| 2021-03-08 10:30:00 | MSFT | Stock | 232.79 | 233.365 | 231.5 | 231.65 | 1567685.0 |
| 2021-03-08 11:00:00 | MSFT | Stock | 231.64 | 232.46 | 231.22 | 231.96 | 1086933.0 |
| 2021-03-08 11:30:00 | MSFT | Stock | 231.98 | 232.06 | 230.22 | 230.259 | 1212065.0 |
| 2021-03-08 12:00:00 | MSFT | Stock | 230.26 | 230.7 | 229.56 | 230.65 | 1262092.0 |
| 2021-03-08 12:30:00 | MSFT | Stock | 230.6671 | 231.405 | 230.24 | 230.31 | 891360.0 |
> showing 50 of 119,192 rows — these rows as CSV