PREVIEW / stock_30min / 2022-11-30
file: by_date/stock_30min/2022/2022-11-30.parquet size: 2.1 MB rows: 105,035 symbols: 2,107
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-30 04:00:00 | AAPL | Stock | 143.5 | 143.82 | 141.5 | 142.48 | 27934.0 |
| 2022-11-30 04:30:00 | AAPL | Stock | 142.44 | 142.49 | 142.11 | 142.31 | 23253.0 |
| 2022-11-30 05:00:00 | AAPL | Stock | 142.34 | 142.38 | 142.2 | 142.2 | 10937.0 |
| 2022-11-30 05:30:00 | AAPL | Stock | 142.2 | 142.33 | 142.2 | 142.28 | 2894.0 |
| 2022-11-30 06:00:00 | AAPL | Stock | 142.17 | 142.2 | 141.96 | 142.01 | 9134.0 |
| 2022-11-30 06:30:00 | AAPL | Stock | 141.99 | 142.1 | 141.99 | 142.1 | 2976.0 |
| 2022-11-30 07:00:00 | AAPL | Stock | 142.07 | 142.14 | 141.91 | 142.01 | 37335.0 |
| 2022-11-30 07:30:00 | AAPL | Stock | 142.04 | 142.04 | 141.86 | 141.9 | 40055.0 |
| 2022-11-30 08:00:00 | AAPL | Stock | 142.0106 | 142.14 | 140.818 | 141.88 | 182965.0 |
| 2022-11-30 08:30:00 | AAPL | Stock | 141.92 | 141.98 | 141.3 | 141.36 | 250084.0 |
| 2022-11-30 09:00:00 | AAPL | Stock | 141.33 | 141.82 | 141.25 | 141.42 | 181043.0 |
| 2022-11-30 09:30:00 | AAPL | Stock | 141.395 | 142.37 | 140.55 | 141.9607 | 7751940.0 |
| 2022-11-30 10:00:00 | AAPL | Stock | 141.96 | 142.17 | 141.29 | 141.5 | 3868857.0 |
| 2022-11-30 10:30:00 | AAPL | Stock | 141.51 | 141.9 | 140.99 | 141.18 | 3420720.0 |
| 2022-11-30 11:00:00 | AAPL | Stock | 141.19 | 141.91 | 141.07 | 141.79 | 2892407.0 |
| 2022-11-30 11:30:00 | AAPL | Stock | 141.79 | 142.015 | 141.53 | 141.56 | 2448197.0 |
| 2022-11-30 12:00:00 | AAPL | Stock | 141.565 | 141.61 | 140.75 | 140.92 | 2660802.0 |
| 2022-11-30 12:30:00 | AAPL | Stock | 140.91 | 141.31 | 140.68 | 141.2509 | 2549075.0 |
| 2022-11-30 13:00:00 | AAPL | Stock | 141.25 | 141.72 | 141.165 | 141.56 | 2006818.0 |
| 2022-11-30 13:30:00 | AAPL | Stock | 141.555 | 144.46 | 141.13 | 144.19 | 8069572.0 |
| 2022-11-30 14:00:00 | AAPL | Stock | 144.18 | 146.53 | 144.15 | 146.2943 | 8694146.0 |
| 2022-11-30 14:30:00 | AAPL | Stock | 146.2876 | 146.48 | 145.645 | 146.09 | 5575326.0 |
| 2022-11-30 15:00:00 | AAPL | Stock | 146.1 | 147.1 | 145.99 | 147.08 | 5679128.0 |
| 2022-11-30 15:30:00 | AAPL | Stock | 147.075 | 148.03 | 147.05 | 148.01 | 12663500.0 |
| 2022-11-30 16:00:00 | AAPL | Stock | 148.01 | 148.72 | 147.71 | 147.8614 | 24661854.0 |
| 2022-11-30 16:30:00 | AAPL | Stock | 147.87 | 148.2 | 147.86 | 148.15 | 1656319.0 |
| 2022-11-30 17:00:00 | AAPL | Stock | 148.1501 | 148.2 | 148.0 | 148.0517 | 40278.0 |
| 2022-11-30 17:30:00 | AAPL | Stock | 148.05 | 148.18 | 148.02 | 148.05 | 50661.0 |
| 2022-11-30 18:00:00 | AAPL | Stock | 148.17 | 148.18 | 148.02 | 148.14 | 39632.0 |
| 2022-11-30 18:30:00 | AAPL | Stock | 148.14 | 148.29 | 148.0 | 148.2 | 30177.0 |
| 2022-11-30 19:00:00 | AAPL | Stock | 148.16 | 148.25 | 148.04 | 148.08 | 31489.0 |
| 2022-11-30 19:30:00 | AAPL | Stock | 148.06 | 148.18 | 147.91 | 148.18 | 30618.0 |
| 2022-11-30 04:00:00 | MSFT | Stock | 241.3 | 241.81 | 241.3 | 241.81 | 1182.0 |
| 2022-11-30 04:30:00 | MSFT | Stock | 241.76 | 241.76 | 240.48 | 240.48 | 330.0 |
| 2022-11-30 05:00:00 | MSFT | Stock | 241.0 | 241.0 | 241.0 | 241.0 | 100.0 |
| 2022-11-30 05:30:00 | MSFT | Stock | 241.3 | 241.3 | 241.3 | 241.3 | 200.0 |
| 2022-11-30 06:30:00 | MSFT | Stock | 241.28 | 241.55 | 241.28 | 241.55 | 200.0 |
| 2022-11-30 07:00:00 | MSFT | Stock | 241.44 | 241.44 | 241.2 | 241.28 | 4143.0 |
| 2022-11-30 07:30:00 | MSFT | Stock | 241.21 | 241.36 | 241.13 | 241.36 | 1911.0 |
| 2022-11-30 08:00:00 | MSFT | Stock | 241.3 | 243.42 | 238.1 | 241.7 | 8146.0 |
| 2022-11-30 08:30:00 | MSFT | Stock | 241.15 | 241.31 | 240.5 | 240.8 | 18066.0 |
| 2022-11-30 09:00:00 | MSFT | Stock | 240.72 | 241.1868 | 240.41 | 240.55 | 23098.0 |
| 2022-11-30 09:30:00 | MSFT | Stock | 240.56 | 243.94 | 239.86 | 243.47 | 1887863.0 |
| 2022-11-30 10:00:00 | MSFT | Stock | 243.47 | 243.82 | 241.63 | 241.9 | 968219.0 |
| 2022-11-30 10:30:00 | MSFT | Stock | 241.92 | 241.99 | 240.945 | 241.05 | 878817.0 |
| 2022-11-30 11:00:00 | MSFT | Stock | 241.06 | 241.5 | 240.56 | 241.29 | 712042.0 |
| 2022-11-30 11:30:00 | MSFT | Stock | 241.31 | 242.25 | 241.105 | 242.06 | 789210.0 |
| 2022-11-30 12:00:00 | MSFT | Stock | 242.08 | 242.4801 | 241.27 | 241.842 | 614550.0 |
| 2022-11-30 12:30:00 | MSFT | Stock | 241.84 | 242.28 | 241.72 | 241.87 | 442731.0 |
| 2022-11-30 13:00:00 | MSFT | Stock | 241.86 | 242.6699 | 241.815 | 242.05 | 608421.0 |
> showing 50 of 105,035 rows — these rows as CSV