PREVIEW / stock_5min / 2015-02-27
file: by_date/stock_5min/2015/2015-02-27.parquet size: 5.5 MB rows: 363,187 symbols: 3,517
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-02-27 04:00:00 | AAPL | Stock | 32.5975 | 32.6675 | 32.5975 | 32.6125 | 7840.0 |
| 2015-02-27 04:15:00 | AAPL | Stock | 32.6 | 32.6 | 32.58 | 32.58 | 11440.0 |
| 2015-02-27 04:35:00 | AAPL | Stock | 32.57 | 32.57 | 32.5625 | 32.5625 | 3600.0 |
| 2015-02-27 04:45:00 | AAPL | Stock | 32.59 | 32.6 | 32.59 | 32.6 | 800.0 |
| 2015-02-27 05:00:00 | AAPL | Stock | 32.62 | 32.62 | 32.59 | 32.59 | 1600.0 |
| 2015-02-27 05:20:00 | AAPL | Stock | 32.6175 | 32.6175 | 32.6175 | 32.6175 | 400.0 |
| 2015-02-27 05:25:00 | AAPL | Stock | 32.62 | 32.62 | 32.62 | 32.62 | 1440.0 |
| 2015-02-27 05:35:00 | AAPL | Stock | 32.62 | 32.62 | 32.62 | 32.62 | 400.0 |
| 2015-02-27 05:40:00 | AAPL | Stock | 32.62 | 32.6225 | 32.62 | 32.6225 | 2800.0 |
| 2015-02-27 05:45:00 | AAPL | Stock | 32.62 | 32.62 | 32.62 | 32.62 | 800.0 |
| 2015-02-27 05:50:00 | AAPL | Stock | 32.6125 | 32.6125 | 32.6125 | 32.6125 | 3200.0 |
| 2015-02-27 05:55:00 | AAPL | Stock | 32.6225 | 32.6225 | 32.6225 | 32.6225 | 476.0 |
| 2015-02-27 06:00:00 | AAPL | Stock | 32.575 | 32.575 | 32.575 | 32.575 | 2000.0 |
| 2015-02-27 06:05:00 | AAPL | Stock | 32.62 | 32.62 | 32.5975 | 32.6 | 2800.0 |
| 2015-02-27 06:10:00 | AAPL | Stock | 32.5775 | 32.5775 | 32.545 | 32.5775 | 9240.0 |
| 2015-02-27 06:15:00 | AAPL | Stock | 32.5775 | 32.5775 | 32.5775 | 32.5775 | 400.0 |
| 2015-02-27 06:20:00 | AAPL | Stock | 32.5875 | 32.5875 | 32.5875 | 32.5875 | 400.0 |
| 2015-02-27 06:25:00 | AAPL | Stock | 32.595 | 32.595 | 32.595 | 32.595 | 400.0 |
| 2015-02-27 06:35:00 | AAPL | Stock | 32.5875 | 32.5875 | 32.585 | 32.585 | 2092.0 |
| 2015-02-27 06:40:00 | AAPL | Stock | 32.585 | 32.595 | 32.585 | 32.595 | 3584.0 |
| 2015-02-27 06:50:00 | AAPL | Stock | 32.615 | 32.625 | 32.615 | 32.625 | 6344.0 |
| 2015-02-27 06:55:00 | AAPL | Stock | 32.6325 | 32.6325 | 32.63 | 32.63 | 2400.0 |
| 2015-02-27 07:00:00 | AAPL | Stock | 32.625 | 32.6325 | 32.6125 | 32.6325 | 15640.0 |
| 2015-02-27 07:05:00 | AAPL | Stock | 32.6275 | 32.6275 | 32.6175 | 32.62 | 17328.0 |
| 2015-02-27 07:10:00 | AAPL | Stock | 32.62 | 32.62 | 32.62 | 32.62 | 400.0 |
| 2015-02-27 07:15:00 | AAPL | Stock | 32.6175 | 32.6175 | 32.6125 | 32.6125 | 11020.0 |
| 2015-02-27 07:20:00 | AAPL | Stock | 32.615 | 32.615 | 32.6025 | 32.605 | 8800.0 |
| 2015-02-27 07:25:00 | AAPL | Stock | 32.605 | 32.625 | 32.605 | 32.6125 | 15200.0 |
| 2015-02-27 07:35:00 | AAPL | Stock | 32.62 | 32.62 | 32.6075 | 32.6075 | 9396.0 |
| 2015-02-27 07:40:00 | AAPL | Stock | 32.6125 | 32.62 | 32.6125 | 32.62 | 3804.0 |
| 2015-02-27 07:45:00 | AAPL | Stock | 32.615 | 32.6225 | 32.615 | 32.62 | 8680.0 |
| 2015-02-27 07:50:00 | AAPL | Stock | 32.625 | 32.6325 | 32.62 | 32.6325 | 8140.0 |
| 2015-02-27 07:55:00 | AAPL | Stock | 32.63 | 32.645 | 32.63 | 32.645 | 34192.0 |
| 2015-02-27 08:00:00 | AAPL | Stock | 32.6375 | 32.6375 | 32.5575 | 32.5675 | 165164.0 |
| 2015-02-27 08:05:00 | AAPL | Stock | 32.5675 | 32.575 | 32.5325 | 32.5475 | 134132.0 |
| 2015-02-27 08:10:00 | AAPL | Stock | 32.5425 | 32.55 | 32.5175 | 32.535 | 80292.0 |
| 2015-02-27 08:15:00 | AAPL | Stock | 32.5275 | 32.5375 | 32.5175 | 32.5375 | 16176.0 |
| 2015-02-27 08:20:00 | AAPL | Stock | 32.5325 | 32.5375 | 32.48 | 32.5 | 91776.0 |
| 2015-02-27 08:25:00 | AAPL | Stock | 32.5 | 32.5325 | 32.5 | 32.5325 | 45584.0 |
| 2015-02-27 08:30:00 | AAPL | Stock | 32.5275 | 32.56 | 32.5125 | 32.55 | 37272.0 |
| 2015-02-27 08:35:00 | AAPL | Stock | 32.5575 | 32.56 | 32.53 | 32.5375 | 23572.0 |
| 2015-02-27 08:40:00 | AAPL | Stock | 32.53 | 32.5375 | 32.5 | 32.5075 | 109992.0 |
| 2015-02-27 08:45:00 | AAPL | Stock | 32.505 | 32.53 | 32.505 | 32.5298 | 27904.0 |
| 2015-02-27 08:50:00 | AAPL | Stock | 32.5175 | 32.5425 | 32.5175 | 32.5425 | 14220.0 |
| 2015-02-27 08:55:00 | AAPL | Stock | 32.5375 | 32.5475 | 32.52 | 32.52 | 14940.0 |
| 2015-02-27 09:00:00 | AAPL | Stock | 32.5275 | 32.5375 | 32.525 | 32.535 | 15828.0 |
| 2015-02-27 09:05:00 | AAPL | Stock | 32.525 | 32.525 | 32.5175 | 32.525 | 19612.0 |
| 2015-02-27 09:10:00 | AAPL | Stock | 32.525 | 32.5475 | 32.525 | 32.53 | 9376.0 |
| 2015-02-27 09:15:00 | AAPL | Stock | 32.525 | 32.525 | 32.475 | 32.475 | 97484.0 |
| 2015-02-27 09:20:00 | AAPL | Stock | 32.475 | 32.495 | 32.46 | 32.48 | 78524.0 |
> showing 50 of 363,187 rows — these rows as CSV