PREVIEW / stock_30min / 2021-12-31
file: by_date/stock_30min/2021/2021-12-31.parquet size: 2.2 MB rows: 108,283 symbols: 2,649
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-12-31 04:00:00 | AAPL | Stock | 177.98 | 178.13 | 177.76 | 177.85 | 3150.0 |
| 2021-12-31 04:30:00 | AAPL | Stock | 177.97 | 177.97 | 177.88 | 177.9 | 800.0 |
| 2021-12-31 05:30:00 | AAPL | Stock | 177.91 | 177.91 | 177.8 | 177.8 | 786.0 |
| 2021-12-31 06:00:00 | AAPL | Stock | 177.8 | 177.8 | 177.8 | 177.8 | 254.0 |
| 2021-12-31 06:30:00 | AAPL | Stock | 177.98 | 177.99 | 177.83 | 177.83 | 1979.0 |
| 2021-12-31 07:00:00 | AAPL | Stock | 177.75 | 177.9 | 177.71 | 177.9 | 4416.0 |
| 2021-12-31 07:30:00 | AAPL | Stock | 177.9 | 178.24 | 177.87 | 178.03 | 25907.0 |
| 2021-12-31 08:00:00 | AAPL | Stock | 177.8902 | 178.26 | 177.72 | 178.14 | 87154.0 |
| 2021-12-31 08:30:00 | AAPL | Stock | 178.14 | 178.35 | 178.12 | 178.26 | 74966.0 |
| 2021-12-31 09:00:00 | AAPL | Stock | 178.26 | 178.36 | 177.96 | 178.13 | 52949.0 |
| 2021-12-31 09:30:00 | AAPL | Stock | 178.12 | 179.23 | 177.72 | 177.88 | 5883259.0 |
| 2021-12-31 10:00:00 | AAPL | Stock | 177.89 | 178.5899 | 177.32 | 178.2602 | 4648025.0 |
| 2021-12-31 10:30:00 | AAPL | Stock | 178.26 | 178.48 | 177.9 | 178.395 | 3169254.0 |
| 2021-12-31 11:00:00 | AAPL | Stock | 178.3908 | 178.43 | 178.0 | 178.36 | 2435845.0 |
| 2021-12-31 11:30:00 | AAPL | Stock | 178.355 | 178.3999 | 177.64 | 177.705 | 2433070.0 |
| 2021-12-31 12:00:00 | AAPL | Stock | 177.71 | 177.84 | 177.26 | 177.51 | 2494520.0 |
| 2021-12-31 12:30:00 | AAPL | Stock | 177.52 | 177.8 | 177.41 | 177.56 | 1997522.0 |
| 2021-12-31 13:00:00 | AAPL | Stock | 177.56 | 177.75 | 177.48 | 177.63 | 2087974.0 |
| 2021-12-31 13:30:00 | AAPL | Stock | 177.62 | 177.91 | 177.355 | 177.55 | 2443443.0 |
| 2021-12-31 14:00:00 | AAPL | Stock | 177.55 | 177.68 | 177.29 | 177.4 | 2195585.0 |
| 2021-12-31 14:30:00 | AAPL | Stock | 177.395 | 177.75 | 177.38 | 177.605 | 2325500.0 |
| 2021-12-31 15:00:00 | AAPL | Stock | 177.61 | 177.9 | 177.6 | 177.845 | 3167699.0 |
| 2021-12-31 15:30:00 | AAPL | Stock | 177.84 | 178.27 | 177.44 | 177.61 | 8187366.0 |
| 2021-12-31 16:00:00 | AAPL | Stock | 177.61 | 177.8 | 177.52 | 177.52 | 8018701.0 |
| 2021-12-31 16:30:00 | AAPL | Stock | 177.52 | 177.52 | 177.45 | 177.5 | 27103.0 |
| 2021-12-31 17:00:00 | AAPL | Stock | 177.48 | 177.51 | 177.48 | 177.5 | 9372.0 |
| 2021-12-31 17:30:00 | AAPL | Stock | 177.5 | 177.57 | 177.4801 | 177.55 | 10377.0 |
| 2021-12-31 18:00:00 | AAPL | Stock | 177.55 | 177.58 | 177.5 | 177.57 | 9306.0 |
| 2021-12-31 18:30:00 | AAPL | Stock | 177.57 | 177.69 | 177.57 | 177.6 | 9404.0 |
| 2021-12-31 19:00:00 | AAPL | Stock | 177.6 | 177.6 | 177.5 | 177.56 | 3542.0 |
| 2021-12-31 19:30:00 | AAPL | Stock | 177.6 | 177.75 | 177.6 | 177.7 | 13104.0 |
| 2021-12-31 04:00:00 | MSFT | Stock | 338.0 | 338.0 | 338.0 | 338.0 | 259.0 |
| 2021-12-31 05:00:00 | MSFT | Stock | 338.73 | 338.73 | 338.52 | 338.52 | 210.0 |
| 2021-12-31 07:00:00 | MSFT | Stock | 338.37 | 338.89 | 338.34 | 338.89 | 1202.0 |
| 2021-12-31 07:30:00 | MSFT | Stock | 338.87 | 338.9 | 338.87 | 338.89 | 1254.0 |
| 2021-12-31 08:00:00 | MSFT | Stock | 338.14 | 338.9 | 338.14 | 338.6601 | 5377.0 |
| 2021-12-31 08:30:00 | MSFT | Stock | 338.7001 | 339.3 | 338.7001 | 338.9481 | 8065.0 |
| 2021-12-31 09:00:00 | MSFT | Stock | 339.32 | 339.32 | 338.2 | 338.51 | 140801.0 |
| 2021-12-31 09:30:00 | MSFT | Stock | 338.67 | 339.355 | 337.14 | 337.35 | 1295336.0 |
| 2021-12-31 10:00:00 | MSFT | Stock | 337.38 | 338.11 | 336.14 | 337.53 | 866157.0 |
| 2021-12-31 10:30:00 | MSFT | Stock | 337.56 | 337.73 | 336.64 | 336.9 | 623759.0 |
| 2021-12-31 11:00:00 | MSFT | Stock | 336.89 | 337.0173 | 335.85 | 336.65 | 776099.0 |
| 2021-12-31 11:30:00 | MSFT | Stock | 336.63 | 336.76 | 335.87 | 336.34 | 621807.0 |
| 2021-12-31 12:00:00 | MSFT | Stock | 336.37 | 336.73 | 336.05 | 336.39 | 546165.0 |
| 2021-12-31 12:30:00 | MSFT | Stock | 336.41 | 337.13 | 336.28 | 337.06 | 470725.0 |
| 2021-12-31 13:00:00 | MSFT | Stock | 337.0595 | 337.95 | 336.94 | 337.8817 | 438023.0 |
| 2021-12-31 13:30:00 | MSFT | Stock | 337.85 | 338.01 | 336.98 | 337.265 | 453873.0 |
| 2021-12-31 14:00:00 | MSFT | Stock | 337.27 | 337.74 | 336.74 | 337.23 | 470351.0 |
| 2021-12-31 14:30:00 | MSFT | Stock | 337.23 | 337.9894 | 337.07 | 337.23 | 619619.0 |
| 2021-12-31 15:00:00 | MSFT | Stock | 337.24 | 337.81 | 337.16 | 337.7 | 502091.0 |
> showing 50 of 108,283 rows — these rows as CSV