PREVIEW / stock_30min / 2009-03-17
file: by_date/stock_30min/2009/2009-03-17.parquet size: 1.2 MB rows: 67,580 symbols: 3,300
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-17 08:00:00 | AAPL | Stock | 3.3939 | 3.4196 | 3.3846 | 3.3861 | 352044.0 |
| 2009-03-17 08:30:00 | AAPL | Stock | 3.3918 | 3.4161 | 3.3918 | 3.3979 | 346192.0 |
| 2009-03-17 09:00:00 | AAPL | Stock | 3.3964 | 3.4061 | 3.3936 | 3.4 | 536396.0 |
| 2009-03-17 09:30:00 | AAPL | Stock | 3.4029 | 3.4925 | 3.3954 | 3.4766 | 102979408.0 |
| 2009-03-17 10:00:00 | AAPL | Stock | 3.4771 | 3.4986 | 3.4771 | 3.4854 | 63296716.0 |
| 2009-03-17 10:30:00 | AAPL | Stock | 3.4861 | 3.5075 | 3.4818 | 3.4921 | 47781496.0 |
| 2009-03-17 11:00:00 | AAPL | Stock | 3.4925 | 3.5136 | 3.4871 | 3.4979 | 34576612.0 |
| 2009-03-17 11:30:00 | AAPL | Stock | 3.4979 | 3.5161 | 3.4955 | 3.5075 | 30779308.0 |
| 2009-03-17 12:00:00 | AAPL | Stock | 3.5075 | 3.5175 | 3.5007 | 3.5039 | 32119416.0 |
| 2009-03-17 12:30:00 | AAPL | Stock | 3.5046 | 3.5079 | 3.4786 | 3.4818 | 40748148.0 |
| 2009-03-17 13:00:00 | AAPL | Stock | 3.4821 | 3.5032 | 3.4736 | 3.4814 | 42659680.0 |
| 2009-03-17 13:30:00 | AAPL | Stock | 3.4821 | 3.5089 | 3.47 | 3.4757 | 43825124.0 |
| 2009-03-17 14:00:00 | AAPL | Stock | 3.4754 | 3.4875 | 3.4514 | 3.4579 | 54862360.0 |
| 2009-03-17 14:30:00 | AAPL | Stock | 3.4571 | 3.4854 | 3.4464 | 3.4711 | 56256088.0 |
| 2009-03-17 15:00:00 | AAPL | Stock | 3.4704 | 3.5357 | 3.4686 | 3.5252 | 88722872.0 |
| 2009-03-17 15:30:00 | AAPL | Stock | 3.5249 | 3.5604 | 3.5161 | 3.5589 | 117996396.0 |
| 2009-03-17 16:00:00 | AAPL | Stock | 3.5593 | 3.5625 | 3.4464 | 3.5568 | 16777096.0 |
| 2009-03-17 16:30:00 | AAPL | Stock | 3.5568 | 3.56 | 3.5568 | 3.5571 | 2319632.0 |
| 2009-03-17 17:00:00 | AAPL | Stock | 3.5571 | 3.5607 | 3.5571 | 3.5607 | 171472.0 |
| 2009-03-17 17:30:00 | AAPL | Stock | 3.5607 | 3.5607 | 3.5571 | 3.5571 | 107800.0 |
| 2009-03-17 18:00:00 | AAPL | Stock | 3.5571 | 3.5593 | 3.5543 | 3.5586 | 759108.0 |
| 2009-03-17 18:30:00 | AAPL | Stock | 3.5579 | 3.56 | 3.5561 | 3.5586 | 126196.0 |
| 2009-03-17 19:00:00 | AAPL | Stock | 3.5593 | 3.5607 | 3.5593 | 3.5607 | 124656.0 |
| 2009-03-17 19:30:00 | AAPL | Stock | 3.5607 | 3.5629 | 3.5575 | 3.5582 | 365064.0 |
| 2009-03-17 07:00:00 | MSFT | Stock | 16.31 | 16.31 | 16.31 | 16.31 | 2000.0 |
| 2009-03-17 07:30:00 | MSFT | Stock | 16.5 | 16.5 | 16.43 | 16.43 | 3600.0 |
| 2009-03-17 08:00:00 | MSFT | Stock | 16.31 | 16.43 | 16.31 | 16.32 | 5610.0 |
| 2009-03-17 08:30:00 | MSFT | Stock | 16.35 | 16.44 | 16.35 | 16.39 | 11100.0 |
| 2009-03-17 09:00:00 | MSFT | Stock | 16.35 | 16.39 | 16.31 | 16.33 | 28222.0 |
| 2009-03-17 09:30:00 | MSFT | Stock | 16.33 | 16.54 | 16.3 | 16.51 | 5841627.0 |
| 2009-03-17 10:00:00 | MSFT | Stock | 16.52 | 16.56 | 16.26 | 16.29 | 4804732.0 |
| 2009-03-17 10:30:00 | MSFT | Stock | 16.29 | 16.51 | 16.26 | 16.472 | 3826265.0 |
| 2009-03-17 11:00:00 | MSFT | Stock | 16.46 | 16.59 | 16.46 | 16.56 | 3252938.0 |
| 2009-03-17 11:30:00 | MSFT | Stock | 16.56 | 16.59 | 16.48 | 16.53 | 3064347.0 |
| 2009-03-17 12:00:00 | MSFT | Stock | 16.53 | 16.59 | 16.44 | 16.58 | 3701243.0 |
| 2009-03-17 12:30:00 | MSFT | Stock | 16.582 | 16.7 | 16.55 | 16.68 | 2602676.0 |
| 2009-03-17 13:00:00 | MSFT | Stock | 16.68 | 16.75 | 16.65 | 16.65 | 3596118.0 |
| 2009-03-17 13:30:00 | MSFT | Stock | 16.65 | 16.73 | 16.59 | 16.602 | 4123140.0 |
| 2009-03-17 14:00:00 | MSFT | Stock | 16.61 | 16.63 | 16.48 | 16.5 | 3802857.0 |
| 2009-03-17 14:30:00 | MSFT | Stock | 16.5 | 16.68 | 16.48 | 16.64 | 3271540.0 |
| 2009-03-17 15:00:00 | MSFT | Stock | 16.63 | 16.79 | 16.62 | 16.67 | 6165571.0 |
| 2009-03-17 15:30:00 | MSFT | Stock | 16.67 | 16.89 | 16.63 | 16.89 | 9780361.0 |
| 2009-03-17 16:00:00 | MSFT | Stock | 16.89 | 16.97 | 16.585 | 16.9 | 2937629.0 |
| 2009-03-17 16:30:00 | MSFT | Stock | 16.9 | 16.92 | 16.89 | 16.9 | 143634.0 |
| 2009-03-17 17:00:00 | MSFT | Stock | 16.91 | 16.92 | 16.9 | 16.9 | 5620.0 |
| 2009-03-17 17:30:00 | MSFT | Stock | 16.9 | 16.92 | 16.9 | 16.9 | 11299.0 |
| 2009-03-17 18:00:00 | MSFT | Stock | 16.92 | 16.92 | 16.9 | 16.9 | 177813.0 |
| 2009-03-17 18:30:00 | MSFT | Stock | 16.9 | 16.92 | 16.9 | 16.9 | 2851.0 |
| 2009-03-17 19:00:00 | MSFT | Stock | 16.91 | 16.91 | 16.9 | 16.9 | 4902.0 |
| 2009-03-17 19:30:00 | MSFT | Stock | 16.9 | 16.92 | 16.9 | 16.9 | 2798.0 |
> showing 50 of 67,580 rows — these rows as CSV