PREVIEW / stock_30min / 2016-05-05
file: by_date/stock_30min/2016/2016-05-05.parquet size: 1.6 MB rows: 82,042 symbols: 3,298
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-05 05:00:00 | AAPL | Stock | 23.5875 | 23.5875 | 23.5875 | 23.5875 | 6640.0 |
| 2016-05-05 05:30:00 | AAPL | Stock | 23.5975 | 23.5975 | 23.57 | 23.5875 | 3332.0 |
| 2016-05-05 06:00:00 | AAPL | Stock | 23.575 | 23.575 | 23.55 | 23.55 | 4600.0 |
| 2016-05-05 06:30:00 | AAPL | Stock | 23.5125 | 23.5375 | 23.5 | 23.5375 | 5516.0 |
| 2016-05-05 07:00:00 | AAPL | Stock | 23.55 | 23.55 | 23.5 | 23.5125 | 17644.0 |
| 2016-05-05 07:30:00 | AAPL | Stock | 23.495 | 23.525 | 23.495 | 23.5125 | 22552.0 |
| 2016-05-05 08:00:00 | AAPL | Stock | 23.52 | 23.5625 | 23.5 | 23.515 | 126600.0 |
| 2016-05-05 08:30:00 | AAPL | Stock | 23.515 | 23.5375 | 23.51 | 23.51 | 128136.0 |
| 2016-05-05 09:00:00 | AAPL | Stock | 23.52 | 23.53 | 23.405 | 23.4975 | 193584.0 |
| 2016-05-05 09:30:00 | AAPL | Stock | 23.5 | 23.5175 | 23.25 | 23.2798 | 20243228.0 |
| 2016-05-05 10:00:00 | AAPL | Stock | 23.2775 | 23.385 | 23.2075 | 23.225 | 14261308.0 |
| 2016-05-05 10:30:00 | AAPL | Stock | 23.2225 | 23.3 | 23.21 | 23.3 | 9571488.0 |
| 2016-05-05 11:00:00 | AAPL | Stock | 23.3 | 23.36 | 23.26 | 23.265 | 7837872.0 |
| 2016-05-05 11:30:00 | AAPL | Stock | 23.265 | 23.3475 | 23.2625 | 23.2958 | 6050688.0 |
| 2016-05-05 12:00:00 | AAPL | Stock | 23.295 | 23.3275 | 23.2575 | 23.2782 | 4910548.0 |
| 2016-05-05 12:30:00 | AAPL | Stock | 23.2775 | 23.2775 | 23.2275 | 23.2425 | 6794432.0 |
| 2016-05-05 13:00:00 | AAPL | Stock | 23.2415 | 23.2525 | 23.17 | 23.209 | 9388996.0 |
| 2016-05-05 13:30:00 | AAPL | Stock | 23.21 | 23.2275 | 23.1737 | 23.215 | 6185796.0 |
| 2016-05-05 14:00:00 | AAPL | Stock | 23.215 | 23.2662 | 23.1788 | 23.235 | 7633008.0 |
| 2016-05-05 14:30:00 | AAPL | Stock | 23.2375 | 23.3 | 23.2262 | 23.2462 | 6344688.0 |
| 2016-05-05 15:00:00 | AAPL | Stock | 23.2462 | 23.2725 | 23.215 | 23.2575 | 7494504.0 |
| 2016-05-05 15:30:00 | AAPL | Stock | 23.2575 | 23.31 | 23.2475 | 23.31 | 14613744.0 |
| 2016-05-05 16:00:00 | AAPL | Stock | 23.31 | 23.3375 | 23.265 | 23.325 | 10159708.0 |
| 2016-05-05 16:30:00 | AAPL | Stock | 23.3225 | 23.3225 | 23.2925 | 23.31 | 19416.0 |
| 2016-05-05 17:00:00 | AAPL | Stock | 23.3 | 23.32 | 23.295 | 23.31 | 35104.0 |
| 2016-05-05 17:30:00 | AAPL | Stock | 23.31 | 23.3125 | 23.3025 | 23.31 | 8576.0 |
| 2016-05-05 18:00:00 | AAPL | Stock | 23.3025 | 23.3075 | 23.3 | 23.3 | 13984.0 |
| 2016-05-05 18:30:00 | AAPL | Stock | 23.3 | 23.31 | 23.29 | 23.3 | 37740.0 |
| 2016-05-05 19:00:00 | AAPL | Stock | 23.3075 | 23.3075 | 23.29 | 23.2925 | 8564.0 |
| 2016-05-05 19:30:00 | AAPL | Stock | 23.3025 | 23.3025 | 23.2875 | 23.3025 | 29520.0 |
| 2016-05-05 07:00:00 | MSFT | Stock | 50.15 | 50.15 | 50.15 | 50.15 | 139.0 |
| 2016-05-05 07:30:00 | MSFT | Stock | 50.0 | 50.0 | 50.0 | 50.0 | 421.0 |
| 2016-05-05 08:00:00 | MSFT | Stock | 50.05 | 50.14 | 50.01 | 50.14 | 4258.0 |
| 2016-05-05 08:30:00 | MSFT | Stock | 50.08 | 50.12 | 50.06 | 50.06 | 6118.0 |
| 2016-05-05 09:00:00 | MSFT | Stock | 50.05 | 50.05 | 49.86 | 49.86 | 60555.0 |
| 2016-05-05 09:30:00 | MSFT | Stock | 49.89 | 50.05 | 49.73 | 49.78 | 2858337.0 |
| 2016-05-05 10:00:00 | MSFT | Stock | 49.78 | 50.028 | 49.748 | 49.905 | 1860483.0 |
| 2016-05-05 10:30:00 | MSFT | Stock | 49.9 | 50.09 | 49.9 | 50.08 | 1645253.0 |
| 2016-05-05 11:00:00 | MSFT | Stock | 50.09 | 50.19 | 50.05 | 50.115 | 1525544.0 |
| 2016-05-05 11:30:00 | MSFT | Stock | 50.119 | 50.3 | 50.11 | 50.15 | 1104392.0 |
| 2016-05-05 12:00:00 | MSFT | Stock | 50.15 | 50.16 | 50.015 | 50.06 | 877935.0 |
| 2016-05-05 12:30:00 | MSFT | Stock | 50.06 | 50.09 | 49.985 | 50.032 | 853911.0 |
| 2016-05-05 13:00:00 | MSFT | Stock | 50.03 | 50.05 | 49.855 | 49.915 | 1223084.0 |
| 2016-05-05 13:30:00 | MSFT | Stock | 49.915 | 49.97 | 49.875 | 49.94 | 1036536.0 |
| 2016-05-05 14:00:00 | MSFT | Stock | 49.94 | 50.04 | 49.88 | 49.95 | 1075757.0 |
| 2016-05-05 14:30:00 | MSFT | Stock | 49.95 | 50.0 | 49.91 | 49.926 | 1030672.0 |
| 2016-05-05 15:00:00 | MSFT | Stock | 49.92 | 49.98 | 49.86 | 49.942 | 1345248.0 |
| 2016-05-05 15:30:00 | MSFT | Stock | 49.944 | 49.99 | 49.815 | 49.94 | 4316488.0 |
| 2016-05-05 16:00:00 | MSFT | Stock | 49.93 | 49.95 | 49.91 | 49.94 | 2833895.0 |
| 2016-05-05 16:30:00 | MSFT | Stock | 49.94 | 49.94 | 49.91 | 49.91 | 300.0 |
> showing 50 of 82,042 rows — these rows as CSV