PREVIEW / stock_5min / 2017-04-12
file: by_date/stock_5min/2017/2017-04-12.parquet size: 5.3 MB rows: 348,286 symbols: 3,032
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-12 04:00:00 | AAPL | Stock | 35.4825 | 35.5625 | 35.4825 | 35.5625 | 13452.0 |
| 2017-04-12 04:05:00 | AAPL | Stock | 35.5625 | 35.5625 | 35.5625 | 35.5625 | 1600.0 |
| 2017-04-12 04:35:00 | AAPL | Stock | 35.5275 | 35.5275 | 35.5275 | 35.5275 | 596.0 |
| 2017-04-12 04:40:00 | AAPL | Stock | 35.525 | 35.525 | 35.525 | 35.525 | 996.0 |
| 2017-04-12 04:45:00 | AAPL | Stock | 35.5 | 35.5 | 35.4625 | 35.4625 | 2560.0 |
| 2017-04-12 04:50:00 | AAPL | Stock | 35.455 | 35.455 | 35.425 | 35.425 | 6696.0 |
| 2017-04-12 04:55:00 | AAPL | Stock | 35.425 | 35.425 | 35.425 | 35.425 | 1812.0 |
| 2017-04-12 06:05:00 | AAPL | Stock | 35.4075 | 35.4075 | 35.4075 | 35.4075 | 400.0 |
| 2017-04-12 06:20:00 | AAPL | Stock | 35.385 | 35.385 | 35.3775 | 35.3775 | 1956.0 |
| 2017-04-12 06:25:00 | AAPL | Stock | 35.38 | 35.38 | 35.38 | 35.38 | 1200.0 |
| 2017-04-12 06:40:00 | AAPL | Stock | 35.405 | 35.405 | 35.405 | 35.405 | 1144.0 |
| 2017-04-12 06:50:00 | AAPL | Stock | 35.385 | 35.385 | 35.385 | 35.385 | 800.0 |
| 2017-04-12 07:00:00 | AAPL | Stock | 35.3975 | 35.3975 | 35.3975 | 35.3975 | 400.0 |
| 2017-04-12 07:05:00 | AAPL | Stock | 35.385 | 35.385 | 35.385 | 35.385 | 960.0 |
| 2017-04-12 07:10:00 | AAPL | Stock | 35.3975 | 35.3975 | 35.3975 | 35.3975 | 400.0 |
| 2017-04-12 07:15:00 | AAPL | Stock | 35.385 | 35.385 | 35.375 | 35.375 | 4800.0 |
| 2017-04-12 07:20:00 | AAPL | Stock | 35.375 | 35.375 | 35.375 | 35.375 | 800.0 |
| 2017-04-12 07:30:00 | AAPL | Stock | 35.3525 | 35.3525 | 35.3525 | 35.3525 | 800.0 |
| 2017-04-12 07:35:00 | AAPL | Stock | 35.35 | 35.35 | 35.35 | 35.35 | 400.0 |
| 2017-04-12 07:45:00 | AAPL | Stock | 35.35 | 35.35 | 35.35 | 35.35 | 3200.0 |
| 2017-04-12 07:50:00 | AAPL | Stock | 35.35 | 35.35 | 35.35 | 35.35 | 3704.0 |
| 2017-04-12 08:00:00 | AAPL | Stock | 35.35 | 35.385 | 35.35 | 35.37 | 13440.0 |
| 2017-04-12 08:05:00 | AAPL | Stock | 35.3675 | 35.3725 | 35.3675 | 35.37 | 6904.0 |
| 2017-04-12 08:10:00 | AAPL | Stock | 35.365 | 35.365 | 35.3525 | 35.3525 | 1600.0 |
| 2017-04-12 08:15:00 | AAPL | Stock | 35.3525 | 35.3675 | 35.3525 | 35.3675 | 3360.0 |
| 2017-04-12 08:20:00 | AAPL | Stock | 35.3525 | 35.3525 | 35.3525 | 35.3525 | 800.0 |
| 2017-04-12 08:25:00 | AAPL | Stock | 35.35 | 35.3675 | 35.35 | 35.3675 | 9000.0 |
| 2017-04-12 08:35:00 | AAPL | Stock | 35.3725 | 35.3725 | 35.3725 | 35.3725 | 420.0 |
| 2017-04-12 08:40:00 | AAPL | Stock | 35.3625 | 35.3625 | 35.3625 | 35.3625 | 1600.0 |
| 2017-04-12 08:50:00 | AAPL | Stock | 35.3625 | 35.3625 | 35.3625 | 35.3625 | 2400.0 |
| 2017-04-12 08:55:00 | AAPL | Stock | 35.37 | 35.37 | 35.3525 | 35.3675 | 6716.0 |
| 2017-04-12 09:00:00 | AAPL | Stock | 35.3625 | 35.365 | 35.3625 | 35.3625 | 1600.0 |
| 2017-04-12 09:05:00 | AAPL | Stock | 35.37 | 35.39 | 35.37 | 35.3825 | 13764.0 |
| 2017-04-12 09:10:00 | AAPL | Stock | 35.3675 | 35.375 | 35.3675 | 35.3675 | 11920.0 |
| 2017-04-12 09:15:00 | AAPL | Stock | 35.3675 | 35.39 | 35.3675 | 35.39 | 1600.0 |
| 2017-04-12 09:20:00 | AAPL | Stock | 35.39 | 35.415 | 35.375 | 35.4025 | 4576.0 |
| 2017-04-12 09:25:00 | AAPL | Stock | 35.3875 | 35.3925 | 35.3875 | 35.3925 | 14652.0 |
| 2017-04-12 09:30:00 | AAPL | Stock | 35.4 | 35.495 | 35.3375 | 35.4125 | 4177372.0 |
| 2017-04-12 09:35:00 | AAPL | Stock | 35.41 | 35.51 | 35.38 | 35.4725 | 2082952.0 |
| 2017-04-12 09:40:00 | AAPL | Stock | 35.47 | 35.5375 | 35.455 | 35.465 | 1704524.0 |
| 2017-04-12 09:45:00 | AAPL | Stock | 35.4675 | 35.5218 | 35.4625 | 35.475 | 1157588.0 |
| 2017-04-12 09:50:00 | AAPL | Stock | 35.4775 | 35.49 | 35.44 | 35.45 | 1121960.0 |
| 2017-04-12 09:55:00 | AAPL | Stock | 35.45 | 35.45 | 35.3775 | 35.4452 | 1365204.0 |
| 2017-04-12 10:00:00 | AAPL | Stock | 35.45 | 35.48 | 35.4188 | 35.435 | 1205764.0 |
| 2017-04-12 10:05:00 | AAPL | Stock | 35.435 | 35.45 | 35.4025 | 35.4175 | 862292.0 |
| 2017-04-12 10:10:00 | AAPL | Stock | 35.42 | 35.42 | 35.355 | 35.355 | 1128980.0 |
| 2017-04-12 10:15:00 | AAPL | Stock | 35.355 | 35.4475 | 35.35 | 35.44 | 1226636.0 |
| 2017-04-12 10:20:00 | AAPL | Stock | 35.4415 | 35.45 | 35.4075 | 35.4323 | 1045568.0 |
| 2017-04-12 10:25:00 | AAPL | Stock | 35.43 | 35.4325 | 35.375 | 35.39 | 659792.0 |
| 2017-04-12 10:30:00 | AAPL | Stock | 35.3925 | 35.425 | 35.36 | 35.3725 | 910552.0 |
> showing 50 of 348,286 rows — these rows as CSV