PREVIEW / stock_5min / 2016-04-22
file: by_date/stock_5min/2016/2016-04-22.parquet size: 5.3 MB rows: 350,060 symbols: 3,323
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-04-22 04:50:00 | AAPL | Stock | 26.32 | 26.32 | 26.32 | 26.32 | 400.0 |
| 2016-04-22 05:20:00 | AAPL | Stock | 26.3075 | 26.3075 | 26.3075 | 26.3075 | 416.0 |
| 2016-04-22 05:35:00 | AAPL | Stock | 26.3625 | 26.3625 | 26.3625 | 26.3625 | 400.0 |
| 2016-04-22 06:05:00 | AAPL | Stock | 26.3 | 26.3 | 26.3 | 26.3 | 1100.0 |
| 2016-04-22 06:10:00 | AAPL | Stock | 26.325 | 26.325 | 26.3 | 26.3 | 1444.0 |
| 2016-04-22 06:25:00 | AAPL | Stock | 26.315 | 26.325 | 26.3 | 26.3 | 36992.0 |
| 2016-04-22 06:30:00 | AAPL | Stock | 26.3 | 26.3 | 26.3 | 26.3 | 34000.0 |
| 2016-04-22 06:35:00 | AAPL | Stock | 26.3 | 26.3 | 26.3 | 26.3 | 8000.0 |
| 2016-04-22 06:40:00 | AAPL | Stock | 26.3125 | 26.3125 | 26.3125 | 26.3125 | 400.0 |
| 2016-04-22 06:50:00 | AAPL | Stock | 26.3175 | 26.3175 | 26.3175 | 26.3175 | 916.0 |
| 2016-04-22 07:00:00 | AAPL | Stock | 26.3375 | 26.3375 | 26.3125 | 26.325 | 13700.0 |
| 2016-04-22 07:10:00 | AAPL | Stock | 26.3375 | 26.355 | 26.3325 | 26.355 | 15200.0 |
| 2016-04-22 07:15:00 | AAPL | Stock | 26.355 | 26.3625 | 26.355 | 26.3625 | 1572.0 |
| 2016-04-22 07:20:00 | AAPL | Stock | 26.365 | 26.3725 | 26.365 | 26.3725 | 4000.0 |
| 2016-04-22 07:25:00 | AAPL | Stock | 26.355 | 26.355 | 26.355 | 26.355 | 2480.0 |
| 2016-04-22 07:35:00 | AAPL | Stock | 26.35 | 26.35 | 26.335 | 26.3375 | 11964.0 |
| 2016-04-22 07:40:00 | AAPL | Stock | 26.3375 | 26.3375 | 26.3175 | 26.3375 | 7284.0 |
| 2016-04-22 07:45:00 | AAPL | Stock | 26.3375 | 26.3375 | 26.3375 | 26.3375 | 4608.0 |
| 2016-04-22 07:50:00 | AAPL | Stock | 26.3375 | 26.3375 | 26.335 | 26.335 | 1392.0 |
| 2016-04-22 07:55:00 | AAPL | Stock | 26.3175 | 26.3175 | 26.3125 | 26.315 | 11228.0 |
| 2016-04-22 08:00:00 | AAPL | Stock | 26.3275 | 26.3725 | 26.315 | 26.3375 | 72188.0 |
| 2016-04-22 08:05:00 | AAPL | Stock | 26.3325 | 26.3425 | 26.32 | 26.3425 | 14080.0 |
| 2016-04-22 08:10:00 | AAPL | Stock | 26.33 | 26.35 | 26.33 | 26.335 | 11340.0 |
| 2016-04-22 08:15:00 | AAPL | Stock | 26.3425 | 26.3425 | 26.3125 | 26.3125 | 23620.0 |
| 2016-04-22 08:25:00 | AAPL | Stock | 26.32 | 26.335 | 26.315 | 26.33 | 10692.0 |
| 2016-04-22 08:30:00 | AAPL | Stock | 26.3425 | 26.3425 | 26.335 | 26.3425 | 10460.0 |
| 2016-04-22 08:35:00 | AAPL | Stock | 26.3475 | 26.3625 | 26.3475 | 26.35 | 17480.0 |
| 2016-04-22 08:40:00 | AAPL | Stock | 26.3475 | 26.355 | 26.3475 | 26.35 | 20620.0 |
| 2016-04-22 08:45:00 | AAPL | Stock | 26.36 | 26.36 | 26.34 | 26.35 | 19892.0 |
| 2016-04-22 08:50:00 | AAPL | Stock | 26.36 | 26.36 | 26.3475 | 26.3475 | 9380.0 |
| 2016-04-22 08:55:00 | AAPL | Stock | 26.3475 | 26.355 | 26.34 | 26.34 | 9948.0 |
| 2016-04-22 09:00:00 | AAPL | Stock | 26.345 | 26.3475 | 26.3275 | 26.34 | 31804.0 |
| 2016-04-22 09:05:00 | AAPL | Stock | 26.335 | 26.3475 | 26.32 | 26.3275 | 48624.0 |
| 2016-04-22 09:10:00 | AAPL | Stock | 26.315 | 26.3275 | 26.3125 | 26.3175 | 39152.0 |
| 2016-04-22 09:15:00 | AAPL | Stock | 26.3175 | 26.3375 | 26.3175 | 26.3375 | 15452.0 |
| 2016-04-22 09:20:00 | AAPL | Stock | 26.3375 | 26.355 | 26.3375 | 26.35 | 21212.0 |
| 2016-04-22 09:25:00 | AAPL | Stock | 26.3525 | 26.375 | 26.255 | 26.255 | 177576.0 |
| 2016-04-22 09:30:00 | AAPL | Stock | 26.255 | 26.485 | 26.25 | 26.485 | 5972312.0 |
| 2016-04-22 09:35:00 | AAPL | Stock | 26.4775 | 26.5 | 26.415 | 26.4425 | 2594196.0 |
| 2016-04-22 09:40:00 | AAPL | Stock | 26.4425 | 26.535 | 26.44 | 26.5225 | 2689272.0 |
| 2016-04-22 09:45:00 | AAPL | Stock | 26.5185 | 26.525 | 26.48 | 26.5225 | 1908984.0 |
| 2016-04-22 09:50:00 | AAPL | Stock | 26.5225 | 26.5225 | 26.4275 | 26.4325 | 2116728.0 |
| 2016-04-22 09:55:00 | AAPL | Stock | 26.4325 | 26.6025 | 26.4325 | 26.6 | 3047384.0 |
| 2016-04-22 10:00:00 | AAPL | Stock | 26.6025 | 26.62 | 26.543 | 26.555 | 2442204.0 |
| 2016-04-22 10:05:00 | AAPL | Stock | 26.5562 | 26.5712 | 26.5 | 26.5012 | 1510212.0 |
| 2016-04-22 10:10:00 | AAPL | Stock | 26.5022 | 26.51 | 26.4325 | 26.44 | 1637808.0 |
| 2016-04-22 10:15:00 | AAPL | Stock | 26.4425 | 26.4625 | 26.35 | 26.3718 | 2078704.0 |
| 2016-04-22 10:20:00 | AAPL | Stock | 26.3712 | 26.4 | 26.355 | 26.3725 | 2146604.0 |
| 2016-04-22 10:25:00 | AAPL | Stock | 26.375 | 26.38 | 26.3525 | 26.3642 | 1528920.0 |
| 2016-04-22 10:30:00 | AAPL | Stock | 26.3625 | 26.3875 | 26.2875 | 26.2925 | 2195028.0 |
> showing 50 of 350,060 rows — these rows as CSV