PREVIEW / stock_30min / 2021-10-19
file: by_date/stock_30min/2021/2021-10-19.parquet size: 2.2 MB rows: 108,742 symbols: 2,676
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-19 04:00:00 | AAPL | Stock | 146.79 | 147.17 | 146.79 | 147.1 | 11187.0 |
| 2021-10-19 04:30:00 | AAPL | Stock | 147.05 | 147.19 | 147.05 | 147.17 | 4878.0 |
| 2021-10-19 05:00:00 | AAPL | Stock | 147.19 | 147.2 | 147.09 | 147.16 | 5703.0 |
| 2021-10-19 05:30:00 | AAPL | Stock | 147.16 | 147.22 | 147.16 | 147.2 | 2916.0 |
| 2021-10-19 06:00:00 | AAPL | Stock | 147.21 | 147.44 | 147.2 | 147.44 | 6460.0 |
| 2021-10-19 06:30:00 | AAPL | Stock | 147.5 | 147.5 | 147.37 | 147.44 | 15312.0 |
| 2021-10-19 07:00:00 | AAPL | Stock | 147.33 | 147.63 | 147.29 | 147.59 | 50149.0 |
| 2021-10-19 07:30:00 | AAPL | Stock | 147.59 | 147.6 | 147.32 | 147.4 | 99568.0 |
| 2021-10-19 08:00:00 | AAPL | Stock | 147.4 | 147.64 | 147.3 | 147.31 | 244166.0 |
| 2021-10-19 08:30:00 | AAPL | Stock | 147.3 | 147.4 | 147.21 | 147.24 | 132222.0 |
| 2021-10-19 09:00:00 | AAPL | Stock | 147.22 | 147.22 | 146.8 | 147.0 | 362266.0 |
| 2021-10-19 09:30:00 | AAPL | Stock | 146.99 | 147.89 | 146.55 | 147.78 | 11929281.0 |
| 2021-10-19 10:00:00 | AAPL | Stock | 147.789 | 148.82 | 147.6417 | 148.76 | 8171768.0 |
| 2021-10-19 10:30:00 | AAPL | Stock | 148.76 | 149.04 | 148.29 | 148.9264 | 6639327.0 |
| 2021-10-19 11:00:00 | AAPL | Stock | 148.9201 | 149.17 | 148.23 | 148.385 | 5783970.0 |
| 2021-10-19 11:30:00 | AAPL | Stock | 148.38 | 148.6199 | 148.22 | 148.52 | 3832643.0 |
| 2021-10-19 12:00:00 | AAPL | Stock | 148.52 | 148.76 | 148.37 | 148.7599 | 3113749.0 |
| 2021-10-19 12:30:00 | AAPL | Stock | 148.7597 | 148.92 | 148.5 | 148.87 | 3056772.0 |
| 2021-10-19 13:00:00 | AAPL | Stock | 148.875 | 149.045 | 148.715 | 148.89 | 2681823.0 |
| 2021-10-19 13:30:00 | AAPL | Stock | 148.885 | 148.98 | 148.77 | 148.845 | 2074411.0 |
| 2021-10-19 14:00:00 | AAPL | Stock | 148.845 | 148.88 | 148.48 | 148.535 | 2295068.0 |
| 2021-10-19 14:30:00 | AAPL | Stock | 148.54 | 148.7099 | 148.335 | 148.675 | 2638318.0 |
| 2021-10-19 15:00:00 | AAPL | Stock | 148.67 | 148.8373 | 148.33 | 148.46 | 3117267.0 |
| 2021-10-19 15:30:00 | AAPL | Stock | 148.455 | 148.82 | 148.26 | 148.78 | 5409138.0 |
| 2021-10-19 16:00:00 | AAPL | Stock | 148.79 | 148.86 | 148.64 | 148.82 | 5614661.0 |
| 2021-10-19 16:30:00 | AAPL | Stock | 148.82 | 148.84 | 148.66 | 148.81 | 27558.0 |
| 2021-10-19 17:00:00 | AAPL | Stock | 148.79 | 148.83 | 148.62 | 148.7796 | 47652.0 |
| 2021-10-19 17:30:00 | AAPL | Stock | 148.75 | 148.8 | 148.71 | 148.71 | 14299.0 |
| 2021-10-19 18:00:00 | AAPL | Stock | 148.7 | 148.73 | 148.6 | 148.61 | 39413.0 |
| 2021-10-19 18:30:00 | AAPL | Stock | 148.61 | 148.66 | 148.53 | 148.66 | 13153.0 |
| 2021-10-19 19:00:00 | AAPL | Stock | 148.62 | 148.64 | 148.55 | 148.58 | 18630.0 |
| 2021-10-19 19:30:00 | AAPL | Stock | 148.59 | 148.66 | 148.56 | 148.6 | 59261.0 |
| 2021-10-19 04:00:00 | MSFT | Stock | 307.82 | 307.82 | 307.79 | 307.79 | 350.0 |
| 2021-10-19 04:30:00 | MSFT | Stock | 308.2 | 308.22 | 308.0 | 308.0 | 10559.0 |
| 2021-10-19 05:30:00 | MSFT | Stock | 308.28 | 308.4 | 308.28 | 308.4 | 1288.0 |
| 2021-10-19 06:00:00 | MSFT | Stock | 308.33 | 308.45 | 308.33 | 308.45 | 1348.0 |
| 2021-10-19 06:30:00 | MSFT | Stock | 308.6 | 308.6 | 308.58 | 308.58 | 272.0 |
| 2021-10-19 07:00:00 | MSFT | Stock | 308.3 | 308.6 | 308.25 | 308.55 | 10950.0 |
| 2021-10-19 07:30:00 | MSFT | Stock | 308.52 | 308.61 | 308.37 | 308.5 | 6496.0 |
| 2021-10-19 08:00:00 | MSFT | Stock | 308.5927 | 308.69 | 308.25 | 308.36 | 15709.0 |
| 2021-10-19 08:30:00 | MSFT | Stock | 308.37 | 308.4 | 307.7 | 307.8 | 18139.0 |
| 2021-10-19 09:00:00 | MSFT | Stock | 307.86 | 308.75 | 307.5 | 308.2 | 54184.0 |
| 2021-10-19 09:30:00 | MSFT | Stock | 308.22 | 309.3 | 307.22 | 308.1 | 2492871.0 |
| 2021-10-19 10:00:00 | MSFT | Stock | 308.1 | 308.96 | 307.8 | 308.65 | 1202816.0 |
| 2021-10-19 10:30:00 | MSFT | Stock | 308.67 | 308.9799 | 307.977 | 308.94 | 912150.0 |
| 2021-10-19 11:00:00 | MSFT | Stock | 308.95 | 309.0 | 308.06 | 308.29 | 630328.0 |
| 2021-10-19 11:30:00 | MSFT | Stock | 308.3 | 308.43 | 307.87 | 307.93 | 600496.0 |
| 2021-10-19 12:00:00 | MSFT | Stock | 307.93 | 308.09 | 307.69 | 308.05 | 453012.0 |
| 2021-10-19 12:30:00 | MSFT | Stock | 308.0624 | 308.42 | 308.0 | 308.2061 | 417311.0 |
| 2021-10-19 13:00:00 | MSFT | Stock | 308.21 | 308.605 | 308.05 | 308.23 | 457927.0 |
> showing 50 of 108,742 rows — these rows as CSV