PREVIEW / stock_30min / 2010-12-20
file: by_date/stock_30min/2010/2010-12-20.parquet size: 1.5 MB rows: 79,997 symbols: 3,556
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-20 04:00:00 | AAPL | Stock | 11.4686 | 11.4771 | 11.4686 | 11.4771 | 5600.0 |
| 2010-12-20 04:30:00 | AAPL | Stock | 11.47 | 11.5 | 11.4643 | 11.4643 | 22400.0 |
| 2010-12-20 06:00:00 | AAPL | Stock | 11.4746 | 11.475 | 11.4746 | 11.475 | 16800.0 |
| 2010-12-20 06:30:00 | AAPL | Stock | 11.475 | 11.475 | 11.4654 | 11.4654 | 19600.0 |
| 2010-12-20 07:00:00 | AAPL | Stock | 11.4768 | 11.4904 | 11.4657 | 11.4904 | 192080.0 |
| 2010-12-20 07:30:00 | AAPL | Stock | 11.4861 | 11.4886 | 11.475 | 11.4757 | 71400.0 |
| 2010-12-20 08:00:00 | AAPL | Stock | 11.4786 | 11.4857 | 11.4729 | 11.4786 | 715540.0 |
| 2010-12-20 08:30:00 | AAPL | Stock | 11.4779 | 11.48 | 11.4661 | 11.4714 | 544460.0 |
| 2010-12-20 09:00:00 | AAPL | Stock | 11.4714 | 11.4839 | 11.4682 | 11.4839 | 787920.0 |
| 2010-12-20 09:30:00 | AAPL | Stock | 11.4857 | 11.4857 | 11.4329 | 11.4475 | 42116536.0 |
| 2010-12-20 10:00:00 | AAPL | Stock | 11.4475 | 11.4479 | 11.3654 | 11.3998 | 49150220.0 |
| 2010-12-20 10:30:00 | AAPL | Stock | 11.4007 | 11.4857 | 11.3757 | 11.3757 | 19319104.0 |
| 2010-12-20 11:00:00 | AAPL | Stock | 11.375 | 11.4282 | 11.3696 | 11.4271 | 20737388.0 |
| 2010-12-20 11:30:00 | AAPL | Stock | 11.4268 | 11.4521 | 11.4214 | 11.4489 | 18593932.0 |
| 2010-12-20 12:00:00 | AAPL | Stock | 11.4489 | 11.4493 | 11.4196 | 11.4293 | 14846804.0 |
| 2010-12-20 12:30:00 | AAPL | Stock | 11.4314 | 11.4725 | 11.43 | 11.4721 | 17034136.0 |
| 2010-12-20 13:00:00 | AAPL | Stock | 11.4712 | 11.5054 | 11.4712 | 11.4904 | 32715676.0 |
| 2010-12-20 13:30:00 | AAPL | Stock | 11.4904 | 11.5054 | 11.4871 | 11.4921 | 16083844.0 |
| 2010-12-20 14:00:00 | AAPL | Stock | 11.4921 | 11.5446 | 11.4893 | 11.5254 | 31982552.0 |
| 2010-12-20 14:30:00 | AAPL | Stock | 11.5244 | 11.5357 | 11.52 | 11.5214 | 18154388.0 |
| 2010-12-20 15:00:00 | AAPL | Stock | 11.5218 | 11.5236 | 11.4911 | 11.5072 | 21752556.0 |
| 2010-12-20 15:30:00 | AAPL | Stock | 11.5079 | 11.5364 | 11.5004 | 11.5071 | 40657316.0 |
| 2010-12-20 16:00:00 | AAPL | Stock | 11.5071 | 11.5161 | 11.4654 | 11.5079 | 32687228.0 |
| 2010-12-20 16:30:00 | AAPL | Stock | 11.5068 | 11.5086 | 11.4312 | 11.4946 | 806400.0 |
| 2010-12-20 17:00:00 | AAPL | Stock | 11.4954 | 11.5032 | 11.4954 | 11.5021 | 216020.0 |
| 2010-12-20 17:30:00 | AAPL | Stock | 11.5032 | 11.5057 | 11.5021 | 11.5057 | 57484.0 |
| 2010-12-20 18:00:00 | AAPL | Stock | 11.5043 | 11.5089 | 11.4968 | 11.4975 | 525616.0 |
| 2010-12-20 18:30:00 | AAPL | Stock | 11.4993 | 11.4993 | 11.4875 | 11.4882 | 389060.0 |
| 2010-12-20 19:00:00 | AAPL | Stock | 11.4882 | 11.4918 | 11.4796 | 11.48 | 442288.0 |
| 2010-12-20 19:30:00 | AAPL | Stock | 11.4811 | 11.4932 | 11.4811 | 11.4929 | 161728.0 |
| 2010-12-20 07:30:00 | MSFT | Stock | 27.95 | 27.95 | 27.95 | 27.95 | 2000.0 |
| 2010-12-20 08:00:00 | MSFT | Stock | 27.91 | 28.0 | 27.91 | 27.99 | 12050.0 |
| 2010-12-20 08:30:00 | MSFT | Stock | 27.93 | 28.0 | 27.93 | 27.99 | 27000.0 |
| 2010-12-20 09:00:00 | MSFT | Stock | 27.96 | 27.99 | 27.86 | 27.95 | 154002.0 |
| 2010-12-20 09:30:00 | MSFT | Stock | 27.95 | 27.96 | 27.83 | 27.904 | 4608672.0 |
| 2010-12-20 10:00:00 | MSFT | Stock | 27.9 | 27.91 | 27.76 | 27.845 | 3560974.0 |
| 2010-12-20 10:30:00 | MSFT | Stock | 27.84 | 27.86 | 27.77 | 27.79 | 1924979.0 |
| 2010-12-20 11:00:00 | MSFT | Stock | 27.78 | 27.8 | 27.68 | 27.79 | 2599713.0 |
| 2010-12-20 11:30:00 | MSFT | Stock | 27.8 | 27.86 | 27.78 | 27.85 | 2128800.0 |
| 2010-12-20 12:00:00 | MSFT | Stock | 27.85 | 27.88 | 27.78 | 27.842 | 2224816.0 |
| 2010-12-20 12:30:00 | MSFT | Stock | 27.84 | 27.88 | 27.81 | 27.855 | 1990217.0 |
| 2010-12-20 13:00:00 | MSFT | Stock | 27.86 | 27.89 | 27.84 | 27.872 | 1856081.0 |
| 2010-12-20 13:30:00 | MSFT | Stock | 27.88 | 27.895 | 27.85 | 27.885 | 1442264.0 |
| 2010-12-20 14:00:00 | MSFT | Stock | 27.885 | 27.99 | 27.88 | 27.95 | 3583926.0 |
| 2010-12-20 14:30:00 | MSFT | Stock | 27.95 | 27.955 | 27.9 | 27.92 | 2354393.0 |
| 2010-12-20 15:00:00 | MSFT | Stock | 27.92 | 27.93 | 27.84 | 27.864 | 2912097.0 |
| 2010-12-20 15:30:00 | MSFT | Stock | 27.86 | 27.91 | 27.81 | 27.81 | 6504768.0 |
| 2010-12-20 16:00:00 | MSFT | Stock | 27.81 | 27.92 | 27.79 | 27.86 | 13649544.0 |
| 2010-12-20 16:30:00 | MSFT | Stock | 27.87 | 27.902 | 27.85 | 27.871 | 19750.0 |
| 2010-12-20 17:00:00 | MSFT | Stock | 27.79 | 27.88 | 27.79 | 27.88 | 900.0 |
> showing 50 of 79,997 rows — these rows as CSV