PREVIEW / stock_5min / 2015-07-27
file: by_date/stock_5min/2015/2015-07-27.parquet size: 5.5 MB rows: 360,353 symbols: 3,490
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-07-27 04:00:00 | AAPL | Stock | 31.125 | 31.15 | 31.09 | 31.1375 | 4296.0 |
| 2015-07-27 04:05:00 | AAPL | Stock | 31.1075 | 31.1075 | 31.1075 | 31.1075 | 400.0 |
| 2015-07-27 04:10:00 | AAPL | Stock | 31.1075 | 31.1075 | 31.1075 | 31.1075 | 1600.0 |
| 2015-07-27 04:15:00 | AAPL | Stock | 31.1075 | 31.1075 | 31.1075 | 31.1075 | 400.0 |
| 2015-07-27 04:20:00 | AAPL | Stock | 31.075 | 31.08 | 31.075 | 31.08 | 800.0 |
| 2015-07-27 04:25:00 | AAPL | Stock | 31.125 | 31.14 | 31.1 | 31.1375 | 3600.0 |
| 2015-07-27 04:30:00 | AAPL | Stock | 31.1125 | 31.1125 | 31.1125 | 31.1125 | 18736.0 |
| 2015-07-27 04:35:00 | AAPL | Stock | 31.11 | 31.11 | 31.11 | 31.11 | 400.0 |
| 2015-07-27 04:40:00 | AAPL | Stock | 31.1125 | 31.1125 | 31.1025 | 31.1025 | 1600.0 |
| 2015-07-27 04:45:00 | AAPL | Stock | 31.0875 | 31.0875 | 31.0875 | 31.0875 | 800.0 |
| 2015-07-27 04:55:00 | AAPL | Stock | 31.1 | 31.1 | 31.1 | 31.1 | 2776.0 |
| 2015-07-27 05:05:00 | AAPL | Stock | 31.07 | 31.07 | 31.06 | 31.06 | 12952.0 |
| 2015-07-27 05:10:00 | AAPL | Stock | 31.06 | 31.06 | 31.05 | 31.05 | 3600.0 |
| 2015-07-27 05:15:00 | AAPL | Stock | 31.0425 | 31.0425 | 31.02 | 31.02 | 2200.0 |
| 2015-07-27 05:20:00 | AAPL | Stock | 31.0375 | 31.0375 | 31.0375 | 31.0375 | 1200.0 |
| 2015-07-27 05:25:00 | AAPL | Stock | 31.0375 | 31.0375 | 31.01 | 31.01 | 5200.0 |
| 2015-07-27 05:30:00 | AAPL | Stock | 31.0225 | 31.0225 | 31.0025 | 31.0025 | 4000.0 |
| 2015-07-27 05:35:00 | AAPL | Stock | 31.0125 | 31.0125 | 30.9825 | 30.9825 | 11960.0 |
| 2015-07-27 05:40:00 | AAPL | Stock | 30.9775 | 30.9775 | 30.9775 | 30.9775 | 3964.0 |
| 2015-07-27 05:50:00 | AAPL | Stock | 30.985 | 30.985 | 30.975 | 30.975 | 1148.0 |
| 2015-07-27 05:55:00 | AAPL | Stock | 30.9575 | 30.9575 | 30.925 | 30.925 | 11596.0 |
| 2015-07-27 06:00:00 | AAPL | Stock | 30.9125 | 30.915 | 30.9025 | 30.905 | 20876.0 |
| 2015-07-27 06:05:00 | AAPL | Stock | 30.9 | 30.9 | 30.8925 | 30.895 | 13596.0 |
| 2015-07-27 06:10:00 | AAPL | Stock | 30.885 | 30.885 | 30.875 | 30.875 | 21600.0 |
| 2015-07-27 06:15:00 | AAPL | Stock | 30.8675 | 30.875 | 30.8525 | 30.8525 | 10696.0 |
| 2015-07-27 06:20:00 | AAPL | Stock | 30.8525 | 30.8525 | 30.8525 | 30.8525 | 4892.0 |
| 2015-07-27 06:25:00 | AAPL | Stock | 30.865 | 30.885 | 30.85 | 30.85 | 15620.0 |
| 2015-07-27 06:35:00 | AAPL | Stock | 30.85 | 30.85 | 30.825 | 30.825 | 45476.0 |
| 2015-07-27 06:40:00 | AAPL | Stock | 30.825 | 30.85 | 30.8 | 30.8225 | 37796.0 |
| 2015-07-27 06:45:00 | AAPL | Stock | 30.805 | 30.8825 | 30.805 | 30.88 | 21472.0 |
| 2015-07-27 06:50:00 | AAPL | Stock | 30.8675 | 30.88 | 30.8675 | 30.87 | 4904.0 |
| 2015-07-27 06:55:00 | AAPL | Stock | 30.88 | 30.8825 | 30.85 | 30.8775 | 14796.0 |
| 2015-07-27 07:00:00 | AAPL | Stock | 30.8775 | 30.8775 | 30.855 | 30.855 | 7992.0 |
| 2015-07-27 07:05:00 | AAPL | Stock | 30.85 | 30.8825 | 30.85 | 30.8775 | 33312.0 |
| 2015-07-27 07:10:00 | AAPL | Stock | 30.865 | 30.865 | 30.7975 | 30.8125 | 64916.0 |
| 2015-07-27 07:15:00 | AAPL | Stock | 30.8125 | 30.85 | 30.8125 | 30.825 | 74080.0 |
| 2015-07-27 07:20:00 | AAPL | Stock | 30.8575 | 30.875 | 30.8575 | 30.8675 | 9124.0 |
| 2015-07-27 07:25:00 | AAPL | Stock | 30.87 | 30.87 | 30.81 | 30.81 | 19256.0 |
| 2015-07-27 07:30:00 | AAPL | Stock | 30.81 | 30.825 | 30.7275 | 30.775 | 116776.0 |
| 2015-07-27 07:35:00 | AAPL | Stock | 30.8 | 30.82 | 30.775 | 30.775 | 29500.0 |
| 2015-07-27 07:40:00 | AAPL | Stock | 30.7675 | 30.7675 | 30.76 | 30.76 | 3600.0 |
| 2015-07-27 07:45:00 | AAPL | Stock | 30.755 | 30.755 | 30.725 | 30.725 | 26524.0 |
| 2015-07-27 07:50:00 | AAPL | Stock | 30.7325 | 30.7325 | 30.6875 | 30.7325 | 20604.0 |
| 2015-07-27 07:55:00 | AAPL | Stock | 30.71 | 30.7975 | 30.6975 | 30.775 | 69316.0 |
| 2015-07-27 08:00:00 | AAPL | Stock | 30.765 | 30.8775 | 30.7275 | 30.75 | 329580.0 |
| 2015-07-27 08:05:00 | AAPL | Stock | 30.75 | 30.75 | 30.7 | 30.7375 | 138932.0 |
| 2015-07-27 08:10:00 | AAPL | Stock | 30.75 | 30.785 | 30.75 | 30.78 | 52556.0 |
| 2015-07-27 08:15:00 | AAPL | Stock | 30.78 | 30.7825 | 30.75 | 30.76 | 71996.0 |
| 2015-07-27 08:20:00 | AAPL | Stock | 30.7625 | 30.7725 | 30.75 | 30.75 | 102592.0 |
| 2015-07-27 08:25:00 | AAPL | Stock | 30.75 | 30.765 | 30.75 | 30.7575 | 48856.0 |
> showing 50 of 360,353 rows — these rows as CSV