PREVIEW / stock_30min / 2005-06-23
file: by_date/stock_30min/2005/2005-06-23.parquet size: 839 KB rows: 45,083 symbols: 1,988
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-23 07:00:00 | AAPL | Stock | 1.3786 | 1.3857 | 1.3786 | 1.3857 | 56000.0 |
| 2005-06-23 07:30:00 | AAPL | Stock | 1.3857 | 1.3857 | 1.3857 | 1.3857 | 11200.0 |
| 2005-06-23 08:00:00 | AAPL | Stock | 1.3839 | 1.3921 | 1.3821 | 1.3871 | 1062152.0 |
| 2005-06-23 08:30:00 | AAPL | Stock | 1.3896 | 1.3946 | 1.3889 | 1.3893 | 687260.0 |
| 2005-06-23 09:00:00 | AAPL | Stock | 1.3893 | 1.3911 | 1.3829 | 1.3882 | 836836.0 |
| 2005-06-23 09:30:00 | AAPL | Stock | 1.3868 | 1.4025 | 1.385 | 1.3996 | 95352628.0 |
| 2005-06-23 10:00:00 | AAPL | Stock | 1.3993 | 1.4011 | 1.3871 | 1.3879 | 55497596.0 |
| 2005-06-23 10:30:00 | AAPL | Stock | 1.3875 | 1.395 | 1.3871 | 1.3939 | 29909208.0 |
| 2005-06-23 11:00:00 | AAPL | Stock | 1.3936 | 1.4061 | 1.3929 | 1.405 | 47466160.0 |
| 2005-06-23 11:30:00 | AAPL | Stock | 1.4043 | 1.4207 | 1.4039 | 1.4132 | 59275020.0 |
| 2005-06-23 12:00:00 | AAPL | Stock | 1.4132 | 1.4196 | 1.4107 | 1.4139 | 56691544.0 |
| 2005-06-23 12:30:00 | AAPL | Stock | 1.4136 | 1.4157 | 1.4089 | 1.4118 | 37242632.0 |
| 2005-06-23 13:00:00 | AAPL | Stock | 1.4121 | 1.4121 | 1.4046 | 1.4071 | 28618996.0 |
| 2005-06-23 13:30:00 | AAPL | Stock | 1.4075 | 1.4079 | 1.39 | 1.3939 | 64532356.0 |
| 2005-06-23 14:00:00 | AAPL | Stock | 1.3939 | 1.3961 | 1.3896 | 1.3936 | 44684808.0 |
| 2005-06-23 14:30:00 | AAPL | Stock | 1.3936 | 1.3989 | 1.3893 | 1.3918 | 35688128.0 |
| 2005-06-23 15:00:00 | AAPL | Stock | 1.3918 | 1.3943 | 1.3864 | 1.3904 | 35454104.0 |
| 2005-06-23 15:30:00 | AAPL | Stock | 1.3896 | 1.3907 | 1.3804 | 1.3879 | 72802576.0 |
| 2005-06-23 16:00:00 | AAPL | Stock | 1.3886 | 1.3893 | 1.35 | 1.3879 | 3162964.0 |
| 2005-06-23 16:30:00 | AAPL | Stock | 1.3879 | 1.3879 | 1.3857 | 1.3857 | 14000.0 |
| 2005-06-23 17:00:00 | AAPL | Stock | 1.3875 | 1.3918 | 1.3857 | 1.39 | 381276.0 |
| 2005-06-23 17:30:00 | AAPL | Stock | 1.39 | 1.39 | 1.3896 | 1.3896 | 39200.0 |
| 2005-06-23 18:00:00 | AAPL | Stock | 1.3918 | 1.3921 | 1.3918 | 1.3918 | 45220.0 |
| 2005-06-23 06:30:00 | MSFT | Stock | 25.29 | 25.29 | 25.29 | 25.29 | 200.0 |
| 2005-06-23 07:00:00 | MSFT | Stock | 25.23 | 25.23 | 25.22 | 25.22 | 2000.0 |
| 2005-06-23 07:30:00 | MSFT | Stock | 25.2 | 25.2 | 25.17 | 25.18 | 12516.0 |
| 2005-06-23 08:00:00 | MSFT | Stock | 25.18 | 25.22 | 25.17 | 25.2 | 99873.0 |
| 2005-06-23 08:30:00 | MSFT | Stock | 25.2 | 25.23 | 25.18 | 25.2 | 220072.0 |
| 2005-06-23 09:00:00 | MSFT | Stock | 25.2 | 25.22 | 25.15 | 25.17 | 398628.0 |
| 2005-06-23 09:30:00 | MSFT | Stock | 25.17 | 25.4 | 25.15 | 25.34 | 13382267.0 |
| 2005-06-23 10:00:00 | MSFT | Stock | 25.33 | 25.39 | 25.29 | 25.38 | 7786254.0 |
| 2005-06-23 10:30:00 | MSFT | Stock | 25.389 | 25.39 | 25.33 | 25.341 | 8056196.0 |
| 2005-06-23 11:00:00 | MSFT | Stock | 25.35 | 25.48 | 25.34 | 25.458 | 8187404.0 |
| 2005-06-23 11:30:00 | MSFT | Stock | 25.45 | 25.57 | 25.45 | 25.56 | 10077060.0 |
| 2005-06-23 12:00:00 | MSFT | Stock | 25.56 | 25.56 | 25.47 | 25.48 | 4523576.0 |
| 2005-06-23 12:30:00 | MSFT | Stock | 25.48 | 25.53 | 25.47 | 25.52 | 3507858.0 |
| 2005-06-23 13:00:00 | MSFT | Stock | 25.528 | 25.62 | 25.52 | 25.54 | 7471367.0 |
| 2005-06-23 13:30:00 | MSFT | Stock | 25.55 | 25.55 | 25.32 | 25.36 | 10987288.0 |
| 2005-06-23 14:00:00 | MSFT | Stock | 25.36 | 25.42 | 25.32 | 25.35 | 4716659.0 |
| 2005-06-23 14:30:00 | MSFT | Stock | 25.35 | 25.38 | 25.33 | 25.38 | 3740740.0 |
| 2005-06-23 15:00:00 | MSFT | Stock | 25.38 | 25.46 | 25.32 | 25.35 | 9954635.0 |
| 2005-06-23 15:30:00 | MSFT | Stock | 25.34 | 25.42 | 25.31 | 25.31 | 8696469.0 |
| 2005-06-23 16:00:00 | MSFT | Stock | 25.31 | 25.363 | 25.29 | 25.32 | 770583.0 |
| 2005-06-23 16:30:00 | MSFT | Stock | 25.32 | 25.34 | 25.225 | 25.3 | 26239.0 |
| 2005-06-23 17:00:00 | MSFT | Stock | 25.32 | 25.32 | 25.3 | 25.3 | 30999.0 |
| 2005-06-23 17:30:00 | MSFT | Stock | 25.32 | 25.32 | 25.31 | 25.32 | 62085.0 |
| 2005-06-23 18:00:00 | MSFT | Stock | 25.32 | 25.33 | 25.29 | 25.32 | 39602.0 |
| 2005-06-23 08:00:00 | NVDA | Stock | 0.2307 | 0.2307 | 0.2284 | 0.2287 | 1152000.0 |
| 2005-06-23 08:30:00 | NVDA | Stock | 0.2287 | 0.2288 | 0.2281 | 0.2283 | 4368600.0 |
| 2005-06-23 09:00:00 | NVDA | Stock | 0.2279 | 0.231 | 0.2279 | 0.2292 | 3216000.0 |
> showing 50 of 45,083 rows — these rows as CSV