PREVIEW / stock_30min / 2022-11-21
file: by_date/stock_30min/2022/2022-11-21.parquet size: 2.1 MB rows: 101,994 symbols: 2,089
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-21 04:00:00 | AAPL | Stock | 150.1 | 150.65 | 150.01 | 150.2 | 13762.0 |
| 2022-11-21 04:30:00 | AAPL | Stock | 150.19 | 150.25 | 150.09 | 150.17 | 3958.0 |
| 2022-11-21 05:00:00 | AAPL | Stock | 150.16 | 150.2 | 149.08 | 149.44 | 12554.0 |
| 2022-11-21 05:30:00 | AAPL | Stock | 149.5 | 149.69 | 149.5 | 149.69 | 2524.0 |
| 2022-11-21 06:00:00 | AAPL | Stock | 149.7 | 149.86 | 149.6 | 149.6 | 2004.0 |
| 2022-11-21 06:30:00 | AAPL | Stock | 149.76 | 149.77 | 149.28 | 149.35 | 5814.0 |
| 2022-11-21 07:00:00 | AAPL | Stock | 149.42 | 149.72 | 149.36 | 149.6 | 33572.0 |
| 2022-11-21 07:30:00 | AAPL | Stock | 149.6 | 149.88 | 149.6 | 149.77 | 14452.0 |
| 2022-11-21 08:00:00 | AAPL | Stock | 150.65 | 150.79 | 149.4315 | 150.36 | 159050.0 |
| 2022-11-21 08:30:00 | AAPL | Stock | 150.42 | 150.45 | 149.93 | 150.27 | 71720.0 |
| 2022-11-21 09:00:00 | AAPL | Stock | 150.2 | 150.49 | 149.86 | 150.07 | 186951.0 |
| 2022-11-21 09:30:00 | AAPL | Stock | 150.08 | 150.37 | 148.46 | 149.64 | 7528436.0 |
| 2022-11-21 10:00:00 | AAPL | Stock | 149.66 | 149.96 | 148.21 | 148.35 | 4543566.0 |
| 2022-11-21 10:30:00 | AAPL | Stock | 148.35 | 148.54 | 147.78 | 148.0601 | 3677136.0 |
| 2022-11-21 11:00:00 | AAPL | Stock | 148.06 | 148.74 | 147.86 | 148.35 | 3345255.0 |
| 2022-11-21 11:30:00 | AAPL | Stock | 148.35 | 148.49 | 147.75 | 148.076 | 2716455.0 |
| 2022-11-21 12:00:00 | AAPL | Stock | 148.075 | 148.3591 | 147.715 | 147.781 | 2074273.0 |
| 2022-11-21 12:30:00 | AAPL | Stock | 147.79 | 148.36 | 147.7605 | 147.99 | 2318510.0 |
| 2022-11-21 13:00:00 | AAPL | Stock | 147.98 | 148.648 | 147.905 | 148.56 | 2626933.0 |
| 2022-11-21 13:30:00 | AAPL | Stock | 148.56 | 149.03 | 148.42 | 148.51 | 2319524.0 |
| 2022-11-21 14:00:00 | AAPL | Stock | 148.5 | 148.76 | 148.28 | 148.33 | 2199833.0 |
| 2022-11-21 14:30:00 | AAPL | Stock | 148.35 | 148.6 | 148.23 | 148.39 | 1733543.0 |
| 2022-11-21 15:00:00 | AAPL | Stock | 148.4 | 148.6 | 148.08 | 148.195 | 2588459.0 |
| 2022-11-21 15:30:00 | AAPL | Stock | 148.2 | 148.44 | 147.88 | 148.02 | 5592447.0 |
| 2022-11-21 16:00:00 | AAPL | Stock | 148.02 | 148.29 | 147.8 | 148.1 | 7107346.0 |
| 2022-11-21 16:30:00 | AAPL | Stock | 148.0946 | 148.18 | 148.01 | 148.05 | 67107.0 |
| 2022-11-21 17:00:00 | AAPL | Stock | 148.05 | 148.09 | 148.01 | 148.04 | 39993.0 |
| 2022-11-21 17:30:00 | AAPL | Stock | 148.06 | 148.0684 | 148.01 | 148.02 | 18400.0 |
| 2022-11-21 18:00:00 | AAPL | Stock | 148.05 | 148.1 | 148.01 | 148.01 | 10307.0 |
| 2022-11-21 18:30:00 | AAPL | Stock | 148.02 | 148.06 | 148.01 | 148.03 | 11482.0 |
| 2022-11-21 19:00:00 | AAPL | Stock | 148.06 | 148.26 | 148.06 | 148.26 | 27708.0 |
| 2022-11-21 19:30:00 | AAPL | Stock | 148.26 | 148.27 | 148.1 | 148.12 | 14887.0 |
| 2022-11-21 04:00:00 | MSFT | Stock | 240.5 | 240.5 | 240.0 | 240.0 | 1036.0 |
| 2022-11-21 04:30:00 | MSFT | Stock | 240.0 | 240.05 | 239.82 | 240.05 | 712.0 |
| 2022-11-21 05:30:00 | MSFT | Stock | 239.83 | 239.83 | 239.83 | 239.83 | 100.0 |
| 2022-11-21 06:00:00 | MSFT | Stock | 239.85 | 240.0 | 239.8 | 239.9 | 3364.0 |
| 2022-11-21 06:30:00 | MSFT | Stock | 239.9 | 239.9 | 239.5 | 239.5 | 14737.0 |
| 2022-11-21 07:00:00 | MSFT | Stock | 239.72 | 240.03 | 239.4 | 239.68 | 8776.0 |
| 2022-11-21 07:30:00 | MSFT | Stock | 239.88 | 240.15 | 239.81 | 240.15 | 2038.0 |
| 2022-11-21 08:00:00 | MSFT | Stock | 239.5502 | 240.78 | 239.48 | 240.65 | 15103.0 |
| 2022-11-21 08:30:00 | MSFT | Stock | 240.65 | 240.89 | 240.48 | 240.88 | 5696.0 |
| 2022-11-21 09:00:00 | MSFT | Stock | 240.89 | 241.7883 | 240.22 | 241.39 | 19357.0 |
| 2022-11-21 09:30:00 | MSFT | Stock | 241.39 | 244.67 | 241.19 | 243.27 | 2422515.0 |
| 2022-11-21 10:00:00 | MSFT | Stock | 243.32 | 243.58 | 241.24 | 241.9 | 1598674.0 |
| 2022-11-21 10:30:00 | MSFT | Stock | 241.83 | 242.41 | 241.451 | 241.9 | 1698014.0 |
| 2022-11-21 11:00:00 | MSFT | Stock | 241.91 | 243.07 | 241.66 | 242.41 | 1126112.0 |
| 2022-11-21 11:30:00 | MSFT | Stock | 242.43 | 242.69 | 241.77 | 242.3 | 897217.0 |
| 2022-11-21 12:00:00 | MSFT | Stock | 242.305 | 242.61 | 241.78 | 241.91 | 856768.0 |
| 2022-11-21 12:30:00 | MSFT | Stock | 241.8911 | 242.64 | 241.3526 | 241.56 | 818404.0 |
| 2022-11-21 13:00:00 | MSFT | Stock | 241.54 | 242.65 | 241.52 | 242.48 | 897095.0 |
> showing 50 of 101,994 rows — these rows as CSV