PREVIEW / stock_5min / 2014-10-30
file: by_date/stock_5min/2014/2014-10-30.parquet size: 5.1 MB rows: 333,629 symbols: 3,554
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-10-30 04:00:00 | AAPL | Stock | 26.8 | 26.8125 | 26.8 | 26.8125 | 4000.0 |
| 2014-10-30 04:05:00 | AAPL | Stock | 26.825 | 26.85 | 26.825 | 26.85 | 4000.0 |
| 2014-10-30 04:20:00 | AAPL | Stock | 26.85 | 26.85 | 26.825 | 26.825 | 4400.0 |
| 2014-10-30 04:30:00 | AAPL | Stock | 26.825 | 26.825 | 26.805 | 26.805 | 4800.0 |
| 2014-10-30 04:35:00 | AAPL | Stock | 26.8125 | 26.8125 | 26.8 | 26.8 | 5600.0 |
| 2014-10-30 04:40:00 | AAPL | Stock | 26.8 | 26.8 | 26.7875 | 26.7875 | 5320.0 |
| 2014-10-30 04:45:00 | AAPL | Stock | 26.775 | 26.775 | 26.775 | 26.775 | 20400.0 |
| 2014-10-30 04:50:00 | AAPL | Stock | 26.775 | 26.775 | 26.775 | 26.775 | 4000.0 |
| 2014-10-30 04:55:00 | AAPL | Stock | 26.775 | 26.775 | 26.775 | 26.775 | 4000.0 |
| 2014-10-30 05:00:00 | AAPL | Stock | 26.775 | 26.775 | 26.775 | 26.775 | 4000.0 |
| 2014-10-30 05:05:00 | AAPL | Stock | 26.7725 | 26.7725 | 26.7625 | 26.7625 | 800.0 |
| 2014-10-30 05:10:00 | AAPL | Stock | 26.745 | 26.75 | 26.745 | 26.75 | 2400.0 |
| 2014-10-30 05:15:00 | AAPL | Stock | 26.745 | 26.745 | 26.7375 | 26.7375 | 7284.0 |
| 2014-10-30 05:20:00 | AAPL | Stock | 26.75 | 26.75 | 26.7125 | 26.7125 | 2800.0 |
| 2014-10-30 05:25:00 | AAPL | Stock | 26.7025 | 26.715 | 26.7025 | 26.715 | 4800.0 |
| 2014-10-30 05:45:00 | AAPL | Stock | 26.7025 | 26.7025 | 26.6875 | 26.6875 | 11916.0 |
| 2014-10-30 05:50:00 | AAPL | Stock | 26.685 | 26.69 | 26.675 | 26.69 | 7648.0 |
| 2014-10-30 05:55:00 | AAPL | Stock | 26.665 | 26.69 | 26.665 | 26.69 | 1600.0 |
| 2014-10-30 06:00:00 | AAPL | Stock | 26.68 | 26.69 | 26.67 | 26.69 | 27716.0 |
| 2014-10-30 06:05:00 | AAPL | Stock | 26.6875 | 26.6875 | 26.68 | 26.68 | 13144.0 |
| 2014-10-30 06:10:00 | AAPL | Stock | 26.6775 | 26.6775 | 26.65 | 26.65 | 4720.0 |
| 2014-10-30 06:15:00 | AAPL | Stock | 26.685 | 26.705 | 26.685 | 26.705 | 1360.0 |
| 2014-10-30 06:20:00 | AAPL | Stock | 26.7025 | 26.71 | 26.7025 | 26.71 | 5204.0 |
| 2014-10-30 06:30:00 | AAPL | Stock | 26.7075 | 26.7075 | 26.7075 | 26.7075 | 1000.0 |
| 2014-10-30 06:35:00 | AAPL | Stock | 26.7075 | 26.7075 | 26.7075 | 26.7075 | 5024.0 |
| 2014-10-30 06:40:00 | AAPL | Stock | 26.7025 | 26.7025 | 26.6775 | 26.6775 | 6700.0 |
| 2014-10-30 06:45:00 | AAPL | Stock | 26.6625 | 26.6625 | 26.655 | 26.655 | 8732.0 |
| 2014-10-30 06:50:00 | AAPL | Stock | 26.655 | 26.655 | 26.6525 | 26.655 | 4012.0 |
| 2014-10-30 06:55:00 | AAPL | Stock | 26.655 | 26.6575 | 26.65 | 26.65 | 7148.0 |
| 2014-10-30 07:00:00 | AAPL | Stock | 26.6475 | 26.65 | 26.6125 | 26.63 | 36980.0 |
| 2014-10-30 07:05:00 | AAPL | Stock | 26.6625 | 26.6625 | 26.65 | 26.6625 | 17600.0 |
| 2014-10-30 07:10:00 | AAPL | Stock | 26.67 | 26.6875 | 26.6625 | 26.685 | 34268.0 |
| 2014-10-30 07:15:00 | AAPL | Stock | 26.6825 | 26.6825 | 26.65 | 26.6625 | 35320.0 |
| 2014-10-30 07:20:00 | AAPL | Stock | 26.6375 | 26.645 | 26.635 | 26.64 | 14216.0 |
| 2014-10-30 07:25:00 | AAPL | Stock | 26.65 | 26.6575 | 26.65 | 26.65 | 29324.0 |
| 2014-10-30 07:30:00 | AAPL | Stock | 26.64 | 26.64 | 26.615 | 26.615 | 42812.0 |
| 2014-10-30 07:35:00 | AAPL | Stock | 26.615 | 26.6175 | 26.6 | 26.6125 | 36160.0 |
| 2014-10-30 07:40:00 | AAPL | Stock | 26.6225 | 26.625 | 26.6125 | 26.625 | 10400.0 |
| 2014-10-30 07:45:00 | AAPL | Stock | 26.625 | 26.625 | 26.625 | 26.625 | 6400.0 |
| 2014-10-30 07:50:00 | AAPL | Stock | 26.6275 | 26.66 | 26.6275 | 26.66 | 21500.0 |
| 2014-10-30 07:55:00 | AAPL | Stock | 26.655 | 26.6725 | 26.65 | 26.6725 | 20352.0 |
| 2014-10-30 08:00:00 | AAPL | Stock | 26.6625 | 26.835 | 26.61 | 26.705 | 226776.0 |
| 2014-10-30 08:05:00 | AAPL | Stock | 26.6575 | 26.725 | 26.6575 | 26.725 | 51616.0 |
| 2014-10-30 08:10:00 | AAPL | Stock | 26.725 | 26.725 | 26.705 | 26.7125 | 31608.0 |
| 2014-10-30 08:15:00 | AAPL | Stock | 26.7 | 26.745 | 26.7 | 26.7325 | 54388.0 |
| 2014-10-30 08:20:00 | AAPL | Stock | 26.7325 | 26.745 | 26.725 | 26.735 | 28420.0 |
| 2014-10-30 08:25:00 | AAPL | Stock | 26.735 | 26.7425 | 26.7275 | 26.7375 | 35128.0 |
| 2014-10-30 08:30:00 | AAPL | Stock | 26.745 | 26.775 | 26.74 | 26.7525 | 21572.0 |
| 2014-10-30 08:35:00 | AAPL | Stock | 26.7575 | 26.78 | 26.75 | 26.75 | 62836.0 |
| 2014-10-30 08:40:00 | AAPL | Stock | 26.7475 | 26.7975 | 26.7425 | 26.7875 | 63560.0 |
> showing 50 of 333,629 rows — these rows as CSV