PREVIEW / stock_5min / 2017-06-02
file: by_date/stock_5min/2017/2017-06-02.parquet size: 5.4 MB rows: 355,763 symbols: 3,035
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-06-02 04:25:00 | AAPL | Stock | 38.41 | 38.41 | 38.41 | 38.41 | 2000.0 |
| 2017-06-02 05:50:00 | AAPL | Stock | 38.4625 | 38.4625 | 38.4625 | 38.4625 | 3828.0 |
| 2017-06-02 06:05:00 | AAPL | Stock | 38.4575 | 38.4575 | 38.4575 | 38.4575 | 4000.0 |
| 2017-06-02 06:10:00 | AAPL | Stock | 38.425 | 38.425 | 38.425 | 38.425 | 5656.0 |
| 2017-06-02 06:15:00 | AAPL | Stock | 38.46 | 38.4725 | 38.46 | 38.4725 | 1272.0 |
| 2017-06-02 06:25:00 | AAPL | Stock | 38.4275 | 38.4275 | 38.4275 | 38.4275 | 400.0 |
| 2017-06-02 06:40:00 | AAPL | Stock | 38.445 | 38.445 | 38.4425 | 38.4425 | 2400.0 |
| 2017-06-02 06:55:00 | AAPL | Stock | 38.4425 | 38.4425 | 38.4425 | 38.4425 | 400.0 |
| 2017-06-02 07:00:00 | AAPL | Stock | 38.435 | 38.45 | 38.435 | 38.4425 | 6972.0 |
| 2017-06-02 07:05:00 | AAPL | Stock | 38.4375 | 38.4375 | 38.4375 | 38.4375 | 6892.0 |
| 2017-06-02 07:10:00 | AAPL | Stock | 38.4325 | 38.4325 | 38.4325 | 38.4325 | 1568.0 |
| 2017-06-02 07:20:00 | AAPL | Stock | 38.4375 | 38.4375 | 38.4375 | 38.4375 | 800.0 |
| 2017-06-02 07:30:00 | AAPL | Stock | 38.41 | 38.41 | 38.41 | 38.41 | 3100.0 |
| 2017-06-02 07:35:00 | AAPL | Stock | 38.4 | 38.4 | 38.4 | 38.4 | 400.0 |
| 2017-06-02 07:50:00 | AAPL | Stock | 38.42 | 38.425 | 38.42 | 38.425 | 1996.0 |
| 2017-06-02 07:55:00 | AAPL | Stock | 38.425 | 38.425 | 38.38 | 38.3825 | 2648.0 |
| 2017-06-02 08:00:00 | AAPL | Stock | 38.4375 | 38.45 | 38.3775 | 38.3975 | 62668.0 |
| 2017-06-02 08:05:00 | AAPL | Stock | 38.4 | 38.4 | 38.385 | 38.385 | 6656.0 |
| 2017-06-02 08:10:00 | AAPL | Stock | 38.385 | 38.4 | 38.385 | 38.4 | 4816.0 |
| 2017-06-02 08:15:00 | AAPL | Stock | 38.41 | 38.43 | 38.41 | 38.4225 | 3800.0 |
| 2017-06-02 08:25:00 | AAPL | Stock | 38.415 | 38.4175 | 38.415 | 38.4175 | 800.0 |
| 2017-06-02 08:30:00 | AAPL | Stock | 38.4 | 38.415 | 38.3425 | 38.35 | 64504.0 |
| 2017-06-02 08:35:00 | AAPL | Stock | 38.3875 | 38.3875 | 38.3625 | 38.375 | 22656.0 |
| 2017-06-02 08:40:00 | AAPL | Stock | 38.3675 | 38.3875 | 38.35 | 38.355 | 35768.0 |
| 2017-06-02 08:45:00 | AAPL | Stock | 38.345 | 38.3525 | 38.27 | 38.3 | 21600.0 |
| 2017-06-02 08:50:00 | AAPL | Stock | 38.3 | 38.325 | 38.3 | 38.3075 | 9600.0 |
| 2017-06-02 08:55:00 | AAPL | Stock | 38.3125 | 38.345 | 38.3125 | 38.345 | 10552.0 |
| 2017-06-02 09:00:00 | AAPL | Stock | 38.3625 | 38.375 | 38.3375 | 38.34 | 13224.0 |
| 2017-06-02 09:05:00 | AAPL | Stock | 38.375 | 38.3925 | 38.36 | 38.3925 | 49260.0 |
| 2017-06-02 09:10:00 | AAPL | Stock | 38.395 | 38.3975 | 38.375 | 38.375 | 25780.0 |
| 2017-06-02 09:15:00 | AAPL | Stock | 38.3825 | 38.3825 | 38.36 | 38.3675 | 18488.0 |
| 2017-06-02 09:20:00 | AAPL | Stock | 38.3675 | 38.3875 | 38.3675 | 38.375 | 5960.0 |
| 2017-06-02 09:25:00 | AAPL | Stock | 38.355 | 38.4 | 38.3325 | 38.4 | 41540.0 |
| 2017-06-02 09:30:00 | AAPL | Stock | 38.3975 | 38.41 | 38.25 | 38.33 | 3105464.0 |
| 2017-06-02 09:35:00 | AAPL | Stock | 38.3275 | 38.335 | 38.26 | 38.275 | 1325824.0 |
| 2017-06-02 09:40:00 | AAPL | Stock | 38.275 | 38.3225 | 38.2225 | 38.3225 | 1731716.0 |
| 2017-06-02 09:45:00 | AAPL | Stock | 38.32 | 38.3625 | 38.2838 | 38.3575 | 1446252.0 |
| 2017-06-02 09:50:00 | AAPL | Stock | 38.3575 | 38.3825 | 38.3425 | 38.375 | 1417468.0 |
| 2017-06-02 09:55:00 | AAPL | Stock | 38.3762 | 38.3782 | 38.295 | 38.3225 | 1039200.0 |
| 2017-06-02 10:00:00 | AAPL | Stock | 38.3225 | 38.385 | 38.3075 | 38.3612 | 1175472.0 |
| 2017-06-02 10:05:00 | AAPL | Stock | 38.3612 | 38.39 | 38.3468 | 38.377 | 1003524.0 |
| 2017-06-02 10:10:00 | AAPL | Stock | 38.375 | 38.3975 | 38.34 | 38.3888 | 980108.0 |
| 2017-06-02 10:15:00 | AAPL | Stock | 38.3888 | 38.3925 | 38.3515 | 38.3675 | 963776.0 |
| 2017-06-02 10:20:00 | AAPL | Stock | 38.3675 | 38.385 | 38.358 | 38.3738 | 491796.0 |
| 2017-06-02 10:25:00 | AAPL | Stock | 38.3735 | 38.3875 | 38.3575 | 38.3862 | 579144.0 |
| 2017-06-02 10:30:00 | AAPL | Stock | 38.3875 | 38.3975 | 38.355 | 38.37 | 657180.0 |
| 2017-06-02 10:35:00 | AAPL | Stock | 38.37 | 38.395 | 38.3575 | 38.39 | 748336.0 |
| 2017-06-02 10:40:00 | AAPL | Stock | 38.3898 | 38.3975 | 38.3787 | 38.3875 | 588032.0 |
| 2017-06-02 10:45:00 | AAPL | Stock | 38.39 | 38.3925 | 38.3598 | 38.375 | 546088.0 |
| 2017-06-02 10:50:00 | AAPL | Stock | 38.3775 | 38.3925 | 38.37 | 38.3787 | 616884.0 |
> showing 50 of 355,763 rows — these rows as CSV