PREVIEW / stock_30min / 2006-11-08
file: by_date/stock_30min/2006/2006-11-08.parquet size: 961 KB rows: 52,159 symbols: 2,420
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-08 07:00:00 | AAPL | Stock | 2.8764 | 2.8764 | 2.8682 | 2.8682 | 8400.0 |
| 2006-11-08 07:30:00 | AAPL | Stock | 2.8675 | 2.8675 | 2.8586 | 2.8586 | 28000.0 |
| 2006-11-08 08:00:00 | AAPL | Stock | 2.8675 | 2.8714 | 2.8589 | 2.8625 | 452172.0 |
| 2006-11-08 08:30:00 | AAPL | Stock | 2.8636 | 2.8639 | 2.8543 | 2.855 | 814072.0 |
| 2006-11-08 09:00:00 | AAPL | Stock | 2.855 | 2.8625 | 2.8507 | 2.8582 | 1030680.0 |
| 2006-11-08 09:30:00 | AAPL | Stock | 2.8579 | 2.8864 | 2.8532 | 2.8818 | 73743264.0 |
| 2006-11-08 10:00:00 | AAPL | Stock | 2.8818 | 2.8996 | 2.8804 | 2.8886 | 67199720.0 |
| 2006-11-08 10:30:00 | AAPL | Stock | 2.8893 | 2.9029 | 2.8832 | 2.8979 | 45370976.0 |
| 2006-11-08 11:00:00 | AAPL | Stock | 2.8975 | 2.8996 | 2.8871 | 2.8936 | 25512116.0 |
| 2006-11-08 11:30:00 | AAPL | Stock | 2.8929 | 2.8932 | 2.8793 | 2.8882 | 22172948.0 |
| 2006-11-08 12:00:00 | AAPL | Stock | 2.8882 | 2.9018 | 2.8882 | 2.8971 | 33925584.0 |
| 2006-11-08 12:30:00 | AAPL | Stock | 2.8968 | 2.9075 | 2.8946 | 2.9039 | 39114180.0 |
| 2006-11-08 13:00:00 | AAPL | Stock | 2.9036 | 2.9229 | 2.9036 | 2.9136 | 64300516.0 |
| 2006-11-08 13:30:00 | AAPL | Stock | 2.9129 | 2.9286 | 2.9125 | 2.9264 | 59936548.0 |
| 2006-11-08 14:00:00 | AAPL | Stock | 2.9264 | 2.9318 | 2.9179 | 2.9189 | 50245944.0 |
| 2006-11-08 14:30:00 | AAPL | Stock | 2.9189 | 2.9321 | 2.9168 | 2.93 | 36546860.0 |
| 2006-11-08 15:00:00 | AAPL | Stock | 2.93 | 2.9489 | 2.9232 | 2.9393 | 47690216.0 |
| 2006-11-08 15:30:00 | AAPL | Stock | 2.9389 | 2.9532 | 2.9279 | 2.9429 | 91452424.0 |
| 2006-11-08 16:00:00 | AAPL | Stock | 2.945 | 2.9521 | 2.9429 | 2.9464 | 2286004.0 |
| 2006-11-08 16:30:00 | AAPL | Stock | 2.9464 | 2.9518 | 2.9446 | 2.9446 | 11646964.0 |
| 2006-11-08 17:00:00 | AAPL | Stock | 2.9464 | 2.95 | 2.9425 | 2.9464 | 2022832.0 |
| 2006-11-08 17:30:00 | AAPL | Stock | 2.9446 | 2.9518 | 2.9446 | 2.9457 | 679448.0 |
| 2006-11-08 18:00:00 | AAPL | Stock | 2.95 | 2.9532 | 2.9482 | 2.9532 | 389088.0 |
| 2006-11-08 18:30:00 | AAPL | Stock | 2.9525 | 2.9564 | 2.9525 | 2.9564 | 102060.0 |
| 2006-11-08 19:00:00 | AAPL | Stock | 2.9564 | 2.9575 | 2.9539 | 2.9554 | 81676.0 |
| 2006-11-08 19:30:00 | AAPL | Stock | 2.9571 | 2.9607 | 2.9568 | 2.9607 | 100660.0 |
| 2006-11-08 07:00:00 | MSFT | Stock | 28.9 | 28.9 | 28.9 | 28.9 | 100.0 |
| 2006-11-08 07:30:00 | MSFT | Stock | 28.85 | 28.85 | 28.85 | 28.85 | 100.0 |
| 2006-11-08 08:00:00 | MSFT | Stock | 28.82 | 29.24 | 28.82 | 28.88 | 36398.0 |
| 2006-11-08 08:30:00 | MSFT | Stock | 28.89 | 28.94 | 28.83 | 28.85 | 15964.0 |
| 2006-11-08 09:00:00 | MSFT | Stock | 28.87 | 28.87 | 28.77 | 28.78 | 221334.0 |
| 2006-11-08 09:30:00 | MSFT | Stock | 28.78 | 28.85 | 28.66 | 28.82 | 9440338.0 |
| 2006-11-08 10:00:00 | MSFT | Stock | 28.81 | 28.89 | 28.8 | 28.87 | 3881749.0 |
| 2006-11-08 10:30:00 | MSFT | Stock | 28.87 | 28.88 | 28.78 | 28.85 | 2989058.0 |
| 2006-11-08 11:00:00 | MSFT | Stock | 28.85 | 28.87 | 28.77 | 28.85 | 3077857.0 |
| 2006-11-08 11:30:00 | MSFT | Stock | 28.85 | 28.87 | 28.83 | 28.86 | 1690101.0 |
| 2006-11-08 12:00:00 | MSFT | Stock | 28.86 | 28.92 | 28.85 | 28.873 | 2374389.0 |
| 2006-11-08 12:30:00 | MSFT | Stock | 28.87 | 28.92 | 28.82 | 28.86 | 2152440.0 |
| 2006-11-08 13:00:00 | MSFT | Stock | 28.862 | 28.91 | 28.84 | 28.9 | 1914229.0 |
| 2006-11-08 13:30:00 | MSFT | Stock | 28.91 | 29.03 | 28.9 | 29.02 | 6227033.0 |
| 2006-11-08 14:00:00 | MSFT | Stock | 29.02 | 29.23 | 28.95 | 29.032 | 19722770.0 |
| 2006-11-08 14:30:00 | MSFT | Stock | 29.04 | 29.167 | 29.0 | 29.05 | 6447416.0 |
| 2006-11-08 15:00:00 | MSFT | Stock | 29.05 | 29.13 | 29.03 | 29.08 | 3734565.0 |
| 2006-11-08 15:30:00 | MSFT | Stock | 29.08 | 29.12 | 28.96 | 28.99 | 6535943.0 |
| 2006-11-08 16:00:00 | MSFT | Stock | 28.99 | 29.16 | 28.95 | 28.99 | 1190375.0 |
| 2006-11-08 16:30:00 | MSFT | Stock | 28.99 | 29.09 | 28.99 | 29.09 | 15400.0 |
| 2006-11-08 17:00:00 | MSFT | Stock | 29.09 | 29.25 | 29.09 | 29.2 | 89815.0 |
| 2006-11-08 17:30:00 | MSFT | Stock | 29.2 | 29.23 | 29.1 | 29.23 | 28566.0 |
| 2006-11-08 18:00:00 | MSFT | Stock | 29.2 | 29.2 | 28.98 | 29.12 | 1740467.0 |
| 2006-11-08 18:30:00 | MSFT | Stock | 29.2 | 29.2 | 29.2 | 29.2 | 600.0 |
> showing 50 of 52,159 rows — these rows as CSV