PREVIEW / stock_30min / 2021-09-15
file: by_date/stock_30min/2021/2021-09-15.parquet size: 2.2 MB rows: 109,597 symbols: 2,734
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-09-15 04:00:00 | AAPL | Stock | 148.2 | 148.82 | 148.2 | 148.74 | 18202.0 |
| 2021-09-15 04:30:00 | AAPL | Stock | 148.7 | 148.82 | 148.7 | 148.75 | 3249.0 |
| 2021-09-15 05:00:00 | AAPL | Stock | 148.68 | 148.71 | 148.59 | 148.71 | 7453.0 |
| 2021-09-15 05:30:00 | AAPL | Stock | 148.71 | 148.81 | 148.67 | 148.78 | 4734.0 |
| 2021-09-15 06:00:00 | AAPL | Stock | 148.8 | 148.8 | 148.67 | 148.74 | 5875.0 |
| 2021-09-15 06:30:00 | AAPL | Stock | 148.68 | 148.7 | 148.44 | 148.44 | 5570.0 |
| 2021-09-15 07:00:00 | AAPL | Stock | 148.48 | 148.55 | 148.25 | 148.27 | 35113.0 |
| 2021-09-15 07:30:00 | AAPL | Stock | 148.29 | 148.369 | 148.22 | 148.3 | 27035.0 |
| 2021-09-15 08:00:00 | AAPL | Stock | 148.41 | 148.48 | 148.15 | 148.21 | 168699.0 |
| 2021-09-15 08:30:00 | AAPL | Stock | 148.24 | 148.79 | 148.24 | 148.43 | 105213.0 |
| 2021-09-15 09:00:00 | AAPL | Stock | 148.41 | 148.66 | 148.37 | 148.54 | 135552.0 |
| 2021-09-15 09:30:00 | AAPL | Stock | 148.54 | 149.09 | 146.95 | 147.44 | 11323033.0 |
| 2021-09-15 10:00:00 | AAPL | Stock | 147.45 | 147.575 | 146.48 | 146.6 | 7404534.0 |
| 2021-09-15 10:30:00 | AAPL | Stock | 146.6 | 147.24 | 146.37 | 147.22 | 5687609.0 |
| 2021-09-15 11:00:00 | AAPL | Stock | 147.22 | 147.4 | 146.92 | 147.021 | 3793696.0 |
| 2021-09-15 11:30:00 | AAPL | Stock | 147.03 | 147.315 | 146.77 | 147.26 | 3204940.0 |
| 2021-09-15 12:00:00 | AAPL | Stock | 147.25 | 147.58 | 147.12 | 147.5771 | 2696460.0 |
| 2021-09-15 12:30:00 | AAPL | Stock | 147.58 | 148.17 | 147.53 | 148.045 | 4707528.0 |
| 2021-09-15 13:00:00 | AAPL | Stock | 148.045 | 148.2899 | 147.86 | 148.2 | 3133525.0 |
| 2021-09-15 13:30:00 | AAPL | Stock | 148.205 | 148.5599 | 148.12 | 148.133 | 2865413.0 |
| 2021-09-15 14:00:00 | AAPL | Stock | 148.13 | 148.39 | 148.09 | 148.33 | 2495695.0 |
| 2021-09-15 14:30:00 | AAPL | Stock | 148.32 | 148.59 | 148.235 | 148.45 | 2551931.0 |
| 2021-09-15 15:00:00 | AAPL | Stock | 148.45 | 149.08 | 148.35 | 149.0601 | 4177892.0 |
| 2021-09-15 15:30:00 | AAPL | Stock | 149.07 | 149.44 | 148.87 | 149.09 | 7833355.0 |
| 2021-09-15 16:00:00 | AAPL | Stock | 149.08 | 149.1 | 148.7 | 148.74 | 8729040.0 |
| 2021-09-15 16:30:00 | AAPL | Stock | 148.73 | 148.85 | 148.5 | 148.75 | 164630.0 |
| 2021-09-15 17:00:00 | AAPL | Stock | 148.75 | 148.8 | 148.73 | 148.74 | 22179.0 |
| 2021-09-15 17:30:00 | AAPL | Stock | 148.74 | 148.92 | 148.74 | 148.92 | 26450.0 |
| 2021-09-15 18:00:00 | AAPL | Stock | 148.92 | 148.97 | 148.9 | 148.93 | 23223.0 |
| 2021-09-15 18:30:00 | AAPL | Stock | 148.95 | 148.96 | 148.95 | 148.96 | 4164.0 |
| 2021-09-15 19:00:00 | AAPL | Stock | 148.96 | 148.97 | 148.92 | 148.96 | 8463.0 |
| 2021-09-15 19:30:00 | AAPL | Stock | 148.94 | 148.97 | 148.94 | 148.97 | 22955.0 |
| 2021-09-15 04:00:00 | MSFT | Stock | 303.2 | 303.2 | 303.0 | 303.15 | 4090.0 |
| 2021-09-15 04:30:00 | MSFT | Stock | 303.15 | 303.6 | 303.15 | 303.6 | 2994.0 |
| 2021-09-15 05:00:00 | MSFT | Stock | 303.5 | 303.73 | 303.5 | 303.53 | 922.0 |
| 2021-09-15 05:30:00 | MSFT | Stock | 303.68 | 303.79 | 303.64 | 303.79 | 2075.0 |
| 2021-09-15 06:00:00 | MSFT | Stock | 303.79 | 303.99 | 303.72 | 303.82 | 5412.0 |
| 2021-09-15 06:30:00 | MSFT | Stock | 303.88 | 304.27 | 303.64 | 303.66 | 3613.0 |
| 2021-09-15 07:00:00 | MSFT | Stock | 303.8 | 303.8 | 303.53 | 303.53 | 26267.0 |
| 2021-09-15 07:30:00 | MSFT | Stock | 303.6 | 303.65 | 303.24 | 303.43 | 12554.0 |
| 2021-09-15 08:00:00 | MSFT | Stock | 303.6512 | 303.85 | 303.2 | 303.3 | 54714.0 |
| 2021-09-15 08:30:00 | MSFT | Stock | 303.28 | 304.1 | 303.28 | 303.99 | 58782.0 |
| 2021-09-15 09:00:00 | MSFT | Stock | 303.99 | 303.99 | 303.0 | 303.16 | 40481.0 |
| 2021-09-15 09:30:00 | MSFT | Stock | 303.23 | 305.32 | 302.27 | 302.88 | 4370178.0 |
| 2021-09-15 10:00:00 | MSFT | Stock | 302.91 | 303.73 | 301.82 | 302.17 | 1491664.0 |
| 2021-09-15 10:30:00 | MSFT | Stock | 302.17 | 303.625 | 302.02 | 303.45 | 1077859.0 |
| 2021-09-15 11:00:00 | MSFT | Stock | 303.445 | 303.69 | 302.32 | 302.4 | 945634.0 |
| 2021-09-15 11:30:00 | MSFT | Stock | 302.4 | 302.65 | 302.02 | 302.62 | 660692.0 |
| 2021-09-15 12:00:00 | MSFT | Stock | 302.61 | 303.15 | 302.13 | 303.09 | 787195.0 |
| 2021-09-15 12:30:00 | MSFT | Stock | 303.11 | 304.495 | 303.11 | 304.31 | 1332070.0 |
> showing 50 of 109,597 rows — these rows as CSV