PREVIEW / stock_5min / 2015-01-14
file: by_date/stock_5min/2015/2015-01-14.parquet size: 5.5 MB rows: 366,983 symbols: 3,535
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-14 04:00:00 | AAPL | Stock | 27.5425 | 27.5425 | 27.4275 | 27.4725 | 5008.0 |
| 2015-01-14 04:10:00 | AAPL | Stock | 27.475 | 27.475 | 27.475 | 27.475 | 400.0 |
| 2015-01-14 04:35:00 | AAPL | Stock | 27.5125 | 27.5125 | 27.4275 | 27.4275 | 10000.0 |
| 2015-01-14 04:40:00 | AAPL | Stock | 27.42 | 27.42 | 27.42 | 27.42 | 400.0 |
| 2015-01-14 04:50:00 | AAPL | Stock | 27.5 | 27.51 | 27.5 | 27.51 | 800.0 |
| 2015-01-14 04:55:00 | AAPL | Stock | 27.51 | 27.545 | 27.51 | 27.545 | 6800.0 |
| 2015-01-14 05:00:00 | AAPL | Stock | 27.5675 | 27.625 | 27.55 | 27.55 | 12140.0 |
| 2015-01-14 05:05:00 | AAPL | Stock | 27.6275 | 27.675 | 27.625 | 27.64 | 2008.0 |
| 2015-01-14 05:15:00 | AAPL | Stock | 27.625 | 27.625 | 27.625 | 27.625 | 724.0 |
| 2015-01-14 05:25:00 | AAPL | Stock | 27.6225 | 27.6225 | 27.55 | 27.55 | 6800.0 |
| 2015-01-14 05:40:00 | AAPL | Stock | 27.6225 | 27.625 | 27.6225 | 27.625 | 4000.0 |
| 2015-01-14 05:45:00 | AAPL | Stock | 27.625 | 27.625 | 27.585 | 27.585 | 5600.0 |
| 2015-01-14 05:50:00 | AAPL | Stock | 27.55 | 27.55 | 27.55 | 27.55 | 1200.0 |
| 2015-01-14 06:00:00 | AAPL | Stock | 27.5625 | 27.6175 | 27.5625 | 27.5875 | 7348.0 |
| 2015-01-14 06:05:00 | AAPL | Stock | 27.58 | 27.58 | 27.58 | 27.58 | 532.0 |
| 2015-01-14 06:10:00 | AAPL | Stock | 27.5625 | 27.5625 | 27.5475 | 27.5475 | 1280.0 |
| 2015-01-14 06:35:00 | AAPL | Stock | 27.56 | 27.56 | 27.56 | 27.56 | 1320.0 |
| 2015-01-14 06:45:00 | AAPL | Stock | 27.56 | 27.56 | 27.56 | 27.56 | 400.0 |
| 2015-01-14 06:50:00 | AAPL | Stock | 27.585 | 27.5875 | 27.585 | 27.5875 | 2000.0 |
| 2015-01-14 07:00:00 | AAPL | Stock | 27.5525 | 27.5525 | 27.525 | 27.525 | 18800.0 |
| 2015-01-14 07:05:00 | AAPL | Stock | 27.525 | 27.535 | 27.5075 | 27.5075 | 14200.0 |
| 2015-01-14 07:10:00 | AAPL | Stock | 27.51 | 27.5125 | 27.48 | 27.4875 | 12960.0 |
| 2015-01-14 07:15:00 | AAPL | Stock | 27.525 | 27.525 | 27.5 | 27.52 | 14400.0 |
| 2015-01-14 07:20:00 | AAPL | Stock | 27.5125 | 27.5125 | 27.5125 | 27.5125 | 744.0 |
| 2015-01-14 07:25:00 | AAPL | Stock | 27.5025 | 27.5025 | 27.4775 | 27.4875 | 7560.0 |
| 2015-01-14 07:30:00 | AAPL | Stock | 27.495 | 27.495 | 27.4525 | 27.4525 | 11036.0 |
| 2015-01-14 07:35:00 | AAPL | Stock | 27.445 | 27.45 | 27.4425 | 27.45 | 22000.0 |
| 2015-01-14 07:40:00 | AAPL | Stock | 27.475 | 27.475 | 27.475 | 27.475 | 4000.0 |
| 2015-01-14 07:45:00 | AAPL | Stock | 27.475 | 27.475 | 27.475 | 27.475 | 2800.0 |
| 2015-01-14 07:50:00 | AAPL | Stock | 27.475 | 27.475 | 27.435 | 27.45 | 34580.0 |
| 2015-01-14 07:55:00 | AAPL | Stock | 27.45 | 27.4625 | 27.45 | 27.4625 | 2000.0 |
| 2015-01-14 08:00:00 | AAPL | Stock | 27.4725 | 27.5225 | 27.4 | 27.43 | 224520.0 |
| 2015-01-14 08:05:00 | AAPL | Stock | 27.4375 | 27.4625 | 27.43 | 27.46 | 43040.0 |
| 2015-01-14 08:10:00 | AAPL | Stock | 27.46 | 27.4625 | 27.435 | 27.4625 | 73592.0 |
| 2015-01-14 08:15:00 | AAPL | Stock | 27.44 | 27.4475 | 27.415 | 27.415 | 42480.0 |
| 2015-01-14 08:20:00 | AAPL | Stock | 27.4325 | 27.4425 | 27.4 | 27.4025 | 33636.0 |
| 2015-01-14 08:25:00 | AAPL | Stock | 27.4 | 27.425 | 27.3925 | 27.405 | 54028.0 |
| 2015-01-14 08:30:00 | AAPL | Stock | 27.405 | 27.4075 | 27.29 | 27.3025 | 520284.0 |
| 2015-01-14 08:35:00 | AAPL | Stock | 27.3 | 27.3 | 27.2225 | 27.255 | 454500.0 |
| 2015-01-14 08:40:00 | AAPL | Stock | 27.255 | 27.295 | 27.255 | 27.275 | 84788.0 |
| 2015-01-14 08:45:00 | AAPL | Stock | 27.275 | 27.2875 | 27.225 | 27.225 | 210296.0 |
| 2015-01-14 08:50:00 | AAPL | Stock | 27.225 | 27.245 | 27.155 | 27.185 | 337004.0 |
| 2015-01-14 08:55:00 | AAPL | Stock | 27.1812 | 27.225 | 27.175 | 27.225 | 171700.0 |
| 2015-01-14 09:00:00 | AAPL | Stock | 27.225 | 27.25 | 27.1925 | 27.22 | 107568.0 |
| 2015-01-14 09:05:00 | AAPL | Stock | 27.225 | 27.23 | 27.1775 | 27.215 | 82772.0 |
| 2015-01-14 09:10:00 | AAPL | Stock | 27.215 | 27.25 | 27.2 | 27.25 | 123216.0 |
| 2015-01-14 09:15:00 | AAPL | Stock | 27.25 | 27.2725 | 27.23 | 27.25 | 160844.0 |
| 2015-01-14 09:20:00 | AAPL | Stock | 27.245 | 27.2525 | 27.23 | 27.235 | 71464.0 |
| 2015-01-14 09:25:00 | AAPL | Stock | 27.225 | 27.2675 | 27.21 | 27.2325 | 108180.0 |
| 2015-01-14 09:30:00 | AAPL | Stock | 27.235 | 27.4125 | 27.235 | 27.3622 | 8245964.0 |
> showing 50 of 366,983 rows — these rows as CSV