PREVIEW / stock_30min / 2021-11-26
file: by_date/stock_30min/2021/2021-11-26.parquet size: 1.6 MB rows: 78,662 symbols: 2,605
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-11-26 04:00:00 | AAPL | Stock | 160.0 | 160.59 | 157.96 | 158.15 | 104334.0 |
| 2021-11-26 04:30:00 | AAPL | Stock | 158.29 | 158.41 | 157.85 | 158.28 | 83011.0 |
| 2021-11-26 05:00:00 | AAPL | Stock | 158.16 | 158.84 | 158.16 | 158.74 | 18966.0 |
| 2021-11-26 05:30:00 | AAPL | Stock | 158.76 | 158.77 | 158.44 | 158.49 | 24476.0 |
| 2021-11-26 06:00:00 | AAPL | Stock | 158.49 | 159.37 | 158.45 | 159.0 | 36341.0 |
| 2021-11-26 06:30:00 | AAPL | Stock | 159.0 | 159.2 | 158.32 | 158.99 | 24089.0 |
| 2021-11-26 07:00:00 | AAPL | Stock | 158.75 | 159.76 | 158.58 | 159.19 | 162329.0 |
| 2021-11-26 07:30:00 | AAPL | Stock | 159.19 | 159.72 | 159.19 | 159.36 | 105362.0 |
| 2021-11-26 08:00:00 | AAPL | Stock | 159.51 | 161.536 | 158.79 | 159.37 | 542595.0 |
| 2021-11-26 08:30:00 | AAPL | Stock | 159.35 | 159.38 | 158.91 | 158.9599 | 219097.0 |
| 2021-11-26 09:00:00 | AAPL | Stock | 158.98 | 159.98 | 158.98 | 159.62 | 378832.0 |
| 2021-11-26 09:30:00 | AAPL | Stock | 159.565 | 160.45 | 158.36 | 158.75 | 11351320.0 |
| 2021-11-26 10:00:00 | AAPL | Stock | 158.74 | 158.97 | 157.58 | 158.14 | 7846881.0 |
| 2021-11-26 10:30:00 | AAPL | Stock | 158.15 | 158.24 | 157.43 | 157.6101 | 6020996.0 |
| 2021-11-26 11:00:00 | AAPL | Stock | 157.61 | 157.615 | 156.9 | 157.44 | 7080196.0 |
| 2021-11-26 11:30:00 | AAPL | Stock | 157.43 | 158.185 | 157.24 | 158.09 | 5522711.0 |
| 2021-11-26 12:00:00 | AAPL | Stock | 158.09 | 158.225 | 157.48 | 157.76 | 4960755.0 |
| 2021-11-26 12:30:00 | AAPL | Stock | 157.75 | 157.88 | 156.36 | 156.88 | 13121591.0 |
| 2021-11-26 13:00:00 | AAPL | Stock | 156.88 | 158.69 | 156.77 | 157.4799 | 7700314.0 |
| 2021-11-26 13:30:00 | AAPL | Stock | 157.45 | 157.5001 | 156.81 | 157.45 | 146889.0 |
| 2021-11-26 14:00:00 | AAPL | Stock | 157.46 | 157.5 | 157.32 | 157.4 | 59057.0 |
| 2021-11-26 14:30:00 | AAPL | Stock | 157.41 | 157.44 | 157.3 | 157.36 | 24598.0 |
| 2021-11-26 15:00:00 | AAPL | Stock | 157.38 | 157.38 | 157.0 | 157.25 | 27403.0 |
| 2021-11-26 15:30:00 | AAPL | Stock | 157.2 | 157.27 | 157.06 | 157.15 | 26771.0 |
| 2021-11-26 16:00:00 | AAPL | Stock | 157.15 | 157.28 | 156.81 | 157.22 | 12849.0 |
| 2021-11-26 16:30:00 | AAPL | Stock | 157.28 | 157.4 | 157.26 | 157.4 | 8973.0 |
| 2021-11-26 04:00:00 | MSFT | Stock | 335.83 | 336.5 | 333.8 | 334.1 | 29959.0 |
| 2021-11-26 04:30:00 | MSFT | Stock | 334.1 | 334.3 | 333.0 | 333.85 | 7880.0 |
| 2021-11-26 05:00:00 | MSFT | Stock | 334.0 | 334.3 | 333.77 | 333.77 | 5633.0 |
| 2021-11-26 05:30:00 | MSFT | Stock | 333.39 | 333.7 | 333.1 | 333.7 | 3419.0 |
| 2021-11-26 06:00:00 | MSFT | Stock | 333.8 | 335.5 | 333.5 | 334.4 | 38652.0 |
| 2021-11-26 06:30:00 | MSFT | Stock | 334.4 | 334.82 | 334.03 | 334.2 | 14962.0 |
| 2021-11-26 07:00:00 | MSFT | Stock | 334.2 | 335.2 | 334.05 | 334.4 | 28694.0 |
| 2021-11-26 07:30:00 | MSFT | Stock | 334.4 | 334.68 | 333.99 | 334.0 | 32160.0 |
| 2021-11-26 08:00:00 | MSFT | Stock | 334.7 | 335.35 | 333.8 | 334.41 | 36723.0 |
| 2021-11-26 08:30:00 | MSFT | Stock | 334.5 | 334.54 | 333.65 | 334.4 | 19620.0 |
| 2021-11-26 09:00:00 | MSFT | Stock | 334.38 | 335.4 | 334.07 | 334.55 | 24243.0 |
| 2021-11-26 09:30:00 | MSFT | Stock | 334.65 | 337.93 | 334.03 | 336.42 | 2541259.0 |
| 2021-11-26 10:00:00 | MSFT | Stock | 336.44 | 336.8 | 334.81 | 335.53 | 1433481.0 |
| 2021-11-26 10:30:00 | MSFT | Stock | 335.49 | 335.7464 | 333.1 | 333.48 | 1432828.0 |
| 2021-11-26 11:00:00 | MSFT | Stock | 333.48 | 333.48 | 330.34 | 330.855 | 1847117.0 |
| 2021-11-26 11:30:00 | MSFT | Stock | 330.88 | 332.13 | 330.39 | 330.99 | 1281939.0 |
| 2021-11-26 12:00:00 | MSFT | Stock | 331.0 | 332.37 | 330.58 | 332.07 | 1603506.0 |
| 2021-11-26 12:30:00 | MSFT | Stock | 332.03 | 332.42 | 328.12 | 329.77 | 4138547.0 |
| 2021-11-26 13:00:00 | MSFT | Stock | 329.68 | 330.26 | 329.2 | 330.09 | 3633937.0 |
| 2021-11-26 13:30:00 | MSFT | Stock | 330.1 | 331.25 | 329.75 | 329.89 | 28496.0 |
| 2021-11-26 14:00:00 | MSFT | Stock | 329.9 | 330.37 | 329.85 | 330.18 | 4768.0 |
| 2021-11-26 14:30:00 | MSFT | Stock | 330.14 | 330.14 | 329.68 | 329.7 | 7081.0 |
| 2021-11-26 15:00:00 | MSFT | Stock | 329.68 | 329.79 | 329.5 | 329.5 | 4240.0 |
| 2021-11-26 15:30:00 | MSFT | Stock | 329.6 | 329.64 | 329.42 | 329.53 | 3905.0 |
> showing 50 of 78,662 rows — these rows as CSV