PREVIEW / stock_5min / 2016-08-04
file: by_date/stock_5min/2016/2016-08-04.parquet size: 5.3 MB rows: 348,086 symbols: 3,250
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-08-04 04:05:00 | AAPL | Stock | 26.355 | 26.355 | 26.355 | 26.355 | 4000.0 |
| 2016-08-04 04:30:00 | AAPL | Stock | 26.36 | 26.36 | 26.36 | 26.36 | 400.0 |
| 2016-08-04 04:35:00 | AAPL | Stock | 26.3925 | 26.395 | 26.3925 | 26.395 | 8000.0 |
| 2016-08-04 04:50:00 | AAPL | Stock | 26.3725 | 26.375 | 26.3725 | 26.375 | 2400.0 |
| 2016-08-04 04:55:00 | AAPL | Stock | 26.375 | 26.375 | 26.375 | 26.375 | 4000.0 |
| 2016-08-04 05:05:00 | AAPL | Stock | 26.3725 | 26.3725 | 26.3425 | 26.3425 | 8400.0 |
| 2016-08-04 05:10:00 | AAPL | Stock | 26.345 | 26.345 | 26.345 | 26.345 | 800.0 |
| 2016-08-04 05:45:00 | AAPL | Stock | 26.3275 | 26.3275 | 26.325 | 26.325 | 800.0 |
| 2016-08-04 05:55:00 | AAPL | Stock | 26.3375 | 26.3375 | 26.3375 | 26.3375 | 5600.0 |
| 2016-08-04 06:00:00 | AAPL | Stock | 26.3325 | 26.3325 | 26.3325 | 26.3325 | 2000.0 |
| 2016-08-04 06:05:00 | AAPL | Stock | 26.3375 | 26.3375 | 26.3375 | 26.3375 | 8000.0 |
| 2016-08-04 06:10:00 | AAPL | Stock | 26.3475 | 26.3625 | 26.3475 | 26.36 | 22080.0 |
| 2016-08-04 06:25:00 | AAPL | Stock | 26.3625 | 26.375 | 26.3625 | 26.3725 | 10000.0 |
| 2016-08-04 06:45:00 | AAPL | Stock | 26.3725 | 26.3725 | 26.3725 | 26.3725 | 400.0 |
| 2016-08-04 06:55:00 | AAPL | Stock | 26.36 | 26.36 | 26.36 | 26.36 | 800.0 |
| 2016-08-04 07:00:00 | AAPL | Stock | 26.36 | 26.3725 | 26.3575 | 26.3575 | 18800.0 |
| 2016-08-04 07:05:00 | AAPL | Stock | 26.36 | 26.36 | 26.35 | 26.35 | 16872.0 |
| 2016-08-04 07:10:00 | AAPL | Stock | 26.35 | 26.35 | 26.35 | 26.35 | 4400.0 |
| 2016-08-04 07:15:00 | AAPL | Stock | 26.35 | 26.3725 | 26.35 | 26.3725 | 19096.0 |
| 2016-08-04 07:20:00 | AAPL | Stock | 26.3675 | 26.3675 | 26.3675 | 26.3675 | 400.0 |
| 2016-08-04 07:25:00 | AAPL | Stock | 26.3675 | 26.375 | 26.3675 | 26.375 | 26708.0 |
| 2016-08-04 07:35:00 | AAPL | Stock | 26.3625 | 26.3725 | 26.3575 | 26.3725 | 6964.0 |
| 2016-08-04 07:40:00 | AAPL | Stock | 26.3625 | 26.3725 | 26.3625 | 26.3725 | 2200.0 |
| 2016-08-04 07:45:00 | AAPL | Stock | 26.375 | 26.3875 | 26.3725 | 26.38 | 10800.0 |
| 2016-08-04 07:50:00 | AAPL | Stock | 26.395 | 26.4 | 26.395 | 26.4 | 20800.0 |
| 2016-08-04 07:55:00 | AAPL | Stock | 26.4125 | 26.4125 | 26.38 | 26.38 | 21960.0 |
| 2016-08-04 08:00:00 | AAPL | Stock | 26.3825 | 26.4125 | 26.3325 | 26.3825 | 115372.0 |
| 2016-08-04 08:05:00 | AAPL | Stock | 26.3875 | 26.4 | 26.3875 | 26.3975 | 24000.0 |
| 2016-08-04 08:10:00 | AAPL | Stock | 26.39 | 26.4 | 26.385 | 26.3875 | 87536.0 |
| 2016-08-04 08:15:00 | AAPL | Stock | 26.38 | 26.385 | 26.375 | 26.385 | 41536.0 |
| 2016-08-04 08:20:00 | AAPL | Stock | 26.3875 | 26.3875 | 26.375 | 26.375 | 18924.0 |
| 2016-08-04 08:25:00 | AAPL | Stock | 26.375 | 26.385 | 26.375 | 26.375 | 16968.0 |
| 2016-08-04 08:30:00 | AAPL | Stock | 26.3725 | 26.3825 | 26.3725 | 26.3825 | 28000.0 |
| 2016-08-04 08:35:00 | AAPL | Stock | 26.385 | 26.4125 | 26.385 | 26.4125 | 32960.0 |
| 2016-08-04 08:40:00 | AAPL | Stock | 26.4125 | 26.4225 | 26.4 | 26.4075 | 64800.0 |
| 2016-08-04 08:45:00 | AAPL | Stock | 26.4025 | 26.4075 | 26.4025 | 26.405 | 8400.0 |
| 2016-08-04 08:50:00 | AAPL | Stock | 26.405 | 26.405 | 26.3875 | 26.3875 | 44904.0 |
| 2016-08-04 08:55:00 | AAPL | Stock | 26.3875 | 26.3925 | 26.37 | 26.385 | 83692.0 |
| 2016-08-04 09:00:00 | AAPL | Stock | 26.385 | 26.385 | 26.37 | 26.385 | 23976.0 |
| 2016-08-04 09:05:00 | AAPL | Stock | 26.3925 | 26.3925 | 26.38 | 26.39 | 7800.0 |
| 2016-08-04 09:10:00 | AAPL | Stock | 26.3925 | 26.3925 | 26.3725 | 26.3725 | 49484.0 |
| 2016-08-04 09:15:00 | AAPL | Stock | 26.3825 | 26.39 | 26.375 | 26.3875 | 37816.0 |
| 2016-08-04 09:20:00 | AAPL | Stock | 26.385 | 26.4075 | 26.385 | 26.395 | 73252.0 |
| 2016-08-04 09:25:00 | AAPL | Stock | 26.4075 | 26.4075 | 26.38 | 26.385 | 61944.0 |
| 2016-08-04 09:30:00 | AAPL | Stock | 26.3925 | 26.46 | 26.34 | 26.3775 | 6212076.0 |
| 2016-08-04 09:35:00 | AAPL | Stock | 26.3825 | 26.4475 | 26.3275 | 26.44 | 3850736.0 |
| 2016-08-04 09:40:00 | AAPL | Stock | 26.4422 | 26.4975 | 26.42 | 26.495 | 4035016.0 |
| 2016-08-04 09:45:00 | AAPL | Stock | 26.495 | 26.5 | 26.4625 | 26.4775 | 2253412.0 |
| 2016-08-04 09:50:00 | AAPL | Stock | 26.48 | 26.5 | 26.4625 | 26.4675 | 1917796.0 |
| 2016-08-04 09:55:00 | AAPL | Stock | 26.465 | 26.475 | 26.375 | 26.38 | 2608716.0 |
> showing 50 of 348,086 rows — these rows as CSV