PREVIEW / stock_5min / 2016-06-22
file: by_date/stock_5min/2016/2016-06-22.parquet size: 5.3 MB rows: 354,602 symbols: 3,291
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-06-22 04:30:00 | AAPL | Stock | 24.0125 | 24.0125 | 24.0125 | 24.0125 | 600.0 |
| 2016-06-22 04:35:00 | AAPL | Stock | 24.0125 | 24.0125 | 24.0125 | 24.0125 | 800.0 |
| 2016-06-22 05:55:00 | AAPL | Stock | 24.0475 | 24.0475 | 24.0475 | 24.0475 | 480.0 |
| 2016-06-22 06:15:00 | AAPL | Stock | 24.0625 | 24.0625 | 24.0625 | 24.0625 | 800.0 |
| 2016-06-22 06:20:00 | AAPL | Stock | 24.0375 | 24.0375 | 24.0375 | 24.0375 | 1160.0 |
| 2016-06-22 06:40:00 | AAPL | Stock | 24.06 | 24.06 | 24.06 | 24.06 | 400.0 |
| 2016-06-22 06:50:00 | AAPL | Stock | 24.0725 | 24.0725 | 24.0725 | 24.0725 | 6000.0 |
| 2016-06-22 07:00:00 | AAPL | Stock | 24.075 | 24.0975 | 24.06 | 24.0975 | 24200.0 |
| 2016-06-22 07:05:00 | AAPL | Stock | 24.0975 | 24.0975 | 24.0925 | 24.0975 | 4800.0 |
| 2016-06-22 07:10:00 | AAPL | Stock | 24.0875 | 24.0875 | 24.0875 | 24.0875 | 800.0 |
| 2016-06-22 07:15:00 | AAPL | Stock | 24.095 | 24.1125 | 24.095 | 24.1125 | 6000.0 |
| 2016-06-22 07:20:00 | AAPL | Stock | 24.135 | 24.1425 | 24.135 | 24.14 | 17200.0 |
| 2016-06-22 07:25:00 | AAPL | Stock | 24.1375 | 24.1525 | 24.1375 | 24.1375 | 15292.0 |
| 2016-06-22 07:30:00 | AAPL | Stock | 24.1375 | 24.1375 | 24.1375 | 24.1375 | 11200.0 |
| 2016-06-22 07:35:00 | AAPL | Stock | 24.1475 | 24.175 | 24.1475 | 24.175 | 19716.0 |
| 2016-06-22 07:40:00 | AAPL | Stock | 24.17 | 24.175 | 24.1625 | 24.175 | 5132.0 |
| 2016-06-22 07:45:00 | AAPL | Stock | 24.1625 | 24.1625 | 24.1625 | 24.1625 | 400.0 |
| 2016-06-22 07:50:00 | AAPL | Stock | 24.175 | 24.175 | 24.1625 | 24.1625 | 4428.0 |
| 2016-06-22 07:55:00 | AAPL | Stock | 24.165 | 24.1725 | 24.1625 | 24.1625 | 8800.0 |
| 2016-06-22 08:00:00 | AAPL | Stock | 24.1625 | 24.175 | 24.05 | 24.1625 | 31160.0 |
| 2016-06-22 08:05:00 | AAPL | Stock | 24.1625 | 24.175 | 24.135 | 24.135 | 136696.0 |
| 2016-06-22 08:10:00 | AAPL | Stock | 24.1625 | 24.175 | 24.125 | 24.155 | 84840.0 |
| 2016-06-22 08:15:00 | AAPL | Stock | 24.155 | 24.155 | 24.1375 | 24.155 | 38752.0 |
| 2016-06-22 08:20:00 | AAPL | Stock | 24.145 | 24.1575 | 24.115 | 24.1375 | 163328.0 |
| 2016-06-22 08:25:00 | AAPL | Stock | 24.1425 | 24.1425 | 24.1375 | 24.14 | 4920.0 |
| 2016-06-22 08:30:00 | AAPL | Stock | 24.14 | 24.1625 | 24.14 | 24.1625 | 8800.0 |
| 2016-06-22 08:35:00 | AAPL | Stock | 24.1625 | 24.1675 | 24.15 | 24.15 | 53884.0 |
| 2016-06-22 08:40:00 | AAPL | Stock | 24.1575 | 24.1575 | 24.15 | 24.155 | 4320.0 |
| 2016-06-22 08:45:00 | AAPL | Stock | 24.155 | 24.1575 | 24.125 | 24.125 | 23740.0 |
| 2016-06-22 08:50:00 | AAPL | Stock | 24.12 | 24.13 | 24.12 | 24.125 | 14016.0 |
| 2016-06-22 08:55:00 | AAPL | Stock | 24.12 | 24.1225 | 24.1125 | 24.1225 | 6324.0 |
| 2016-06-22 09:00:00 | AAPL | Stock | 24.1175 | 24.13 | 24.1175 | 24.13 | 8400.0 |
| 2016-06-22 09:05:00 | AAPL | Stock | 24.1275 | 24.1375 | 24.125 | 24.1375 | 12260.0 |
| 2016-06-22 09:10:00 | AAPL | Stock | 24.1475 | 24.1475 | 24.1475 | 24.1475 | 800.0 |
| 2016-06-22 09:15:00 | AAPL | Stock | 24.1325 | 24.145 | 24.13 | 24.135 | 17208.0 |
| 2016-06-22 09:20:00 | AAPL | Stock | 24.135 | 24.135 | 24.11 | 24.12 | 27112.0 |
| 2016-06-22 09:25:00 | AAPL | Stock | 24.115 | 24.125 | 24.06 | 24.0625 | 161236.0 |
| 2016-06-22 09:30:00 | AAPL | Stock | 24.0625 | 24.1625 | 24.0625 | 24.15 | 4182564.0 |
| 2016-06-22 09:35:00 | AAPL | Stock | 24.155 | 24.185 | 24.14 | 24.1625 | 2813880.0 |
| 2016-06-22 09:40:00 | AAPL | Stock | 24.165 | 24.2225 | 24.1625 | 24.205 | 3270828.0 |
| 2016-06-22 09:45:00 | AAPL | Stock | 24.2025 | 24.2025 | 24.155 | 24.1862 | 1667072.0 |
| 2016-06-22 09:50:00 | AAPL | Stock | 24.187 | 24.205 | 24.1725 | 24.199 | 1381476.0 |
| 2016-06-22 09:55:00 | AAPL | Stock | 24.1975 | 24.204 | 24.15 | 24.15 | 1243952.0 |
| 2016-06-22 10:00:00 | AAPL | Stock | 24.155 | 24.1737 | 24.1425 | 24.15 | 1320200.0 |
| 2016-06-22 10:05:00 | AAPL | Stock | 24.15 | 24.1575 | 24.115 | 24.145 | 1506200.0 |
| 2016-06-22 10:10:00 | AAPL | Stock | 24.145 | 24.18 | 24.1425 | 24.18 | 1533648.0 |
| 2016-06-22 10:15:00 | AAPL | Stock | 24.18 | 24.1875 | 24.145 | 24.145 | 1256308.0 |
| 2016-06-22 10:20:00 | AAPL | Stock | 24.145 | 24.1588 | 24.11 | 24.1225 | 1323624.0 |
| 2016-06-22 10:25:00 | AAPL | Stock | 24.12 | 24.1475 | 24.105 | 24.14 | 1116192.0 |
| 2016-06-22 10:30:00 | AAPL | Stock | 24.14 | 24.1675 | 24.1125 | 24.165 | 1695024.0 |
> showing 50 of 354,602 rows — these rows as CSV