PREVIEW / stock_5min / 2017-02-13
file: by_date/stock_5min/2017/2017-02-13.parquet size: 5.4 MB rows: 353,648 symbols: 3,107
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-02-13 04:20:00 | AAPL | Stock | 33.1 | 33.1 | 33.0425 | 33.055 | 2000.0 |
| 2017-02-13 04:30:00 | AAPL | Stock | 33.06 | 33.06 | 33.06 | 33.06 | 400.0 |
| 2017-02-13 04:45:00 | AAPL | Stock | 33.03 | 33.03 | 33.03 | 33.03 | 7116.0 |
| 2017-02-13 05:15:00 | AAPL | Stock | 33.05 | 33.05 | 33.05 | 33.05 | 592.0 |
| 2017-02-13 05:30:00 | AAPL | Stock | 33.05 | 33.05 | 33.05 | 33.05 | 800.0 |
| 2017-02-13 05:35:00 | AAPL | Stock | 33.0725 | 33.075 | 33.0725 | 33.075 | 1600.0 |
| 2017-02-13 05:50:00 | AAPL | Stock | 33.07 | 33.07 | 33.07 | 33.07 | 800.0 |
| 2017-02-13 05:55:00 | AAPL | Stock | 33.05 | 33.05 | 33.05 | 33.05 | 504.0 |
| 2017-02-13 06:00:00 | AAPL | Stock | 33.0525 | 33.0525 | 33.0525 | 33.0525 | 800.0 |
| 2017-02-13 06:30:00 | AAPL | Stock | 33.08 | 33.0875 | 33.08 | 33.0875 | 3680.0 |
| 2017-02-13 06:35:00 | AAPL | Stock | 33.0875 | 33.0875 | 33.0875 | 33.0875 | 4000.0 |
| 2017-02-13 06:50:00 | AAPL | Stock | 33.0875 | 33.0875 | 33.0875 | 33.0875 | 2800.0 |
| 2017-02-13 07:00:00 | AAPL | Stock | 33.0625 | 33.0625 | 33.0625 | 33.0625 | 400.0 |
| 2017-02-13 07:05:00 | AAPL | Stock | 33.0625 | 33.0625 | 33.0625 | 33.0625 | 400.0 |
| 2017-02-13 07:10:00 | AAPL | Stock | 33.075 | 33.085 | 33.075 | 33.085 | 3308.0 |
| 2017-02-13 07:15:00 | AAPL | Stock | 33.075 | 33.075 | 33.075 | 33.075 | 400.0 |
| 2017-02-13 07:20:00 | AAPL | Stock | 33.075 | 33.0875 | 33.075 | 33.0875 | 2212.0 |
| 2017-02-13 07:30:00 | AAPL | Stock | 33.0875 | 33.1 | 33.0875 | 33.1 | 800.0 |
| 2017-02-13 07:35:00 | AAPL | Stock | 33.1 | 33.105 | 33.1 | 33.105 | 13740.0 |
| 2017-02-13 07:40:00 | AAPL | Stock | 33.095 | 33.11 | 33.095 | 33.11 | 2800.0 |
| 2017-02-13 07:45:00 | AAPL | Stock | 33.12 | 33.1375 | 33.1175 | 33.1375 | 49552.0 |
| 2017-02-13 07:50:00 | AAPL | Stock | 33.1475 | 33.15 | 33.1375 | 33.14 | 8496.0 |
| 2017-02-13 07:55:00 | AAPL | Stock | 33.14 | 33.145 | 33.125 | 33.125 | 22528.0 |
| 2017-02-13 08:00:00 | AAPL | Stock | 33.125 | 33.15 | 32.9475 | 33.095 | 99672.0 |
| 2017-02-13 08:05:00 | AAPL | Stock | 33.0875 | 33.135 | 33.0875 | 33.125 | 27172.0 |
| 2017-02-13 08:10:00 | AAPL | Stock | 33.1375 | 33.14 | 33.135 | 33.135 | 41200.0 |
| 2017-02-13 08:15:00 | AAPL | Stock | 33.1425 | 33.1625 | 33.1425 | 33.16 | 27948.0 |
| 2017-02-13 08:20:00 | AAPL | Stock | 33.16 | 33.1825 | 33.155 | 33.1825 | 67184.0 |
| 2017-02-13 08:25:00 | AAPL | Stock | 33.165 | 33.175 | 33.155 | 33.1625 | 46148.0 |
| 2017-02-13 08:30:00 | AAPL | Stock | 33.16 | 33.1675 | 33.15 | 33.1575 | 26140.0 |
| 2017-02-13 08:35:00 | AAPL | Stock | 33.1575 | 33.1625 | 33.1575 | 33.1625 | 33080.0 |
| 2017-02-13 08:40:00 | AAPL | Stock | 33.1625 | 33.18 | 33.1625 | 33.1725 | 34312.0 |
| 2017-02-13 08:45:00 | AAPL | Stock | 33.1625 | 33.165 | 33.155 | 33.1625 | 20276.0 |
| 2017-02-13 08:50:00 | AAPL | Stock | 33.16 | 33.17 | 33.155 | 33.1625 | 16528.0 |
| 2017-02-13 08:55:00 | AAPL | Stock | 33.17 | 33.22 | 33.17 | 33.2125 | 100568.0 |
| 2017-02-13 09:00:00 | AAPL | Stock | 33.2075 | 33.2325 | 33.2075 | 33.2125 | 109052.0 |
| 2017-02-13 09:05:00 | AAPL | Stock | 33.2075 | 33.2725 | 33.2 | 33.265 | 247764.0 |
| 2017-02-13 09:10:00 | AAPL | Stock | 33.2625 | 33.275 | 33.255 | 33.2725 | 189032.0 |
| 2017-02-13 09:15:00 | AAPL | Stock | 33.2675 | 33.2725 | 33.26 | 33.2725 | 104580.0 |
| 2017-02-13 09:20:00 | AAPL | Stock | 33.2625 | 33.27 | 33.25 | 33.2625 | 102056.0 |
| 2017-02-13 09:25:00 | AAPL | Stock | 33.26 | 33.2825 | 33.25 | 33.2525 | 220164.0 |
| 2017-02-13 09:30:00 | AAPL | Stock | 33.2625 | 33.35 | 33.1875 | 33.3498 | 7395988.0 |
| 2017-02-13 09:35:00 | AAPL | Stock | 33.348 | 33.3625 | 33.3 | 33.36 | 3597532.0 |
| 2017-02-13 09:40:00 | AAPL | Stock | 33.359 | 33.4457 | 33.355 | 33.425 | 4115960.0 |
| 2017-02-13 09:45:00 | AAPL | Stock | 33.425 | 33.455 | 33.4 | 33.4375 | 2922832.0 |
| 2017-02-13 09:50:00 | AAPL | Stock | 33.44 | 33.4425 | 33.3975 | 33.402 | 2081676.0 |
| 2017-02-13 09:55:00 | AAPL | Stock | 33.4 | 33.415 | 33.3625 | 33.4012 | 1820804.0 |
| 2017-02-13 10:00:00 | AAPL | Stock | 33.4012 | 33.4275 | 33.3938 | 33.4078 | 1122732.0 |
| 2017-02-13 10:05:00 | AAPL | Stock | 33.41 | 33.425 | 33.4 | 33.415 | 1057116.0 |
| 2017-02-13 10:10:00 | AAPL | Stock | 33.4175 | 33.4375 | 33.4085 | 33.435 | 977716.0 |
> showing 50 of 353,648 rows — these rows as CSV