PREVIEW / stock_30min / 2021-04-05
file: by_date/stock_30min/2021/2021-04-05.parquet size: 2.3 MB rows: 115,837 symbols: 2,953
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-04-05 04:00:00 | AAPL | Stock | 123.12 | 123.46 | 122.81 | 123.16 | 23102.0 |
| 2021-04-05 04:30:00 | AAPL | Stock | 123.2 | 123.38 | 123.04 | 123.12 | 4481.0 |
| 2021-04-05 05:00:00 | AAPL | Stock | 123.08 | 123.23 | 123.07 | 123.23 | 5774.0 |
| 2021-04-05 05:30:00 | AAPL | Stock | 123.32 | 123.5 | 123.32 | 123.38 | 7823.0 |
| 2021-04-05 06:00:00 | AAPL | Stock | 123.4 | 123.45 | 123.35 | 123.4 | 8552.0 |
| 2021-04-05 06:30:00 | AAPL | Stock | 123.45 | 123.45 | 123.0 | 123.09 | 11747.0 |
| 2021-04-05 07:00:00 | AAPL | Stock | 123.14 | 123.25 | 123.06 | 123.06 | 141420.0 |
| 2021-04-05 07:30:00 | AAPL | Stock | 123.06 | 123.39 | 123.04 | 123.35 | 77175.0 |
| 2021-04-05 08:00:00 | AAPL | Stock | 123.35 | 123.41 | 123.05 | 123.41 | 218595.0 |
| 2021-04-05 08:30:00 | AAPL | Stock | 123.4 | 124.0 | 123.39 | 123.8899 | 221774.0 |
| 2021-04-05 09:00:00 | AAPL | Stock | 123.89 | 123.96 | 123.52 | 123.76 | 466548.0 |
| 2021-04-05 09:30:00 | AAPL | Stock | 123.74 | 125.13 | 123.07 | 124.8161 | 13224203.0 |
| 2021-04-05 10:00:00 | AAPL | Stock | 124.81 | 125.46 | 124.56 | 125.1001 | 7962225.0 |
| 2021-04-05 10:30:00 | AAPL | Stock | 125.1 | 125.62 | 125.05 | 125.16 | 6504649.0 |
| 2021-04-05 11:00:00 | AAPL | Stock | 125.165 | 125.2 | 124.8301 | 124.9686 | 3722842.0 |
| 2021-04-05 11:30:00 | AAPL | Stock | 124.97 | 125.57 | 124.88 | 125.325 | 4444404.0 |
| 2021-04-05 12:00:00 | AAPL | Stock | 125.33 | 125.86 | 125.315 | 125.8283 | 3855503.0 |
| 2021-04-05 12:30:00 | AAPL | Stock | 125.83 | 125.96 | 125.46 | 125.5614 | 4027407.0 |
| 2021-04-05 13:00:00 | AAPL | Stock | 125.57 | 125.8 | 125.53 | 125.655 | 3093688.0 |
| 2021-04-05 13:30:00 | AAPL | Stock | 125.66 | 126.08 | 125.58 | 126.05 | 3364837.0 |
| 2021-04-05 14:00:00 | AAPL | Stock | 126.0439 | 126.1601 | 125.81 | 125.87 | 3661114.0 |
| 2021-04-05 14:30:00 | AAPL | Stock | 125.8781 | 126.11 | 125.6 | 125.63 | 3527558.0 |
| 2021-04-05 15:00:00 | AAPL | Stock | 125.635 | 125.82 | 125.465 | 125.549 | 4152799.0 |
| 2021-04-05 15:30:00 | AAPL | Stock | 125.545 | 126.0 | 125.3101 | 125.9 | 8380649.0 |
| 2021-04-05 16:00:00 | AAPL | Stock | 125.9 | 126.11 | 125.81 | 126.04 | 6577403.0 |
| 2021-04-05 16:30:00 | AAPL | Stock | 126.05 | 126.22 | 125.9 | 126.2 | 194932.0 |
| 2021-04-05 17:00:00 | AAPL | Stock | 126.19 | 126.28 | 126.19 | 126.24 | 61347.0 |
| 2021-04-05 17:30:00 | AAPL | Stock | 126.24 | 126.32 | 126.24 | 126.31 | 45058.0 |
| 2021-04-05 18:00:00 | AAPL | Stock | 126.3 | 126.33 | 126.2 | 126.25 | 52889.0 |
| 2021-04-05 18:30:00 | AAPL | Stock | 126.26 | 126.34 | 126.22 | 126.2999 | 39486.0 |
| 2021-04-05 19:00:00 | AAPL | Stock | 126.3 | 126.38 | 126.3 | 126.38 | 59714.0 |
| 2021-04-05 19:30:00 | AAPL | Stock | 126.38 | 126.5 | 126.34 | 126.5 | 117288.0 |
| 2021-04-05 04:00:00 | MSFT | Stock | 242.65 | 243.0 | 242.5 | 242.75 | 1065.0 |
| 2021-04-05 04:30:00 | MSFT | Stock | 242.88 | 242.88 | 242.42 | 242.45 | 1211.0 |
| 2021-04-05 05:00:00 | MSFT | Stock | 242.05 | 242.61 | 242.05 | 242.35 | 1098.0 |
| 2021-04-05 05:30:00 | MSFT | Stock | 242.9 | 243.05 | 242.9 | 243.0 | 3133.0 |
| 2021-04-05 06:00:00 | MSFT | Stock | 242.84 | 242.96 | 242.81 | 242.81 | 527.0 |
| 2021-04-05 06:30:00 | MSFT | Stock | 242.81 | 242.85 | 241.95 | 241.95 | 4721.0 |
| 2021-04-05 07:00:00 | MSFT | Stock | 242.48 | 242.76 | 241.92 | 242.02 | 35428.0 |
| 2021-04-05 07:30:00 | MSFT | Stock | 242.0 | 242.35 | 241.91 | 242.29 | 10338.0 |
| 2021-04-05 08:00:00 | MSFT | Stock | 242.5 | 242.5 | 241.745 | 242.37 | 26733.0 |
| 2021-04-05 08:30:00 | MSFT | Stock | 242.35 | 242.85 | 242.3 | 242.8 | 95672.0 |
| 2021-04-05 09:00:00 | MSFT | Stock | 242.8 | 242.95 | 242.42 | 242.72 | 30256.0 |
| 2021-04-05 09:30:00 | MSFT | Stock | 242.79 | 247.3 | 242.7 | 247.26 | 4242164.0 |
| 2021-04-05 10:00:00 | MSFT | Stock | 247.26 | 248.57 | 246.72 | 248.17 | 3508588.0 |
| 2021-04-05 10:30:00 | MSFT | Stock | 248.17 | 249.75 | 247.75 | 248.9 | 2297635.0 |
| 2021-04-05 11:00:00 | MSFT | Stock | 248.92 | 249.0 | 248.03 | 248.285 | 1727414.0 |
| 2021-04-05 11:30:00 | MSFT | Stock | 248.2733 | 249.505 | 248.24 | 248.85 | 1749856.0 |
| 2021-04-05 12:00:00 | MSFT | Stock | 248.87 | 249.54 | 248.87 | 249.0115 | 1439271.0 |
| 2021-04-05 12:30:00 | MSFT | Stock | 249.02 | 249.39 | 248.94 | 249.1 | 1105321.0 |
> showing 50 of 115,837 rows — these rows as CSV