PREVIEW / stock_30min / 2022-10-11
file: by_date/stock_30min/2022/2022-10-11.parquet size: 2.0 MB rows: 101,456 symbols: 2,201
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-10-11 04:00:00 | AAPL | Stock | 139.69 | 140.03 | 139.34 | 139.62 | 19994.0 |
| 2022-10-11 04:30:00 | AAPL | Stock | 139.6 | 139.6 | 139.04 | 139.13 | 15358.0 |
| 2022-10-11 05:00:00 | AAPL | Stock | 139.17 | 139.46 | 139.13 | 139.35 | 7690.0 |
| 2022-10-11 05:30:00 | AAPL | Stock | 139.35 | 139.45 | 139.06 | 139.31 | 12364.0 |
| 2022-10-11 06:00:00 | AAPL | Stock | 139.17 | 139.49 | 139.0 | 139.27 | 30128.0 |
| 2022-10-11 06:30:00 | AAPL | Stock | 139.3 | 139.63 | 139.3 | 139.62 | 8717.0 |
| 2022-10-11 07:00:00 | AAPL | Stock | 139.62 | 140.05 | 139.62 | 139.98 | 58367.0 |
| 2022-10-11 07:30:00 | AAPL | Stock | 139.95 | 140.03 | 139.48 | 139.86 | 37749.0 |
| 2022-10-11 08:00:00 | AAPL | Stock | 139.7 | 140.4 | 139.0115 | 140.4 | 131237.0 |
| 2022-10-11 08:30:00 | AAPL | Stock | 140.36 | 140.58 | 140.05 | 140.06 | 131491.0 |
| 2022-10-11 09:00:00 | AAPL | Stock | 140.03 | 140.06 | 139.65 | 139.89 | 135847.0 |
| 2022-10-11 09:30:00 | AAPL | Stock | 139.89 | 140.0702 | 138.8401 | 138.88 | 8597404.0 |
| 2022-10-11 10:00:00 | AAPL | Stock | 138.88 | 139.28 | 138.36 | 138.98 | 5762426.0 |
| 2022-10-11 10:30:00 | AAPL | Stock | 138.98 | 139.83 | 138.72 | 139.0612 | 4647395.0 |
| 2022-10-11 11:00:00 | AAPL | Stock | 139.07 | 140.22 | 139.0214 | 139.86 | 4269182.0 |
| 2022-10-11 11:30:00 | AAPL | Stock | 139.86 | 140.78 | 139.72 | 140.3809 | 4005227.0 |
| 2022-10-11 12:00:00 | AAPL | Stock | 140.405 | 141.25 | 140.01 | 140.6926 | 3835302.0 |
| 2022-10-11 12:30:00 | AAPL | Stock | 140.7 | 141.35 | 140.66 | 140.7776 | 3197584.0 |
| 2022-10-11 13:00:00 | AAPL | Stock | 140.78 | 140.93 | 140.03 | 140.09 | 3162578.0 |
| 2022-10-11 13:30:00 | AAPL | Stock | 140.09 | 140.64 | 139.83 | 140.44 | 2919933.0 |
| 2022-10-11 14:00:00 | AAPL | Stock | 140.44 | 140.55 | 139.6528 | 140.085 | 3194608.0 |
| 2022-10-11 14:30:00 | AAPL | Stock | 140.085 | 140.305 | 138.52 | 138.65 | 4534836.0 |
| 2022-10-11 15:00:00 | AAPL | Stock | 138.655 | 138.955 | 138.22 | 138.8 | 5543622.0 |
| 2022-10-11 15:30:00 | AAPL | Stock | 138.8 | 139.25 | 138.46 | 138.95 | 7635749.0 |
| 2022-10-11 16:00:00 | AAPL | Stock | 138.95 | 139.2 | 138.71 | 139.07 | 6575448.0 |
| 2022-10-11 16:30:00 | AAPL | Stock | 139.06 | 139.34 | 138.98 | 139.25 | 52965.0 |
| 2022-10-11 17:00:00 | AAPL | Stock | 139.23 | 139.25 | 139.07 | 139.16 | 13895.0 |
| 2022-10-11 17:30:00 | AAPL | Stock | 139.12 | 139.1761 | 139.1 | 139.15 | 5699.0 |
| 2022-10-11 18:00:00 | AAPL | Stock | 139.15 | 139.33 | 139.11 | 139.17 | 16300.0 |
| 2022-10-11 18:30:00 | AAPL | Stock | 139.13 | 139.15 | 139.03 | 139.11 | 12348.0 |
| 2022-10-11 19:00:00 | AAPL | Stock | 139.11 | 139.23 | 139.0 | 139.1 | 15495.0 |
| 2022-10-11 19:30:00 | AAPL | Stock | 139.07 | 139.24 | 139.05 | 139.24 | 13305.0 |
| 2022-10-11 04:00:00 | MSFT | Stock | 228.98 | 228.98 | 228.0 | 228.0 | 915.0 |
| 2022-10-11 04:30:00 | MSFT | Stock | 227.63 | 227.63 | 226.79 | 226.79 | 1607.0 |
| 2022-10-11 05:00:00 | MSFT | Stock | 227.43 | 227.53 | 227.12 | 227.5 | 1595.0 |
| 2022-10-11 05:30:00 | MSFT | Stock | 227.29 | 227.29 | 226.81 | 227.0 | 4405.0 |
| 2022-10-11 06:00:00 | MSFT | Stock | 227.1 | 227.36 | 227.0 | 227.36 | 3697.0 |
| 2022-10-11 06:30:00 | MSFT | Stock | 227.74 | 228.0 | 227.74 | 228.0 | 4558.0 |
| 2022-10-11 07:00:00 | MSFT | Stock | 227.99 | 228.45 | 227.99 | 228.1 | 3904.0 |
| 2022-10-11 07:30:00 | MSFT | Stock | 228.1 | 228.25 | 227.9 | 228.1 | 2742.0 |
| 2022-10-11 08:00:00 | MSFT | Stock | 228.2 | 229.2374 | 227.79 | 229.1758 | 19788.0 |
| 2022-10-11 08:30:00 | MSFT | Stock | 229.0 | 229.45 | 228.57 | 228.64 | 23205.0 |
| 2022-10-11 09:00:00 | MSFT | Stock | 228.7 | 228.9 | 227.25 | 227.55 | 47167.0 |
| 2022-10-11 09:30:00 | MSFT | Stock | 227.6 | 227.94 | 225.21 | 225.44 | 2708054.0 |
| 2022-10-11 10:00:00 | MSFT | Stock | 225.41 | 226.21 | 224.92 | 225.82 | 2133876.0 |
| 2022-10-11 10:30:00 | MSFT | Stock | 225.8 | 227.12 | 225.28 | 225.82 | 1404890.0 |
| 2022-10-11 11:00:00 | MSFT | Stock | 225.84 | 227.67 | 225.56 | 227.52 | 1282513.0 |
| 2022-10-11 11:30:00 | MSFT | Stock | 227.515 | 229.03 | 227.11 | 228.09 | 1352329.0 |
| 2022-10-11 12:00:00 | MSFT | Stock | 228.11 | 229.04 | 227.19 | 228.38 | 966363.0 |
| 2022-10-11 12:30:00 | MSFT | Stock | 228.39 | 229.06 | 228.1 | 228.28 | 880021.0 |
> showing 50 of 101,456 rows — these rows as CSV