PREVIEW / stock_30min / 2022-11-16
file: by_date/stock_30min/2022/2022-11-16.parquet size: 2.1 MB rows: 102,409 symbols: 2,069
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-16 04:00:00 | AAPL | Stock | 150.25 | 150.28 | 149.75 | 149.87 | 52685.0 |
| 2022-11-16 04:30:00 | AAPL | Stock | 149.87 | 150.13 | 149.76 | 150.09 | 30788.0 |
| 2022-11-16 05:00:00 | AAPL | Stock | 150.12 | 150.57 | 150.12 | 150.4 | 8851.0 |
| 2022-11-16 05:30:00 | AAPL | Stock | 150.36 | 150.36 | 150.04 | 150.1 | 7559.0 |
| 2022-11-16 06:00:00 | AAPL | Stock | 150.1 | 150.1 | 149.75 | 150.04 | 28076.0 |
| 2022-11-16 06:30:00 | AAPL | Stock | 150.04 | 150.1 | 149.5 | 149.81 | 39676.0 |
| 2022-11-16 07:00:00 | AAPL | Stock | 149.81 | 150.2 | 149.57 | 149.9 | 61507.0 |
| 2022-11-16 07:30:00 | AAPL | Stock | 149.84 | 150.25 | 149.83 | 150.09 | 20379.0 |
| 2022-11-16 08:00:00 | AAPL | Stock | 150.5 | 151.23 | 149.55 | 149.85 | 149384.0 |
| 2022-11-16 08:30:00 | AAPL | Stock | 149.85 | 150.39 | 148.0 | 149.07 | 338724.0 |
| 2022-11-16 09:00:00 | AAPL | Stock | 149.03 | 149.63 | 148.37 | 149.05 | 331021.0 |
| 2022-11-16 09:30:00 | AAPL | Stock | 148.96 | 149.87 | 147.9474 | 148.27 | 7375268.0 |
| 2022-11-16 10:00:00 | AAPL | Stock | 148.26 | 148.395 | 147.29 | 148.205 | 5036384.0 |
| 2022-11-16 10:30:00 | AAPL | Stock | 148.2085 | 148.9 | 147.64 | 147.735 | 4648015.0 |
| 2022-11-16 11:00:00 | AAPL | Stock | 147.735 | 148.66 | 147.67 | 148.3582 | 3530373.0 |
| 2022-11-16 11:30:00 | AAPL | Stock | 148.35 | 148.76 | 148.17 | 148.43 | 2957260.0 |
| 2022-11-16 12:00:00 | AAPL | Stock | 148.43 | 148.88 | 148.18 | 148.7759 | 2806597.0 |
| 2022-11-16 12:30:00 | AAPL | Stock | 148.78 | 149.5 | 148.62 | 148.75 | 3538274.0 |
| 2022-11-16 13:00:00 | AAPL | Stock | 148.735 | 149.31 | 148.53 | 149.17 | 2133967.0 |
| 2022-11-16 13:30:00 | AAPL | Stock | 149.18 | 149.33 | 148.53 | 148.61 | 1786902.0 |
| 2022-11-16 14:00:00 | AAPL | Stock | 148.605 | 148.86 | 148.5 | 148.63 | 1805869.0 |
| 2022-11-16 14:30:00 | AAPL | Stock | 148.64 | 149.0766 | 148.28 | 149.0455 | 2415900.0 |
| 2022-11-16 15:00:00 | AAPL | Stock | 149.037 | 149.05 | 148.355 | 148.71 | 2535528.0 |
| 2022-11-16 15:30:00 | AAPL | Stock | 148.71 | 149.25 | 148.4201 | 148.78 | 5596621.0 |
| 2022-11-16 16:00:00 | AAPL | Stock | 148.78 | 149.38 | 148.644 | 149.15 | 8480252.0 |
| 2022-11-16 16:30:00 | AAPL | Stock | 149.05 | 149.05 | 148.6 | 148.76 | 54670.0 |
| 2022-11-16 17:00:00 | AAPL | Stock | 148.8 | 148.85 | 148.7324 | 148.77 | 39936.0 |
| 2022-11-16 17:30:00 | AAPL | Stock | 148.7711 | 148.88 | 148.77 | 148.88 | 4289.0 |
| 2022-11-16 18:00:00 | AAPL | Stock | 148.85 | 148.98 | 148.85 | 148.85 | 7416.0 |
| 2022-11-16 18:30:00 | AAPL | Stock | 148.89 | 149.18 | 148.89 | 149.17 | 7326.0 |
| 2022-11-16 19:00:00 | AAPL | Stock | 149.18 | 149.19 | 148.85 | 148.9 | 10550.0 |
| 2022-11-16 19:30:00 | AAPL | Stock | 148.91 | 148.95 | 148.86 | 148.9 | 12905.0 |
| 2022-11-16 04:00:00 | MSFT | Stock | 241.78 | 241.98 | 241.5 | 241.75 | 6959.0 |
| 2022-11-16 04:30:00 | MSFT | Stock | 241.75 | 242.0 | 241.66 | 242.0 | 3065.0 |
| 2022-11-16 05:00:00 | MSFT | Stock | 241.98 | 242.4 | 241.98 | 242.4 | 1355.0 |
| 2022-11-16 05:30:00 | MSFT | Stock | 242.37 | 242.37 | 241.89 | 241.89 | 787.0 |
| 2022-11-16 06:00:00 | MSFT | Stock | 241.1 | 241.1 | 241.1 | 241.1 | 258.0 |
| 2022-11-16 06:30:00 | MSFT | Stock | 241.29 | 242.09 | 241.26 | 241.82 | 4597.0 |
| 2022-11-16 07:00:00 | MSFT | Stock | 241.77 | 241.77 | 241.17 | 241.74 | 3534.0 |
| 2022-11-16 07:30:00 | MSFT | Stock | 241.69 | 241.95 | 241.57 | 241.95 | 4866.0 |
| 2022-11-16 08:00:00 | MSFT | Stock | 241.5 | 241.826 | 240.687 | 241.4004 | 11979.0 |
| 2022-11-16 08:30:00 | MSFT | Stock | 241.33 | 242.26 | 240.1 | 240.92 | 24615.0 |
| 2022-11-16 09:00:00 | MSFT | Stock | 240.93 | 242.65 | 240.92 | 242.55 | 34706.0 |
| 2022-11-16 09:30:00 | MSFT | Stock | 242.71 | 243.65 | 241.71 | 242.76 | 2301765.0 |
| 2022-11-16 10:00:00 | MSFT | Stock | 242.79 | 243.0 | 240.42 | 240.91 | 1425159.0 |
| 2022-11-16 10:30:00 | MSFT | Stock | 240.855 | 241.9 | 240.47 | 240.74 | 954416.0 |
| 2022-11-16 11:00:00 | MSFT | Stock | 240.76 | 241.6547 | 240.67 | 241.55 | 761765.0 |
| 2022-11-16 11:30:00 | MSFT | Stock | 241.5217 | 242.59 | 241.5217 | 242.27 | 903997.0 |
| 2022-11-16 12:00:00 | MSFT | Stock | 242.23 | 242.44 | 241.8665 | 242.34 | 579948.0 |
| 2022-11-16 12:30:00 | MSFT | Stock | 242.35 | 243.8 | 242.21 | 243.0 | 798793.0 |
> showing 50 of 102,409 rows — these rows as CSV