PREVIEW / stock_30min / 2006-10-31
file: by_date/stock_30min/2006/2006-10-31.parquet size: 964 KB rows: 51,945 symbols: 2,436
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-10-31 07:30:00 | AAPL | Stock | 2.8918 | 2.8932 | 2.8918 | 2.8918 | 134400.0 |
| 2006-10-31 08:00:00 | AAPL | Stock | 2.8946 | 2.8996 | 2.8911 | 2.8964 | 692048.0 |
| 2006-10-31 08:30:00 | AAPL | Stock | 2.8957 | 2.9143 | 2.8957 | 2.9104 | 2851380.0 |
| 2006-10-31 09:00:00 | AAPL | Stock | 2.9104 | 2.9179 | 2.9064 | 2.9071 | 3940020.0 |
| 2006-10-31 09:30:00 | AAPL | Stock | 2.9089 | 2.9118 | 2.8864 | 2.8982 | 91407960.0 |
| 2006-10-31 10:00:00 | AAPL | Stock | 2.8986 | 2.9004 | 2.8914 | 2.8982 | 41223056.0 |
| 2006-10-31 10:30:00 | AAPL | Stock | 2.8982 | 2.9168 | 2.8964 | 2.9139 | 38455424.0 |
| 2006-10-31 11:00:00 | AAPL | Stock | 2.9139 | 2.9171 | 2.8993 | 2.9025 | 33379164.0 |
| 2006-10-31 11:30:00 | AAPL | Stock | 2.9025 | 2.905 | 2.8943 | 2.8968 | 22272712.0 |
| 2006-10-31 12:00:00 | AAPL | Stock | 2.8971 | 2.8982 | 2.8836 | 2.8879 | 26881484.0 |
| 2006-10-31 12:30:00 | AAPL | Stock | 2.8882 | 2.8882 | 2.8654 | 2.8754 | 51771692.0 |
| 2006-10-31 13:00:00 | AAPL | Stock | 2.8754 | 2.8786 | 2.8686 | 2.8721 | 24515344.0 |
| 2006-10-31 13:30:00 | AAPL | Stock | 2.8721 | 2.8893 | 2.8721 | 2.8836 | 26724404.0 |
| 2006-10-31 14:00:00 | AAPL | Stock | 2.8836 | 2.8843 | 2.8725 | 2.8743 | 19904472.0 |
| 2006-10-31 14:30:00 | AAPL | Stock | 2.8746 | 2.8889 | 2.8746 | 2.8832 | 18982796.0 |
| 2006-10-31 15:00:00 | AAPL | Stock | 2.8832 | 2.8929 | 2.8786 | 2.8921 | 24665396.0 |
| 2006-10-31 15:30:00 | AAPL | Stock | 2.8925 | 2.8964 | 2.8864 | 2.8957 | 52053960.0 |
| 2006-10-31 16:00:00 | AAPL | Stock | 2.8943 | 2.8975 | 2.8929 | 2.8964 | 1058316.0 |
| 2006-10-31 16:30:00 | AAPL | Stock | 2.8982 | 2.8993 | 2.8964 | 2.8982 | 729904.0 |
| 2006-10-31 17:00:00 | AAPL | Stock | 2.8982 | 2.8982 | 2.8964 | 2.8968 | 203700.0 |
| 2006-10-31 17:30:00 | AAPL | Stock | 2.8968 | 2.8982 | 2.8964 | 2.8964 | 50372.0 |
| 2006-10-31 18:00:00 | AAPL | Stock | 2.8964 | 2.8982 | 2.895 | 2.895 | 33600.0 |
| 2006-10-31 18:30:00 | AAPL | Stock | 2.8957 | 2.8957 | 2.8954 | 2.8954 | 25956.0 |
| 2006-10-31 19:00:00 | AAPL | Stock | 2.8954 | 2.8954 | 2.8954 | 2.8954 | 12628.0 |
| 2006-10-31 19:30:00 | AAPL | Stock | 2.8971 | 2.8971 | 2.8954 | 2.8954 | 8400.0 |
| 2006-10-31 08:00:00 | MSFT | Stock | 28.6 | 28.6 | 28.55 | 28.6 | 2200.0 |
| 2006-10-31 08:30:00 | MSFT | Stock | 28.6 | 28.61 | 28.56 | 28.59 | 8497.0 |
| 2006-10-31 09:00:00 | MSFT | Stock | 28.59 | 28.69 | 28.57 | 28.67 | 59057.0 |
| 2006-10-31 09:30:00 | MSFT | Stock | 28.66 | 28.73 | 28.58 | 28.68 | 5684133.0 |
| 2006-10-31 10:00:00 | MSFT | Stock | 28.68 | 28.7 | 28.56 | 28.68 | 6288824.0 |
| 2006-10-31 10:30:00 | MSFT | Stock | 28.68 | 28.84 | 28.66 | 28.81 | 4484583.0 |
| 2006-10-31 11:00:00 | MSFT | Stock | 28.81 | 28.85 | 28.77 | 28.82 | 3893016.0 |
| 2006-10-31 11:30:00 | MSFT | Stock | 28.81 | 28.82 | 28.68 | 28.71 | 3175302.0 |
| 2006-10-31 12:00:00 | MSFT | Stock | 28.7 | 28.71 | 28.58 | 28.69 | 1750530.0 |
| 2006-10-31 12:30:00 | MSFT | Stock | 28.69 | 28.7 | 28.58 | 28.68 | 2549850.0 |
| 2006-10-31 13:00:00 | MSFT | Stock | 28.68 | 28.69 | 28.61 | 28.622 | 1659632.0 |
| 2006-10-31 13:30:00 | MSFT | Stock | 28.62 | 28.69 | 28.62 | 28.67 | 2164508.0 |
| 2006-10-31 14:00:00 | MSFT | Stock | 28.66 | 28.67 | 28.58 | 28.59 | 1803826.0 |
| 2006-10-31 14:30:00 | MSFT | Stock | 28.59 | 28.67 | 28.59 | 28.65 | 2411952.0 |
| 2006-10-31 15:00:00 | MSFT | Stock | 28.65 | 28.72 | 28.65 | 28.68 | 3242358.0 |
| 2006-10-31 15:30:00 | MSFT | Stock | 28.68 | 28.75 | 28.63 | 28.69 | 6874948.0 |
| 2006-10-31 16:00:00 | MSFT | Stock | 28.69 | 28.78 | 28.68 | 28.71 | 2473023.0 |
| 2006-10-31 16:30:00 | MSFT | Stock | 28.7 | 28.71 | 28.7 | 28.71 | 1100.0 |
| 2006-10-31 17:00:00 | MSFT | Stock | 28.71 | 28.71 | 28.71 | 28.71 | 814648.0 |
| 2006-10-31 17:30:00 | MSFT | Stock | 28.71 | 28.72 | 28.71 | 28.71 | 11800.0 |
| 2006-10-31 19:30:00 | MSFT | Stock | 28.71 | 28.71 | 28.71 | 28.71 | 1000.0 |
| 2006-10-31 06:00:00 | NVDA | Stock | 0.5438 | 0.5438 | 0.5438 | 0.5438 | 9300.0 |
| 2006-10-31 07:00:00 | NVDA | Stock | 0.553 | 0.5543 | 0.553 | 0.5543 | 264000.0 |
| 2006-10-31 07:30:00 | NVDA | Stock | 0.5558 | 0.5558 | 0.5558 | 0.5558 | 36000.0 |
| 2006-10-31 08:00:00 | NVDA | Stock | 0.5575 | 0.5583 | 0.5542 | 0.5567 | 702000.0 |
> showing 50 of 51,945 rows — these rows as CSV