PREVIEW / stock_5min / 2017-10-11
file: by_date/stock_5min/2017/2017-10-11.parquet size: 5.4 MB rows: 351,117 symbols: 2,954
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-10-11 04:10:00 | AAPL | Stock | 38.945 | 38.945 | 38.945 | 38.945 | 796.0 |
| 2017-10-11 04:35:00 | AAPL | Stock | 38.9 | 38.925 | 38.9 | 38.925 | 6692.0 |
| 2017-10-11 05:15:00 | AAPL | Stock | 38.925 | 38.925 | 38.925 | 38.925 | 2000.0 |
| 2017-10-11 05:55:00 | AAPL | Stock | 38.945 | 38.945 | 38.945 | 38.945 | 800.0 |
| 2017-10-11 06:10:00 | AAPL | Stock | 38.955 | 38.955 | 38.955 | 38.955 | 400.0 |
| 2017-10-11 06:20:00 | AAPL | Stock | 38.95 | 38.95 | 38.95 | 38.95 | 400.0 |
| 2017-10-11 06:30:00 | AAPL | Stock | 38.95 | 38.95 | 38.95 | 38.95 | 1200.0 |
| 2017-10-11 06:45:00 | AAPL | Stock | 38.905 | 38.905 | 38.9 | 38.9 | 41000.0 |
| 2017-10-11 07:00:00 | AAPL | Stock | 38.9375 | 38.9625 | 38.9375 | 38.95 | 20324.0 |
| 2017-10-11 07:05:00 | AAPL | Stock | 38.9525 | 38.97 | 38.9525 | 38.97 | 7600.0 |
| 2017-10-11 07:15:00 | AAPL | Stock | 38.9525 | 38.9525 | 38.9525 | 38.9525 | 400.0 |
| 2017-10-11 07:20:00 | AAPL | Stock | 38.9625 | 38.97 | 38.95 | 38.95 | 10400.0 |
| 2017-10-11 07:25:00 | AAPL | Stock | 38.95 | 38.95 | 38.95 | 38.95 | 8000.0 |
| 2017-10-11 07:30:00 | AAPL | Stock | 38.95 | 38.95 | 38.9375 | 38.9375 | 10400.0 |
| 2017-10-11 07:40:00 | AAPL | Stock | 38.9175 | 38.9275 | 38.9175 | 38.925 | 4000.0 |
| 2017-10-11 07:45:00 | AAPL | Stock | 38.9125 | 38.9125 | 38.9125 | 38.9125 | 800.0 |
| 2017-10-11 07:50:00 | AAPL | Stock | 38.9125 | 38.9125 | 38.9125 | 38.9125 | 2424.0 |
| 2017-10-11 08:00:00 | AAPL | Stock | 38.95 | 39.055 | 38.9125 | 39.055 | 46376.0 |
| 2017-10-11 08:05:00 | AAPL | Stock | 38.925 | 38.95 | 38.925 | 38.95 | 5188.0 |
| 2017-10-11 08:10:00 | AAPL | Stock | 38.95 | 38.9675 | 38.95 | 38.9675 | 5400.0 |
| 2017-10-11 08:15:00 | AAPL | Stock | 38.945 | 38.9725 | 38.945 | 38.95 | 11084.0 |
| 2017-10-11 08:20:00 | AAPL | Stock | 38.955 | 38.955 | 38.945 | 38.945 | 6000.0 |
| 2017-10-11 08:25:00 | AAPL | Stock | 38.945 | 38.9525 | 38.945 | 38.945 | 5200.0 |
| 2017-10-11 08:30:00 | AAPL | Stock | 38.9675 | 38.975 | 38.9675 | 38.975 | 2000.0 |
| 2017-10-11 08:35:00 | AAPL | Stock | 38.99 | 39.0 | 38.965 | 38.97 | 14800.0 |
| 2017-10-11 08:40:00 | AAPL | Stock | 38.9725 | 38.9725 | 38.95 | 38.95 | 9204.0 |
| 2017-10-11 08:45:00 | AAPL | Stock | 38.95 | 38.9625 | 38.95 | 38.9625 | 3700.0 |
| 2017-10-11 08:50:00 | AAPL | Stock | 38.955 | 38.9725 | 38.955 | 38.965 | 8600.0 |
| 2017-10-11 08:55:00 | AAPL | Stock | 38.9625 | 38.9725 | 38.9625 | 38.9725 | 9192.0 |
| 2017-10-11 09:00:00 | AAPL | Stock | 38.9725 | 38.98 | 38.9725 | 38.98 | 20396.0 |
| 2017-10-11 09:05:00 | AAPL | Stock | 38.975 | 38.9875 | 38.9725 | 38.9875 | 5000.0 |
| 2017-10-11 09:10:00 | AAPL | Stock | 38.9775 | 39.0 | 38.9775 | 39.0 | 6412.0 |
| 2017-10-11 09:15:00 | AAPL | Stock | 39.0 | 39.0125 | 38.9975 | 39.0125 | 8512.0 |
| 2017-10-11 09:20:00 | AAPL | Stock | 39.0 | 39.0175 | 39.0 | 39.0175 | 5860.0 |
| 2017-10-11 09:25:00 | AAPL | Stock | 39.0175 | 39.0175 | 38.965 | 38.965 | 34220.0 |
| 2017-10-11 09:30:00 | AAPL | Stock | 38.9925 | 39.08 | 38.9738 | 39.015 | 2593228.0 |
| 2017-10-11 09:35:00 | AAPL | Stock | 39.02 | 39.0425 | 38.9375 | 38.9375 | 1657956.0 |
| 2017-10-11 09:40:00 | AAPL | Stock | 38.9425 | 39.0125 | 38.9375 | 39.0025 | 1110408.0 |
| 2017-10-11 09:45:00 | AAPL | Stock | 39.0025 | 39.0175 | 38.975 | 38.9875 | 647636.0 |
| 2017-10-11 09:50:00 | AAPL | Stock | 38.9875 | 39.0 | 38.9375 | 38.9675 | 826936.0 |
| 2017-10-11 09:55:00 | AAPL | Stock | 38.967 | 39.07 | 38.9575 | 39.055 | 1440268.0 |
| 2017-10-11 10:00:00 | AAPL | Stock | 39.0575 | 39.1125 | 39.05 | 39.1025 | 1398228.0 |
| 2017-10-11 10:05:00 | AAPL | Stock | 39.1075 | 39.1725 | 39.0878 | 39.1688 | 2200672.0 |
| 2017-10-11 10:10:00 | AAPL | Stock | 39.1688 | 39.245 | 39.155 | 39.2165 | 2115688.0 |
| 2017-10-11 10:15:00 | AAPL | Stock | 39.2162 | 39.2175 | 39.1575 | 39.205 | 1214096.0 |
| 2017-10-11 10:20:00 | AAPL | Stock | 39.205 | 39.2325 | 39.185 | 39.2 | 1114196.0 |
| 2017-10-11 10:25:00 | AAPL | Stock | 39.2 | 39.2325 | 39.19 | 39.1918 | 1159696.0 |
| 2017-10-11 10:30:00 | AAPL | Stock | 39.195 | 39.235 | 39.1725 | 39.205 | 827680.0 |
| 2017-10-11 10:35:00 | AAPL | Stock | 39.2025 | 39.2075 | 39.1225 | 39.1375 | 1242216.0 |
| 2017-10-11 10:40:00 | AAPL | Stock | 39.1375 | 39.1675 | 39.1325 | 39.165 | 707016.0 |
> showing 50 of 351,117 rows — these rows as CSV