PREVIEW / stock_30min / 2022-03-02
file: by_date/stock_30min/2022/2022-03-02.parquet size: 2.1 MB rows: 106,399 symbols: 2,512
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-03-02 04:00:00 | AAPL | Stock | 165.0 | 165.0 | 162.56 | 162.67 | 8749.0 |
| 2022-03-02 04:30:00 | AAPL | Stock | 162.84 | 164.08 | 162.84 | 163.8 | 5975.0 |
| 2022-03-02 05:00:00 | AAPL | Stock | 163.87 | 164.74 | 163.6 | 164.31 | 7873.0 |
| 2022-03-02 05:30:00 | AAPL | Stock | 164.27 | 164.27 | 163.81 | 164.1 | 6629.0 |
| 2022-03-02 06:00:00 | AAPL | Stock | 164.05 | 164.65 | 164.05 | 164.65 | 4677.0 |
| 2022-03-02 06:30:00 | AAPL | Stock | 164.72 | 164.72 | 164.22 | 164.49 | 9073.0 |
| 2022-03-02 07:00:00 | AAPL | Stock | 164.43 | 164.6 | 163.9 | 164.0 | 56994.0 |
| 2022-03-02 07:30:00 | AAPL | Stock | 163.94 | 163.94 | 163.65 | 163.9 | 30696.0 |
| 2022-03-02 08:00:00 | AAPL | Stock | 164.5199 | 164.9 | 163.23 | 163.6 | 244918.0 |
| 2022-03-02 08:30:00 | AAPL | Stock | 163.6 | 163.75 | 163.23 | 163.65 | 142928.0 |
| 2022-03-02 09:00:00 | AAPL | Stock | 163.66 | 164.55 | 163.66 | 164.48 | 227708.0 |
| 2022-03-02 09:30:00 | AAPL | Stock | 164.48 | 164.69 | 163.05 | 164.0432 | 6941639.0 |
| 2022-03-02 10:00:00 | AAPL | Stock | 164.05 | 164.72 | 162.95 | 164.51 | 5651467.0 |
| 2022-03-02 10:30:00 | AAPL | Stock | 164.49 | 165.18 | 164.16 | 164.595 | 5935103.0 |
| 2022-03-02 11:00:00 | AAPL | Stock | 164.61 | 166.2 | 164.17 | 165.7393 | 6392190.0 |
| 2022-03-02 11:30:00 | AAPL | Stock | 165.76 | 166.47 | 165.57 | 165.89 | 4433994.0 |
| 2022-03-02 12:00:00 | AAPL | Stock | 165.88 | 166.65 | 165.71 | 166.29 | 4404724.0 |
| 2022-03-02 12:30:00 | AAPL | Stock | 166.3 | 166.725 | 166.04 | 166.1972 | 2984137.0 |
| 2022-03-02 13:00:00 | AAPL | Stock | 166.2 | 166.89 | 166.2 | 166.6861 | 2729581.0 |
| 2022-03-02 13:30:00 | AAPL | Stock | 166.7 | 167.0 | 166.41 | 166.7029 | 2597290.0 |
| 2022-03-02 14:00:00 | AAPL | Stock | 166.72 | 167.15 | 166.6 | 166.87 | 2811245.0 |
| 2022-03-02 14:30:00 | AAPL | Stock | 166.88 | 167.25 | 166.63 | 166.755 | 3034431.0 |
| 2022-03-02 15:00:00 | AAPL | Stock | 166.75 | 167.3 | 166.71 | 167.21 | 3134580.0 |
| 2022-03-02 15:30:00 | AAPL | Stock | 167.21 | 167.36 | 166.4 | 166.54 | 7679900.0 |
| 2022-03-02 16:00:00 | AAPL | Stock | 166.52 | 166.56 | 166.07 | 166.15 | 9108704.0 |
| 2022-03-02 16:30:00 | AAPL | Stock | 166.15 | 166.56 | 165.95 | 166.19 | 101416.0 |
| 2022-03-02 17:00:00 | AAPL | Stock | 166.16 | 166.25 | 165.99 | 166.07 | 12427.0 |
| 2022-03-02 17:30:00 | AAPL | Stock | 166.06 | 166.12 | 166.0 | 166.05 | 4809.0 |
| 2022-03-02 18:00:00 | AAPL | Stock | 166.1 | 166.27 | 166.1 | 166.2 | 15104.0 |
| 2022-03-02 18:30:00 | AAPL | Stock | 166.29 | 166.33 | 166.07 | 166.3 | 5776.0 |
| 2022-03-02 19:00:00 | AAPL | Stock | 166.32 | 166.54 | 166.25 | 166.37 | 16224.0 |
| 2022-03-02 19:30:00 | AAPL | Stock | 166.33 | 166.47 | 166.21 | 166.36 | 19461.0 |
| 2022-03-02 04:00:00 | MSFT | Stock | 294.74 | 294.75 | 293.74 | 294.44 | 3728.0 |
| 2022-03-02 04:30:00 | MSFT | Stock | 295.85 | 296.81 | 295.85 | 296.42 | 910.0 |
| 2022-03-02 05:00:00 | MSFT | Stock | 296.68 | 297.59 | 296.68 | 296.7 | 835.0 |
| 2022-03-02 05:30:00 | MSFT | Stock | 296.12 | 296.12 | 296.01 | 296.12 | 1162.0 |
| 2022-03-02 06:00:00 | MSFT | Stock | 296.81 | 297.3 | 296.81 | 297.3 | 374.0 |
| 2022-03-02 06:30:00 | MSFT | Stock | 296.45 | 296.45 | 296.45 | 296.45 | 110.0 |
| 2022-03-02 07:00:00 | MSFT | Stock | 297.1 | 297.32 | 296.55 | 296.8 | 6916.0 |
| 2022-03-02 07:30:00 | MSFT | Stock | 296.61 | 297.3 | 296.0 | 297.28 | 7590.0 |
| 2022-03-02 08:00:00 | MSFT | Stock | 297.0 | 297.79 | 295.53 | 295.72 | 15342.0 |
| 2022-03-02 08:30:00 | MSFT | Stock | 296.1 | 296.1911 | 295.13 | 295.3 | 17081.0 |
| 2022-03-02 09:00:00 | MSFT | Stock | 295.69 | 296.237 | 295.15 | 295.89 | 20066.0 |
| 2022-03-02 09:30:00 | MSFT | Stock | 295.8 | 298.37 | 294.5 | 296.34 | 2522360.0 |
| 2022-03-02 10:00:00 | MSFT | Stock | 296.39 | 297.6 | 293.698 | 296.8501 | 1487681.0 |
| 2022-03-02 10:30:00 | MSFT | Stock | 296.78 | 297.95 | 295.73 | 296.31 | 1220719.0 |
| 2022-03-02 11:00:00 | MSFT | Stock | 296.29 | 298.76 | 295.34 | 298.03 | 1398661.0 |
| 2022-03-02 11:30:00 | MSFT | Stock | 298.02 | 299.57 | 297.69 | 298.2795 | 999297.0 |
| 2022-03-02 12:00:00 | MSFT | Stock | 298.33 | 299.73 | 298.0248 | 299.27 | 844874.0 |
| 2022-03-02 12:30:00 | MSFT | Stock | 299.2866 | 299.62 | 298.67 | 299.05 | 888475.0 |
> showing 50 of 106,399 rows — these rows as CSV