PREVIEW / stock_5min / 2014-10-28
file: by_date/stock_5min/2014/2014-10-28.parquet size: 5.5 MB rows: 367,221 symbols: 3,557
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-28 04:00:00 | AAPL | Stock | 26.1725 | 26.41 | 26.1725 | 26.41 | 5120.0 |
| 2014-10-28 04:05:00 | AAPL | Stock | 26.395 | 26.395 | 26.395 | 26.395 | 400.0 |
| 2014-10-28 04:15:00 | AAPL | Stock | 26.385 | 26.4125 | 26.385 | 26.4125 | 4000.0 |
| 2014-10-28 04:25:00 | AAPL | Stock | 26.42 | 26.42 | 26.4175 | 26.4175 | 4400.0 |
| 2014-10-28 04:30:00 | AAPL | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 3600.0 |
| 2014-10-28 04:35:00 | AAPL | Stock | 26.3775 | 26.3775 | 26.375 | 26.375 | 2800.0 |
| 2014-10-28 04:40:00 | AAPL | Stock | 26.4125 | 26.42 | 26.395 | 26.395 | 1800.0 |
| 2014-10-28 04:50:00 | AAPL | Stock | 26.4125 | 26.4425 | 26.4125 | 26.4425 | 18840.0 |
| 2014-10-28 04:55:00 | AAPL | Stock | 26.4425 | 26.4425 | 26.4425 | 26.4425 | 400.0 |
| 2014-10-28 05:20:00 | AAPL | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 4000.0 |
| 2014-10-28 05:25:00 | AAPL | Stock | 26.4025 | 26.4025 | 26.4025 | 26.4025 | 400.0 |
| 2014-10-28 05:30:00 | AAPL | Stock | 26.4025 | 26.4025 | 26.4025 | 26.4025 | 1000.0 |
| 2014-10-28 05:35:00 | AAPL | Stock | 26.4025 | 26.405 | 26.4025 | 26.405 | 2564.0 |
| 2014-10-28 05:40:00 | AAPL | Stock | 26.4075 | 26.42 | 26.4075 | 26.4175 | 14468.0 |
| 2014-10-28 05:50:00 | AAPL | Stock | 26.425 | 26.425 | 26.425 | 26.425 | 3200.0 |
| 2014-10-28 05:55:00 | AAPL | Stock | 26.425 | 26.43 | 26.4175 | 26.43 | 2800.0 |
| 2014-10-28 06:00:00 | AAPL | Stock | 26.43 | 26.43 | 26.4225 | 26.4225 | 3972.0 |
| 2014-10-28 06:05:00 | AAPL | Stock | 26.4175 | 26.4175 | 26.4175 | 26.4175 | 2000.0 |
| 2014-10-28 06:10:00 | AAPL | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 6000.0 |
| 2014-10-28 06:15:00 | AAPL | Stock | 26.4125 | 26.4125 | 26.4125 | 26.4125 | 4000.0 |
| 2014-10-28 06:20:00 | AAPL | Stock | 26.4125 | 26.4125 | 26.4 | 26.4 | 2800.0 |
| 2014-10-28 06:25:00 | AAPL | Stock | 26.41 | 26.4125 | 26.41 | 26.4125 | 3800.0 |
| 2014-10-28 06:30:00 | AAPL | Stock | 26.4125 | 26.4175 | 26.41 | 26.4175 | 3624.0 |
| 2014-10-28 06:35:00 | AAPL | Stock | 26.42 | 26.4275 | 26.42 | 26.4275 | 2492.0 |
| 2014-10-28 06:40:00 | AAPL | Stock | 26.4175 | 26.4175 | 26.41 | 26.4175 | 14424.0 |
| 2014-10-28 06:45:00 | AAPL | Stock | 26.4225 | 26.4225 | 26.4225 | 26.4225 | 1912.0 |
| 2014-10-28 06:50:00 | AAPL | Stock | 26.4025 | 26.4025 | 26.4 | 26.4 | 7752.0 |
| 2014-10-28 06:55:00 | AAPL | Stock | 26.4025 | 26.425 | 26.4025 | 26.425 | 5996.0 |
| 2014-10-28 07:00:00 | AAPL | Stock | 26.4225 | 26.4225 | 26.405 | 26.42 | 8600.0 |
| 2014-10-28 07:05:00 | AAPL | Stock | 26.4125 | 26.425 | 26.405 | 26.405 | 29784.0 |
| 2014-10-28 07:10:00 | AAPL | Stock | 26.4125 | 26.4125 | 26.375 | 26.4 | 50016.0 |
| 2014-10-28 07:15:00 | AAPL | Stock | 26.4 | 26.4 | 26.38 | 26.4 | 18016.0 |
| 2014-10-28 07:20:00 | AAPL | Stock | 26.4 | 26.4025 | 26.3975 | 26.4025 | 10800.0 |
| 2014-10-28 07:25:00 | AAPL | Stock | 26.4075 | 26.41 | 26.405 | 26.41 | 5820.0 |
| 2014-10-28 07:30:00 | AAPL | Stock | 26.4125 | 26.4125 | 26.405 | 26.4075 | 9600.0 |
| 2014-10-28 07:35:00 | AAPL | Stock | 26.405 | 26.4075 | 26.3875 | 26.4 | 19800.0 |
| 2014-10-28 07:40:00 | AAPL | Stock | 26.385 | 26.4 | 26.385 | 26.4 | 4000.0 |
| 2014-10-28 07:45:00 | AAPL | Stock | 26.3875 | 26.4 | 26.38 | 26.38 | 19552.0 |
| 2014-10-28 07:50:00 | AAPL | Stock | 26.3775 | 26.3875 | 26.3775 | 26.3875 | 2000.0 |
| 2014-10-28 07:55:00 | AAPL | Stock | 26.3975 | 26.3975 | 26.395 | 26.3975 | 11520.0 |
| 2014-10-28 08:00:00 | AAPL | Stock | 26.4 | 26.4225 | 26.1725 | 26.3775 | 308828.0 |
| 2014-10-28 08:05:00 | AAPL | Stock | 26.38 | 26.38 | 26.3625 | 26.3625 | 53884.0 |
| 2014-10-28 08:10:00 | AAPL | Stock | 26.3675 | 26.3675 | 26.3625 | 26.3625 | 18032.0 |
| 2014-10-28 08:15:00 | AAPL | Stock | 26.365 | 26.3675 | 26.355 | 26.3625 | 16600.0 |
| 2014-10-28 08:20:00 | AAPL | Stock | 26.3625 | 26.3625 | 26.3525 | 26.3575 | 21988.0 |
| 2014-10-28 08:25:00 | AAPL | Stock | 26.355 | 26.355 | 26.3375 | 26.34 | 27144.0 |
| 2014-10-28 08:30:00 | AAPL | Stock | 26.34 | 26.36 | 26.3375 | 26.36 | 30052.0 |
| 2014-10-28 08:35:00 | AAPL | Stock | 26.36 | 26.3775 | 26.35 | 26.37 | 91016.0 |
| 2014-10-28 08:40:00 | AAPL | Stock | 26.3725 | 26.3725 | 26.35 | 26.35 | 44596.0 |
| 2014-10-28 08:45:00 | AAPL | Stock | 26.3625 | 26.3625 | 26.355 | 26.36 | 6244.0 |
> showing 50 of 367,221 rows — these rows as CSV