PREVIEW / stock_5min / 2016-10-17
file: by_date/stock_5min/2016/2016-10-17.parquet size: 5.1 MB rows: 339,398 symbols: 3,184
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 |
|---|---|---|---|---|---|---|---|
| 2016-10-17 04:00:00 | AAPL | Stock | 29.3775 | 29.5 | 29.31 | 29.5 | 6360.0 |
| 2016-10-17 04:10:00 | AAPL | Stock | 29.3125 | 29.3125 | 29.3125 | 29.3125 | 400.0 |
| 2016-10-17 04:20:00 | AAPL | Stock | 29.3175 | 29.3175 | 29.3175 | 29.3175 | 1856.0 |
| 2016-10-17 05:00:00 | AAPL | Stock | 29.3 | 29.3 | 29.3 | 29.3 | 3600.0 |
| 2016-10-17 05:05:00 | AAPL | Stock | 29.3025 | 29.3025 | 29.3 | 29.3 | 15696.0 |
| 2016-10-17 05:15:00 | AAPL | Stock | 29.3 | 29.3 | 29.3 | 29.3 | 1200.0 |
| 2016-10-17 05:20:00 | AAPL | Stock | 29.325 | 29.325 | 29.325 | 29.325 | 400.0 |
| 2016-10-17 05:40:00 | AAPL | Stock | 29.3 | 29.3 | 29.3 | 29.3 | 1184.0 |
| 2016-10-17 05:45:00 | AAPL | Stock | 29.3 | 29.3 | 29.3 | 29.3 | 400.0 |
| 2016-10-17 05:50:00 | AAPL | Stock | 29.3 | 29.3 | 29.3 | 29.3 | 400.0 |
| 2016-10-17 06:05:00 | AAPL | Stock | 29.3 | 29.3 | 29.3 | 29.3 | 400.0 |
| 2016-10-17 06:30:00 | AAPL | Stock | 29.3375 | 29.3375 | 29.3375 | 29.3375 | 2800.0 |
| 2016-10-17 06:45:00 | AAPL | Stock | 29.3275 | 29.3275 | 29.3275 | 29.3275 | 1200.0 |
| 2016-10-17 06:50:00 | AAPL | Stock | 29.335 | 29.335 | 29.335 | 29.335 | 400.0 |
| 2016-10-17 06:55:00 | AAPL | Stock | 29.3375 | 29.3375 | 29.3375 | 29.3375 | 1200.0 |
| 2016-10-17 07:00:00 | AAPL | Stock | 29.3375 | 29.35 | 29.3375 | 29.35 | 1340.0 |
| 2016-10-17 07:05:00 | AAPL | Stock | 29.35 | 29.3725 | 29.35 | 29.355 | 4776.0 |
| 2016-10-17 07:10:00 | AAPL | Stock | 29.375 | 29.3925 | 29.375 | 29.3875 | 11124.0 |
| 2016-10-17 07:15:00 | AAPL | Stock | 29.395 | 29.395 | 29.395 | 29.395 | 3748.0 |
| 2016-10-17 07:20:00 | AAPL | Stock | 29.3875 | 29.405 | 29.3875 | 29.405 | 9200.0 |
| 2016-10-17 07:25:00 | AAPL | Stock | 29.42 | 29.425 | 29.42 | 29.425 | 2500.0 |
| 2016-10-17 07:30:00 | AAPL | Stock | 29.43 | 29.43 | 29.4075 | 29.4075 | 1240.0 |
| 2016-10-17 07:35:00 | AAPL | Stock | 29.4125 | 29.4125 | 29.4125 | 29.4125 | 400.0 |
| 2016-10-17 07:45:00 | AAPL | Stock | 29.425 | 29.425 | 29.4075 | 29.4075 | 4220.0 |
| 2016-10-17 07:50:00 | AAPL | Stock | 29.415 | 29.415 | 29.4075 | 29.4075 | 1660.0 |
| 2016-10-17 07:55:00 | AAPL | Stock | 29.4125 | 29.4125 | 29.4125 | 29.4125 | 1092.0 |
| 2016-10-17 08:00:00 | AAPL | Stock | 29.4125 | 29.45 | 29.3475 | 29.45 | 81744.0 |
| 2016-10-17 08:05:00 | AAPL | Stock | 29.45 | 29.4625 | 29.44 | 29.4625 | 10168.0 |
| 2016-10-17 08:10:00 | AAPL | Stock | 29.475 | 29.475 | 29.4575 | 29.475 | 12300.0 |
| 2016-10-17 08:15:00 | AAPL | Stock | 29.4575 | 29.4575 | 29.445 | 29.445 | 9788.0 |
| 2016-10-17 08:20:00 | AAPL | Stock | 29.445 | 29.46 | 29.445 | 29.45 | 14664.0 |
| 2016-10-17 08:25:00 | AAPL | Stock | 29.45 | 29.46 | 29.45 | 29.45 | 4464.0 |
| 2016-10-17 08:30:00 | AAPL | Stock | 29.4575 | 29.4575 | 29.4575 | 29.4575 | 600.0 |
| 2016-10-17 08:35:00 | AAPL | Stock | 29.4575 | 29.4575 | 29.42 | 29.42 | 14356.0 |
| 2016-10-17 08:40:00 | AAPL | Stock | 29.43 | 29.43 | 29.4275 | 29.43 | 13700.0 |
| 2016-10-17 08:45:00 | AAPL | Stock | 29.43 | 29.44 | 29.425 | 29.44 | 2400.0 |
| 2016-10-17 08:50:00 | AAPL | Stock | 29.4375 | 29.4475 | 29.4375 | 29.4475 | 10520.0 |
| 2016-10-17 08:55:00 | AAPL | Stock | 29.445 | 29.455 | 29.44 | 29.44 | 10000.0 |
| 2016-10-17 09:00:00 | AAPL | Stock | 29.4375 | 29.4625 | 29.4375 | 29.4625 | 11832.0 |
| 2016-10-17 09:05:00 | AAPL | Stock | 29.4525 | 29.4675 | 29.4525 | 29.4675 | 11200.0 |
| 2016-10-17 09:10:00 | AAPL | Stock | 29.465 | 29.4875 | 29.455 | 29.475 | 46152.0 |
| 2016-10-17 09:15:00 | AAPL | Stock | 29.48 | 29.48 | 29.455 | 29.47 | 52700.0 |
| 2016-10-17 09:20:00 | AAPL | Stock | 29.47 | 29.47 | 29.4625 | 29.4675 | 21304.0 |
| 2016-10-17 09:25:00 | AAPL | Stock | 29.4625 | 29.4625 | 29.3325 | 29.3325 | 250528.0 |
| 2016-10-17 09:30:00 | AAPL | Stock | 29.335 | 29.46 | 29.25 | 29.2775 | 5839272.0 |
| 2016-10-17 09:35:00 | AAPL | Stock | 29.28 | 29.3 | 29.2125 | 29.2375 | 3287112.0 |
| 2016-10-17 09:40:00 | AAPL | Stock | 29.235 | 29.325 | 29.2325 | 29.275 | 2853668.0 |
| 2016-10-17 09:45:00 | AAPL | Stock | 29.275 | 29.31 | 29.255 | 29.29 | 1641908.0 |
| 2016-10-17 09:50:00 | AAPL | Stock | 29.29 | 29.325 | 29.23 | 29.2375 | 2226796.0 |
| 2016-10-17 09:55:00 | AAPL | Stock | 29.235 | 29.26 | 29.225 | 29.2288 | 2070080.0 |
> showing 50 of 339,398 rows — these rows as CSV