PREVIEW / stock_30min / 2015-10-21
file: by_date/stock_30min/2015/2015-10-21.parquet size: 1.5 MB rows: 80,361 symbols: 3,411
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-21 04:30:00 | AAPL | Stock | 28.4275 | 28.4275 | 28.4275 | 28.4275 | 400.0 |
| 2015-10-21 05:00:00 | AAPL | Stock | 28.455 | 28.495 | 28.4525 | 28.495 | 4892.0 |
| 2015-10-21 05:30:00 | AAPL | Stock | 28.5125 | 28.5125 | 28.4775 | 28.4775 | 6792.0 |
| 2015-10-21 06:00:00 | AAPL | Stock | 28.4875 | 28.525 | 28.48 | 28.5225 | 13800.0 |
| 2015-10-21 06:30:00 | AAPL | Stock | 28.525 | 28.525 | 28.5 | 28.5 | 17304.0 |
| 2015-10-21 07:00:00 | AAPL | Stock | 28.4825 | 28.4825 | 28.4625 | 28.4625 | 5720.0 |
| 2015-10-21 07:30:00 | AAPL | Stock | 28.4675 | 28.4825 | 28.4325 | 28.4325 | 31784.0 |
| 2015-10-21 08:00:00 | AAPL | Stock | 28.4175 | 28.52 | 28.3575 | 28.4 | 240380.0 |
| 2015-10-21 08:30:00 | AAPL | Stock | 28.4125 | 28.475 | 28.4125 | 28.475 | 233544.0 |
| 2015-10-21 09:00:00 | AAPL | Stock | 28.475 | 28.5 | 28.425 | 28.48 | 826976.0 |
| 2015-10-21 09:30:00 | AAPL | Stock | 28.49 | 28.625 | 28.425 | 28.5625 | 24504968.0 |
| 2015-10-21 10:00:00 | AAPL | Stock | 28.5625 | 28.5625 | 28.4525 | 28.4725 | 11193756.0 |
| 2015-10-21 10:30:00 | AAPL | Stock | 28.4725 | 28.605 | 28.4525 | 28.5735 | 9434340.0 |
| 2015-10-21 11:00:00 | AAPL | Stock | 28.575 | 28.6088 | 28.515 | 28.5712 | 6788500.0 |
| 2015-10-21 11:30:00 | AAPL | Stock | 28.575 | 28.785 | 28.575 | 28.7805 | 14967172.0 |
| 2015-10-21 12:00:00 | AAPL | Stock | 28.78 | 28.8725 | 28.7525 | 28.865 | 11125260.0 |
| 2015-10-21 12:30:00 | AAPL | Stock | 28.865 | 28.895 | 28.77 | 28.7738 | 12170876.0 |
| 2015-10-21 13:00:00 | AAPL | Stock | 28.7735 | 28.785 | 28.6725 | 28.69 | 9893808.0 |
| 2015-10-21 13:30:00 | AAPL | Stock | 28.69 | 28.77 | 28.6625 | 28.6835 | 8202320.0 |
| 2015-10-21 14:00:00 | AAPL | Stock | 28.6825 | 28.6875 | 28.5775 | 28.65 | 8432984.0 |
| 2015-10-21 14:30:00 | AAPL | Stock | 28.65 | 28.72 | 28.6075 | 28.6425 | 10874344.0 |
| 2015-10-21 15:00:00 | AAPL | Stock | 28.64 | 28.6775 | 28.5325 | 28.6025 | 8118812.0 |
| 2015-10-21 15:30:00 | AAPL | Stock | 28.6025 | 28.61 | 28.4325 | 28.44 | 14621188.0 |
| 2015-10-21 16:00:00 | AAPL | Stock | 28.44 | 28.4625 | 28.4 | 28.4125 | 6468728.0 |
| 2015-10-21 16:30:00 | AAPL | Stock | 28.4025 | 28.445 | 28.4 | 28.4325 | 88840.0 |
| 2015-10-21 17:00:00 | AAPL | Stock | 28.4425 | 28.4625 | 28.4425 | 28.4625 | 87576.0 |
| 2015-10-21 17:30:00 | AAPL | Stock | 28.455 | 28.4625 | 28.44 | 28.44 | 36388.0 |
| 2015-10-21 18:00:00 | AAPL | Stock | 28.445 | 28.46 | 28.4375 | 28.45 | 33380.0 |
| 2015-10-21 18:30:00 | AAPL | Stock | 28.44 | 28.4475 | 28.43 | 28.4375 | 12644.0 |
| 2015-10-21 19:00:00 | AAPL | Stock | 28.4475 | 28.4475 | 28.4275 | 28.4375 | 15052.0 |
| 2015-10-21 19:30:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.4125 | 28.4375 | 26216.0 |
| 2015-10-21 05:00:00 | MSFT | Stock | 47.68 | 47.68 | 47.68 | 47.68 | 2100.0 |
| 2015-10-21 06:00:00 | MSFT | Stock | 47.8 | 47.8 | 47.8 | 47.8 | 500.0 |
| 2015-10-21 07:00:00 | MSFT | Stock | 47.83 | 47.83 | 47.83 | 47.83 | 690.0 |
| 2015-10-21 07:30:00 | MSFT | Stock | 47.78 | 47.78 | 47.78 | 47.78 | 100.0 |
| 2015-10-21 08:00:00 | MSFT | Stock | 47.81 | 48.02 | 47.81 | 47.93 | 11571.0 |
| 2015-10-21 08:30:00 | MSFT | Stock | 47.93 | 48.0 | 47.91 | 47.97 | 3698.0 |
| 2015-10-21 09:00:00 | MSFT | Stock | 47.97 | 48.0 | 47.87 | 47.93 | 40765.0 |
| 2015-10-21 09:30:00 | MSFT | Stock | 47.95 | 47.95 | 47.57 | 47.77 | 2334344.0 |
| 2015-10-21 10:00:00 | MSFT | Stock | 47.78 | 47.84 | 47.68 | 47.767 | 1525682.0 |
| 2015-10-21 10:30:00 | MSFT | Stock | 47.76 | 47.87 | 47.7 | 47.84 | 1683342.0 |
| 2015-10-21 11:00:00 | MSFT | Stock | 47.85 | 47.88 | 47.725 | 47.86 | 1302466.0 |
| 2015-10-21 11:30:00 | MSFT | Stock | 47.87 | 47.99 | 47.81 | 47.945 | 1713510.0 |
| 2015-10-21 12:00:00 | MSFT | Stock | 47.942 | 47.99 | 47.91 | 47.967 | 701498.0 |
| 2015-10-21 12:30:00 | MSFT | Stock | 47.97 | 47.98 | 47.82 | 47.82 | 1040656.0 |
| 2015-10-21 13:00:00 | MSFT | Stock | 47.814 | 47.82 | 47.51 | 47.52 | 1362796.0 |
| 2015-10-21 13:30:00 | MSFT | Stock | 47.52 | 47.56 | 47.4 | 47.47 | 1347516.0 |
| 2015-10-21 14:00:00 | MSFT | Stock | 47.46 | 47.52 | 47.37 | 47.515 | 1102112.0 |
| 2015-10-21 14:30:00 | MSFT | Stock | 47.52 | 47.69 | 47.49 | 47.53 | 1119332.0 |
| 2015-10-21 15:00:00 | MSFT | Stock | 47.54 | 47.58 | 47.385 | 47.469 | 1497664.0 |
> showing 50 of 80,361 rows — these rows as CSV