PREVIEW / stock_30min / 2009-06-29
file: by_date/stock_30min/2009/2009-06-29.parquet size: 1.3 MB rows: 71,321 symbols: 3,330
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-06-29 05:30:00 | AAPL | Stock | 5.0679 | 5.0679 | 5.0679 | 5.0679 | 2800.0 |
| 2009-06-29 06:00:00 | AAPL | Stock | 5.0575 | 5.0661 | 5.0575 | 5.0661 | 16800.0 |
| 2009-06-29 07:00:00 | AAPL | Stock | 5.1061 | 5.1061 | 5.0886 | 5.0893 | 58324.0 |
| 2009-06-29 07:30:00 | AAPL | Stock | 5.1071 | 5.1168 | 5.1071 | 5.1168 | 134960.0 |
| 2009-06-29 08:00:00 | AAPL | Stock | 5.1211 | 5.1404 | 5.1125 | 5.1318 | 1054060.0 |
| 2009-06-29 08:30:00 | AAPL | Stock | 5.1336 | 5.1339 | 5.1143 | 5.1221 | 598276.0 |
| 2009-06-29 09:00:00 | AAPL | Stock | 5.1225 | 5.1271 | 5.1107 | 5.1232 | 2124108.0 |
| 2009-06-29 09:30:00 | AAPL | Stock | 5.1236 | 5.1411 | 5.0871 | 5.1 | 80734584.0 |
| 2009-06-29 10:00:00 | AAPL | Stock | 5.1 | 5.1068 | 5.0668 | 5.0828 | 45332112.0 |
| 2009-06-29 10:30:00 | AAPL | Stock | 5.0821 | 5.0957 | 5.0696 | 5.0779 | 34422640.0 |
| 2009-06-29 11:00:00 | AAPL | Stock | 5.0779 | 5.1118 | 5.0729 | 5.1096 | 33249160.0 |
| 2009-06-29 11:30:00 | AAPL | Stock | 5.1096 | 5.1157 | 5.0989 | 5.1143 | 26085052.0 |
| 2009-06-29 12:00:00 | AAPL | Stock | 5.1143 | 5.1161 | 5.1 | 5.1059 | 18677204.0 |
| 2009-06-29 12:30:00 | AAPL | Stock | 5.1054 | 5.1404 | 5.0971 | 5.1004 | 77396928.0 |
| 2009-06-29 13:00:00 | AAPL | Stock | 5.0996 | 5.1096 | 5.0911 | 5.0911 | 23615004.0 |
| 2009-06-29 13:30:00 | AAPL | Stock | 5.0911 | 5.0979 | 5.0714 | 5.0796 | 28870912.0 |
| 2009-06-29 14:00:00 | AAPL | Stock | 5.0796 | 5.0821 | 5.0679 | 5.0756 | 22489628.0 |
| 2009-06-29 14:30:00 | AAPL | Stock | 5.0757 | 5.0904 | 5.0632 | 5.0861 | 32624284.0 |
| 2009-06-29 15:00:00 | AAPL | Stock | 5.0861 | 5.0964 | 5.0832 | 5.0839 | 25137392.0 |
| 2009-06-29 15:30:00 | AAPL | Stock | 5.0836 | 5.0868 | 5.055 | 5.07 | 62550096.0 |
| 2009-06-29 16:00:00 | AAPL | Stock | 5.07 | 5.0949 | 5.0614 | 5.0704 | 47132092.0 |
| 2009-06-29 16:30:00 | AAPL | Stock | 5.0704 | 5.0937 | 5.0636 | 5.0668 | 326564.0 |
| 2009-06-29 17:00:00 | AAPL | Stock | 5.0675 | 5.0675 | 5.0654 | 5.0654 | 6440.0 |
| 2009-06-29 17:30:00 | AAPL | Stock | 5.0928 | 5.0928 | 5.0625 | 5.0696 | 408464.0 |
| 2009-06-29 18:00:00 | AAPL | Stock | 5.0704 | 5.0704 | 5.0657 | 5.0696 | 79856.0 |
| 2009-06-29 19:00:00 | AAPL | Stock | 5.065 | 5.0693 | 5.0643 | 5.0693 | 28560.0 |
| 2009-06-29 19:30:00 | AAPL | Stock | 5.0661 | 5.0679 | 5.0636 | 5.0679 | 19180.0 |
| 2009-06-29 07:00:00 | MSFT | Stock | 23.55 | 23.55 | 23.55 | 23.55 | 2800.0 |
| 2009-06-29 07:30:00 | MSFT | Stock | 23.55 | 23.55 | 23.55 | 23.55 | 1000.0 |
| 2009-06-29 08:00:00 | MSFT | Stock | 23.55 | 23.6 | 23.5 | 23.57 | 34365.0 |
| 2009-06-29 08:30:00 | MSFT | Stock | 23.61 | 23.61 | 23.54 | 23.57 | 13250.0 |
| 2009-06-29 09:00:00 | MSFT | Stock | 23.54 | 23.62 | 23.54 | 23.6 | 62763.0 |
| 2009-06-29 09:30:00 | MSFT | Stock | 23.6 | 23.89 | 23.55 | 23.881 | 10722717.0 |
| 2009-06-29 10:00:00 | MSFT | Stock | 23.88 | 24.0 | 23.75 | 24.0 | 7419566.0 |
| 2009-06-29 10:30:00 | MSFT | Stock | 24.0 | 24.03 | 23.89 | 23.935 | 5845457.0 |
| 2009-06-29 11:00:00 | MSFT | Stock | 23.94 | 23.99 | 23.93 | 23.98 | 2870330.0 |
| 2009-06-29 11:30:00 | MSFT | Stock | 23.972 | 23.98 | 23.87 | 23.94 | 3476371.0 |
| 2009-06-29 12:00:00 | MSFT | Stock | 23.94 | 23.95 | 23.89 | 23.9 | 2303045.0 |
| 2009-06-29 12:30:00 | MSFT | Stock | 23.9 | 23.96 | 23.83 | 23.84 | 2709405.0 |
| 2009-06-29 13:00:00 | MSFT | Stock | 23.845 | 23.89 | 23.84 | 23.851 | 1738676.0 |
| 2009-06-29 13:30:00 | MSFT | Stock | 23.85 | 23.86 | 23.74 | 23.78 | 2871596.0 |
| 2009-06-29 14:00:00 | MSFT | Stock | 23.77 | 23.8 | 23.7 | 23.74 | 2368623.0 |
| 2009-06-29 14:30:00 | MSFT | Stock | 23.74 | 23.84 | 23.69 | 23.75 | 3917134.0 |
| 2009-06-29 15:00:00 | MSFT | Stock | 23.755 | 23.89 | 23.71 | 23.876 | 3265227.0 |
| 2009-06-29 15:30:00 | MSFT | Stock | 23.87 | 23.88 | 23.72 | 23.82 | 8105463.0 |
| 2009-06-29 16:00:00 | MSFT | Stock | 23.85 | 23.87 | 23.81 | 23.86 | 3801138.0 |
| 2009-06-29 16:30:00 | MSFT | Stock | 23.85 | 23.86 | 23.84 | 23.86 | 16900.0 |
| 2009-06-29 17:00:00 | MSFT | Stock | 23.86 | 23.88 | 23.86 | 23.88 | 1358.0 |
| 2009-06-29 17:30:00 | MSFT | Stock | 24.024 | 24.024 | 23.844 | 23.88 | 67426.0 |
| 2009-06-29 18:00:00 | MSFT | Stock | 23.89 | 23.9 | 23.86 | 23.9 | 4138.0 |
> showing 50 of 71,321 rows — these rows as CSV