PREVIEW / stock_30min / 2021-05-24
file: by_date/stock_30min/2021/2021-05-24.parquet size: 2.2 MB rows: 108,716 symbols: 2,945
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-05-24 04:00:00 | AAPL | Stock | 125.86 | 126.08 | 125.79 | 125.98 | 7589.0 |
| 2021-05-24 04:30:00 | AAPL | Stock | 125.96 | 125.96 | 125.72 | 125.9 | 4467.0 |
| 2021-05-24 05:00:00 | AAPL | Stock | 125.9 | 126.05 | 125.9 | 126.05 | 4189.0 |
| 2021-05-24 05:30:00 | AAPL | Stock | 126.03 | 126.5 | 125.99 | 126.5 | 12749.0 |
| 2021-05-24 06:00:00 | AAPL | Stock | 126.36 | 126.4 | 126.25 | 126.3 | 10537.0 |
| 2021-05-24 06:30:00 | AAPL | Stock | 126.3 | 126.3 | 126.16 | 126.27 | 885.0 |
| 2021-05-24 07:00:00 | AAPL | Stock | 126.18 | 126.35 | 125.89 | 125.95 | 52370.0 |
| 2021-05-24 07:30:00 | AAPL | Stock | 125.95 | 126.14 | 125.91 | 126.12 | 63043.0 |
| 2021-05-24 08:00:00 | AAPL | Stock | 126.1499 | 126.3 | 125.9 | 126.21 | 225101.0 |
| 2021-05-24 08:30:00 | AAPL | Stock | 126.21 | 126.32 | 126.17 | 126.2 | 95582.0 |
| 2021-05-24 09:00:00 | AAPL | Stock | 126.21 | 126.32 | 125.91 | 125.94 | 210326.0 |
| 2021-05-24 09:30:00 | AAPL | Stock | 126.01 | 127.04 | 125.94 | 126.655 | 9466044.0 |
| 2021-05-24 10:00:00 | AAPL | Stock | 126.67 | 127.66 | 126.66 | 127.53 | 6309987.0 |
| 2021-05-24 10:30:00 | AAPL | Stock | 127.53 | 127.6237 | 127.32 | 127.5323 | 4422775.0 |
| 2021-05-24 11:00:00 | AAPL | Stock | 127.535 | 127.65 | 127.38 | 127.51 | 3142530.0 |
| 2021-05-24 11:30:00 | AAPL | Stock | 127.51 | 127.68 | 127.465 | 127.54 | 2974944.0 |
| 2021-05-24 12:00:00 | AAPL | Stock | 127.5373 | 127.7802 | 127.39 | 127.4601 | 2888509.0 |
| 2021-05-24 12:30:00 | AAPL | Stock | 127.47 | 127.55 | 127.33 | 127.44 | 2036842.0 |
| 2021-05-24 13:00:00 | AAPL | Stock | 127.44 | 127.59 | 127.3684 | 127.5842 | 1706205.0 |
| 2021-05-24 13:30:00 | AAPL | Stock | 127.59 | 127.6899 | 127.53 | 127.6012 | 1687681.0 |
| 2021-05-24 14:00:00 | AAPL | Stock | 127.61 | 127.79 | 127.5905 | 127.735 | 2047779.0 |
| 2021-05-24 14:30:00 | AAPL | Stock | 127.735 | 127.94 | 127.72 | 127.765 | 2416569.0 |
| 2021-05-24 15:00:00 | AAPL | Stock | 127.77 | 127.91 | 127.63 | 127.715 | 2348673.0 |
| 2021-05-24 15:30:00 | AAPL | Stock | 127.72 | 127.72 | 127.0 | 127.11 | 7222139.0 |
| 2021-05-24 16:00:00 | AAPL | Stock | 127.1 | 127.17 | 126.9999 | 127.04 | 6804412.0 |
| 2021-05-24 16:30:00 | AAPL | Stock | 127.05 | 127.1 | 127.01 | 127.08 | 57004.0 |
| 2021-05-24 17:00:00 | AAPL | Stock | 127.07 | 127.1 | 127.03 | 127.06 | 32894.0 |
| 2021-05-24 17:30:00 | AAPL | Stock | 127.06 | 127.07 | 127.01 | 127.07 | 17176.0 |
| 2021-05-24 18:00:00 | AAPL | Stock | 127.07 | 127.17 | 127.03 | 127.12 | 29391.0 |
| 2021-05-24 18:30:00 | AAPL | Stock | 127.12 | 127.21 | 127.1 | 127.2 | 16175.0 |
| 2021-05-24 19:00:00 | AAPL | Stock | 127.2 | 127.27 | 127.18 | 127.25 | 22997.0 |
| 2021-05-24 19:30:00 | AAPL | Stock | 127.24 | 127.35 | 127.18 | 127.29 | 43825.0 |
| 2021-05-24 04:00:00 | MSFT | Stock | 246.31 | 246.5 | 246.31 | 246.5 | 1369.0 |
| 2021-05-24 04:30:00 | MSFT | Stock | 246.75 | 246.75 | 246.3 | 246.3 | 1329.0 |
| 2021-05-24 05:00:00 | MSFT | Stock | 246.52 | 246.7 | 246.52 | 246.7 | 398.0 |
| 2021-05-24 05:30:00 | MSFT | Stock | 246.66 | 246.66 | 246.42 | 246.5 | 3275.0 |
| 2021-05-24 06:00:00 | MSFT | Stock | 246.61 | 246.61 | 246.5 | 246.5 | 335.0 |
| 2021-05-24 07:00:00 | MSFT | Stock | 246.55 | 246.55 | 246.08 | 246.19 | 5609.0 |
| 2021-05-24 07:30:00 | MSFT | Stock | 246.25 | 246.7 | 246.23 | 246.7 | 10235.0 |
| 2021-05-24 08:00:00 | MSFT | Stock | 246.69 | 246.98 | 244.558 | 246.87 | 23782.0 |
| 2021-05-24 08:30:00 | MSFT | Stock | 246.8 | 247.0 | 245.17 | 246.8 | 97685.0 |
| 2021-05-24 09:00:00 | MSFT | Stock | 246.85 | 248.0 | 246.85 | 247.75 | 46478.0 |
| 2021-05-24 09:30:00 | MSFT | Stock | 247.77 | 250.04 | 247.51 | 249.64 | 2975203.0 |
| 2021-05-24 10:00:00 | MSFT | Stock | 249.64 | 250.6899 | 249.63 | 250.3 | 1401016.0 |
| 2021-05-24 10:30:00 | MSFT | Stock | 250.31 | 250.6 | 250.1301 | 250.42 | 856405.0 |
| 2021-05-24 11:00:00 | MSFT | Stock | 250.42 | 250.61 | 250.24 | 250.36 | 701617.0 |
| 2021-05-24 11:30:00 | MSFT | Stock | 250.37 | 250.86 | 250.2701 | 250.65 | 661247.0 |
| 2021-05-24 12:00:00 | MSFT | Stock | 250.65 | 251.04 | 250.36 | 250.4128 | 663507.0 |
| 2021-05-24 12:30:00 | MSFT | Stock | 250.43 | 250.59 | 250.05 | 250.28 | 538602.0 |
| 2021-05-24 13:00:00 | MSFT | Stock | 250.2701 | 250.61 | 250.0958 | 250.6 | 444082.0 |
> showing 50 of 108,716 rows — these rows as CSV