PREVIEW / stock_5min / 2016-12-02
file: by_date/stock_5min/2016/2016-12-02.parquet size: 5.4 MB rows: 353,832 symbols: 3,150
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-02 04:00:00 | AAPL | Stock | 27.325 | 27.325 | 27.325 | 27.325 | 1200.0 |
| 2016-12-02 04:05:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 564.0 |
| 2016-12-02 04:10:00 | AAPL | Stock | 27.225 | 27.225 | 27.225 | 27.225 | 400.0 |
| 2016-12-02 04:20:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 400.0 |
| 2016-12-02 04:30:00 | AAPL | Stock | 27.225 | 27.225 | 27.225 | 27.225 | 400.0 |
| 2016-12-02 04:35:00 | AAPL | Stock | 27.2375 | 27.2375 | 27.215 | 27.215 | 1836.0 |
| 2016-12-02 04:45:00 | AAPL | Stock | 27.225 | 27.225 | 27.225 | 27.225 | 704.0 |
| 2016-12-02 04:50:00 | AAPL | Stock | 27.225 | 27.225 | 27.225 | 27.225 | 824.0 |
| 2016-12-02 05:05:00 | AAPL | Stock | 27.2 | 27.2 | 27.2 | 27.2 | 400.0 |
| 2016-12-02 05:15:00 | AAPL | Stock | 27.19 | 27.19 | 27.19 | 27.19 | 400.0 |
| 2016-12-02 05:20:00 | AAPL | Stock | 27.19 | 27.19 | 27.19 | 27.19 | 912.0 |
| 2016-12-02 05:45:00 | AAPL | Stock | 27.225 | 27.225 | 27.225 | 27.225 | 3200.0 |
| 2016-12-02 06:05:00 | AAPL | Stock | 27.25 | 27.26 | 27.25 | 27.26 | 1328.0 |
| 2016-12-02 06:55:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 400.0 |
| 2016-12-02 07:00:00 | AAPL | Stock | 27.2675 | 27.2675 | 27.2675 | 27.2675 | 1760.0 |
| 2016-12-02 07:05:00 | AAPL | Stock | 27.295 | 27.305 | 27.275 | 27.305 | 7200.0 |
| 2016-12-02 07:15:00 | AAPL | Stock | 27.305 | 27.305 | 27.305 | 27.305 | 400.0 |
| 2016-12-02 07:25:00 | AAPL | Stock | 27.3175 | 27.32 | 27.2925 | 27.2925 | 4164.0 |
| 2016-12-02 07:30:00 | AAPL | Stock | 27.2925 | 27.2925 | 27.275 | 27.275 | 10944.0 |
| 2016-12-02 07:35:00 | AAPL | Stock | 27.27 | 27.27 | 27.27 | 27.27 | 1456.0 |
| 2016-12-02 07:50:00 | AAPL | Stock | 27.3275 | 27.3275 | 27.3 | 27.3 | 1400.0 |
| 2016-12-02 07:55:00 | AAPL | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 848.0 |
| 2016-12-02 08:00:00 | AAPL | Stock | 27.3025 | 27.3325 | 27.295 | 27.3325 | 15844.0 |
| 2016-12-02 08:05:00 | AAPL | Stock | 27.3275 | 27.3275 | 27.3275 | 27.3275 | 400.0 |
| 2016-12-02 08:10:00 | AAPL | Stock | 27.32 | 27.3325 | 27.32 | 27.3325 | 10400.0 |
| 2016-12-02 08:15:00 | AAPL | Stock | 27.32 | 27.32 | 27.3125 | 27.3125 | 1200.0 |
| 2016-12-02 08:20:00 | AAPL | Stock | 27.3275 | 27.3625 | 27.31 | 27.3375 | 36664.0 |
| 2016-12-02 08:25:00 | AAPL | Stock | 27.3375 | 27.36 | 27.3375 | 27.3375 | 10284.0 |
| 2016-12-02 08:30:00 | AAPL | Stock | 27.355 | 27.385 | 27.34 | 27.34 | 26216.0 |
| 2016-12-02 08:35:00 | AAPL | Stock | 27.345 | 27.3725 | 27.345 | 27.3725 | 7484.0 |
| 2016-12-02 08:40:00 | AAPL | Stock | 27.35 | 27.35 | 27.315 | 27.315 | 11704.0 |
| 2016-12-02 08:45:00 | AAPL | Stock | 27.3375 | 27.3375 | 27.3225 | 27.325 | 6504.0 |
| 2016-12-02 08:50:00 | AAPL | Stock | 27.325 | 27.34 | 27.32 | 27.325 | 15596.0 |
| 2016-12-02 08:55:00 | AAPL | Stock | 27.3375 | 27.3425 | 27.325 | 27.3425 | 4000.0 |
| 2016-12-02 09:00:00 | AAPL | Stock | 27.34 | 27.36 | 27.34 | 27.36 | 7132.0 |
| 2016-12-02 09:10:00 | AAPL | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 6576.0 |
| 2016-12-02 09:15:00 | AAPL | Stock | 27.3425 | 27.3425 | 27.3425 | 27.3425 | 1600.0 |
| 2016-12-02 09:20:00 | AAPL | Stock | 27.36 | 27.3725 | 27.34 | 27.34 | 22828.0 |
| 2016-12-02 09:25:00 | AAPL | Stock | 27.3425 | 27.3525 | 27.2875 | 27.3325 | 182672.0 |
| 2016-12-02 09:30:00 | AAPL | Stock | 27.2925 | 27.4875 | 27.2925 | 27.485 | 6245780.0 |
| 2016-12-02 09:35:00 | AAPL | Stock | 27.4875 | 27.5225 | 27.25 | 27.415 | 3481680.0 |
| 2016-12-02 09:40:00 | AAPL | Stock | 27.425 | 27.455 | 27.405 | 27.4125 | 2250864.0 |
| 2016-12-02 09:45:00 | AAPL | Stock | 27.415 | 27.415 | 27.315 | 27.3375 | 1896164.0 |
| 2016-12-02 09:50:00 | AAPL | Stock | 27.3375 | 27.4175 | 27.3175 | 27.375 | 1662992.0 |
| 2016-12-02 09:55:00 | AAPL | Stock | 27.375 | 27.3975 | 27.3512 | 27.3775 | 1447552.0 |
| 2016-12-02 10:00:00 | AAPL | Stock | 27.3775 | 27.4222 | 27.37 | 27.4035 | 1580868.0 |
| 2016-12-02 10:05:00 | AAPL | Stock | 27.405 | 27.4125 | 27.385 | 27.3925 | 1103620.0 |
| 2016-12-02 10:10:00 | AAPL | Stock | 27.3925 | 27.3925 | 27.2375 | 27.2438 | 2193608.0 |
| 2016-12-02 10:15:00 | AAPL | Stock | 27.2425 | 27.29 | 27.2125 | 27.28 | 2376264.0 |
| 2016-12-02 10:20:00 | AAPL | Stock | 27.28 | 27.3275 | 27.2625 | 27.296 | 1391724.0 |
> showing 50 of 353,832 rows — these rows as CSV