PREVIEW / stock_30min / 2021-01-11
file: by_date/stock_30min/2021/2021-01-11.parquet size: 2.3 MB rows: 114,986 symbols: 2,691
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-01-11 04:00:00 | AAPL | Stock | 131.75 | 131.75 | 131.0 | 131.2 | 46510.0 |
| 2021-01-11 04:30:00 | AAPL | Stock | 131.23 | 131.48 | 131.14 | 131.28 | 12878.0 |
| 2021-01-11 05:00:00 | AAPL | Stock | 131.21 | 131.4 | 131.17 | 131.3 | 5966.0 |
| 2021-01-11 05:30:00 | AAPL | Stock | 131.3 | 131.48 | 131.29 | 131.4 | 12900.0 |
| 2021-01-11 06:00:00 | AAPL | Stock | 131.47 | 131.48 | 131.32 | 131.32 | 11088.0 |
| 2021-01-11 06:30:00 | AAPL | Stock | 131.29 | 131.73 | 131.28 | 131.52 | 17098.0 |
| 2021-01-11 07:00:00 | AAPL | Stock | 131.6 | 131.67 | 130.24 | 130.55 | 335474.0 |
| 2021-01-11 07:30:00 | AAPL | Stock | 130.54 | 130.72 | 130.41 | 130.64 | 115668.0 |
| 2021-01-11 08:00:00 | AAPL | Stock | 131.14 | 131.43 | 130.25 | 130.28 | 487084.0 |
| 2021-01-11 08:30:00 | AAPL | Stock | 130.26 | 130.34 | 130.02 | 130.18 | 349344.0 |
| 2021-01-11 09:00:00 | AAPL | Stock | 130.21 | 130.21 | 129.0 | 129.16 | 748002.0 |
| 2021-01-11 09:30:00 | AAPL | Stock | 129.16 | 129.82 | 128.5 | 129.425 | 15696795.0 |
| 2021-01-11 10:00:00 | AAPL | Stock | 129.41 | 130.17 | 129.37 | 130.0 | 8474651.0 |
| 2021-01-11 10:30:00 | AAPL | Stock | 130.0 | 130.11 | 129.32 | 129.57 | 5571928.0 |
| 2021-01-11 11:00:00 | AAPL | Stock | 129.56 | 129.64 | 129.03 | 129.563 | 4895913.0 |
| 2021-01-11 11:30:00 | AAPL | Stock | 129.56 | 129.69 | 129.3 | 129.51 | 3362426.0 |
| 2021-01-11 12:00:00 | AAPL | Stock | 129.51 | 129.85 | 129.35 | 129.705 | 3526809.0 |
| 2021-01-11 12:30:00 | AAPL | Stock | 129.7 | 130.06 | 129.49 | 129.55 | 3656278.0 |
| 2021-01-11 13:00:00 | AAPL | Stock | 129.545 | 129.93 | 129.45 | 129.61 | 4229160.0 |
| 2021-01-11 13:30:00 | AAPL | Stock | 129.62 | 129.65 | 129.22 | 129.345 | 3283249.0 |
| 2021-01-11 14:00:00 | AAPL | Stock | 129.348 | 129.348 | 128.94 | 129.001 | 3975420.0 |
| 2021-01-11 14:30:00 | AAPL | Stock | 129.0 | 129.33 | 128.87 | 129.31 | 3984956.0 |
| 2021-01-11 15:00:00 | AAPL | Stock | 129.31 | 129.44 | 128.69 | 128.738 | 4758878.0 |
| 2021-01-11 15:30:00 | AAPL | Stock | 128.735 | 129.18 | 128.718 | 128.98 | 7784960.0 |
| 2021-01-11 16:00:00 | AAPL | Stock | 128.98 | 129.15 | 128.961 | 129.01 | 11881266.0 |
| 2021-01-11 16:30:00 | AAPL | Stock | 129.02 | 129.04 | 128.95 | 128.95 | 102356.0 |
| 2021-01-11 17:00:00 | AAPL | Stock | 128.96 | 129.0 | 128.95 | 128.96 | 44206.0 |
| 2021-01-11 17:30:00 | AAPL | Stock | 128.96 | 129.05 | 128.91 | 129.05 | 61532.0 |
| 2021-01-11 18:00:00 | AAPL | Stock | 129.02 | 129.13 | 128.97 | 129.07 | 32185.0 |
| 2021-01-11 18:30:00 | AAPL | Stock | 129.07 | 129.17 | 129.07 | 129.12 | 63818.0 |
| 2021-01-11 19:00:00 | AAPL | Stock | 129.14 | 129.24 | 129.04 | 129.17 | 53598.0 |
| 2021-01-11 19:30:00 | AAPL | Stock | 129.12 | 129.24 | 129.05 | 129.15 | 74988.0 |
| 2021-01-11 04:00:00 | MSFT | Stock | 218.8 | 219.56 | 218.6 | 219.54 | 1647.0 |
| 2021-01-11 04:30:00 | MSFT | Stock | 219.6 | 219.6 | 219.51 | 219.51 | 428.0 |
| 2021-01-11 05:30:00 | MSFT | Stock | 219.13 | 219.13 | 218.97 | 219.0 | 1697.0 |
| 2021-01-11 06:30:00 | MSFT | Stock | 218.71 | 218.76 | 218.71 | 218.73 | 446.0 |
| 2021-01-11 07:00:00 | MSFT | Stock | 218.71 | 219.0 | 218.3 | 218.55 | 10811.0 |
| 2021-01-11 07:30:00 | MSFT | Stock | 218.7 | 218.99 | 218.57 | 218.75 | 11336.0 |
| 2021-01-11 08:00:00 | MSFT | Stock | 218.88 | 218.88 | 217.6 | 217.6 | 16623.0 |
| 2021-01-11 08:30:00 | MSFT | Stock | 217.6 | 218.0 | 217.53 | 217.7 | 21482.0 |
| 2021-01-11 09:00:00 | MSFT | Stock | 217.93 | 218.6 | 217.22 | 218.54 | 39484.0 |
| 2021-01-11 09:30:00 | MSFT | Stock | 218.55 | 218.65 | 216.73 | 217.43 | 2482223.0 |
| 2021-01-11 10:00:00 | MSFT | Stock | 217.425 | 218.836 | 217.0 | 218.76 | 1287008.0 |
| 2021-01-11 10:30:00 | MSFT | Stock | 218.76 | 218.91 | 218.21 | 218.361 | 942676.0 |
| 2021-01-11 11:00:00 | MSFT | Stock | 218.38 | 218.387 | 217.44 | 218.08 | 764353.0 |
| 2021-01-11 11:30:00 | MSFT | Stock | 218.075 | 218.562 | 217.9 | 218.11 | 601944.0 |
| 2021-01-11 12:00:00 | MSFT | Stock | 218.12 | 218.275 | 217.88 | 218.231 | 496378.0 |
| 2021-01-11 12:30:00 | MSFT | Stock | 218.22 | 218.55 | 218.1 | 218.26 | 611705.0 |
| 2021-01-11 13:00:00 | MSFT | Stock | 218.28 | 218.53 | 217.8 | 217.9 | 442815.0 |
| 2021-01-11 13:30:00 | MSFT | Stock | 217.9 | 217.97 | 217.51 | 217.79 | 470491.0 |
> showing 50 of 114,986 rows — these rows as CSV