PREVIEW / stock_30min / 2022-05-02
file: by_date/stock_30min/2022/2022-05-02.parquet size: 2.2 MB rows: 108,290 symbols: 2,511
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-05-02 04:00:00 | AAPL | Stock | 158.6 | 158.8 | 158.1 | 158.5 | 23176.0 |
| 2022-05-02 04:30:00 | AAPL | Stock | 158.35 | 158.42 | 157.69 | 157.82 | 19843.0 |
| 2022-05-02 05:00:00 | AAPL | Stock | 157.85 | 158.36 | 157.85 | 158.36 | 12466.0 |
| 2022-05-02 05:30:00 | AAPL | Stock | 158.38 | 158.49 | 158.24 | 158.24 | 3559.0 |
| 2022-05-02 06:00:00 | AAPL | Stock | 158.06 | 158.59 | 158.0 | 158.35 | 6627.0 |
| 2022-05-02 06:30:00 | AAPL | Stock | 158.34 | 158.55 | 158.01 | 158.03 | 13307.0 |
| 2022-05-02 07:00:00 | AAPL | Stock | 158.19 | 158.24 | 157.37 | 157.51 | 114641.0 |
| 2022-05-02 07:30:00 | AAPL | Stock | 157.5 | 157.5 | 156.2 | 156.33 | 135463.0 |
| 2022-05-02 08:00:00 | AAPL | Stock | 158.0801 | 158.87 | 156.13 | 156.68 | 531593.0 |
| 2022-05-02 08:30:00 | AAPL | Stock | 156.7 | 156.92 | 156.19 | 156.45 | 264064.0 |
| 2022-05-02 09:00:00 | AAPL | Stock | 156.5 | 157.65 | 156.46 | 156.71 | 536244.0 |
| 2022-05-02 09:30:00 | AAPL | Stock | 156.79 | 158.04 | 155.31 | 156.79 | 13437146.0 |
| 2022-05-02 10:00:00 | AAPL | Stock | 156.79 | 157.135 | 154.59 | 156.39 | 12015531.0 |
| 2022-05-02 10:30:00 | AAPL | Stock | 156.4 | 157.71 | 156.02 | 156.29 | 7744270.0 |
| 2022-05-02 11:00:00 | AAPL | Stock | 156.29 | 156.58 | 155.56 | 155.86 | 5741913.0 |
| 2022-05-02 11:30:00 | AAPL | Stock | 155.87 | 156.04 | 155.01 | 155.845 | 6392520.0 |
| 2022-05-02 12:00:00 | AAPL | Stock | 155.84 | 156.594 | 154.92 | 156.1755 | 5046764.0 |
| 2022-05-02 12:30:00 | AAPL | Stock | 156.19 | 156.37 | 154.83 | 155.095 | 4631126.0 |
| 2022-05-02 13:00:00 | AAPL | Stock | 155.1 | 155.34 | 154.25 | 154.4371 | 4782747.0 |
| 2022-05-02 13:30:00 | AAPL | Stock | 154.43 | 154.81 | 153.705 | 154.0641 | 4866038.0 |
| 2022-05-02 14:00:00 | AAPL | Stock | 154.06 | 154.74 | 153.545 | 153.82 | 4286392.0 |
| 2022-05-02 14:30:00 | AAPL | Stock | 153.81 | 154.43 | 153.27 | 153.86 | 5275497.0 |
| 2022-05-02 15:00:00 | AAPL | Stock | 153.84 | 157.0 | 153.785 | 156.5301 | 8794922.0 |
| 2022-05-02 15:30:00 | AAPL | Stock | 156.53 | 158.23 | 156.52 | 157.96 | 13273768.0 |
| 2022-05-02 16:00:00 | AAPL | Stock | 157.9 | 158.3 | 156.95 | 157.52 | 9447282.0 |
| 2022-05-02 16:30:00 | AAPL | Stock | 157.54 | 158.03 | 157.53 | 157.98 | 105671.0 |
| 2022-05-02 17:00:00 | AAPL | Stock | 157.95 | 158.16 | 157.92 | 158.05 | 51916.0 |
| 2022-05-02 17:30:00 | AAPL | Stock | 158.05 | 158.09 | 157.91 | 157.95 | 19970.0 |
| 2022-05-02 18:00:00 | AAPL | Stock | 157.93 | 157.99 | 157.61 | 157.62 | 61035.0 |
| 2022-05-02 18:30:00 | AAPL | Stock | 157.61 | 157.65 | 157.4 | 157.5599 | 25395.0 |
| 2022-05-02 19:00:00 | AAPL | Stock | 157.55 | 157.9 | 157.55 | 157.88 | 9254.0 |
| 2022-05-02 19:30:00 | AAPL | Stock | 157.87 | 157.96 | 157.6 | 157.91 | 29414.0 |
| 2022-05-02 04:00:00 | MSFT | Stock | 278.12 | 279.1 | 278.11 | 279.1 | 4202.0 |
| 2022-05-02 04:30:00 | MSFT | Stock | 278.81 | 279.38 | 278.06 | 278.17 | 5416.0 |
| 2022-05-02 05:00:00 | MSFT | Stock | 278.21 | 278.35 | 278.15 | 278.31 | 978.0 |
| 2022-05-02 05:30:00 | MSFT | Stock | 278.87 | 278.91 | 278.87 | 278.88 | 797.0 |
| 2022-05-02 06:00:00 | MSFT | Stock | 278.41 | 279.0 | 278.41 | 278.76 | 354.0 |
| 2022-05-02 06:30:00 | MSFT | Stock | 278.8 | 278.89 | 277.95 | 277.95 | 893.0 |
| 2022-05-02 07:00:00 | MSFT | Stock | 278.27 | 278.3 | 277.95 | 278.28 | 8679.0 |
| 2022-05-02 07:30:00 | MSFT | Stock | 277.99 | 277.99 | 275.8 | 276.0 | 18317.0 |
| 2022-05-02 08:00:00 | MSFT | Stock | 278.2489 | 278.6433 | 275.4355 | 276.43 | 33309.0 |
| 2022-05-02 08:30:00 | MSFT | Stock | 276.67 | 276.81 | 276.0 | 276.23 | 15935.0 |
| 2022-05-02 09:00:00 | MSFT | Stock | 276.5882 | 278.4 | 276.58 | 277.68 | 42206.0 |
| 2022-05-02 09:30:00 | MSFT | Stock | 277.67 | 280.5 | 276.22 | 279.79 | 2969412.0 |
| 2022-05-02 10:00:00 | MSFT | Stock | 279.76 | 281.77 | 277.05 | 280.975 | 2040622.0 |
| 2022-05-02 10:30:00 | MSFT | Stock | 281.0 | 282.49 | 279.65 | 279.98 | 1665238.0 |
| 2022-05-02 11:00:00 | MSFT | Stock | 279.98 | 280.49 | 277.75 | 278.55 | 1121646.0 |
| 2022-05-02 11:30:00 | MSFT | Stock | 278.555 | 280.81 | 278.22 | 280.81 | 1086450.0 |
| 2022-05-02 12:00:00 | MSFT | Stock | 280.76 | 282.3 | 279.69 | 281.43 | 1435867.0 |
| 2022-05-02 12:30:00 | MSFT | Stock | 281.46 | 281.83 | 280.11 | 280.245 | 1257022.0 |
> showing 50 of 108,290 rows — these rows as CSV