PREVIEW / stock_30min / 2006-08-21
file: by_date/stock_30min/2006/2006-08-21.parquet size: 880 KB rows: 48,703 symbols: 2,322
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-08-21 07:30:00 | AAPL | Stock | 2.4118 | 2.4161 | 2.4118 | 2.4118 | 142800.0 |
| 2006-08-21 08:00:00 | AAPL | Stock | 2.4161 | 2.4161 | 2.4018 | 2.4054 | 722064.0 |
| 2006-08-21 08:30:00 | AAPL | Stock | 2.4054 | 2.4064 | 2.4014 | 2.4014 | 315000.0 |
| 2006-08-21 09:00:00 | AAPL | Stock | 2.4018 | 2.4068 | 2.4 | 2.4036 | 740488.0 |
| 2006-08-21 09:30:00 | AAPL | Stock | 2.4036 | 2.4039 | 2.3664 | 2.3668 | 94502296.0 |
| 2006-08-21 10:00:00 | AAPL | Stock | 2.3668 | 2.385 | 2.3625 | 2.3739 | 62452208.0 |
| 2006-08-21 10:30:00 | AAPL | Stock | 2.3736 | 2.3871 | 2.3729 | 2.3785 | 35671664.0 |
| 2006-08-21 11:00:00 | AAPL | Stock | 2.3782 | 2.3879 | 2.3704 | 2.3846 | 35228760.0 |
| 2006-08-21 11:30:00 | AAPL | Stock | 2.385 | 2.3879 | 2.3779 | 2.3814 | 27889624.0 |
| 2006-08-21 12:00:00 | AAPL | Stock | 2.3814 | 2.3821 | 2.3732 | 2.3796 | 30999752.0 |
| 2006-08-21 12:30:00 | AAPL | Stock | 2.3793 | 2.3893 | 2.3789 | 2.3875 | 30222612.0 |
| 2006-08-21 13:00:00 | AAPL | Stock | 2.3875 | 2.3971 | 2.385 | 2.3854 | 31747044.0 |
| 2006-08-21 13:30:00 | AAPL | Stock | 2.3854 | 2.3893 | 2.3786 | 2.3843 | 28288092.0 |
| 2006-08-21 14:00:00 | AAPL | Stock | 2.3843 | 2.3875 | 2.3786 | 2.3807 | 25045552.0 |
| 2006-08-21 14:30:00 | AAPL | Stock | 2.3804 | 2.3829 | 2.3718 | 2.3776 | 31949400.0 |
| 2006-08-21 15:00:00 | AAPL | Stock | 2.3778 | 2.3861 | 2.3764 | 2.3818 | 36768060.0 |
| 2006-08-21 15:30:00 | AAPL | Stock | 2.3821 | 2.3882 | 2.3764 | 2.3786 | 42419076.0 |
| 2006-08-21 16:00:00 | AAPL | Stock | 2.3786 | 2.3811 | 2.375 | 2.375 | 1370908.0 |
| 2006-08-21 16:30:00 | AAPL | Stock | 2.3771 | 2.3771 | 2.375 | 2.3768 | 2278164.0 |
| 2006-08-21 17:00:00 | AAPL | Stock | 2.3768 | 2.3768 | 2.375 | 2.375 | 49644.0 |
| 2006-08-21 17:30:00 | AAPL | Stock | 2.3768 | 2.3775 | 2.3768 | 2.3771 | 145600.0 |
| 2006-08-21 18:00:00 | AAPL | Stock | 2.3768 | 2.3771 | 2.3718 | 2.3732 | 168896.0 |
| 2006-08-21 07:00:00 | MSFT | Stock | 25.72 | 25.72 | 25.72 | 25.72 | 500.0 |
| 2006-08-21 07:30:00 | MSFT | Stock | 25.8 | 25.8 | 25.7 | 25.72 | 4050.0 |
| 2006-08-21 08:00:00 | MSFT | Stock | 25.7 | 25.75 | 25.65 | 25.67 | 36246.0 |
| 2006-08-21 08:30:00 | MSFT | Stock | 25.66 | 25.75 | 25.66 | 25.75 | 46961.0 |
| 2006-08-21 09:00:00 | MSFT | Stock | 25.72 | 25.75 | 25.63 | 25.65 | 152178.0 |
| 2006-08-21 09:30:00 | MSFT | Stock | 25.66 | 25.69 | 25.56 | 25.64 | 8846937.0 |
| 2006-08-21 10:00:00 | MSFT | Stock | 25.64 | 25.69 | 25.6 | 25.66 | 8495341.0 |
| 2006-08-21 10:30:00 | MSFT | Stock | 25.65 | 25.77 | 25.6 | 25.75 | 5438617.0 |
| 2006-08-21 11:00:00 | MSFT | Stock | 25.74 | 25.95 | 25.74 | 25.94 | 7185954.0 |
| 2006-08-21 11:30:00 | MSFT | Stock | 25.94 | 26.05 | 25.86 | 25.96 | 12147770.0 |
| 2006-08-21 12:00:00 | MSFT | Stock | 25.95 | 25.98 | 25.91 | 25.92 | 5271013.0 |
| 2006-08-21 12:30:00 | MSFT | Stock | 25.92 | 25.94 | 25.91 | 25.94 | 1959771.0 |
| 2006-08-21 13:00:00 | MSFT | Stock | 25.94 | 26.03 | 25.93 | 25.95 | 4683376.0 |
| 2006-08-21 13:30:00 | MSFT | Stock | 25.95 | 26.0 | 25.95 | 25.96 | 3148102.0 |
| 2006-08-21 14:00:00 | MSFT | Stock | 25.96 | 26.05 | 25.96 | 26.02 | 4891470.0 |
| 2006-08-21 14:30:00 | MSFT | Stock | 26.02 | 26.12 | 26.01 | 26.06 | 7248442.0 |
| 2006-08-21 15:00:00 | MSFT | Stock | 26.06 | 26.07 | 25.64 | 26.07 | 4204910.0 |
| 2006-08-21 15:30:00 | MSFT | Stock | 26.07 | 26.13 | 26.06 | 26.12 | 10192766.0 |
| 2006-08-21 16:00:00 | MSFT | Stock | 26.12 | 26.15 | 25.924 | 26.1 | 362550.0 |
| 2006-08-21 16:30:00 | MSFT | Stock | 26.1 | 26.12 | 26.088 | 26.11 | 645874.0 |
| 2006-08-21 17:00:00 | MSFT | Stock | 26.1 | 26.12 | 26.1 | 26.12 | 13378.0 |
| 2006-08-21 17:30:00 | MSFT | Stock | 26.12 | 26.12 | 26.1 | 26.1 | 2095.0 |
| 2006-08-21 18:00:00 | MSFT | Stock | 26.1 | 26.1 | 26.1 | 26.1 | 600.0 |
| 2006-08-21 08:00:00 | NVDA | Stock | 0.45 | 0.45 | 0.4483 | 0.4492 | 318000.0 |
| 2006-08-21 08:30:00 | NVDA | Stock | 0.45 | 0.4508 | 0.45 | 0.45 | 223200.0 |
| 2006-08-21 09:00:00 | NVDA | Stock | 0.4492 | 0.4502 | 0.4478 | 0.4478 | 603000.0 |
| 2006-08-21 09:30:00 | NVDA | Stock | 0.4492 | 0.45 | 0.4417 | 0.4442 | 76569360.0 |
| 2006-08-21 10:00:00 | NVDA | Stock | 0.4442 | 0.449 | 0.442 | 0.4425 | 55104480.0 |
> showing 50 of 48,703 rows — these rows as CSV