PREVIEW / stock_30min / 2022-11-02
file: by_date/stock_30min/2022/2022-11-02.parquet size: 2.1 MB rows: 102,086 symbols: 2,084
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-02 04:00:00 | AAPL | Stock | 150.72 | 150.93 | 150.41 | 150.93 | 14465.0 |
| 2022-11-02 04:30:00 | AAPL | Stock | 150.81 | 150.84 | 150.6 | 150.6 | 7312.0 |
| 2022-11-02 05:00:00 | AAPL | Stock | 150.6 | 150.6 | 150.25 | 150.25 | 7518.0 |
| 2022-11-02 05:30:00 | AAPL | Stock | 150.25 | 150.4 | 150.15 | 150.38 | 3660.0 |
| 2022-11-02 06:00:00 | AAPL | Stock | 150.34 | 150.4 | 150.25 | 150.25 | 8325.0 |
| 2022-11-02 06:30:00 | AAPL | Stock | 150.26 | 150.3 | 149.69 | 149.8 | 49011.0 |
| 2022-11-02 07:00:00 | AAPL | Stock | 149.95 | 150.0 | 149.41 | 149.43 | 41718.0 |
| 2022-11-02 07:30:00 | AAPL | Stock | 149.44 | 149.55 | 149.22 | 149.38 | 57800.0 |
| 2022-11-02 08:00:00 | AAPL | Stock | 149.9 | 150.0 | 148.45 | 148.8644 | 209386.0 |
| 2022-11-02 08:30:00 | AAPL | Stock | 148.79 | 149.16 | 148.53 | 148.86 | 156292.0 |
| 2022-11-02 09:00:00 | AAPL | Stock | 148.86 | 149.07 | 148.44 | 149.07 | 191700.0 |
| 2022-11-02 09:30:00 | AAPL | Stock | 149.07 | 150.6 | 148.67 | 148.68 | 7711846.0 |
| 2022-11-02 10:00:00 | AAPL | Stock | 148.68 | 149.64 | 148.67 | 148.99 | 3957809.0 |
| 2022-11-02 10:30:00 | AAPL | Stock | 149.0 | 149.6 | 148.81 | 149.3 | 3082974.0 |
| 2022-11-02 11:00:00 | AAPL | Stock | 149.3 | 149.4499 | 148.6 | 148.86 | 2989600.0 |
| 2022-11-02 11:30:00 | AAPL | Stock | 148.8676 | 149.1 | 148.33 | 148.9146 | 3338882.0 |
| 2022-11-02 12:00:00 | AAPL | Stock | 148.925 | 149.0886 | 148.37 | 148.53 | 2544407.0 |
| 2022-11-02 12:30:00 | AAPL | Stock | 148.535 | 149.26 | 148.19 | 149.21 | 2705984.0 |
| 2022-11-02 13:00:00 | AAPL | Stock | 149.205 | 149.235 | 148.7 | 148.81 | 1703462.0 |
| 2022-11-02 13:30:00 | AAPL | Stock | 148.82 | 149.66 | 148.79 | 149.03 | 3333166.0 |
| 2022-11-02 14:00:00 | AAPL | Stock | 149.04 | 151.99 | 148.09 | 151.72 | 8749257.0 |
| 2022-11-02 14:30:00 | AAPL | Stock | 151.71 | 152.17 | 147.35 | 147.785 | 11141091.0 |
| 2022-11-02 15:00:00 | AAPL | Stock | 147.7589 | 148.8324 | 145.5 | 145.9592 | 8027534.0 |
| 2022-11-02 15:30:00 | AAPL | Stock | 145.95 | 146.51 | 145.0 | 145.01 | 11690740.0 |
| 2022-11-02 16:00:00 | AAPL | Stock | 145.03 | 145.22 | 144.15 | 144.71 | 10065339.0 |
| 2022-11-02 16:30:00 | AAPL | Stock | 144.71 | 145.03 | 144.5 | 144.5 | 233600.0 |
| 2022-11-02 17:00:00 | AAPL | Stock | 144.51 | 144.86 | 144.5 | 144.85 | 66731.0 |
| 2022-11-02 17:30:00 | AAPL | Stock | 144.88 | 144.91 | 144.5 | 144.55 | 98530.0 |
| 2022-11-02 18:00:00 | AAPL | Stock | 144.54 | 144.57 | 144.1 | 144.36 | 82953.0 |
| 2022-11-02 18:30:00 | AAPL | Stock | 144.36 | 144.45 | 144.21 | 144.25 | 32788.0 |
| 2022-11-02 19:00:00 | AAPL | Stock | 144.25 | 144.25 | 144.1 | 144.22 | 32326.0 |
| 2022-11-02 19:30:00 | AAPL | Stock | 144.2 | 144.29 | 144.09 | 144.1 | 25915.0 |
| 2022-11-02 04:00:00 | MSFT | Stock | 228.01 | 228.83 | 228.01 | 228.83 | 957.0 |
| 2022-11-02 04:30:00 | MSFT | Stock | 228.73 | 228.73 | 228.5 | 228.5 | 355.0 |
| 2022-11-02 05:00:00 | MSFT | Stock | 228.77 | 228.77 | 228.39 | 228.39 | 469.0 |
| 2022-11-02 05:30:00 | MSFT | Stock | 228.48 | 228.62 | 228.4 | 228.5 | 7208.0 |
| 2022-11-02 06:00:00 | MSFT | Stock | 228.6 | 228.6 | 228.51 | 228.51 | 1595.0 |
| 2022-11-02 06:30:00 | MSFT | Stock | 228.5 | 228.5 | 228.34 | 228.34 | 484.0 |
| 2022-11-02 07:00:00 | MSFT | Stock | 228.21 | 228.4 | 228.0 | 228.4 | 9731.0 |
| 2022-11-02 07:30:00 | MSFT | Stock | 228.46 | 228.65 | 228.46 | 228.6 | 2564.0 |
| 2022-11-02 08:00:00 | MSFT | Stock | 228.1 | 228.78 | 227.68 | 228.6 | 49772.0 |
| 2022-11-02 08:30:00 | MSFT | Stock | 228.6 | 228.99 | 228.35 | 228.7158 | 11130.0 |
| 2022-11-02 09:00:00 | MSFT | Stock | 228.75 | 229.4 | 228.35 | 229.4 | 32930.0 |
| 2022-11-02 09:30:00 | MSFT | Stock | 229.4 | 229.46 | 226.45 | 226.475 | 2248616.0 |
| 2022-11-02 10:00:00 | MSFT | Stock | 226.475 | 226.88 | 226.01 | 226.38 | 1266754.0 |
| 2022-11-02 10:30:00 | MSFT | Stock | 226.37 | 227.12 | 226.171 | 226.42 | 1072832.0 |
| 2022-11-02 11:00:00 | MSFT | Stock | 226.405 | 226.68 | 224.82 | 224.92 | 1503699.0 |
| 2022-11-02 11:30:00 | MSFT | Stock | 224.925 | 225.31 | 224.68 | 225.04 | 1153814.0 |
| 2022-11-02 12:00:00 | MSFT | Stock | 225.05 | 225.25 | 224.5 | 224.57 | 928352.0 |
| 2022-11-02 12:30:00 | MSFT | Stock | 224.582 | 225.78 | 224.55 | 225.575 | 1022333.0 |
> showing 50 of 102,086 rows — these rows as CSV