PREVIEW / stock_5min / 2015-12-28
file: by_date/stock_5min/2015/2015-12-28.parquet size: 5.4 MB rows: 362,633 symbols: 3,423
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-12-28 05:15:00 | AAPL | Stock | 26.925 | 26.925 | 26.9175 | 26.9175 | 3644.0 |
| 2015-12-28 05:50:00 | AAPL | Stock | 26.9075 | 26.9075 | 26.9075 | 26.9075 | 400.0 |
| 2015-12-28 07:05:00 | AAPL | Stock | 26.8425 | 26.845 | 26.8425 | 26.8425 | 2000.0 |
| 2015-12-28 07:10:00 | AAPL | Stock | 26.84 | 26.84 | 26.84 | 26.84 | 548.0 |
| 2015-12-28 07:15:00 | AAPL | Stock | 26.845 | 26.8725 | 26.845 | 26.8725 | 2400.0 |
| 2015-12-28 07:20:00 | AAPL | Stock | 26.86 | 26.8625 | 26.8125 | 26.8175 | 6200.0 |
| 2015-12-28 07:25:00 | AAPL | Stock | 26.795 | 26.795 | 26.7925 | 26.7925 | 4400.0 |
| 2015-12-28 07:30:00 | AAPL | Stock | 26.8025 | 26.8025 | 26.8 | 26.8 | 2000.0 |
| 2015-12-28 07:35:00 | AAPL | Stock | 26.83 | 26.83 | 26.8225 | 26.8225 | 1200.0 |
| 2015-12-28 07:40:00 | AAPL | Stock | 26.8175 | 26.825 | 26.8175 | 26.825 | 9972.0 |
| 2015-12-28 07:50:00 | AAPL | Stock | 26.825 | 26.825 | 26.825 | 26.825 | 1320.0 |
| 2015-12-28 08:00:00 | AAPL | Stock | 26.8525 | 26.875 | 26.825 | 26.875 | 19804.0 |
| 2015-12-28 08:05:00 | AAPL | Stock | 26.8875 | 26.8875 | 26.8525 | 26.87 | 22672.0 |
| 2015-12-28 08:10:00 | AAPL | Stock | 26.87 | 26.87 | 26.85 | 26.865 | 6800.0 |
| 2015-12-28 08:15:00 | AAPL | Stock | 26.855 | 26.875 | 26.855 | 26.86 | 4560.0 |
| 2015-12-28 08:20:00 | AAPL | Stock | 26.8675 | 26.8775 | 26.8625 | 26.8775 | 12828.0 |
| 2015-12-28 08:25:00 | AAPL | Stock | 26.875 | 26.875 | 26.875 | 26.875 | 6356.0 |
| 2015-12-28 08:30:00 | AAPL | Stock | 26.8825 | 26.8875 | 26.8825 | 26.8875 | 1912.0 |
| 2015-12-28 08:35:00 | AAPL | Stock | 26.9175 | 26.9225 | 26.9 | 26.92 | 9320.0 |
| 2015-12-28 08:40:00 | AAPL | Stock | 26.9125 | 26.92 | 26.91 | 26.915 | 7600.0 |
| 2015-12-28 08:45:00 | AAPL | Stock | 26.9025 | 26.9025 | 26.9 | 26.9025 | 5600.0 |
| 2015-12-28 08:55:00 | AAPL | Stock | 26.91 | 26.925 | 26.91 | 26.925 | 10788.0 |
| 2015-12-28 09:00:00 | AAPL | Stock | 26.925 | 26.9375 | 26.9125 | 26.925 | 30300.0 |
| 2015-12-28 09:05:00 | AAPL | Stock | 26.9225 | 26.935 | 26.915 | 26.915 | 16000.0 |
| 2015-12-28 09:10:00 | AAPL | Stock | 26.92 | 26.935 | 26.9175 | 26.935 | 6400.0 |
| 2015-12-28 09:15:00 | AAPL | Stock | 26.935 | 26.935 | 26.935 | 26.935 | 1200.0 |
| 2015-12-28 09:20:00 | AAPL | Stock | 26.9225 | 26.9225 | 26.9175 | 26.9175 | 800.0 |
| 2015-12-28 09:25:00 | AAPL | Stock | 26.92 | 26.92 | 26.895 | 26.895 | 19064.0 |
| 2015-12-28 09:30:00 | AAPL | Stock | 26.8975 | 26.915 | 26.8625 | 26.8975 | 3142332.0 |
| 2015-12-28 09:35:00 | AAPL | Stock | 26.9 | 26.9225 | 26.8025 | 26.8075 | 2373708.0 |
| 2015-12-28 09:40:00 | AAPL | Stock | 26.813 | 26.82 | 26.73 | 26.75 | 3035664.0 |
| 2015-12-28 09:45:00 | AAPL | Stock | 26.745 | 26.7975 | 26.72 | 26.78 | 2627096.0 |
| 2015-12-28 09:50:00 | AAPL | Stock | 26.7775 | 26.7775 | 26.735 | 26.7425 | 1682208.0 |
| 2015-12-28 09:55:00 | AAPL | Stock | 26.7425 | 26.745 | 26.675 | 26.6935 | 2563228.0 |
| 2015-12-28 10:00:00 | AAPL | Stock | 26.695 | 26.72 | 26.6725 | 26.6875 | 1842948.0 |
| 2015-12-28 10:05:00 | AAPL | Stock | 26.6875 | 26.7375 | 26.6825 | 26.7202 | 1672136.0 |
| 2015-12-28 10:10:00 | AAPL | Stock | 26.7222 | 26.7275 | 26.64 | 26.6525 | 2032900.0 |
| 2015-12-28 10:15:00 | AAPL | Stock | 26.65 | 26.6925 | 26.6425 | 26.6825 | 1438768.0 |
| 2015-12-28 10:20:00 | AAPL | Stock | 26.6825 | 26.6845 | 26.65 | 26.6625 | 1278132.0 |
| 2015-12-28 10:25:00 | AAPL | Stock | 26.6625 | 26.6638 | 26.615 | 26.6212 | 1751796.0 |
| 2015-12-28 10:30:00 | AAPL | Stock | 26.615 | 26.64 | 26.5925 | 26.6288 | 1744868.0 |
| 2015-12-28 10:35:00 | AAPL | Stock | 26.629 | 26.66 | 26.625 | 26.63 | 1337640.0 |
| 2015-12-28 10:40:00 | AAPL | Stock | 26.6312 | 26.645 | 26.625 | 26.6362 | 1580816.0 |
| 2015-12-28 10:45:00 | AAPL | Stock | 26.635 | 26.6625 | 26.58 | 26.585 | 2299076.0 |
| 2015-12-28 10:50:00 | AAPL | Stock | 26.585 | 26.6225 | 26.5625 | 26.5625 | 1374816.0 |
| 2015-12-28 10:55:00 | AAPL | Stock | 26.5625 | 26.575 | 26.5452 | 26.5525 | 1510404.0 |
| 2015-12-28 11:00:00 | AAPL | Stock | 26.5525 | 26.6088 | 26.55 | 26.5922 | 1208572.0 |
| 2015-12-28 11:05:00 | AAPL | Stock | 26.5975 | 26.6325 | 26.5875 | 26.625 | 1131652.0 |
| 2015-12-28 11:10:00 | AAPL | Stock | 26.625 | 26.66 | 26.6125 | 26.66 | 1177308.0 |
| 2015-12-28 11:15:00 | AAPL | Stock | 26.6578 | 26.6825 | 26.6562 | 26.6582 | 1146704.0 |
> showing 50 of 362,633 rows — these rows as CSV