PREVIEW / stock_5min / 2016-02-08
file: by_date/stock_5min/2016/2016-02-08.parquet size: 5.6 MB rows: 369,329 symbols: 3,367
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-02-08 04:00:00 | AAPL | Stock | 23.4525 | 23.4525 | 23.4525 | 23.4525 | 1904.0 |
| 2016-02-08 04:05:00 | AAPL | Stock | 23.45 | 23.45 | 23.45 | 23.45 | 1200.0 |
| 2016-02-08 04:20:00 | AAPL | Stock | 23.3375 | 23.3375 | 23.3375 | 23.3375 | 1760.0 |
| 2016-02-08 04:25:00 | AAPL | Stock | 23.2775 | 23.2825 | 23.275 | 23.275 | 3000.0 |
| 2016-02-08 04:30:00 | AAPL | Stock | 23.2525 | 23.255 | 23.2525 | 23.255 | 1992.0 |
| 2016-02-08 04:35:00 | AAPL | Stock | 23.2525 | 23.2525 | 23.22 | 23.22 | 5884.0 |
| 2016-02-08 04:45:00 | AAPL | Stock | 23.22 | 23.22 | 23.22 | 23.22 | 4600.0 |
| 2016-02-08 04:50:00 | AAPL | Stock | 23.1875 | 23.1875 | 23.1875 | 23.1875 | 1600.0 |
| 2016-02-08 04:55:00 | AAPL | Stock | 23.17 | 23.17 | 23.1625 | 23.1625 | 1280.0 |
| 2016-02-08 05:00:00 | AAPL | Stock | 23.0825 | 23.105 | 23.0825 | 23.105 | 4140.0 |
| 2016-02-08 05:05:00 | AAPL | Stock | 23.105 | 23.1275 | 23.105 | 23.1275 | 5200.0 |
| 2016-02-08 05:10:00 | AAPL | Stock | 23.105 | 23.12 | 23.105 | 23.12 | 932.0 |
| 2016-02-08 05:15:00 | AAPL | Stock | 23.12 | 23.12 | 23.12 | 23.12 | 18544.0 |
| 2016-02-08 05:20:00 | AAPL | Stock | 23.12 | 23.12 | 23.105 | 23.105 | 9992.0 |
| 2016-02-08 05:25:00 | AAPL | Stock | 23.1575 | 23.1575 | 23.105 | 23.105 | 1556.0 |
| 2016-02-08 05:35:00 | AAPL | Stock | 23.1575 | 23.1575 | 23.1575 | 23.1575 | 596.0 |
| 2016-02-08 05:45:00 | AAPL | Stock | 23.105 | 23.105 | 23.105 | 23.105 | 1988.0 |
| 2016-02-08 05:50:00 | AAPL | Stock | 23.105 | 23.105 | 23.105 | 23.105 | 680.0 |
| 2016-02-08 05:55:00 | AAPL | Stock | 23.105 | 23.105 | 23.105 | 23.105 | 1200.0 |
| 2016-02-08 06:00:00 | AAPL | Stock | 23.08 | 23.08 | 23.08 | 23.08 | 600.0 |
| 2016-02-08 06:05:00 | AAPL | Stock | 23.05 | 23.055 | 23.0375 | 23.055 | 4000.0 |
| 2016-02-08 06:10:00 | AAPL | Stock | 23.075 | 23.075 | 23.0325 | 23.0325 | 4864.0 |
| 2016-02-08 06:15:00 | AAPL | Stock | 23.04 | 23.04 | 23.04 | 23.04 | 1000.0 |
| 2016-02-08 06:20:00 | AAPL | Stock | 23.05 | 23.05 | 23.05 | 23.05 | 4000.0 |
| 2016-02-08 06:25:00 | AAPL | Stock | 23.075 | 23.0975 | 23.075 | 23.0775 | 10160.0 |
| 2016-02-08 06:30:00 | AAPL | Stock | 23.1 | 23.1225 | 23.1 | 23.1225 | 12388.0 |
| 2016-02-08 06:35:00 | AAPL | Stock | 23.1125 | 23.1375 | 23.0775 | 23.0775 | 11376.0 |
| 2016-02-08 06:45:00 | AAPL | Stock | 23.0875 | 23.1 | 23.0775 | 23.1 | 2400.0 |
| 2016-02-08 06:55:00 | AAPL | Stock | 23.0975 | 23.0975 | 23.0975 | 23.0975 | 400.0 |
| 2016-02-08 07:00:00 | AAPL | Stock | 23.08 | 23.1 | 23.05 | 23.05 | 5052.0 |
| 2016-02-08 07:05:00 | AAPL | Stock | 23.0525 | 23.08 | 23.05 | 23.08 | 8160.0 |
| 2016-02-08 07:10:00 | AAPL | Stock | 23.05 | 23.0625 | 23.0325 | 23.05 | 44792.0 |
| 2016-02-08 07:15:00 | AAPL | Stock | 23.05 | 23.075 | 23.05 | 23.075 | 41292.0 |
| 2016-02-08 07:20:00 | AAPL | Stock | 23.085 | 23.0875 | 23.0125 | 23.0275 | 52808.0 |
| 2016-02-08 07:25:00 | AAPL | Stock | 23.045 | 23.08 | 23.0375 | 23.08 | 33580.0 |
| 2016-02-08 07:30:00 | AAPL | Stock | 23.0975 | 23.0975 | 23.075 | 23.075 | 7780.0 |
| 2016-02-08 07:35:00 | AAPL | Stock | 23.075 | 23.1 | 23.0725 | 23.0875 | 18860.0 |
| 2016-02-08 07:40:00 | AAPL | Stock | 23.075 | 23.0875 | 23.0375 | 23.0375 | 28692.0 |
| 2016-02-08 07:45:00 | AAPL | Stock | 23.0375 | 23.06 | 23.03 | 23.06 | 7200.0 |
| 2016-02-08 07:50:00 | AAPL | Stock | 23.065 | 23.085 | 23.065 | 23.085 | 14800.0 |
| 2016-02-08 07:55:00 | AAPL | Stock | 23.07 | 23.0725 | 23.07 | 23.07 | 12820.0 |
| 2016-02-08 08:00:00 | AAPL | Stock | 23.0775 | 23.1575 | 23.0325 | 23.14 | 191300.0 |
| 2016-02-08 08:05:00 | AAPL | Stock | 23.1525 | 23.1625 | 23.0825 | 23.0825 | 55480.0 |
| 2016-02-08 08:10:00 | AAPL | Stock | 23.0775 | 23.12 | 23.05 | 23.095 | 57256.0 |
| 2016-02-08 08:15:00 | AAPL | Stock | 23.095 | 23.12 | 23.095 | 23.1 | 12564.0 |
| 2016-02-08 08:20:00 | AAPL | Stock | 23.1075 | 23.1575 | 23.1075 | 23.1475 | 51124.0 |
| 2016-02-08 08:25:00 | AAPL | Stock | 23.15 | 23.1725 | 23.125 | 23.155 | 68280.0 |
| 2016-02-08 08:30:00 | AAPL | Stock | 23.155 | 23.1725 | 23.125 | 23.15 | 31840.0 |
| 2016-02-08 08:35:00 | AAPL | Stock | 23.1425 | 23.175 | 23.1425 | 23.175 | 40276.0 |
| 2016-02-08 08:40:00 | AAPL | Stock | 23.1725 | 23.1925 | 23.1725 | 23.19 | 22660.0 |
> showing 50 of 369,329 rows — these rows as CSV