PREVIEW / stock_30min / 2006-11-07
file: by_date/stock_30min/2006/2006-11-07.parquet size: 955 KB rows: 51,228 symbols: 2,426
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-07 07:00:00 | AAPL | Stock | 2.8546 | 2.8571 | 2.8546 | 2.8571 | 64400.0 |
| 2006-11-07 07:30:00 | AAPL | Stock | 2.8625 | 2.8636 | 2.8607 | 2.8636 | 75600.0 |
| 2006-11-07 08:00:00 | AAPL | Stock | 2.8546 | 2.8625 | 2.8543 | 2.8607 | 326088.0 |
| 2006-11-07 08:30:00 | AAPL | Stock | 2.8607 | 2.8671 | 2.8579 | 2.8643 | 1168468.0 |
| 2006-11-07 09:00:00 | AAPL | Stock | 2.8654 | 2.8732 | 2.8579 | 2.8732 | 1627892.0 |
| 2006-11-07 09:30:00 | AAPL | Stock | 2.8732 | 2.8796 | 2.8618 | 2.8718 | 71268512.0 |
| 2006-11-07 10:00:00 | AAPL | Stock | 2.8718 | 2.8804 | 2.8682 | 2.8761 | 54601288.0 |
| 2006-11-07 10:30:00 | AAPL | Stock | 2.8757 | 2.8825 | 2.8746 | 2.8818 | 40516196.0 |
| 2006-11-07 11:00:00 | AAPL | Stock | 2.8818 | 2.8893 | 2.8786 | 2.8889 | 26734288.0 |
| 2006-11-07 11:30:00 | AAPL | Stock | 2.8893 | 2.8921 | 2.885 | 2.8893 | 33990292.0 |
| 2006-11-07 12:00:00 | AAPL | Stock | 2.8886 | 2.8911 | 2.8839 | 2.8846 | 20840064.0 |
| 2006-11-07 12:30:00 | AAPL | Stock | 2.8846 | 2.8929 | 2.8843 | 2.8914 | 25409720.0 |
| 2006-11-07 13:00:00 | AAPL | Stock | 2.8914 | 2.8921 | 2.8832 | 2.8857 | 27261080.0 |
| 2006-11-07 13:30:00 | AAPL | Stock | 2.8857 | 2.8886 | 2.8832 | 2.8871 | 17202360.0 |
| 2006-11-07 14:00:00 | AAPL | Stock | 2.8871 | 2.8879 | 2.8732 | 2.8771 | 54366676.0 |
| 2006-11-07 14:30:00 | AAPL | Stock | 2.8775 | 2.8829 | 2.8739 | 2.8818 | 29212792.0 |
| 2006-11-07 15:00:00 | AAPL | Stock | 2.8821 | 2.8864 | 2.8711 | 2.875 | 32638060.0 |
| 2006-11-07 15:30:00 | AAPL | Stock | 2.875 | 2.8907 | 2.8686 | 2.875 | 80269336.0 |
| 2006-11-07 16:00:00 | AAPL | Stock | 2.8754 | 2.8768 | 2.8746 | 2.8746 | 3385928.0 |
| 2006-11-07 16:30:00 | AAPL | Stock | 2.8739 | 2.8739 | 2.8736 | 2.8739 | 379400.0 |
| 2006-11-07 17:00:00 | AAPL | Stock | 2.8739 | 2.8739 | 2.8729 | 2.8739 | 37996.0 |
| 2006-11-07 17:30:00 | AAPL | Stock | 2.8725 | 2.8729 | 2.8696 | 2.8696 | 72352.0 |
| 2006-11-07 18:00:00 | AAPL | Stock | 2.8729 | 2.8743 | 2.8721 | 2.8721 | 28756.0 |
| 2006-11-07 18:30:00 | AAPL | Stock | 2.8721 | 2.8721 | 2.8714 | 2.8714 | 28840.0 |
| 2006-11-07 19:30:00 | AAPL | Stock | 2.8696 | 2.8714 | 2.8668 | 2.8668 | 86800.0 |
| 2006-11-07 07:30:00 | MSFT | Stock | 28.84 | 28.84 | 28.72 | 28.72 | 1700.0 |
| 2006-11-07 08:00:00 | MSFT | Stock | 28.78 | 28.93 | 28.75 | 28.84 | 89080.0 |
| 2006-11-07 08:30:00 | MSFT | Stock | 28.85 | 28.93 | 28.84 | 28.91 | 65010.0 |
| 2006-11-07 09:00:00 | MSFT | Stock | 28.91 | 28.97 | 28.83 | 28.85 | 120945.0 |
| 2006-11-07 09:30:00 | MSFT | Stock | 28.86 | 28.93 | 28.8 | 28.93 | 6179789.0 |
| 2006-11-07 10:00:00 | MSFT | Stock | 28.92 | 29.07 | 28.91 | 29.023 | 6489147.0 |
| 2006-11-07 10:30:00 | MSFT | Stock | 29.02 | 29.07 | 28.96 | 28.97 | 4167151.0 |
| 2006-11-07 11:00:00 | MSFT | Stock | 28.97 | 29.07 | 28.97 | 29.06 | 2945842.0 |
| 2006-11-07 11:30:00 | MSFT | Stock | 29.07 | 29.07 | 28.99 | 28.99 | 3364464.0 |
| 2006-11-07 12:00:00 | MSFT | Stock | 28.99 | 29.043 | 28.96 | 28.97 | 2270460.0 |
| 2006-11-07 12:30:00 | MSFT | Stock | 28.97 | 29.01 | 28.95 | 29.0 | 2018983.0 |
| 2006-11-07 13:00:00 | MSFT | Stock | 28.99 | 29.0 | 28.95 | 28.97 | 1653125.0 |
| 2006-11-07 13:30:00 | MSFT | Stock | 28.96 | 28.97 | 28.92 | 28.95 | 1110959.0 |
| 2006-11-07 14:00:00 | MSFT | Stock | 28.96 | 28.99 | 28.9 | 28.92 | 3028914.0 |
| 2006-11-07 14:30:00 | MSFT | Stock | 28.92 | 28.98 | 28.91 | 28.96 | 1942302.0 |
| 2006-11-07 15:00:00 | MSFT | Stock | 28.95 | 28.99 | 28.91 | 28.93 | 3030950.0 |
| 2006-11-07 15:30:00 | MSFT | Stock | 28.928 | 28.95 | 28.88 | 28.95 | 9320483.0 |
| 2006-11-07 16:00:00 | MSFT | Stock | 28.95 | 29.021 | 28.94 | 29.021 | 108212.0 |
| 2006-11-07 16:30:00 | MSFT | Stock | 28.95 | 28.96 | 28.95 | 28.95 | 116007.0 |
| 2006-11-07 17:00:00 | MSFT | Stock | 28.96 | 28.96 | 28.96 | 28.96 | 3700.0 |
| 2006-11-07 17:30:00 | MSFT | Stock | 28.95 | 28.96 | 28.95 | 28.96 | 211.0 |
| 2006-11-07 18:00:00 | MSFT | Stock | 28.97 | 28.97 | 28.97 | 28.97 | 3000.0 |
| 2006-11-07 18:30:00 | MSFT | Stock | 28.96 | 28.96 | 28.96 | 28.96 | 1000.0 |
| 2006-11-07 19:30:00 | MSFT | Stock | 28.99 | 28.99 | 28.99 | 28.99 | 1000.0 |
| 2006-11-07 07:00:00 | NVDA | Stock | 0.5613 | 0.5633 | 0.5613 | 0.5613 | 63000.0 |
> showing 50 of 51,228 rows — these rows as CSV