PREVIEW / stock_5min / 2016-05-12
file: by_date/stock_5min/2016/2016-05-12.parquet size: 5.4 MB rows: 356,978 symbols: 3,297
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-05-12 04:00:00 | AAPL | Stock | 23.125 | 23.125 | 23.125 | 23.125 | 1200.0 |
| 2016-05-12 04:20:00 | AAPL | Stock | 23.135 | 23.135 | 23.135 | 23.135 | 400.0 |
| 2016-05-12 04:30:00 | AAPL | Stock | 23.135 | 23.1375 | 23.135 | 23.1375 | 4400.0 |
| 2016-05-12 04:35:00 | AAPL | Stock | 23.1375 | 23.145 | 23.1375 | 23.145 | 6216.0 |
| 2016-05-12 04:50:00 | AAPL | Stock | 23.145 | 23.145 | 23.145 | 23.145 | 4000.0 |
| 2016-05-12 04:55:00 | AAPL | Stock | 23.17 | 23.17 | 23.17 | 23.17 | 1040.0 |
| 2016-05-12 05:05:00 | AAPL | Stock | 23.16 | 23.16 | 23.16 | 23.16 | 480.0 |
| 2016-05-12 05:40:00 | AAPL | Stock | 23.1625 | 23.1625 | 23.1625 | 23.1625 | 528.0 |
| 2016-05-12 05:50:00 | AAPL | Stock | 23.1625 | 23.175 | 23.1625 | 23.175 | 3360.0 |
| 2016-05-12 06:05:00 | AAPL | Stock | 23.1725 | 23.1725 | 23.1725 | 23.1725 | 2928.0 |
| 2016-05-12 06:10:00 | AAPL | Stock | 23.1725 | 23.1725 | 23.1725 | 23.1725 | 672.0 |
| 2016-05-12 06:20:00 | AAPL | Stock | 23.1825 | 23.1825 | 23.1825 | 23.1825 | 400.0 |
| 2016-05-12 06:30:00 | AAPL | Stock | 23.1825 | 23.1825 | 23.1825 | 23.1825 | 400.0 |
| 2016-05-12 06:50:00 | AAPL | Stock | 23.195 | 23.1975 | 23.195 | 23.1975 | 2800.0 |
| 2016-05-12 06:55:00 | AAPL | Stock | 23.2075 | 23.2075 | 23.2075 | 23.2075 | 400.0 |
| 2016-05-12 07:00:00 | AAPL | Stock | 23.1975 | 23.205 | 23.1975 | 23.205 | 6804.0 |
| 2016-05-12 07:05:00 | AAPL | Stock | 23.2025 | 23.2475 | 23.2025 | 23.2475 | 3056.0 |
| 2016-05-12 07:10:00 | AAPL | Stock | 23.205 | 23.205 | 23.1975 | 23.1975 | 6256.0 |
| 2016-05-12 07:15:00 | AAPL | Stock | 23.1875 | 23.1875 | 23.1875 | 23.1875 | 400.0 |
| 2016-05-12 07:20:00 | AAPL | Stock | 23.195 | 23.21 | 23.1875 | 23.19 | 6604.0 |
| 2016-05-12 07:30:00 | AAPL | Stock | 23.195 | 23.195 | 23.195 | 23.195 | 840.0 |
| 2016-05-12 07:35:00 | AAPL | Stock | 23.195 | 23.195 | 23.19 | 23.195 | 16360.0 |
| 2016-05-12 07:40:00 | AAPL | Stock | 23.19 | 23.2025 | 23.19 | 23.2025 | 5200.0 |
| 2016-05-12 07:45:00 | AAPL | Stock | 23.205 | 23.205 | 23.205 | 23.205 | 800.0 |
| 2016-05-12 07:50:00 | AAPL | Stock | 23.1925 | 23.1925 | 23.1725 | 23.175 | 44336.0 |
| 2016-05-12 07:55:00 | AAPL | Stock | 23.1825 | 23.1925 | 23.1825 | 23.1925 | 11884.0 |
| 2016-05-12 08:00:00 | AAPL | Stock | 23.1925 | 23.2 | 23.1625 | 23.1675 | 16536.0 |
| 2016-05-12 08:05:00 | AAPL | Stock | 23.1675 | 23.1675 | 23.145 | 23.1525 | 34832.0 |
| 2016-05-12 08:10:00 | AAPL | Stock | 23.155 | 23.1625 | 23.155 | 23.155 | 8268.0 |
| 2016-05-12 08:15:00 | AAPL | Stock | 23.16 | 23.1625 | 23.16 | 23.1625 | 2552.0 |
| 2016-05-12 08:20:00 | AAPL | Stock | 23.1625 | 23.1625 | 23.1525 | 23.1525 | 12740.0 |
| 2016-05-12 08:25:00 | AAPL | Stock | 23.165 | 23.165 | 23.1625 | 23.1625 | 1200.0 |
| 2016-05-12 08:30:00 | AAPL | Stock | 23.165 | 23.1675 | 23.16 | 23.1675 | 18228.0 |
| 2016-05-12 08:35:00 | AAPL | Stock | 23.1675 | 23.1725 | 23.165 | 23.1725 | 6444.0 |
| 2016-05-12 08:40:00 | AAPL | Stock | 23.175 | 23.175 | 23.1625 | 23.1625 | 12168.0 |
| 2016-05-12 08:45:00 | AAPL | Stock | 23.1625 | 23.1675 | 23.16 | 23.16 | 4128.0 |
| 2016-05-12 08:50:00 | AAPL | Stock | 23.16 | 23.1675 | 23.16 | 23.16 | 2700.0 |
| 2016-05-12 08:55:00 | AAPL | Stock | 23.16 | 23.1625 | 23.16 | 23.1625 | 1208.0 |
| 2016-05-12 09:00:00 | AAPL | Stock | 23.1625 | 23.1625 | 23.1375 | 23.15 | 42628.0 |
| 2016-05-12 09:05:00 | AAPL | Stock | 23.15 | 23.1575 | 23.1475 | 23.15 | 33992.0 |
| 2016-05-12 09:10:00 | AAPL | Stock | 23.1475 | 23.1475 | 23.1325 | 23.1325 | 29828.0 |
| 2016-05-12 09:15:00 | AAPL | Stock | 23.1325 | 23.14 | 23.1 | 23.1 | 34888.0 |
| 2016-05-12 09:20:00 | AAPL | Stock | 23.1 | 23.1075 | 23.07 | 23.0925 | 66296.0 |
| 2016-05-12 09:25:00 | AAPL | Stock | 23.0875 | 23.2 | 23.0775 | 23.1925 | 371932.0 |
| 2016-05-12 09:30:00 | AAPL | Stock | 23.1925 | 23.195 | 23.0125 | 23.035 | 7699192.0 |
| 2016-05-12 09:35:00 | AAPL | Stock | 23.035 | 23.0575 | 22.97 | 23.0062 | 5670424.0 |
| 2016-05-12 09:40:00 | AAPL | Stock | 23.005 | 23.0175 | 22.88 | 22.8875 | 6359928.0 |
| 2016-05-12 09:45:00 | AAPL | Stock | 22.885 | 22.9125 | 22.825 | 22.8625 | 7782876.0 |
| 2016-05-12 09:50:00 | AAPL | Stock | 22.862 | 22.9 | 22.78 | 22.7825 | 5571964.0 |
| 2016-05-12 09:55:00 | AAPL | Stock | 22.78 | 22.7825 | 22.7125 | 22.735 | 7599172.0 |
> showing 50 of 356,978 rows — these rows as CSV