PREVIEW / stock_30min / 2022-10-05
file: by_date/stock_30min/2022/2022-10-05.parquet size: 2.0 MB rows: 101,942 symbols: 2,159
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-05 04:00:00 | AAPL | Stock | 145.44 | 145.44 | 144.37 | 144.37 | 17618.0 |
| 2022-10-05 04:30:00 | AAPL | Stock | 144.48 | 144.92 | 144.37 | 144.92 | 5897.0 |
| 2022-10-05 05:00:00 | AAPL | Stock | 144.8 | 144.9 | 144.65 | 144.81 | 4802.0 |
| 2022-10-05 05:30:00 | AAPL | Stock | 144.89 | 144.89 | 144.4 | 144.57 | 6802.0 |
| 2022-10-05 06:00:00 | AAPL | Stock | 144.62 | 144.83 | 144.57 | 144.71 | 7004.0 |
| 2022-10-05 06:30:00 | AAPL | Stock | 144.88 | 144.94 | 144.77 | 144.93 | 6507.0 |
| 2022-10-05 07:00:00 | AAPL | Stock | 144.94 | 145.0 | 144.83 | 144.95 | 35552.0 |
| 2022-10-05 07:30:00 | AAPL | Stock | 144.99 | 145.0 | 144.7 | 144.8 | 40266.0 |
| 2022-10-05 08:00:00 | AAPL | Stock | 144.96 | 145.8 | 144.3115 | 144.6 | 135415.0 |
| 2022-10-05 08:30:00 | AAPL | Stock | 144.63 | 144.83 | 144.32 | 144.35 | 101400.0 |
| 2022-10-05 09:00:00 | AAPL | Stock | 144.33 | 144.42 | 143.67 | 144.02 | 192419.0 |
| 2022-10-05 09:30:00 | AAPL | Stock | 144.07 | 145.33 | 143.915 | 145.195 | 8676091.0 |
| 2022-10-05 10:00:00 | AAPL | Stock | 145.19 | 145.3 | 143.351 | 143.415 | 6665112.0 |
| 2022-10-05 10:30:00 | AAPL | Stock | 143.41 | 143.86 | 143.01 | 143.61 | 4938209.0 |
| 2022-10-05 11:00:00 | AAPL | Stock | 143.59 | 144.43 | 143.54 | 144.14 | 4404535.0 |
| 2022-10-05 11:30:00 | AAPL | Stock | 144.15 | 144.48 | 143.86 | 144.38 | 3398596.0 |
| 2022-10-05 12:00:00 | AAPL | Stock | 144.4 | 145.5299 | 144.01 | 145.09 | 4615888.0 |
| 2022-10-05 12:30:00 | AAPL | Stock | 145.09 | 145.905 | 144.94 | 145.445 | 3069932.0 |
| 2022-10-05 13:00:00 | AAPL | Stock | 145.45 | 146.26 | 145.36 | 145.8655 | 3515795.0 |
| 2022-10-05 13:30:00 | AAPL | Stock | 145.86 | 145.98 | 145.32 | 145.3471 | 2508664.0 |
| 2022-10-05 14:00:00 | AAPL | Stock | 145.345 | 146.1 | 145.2795 | 145.9599 | 3148991.0 |
| 2022-10-05 14:30:00 | AAPL | Stock | 145.96 | 146.46 | 145.74 | 146.4155 | 3472691.0 |
| 2022-10-05 15:00:00 | AAPL | Stock | 146.415 | 147.38 | 146.415 | 146.765 | 5685605.0 |
| 2022-10-05 15:30:00 | AAPL | Stock | 146.77 | 147.09 | 145.87 | 146.42 | 8877178.0 |
| 2022-10-05 16:00:00 | AAPL | Stock | 146.42 | 146.8 | 146.0 | 146.37 | 5437051.0 |
| 2022-10-05 16:30:00 | AAPL | Stock | 146.38 | 146.45 | 146.23 | 146.28 | 93691.0 |
| 2022-10-05 17:00:00 | AAPL | Stock | 146.28 | 146.33 | 146.11 | 146.25 | 17393.0 |
| 2022-10-05 17:30:00 | AAPL | Stock | 146.16 | 146.2 | 146.08 | 146.15 | 19454.0 |
| 2022-10-05 18:00:00 | AAPL | Stock | 146.15 | 146.36 | 146.02 | 146.19 | 23742.0 |
| 2022-10-05 18:30:00 | AAPL | Stock | 146.22 | 146.55 | 146.2 | 146.4 | 40474.0 |
| 2022-10-05 19:00:00 | AAPL | Stock | 146.5 | 146.56 | 146.25 | 146.41 | 12214.0 |
| 2022-10-05 19:30:00 | AAPL | Stock | 146.43 | 147.4 | 146.4 | 147.31 | 35530.0 |
| 2022-10-05 04:00:00 | MSFT | Stock | 247.35 | 247.5 | 246.67 | 246.67 | 1091.0 |
| 2022-10-05 04:30:00 | MSFT | Stock | 246.04 | 246.67 | 245.74 | 246.63 | 702.0 |
| 2022-10-05 05:00:00 | MSFT | Stock | 246.8 | 246.8 | 246.5 | 246.6 | 848.0 |
| 2022-10-05 05:30:00 | MSFT | Stock | 246.59 | 246.59 | 246.0 | 246.34 | 1232.0 |
| 2022-10-05 06:00:00 | MSFT | Stock | 246.5 | 246.96 | 246.5 | 246.96 | 1542.0 |
| 2022-10-05 06:30:00 | MSFT | Stock | 246.96 | 247.15 | 246.96 | 247.15 | 412.0 |
| 2022-10-05 07:00:00 | MSFT | Stock | 247.35 | 247.35 | 246.75 | 247.03 | 7920.0 |
| 2022-10-05 07:30:00 | MSFT | Stock | 247.03 | 247.1 | 246.8 | 246.8 | 5489.0 |
| 2022-10-05 08:00:00 | MSFT | Stock | 246.7501 | 248.258 | 246.06 | 246.38 | 17480.0 |
| 2022-10-05 08:30:00 | MSFT | Stock | 246.65 | 246.8 | 245.91 | 246.0 | 22416.0 |
| 2022-10-05 09:00:00 | MSFT | Stock | 246.01 | 247.55 | 245.5 | 245.99 | 38231.0 |
| 2022-10-05 09:30:00 | MSFT | Stock | 246.05 | 247.27 | 245.26 | 246.14 | 1776964.0 |
| 2022-10-05 10:00:00 | MSFT | Stock | 246.06 | 246.14 | 244.23 | 244.45 | 1207555.0 |
| 2022-10-05 10:30:00 | MSFT | Stock | 244.42 | 245.05 | 244.11 | 244.345 | 995453.0 |
| 2022-10-05 11:00:00 | MSFT | Stock | 244.365 | 245.63 | 244.28 | 245.27 | 796542.0 |
| 2022-10-05 11:30:00 | MSFT | Stock | 245.29 | 245.9381 | 245.11 | 245.64 | 699437.0 |
| 2022-10-05 12:00:00 | MSFT | Stock | 245.64 | 247.55 | 244.99 | 246.97 | 821799.0 |
| 2022-10-05 12:30:00 | MSFT | Stock | 246.97 | 248.26 | 246.89 | 247.65 | 739731.0 |
> showing 50 of 101,942 rows — these rows as CSV