PREVIEW / stock_30min / 2022-09-22
file: by_date/stock_30min/2022/2022-09-22.parquet size: 2.1 MB rows: 104,020 symbols: 2,234
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-09-22 04:00:00 | AAPL | Stock | 153.02 | 154.96 | 153.02 | 154.03 | 40249.0 |
| 2022-09-22 04:30:00 | AAPL | Stock | 154.2 | 154.9 | 154.16 | 154.46 | 33900.0 |
| 2022-09-22 05:00:00 | AAPL | Stock | 154.5 | 154.53 | 153.84 | 153.95 | 24352.0 |
| 2022-09-22 05:30:00 | AAPL | Stock | 153.91 | 154.13 | 153.57 | 153.88 | 12597.0 |
| 2022-09-22 06:00:00 | AAPL | Stock | 153.78 | 153.84 | 153.55 | 153.55 | 3212.0 |
| 2022-09-22 06:30:00 | AAPL | Stock | 153.93 | 154.0 | 153.81 | 153.98 | 5968.0 |
| 2022-09-22 07:00:00 | AAPL | Stock | 153.9 | 154.0 | 153.0 | 153.0 | 42890.0 |
| 2022-09-22 07:30:00 | AAPL | Stock | 153.05 | 153.75 | 153.01 | 153.53 | 28622.0 |
| 2022-09-22 08:00:00 | AAPL | Stock | 153.581 | 154.0 | 152.91 | 153.64 | 125108.0 |
| 2022-09-22 08:30:00 | AAPL | Stock | 153.6 | 154.51 | 153.01 | 153.96 | 162727.0 |
| 2022-09-22 09:00:00 | AAPL | Stock | 153.93 | 154.09 | 152.1 | 152.3 | 399180.0 |
| 2022-09-22 09:30:00 | AAPL | Stock | 152.39 | 153.53 | 151.66 | 152.11 | 11066414.0 |
| 2022-09-22 10:00:00 | AAPL | Stock | 152.12 | 153.09 | 151.95 | 152.42 | 6859323.0 |
| 2022-09-22 10:30:00 | AAPL | Stock | 152.411 | 152.81 | 151.71 | 151.7599 | 5726527.0 |
| 2022-09-22 11:00:00 | AAPL | Stock | 151.76 | 151.99 | 150.91 | 151.22 | 5348502.0 |
| 2022-09-22 11:30:00 | AAPL | Stock | 151.23 | 152.25 | 151.16 | 151.855 | 4059912.0 |
| 2022-09-22 12:00:00 | AAPL | Stock | 151.83 | 152.41 | 151.515 | 152.033 | 3202369.0 |
| 2022-09-22 12:30:00 | AAPL | Stock | 152.04 | 152.91 | 151.89 | 152.56 | 3941542.0 |
| 2022-09-22 13:00:00 | AAPL | Stock | 152.56 | 152.64 | 151.88 | 152.4062 | 3122015.0 |
| 2022-09-22 13:30:00 | AAPL | Stock | 152.4 | 152.98 | 152.32 | 152.6995 | 3659164.0 |
| 2022-09-22 14:00:00 | AAPL | Stock | 152.69 | 152.845 | 152.0 | 152.1 | 3098784.0 |
| 2022-09-22 14:30:00 | AAPL | Stock | 152.11 | 152.88 | 151.9698 | 152.82 | 3432237.0 |
| 2022-09-22 15:00:00 | AAPL | Stock | 152.81 | 153.97 | 152.81 | 153.67 | 6239850.0 |
| 2022-09-22 15:30:00 | AAPL | Stock | 153.68 | 154.47 | 152.61 | 152.7 | 9174758.0 |
| 2022-09-22 16:00:00 | AAPL | Stock | 152.69 | 152.86 | 152.3 | 152.3 | 5881272.0 |
| 2022-09-22 16:30:00 | AAPL | Stock | 152.35 | 152.75 | 152.3104 | 152.63 | 121870.0 |
| 2022-09-22 17:00:00 | AAPL | Stock | 152.66 | 152.74 | 152.47 | 152.72 | 30985.0 |
| 2022-09-22 17:30:00 | AAPL | Stock | 152.72 | 152.89 | 152.7 | 152.7935 | 28544.0 |
| 2022-09-22 18:00:00 | AAPL | Stock | 152.8 | 152.99 | 152.56 | 152.83 | 21592.0 |
| 2022-09-22 18:30:00 | AAPL | Stock | 152.8 | 152.84 | 152.51 | 152.54 | 9578.0 |
| 2022-09-22 19:00:00 | AAPL | Stock | 152.57 | 152.79 | 152.57 | 152.69 | 5606.0 |
| 2022-09-22 19:30:00 | AAPL | Stock | 152.68 | 153.1 | 152.66 | 153.0 | 25788.0 |
| 2022-09-22 04:00:00 | MSFT | Stock | 238.95 | 240.69 | 238.95 | 240.3 | 4337.0 |
| 2022-09-22 04:30:00 | MSFT | Stock | 240.37 | 241.48 | 240.36 | 240.75 | 3131.0 |
| 2022-09-22 05:00:00 | MSFT | Stock | 240.15 | 240.15 | 239.7 | 239.89 | 2281.0 |
| 2022-09-22 05:30:00 | MSFT | Stock | 239.62 | 239.62 | 239.0 | 239.4 | 2203.0 |
| 2022-09-22 06:00:00 | MSFT | Stock | 239.27 | 239.4 | 239.27 | 239.4 | 1705.0 |
| 2022-09-22 07:00:00 | MSFT | Stock | 239.69 | 239.7 | 237.62 | 237.62 | 16374.0 |
| 2022-09-22 07:30:00 | MSFT | Stock | 237.98 | 239.59 | 237.98 | 239.21 | 15645.0 |
| 2022-09-22 08:00:00 | MSFT | Stock | 239.6 | 239.85 | 237.8107 | 239.54 | 24292.0 |
| 2022-09-22 08:30:00 | MSFT | Stock | 239.25 | 240.5 | 239.0 | 239.63 | 24649.0 |
| 2022-09-22 09:00:00 | MSFT | Stock | 239.811 | 240.1748 | 237.51 | 238.12 | 45416.0 |
| 2022-09-22 09:30:00 | MSFT | Stock | 238.18 | 240.919 | 237.57 | 240.28 | 3206177.0 |
| 2022-09-22 10:00:00 | MSFT | Stock | 240.26 | 241.06 | 239.37 | 240.01 | 1936963.0 |
| 2022-09-22 10:30:00 | MSFT | Stock | 240.01 | 240.7363 | 239.5 | 239.59 | 1665644.0 |
| 2022-09-22 11:00:00 | MSFT | Stock | 239.595 | 239.97 | 239.1775 | 239.76 | 1485222.0 |
| 2022-09-22 11:30:00 | MSFT | Stock | 239.78 | 241.3147 | 239.6889 | 241.14 | 1230757.0 |
| 2022-09-22 12:00:00 | MSFT | Stock | 241.12 | 241.67 | 240.25 | 240.8294 | 937526.0 |
| 2022-09-22 12:30:00 | MSFT | Stock | 240.82 | 241.1942 | 240.2 | 240.27 | 855765.0 |
| 2022-09-22 13:00:00 | MSFT | Stock | 240.3 | 240.5 | 239.75 | 240.36 | 685996.0 |
> showing 50 of 104,020 rows — these rows as CSV