PREVIEW / stock_30min / 2022-05-31
file: by_date/stock_30min/2022/2022-05-31.parquet size: 2.2 MB rows: 108,820 symbols: 2,414
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-05-31 04:00:00 | AAPL | Stock | 150.0 | 151.0 | 148.89 | 150.22 | 44863.0 |
| 2022-05-31 04:30:00 | AAPL | Stock | 150.22 | 150.25 | 150.0 | 150.01 | 19111.0 |
| 2022-05-31 05:00:00 | AAPL | Stock | 150.0 | 150.0 | 149.15 | 149.28 | 18157.0 |
| 2022-05-31 05:30:00 | AAPL | Stock | 149.21 | 149.41 | 148.99 | 149.05 | 27726.0 |
| 2022-05-31 06:00:00 | AAPL | Stock | 149.01 | 149.01 | 148.73 | 148.83 | 27021.0 |
| 2022-05-31 06:30:00 | AAPL | Stock | 148.86 | 149.37 | 148.86 | 149.23 | 8416.0 |
| 2022-05-31 07:00:00 | AAPL | Stock | 149.25 | 149.6 | 149.18 | 149.35 | 57382.0 |
| 2022-05-31 07:30:00 | AAPL | Stock | 149.34 | 149.78 | 149.3 | 149.5 | 40371.0 |
| 2022-05-31 08:00:00 | AAPL | Stock | 149.44 | 150.69 | 148.8 | 148.8899 | 418234.0 |
| 2022-05-31 08:30:00 | AAPL | Stock | 148.89 | 148.92 | 148.59 | 148.6898 | 179309.0 |
| 2022-05-31 09:00:00 | AAPL | Stock | 148.65 | 149.64 | 148.6199 | 149.0 | 277150.0 |
| 2022-05-31 09:30:00 | AAPL | Stock | 149.07 | 150.26 | 147.58 | 147.881 | 10876440.0 |
| 2022-05-31 10:00:00 | AAPL | Stock | 147.875 | 148.2401 | 146.84 | 147.99 | 6238554.0 |
| 2022-05-31 10:30:00 | AAPL | Stock | 147.98 | 148.79 | 147.9 | 148.519 | 3941926.0 |
| 2022-05-31 11:00:00 | AAPL | Stock | 148.51 | 149.0501 | 147.855 | 148.1899 | 3718371.0 |
| 2022-05-31 11:30:00 | AAPL | Stock | 148.17 | 150.2401 | 147.98 | 149.973 | 4709630.0 |
| 2022-05-31 12:00:00 | AAPL | Stock | 149.9796 | 150.58 | 149.23 | 149.7 | 5144612.0 |
| 2022-05-31 12:30:00 | AAPL | Stock | 149.71 | 150.515 | 149.57 | 149.9699 | 4305229.0 |
| 2022-05-31 13:00:00 | AAPL | Stock | 149.96 | 150.66 | 149.36 | 149.53 | 3987048.0 |
| 2022-05-31 13:30:00 | AAPL | Stock | 149.55 | 150.3 | 149.5 | 150.235 | 3271314.0 |
| 2022-05-31 14:00:00 | AAPL | Stock | 150.23 | 150.49 | 149.9943 | 150.14 | 2751105.0 |
| 2022-05-31 14:30:00 | AAPL | Stock | 150.15 | 150.29 | 148.765 | 149.095 | 3413652.0 |
| 2022-05-31 15:00:00 | AAPL | Stock | 149.0901 | 150.118 | 148.8 | 150.03 | 3745433.0 |
| 2022-05-31 15:30:00 | AAPL | Stock | 150.0289 | 150.51 | 148.73 | 148.84 | 8489865.0 |
| 2022-05-31 16:00:00 | AAPL | Stock | 148.76 | 149.28 | 148.5 | 149.09 | 21674966.0 |
| 2022-05-31 16:30:00 | AAPL | Stock | 149.03 | 149.11 | 148.78 | 148.9102 | 96862.0 |
| 2022-05-31 17:00:00 | AAPL | Stock | 148.9548 | 148.99 | 148.85 | 148.9 | 14842.0 |
| 2022-05-31 17:30:00 | AAPL | Stock | 148.91 | 148.97 | 148.89 | 148.93 | 14113.0 |
| 2022-05-31 18:00:00 | AAPL | Stock | 148.95 | 149.09 | 148.93 | 148.99 | 27975.0 |
| 2022-05-31 18:30:00 | AAPL | Stock | 149.0 | 149.59 | 149.0 | 149.33 | 20615.0 |
| 2022-05-31 19:00:00 | AAPL | Stock | 149.33 | 149.6 | 149.25 | 149.53 | 16125.0 |
| 2022-05-31 19:30:00 | AAPL | Stock | 149.55 | 149.57 | 149.35 | 149.5 | 34394.0 |
| 2022-05-31 04:00:00 | MSFT | Stock | 273.64 | 274.27 | 272.21 | 274.27 | 4898.0 |
| 2022-05-31 04:30:00 | MSFT | Stock | 274.35 | 274.35 | 274.02 | 274.02 | 1262.0 |
| 2022-05-31 05:00:00 | MSFT | Stock | 273.53 | 273.53 | 272.02 | 272.57 | 1187.0 |
| 2022-05-31 05:30:00 | MSFT | Stock | 272.97 | 272.97 | 271.87 | 272.25 | 3962.0 |
| 2022-05-31 06:00:00 | MSFT | Stock | 271.97 | 272.25 | 271.68 | 271.71 | 4419.0 |
| 2022-05-31 06:30:00 | MSFT | Stock | 271.7 | 272.7 | 271.7 | 272.6 | 5225.0 |
| 2022-05-31 07:00:00 | MSFT | Stock | 272.7 | 273.08 | 272.5 | 272.5 | 19319.0 |
| 2022-05-31 07:30:00 | MSFT | Stock | 272.4 | 272.99 | 272.25 | 272.6 | 6580.0 |
| 2022-05-31 08:00:00 | MSFT | Stock | 272.65 | 275.41 | 271.01 | 271.35 | 36306.0 |
| 2022-05-31 08:30:00 | MSFT | Stock | 271.3 | 271.55 | 271.01 | 271.5 | 15037.0 |
| 2022-05-31 09:00:00 | MSFT | Stock | 271.3001 | 273.15 | 271.3001 | 272.25 | 35625.0 |
| 2022-05-31 09:30:00 | MSFT | Stock | 272.49 | 272.65 | 269.315 | 270.785 | 3003321.0 |
| 2022-05-31 10:00:00 | MSFT | Stock | 270.76 | 271.16 | 268.93 | 270.58 | 1315362.0 |
| 2022-05-31 10:30:00 | MSFT | Stock | 270.49 | 271.41 | 270.46 | 271.14 | 1079116.0 |
| 2022-05-31 11:00:00 | MSFT | Stock | 271.1525 | 271.7 | 270.31 | 270.61 | 955393.0 |
| 2022-05-31 11:30:00 | MSFT | Stock | 270.57 | 273.42 | 270.18 | 272.99 | 953257.0 |
| 2022-05-31 12:00:00 | MSFT | Stock | 272.97 | 273.9 | 272.02 | 272.77 | 859804.0 |
| 2022-05-31 12:30:00 | MSFT | Stock | 272.755 | 273.56 | 272.58 | 273.3268 | 776267.0 |
> showing 50 of 108,820 rows — these rows as CSV