PREVIEW / stock_5min / 2015-11-03
file: by_date/stock_5min/2015/2015-11-03.parquet size: 5.6 MB rows: 367,322 symbols: 3,419
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-03 04:00:00 | AAPL | Stock | 30.25 | 30.25 | 30.25 | 30.25 | 400.0 |
| 2015-11-03 04:05:00 | AAPL | Stock | 30.1875 | 30.1875 | 30.17 | 30.17 | 1676.0 |
| 2015-11-03 04:40:00 | AAPL | Stock | 30.2125 | 30.2125 | 30.2125 | 30.2125 | 400.0 |
| 2015-11-03 04:45:00 | AAPL | Stock | 30.2125 | 30.22 | 30.2125 | 30.22 | 1280.0 |
| 2015-11-03 04:50:00 | AAPL | Stock | 30.22 | 30.235 | 30.22 | 30.235 | 2580.0 |
| 2015-11-03 05:15:00 | AAPL | Stock | 30.225 | 30.225 | 30.225 | 30.225 | 800.0 |
| 2015-11-03 05:20:00 | AAPL | Stock | 30.2125 | 30.2125 | 30.2125 | 30.2125 | 400.0 |
| 2015-11-03 05:45:00 | AAPL | Stock | 30.225 | 30.225 | 30.225 | 30.225 | 4800.0 |
| 2015-11-03 05:50:00 | AAPL | Stock | 30.2175 | 30.2175 | 30.2175 | 30.2175 | 5432.0 |
| 2015-11-03 05:55:00 | AAPL | Stock | 30.2175 | 30.2175 | 30.215 | 30.215 | 5600.0 |
| 2015-11-03 06:00:00 | AAPL | Stock | 30.205 | 30.21 | 30.1875 | 30.1875 | 5932.0 |
| 2015-11-03 06:05:00 | AAPL | Stock | 30.2 | 30.2 | 30.1875 | 30.1875 | 2800.0 |
| 2015-11-03 06:10:00 | AAPL | Stock | 30.1875 | 30.1875 | 30.175 | 30.175 | 2000.0 |
| 2015-11-03 06:15:00 | AAPL | Stock | 30.17 | 30.17 | 30.15 | 30.15 | 5800.0 |
| 2015-11-03 06:25:00 | AAPL | Stock | 30.1625 | 30.1625 | 30.1625 | 30.1625 | 400.0 |
| 2015-11-03 06:35:00 | AAPL | Stock | 30.1675 | 30.1675 | 30.1625 | 30.1675 | 1716.0 |
| 2015-11-03 06:40:00 | AAPL | Stock | 30.1675 | 30.185 | 30.1675 | 30.185 | 5500.0 |
| 2015-11-03 06:45:00 | AAPL | Stock | 30.1775 | 30.1775 | 30.1775 | 30.1775 | 6500.0 |
| 2015-11-03 06:55:00 | AAPL | Stock | 30.175 | 30.175 | 30.1625 | 30.1625 | 8400.0 |
| 2015-11-03 07:00:00 | AAPL | Stock | 30.175 | 30.175 | 30.165 | 30.175 | 18600.0 |
| 2015-11-03 07:05:00 | AAPL | Stock | 30.175 | 30.175 | 30.16 | 30.175 | 7440.0 |
| 2015-11-03 07:10:00 | AAPL | Stock | 30.155 | 30.155 | 30.155 | 30.155 | 1240.0 |
| 2015-11-03 07:15:00 | AAPL | Stock | 30.155 | 30.1675 | 30.1375 | 30.1375 | 18132.0 |
| 2015-11-03 07:20:00 | AAPL | Stock | 30.1325 | 30.1325 | 30.105 | 30.105 | 17172.0 |
| 2015-11-03 07:25:00 | AAPL | Stock | 30.125 | 30.16 | 30.0825 | 30.1475 | 13188.0 |
| 2015-11-03 07:30:00 | AAPL | Stock | 30.145 | 30.1475 | 30.145 | 30.1475 | 800.0 |
| 2015-11-03 07:35:00 | AAPL | Stock | 30.1425 | 30.165 | 30.1425 | 30.15 | 15208.0 |
| 2015-11-03 07:40:00 | AAPL | Stock | 30.1625 | 30.1675 | 30.155 | 30.1625 | 35988.0 |
| 2015-11-03 07:45:00 | AAPL | Stock | 30.1675 | 30.175 | 30.1675 | 30.175 | 7600.0 |
| 2015-11-03 07:50:00 | AAPL | Stock | 30.175 | 30.175 | 30.1675 | 30.175 | 15200.0 |
| 2015-11-03 07:55:00 | AAPL | Stock | 30.185 | 30.185 | 30.1675 | 30.1675 | 8600.0 |
| 2015-11-03 08:00:00 | AAPL | Stock | 30.175 | 30.2 | 30.145 | 30.1825 | 91932.0 |
| 2015-11-03 08:05:00 | AAPL | Stock | 30.1825 | 30.1875 | 30.1675 | 30.175 | 132212.0 |
| 2015-11-03 08:10:00 | AAPL | Stock | 30.165 | 30.175 | 30.155 | 30.155 | 21140.0 |
| 2015-11-03 08:15:00 | AAPL | Stock | 30.1525 | 30.1625 | 30.15 | 30.1625 | 15960.0 |
| 2015-11-03 08:20:00 | AAPL | Stock | 30.1625 | 30.175 | 30.125 | 30.1275 | 57116.0 |
| 2015-11-03 08:25:00 | AAPL | Stock | 30.13 | 30.1525 | 30.1225 | 30.1525 | 57988.0 |
| 2015-11-03 08:30:00 | AAPL | Stock | 30.1625 | 30.1625 | 30.1475 | 30.1625 | 19556.0 |
| 2015-11-03 08:35:00 | AAPL | Stock | 30.1625 | 30.1625 | 30.15 | 30.16 | 40200.0 |
| 2015-11-03 08:40:00 | AAPL | Stock | 30.1525 | 30.1875 | 30.15 | 30.1875 | 54528.0 |
| 2015-11-03 08:45:00 | AAPL | Stock | 30.1925 | 30.1975 | 30.1825 | 30.195 | 23916.0 |
| 2015-11-03 08:50:00 | AAPL | Stock | 30.18 | 30.1975 | 30.1675 | 30.1675 | 45572.0 |
| 2015-11-03 08:55:00 | AAPL | Stock | 30.1725 | 30.175 | 30.1375 | 30.16 | 54188.0 |
| 2015-11-03 09:00:00 | AAPL | Stock | 30.16 | 30.19 | 30.16 | 30.19 | 25604.0 |
| 2015-11-03 09:05:00 | AAPL | Stock | 30.195 | 30.2 | 30.185 | 30.185 | 32520.0 |
| 2015-11-03 09:10:00 | AAPL | Stock | 30.1775 | 30.185 | 30.165 | 30.185 | 38268.0 |
| 2015-11-03 09:15:00 | AAPL | Stock | 30.185 | 30.1875 | 30.1625 | 30.18 | 30620.0 |
| 2015-11-03 09:20:00 | AAPL | Stock | 30.18 | 30.22 | 30.18 | 30.22 | 104992.0 |
| 2015-11-03 09:25:00 | AAPL | Stock | 30.22 | 30.23 | 30.1775 | 30.2 | 52088.0 |
| 2015-11-03 09:30:00 | AAPL | Stock | 30.1975 | 30.2725 | 30.175 | 30.1925 | 4921256.0 |
> showing 50 of 367,322 rows — these rows as CSV