PREVIEW / stock_30min / 2023-02-08
file: by_date/stock_30min/2023/2023-02-08.parquet size: 2.1 MB rows: 102,374 symbols: 1,849
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 |
|---|---|---|---|---|---|---|---|
| 2023-02-08 04:00:00 | AAPL | Stock | 154.15 | 154.38 | 153.87 | 154.0 | 31266.0 |
| 2023-02-08 04:30:00 | AAPL | Stock | 154.0 | 154.0 | 153.55 | 153.68 | 21185.0 |
| 2023-02-08 05:00:00 | AAPL | Stock | 153.86 | 153.88 | 153.5 | 153.68 | 14808.0 |
| 2023-02-08 05:30:00 | AAPL | Stock | 153.68 | 153.82 | 153.51 | 153.76 | 28600.0 |
| 2023-02-08 06:00:00 | AAPL | Stock | 153.76 | 153.88 | 153.52 | 153.53 | 10276.0 |
| 2023-02-08 06:30:00 | AAPL | Stock | 153.66 | 153.76 | 153.52 | 153.76 | 6418.0 |
| 2023-02-08 07:00:00 | AAPL | Stock | 153.74 | 154.24 | 153.74 | 154.0 | 36725.0 |
| 2023-02-08 07:30:00 | AAPL | Stock | 153.97 | 154.19 | 153.7 | 153.83 | 41798.0 |
| 2023-02-08 08:00:00 | AAPL | Stock | 153.9108 | 154.5 | 153.5515 | 153.79 | 131098.0 |
| 2023-02-08 08:30:00 | AAPL | Stock | 153.81 | 154.38 | 153.74 | 153.94 | 102720.0 |
| 2023-02-08 09:00:00 | AAPL | Stock | 153.9 | 154.28 | 153.66 | 153.77 | 166136.0 |
| 2023-02-08 09:30:00 | AAPL | Stock | 153.77 | 154.58 | 153.16 | 153.45 | 6747233.0 |
| 2023-02-08 10:00:00 | AAPL | Stock | 153.44 | 153.77 | 152.7601 | 152.96 | 4262753.0 |
| 2023-02-08 10:30:00 | AAPL | Stock | 152.95 | 153.4502 | 152.25 | 153.1612 | 4051973.0 |
| 2023-02-08 11:00:00 | AAPL | Stock | 153.1606 | 153.19 | 151.71 | 152.045 | 3937951.0 |
| 2023-02-08 11:30:00 | AAPL | Stock | 152.04 | 152.31 | 151.46 | 152.23 | 3208166.0 |
| 2023-02-08 12:00:00 | AAPL | Stock | 152.237 | 152.25 | 151.58 | 152.03 | 2087001.0 |
| 2023-02-08 12:30:00 | AAPL | Stock | 152.035 | 152.14 | 151.168 | 151.783 | 2197109.0 |
| 2023-02-08 13:00:00 | AAPL | Stock | 151.78 | 152.14 | 151.59 | 151.66 | 2175294.0 |
| 2023-02-08 13:30:00 | AAPL | Stock | 151.66 | 151.97 | 151.22 | 151.96 | 2060753.0 |
| 2023-02-08 14:00:00 | AAPL | Stock | 151.96 | 152.31 | 151.77 | 151.92 | 2102698.0 |
| 2023-02-08 14:30:00 | AAPL | Stock | 151.9216 | 152.265 | 151.67 | 152.19 | 2035235.0 |
| 2023-02-08 15:00:00 | AAPL | Stock | 152.19 | 152.3 | 151.565 | 151.64 | 2831716.0 |
| 2023-02-08 15:30:00 | AAPL | Stock | 151.64 | 152.16 | 151.49 | 151.945 | 7006418.0 |
| 2023-02-08 16:00:00 | AAPL | Stock | 151.96 | 152.35 | 151.92 | 152.26 | 9698993.0 |
| 2023-02-08 16:30:00 | AAPL | Stock | 152.25 | 152.49 | 151.92 | 152.43 | 88584.0 |
| 2023-02-08 17:00:00 | AAPL | Stock | 152.43 | 152.43 | 151.92 | 152.29 | 50224.0 |
| 2023-02-08 17:30:00 | AAPL | Stock | 152.2 | 152.2607 | 152.1 | 152.14 | 11204.0 |
| 2023-02-08 18:00:00 | AAPL | Stock | 152.14 | 152.26 | 152.1 | 152.2 | 10286.0 |
| 2023-02-08 18:30:00 | AAPL | Stock | 152.25 | 152.36 | 152.25 | 152.31 | 31711.0 |
| 2023-02-08 19:00:00 | AAPL | Stock | 152.33 | 152.5 | 152.33 | 152.49 | 16333.0 |
| 2023-02-08 19:30:00 | AAPL | Stock | 152.49 | 152.5 | 152.36 | 152.4 | 12627.0 |
| 2023-02-08 04:00:00 | MSFT | Stock | 270.0 | 272.94 | 269.4 | 272.7 | 25107.0 |
| 2023-02-08 04:30:00 | MSFT | Stock | 272.7 | 272.85 | 272.3 | 272.35 | 49225.0 |
| 2023-02-08 05:00:00 | MSFT | Stock | 272.47 | 272.5 | 271.58 | 272.1 | 19925.0 |
| 2023-02-08 05:30:00 | MSFT | Stock | 271.88 | 273.6 | 271.82 | 273.4 | 18265.0 |
| 2023-02-08 06:00:00 | MSFT | Stock | 273.56 | 273.56 | 272.75 | 272.8 | 15225.0 |
| 2023-02-08 06:30:00 | MSFT | Stock | 272.85 | 272.85 | 271.87 | 271.87 | 55827.0 |
| 2023-02-08 07:00:00 | MSFT | Stock | 271.97 | 272.58 | 270.71 | 271.97 | 80154.0 |
| 2023-02-08 07:30:00 | MSFT | Stock | 271.85 | 272.15 | 270.26 | 270.9 | 110015.0 |
| 2023-02-08 08:00:00 | MSFT | Stock | 272.5685 | 273.0115 | 266.892 | 270.25 | 220067.0 |
| 2023-02-08 08:30:00 | MSFT | Stock | 270.25 | 271.5 | 269.75 | 271.48 | 221534.0 |
| 2023-02-08 09:00:00 | MSFT | Stock | 271.48 | 273.4 | 271.304 | 273.13 | 487489.0 |
| 2023-02-08 09:30:00 | MSFT | Stock | 273.09 | 276.76 | 271.02 | 272.68 | 10376687.0 |
| 2023-02-08 10:00:00 | MSFT | Stock | 272.69 | 274.33 | 270.6076 | 272.3928 | 4271106.0 |
| 2023-02-08 10:30:00 | MSFT | Stock | 272.38 | 272.38 | 270.07 | 270.325 | 2569955.0 |
| 2023-02-08 11:00:00 | MSFT | Stock | 270.3101 | 270.53 | 267.61 | 268.2599 | 3366170.0 |
| 2023-02-08 11:30:00 | MSFT | Stock | 268.24 | 269.75 | 267.56 | 269.6799 | 2159596.0 |
| 2023-02-08 12:00:00 | MSFT | Stock | 269.65 | 270.25 | 268.52 | 269.93 | 1586160.0 |
| 2023-02-08 12:30:00 | MSFT | Stock | 269.92 | 270.03 | 268.63 | 269.7098 | 1153327.0 |
> showing 50 of 102,374 rows — these rows as CSV