PREVIEW / stock_5min / 2016-08-02
file: by_date/stock_5min/2016/2016-08-02.parquet size: 5.5 MB rows: 356,042 symbols: 3,244
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-08-02 04:00:00 | AAPL | Stock | 26.5 | 26.5 | 26.5 | 26.5 | 400.0 |
| 2016-08-02 04:05:00 | AAPL | Stock | 26.4975 | 26.4975 | 26.4975 | 26.4975 | 400.0 |
| 2016-08-02 04:10:00 | AAPL | Stock | 26.4175 | 26.4175 | 26.4175 | 26.4175 | 400.0 |
| 2016-08-02 04:15:00 | AAPL | Stock | 26.4625 | 26.4625 | 26.4625 | 26.4625 | 400.0 |
| 2016-08-02 04:20:00 | AAPL | Stock | 26.375 | 26.375 | 26.375 | 26.375 | 3200.0 |
| 2016-08-02 04:25:00 | AAPL | Stock | 26.41 | 26.41 | 26.41 | 26.41 | 500.0 |
| 2016-08-02 04:40:00 | AAPL | Stock | 26.3775 | 26.3775 | 26.3775 | 26.3775 | 3200.0 |
| 2016-08-02 04:45:00 | AAPL | Stock | 26.375 | 26.375 | 26.375 | 26.375 | 400.0 |
| 2016-08-02 04:55:00 | AAPL | Stock | 26.375 | 26.395 | 26.375 | 26.395 | 4392.0 |
| 2016-08-02 05:10:00 | AAPL | Stock | 26.395 | 26.395 | 26.395 | 26.395 | 800.0 |
| 2016-08-02 05:35:00 | AAPL | Stock | 26.36 | 26.3875 | 26.36 | 26.3875 | 2400.0 |
| 2016-08-02 05:40:00 | AAPL | Stock | 26.3875 | 26.3875 | 26.3875 | 26.3875 | 4000.0 |
| 2016-08-02 06:00:00 | AAPL | Stock | 26.4125 | 26.43 | 26.4125 | 26.43 | 6564.0 |
| 2016-08-02 06:10:00 | AAPL | Stock | 26.39 | 26.4325 | 26.39 | 26.4325 | 1400.0 |
| 2016-08-02 06:25:00 | AAPL | Stock | 26.45 | 26.45 | 26.45 | 26.45 | 4000.0 |
| 2016-08-02 06:30:00 | AAPL | Stock | 26.45 | 26.4625 | 26.45 | 26.4625 | 2000.0 |
| 2016-08-02 06:45:00 | AAPL | Stock | 26.4175 | 26.4175 | 26.38 | 26.38 | 4980.0 |
| 2016-08-02 06:55:00 | AAPL | Stock | 26.4125 | 26.4125 | 26.38 | 26.4125 | 18080.0 |
| 2016-08-02 07:00:00 | AAPL | Stock | 26.4125 | 26.4625 | 26.4125 | 26.4625 | 46080.0 |
| 2016-08-02 07:05:00 | AAPL | Stock | 26.455 | 26.455 | 26.45 | 26.45 | 4720.0 |
| 2016-08-02 07:10:00 | AAPL | Stock | 26.4375 | 26.4375 | 26.415 | 26.415 | 8820.0 |
| 2016-08-02 07:15:00 | AAPL | Stock | 26.435 | 26.435 | 26.435 | 26.435 | 800.0 |
| 2016-08-02 07:20:00 | AAPL | Stock | 26.435 | 26.4375 | 26.425 | 26.425 | 4800.0 |
| 2016-08-02 07:25:00 | AAPL | Stock | 26.425 | 26.425 | 26.4225 | 26.425 | 2800.0 |
| 2016-08-02 07:30:00 | AAPL | Stock | 26.4375 | 26.44 | 26.4375 | 26.44 | 2400.0 |
| 2016-08-02 07:35:00 | AAPL | Stock | 26.4575 | 26.4575 | 26.4375 | 26.4375 | 9768.0 |
| 2016-08-02 07:40:00 | AAPL | Stock | 26.4175 | 26.4375 | 26.41 | 26.4225 | 6696.0 |
| 2016-08-02 07:45:00 | AAPL | Stock | 26.4325 | 26.4325 | 26.4125 | 26.4125 | 3156.0 |
| 2016-08-02 07:50:00 | AAPL | Stock | 26.41 | 26.425 | 26.41 | 26.425 | 6068.0 |
| 2016-08-02 07:55:00 | AAPL | Stock | 26.415 | 26.415 | 26.4 | 26.4 | 18892.0 |
| 2016-08-02 08:00:00 | AAPL | Stock | 26.435 | 26.45 | 26.4175 | 26.42 | 83676.0 |
| 2016-08-02 08:05:00 | AAPL | Stock | 26.4175 | 26.43 | 26.405 | 26.43 | 40452.0 |
| 2016-08-02 08:10:00 | AAPL | Stock | 26.4225 | 26.4225 | 26.4225 | 26.4225 | 4800.0 |
| 2016-08-02 08:15:00 | AAPL | Stock | 26.4375 | 26.445 | 26.4375 | 26.4425 | 14076.0 |
| 2016-08-02 08:20:00 | AAPL | Stock | 26.4375 | 26.455 | 26.4375 | 26.455 | 26660.0 |
| 2016-08-02 08:25:00 | AAPL | Stock | 26.4525 | 26.4525 | 26.44 | 26.44 | 25440.0 |
| 2016-08-02 08:30:00 | AAPL | Stock | 26.44 | 26.4475 | 26.4375 | 26.4375 | 17940.0 |
| 2016-08-02 08:35:00 | AAPL | Stock | 26.4375 | 26.4475 | 26.4375 | 26.4475 | 10820.0 |
| 2016-08-02 08:40:00 | AAPL | Stock | 26.4475 | 26.4475 | 26.445 | 26.4475 | 2888.0 |
| 2016-08-02 08:45:00 | AAPL | Stock | 26.4525 | 26.4525 | 26.4425 | 26.4425 | 4024.0 |
| 2016-08-02 08:50:00 | AAPL | Stock | 26.4475 | 26.4475 | 26.4375 | 26.44 | 20244.0 |
| 2016-08-02 08:55:00 | AAPL | Stock | 26.435 | 26.44 | 26.435 | 26.435 | 8420.0 |
| 2016-08-02 09:00:00 | AAPL | Stock | 26.4375 | 26.4375 | 26.4175 | 26.435 | 53600.0 |
| 2016-08-02 09:05:00 | AAPL | Stock | 26.435 | 26.44 | 26.4275 | 26.44 | 6800.0 |
| 2016-08-02 09:10:00 | AAPL | Stock | 26.44 | 26.44 | 26.44 | 26.44 | 1644.0 |
| 2016-08-02 09:15:00 | AAPL | Stock | 26.44 | 26.45 | 26.4325 | 26.45 | 11536.0 |
| 2016-08-02 09:20:00 | AAPL | Stock | 26.45 | 26.4525 | 26.4425 | 26.4525 | 20164.0 |
| 2016-08-02 09:25:00 | AAPL | Stock | 26.45 | 26.4525 | 26.385 | 26.39 | 138096.0 |
| 2016-08-02 09:30:00 | AAPL | Stock | 26.5125 | 26.5125 | 26.3855 | 26.4848 | 6202736.0 |
| 2016-08-02 09:35:00 | AAPL | Stock | 26.485 | 26.5175 | 26.3625 | 26.38 | 4355592.0 |
> showing 50 of 356,042 rows — these rows as CSV