PREVIEW / stock_5min / 2014-09-18
file: by_date/stock_5min/2014/2014-09-18.parquet size: 5.4 MB rows: 356,721 symbols: 3,582
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-09-18 04:00:00 | AAPL | Stock | 25.33 | 25.33 | 25.33 | 25.33 | 560.0 |
| 2014-09-18 04:05:00 | AAPL | Stock | 25.395 | 25.395 | 25.3325 | 25.3325 | 2800.0 |
| 2014-09-18 04:25:00 | AAPL | Stock | 25.3475 | 25.3475 | 25.3325 | 25.3325 | 1692.0 |
| 2014-09-18 04:35:00 | AAPL | Stock | 25.3575 | 25.3575 | 25.3575 | 25.3575 | 400.0 |
| 2014-09-18 04:55:00 | AAPL | Stock | 25.4025 | 25.405 | 25.4025 | 25.405 | 1996.0 |
| 2014-09-18 05:00:00 | AAPL | Stock | 25.4325 | 25.435 | 25.4325 | 25.435 | 1800.0 |
| 2014-09-18 05:10:00 | AAPL | Stock | 25.425 | 25.425 | 25.4225 | 25.4225 | 6800.0 |
| 2014-09-18 05:15:00 | AAPL | Stock | 25.4225 | 25.4375 | 25.4225 | 25.4375 | 2160.0 |
| 2014-09-18 05:20:00 | AAPL | Stock | 25.4375 | 25.4375 | 25.4375 | 25.4375 | 800.0 |
| 2014-09-18 05:40:00 | AAPL | Stock | 25.48 | 25.48 | 25.48 | 25.48 | 1624.0 |
| 2014-09-18 05:45:00 | AAPL | Stock | 25.48 | 25.48 | 25.48 | 25.48 | 400.0 |
| 2014-09-18 06:00:00 | AAPL | Stock | 25.4775 | 25.525 | 25.4775 | 25.525 | 18332.0 |
| 2014-09-18 06:05:00 | AAPL | Stock | 25.5375 | 25.5475 | 25.525 | 25.5375 | 29656.0 |
| 2014-09-18 06:10:00 | AAPL | Stock | 25.5375 | 25.545 | 25.5375 | 25.545 | 6000.0 |
| 2014-09-18 06:15:00 | AAPL | Stock | 25.53 | 25.53 | 25.525 | 25.525 | 2800.0 |
| 2014-09-18 06:20:00 | AAPL | Stock | 25.525 | 25.525 | 25.5 | 25.5 | 4608.0 |
| 2014-09-18 06:25:00 | AAPL | Stock | 25.5125 | 25.515 | 25.5025 | 25.515 | 3820.0 |
| 2014-09-18 06:30:00 | AAPL | Stock | 25.515 | 25.515 | 25.5075 | 25.5075 | 2000.0 |
| 2014-09-18 06:35:00 | AAPL | Stock | 25.525 | 25.525 | 25.525 | 25.525 | 400.0 |
| 2014-09-18 06:45:00 | AAPL | Stock | 25.52 | 25.5225 | 25.5075 | 25.5075 | 11188.0 |
| 2014-09-18 06:50:00 | AAPL | Stock | 25.5075 | 25.53 | 25.5075 | 25.53 | 56380.0 |
| 2014-09-18 06:55:00 | AAPL | Stock | 25.5325 | 25.5425 | 25.5275 | 25.5275 | 11392.0 |
| 2014-09-18 07:00:00 | AAPL | Stock | 25.5275 | 25.5725 | 25.5275 | 25.555 | 31824.0 |
| 2014-09-18 07:05:00 | AAPL | Stock | 25.555 | 25.57 | 25.53 | 25.5625 | 34040.0 |
| 2014-09-18 07:10:00 | AAPL | Stock | 25.5625 | 25.57 | 25.55 | 25.5575 | 33944.0 |
| 2014-09-18 07:15:00 | AAPL | Stock | 25.5375 | 25.5575 | 25.5325 | 25.5575 | 8400.0 |
| 2014-09-18 07:20:00 | AAPL | Stock | 25.55 | 25.5575 | 25.55 | 25.55 | 17600.0 |
| 2014-09-18 07:25:00 | AAPL | Stock | 25.5575 | 25.57 | 25.55 | 25.57 | 80820.0 |
| 2014-09-18 07:30:00 | AAPL | Stock | 25.57 | 25.6775 | 25.5675 | 25.6775 | 132728.0 |
| 2014-09-18 07:35:00 | AAPL | Stock | 25.63 | 25.6425 | 25.59 | 25.59 | 37080.0 |
| 2014-09-18 07:40:00 | AAPL | Stock | 25.59 | 25.62 | 25.59 | 25.5975 | 38684.0 |
| 2014-09-18 07:45:00 | AAPL | Stock | 25.595 | 25.6175 | 25.5875 | 25.6125 | 62152.0 |
| 2014-09-18 07:50:00 | AAPL | Stock | 25.615 | 25.6175 | 25.6 | 25.6 | 104780.0 |
| 2014-09-18 07:55:00 | AAPL | Stock | 25.5925 | 25.605 | 25.575 | 25.575 | 52500.0 |
| 2014-09-18 08:00:00 | AAPL | Stock | 25.575 | 25.6325 | 25.515 | 25.57 | 203940.0 |
| 2014-09-18 08:05:00 | AAPL | Stock | 25.575 | 25.5875 | 25.5625 | 25.575 | 71640.0 |
| 2014-09-18 08:10:00 | AAPL | Stock | 25.565 | 25.57 | 25.55 | 25.55 | 45340.0 |
| 2014-09-18 08:15:00 | AAPL | Stock | 25.55 | 25.56 | 25.545 | 25.55 | 39420.0 |
| 2014-09-18 08:20:00 | AAPL | Stock | 25.55 | 25.555 | 25.5325 | 25.5325 | 57788.0 |
| 2014-09-18 08:25:00 | AAPL | Stock | 25.53 | 25.5525 | 25.52 | 25.5525 | 45864.0 |
| 2014-09-18 08:30:00 | AAPL | Stock | 25.5525 | 25.56 | 25.55 | 25.56 | 18632.0 |
| 2014-09-18 08:35:00 | AAPL | Stock | 25.5525 | 25.565 | 25.545 | 25.56 | 79468.0 |
| 2014-09-18 08:40:00 | AAPL | Stock | 25.5475 | 25.55 | 25.54 | 25.5425 | 24800.0 |
| 2014-09-18 08:45:00 | AAPL | Stock | 25.54 | 25.56 | 25.54 | 25.555 | 45976.0 |
| 2014-09-18 08:50:00 | AAPL | Stock | 25.555 | 25.56 | 25.5425 | 25.5425 | 36108.0 |
| 2014-09-18 08:55:00 | AAPL | Stock | 25.5475 | 25.56 | 25.5475 | 25.5525 | 15400.0 |
| 2014-09-18 09:00:00 | AAPL | Stock | 25.5525 | 25.61 | 25.55 | 25.605 | 193248.0 |
| 2014-09-18 09:05:00 | AAPL | Stock | 25.605 | 25.6075 | 25.5825 | 25.6 | 85580.0 |
| 2014-09-18 09:10:00 | AAPL | Stock | 25.6 | 25.6 | 25.5675 | 25.57 | 35704.0 |
| 2014-09-18 09:15:00 | AAPL | Stock | 25.57 | 25.5875 | 25.57 | 25.5825 | 19532.0 |
> showing 50 of 356,721 rows — these rows as CSV