PREVIEW / stock_5min / 2017-06-19
file: by_date/stock_5min/2017/2017-06-19.parquet size: 5.4 MB rows: 355,941 symbols: 3,032
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-06-19 04:00:00 | AAPL | Stock | 35.775 | 35.8875 | 35.775 | 35.8875 | 4292.0 |
| 2017-06-19 04:15:00 | AAPL | Stock | 35.825 | 35.85 | 35.825 | 35.85 | 4400.0 |
| 2017-06-19 04:50:00 | AAPL | Stock | 35.9 | 35.9225 | 35.9 | 35.9225 | 1056.0 |
| 2017-06-19 04:55:00 | AAPL | Stock | 35.945 | 35.945 | 35.945 | 35.945 | 400.0 |
| 2017-06-19 05:15:00 | AAPL | Stock | 35.95 | 35.95 | 35.95 | 35.95 | 1796.0 |
| 2017-06-19 05:25:00 | AAPL | Stock | 35.95 | 35.95 | 35.95 | 35.95 | 3884.0 |
| 2017-06-19 05:30:00 | AAPL | Stock | 35.95 | 35.95 | 35.9225 | 35.9225 | 1876.0 |
| 2017-06-19 05:40:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 400.0 |
| 2017-06-19 05:50:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 600.0 |
| 2017-06-19 05:55:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 400.0 |
| 2017-06-19 06:00:00 | AAPL | Stock | 35.915 | 35.9375 | 35.85 | 35.9375 | 18124.0 |
| 2017-06-19 06:05:00 | AAPL | Stock | 35.9375 | 35.95 | 35.9375 | 35.95 | 2656.0 |
| 2017-06-19 06:10:00 | AAPL | Stock | 35.94 | 35.94 | 35.9375 | 35.9375 | 15200.0 |
| 2017-06-19 06:15:00 | AAPL | Stock | 35.9375 | 35.9375 | 35.925 | 35.925 | 15200.0 |
| 2017-06-19 06:20:00 | AAPL | Stock | 35.955 | 35.955 | 35.955 | 35.955 | 3480.0 |
| 2017-06-19 06:40:00 | AAPL | Stock | 35.9225 | 35.9225 | 35.88 | 35.9 | 16000.0 |
| 2017-06-19 06:55:00 | AAPL | Stock | 35.9 | 35.9 | 35.9 | 35.9 | 4200.0 |
| 2017-06-19 07:00:00 | AAPL | Stock | 35.89 | 35.9 | 35.89 | 35.8925 | 9840.0 |
| 2017-06-19 07:05:00 | AAPL | Stock | 35.9125 | 35.9125 | 35.895 | 35.895 | 4800.0 |
| 2017-06-19 07:10:00 | AAPL | Stock | 35.895 | 35.9075 | 35.895 | 35.895 | 6000.0 |
| 2017-06-19 07:15:00 | AAPL | Stock | 35.89 | 35.8975 | 35.8875 | 35.8875 | 5580.0 |
| 2017-06-19 07:20:00 | AAPL | Stock | 35.8875 | 35.8875 | 35.875 | 35.875 | 8968.0 |
| 2017-06-19 07:25:00 | AAPL | Stock | 35.8875 | 35.8875 | 35.88 | 35.88 | 6764.0 |
| 2017-06-19 07:30:00 | AAPL | Stock | 35.875 | 35.875 | 35.86 | 35.86 | 4680.0 |
| 2017-06-19 07:35:00 | AAPL | Stock | 35.875 | 35.875 | 35.86 | 35.8725 | 9088.0 |
| 2017-06-19 07:45:00 | AAPL | Stock | 35.87 | 35.875 | 35.8625 | 35.875 | 4400.0 |
| 2017-06-19 07:50:00 | AAPL | Stock | 35.875 | 35.9125 | 35.875 | 35.9125 | 8756.0 |
| 2017-06-19 07:55:00 | AAPL | Stock | 35.9125 | 35.915 | 35.9125 | 35.915 | 10388.0 |
| 2017-06-19 08:00:00 | AAPL | Stock | 35.9125 | 35.9375 | 35.875 | 35.9275 | 89904.0 |
| 2017-06-19 08:05:00 | AAPL | Stock | 35.925 | 35.95 | 35.925 | 35.95 | 70804.0 |
| 2017-06-19 08:10:00 | AAPL | Stock | 35.9275 | 35.9475 | 35.9275 | 35.9425 | 7000.0 |
| 2017-06-19 08:15:00 | AAPL | Stock | 35.94 | 35.9525 | 35.9375 | 35.9475 | 50712.0 |
| 2017-06-19 08:20:00 | AAPL | Stock | 35.9475 | 35.965 | 35.9475 | 35.96 | 55612.0 |
| 2017-06-19 08:25:00 | AAPL | Stock | 35.9625 | 35.9625 | 35.9325 | 35.95 | 26700.0 |
| 2017-06-19 08:30:00 | AAPL | Stock | 35.95 | 35.95 | 35.935 | 35.9375 | 12764.0 |
| 2017-06-19 08:35:00 | AAPL | Stock | 35.9375 | 35.9375 | 35.925 | 35.9275 | 22384.0 |
| 2017-06-19 08:40:00 | AAPL | Stock | 35.9275 | 35.9275 | 35.875 | 35.905 | 55048.0 |
| 2017-06-19 08:45:00 | AAPL | Stock | 35.91 | 35.9125 | 35.9 | 35.9125 | 29008.0 |
| 2017-06-19 08:50:00 | AAPL | Stock | 35.91 | 35.91 | 35.84 | 35.84 | 137688.0 |
| 2017-06-19 08:55:00 | AAPL | Stock | 35.8725 | 35.8725 | 35.85 | 35.85 | 14308.0 |
| 2017-06-19 09:00:00 | AAPL | Stock | 35.8625 | 35.8725 | 35.8525 | 35.8625 | 4464.0 |
| 2017-06-19 09:05:00 | AAPL | Stock | 35.87 | 35.9075 | 35.87 | 35.9025 | 60392.0 |
| 2017-06-19 09:10:00 | AAPL | Stock | 35.91 | 35.92 | 35.9 | 35.9075 | 170916.0 |
| 2017-06-19 09:15:00 | AAPL | Stock | 35.905 | 35.925 | 35.905 | 35.9125 | 12400.0 |
| 2017-06-19 09:20:00 | AAPL | Stock | 35.9 | 35.92 | 35.9 | 35.9125 | 43848.0 |
| 2017-06-19 09:25:00 | AAPL | Stock | 35.92 | 36.0775 | 35.9125 | 35.9975 | 357084.0 |
| 2017-06-19 09:30:00 | AAPL | Stock | 35.9975 | 36.07 | 35.915 | 36.0 | 5940044.0 |
| 2017-06-19 09:35:00 | AAPL | Stock | 36.0 | 36.1975 | 35.9925 | 36.185 | 4401372.0 |
| 2017-06-19 09:40:00 | AAPL | Stock | 36.185 | 36.2 | 36.135 | 36.1538 | 3146712.0 |
| 2017-06-19 09:45:00 | AAPL | Stock | 36.1525 | 36.175 | 36.1 | 36.1275 | 2393576.0 |
> showing 50 of 355,941 rows — these rows as CSV