PREVIEW / stock_30min / 2006-10-05
file: by_date/stock_30min/2006/2006-10-05.parquet size: 934 KB rows: 50,642 symbols: 2,381
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-05 06:30:00 | AAPL | Stock | 2.6864 | 2.6964 | 2.6804 | 2.6804 | 103600.0 |
| 2006-10-05 07:00:00 | AAPL | Stock | 2.6611 | 2.6725 | 2.6607 | 2.6696 | 68880.0 |
| 2006-10-05 07:30:00 | AAPL | Stock | 2.675 | 2.675 | 2.6554 | 2.6671 | 389200.0 |
| 2006-10-05 08:00:00 | AAPL | Stock | 2.6611 | 2.6696 | 2.6554 | 2.6607 | 2624160.0 |
| 2006-10-05 08:30:00 | AAPL | Stock | 2.6625 | 2.6696 | 2.6554 | 2.6607 | 2434516.0 |
| 2006-10-05 09:00:00 | AAPL | Stock | 2.6607 | 2.6639 | 2.6582 | 2.6607 | 2088240.0 |
| 2006-10-05 09:30:00 | AAPL | Stock | 2.6618 | 2.6854 | 2.6475 | 2.6818 | 120849708.0 |
| 2006-10-05 10:00:00 | AAPL | Stock | 2.6818 | 2.6868 | 2.6654 | 2.6768 | 70876792.0 |
| 2006-10-05 10:30:00 | AAPL | Stock | 2.6768 | 2.72 | 2.6729 | 2.7129 | 108642156.0 |
| 2006-10-05 11:00:00 | AAPL | Stock | 2.7129 | 2.7196 | 2.695 | 2.7021 | 67076100.0 |
| 2006-10-05 11:30:00 | AAPL | Stock | 2.7014 | 2.7107 | 2.6857 | 2.6946 | 45678388.0 |
| 2006-10-05 12:00:00 | AAPL | Stock | 2.6943 | 2.6968 | 2.6764 | 2.6796 | 34186824.0 |
| 2006-10-05 12:30:00 | AAPL | Stock | 2.6793 | 2.6817 | 2.6696 | 2.6732 | 32318412.0 |
| 2006-10-05 13:00:00 | AAPL | Stock | 2.6732 | 2.6821 | 2.6696 | 2.68 | 27774824.0 |
| 2006-10-05 13:30:00 | AAPL | Stock | 2.6804 | 2.6854 | 2.6732 | 2.6743 | 21293384.0 |
| 2006-10-05 14:00:00 | AAPL | Stock | 2.6743 | 2.6768 | 2.6693 | 2.6736 | 21213276.0 |
| 2006-10-05 14:30:00 | AAPL | Stock | 2.6736 | 2.7089 | 2.6732 | 2.6764 | 19407920.0 |
| 2006-10-05 15:00:00 | AAPL | Stock | 2.6764 | 2.6829 | 2.6693 | 2.6768 | 29223040.0 |
| 2006-10-05 15:30:00 | AAPL | Stock | 2.6768 | 2.6782 | 2.6657 | 2.6696 | 47826072.0 |
| 2006-10-05 16:00:00 | AAPL | Stock | 2.6682 | 2.6696 | 2.6679 | 2.6679 | 973700.0 |
| 2006-10-05 16:30:00 | AAPL | Stock | 2.6682 | 2.6725 | 2.6679 | 2.67 | 10008600.0 |
| 2006-10-05 17:00:00 | AAPL | Stock | 2.6696 | 2.6707 | 2.6693 | 2.6707 | 185556.0 |
| 2006-10-05 17:30:00 | AAPL | Stock | 2.6707 | 2.6725 | 2.6689 | 2.6689 | 9825200.0 |
| 2006-10-05 18:00:00 | AAPL | Stock | 2.6689 | 2.6732 | 2.6689 | 2.6711 | 43652.0 |
| 2006-10-05 18:30:00 | AAPL | Stock | 2.6714 | 2.6732 | 2.6714 | 2.6732 | 9520.0 |
| 2006-10-05 19:00:00 | AAPL | Stock | 2.6714 | 2.6714 | 2.6714 | 2.6714 | 5600.0 |
| 2006-10-05 19:30:00 | AAPL | Stock | 2.6714 | 2.6714 | 2.6682 | 2.6682 | 29400.0 |
| 2006-10-05 06:00:00 | MSFT | Stock | 27.9 | 27.9 | 27.9 | 27.9 | 400.0 |
| 2006-10-05 08:00:00 | MSFT | Stock | 27.9 | 27.9 | 27.83 | 27.84 | 10120.0 |
| 2006-10-05 08:30:00 | MSFT | Stock | 27.83 | 27.87 | 27.83 | 27.86 | 7750.0 |
| 2006-10-05 09:00:00 | MSFT | Stock | 27.85 | 27.93 | 27.83 | 27.92 | 151050.0 |
| 2006-10-05 09:30:00 | MSFT | Stock | 27.92 | 28.11 | 27.9 | 28.07 | 15417978.0 |
| 2006-10-05 10:00:00 | MSFT | Stock | 28.08 | 28.1 | 27.94 | 27.95 | 6804937.0 |
| 2006-10-05 10:30:00 | MSFT | Stock | 27.96 | 27.96 | 27.8 | 27.93 | 7624210.0 |
| 2006-10-05 11:00:00 | MSFT | Stock | 27.93 | 27.94 | 27.83 | 27.87 | 3848432.0 |
| 2006-10-05 11:30:00 | MSFT | Stock | 27.869 | 28.0 | 27.86 | 27.95 | 10808467.0 |
| 2006-10-05 12:00:00 | MSFT | Stock | 27.95 | 27.99 | 27.93 | 27.93 | 4393195.0 |
| 2006-10-05 12:30:00 | MSFT | Stock | 27.93 | 27.95 | 27.87 | 27.9 | 5341780.0 |
| 2006-10-05 13:00:00 | MSFT | Stock | 27.902 | 28.08 | 27.87 | 27.92 | 3053925.0 |
| 2006-10-05 13:30:00 | MSFT | Stock | 27.91 | 27.92 | 27.82 | 27.84 | 2874614.0 |
| 2006-10-05 14:00:00 | MSFT | Stock | 27.84 | 27.86 | 27.79 | 27.81 | 2669489.0 |
| 2006-10-05 14:30:00 | MSFT | Stock | 27.8 | 27.91 | 27.78 | 27.9 | 3623954.0 |
| 2006-10-05 15:00:00 | MSFT | Stock | 27.9 | 27.92 | 27.88 | 27.89 | 4112833.0 |
| 2006-10-05 15:30:00 | MSFT | Stock | 27.89 | 27.95 | 27.86 | 27.94 | 5965912.0 |
| 2006-10-05 16:00:00 | MSFT | Stock | 27.93 | 27.94 | 27.807 | 27.87 | 1039898.0 |
| 2006-10-05 16:30:00 | MSFT | Stock | 27.92 | 27.93 | 27.88 | 27.88 | 1536.0 |
| 2006-10-05 17:00:00 | MSFT | Stock | 27.9 | 27.9 | 27.9 | 27.9 | 497.0 |
| 2006-10-05 17:30:00 | MSFT | Stock | 27.94 | 27.94 | 27.93 | 27.93 | 600854.0 |
| 2006-10-05 18:00:00 | MSFT | Stock | 27.92 | 27.94 | 27.92 | 27.94 | 11338.0 |
| 2006-10-05 18:30:00 | MSFT | Stock | 27.94 | 27.94 | 27.92 | 27.92 | 575.0 |
> showing 50 of 50,642 rows — these rows as CSV