PREVIEW / stock_30min / 2022-12-01
file: by_date/stock_30min/2022/2022-12-01.parquet size: 2.1 MB rows: 103,635 symbols: 2,075
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-12-01 04:00:00 | AAPL | Stock | 148.08 | 148.08 | 147.04 | 147.37 | 32360.0 |
| 2022-12-01 04:30:00 | AAPL | Stock | 147.37 | 147.37 | 147.12 | 147.26 | 9215.0 |
| 2022-12-01 05:00:00 | AAPL | Stock | 147.31 | 147.51 | 147.2 | 147.38 | 16184.0 |
| 2022-12-01 05:30:00 | AAPL | Stock | 147.43 | 147.56 | 147.38 | 147.38 | 3833.0 |
| 2022-12-01 06:00:00 | AAPL | Stock | 147.3 | 147.38 | 147.24 | 147.24 | 4290.0 |
| 2022-12-01 06:30:00 | AAPL | Stock | 147.35 | 147.41 | 147.2 | 147.41 | 7200.0 |
| 2022-12-01 07:00:00 | AAPL | Stock | 147.35 | 147.66 | 147.33 | 147.5 | 88950.0 |
| 2022-12-01 07:30:00 | AAPL | Stock | 147.5 | 147.98 | 147.5 | 147.96 | 39394.0 |
| 2022-12-01 08:00:00 | AAPL | Stock | 147.36 | 148.47 | 147.1785 | 148.35 | 190730.0 |
| 2022-12-01 08:30:00 | AAPL | Stock | 148.15 | 149.14 | 148.0 | 148.22 | 373180.0 |
| 2022-12-01 09:00:00 | AAPL | Stock | 148.22 | 148.46 | 148.06 | 148.3 | 205364.0 |
| 2022-12-01 09:30:00 | AAPL | Stock | 148.21 | 149.13 | 147.41 | 148.27 | 7903282.0 |
| 2022-12-01 10:00:00 | AAPL | Stock | 148.3 | 148.62 | 146.7 | 146.78 | 5864595.0 |
| 2022-12-01 10:30:00 | AAPL | Stock | 146.78 | 148.22 | 146.61 | 148.211 | 4358712.0 |
| 2022-12-01 11:00:00 | AAPL | Stock | 148.23 | 148.26 | 147.71 | 147.83 | 3443644.0 |
| 2022-12-01 11:30:00 | AAPL | Stock | 147.825 | 148.1052 | 147.43 | 147.6599 | 2943288.0 |
| 2022-12-01 12:00:00 | AAPL | Stock | 147.65 | 147.7 | 147.1 | 147.545 | 2885672.0 |
| 2022-12-01 12:30:00 | AAPL | Stock | 147.55 | 148.0085 | 147.54 | 147.92 | 2422365.0 |
| 2022-12-01 13:00:00 | AAPL | Stock | 147.915 | 148.315 | 147.56 | 147.9188 | 2768304.0 |
| 2022-12-01 13:30:00 | AAPL | Stock | 147.91 | 148.4499 | 147.86 | 148.2043 | 2369832.0 |
| 2022-12-01 14:00:00 | AAPL | Stock | 148.2 | 148.64 | 147.96 | 148.56 | 2359270.0 |
| 2022-12-01 14:30:00 | AAPL | Stock | 148.5506 | 148.85 | 148.39 | 148.8357 | 2567744.0 |
| 2022-12-01 15:00:00 | AAPL | Stock | 148.84 | 148.97 | 148.28 | 148.34 | 2697110.0 |
| 2022-12-01 15:30:00 | AAPL | Stock | 148.345 | 149.0 | 148.31 | 148.33 | 5736090.0 |
| 2022-12-01 16:00:00 | AAPL | Stock | 148.36 | 148.36 | 148.13 | 148.13 | 9518721.0 |
| 2022-12-01 16:30:00 | AAPL | Stock | 148.13 | 148.31 | 148.13 | 148.2 | 64007.0 |
| 2022-12-01 17:00:00 | AAPL | Stock | 148.19 | 148.21 | 148.06 | 148.15 | 12745.0 |
| 2022-12-01 17:30:00 | AAPL | Stock | 148.13 | 148.25 | 148.13 | 148.15 | 14956.0 |
| 2022-12-01 18:00:00 | AAPL | Stock | 148.15 | 148.15 | 148.0 | 148.03 | 19845.0 |
| 2022-12-01 18:30:00 | AAPL | Stock | 148.03 | 148.14 | 147.96 | 148.02 | 6883.0 |
| 2022-12-01 19:00:00 | AAPL | Stock | 147.96 | 147.96 | 147.8 | 147.92 | 16645.0 |
| 2022-12-01 19:30:00 | AAPL | Stock | 147.92 | 148.1 | 147.82 | 147.86 | 20831.0 |
| 2022-12-01 04:00:00 | MSFT | Stock | 254.3 | 254.3 | 253.56 | 253.8 | 8293.0 |
| 2022-12-01 04:30:00 | MSFT | Stock | 253.8 | 253.8 | 253.7 | 253.7 | 367.0 |
| 2022-12-01 05:00:00 | MSFT | Stock | 253.73 | 253.8 | 253.57 | 253.78 | 2590.0 |
| 2022-12-01 05:30:00 | MSFT | Stock | 253.8 | 253.8 | 253.55 | 253.55 | 1430.0 |
| 2022-12-01 06:00:00 | MSFT | Stock | 253.4 | 253.5 | 253.13 | 253.5 | 3512.0 |
| 2022-12-01 06:30:00 | MSFT | Stock | 253.4 | 253.6 | 253.3 | 253.55 | 4658.0 |
| 2022-12-01 07:00:00 | MSFT | Stock | 253.8 | 254.15 | 253.2 | 253.2 | 8351.0 |
| 2022-12-01 07:30:00 | MSFT | Stock | 253.26 | 253.93 | 253.26 | 253.85 | 9051.0 |
| 2022-12-01 08:00:00 | MSFT | Stock | 253.7128 | 255.05 | 253.35 | 254.6 | 20669.0 |
| 2022-12-01 08:30:00 | MSFT | Stock | 254.3 | 255.79 | 254.2 | 254.3 | 56543.0 |
| 2022-12-01 09:00:00 | MSFT | Stock | 254.31 | 254.55 | 253.29 | 254.07 | 30106.0 |
| 2022-12-01 09:30:00 | MSFT | Stock | 254.13 | 256.12 | 253.13 | 254.785 | 2540836.0 |
| 2022-12-01 10:00:00 | MSFT | Stock | 254.84 | 255.68 | 251.41 | 251.61 | 1662634.0 |
| 2022-12-01 10:30:00 | MSFT | Stock | 251.64 | 254.0 | 250.9156 | 253.99 | 1227727.0 |
| 2022-12-01 11:00:00 | MSFT | Stock | 253.99 | 254.09 | 252.83 | 252.91 | 1056507.0 |
| 2022-12-01 11:30:00 | MSFT | Stock | 252.9 | 253.56 | 252.6 | 253.18 | 875198.0 |
| 2022-12-01 12:00:00 | MSFT | Stock | 253.19 | 253.955 | 252.33 | 253.83 | 699642.0 |
| 2022-12-01 12:30:00 | MSFT | Stock | 253.85 | 254.39 | 253.78 | 254.31 | 718716.0 |
> showing 50 of 103,635 rows — these rows as CSV