PREVIEW / stock_5min / 2015-11-10
file: by_date/stock_5min/2015/2015-11-10.parquet size: 5.4 MB rows: 360,181 symbols: 3,398
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-11-10 04:00:00 | AAPL | Stock | 30.1125 | 30.1125 | 30.1125 | 30.1125 | 8000.0 |
| 2015-11-10 04:15:00 | AAPL | Stock | 30.07 | 30.07 | 30.07 | 30.07 | 776.0 |
| 2015-11-10 04:20:00 | AAPL | Stock | 30.02 | 30.02 | 29.9825 | 29.9825 | 11584.0 |
| 2015-11-10 04:25:00 | AAPL | Stock | 30.04 | 30.04 | 30.0 | 30.0225 | 7084.0 |
| 2015-11-10 04:30:00 | AAPL | Stock | 30.0 | 30.0 | 29.9975 | 29.9975 | 14380.0 |
| 2015-11-10 04:45:00 | AAPL | Stock | 29.9725 | 29.9725 | 29.9725 | 29.9725 | 2000.0 |
| 2015-11-10 05:10:00 | AAPL | Stock | 30.0075 | 30.0075 | 30.0 | 30.0 | 2000.0 |
| 2015-11-10 05:20:00 | AAPL | Stock | 29.9975 | 29.9975 | 29.9975 | 29.9975 | 472.0 |
| 2015-11-10 05:35:00 | AAPL | Stock | 30.0 | 30.0 | 30.0 | 30.0 | 780.0 |
| 2015-11-10 05:45:00 | AAPL | Stock | 29.9925 | 30.0 | 29.9925 | 30.0 | 2220.0 |
| 2015-11-10 05:55:00 | AAPL | Stock | 29.95 | 29.95 | 29.95 | 29.95 | 6000.0 |
| 2015-11-10 06:00:00 | AAPL | Stock | 29.93 | 29.93 | 29.885 | 29.885 | 13952.0 |
| 2015-11-10 06:05:00 | AAPL | Stock | 29.9 | 29.9 | 29.875 | 29.875 | 28608.0 |
| 2015-11-10 06:10:00 | AAPL | Stock | 29.8775 | 29.9125 | 29.8775 | 29.9125 | 4400.0 |
| 2015-11-10 06:15:00 | AAPL | Stock | 29.88 | 29.88 | 29.8625 | 29.8625 | 5600.0 |
| 2015-11-10 06:20:00 | AAPL | Stock | 29.875 | 29.8875 | 29.875 | 29.8875 | 1000.0 |
| 2015-11-10 06:25:00 | AAPL | Stock | 29.8875 | 29.89 | 29.875 | 29.89 | 16940.0 |
| 2015-11-10 06:30:00 | AAPL | Stock | 29.8775 | 29.9 | 29.8725 | 29.9 | 6000.0 |
| 2015-11-10 06:35:00 | AAPL | Stock | 29.905 | 29.9225 | 29.9 | 29.92 | 10400.0 |
| 2015-11-10 06:40:00 | AAPL | Stock | 29.925 | 29.925 | 29.915 | 29.915 | 2400.0 |
| 2015-11-10 06:45:00 | AAPL | Stock | 29.925 | 29.925 | 29.9125 | 29.9125 | 15292.0 |
| 2015-11-10 06:50:00 | AAPL | Stock | 29.9125 | 29.915 | 29.875 | 29.875 | 39168.0 |
| 2015-11-10 06:55:00 | AAPL | Stock | 29.9 | 29.9 | 29.8825 | 29.895 | 14244.0 |
| 2015-11-10 07:00:00 | AAPL | Stock | 29.91 | 29.9125 | 29.81 | 29.825 | 140780.0 |
| 2015-11-10 07:05:00 | AAPL | Stock | 29.825 | 29.825 | 29.7 | 29.725 | 139748.0 |
| 2015-11-10 07:10:00 | AAPL | Stock | 29.75 | 29.75 | 29.6625 | 29.7375 | 128252.0 |
| 2015-11-10 07:15:00 | AAPL | Stock | 29.725 | 29.725 | 29.7 | 29.7225 | 24040.0 |
| 2015-11-10 07:20:00 | AAPL | Stock | 29.725 | 29.75 | 29.725 | 29.7275 | 62812.0 |
| 2015-11-10 07:25:00 | AAPL | Stock | 29.725 | 29.725 | 29.575 | 29.6 | 122736.0 |
| 2015-11-10 07:30:00 | AAPL | Stock | 29.625 | 29.675 | 29.625 | 29.665 | 48244.0 |
| 2015-11-10 07:35:00 | AAPL | Stock | 29.6625 | 29.675 | 29.6425 | 29.6625 | 37196.0 |
| 2015-11-10 07:40:00 | AAPL | Stock | 29.6725 | 29.7 | 29.6625 | 29.675 | 46468.0 |
| 2015-11-10 07:45:00 | AAPL | Stock | 29.67 | 29.67 | 29.4775 | 29.5 | 193072.0 |
| 2015-11-10 07:50:00 | AAPL | Stock | 29.5275 | 29.575 | 29.505 | 29.55 | 122200.0 |
| 2015-11-10 07:55:00 | AAPL | Stock | 29.5525 | 29.61 | 29.5525 | 29.575 | 81844.0 |
| 2015-11-10 08:00:00 | AAPL | Stock | 29.575 | 30.075 | 29.5375 | 29.59 | 367552.0 |
| 2015-11-10 08:05:00 | AAPL | Stock | 29.59 | 29.625 | 29.5775 | 29.6 | 145192.0 |
| 2015-11-10 08:10:00 | AAPL | Stock | 29.6 | 29.6025 | 29.5625 | 29.58 | 236724.0 |
| 2015-11-10 08:15:00 | AAPL | Stock | 29.5825 | 29.65 | 29.5825 | 29.5925 | 309976.0 |
| 2015-11-10 08:20:00 | AAPL | Stock | 29.6 | 29.6025 | 29.5525 | 29.5625 | 161132.0 |
| 2015-11-10 08:25:00 | AAPL | Stock | 29.5625 | 29.5875 | 29.495 | 29.51 | 226888.0 |
| 2015-11-10 08:30:00 | AAPL | Stock | 29.5 | 29.5025 | 29.3775 | 29.435 | 740856.0 |
| 2015-11-10 08:35:00 | AAPL | Stock | 29.4325 | 29.45 | 29.3875 | 29.4375 | 641696.0 |
| 2015-11-10 08:40:00 | AAPL | Stock | 29.435 | 29.46 | 29.42 | 29.4325 | 170456.0 |
| 2015-11-10 08:45:00 | AAPL | Stock | 29.4325 | 29.445 | 29.425 | 29.43 | 171248.0 |
| 2015-11-10 08:50:00 | AAPL | Stock | 29.435 | 29.45 | 29.4275 | 29.45 | 61020.0 |
| 2015-11-10 08:55:00 | AAPL | Stock | 29.4425 | 29.4625 | 29.425 | 29.445 | 287588.0 |
| 2015-11-10 09:00:00 | AAPL | Stock | 29.445 | 29.4475 | 29.3875 | 29.39 | 269168.0 |
| 2015-11-10 09:05:00 | AAPL | Stock | 29.4 | 29.4125 | 29.3225 | 29.34 | 802108.0 |
| 2015-11-10 09:10:00 | AAPL | Stock | 29.34 | 29.3625 | 29.315 | 29.32 | 284020.0 |
> showing 50 of 360,181 rows — these rows as CSV