PREVIEW / stock_5min / 2017-09-11
file: by_date/stock_5min/2017/2017-09-11.parquet size: 5.4 MB rows: 355,639 symbols: 2,972
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-09-11 04:00:00 | AAPL | Stock | 40.1025 | 40.1025 | 40.0875 | 40.1025 | 4884.0 |
| 2017-09-11 04:05:00 | AAPL | Stock | 40.1025 | 40.1025 | 40.0875 | 40.0875 | 5360.0 |
| 2017-09-11 04:10:00 | AAPL | Stock | 40.1025 | 40.125 | 40.1 | 40.125 | 8540.0 |
| 2017-09-11 04:15:00 | AAPL | Stock | 40.1625 | 40.1625 | 40.1025 | 40.115 | 6716.0 |
| 2017-09-11 04:20:00 | AAPL | Stock | 40.125 | 40.1575 | 40.125 | 40.1575 | 2400.0 |
| 2017-09-11 04:25:00 | AAPL | Stock | 40.155 | 40.2 | 40.155 | 40.175 | 14996.0 |
| 2017-09-11 04:30:00 | AAPL | Stock | 40.175 | 40.175 | 40.175 | 40.175 | 1312.0 |
| 2017-09-11 04:35:00 | AAPL | Stock | 40.2175 | 40.2225 | 40.2175 | 40.2225 | 1608.0 |
| 2017-09-11 04:40:00 | AAPL | Stock | 40.2225 | 40.2225 | 40.2225 | 40.2225 | 5064.0 |
| 2017-09-11 04:45:00 | AAPL | Stock | 40.2225 | 40.2225 | 40.2175 | 40.2175 | 12160.0 |
| 2017-09-11 04:50:00 | AAPL | Stock | 40.2125 | 40.2175 | 40.2125 | 40.2175 | 4408.0 |
| 2017-09-11 04:55:00 | AAPL | Stock | 40.2175 | 40.2175 | 40.2175 | 40.2175 | 800.0 |
| 2017-09-11 05:00:00 | AAPL | Stock | 40.2175 | 40.2175 | 40.2175 | 40.2175 | 5620.0 |
| 2017-09-11 05:05:00 | AAPL | Stock | 40.2175 | 40.2175 | 40.2175 | 40.2175 | 800.0 |
| 2017-09-11 05:10:00 | AAPL | Stock | 40.2225 | 40.2225 | 40.2125 | 40.2125 | 2044.0 |
| 2017-09-11 05:15:00 | AAPL | Stock | 40.2125 | 40.2125 | 40.2125 | 40.2125 | 2000.0 |
| 2017-09-11 05:25:00 | AAPL | Stock | 40.215 | 40.215 | 40.2125 | 40.2125 | 4000.0 |
| 2017-09-11 05:30:00 | AAPL | Stock | 40.225 | 40.225 | 40.2125 | 40.2125 | 5000.0 |
| 2017-09-11 05:35:00 | AAPL | Stock | 40.2125 | 40.2125 | 40.2125 | 40.2125 | 5272.0 |
| 2017-09-11 05:40:00 | AAPL | Stock | 40.2125 | 40.235 | 40.2125 | 40.235 | 3184.0 |
| 2017-09-11 05:45:00 | AAPL | Stock | 40.235 | 40.24 | 40.235 | 40.235 | 8936.0 |
| 2017-09-11 05:55:00 | AAPL | Stock | 40.2475 | 40.2575 | 40.2475 | 40.2575 | 3124.0 |
| 2017-09-11 06:00:00 | AAPL | Stock | 40.26 | 40.26 | 40.225 | 40.225 | 11488.0 |
| 2017-09-11 06:05:00 | AAPL | Stock | 40.225 | 40.225 | 40.215 | 40.215 | 5776.0 |
| 2017-09-11 06:10:00 | AAPL | Stock | 40.215 | 40.215 | 40.215 | 40.215 | 3172.0 |
| 2017-09-11 06:15:00 | AAPL | Stock | 40.22 | 40.225 | 40.215 | 40.225 | 12380.0 |
| 2017-09-11 06:20:00 | AAPL | Stock | 40.225 | 40.2375 | 40.225 | 40.2375 | 4892.0 |
| 2017-09-11 06:25:00 | AAPL | Stock | 40.2375 | 40.2375 | 40.2375 | 40.2375 | 1200.0 |
| 2017-09-11 06:30:00 | AAPL | Stock | 40.25 | 40.25 | 40.25 | 40.25 | 800.0 |
| 2017-09-11 06:35:00 | AAPL | Stock | 40.25 | 40.25 | 40.25 | 40.25 | 7236.0 |
| 2017-09-11 06:40:00 | AAPL | Stock | 40.2475 | 40.2475 | 40.225 | 40.225 | 40936.0 |
| 2017-09-11 06:45:00 | AAPL | Stock | 40.225 | 40.245 | 40.225 | 40.245 | 4396.0 |
| 2017-09-11 06:50:00 | AAPL | Stock | 40.2175 | 40.225 | 40.175 | 40.175 | 25544.0 |
| 2017-09-11 06:55:00 | AAPL | Stock | 40.215 | 40.215 | 40.1525 | 40.175 | 7388.0 |
| 2017-09-11 07:00:00 | AAPL | Stock | 40.175 | 40.175 | 40.1275 | 40.1625 | 44916.0 |
| 2017-09-11 07:05:00 | AAPL | Stock | 40.1625 | 40.1625 | 40.125 | 40.125 | 22932.0 |
| 2017-09-11 07:10:00 | AAPL | Stock | 40.125 | 40.1525 | 40.115 | 40.1375 | 24660.0 |
| 2017-09-11 07:15:00 | AAPL | Stock | 40.125 | 40.16 | 40.125 | 40.16 | 8348.0 |
| 2017-09-11 07:20:00 | AAPL | Stock | 40.1525 | 40.1725 | 40.15 | 40.165 | 27072.0 |
| 2017-09-11 07:25:00 | AAPL | Stock | 40.1725 | 40.1875 | 40.1625 | 40.1675 | 31652.0 |
| 2017-09-11 07:30:00 | AAPL | Stock | 40.1675 | 40.18 | 40.1675 | 40.175 | 8492.0 |
| 2017-09-11 07:35:00 | AAPL | Stock | 40.1775 | 40.1775 | 40.125 | 40.1375 | 34928.0 |
| 2017-09-11 07:40:00 | AAPL | Stock | 40.1375 | 40.1625 | 40.1375 | 40.15 | 9016.0 |
| 2017-09-11 07:45:00 | AAPL | Stock | 40.1475 | 40.1725 | 40.1425 | 40.145 | 40208.0 |
| 2017-09-11 07:50:00 | AAPL | Stock | 40.15 | 40.1575 | 40.15 | 40.15 | 4448.0 |
| 2017-09-11 07:55:00 | AAPL | Stock | 40.15 | 40.1725 | 40.15 | 40.1625 | 7572.0 |
| 2017-09-11 08:00:00 | AAPL | Stock | 40.165 | 40.25 | 40.14 | 40.1625 | 142560.0 |
| 2017-09-11 08:05:00 | AAPL | Stock | 40.175 | 40.175 | 40.1425 | 40.15 | 67684.0 |
| 2017-09-11 08:10:00 | AAPL | Stock | 40.15 | 40.1675 | 40.145 | 40.1575 | 67152.0 |
| 2017-09-11 08:15:00 | AAPL | Stock | 40.1675 | 40.17 | 40.1575 | 40.17 | 23036.0 |
> showing 50 of 355,639 rows — these rows as CSV