PREVIEW / stock_5min / 2014-12-19
file: by_date/stock_5min/2014/2014-12-19.parquet size: 5.9 MB rows: 389,295 symbols: 3,579
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-19 04:00:00 | AAPL | Stock | 28.1375 | 28.25 | 28.1375 | 28.25 | 9200.0 |
| 2014-12-19 04:05:00 | AAPL | Stock | 28.2875 | 28.3 | 28.2875 | 28.3 | 1600.0 |
| 2014-12-19 04:10:00 | AAPL | Stock | 28.2975 | 28.2975 | 28.2975 | 28.2975 | 400.0 |
| 2014-12-19 04:15:00 | AAPL | Stock | 28.2975 | 28.2975 | 28.2975 | 28.2975 | 1200.0 |
| 2014-12-19 04:20:00 | AAPL | Stock | 28.2975 | 28.3 | 28.2975 | 28.3 | 3212.0 |
| 2014-12-19 04:25:00 | AAPL | Stock | 28.3225 | 28.3375 | 28.3225 | 28.3275 | 7820.0 |
| 2014-12-19 04:30:00 | AAPL | Stock | 28.3375 | 28.3375 | 28.3375 | 28.3375 | 400.0 |
| 2014-12-19 04:50:00 | AAPL | Stock | 28.315 | 28.315 | 28.315 | 28.315 | 1000.0 |
| 2014-12-19 04:55:00 | AAPL | Stock | 28.33 | 28.33 | 28.33 | 28.33 | 800.0 |
| 2014-12-19 05:05:00 | AAPL | Stock | 28.315 | 28.315 | 28.315 | 28.315 | 716.0 |
| 2014-12-19 05:10:00 | AAPL | Stock | 28.3475 | 28.3475 | 28.305 | 28.31 | 4604.0 |
| 2014-12-19 05:20:00 | AAPL | Stock | 28.3125 | 28.3125 | 28.31 | 28.31 | 4800.0 |
| 2014-12-19 05:35:00 | AAPL | Stock | 28.29 | 28.29 | 28.29 | 28.29 | 1600.0 |
| 2014-12-19 05:40:00 | AAPL | Stock | 28.2825 | 28.2825 | 28.2825 | 28.2825 | 600.0 |
| 2014-12-19 05:45:00 | AAPL | Stock | 28.26 | 28.26 | 28.25 | 28.25 | 3600.0 |
| 2014-12-19 05:50:00 | AAPL | Stock | 28.25 | 28.25 | 28.25 | 28.25 | 800.0 |
| 2014-12-19 05:55:00 | AAPL | Stock | 28.28 | 28.28 | 28.28 | 28.28 | 800.0 |
| 2014-12-19 06:00:00 | AAPL | Stock | 28.25 | 28.25 | 28.25 | 28.25 | 400.0 |
| 2014-12-19 06:05:00 | AAPL | Stock | 28.2675 | 28.2675 | 28.2475 | 28.2575 | 3600.0 |
| 2014-12-19 06:15:00 | AAPL | Stock | 28.2675 | 28.2675 | 28.25 | 28.25 | 23960.0 |
| 2014-12-19 06:20:00 | AAPL | Stock | 28.25 | 28.25 | 28.25 | 28.25 | 2800.0 |
| 2014-12-19 06:30:00 | AAPL | Stock | 28.275 | 28.275 | 28.2375 | 28.2375 | 13068.0 |
| 2014-12-19 06:35:00 | AAPL | Stock | 28.245 | 28.245 | 28.245 | 28.245 | 2800.0 |
| 2014-12-19 06:40:00 | AAPL | Stock | 28.2375 | 28.2375 | 28.2225 | 28.2225 | 11548.0 |
| 2014-12-19 06:45:00 | AAPL | Stock | 28.225 | 28.225 | 28.2225 | 28.225 | 8492.0 |
| 2014-12-19 06:50:00 | AAPL | Stock | 28.225 | 28.225 | 28.225 | 28.225 | 1600.0 |
| 2014-12-19 07:00:00 | AAPL | Stock | 28.2375 | 28.2875 | 28.2375 | 28.25 | 35216.0 |
| 2014-12-19 07:05:00 | AAPL | Stock | 28.2475 | 28.25 | 28.2475 | 28.25 | 12168.0 |
| 2014-12-19 07:10:00 | AAPL | Stock | 28.25 | 28.25 | 28.25 | 28.25 | 1300.0 |
| 2014-12-19 07:15:00 | AAPL | Stock | 28.25 | 28.25 | 28.25 | 28.25 | 2200.0 |
| 2014-12-19 07:20:00 | AAPL | Stock | 28.2625 | 28.2625 | 28.2625 | 28.2625 | 4000.0 |
| 2014-12-19 07:25:00 | AAPL | Stock | 28.2525 | 28.26 | 28.2525 | 28.26 | 5200.0 |
| 2014-12-19 07:30:00 | AAPL | Stock | 28.2625 | 28.295 | 28.26 | 28.295 | 12020.0 |
| 2014-12-19 07:35:00 | AAPL | Stock | 28.3 | 28.3125 | 28.3 | 28.3125 | 26776.0 |
| 2014-12-19 07:40:00 | AAPL | Stock | 28.3025 | 28.3025 | 28.3 | 28.3 | 15760.0 |
| 2014-12-19 07:45:00 | AAPL | Stock | 28.28 | 28.2975 | 28.28 | 28.2975 | 1800.0 |
| 2014-12-19 07:50:00 | AAPL | Stock | 28.2875 | 28.3 | 28.275 | 28.2775 | 58220.0 |
| 2014-12-19 07:55:00 | AAPL | Stock | 28.265 | 28.265 | 28.2375 | 28.2375 | 72724.0 |
| 2014-12-19 08:00:00 | AAPL | Stock | 28.235 | 28.3125 | 28.2225 | 28.2428 | 176188.0 |
| 2014-12-19 08:05:00 | AAPL | Stock | 28.2475 | 28.25 | 28.2375 | 28.25 | 121140.0 |
| 2014-12-19 08:10:00 | AAPL | Stock | 28.255 | 28.275 | 28.25 | 28.275 | 79120.0 |
| 2014-12-19 08:15:00 | AAPL | Stock | 28.2725 | 28.275 | 28.2425 | 28.25 | 37336.0 |
| 2014-12-19 08:20:00 | AAPL | Stock | 28.245 | 28.255 | 28.245 | 28.255 | 28580.0 |
| 2014-12-19 08:25:00 | AAPL | Stock | 28.255 | 28.275 | 28.2525 | 28.2625 | 8584.0 |
| 2014-12-19 08:30:00 | AAPL | Stock | 28.2625 | 28.275 | 28.245 | 28.245 | 93328.0 |
| 2014-12-19 08:35:00 | AAPL | Stock | 28.2575 | 28.2575 | 28.235 | 28.2375 | 61884.0 |
| 2014-12-19 08:40:00 | AAPL | Stock | 28.2375 | 28.2375 | 28.1875 | 28.2 | 111752.0 |
| 2014-12-19 08:45:00 | AAPL | Stock | 28.2125 | 28.2125 | 28.175 | 28.175 | 103840.0 |
| 2014-12-19 08:50:00 | AAPL | Stock | 28.175 | 28.175 | 28.1525 | 28.1725 | 58476.0 |
| 2014-12-19 08:55:00 | AAPL | Stock | 28.1725 | 28.1975 | 28.1725 | 28.195 | 35716.0 |
> showing 50 of 389,295 rows — these rows as CSV