PREVIEW / stock_5min / 2018-08-31
file: by_date/stock_5min/2018/2018-08-31.parquet size: 5.4 MB rows: 344,572 symbols: 2,788
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 |
|---|---|---|---|---|---|---|---|
| 2018-08-31 04:00:00 | AAPL | Stock | 56.36 | 56.36 | 56.36 | 56.36 | 2000.0 |
| 2018-08-31 04:05:00 | AAPL | Stock | 56.37 | 56.37 | 56.37 | 56.37 | 5040.0 |
| 2018-08-31 04:10:00 | AAPL | Stock | 56.375 | 56.375 | 56.375 | 56.375 | 4336.0 |
| 2018-08-31 04:15:00 | AAPL | Stock | 56.375 | 56.375 | 56.325 | 56.325 | 8312.0 |
| 2018-08-31 04:20:00 | AAPL | Stock | 56.375 | 56.375 | 56.375 | 56.375 | 400.0 |
| 2018-08-31 04:30:00 | AAPL | Stock | 56.3275 | 56.375 | 56.325 | 56.375 | 5388.0 |
| 2018-08-31 04:40:00 | AAPL | Stock | 56.33 | 56.33 | 56.33 | 56.33 | 1372.0 |
| 2018-08-31 05:10:00 | AAPL | Stock | 56.4375 | 56.4375 | 56.4125 | 56.4125 | 2400.0 |
| 2018-08-31 05:15:00 | AAPL | Stock | 56.4375 | 56.4525 | 56.4375 | 56.4525 | 4148.0 |
| 2018-08-31 05:25:00 | AAPL | Stock | 56.45 | 56.45 | 56.45 | 56.45 | 4000.0 |
| 2018-08-31 05:30:00 | AAPL | Stock | 56.4425 | 56.4725 | 56.425 | 56.425 | 6724.0 |
| 2018-08-31 05:40:00 | AAPL | Stock | 56.35 | 56.35 | 56.3375 | 56.35 | 9276.0 |
| 2018-08-31 05:45:00 | AAPL | Stock | 56.3375 | 56.3375 | 56.3375 | 56.3375 | 400.0 |
| 2018-08-31 05:50:00 | AAPL | Stock | 56.375 | 56.375 | 56.375 | 56.375 | 800.0 |
| 2018-08-31 05:55:00 | AAPL | Stock | 56.3375 | 56.3375 | 56.33 | 56.33 | 4484.0 |
| 2018-08-31 06:00:00 | AAPL | Stock | 56.305 | 56.305 | 56.305 | 56.305 | 1600.0 |
| 2018-08-31 06:15:00 | AAPL | Stock | 56.37 | 56.37 | 56.37 | 56.37 | 1200.0 |
| 2018-08-31 06:30:00 | AAPL | Stock | 56.3925 | 56.3925 | 56.37 | 56.37 | 6400.0 |
| 2018-08-31 06:45:00 | AAPL | Stock | 56.3675 | 56.3675 | 56.3675 | 56.3675 | 720.0 |
| 2018-08-31 06:50:00 | AAPL | Stock | 56.37 | 56.4 | 56.37 | 56.395 | 6928.0 |
| 2018-08-31 07:00:00 | AAPL | Stock | 56.4 | 56.4375 | 56.3825 | 56.425 | 31444.0 |
| 2018-08-31 07:05:00 | AAPL | Stock | 56.4475 | 56.4475 | 56.415 | 56.4475 | 5424.0 |
| 2018-08-31 07:10:00 | AAPL | Stock | 56.45 | 56.4575 | 56.45 | 56.4575 | 3000.0 |
| 2018-08-31 07:15:00 | AAPL | Stock | 56.45 | 56.45 | 56.375 | 56.4225 | 58000.0 |
| 2018-08-31 07:20:00 | AAPL | Stock | 56.415 | 56.435 | 56.3875 | 56.4025 | 29720.0 |
| 2018-08-31 07:25:00 | AAPL | Stock | 56.3975 | 56.4175 | 56.3975 | 56.4 | 16712.0 |
| 2018-08-31 07:30:00 | AAPL | Stock | 56.395 | 56.4075 | 56.3775 | 56.3775 | 16128.0 |
| 2018-08-31 07:35:00 | AAPL | Stock | 56.3775 | 56.3875 | 56.37 | 56.3875 | 8000.0 |
| 2018-08-31 07:40:00 | AAPL | Stock | 56.385 | 56.4225 | 56.3825 | 56.4225 | 21360.0 |
| 2018-08-31 07:45:00 | AAPL | Stock | 56.425 | 56.4425 | 56.4175 | 56.4375 | 16884.0 |
| 2018-08-31 07:50:00 | AAPL | Stock | 56.42 | 56.45 | 56.37 | 56.4425 | 44308.0 |
| 2018-08-31 07:55:00 | AAPL | Stock | 56.4125 | 56.4375 | 56.4125 | 56.4325 | 36076.0 |
| 2018-08-31 08:00:00 | AAPL | Stock | 56.41 | 56.5 | 56.3625 | 56.5 | 178336.0 |
| 2018-08-31 08:05:00 | AAPL | Stock | 56.4825 | 56.5125 | 56.4575 | 56.5125 | 112228.0 |
| 2018-08-31 08:10:00 | AAPL | Stock | 56.5125 | 56.585 | 56.5 | 56.57 | 262576.0 |
| 2018-08-31 08:15:00 | AAPL | Stock | 56.575 | 56.6 | 56.5375 | 56.5375 | 108804.0 |
| 2018-08-31 08:20:00 | AAPL | Stock | 56.545 | 56.59 | 56.5075 | 56.5325 | 70228.0 |
| 2018-08-31 08:25:00 | AAPL | Stock | 56.5375 | 56.62 | 56.5375 | 56.575 | 64588.0 |
| 2018-08-31 08:30:00 | AAPL | Stock | 56.5725 | 56.5925 | 56.5425 | 56.575 | 44712.0 |
| 2018-08-31 08:35:00 | AAPL | Stock | 56.5725 | 56.5725 | 56.5 | 56.525 | 91860.0 |
| 2018-08-31 08:40:00 | AAPL | Stock | 56.505 | 56.525 | 56.475 | 56.5 | 99480.0 |
| 2018-08-31 08:45:00 | AAPL | Stock | 56.5 | 56.535 | 56.5 | 56.535 | 14500.0 |
| 2018-08-31 08:50:00 | AAPL | Stock | 56.535 | 56.5425 | 56.4975 | 56.5 | 49056.0 |
| 2018-08-31 08:55:00 | AAPL | Stock | 56.4925 | 56.515 | 56.4775 | 56.4775 | 121400.0 |
| 2018-08-31 09:00:00 | AAPL | Stock | 56.48 | 56.49 | 56.4625 | 56.4675 | 62448.0 |
| 2018-08-31 09:05:00 | AAPL | Stock | 56.475 | 56.525 | 56.475 | 56.515 | 53584.0 |
| 2018-08-31 09:10:00 | AAPL | Stock | 56.5025 | 56.5525 | 56.5025 | 56.5375 | 42004.0 |
| 2018-08-31 09:15:00 | AAPL | Stock | 56.5475 | 56.5625 | 56.5375 | 56.5375 | 73460.0 |
| 2018-08-31 09:20:00 | AAPL | Stock | 56.525 | 56.5825 | 56.525 | 56.57 | 74200.0 |
| 2018-08-31 09:25:00 | AAPL | Stock | 56.57 | 56.6875 | 56.5625 | 56.63 | 202364.0 |
> showing 50 of 344,572 rows — these rows as CSV