PREVIEW / stock_5min / 2016-12-07
file: by_date/stock_5min/2016/2016-12-07.parquet size: 5.7 MB rows: 369,738 symbols: 3,168
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-12-07 04:25:00 | AAPL | Stock | 27.52 | 27.52 | 27.52 | 27.52 | 400.0 |
| 2016-12-07 04:55:00 | AAPL | Stock | 27.52 | 27.52 | 27.52 | 27.52 | 400.0 |
| 2016-12-07 05:25:00 | AAPL | Stock | 27.525 | 27.525 | 27.525 | 27.525 | 1596.0 |
| 2016-12-07 05:30:00 | AAPL | Stock | 27.56 | 27.5625 | 27.56 | 27.5625 | 900.0 |
| 2016-12-07 06:00:00 | AAPL | Stock | 27.525 | 27.525 | 27.525 | 27.525 | 3944.0 |
| 2016-12-07 06:15:00 | AAPL | Stock | 27.5325 | 27.5325 | 27.525 | 27.525 | 1048.0 |
| 2016-12-07 07:05:00 | AAPL | Stock | 27.5225 | 27.5225 | 27.5225 | 27.5225 | 1376.0 |
| 2016-12-07 07:10:00 | AAPL | Stock | 27.485 | 27.5 | 27.485 | 27.5 | 4380.0 |
| 2016-12-07 07:20:00 | AAPL | Stock | 27.4975 | 27.5 | 27.4975 | 27.4975 | 2120.0 |
| 2016-12-07 07:30:00 | AAPL | Stock | 27.51 | 27.51 | 27.41 | 27.41 | 14260.0 |
| 2016-12-07 07:35:00 | AAPL | Stock | 27.4275 | 27.4275 | 27.35 | 27.35 | 36304.0 |
| 2016-12-07 07:40:00 | AAPL | Stock | 27.3525 | 27.3875 | 27.35 | 27.3875 | 25860.0 |
| 2016-12-07 07:45:00 | AAPL | Stock | 27.3625 | 27.4025 | 27.3625 | 27.4025 | 5896.0 |
| 2016-12-07 07:50:00 | AAPL | Stock | 27.4 | 27.4 | 27.35 | 27.35 | 16100.0 |
| 2016-12-07 07:55:00 | AAPL | Stock | 27.35 | 27.35 | 27.2625 | 27.2625 | 43180.0 |
| 2016-12-07 08:00:00 | AAPL | Stock | 27.31 | 27.515 | 27.2725 | 27.2725 | 42852.0 |
| 2016-12-07 08:05:00 | AAPL | Stock | 27.2675 | 27.2875 | 27.25 | 27.25 | 50376.0 |
| 2016-12-07 08:10:00 | AAPL | Stock | 27.265 | 27.2675 | 27.2075 | 27.2675 | 36908.0 |
| 2016-12-07 08:15:00 | AAPL | Stock | 27.2625 | 27.35 | 27.25 | 27.3125 | 63264.0 |
| 2016-12-07 08:20:00 | AAPL | Stock | 27.345 | 27.345 | 27.3 | 27.3125 | 19020.0 |
| 2016-12-07 08:25:00 | AAPL | Stock | 27.3125 | 27.3625 | 27.3125 | 27.3625 | 34544.0 |
| 2016-12-07 08:30:00 | AAPL | Stock | 27.325 | 27.3625 | 27.325 | 27.3625 | 53284.0 |
| 2016-12-07 08:35:00 | AAPL | Stock | 27.345 | 27.345 | 27.3125 | 27.3125 | 12476.0 |
| 2016-12-07 08:40:00 | AAPL | Stock | 27.2975 | 27.325 | 27.2775 | 27.325 | 16000.0 |
| 2016-12-07 08:45:00 | AAPL | Stock | 27.325 | 27.325 | 27.3225 | 27.325 | 4800.0 |
| 2016-12-07 08:50:00 | AAPL | Stock | 27.315 | 27.325 | 27.3125 | 27.3225 | 17012.0 |
| 2016-12-07 08:55:00 | AAPL | Stock | 27.32 | 27.32 | 27.275 | 27.28 | 10800.0 |
| 2016-12-07 09:00:00 | AAPL | Stock | 27.2875 | 27.2875 | 27.2825 | 27.2875 | 33444.0 |
| 2016-12-07 09:05:00 | AAPL | Stock | 27.29 | 27.3 | 27.29 | 27.3 | 1200.0 |
| 2016-12-07 09:10:00 | AAPL | Stock | 27.3 | 27.3275 | 27.3 | 27.3275 | 23244.0 |
| 2016-12-07 09:15:00 | AAPL | Stock | 27.3575 | 27.3575 | 27.2875 | 27.325 | 51260.0 |
| 2016-12-07 09:20:00 | AAPL | Stock | 27.325 | 27.3475 | 27.29 | 27.3475 | 37800.0 |
| 2016-12-07 09:25:00 | AAPL | Stock | 27.3475 | 27.3475 | 27.2875 | 27.3 | 32392.0 |
| 2016-12-07 09:30:00 | AAPL | Stock | 27.3125 | 27.45 | 27.29 | 27.4212 | 3521676.0 |
| 2016-12-07 09:35:00 | AAPL | Stock | 27.42 | 27.43 | 27.3675 | 27.3925 | 1921416.0 |
| 2016-12-07 09:40:00 | AAPL | Stock | 27.3925 | 27.4125 | 27.3375 | 27.4125 | 1781928.0 |
| 2016-12-07 09:45:00 | AAPL | Stock | 27.4112 | 27.4725 | 27.385 | 27.44 | 1565372.0 |
| 2016-12-07 09:50:00 | AAPL | Stock | 27.4412 | 27.4412 | 27.35 | 27.38 | 1239876.0 |
| 2016-12-07 09:55:00 | AAPL | Stock | 27.3792 | 27.3975 | 27.3525 | 27.3625 | 1127880.0 |
| 2016-12-07 10:00:00 | AAPL | Stock | 27.36 | 27.3975 | 27.345 | 27.385 | 1613520.0 |
| 2016-12-07 10:05:00 | AAPL | Stock | 27.385 | 27.4345 | 27.3775 | 27.4345 | 1344252.0 |
| 2016-12-07 10:10:00 | AAPL | Stock | 27.4325 | 27.45 | 27.42 | 27.4262 | 1112232.0 |
| 2016-12-07 10:15:00 | AAPL | Stock | 27.4275 | 27.4575 | 27.425 | 27.4382 | 1178812.0 |
| 2016-12-07 10:20:00 | AAPL | Stock | 27.44 | 27.4738 | 27.435 | 27.435 | 937856.0 |
| 2016-12-07 10:25:00 | AAPL | Stock | 27.4425 | 27.4442 | 27.405 | 27.42 | 1069500.0 |
| 2016-12-07 10:30:00 | AAPL | Stock | 27.4225 | 27.4342 | 27.395 | 27.4 | 1010564.0 |
| 2016-12-07 10:35:00 | AAPL | Stock | 27.4012 | 27.4075 | 27.3575 | 27.4 | 1795684.0 |
| 2016-12-07 10:40:00 | AAPL | Stock | 27.4025 | 27.47 | 27.38 | 27.4675 | 2412376.0 |
| 2016-12-07 10:45:00 | AAPL | Stock | 27.4688 | 27.4975 | 27.4475 | 27.49 | 1395144.0 |
| 2016-12-07 10:50:00 | AAPL | Stock | 27.4925 | 27.5225 | 27.47 | 27.4775 | 1518912.0 |
> showing 50 of 369,738 rows — these rows as CSV