PREVIEW / stock_5min / 2016-08-09
file: by_date/stock_5min/2016/2016-08-09.parquet size: 5.4 MB rows: 353,503 symbols: 3,250
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-08-09 04:00:00 | AAPL | Stock | 27.1025 | 27.1025 | 27.1025 | 27.1025 | 400.0 |
| 2016-08-09 04:15:00 | AAPL | Stock | 27.0975 | 27.0975 | 27.0975 | 27.0975 | 3348.0 |
| 2016-08-09 05:05:00 | AAPL | Stock | 27.125 | 27.1275 | 27.125 | 27.1275 | 4680.0 |
| 2016-08-09 05:40:00 | AAPL | Stock | 27.1475 | 27.1475 | 27.135 | 27.135 | 1172.0 |
| 2016-08-09 06:00:00 | AAPL | Stock | 27.135 | 27.135 | 27.135 | 27.135 | 400.0 |
| 2016-08-09 06:05:00 | AAPL | Stock | 27.135 | 27.135 | 27.135 | 27.135 | 1520.0 |
| 2016-08-09 06:15:00 | AAPL | Stock | 27.145 | 27.145 | 27.145 | 27.145 | 400.0 |
| 2016-08-09 06:20:00 | AAPL | Stock | 27.145 | 27.145 | 27.145 | 27.145 | 2340.0 |
| 2016-08-09 06:50:00 | AAPL | Stock | 27.1475 | 27.1475 | 27.1475 | 27.1475 | 524.0 |
| 2016-08-09 06:55:00 | AAPL | Stock | 27.1475 | 27.1575 | 27.1475 | 27.1575 | 976.0 |
| 2016-08-09 07:00:00 | AAPL | Stock | 27.1475 | 27.1475 | 27.1475 | 27.1475 | 7160.0 |
| 2016-08-09 07:05:00 | AAPL | Stock | 27.15 | 27.1525 | 27.15 | 27.15 | 3200.0 |
| 2016-08-09 07:10:00 | AAPL | Stock | 27.1625 | 27.1625 | 27.15 | 27.15 | 6000.0 |
| 2016-08-09 07:15:00 | AAPL | Stock | 27.1625 | 27.1625 | 27.1625 | 27.1625 | 2840.0 |
| 2016-08-09 07:20:00 | AAPL | Stock | 27.1525 | 27.155 | 27.1525 | 27.1525 | 28600.0 |
| 2016-08-09 07:25:00 | AAPL | Stock | 27.16 | 27.1625 | 27.16 | 27.16 | 4916.0 |
| 2016-08-09 07:30:00 | AAPL | Stock | 27.1525 | 27.1525 | 27.15 | 27.15 | 2000.0 |
| 2016-08-09 07:35:00 | AAPL | Stock | 27.15 | 27.155 | 27.1375 | 27.1375 | 6164.0 |
| 2016-08-09 07:40:00 | AAPL | Stock | 27.1475 | 27.15 | 27.1475 | 27.1475 | 12160.0 |
| 2016-08-09 07:45:00 | AAPL | Stock | 27.1325 | 27.1325 | 27.1325 | 27.1325 | 400.0 |
| 2016-08-09 07:50:00 | AAPL | Stock | 27.13 | 27.1375 | 27.13 | 27.1375 | 2940.0 |
| 2016-08-09 08:00:00 | AAPL | Stock | 27.1475 | 27.1625 | 27.13 | 27.15 | 80776.0 |
| 2016-08-09 08:05:00 | AAPL | Stock | 27.15 | 27.1575 | 27.15 | 27.15 | 7616.0 |
| 2016-08-09 08:10:00 | AAPL | Stock | 27.15 | 27.15 | 27.1475 | 27.1475 | 3200.0 |
| 2016-08-09 08:15:00 | AAPL | Stock | 27.145 | 27.145 | 27.135 | 27.135 | 37388.0 |
| 2016-08-09 08:20:00 | AAPL | Stock | 27.135 | 27.135 | 27.125 | 27.125 | 53240.0 |
| 2016-08-09 08:25:00 | AAPL | Stock | 27.125 | 27.125 | 27.125 | 27.125 | 1700.0 |
| 2016-08-09 08:30:00 | AAPL | Stock | 27.125 | 27.14 | 27.1125 | 27.115 | 34644.0 |
| 2016-08-09 08:35:00 | AAPL | Stock | 27.115 | 27.115 | 27.105 | 27.1075 | 64144.0 |
| 2016-08-09 08:40:00 | AAPL | Stock | 27.1075 | 27.1075 | 27.0775 | 27.0775 | 60784.0 |
| 2016-08-09 08:45:00 | AAPL | Stock | 27.08 | 27.0875 | 27.0475 | 27.065 | 73492.0 |
| 2016-08-09 08:50:00 | AAPL | Stock | 27.06 | 27.06 | 27.025 | 27.06 | 72604.0 |
| 2016-08-09 08:55:00 | AAPL | Stock | 27.06 | 27.06 | 27.0225 | 27.0375 | 19392.0 |
| 2016-08-09 09:00:00 | AAPL | Stock | 27.0375 | 27.045 | 27.025 | 27.0425 | 30188.0 |
| 2016-08-09 09:05:00 | AAPL | Stock | 27.0375 | 27.04 | 27.035 | 27.0375 | 7052.0 |
| 2016-08-09 09:10:00 | AAPL | Stock | 27.0425 | 27.0475 | 27.035 | 27.0475 | 32188.0 |
| 2016-08-09 09:15:00 | AAPL | Stock | 27.0375 | 27.0375 | 27.03 | 27.03 | 9600.0 |
| 2016-08-09 09:20:00 | AAPL | Stock | 27.03 | 27.04 | 27.025 | 27.0375 | 41204.0 |
| 2016-08-09 09:25:00 | AAPL | Stock | 27.0375 | 27.0775 | 27.035 | 27.055 | 50028.0 |
| 2016-08-09 09:30:00 | AAPL | Stock | 27.055 | 27.125 | 27.045 | 27.11 | 4588716.0 |
| 2016-08-09 09:35:00 | AAPL | Stock | 27.1138 | 27.1275 | 27.07 | 27.1175 | 2646276.0 |
| 2016-08-09 09:40:00 | AAPL | Stock | 27.1175 | 27.15 | 27.0975 | 27.11 | 2507244.0 |
| 2016-08-09 09:45:00 | AAPL | Stock | 27.1075 | 27.12 | 27.085 | 27.1075 | 1947536.0 |
| 2016-08-09 09:50:00 | AAPL | Stock | 27.11 | 27.11 | 27.0675 | 27.095 | 1866572.0 |
| 2016-08-09 09:55:00 | AAPL | Stock | 27.0958 | 27.0975 | 27.0425 | 27.0475 | 1717016.0 |
| 2016-08-09 10:00:00 | AAPL | Stock | 27.0462 | 27.08 | 27.0375 | 27.0575 | 2062332.0 |
| 2016-08-09 10:05:00 | AAPL | Stock | 27.0588 | 27.0775 | 27.04 | 27.0675 | 1160092.0 |
| 2016-08-09 10:10:00 | AAPL | Stock | 27.07 | 27.0875 | 27.0525 | 27.0528 | 1220672.0 |
| 2016-08-09 10:15:00 | AAPL | Stock | 27.0525 | 27.0775 | 27.045 | 27.0475 | 1438600.0 |
| 2016-08-09 10:20:00 | AAPL | Stock | 27.0488 | 27.06 | 27.02 | 27.0588 | 2243776.0 |
> showing 50 of 353,503 rows — these rows as CSV