PREVIEW / stock_30min / 2021-10-25
file: by_date/stock_30min/2021/2021-10-25.parquet size: 2.3 MB rows: 114,154 symbols: 2,719
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-10-25 04:00:00 | AAPL | Stock | 148.5 | 148.85 | 148.45 | 148.69 | 13887.0 |
| 2021-10-25 04:30:00 | AAPL | Stock | 148.7 | 148.7 | 148.58 | 148.61 | 3788.0 |
| 2021-10-25 05:00:00 | AAPL | Stock | 148.61 | 148.62 | 148.47 | 148.5 | 14712.0 |
| 2021-10-25 05:30:00 | AAPL | Stock | 148.51 | 148.57 | 148.5 | 148.52 | 1350.0 |
| 2021-10-25 06:00:00 | AAPL | Stock | 148.53 | 148.63 | 148.48 | 148.5 | 15402.0 |
| 2021-10-25 06:30:00 | AAPL | Stock | 148.53 | 148.53 | 148.32 | 148.36 | 11545.0 |
| 2021-10-25 07:00:00 | AAPL | Stock | 148.41 | 148.51 | 148.11 | 148.44 | 32964.0 |
| 2021-10-25 07:30:00 | AAPL | Stock | 148.42 | 148.6 | 148.41 | 148.56 | 16243.0 |
| 2021-10-25 08:00:00 | AAPL | Stock | 148.35 | 148.64 | 148.15 | 148.45 | 226679.0 |
| 2021-10-25 08:30:00 | AAPL | Stock | 148.45 | 148.58 | 148.4 | 148.42 | 120706.0 |
| 2021-10-25 09:00:00 | AAPL | Stock | 148.42 | 148.75 | 148.38 | 148.7 | 140749.0 |
| 2021-10-25 09:30:00 | AAPL | Stock | 148.69 | 149.37 | 147.92 | 148.345 | 7721612.0 |
| 2021-10-25 10:00:00 | AAPL | Stock | 148.36 | 148.44 | 147.6211 | 147.915 | 3726173.0 |
| 2021-10-25 10:30:00 | AAPL | Stock | 147.91 | 148.08 | 147.7401 | 148.0787 | 2468101.0 |
| 2021-10-25 11:00:00 | AAPL | Stock | 148.075 | 148.32 | 147.83 | 148.31 | 2679648.0 |
| 2021-10-25 11:30:00 | AAPL | Stock | 148.32 | 148.52 | 148.15 | 148.52 | 2567822.0 |
| 2021-10-25 12:00:00 | AAPL | Stock | 148.525 | 148.91 | 148.48 | 148.6325 | 2915537.0 |
| 2021-10-25 12:30:00 | AAPL | Stock | 148.64 | 149.08 | 148.56 | 148.965 | 2195946.0 |
| 2021-10-25 13:00:00 | AAPL | Stock | 148.97 | 149.08 | 148.71 | 148.7299 | 1418349.0 |
| 2021-10-25 13:30:00 | AAPL | Stock | 148.72 | 148.92 | 148.71 | 148.79 | 1587949.0 |
| 2021-10-25 14:00:00 | AAPL | Stock | 148.8 | 148.96 | 148.75 | 148.8804 | 1645478.0 |
| 2021-10-25 14:30:00 | AAPL | Stock | 148.885 | 148.96 | 148.6328 | 148.69 | 1828845.0 |
| 2021-10-25 15:00:00 | AAPL | Stock | 148.7 | 148.78 | 148.455 | 148.5725 | 1917502.0 |
| 2021-10-25 15:30:00 | AAPL | Stock | 148.575 | 148.66 | 148.42 | 148.65 | 4126406.0 |
| 2021-10-25 16:00:00 | AAPL | Stock | 148.64 | 148.9 | 147.77 | 148.48 | 5942999.0 |
| 2021-10-25 16:30:00 | AAPL | Stock | 148.39 | 148.76 | 148.31 | 148.58 | 72821.0 |
| 2021-10-25 17:00:00 | AAPL | Stock | 148.55 | 148.67 | 148.51 | 148.6 | 30255.0 |
| 2021-10-25 17:30:00 | AAPL | Stock | 148.57 | 148.66 | 148.45 | 148.46 | 14625.0 |
| 2021-10-25 18:00:00 | AAPL | Stock | 148.49 | 148.54 | 148.45 | 148.49 | 9566.0 |
| 2021-10-25 18:30:00 | AAPL | Stock | 148.49 | 148.54 | 148.49 | 148.49 | 7140.0 |
| 2021-10-25 19:00:00 | AAPL | Stock | 148.47 | 148.53 | 148.45 | 148.47 | 12465.0 |
| 2021-10-25 19:30:00 | AAPL | Stock | 148.45 | 148.6 | 148.4 | 148.6 | 31813.0 |
| 2021-10-25 04:00:00 | MSFT | Stock | 310.06 | 310.45 | 310.06 | 310.35 | 2155.0 |
| 2021-10-25 04:30:00 | MSFT | Stock | 310.24 | 310.24 | 310.07 | 310.07 | 334.0 |
| 2021-10-25 05:00:00 | MSFT | Stock | 310.0 | 310.02 | 309.78 | 309.78 | 1467.0 |
| 2021-10-25 05:30:00 | MSFT | Stock | 309.67 | 309.67 | 309.64 | 309.65 | 619.0 |
| 2021-10-25 06:00:00 | MSFT | Stock | 309.66 | 309.74 | 309.3 | 309.64 | 2899.0 |
| 2021-10-25 06:30:00 | MSFT | Stock | 309.36 | 309.65 | 309.01 | 309.22 | 2389.0 |
| 2021-10-25 07:00:00 | MSFT | Stock | 309.68 | 309.68 | 308.95 | 309.0 | 6974.0 |
| 2021-10-25 07:30:00 | MSFT | Stock | 309.03 | 309.4 | 308.95 | 309.4 | 3949.0 |
| 2021-10-25 08:00:00 | MSFT | Stock | 309.3501 | 309.4 | 308.95 | 309.22 | 5132.0 |
| 2021-10-25 08:30:00 | MSFT | Stock | 309.16 | 309.4 | 308.95 | 309.0 | 9893.0 |
| 2021-10-25 09:00:00 | MSFT | Stock | 309.0 | 309.54 | 308.8 | 309.54 | 10689.0 |
| 2021-10-25 09:30:00 | MSFT | Stock | 309.54 | 309.54 | 306.46 | 307.415 | 2146696.0 |
| 2021-10-25 10:00:00 | MSFT | Stock | 307.43 | 308.15 | 307.17 | 308.11 | 917535.0 |
| 2021-10-25 10:30:00 | MSFT | Stock | 308.125 | 308.25 | 307.8202 | 307.98 | 699110.0 |
| 2021-10-25 11:00:00 | MSFT | Stock | 307.95 | 308.609 | 307.72 | 308.21 | 564989.0 |
| 2021-10-25 11:30:00 | MSFT | Stock | 308.22 | 308.27 | 307.62 | 308.065 | 580560.0 |
| 2021-10-25 12:00:00 | MSFT | Stock | 308.08 | 308.83 | 308.07 | 308.581 | 629728.0 |
| 2021-10-25 12:30:00 | MSFT | Stock | 308.59 | 309.0536 | 308.541 | 309.02 | 406384.0 |
> showing 50 of 114,154 rows — these rows as CSV