PREVIEW / stock_5min / 2014-12-16
file: by_date/stock_5min/2014/2014-12-16.parquet size: 5.8 MB rows: 384,583 symbols: 3,541
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-16 04:00:00 | AAPL | Stock | 26.975 | 26.975 | 26.77 | 26.7875 | 24860.0 |
| 2014-12-16 04:05:00 | AAPL | Stock | 26.79 | 26.8175 | 26.79 | 26.8175 | 2400.0 |
| 2014-12-16 04:10:00 | AAPL | Stock | 26.795 | 26.845 | 26.795 | 26.845 | 1200.0 |
| 2014-12-16 04:15:00 | AAPL | Stock | 26.845 | 26.8975 | 26.845 | 26.8975 | 1200.0 |
| 2014-12-16 04:30:00 | AAPL | Stock | 26.9 | 26.95 | 26.8975 | 26.95 | 5600.0 |
| 2014-12-16 04:35:00 | AAPL | Stock | 26.95 | 26.9675 | 26.95 | 26.9675 | 2400.0 |
| 2014-12-16 04:40:00 | AAPL | Stock | 26.9025 | 26.925 | 26.9025 | 26.925 | 1212.0 |
| 2014-12-16 04:45:00 | AAPL | Stock | 26.9225 | 26.925 | 26.9225 | 26.925 | 6584.0 |
| 2014-12-16 04:50:00 | AAPL | Stock | 26.925 | 26.945 | 26.925 | 26.945 | 6012.0 |
| 2014-12-16 04:55:00 | AAPL | Stock | 26.945 | 26.945 | 26.945 | 26.945 | 424.0 |
| 2014-12-16 05:00:00 | AAPL | Stock | 26.9525 | 26.9525 | 26.945 | 26.9525 | 9464.0 |
| 2014-12-16 05:20:00 | AAPL | Stock | 26.9575 | 26.9575 | 26.9575 | 26.9575 | 800.0 |
| 2014-12-16 05:25:00 | AAPL | Stock | 26.9475 | 26.9475 | 26.9475 | 26.9475 | 3640.0 |
| 2014-12-16 05:30:00 | AAPL | Stock | 26.9725 | 26.9725 | 26.9725 | 26.9725 | 2000.0 |
| 2014-12-16 05:40:00 | AAPL | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 400.0 |
| 2014-12-16 05:45:00 | AAPL | Stock | 26.9975 | 27.025 | 26.9975 | 27.025 | 6800.0 |
| 2014-12-16 06:00:00 | AAPL | Stock | 26.985 | 27.0 | 26.985 | 27.0 | 2376.0 |
| 2014-12-16 06:10:00 | AAPL | Stock | 27.025 | 27.05 | 27.025 | 27.05 | 15288.0 |
| 2014-12-16 06:15:00 | AAPL | Stock | 27.04 | 27.04 | 27.035 | 27.035 | 9996.0 |
| 2014-12-16 06:20:00 | AAPL | Stock | 27.0375 | 27.0375 | 27.025 | 27.025 | 5484.0 |
| 2014-12-16 06:30:00 | AAPL | Stock | 27.015 | 27.015 | 26.965 | 26.9675 | 8696.0 |
| 2014-12-16 06:35:00 | AAPL | Stock | 26.965 | 26.965 | 26.9625 | 26.9625 | 3200.0 |
| 2014-12-16 06:40:00 | AAPL | Stock | 26.975 | 27.0125 | 26.95 | 26.95 | 4400.0 |
| 2014-12-16 06:45:00 | AAPL | Stock | 26.9375 | 26.9375 | 26.9375 | 26.9375 | 1980.0 |
| 2014-12-16 06:50:00 | AAPL | Stock | 26.92 | 26.92 | 26.875 | 26.875 | 10680.0 |
| 2014-12-16 06:55:00 | AAPL | Stock | 26.8875 | 26.8875 | 26.8275 | 26.8275 | 12456.0 |
| 2014-12-16 07:00:00 | AAPL | Stock | 26.825 | 26.8275 | 26.7775 | 26.78 | 47728.0 |
| 2014-12-16 07:05:00 | AAPL | Stock | 26.795 | 26.795 | 26.675 | 26.725 | 77892.0 |
| 2014-12-16 07:10:00 | AAPL | Stock | 26.69 | 26.7475 | 26.69 | 26.725 | 50680.0 |
| 2014-12-16 07:15:00 | AAPL | Stock | 26.71 | 26.7375 | 26.675 | 26.715 | 21748.0 |
| 2014-12-16 07:20:00 | AAPL | Stock | 26.7025 | 26.7025 | 26.675 | 26.675 | 14800.0 |
| 2014-12-16 07:25:00 | AAPL | Stock | 26.6825 | 26.6875 | 26.595 | 26.6625 | 93216.0 |
| 2014-12-16 07:30:00 | AAPL | Stock | 26.6425 | 26.7125 | 26.6275 | 26.6625 | 46208.0 |
| 2014-12-16 07:35:00 | AAPL | Stock | 26.6625 | 26.6875 | 26.625 | 26.6875 | 77440.0 |
| 2014-12-16 07:40:00 | AAPL | Stock | 26.675 | 26.675 | 26.6025 | 26.6075 | 150204.0 |
| 2014-12-16 07:45:00 | AAPL | Stock | 26.6075 | 26.645 | 26.6075 | 26.645 | 45972.0 |
| 2014-12-16 07:50:00 | AAPL | Stock | 26.625 | 26.65 | 26.5775 | 26.61 | 64856.0 |
| 2014-12-16 07:55:00 | AAPL | Stock | 26.6075 | 26.6075 | 26.55 | 26.555 | 67140.0 |
| 2014-12-16 08:00:00 | AAPL | Stock | 26.555 | 26.8125 | 26.525 | 26.6525 | 564088.0 |
| 2014-12-16 08:05:00 | AAPL | Stock | 26.65 | 26.675 | 26.6125 | 26.675 | 171808.0 |
| 2014-12-16 08:10:00 | AAPL | Stock | 26.6725 | 26.675 | 26.6425 | 26.6425 | 74264.0 |
| 2014-12-16 08:15:00 | AAPL | Stock | 26.65 | 26.725 | 26.6425 | 26.7 | 167820.0 |
| 2014-12-16 08:20:00 | AAPL | Stock | 26.7 | 26.7875 | 26.7 | 26.76 | 258388.0 |
| 2014-12-16 08:25:00 | AAPL | Stock | 26.7675 | 26.775 | 26.7375 | 26.7625 | 110500.0 |
| 2014-12-16 08:30:00 | AAPL | Stock | 26.77 | 26.77 | 26.725 | 26.735 | 122564.0 |
| 2014-12-16 08:35:00 | AAPL | Stock | 26.725 | 26.7375 | 26.675 | 26.6875 | 209840.0 |
| 2014-12-16 08:40:00 | AAPL | Stock | 26.7 | 26.7 | 26.675 | 26.6925 | 97264.0 |
| 2014-12-16 08:45:00 | AAPL | Stock | 26.7 | 26.7375 | 26.6825 | 26.725 | 174136.0 |
| 2014-12-16 08:50:00 | AAPL | Stock | 26.725 | 26.7275 | 26.6775 | 26.6775 | 116824.0 |
| 2014-12-16 08:55:00 | AAPL | Stock | 26.685 | 26.6875 | 26.65 | 26.6525 | 226200.0 |
> showing 50 of 384,583 rows — these rows as CSV