PREVIEW / stock_5min / 2014-10-22
file: by_date/stock_5min/2014/2014-10-22.parquet size: 5.4 MB rows: 357,724 symbols: 3,544
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-10-22 04:00:00 | AAPL | Stock | 25.62 | 25.6225 | 25.585 | 25.585 | 5908.0 |
| 2014-10-22 04:15:00 | AAPL | Stock | 25.5675 | 25.5675 | 25.5675 | 25.5675 | 2000.0 |
| 2014-10-22 04:20:00 | AAPL | Stock | 25.5525 | 25.615 | 25.5 | 25.615 | 18292.0 |
| 2014-10-22 04:25:00 | AAPL | Stock | 25.575 | 25.575 | 25.575 | 25.575 | 400.0 |
| 2014-10-22 04:30:00 | AAPL | Stock | 25.575 | 25.575 | 25.5625 | 25.5625 | 3008.0 |
| 2014-10-22 04:40:00 | AAPL | Stock | 25.5875 | 25.5875 | 25.5875 | 25.5875 | 400.0 |
| 2014-10-22 04:50:00 | AAPL | Stock | 25.5925 | 25.5925 | 25.5925 | 25.5925 | 400.0 |
| 2014-10-22 04:55:00 | AAPL | Stock | 25.5925 | 25.595 | 25.5925 | 25.595 | 6420.0 |
| 2014-10-22 05:15:00 | AAPL | Stock | 25.5875 | 25.5875 | 25.5875 | 25.5875 | 10000.0 |
| 2014-10-22 05:20:00 | AAPL | Stock | 25.585 | 25.585 | 25.585 | 25.585 | 1960.0 |
| 2014-10-22 05:35:00 | AAPL | Stock | 25.5825 | 25.5825 | 25.5725 | 25.5825 | 5852.0 |
| 2014-10-22 05:45:00 | AAPL | Stock | 25.5825 | 25.5825 | 25.5825 | 25.5825 | 1532.0 |
| 2014-10-22 05:55:00 | AAPL | Stock | 25.575 | 25.575 | 25.575 | 25.575 | 400.0 |
| 2014-10-22 06:00:00 | AAPL | Stock | 25.565 | 25.565 | 25.56 | 25.565 | 3300.0 |
| 2014-10-22 06:05:00 | AAPL | Stock | 25.5625 | 25.5725 | 25.5625 | 25.5725 | 4076.0 |
| 2014-10-22 06:10:00 | AAPL | Stock | 25.5625 | 25.5625 | 25.5625 | 25.5625 | 3092.0 |
| 2014-10-22 06:15:00 | AAPL | Stock | 25.575 | 25.575 | 25.575 | 25.575 | 4000.0 |
| 2014-10-22 06:20:00 | AAPL | Stock | 25.5625 | 25.5625 | 25.5625 | 25.5625 | 800.0 |
| 2014-10-22 06:25:00 | AAPL | Stock | 25.5575 | 25.5625 | 25.545 | 25.5625 | 2916.0 |
| 2014-10-22 06:30:00 | AAPL | Stock | 25.55 | 25.55 | 25.55 | 25.55 | 3200.0 |
| 2014-10-22 06:35:00 | AAPL | Stock | 25.555 | 25.5575 | 25.555 | 25.555 | 6800.0 |
| 2014-10-22 06:40:00 | AAPL | Stock | 25.5525 | 25.5625 | 25.55 | 25.5625 | 8392.0 |
| 2014-10-22 06:45:00 | AAPL | Stock | 25.5625 | 25.5625 | 25.55 | 25.55 | 6000.0 |
| 2014-10-22 06:55:00 | AAPL | Stock | 25.5425 | 25.55 | 25.5425 | 25.55 | 1200.0 |
| 2014-10-22 07:00:00 | AAPL | Stock | 25.55 | 25.55 | 25.545 | 25.545 | 2088.0 |
| 2014-10-22 07:05:00 | AAPL | Stock | 25.5475 | 25.555 | 25.545 | 25.555 | 2832.0 |
| 2014-10-22 07:10:00 | AAPL | Stock | 25.565 | 25.5825 | 25.565 | 25.575 | 15616.0 |
| 2014-10-22 07:15:00 | AAPL | Stock | 25.575 | 25.5875 | 25.575 | 25.5875 | 9200.0 |
| 2014-10-22 07:25:00 | AAPL | Stock | 25.58 | 25.595 | 25.58 | 25.595 | 42288.0 |
| 2014-10-22 07:30:00 | AAPL | Stock | 25.595 | 25.615 | 25.595 | 25.6125 | 25008.0 |
| 2014-10-22 07:35:00 | AAPL | Stock | 25.6 | 25.6 | 25.6 | 25.6 | 3480.0 |
| 2014-10-22 07:40:00 | AAPL | Stock | 25.6 | 25.6 | 25.5775 | 25.59 | 15072.0 |
| 2014-10-22 07:45:00 | AAPL | Stock | 25.5775 | 25.585 | 25.57 | 25.57 | 18792.0 |
| 2014-10-22 07:50:00 | AAPL | Stock | 25.585 | 25.6075 | 25.585 | 25.6075 | 19480.0 |
| 2014-10-22 07:55:00 | AAPL | Stock | 25.605 | 25.605 | 25.6 | 25.6 | 3240.0 |
| 2014-10-22 08:00:00 | AAPL | Stock | 25.6 | 25.6125 | 25.5375 | 25.585 | 71332.0 |
| 2014-10-22 08:05:00 | AAPL | Stock | 25.59 | 25.5975 | 25.55 | 25.595 | 72656.0 |
| 2014-10-22 08:10:00 | AAPL | Stock | 25.595 | 25.645 | 25.595 | 25.6375 | 79460.0 |
| 2014-10-22 08:15:00 | AAPL | Stock | 25.6375 | 25.6575 | 25.6275 | 25.65 | 163600.0 |
| 2014-10-22 08:20:00 | AAPL | Stock | 25.65 | 25.67 | 25.65 | 25.665 | 143928.0 |
| 2014-10-22 08:25:00 | AAPL | Stock | 25.665 | 25.6875 | 25.655 | 25.685 | 89944.0 |
| 2014-10-22 08:30:00 | AAPL | Stock | 25.675 | 25.675 | 25.65 | 25.65 | 144052.0 |
| 2014-10-22 08:35:00 | AAPL | Stock | 25.655 | 25.655 | 25.6125 | 25.6175 | 66828.0 |
| 2014-10-22 08:40:00 | AAPL | Stock | 25.615 | 25.645 | 25.6125 | 25.6425 | 35640.0 |
| 2014-10-22 08:45:00 | AAPL | Stock | 25.635 | 25.65 | 25.62 | 25.62 | 108660.0 |
| 2014-10-22 08:50:00 | AAPL | Stock | 25.62 | 25.6525 | 25.62 | 25.6525 | 94136.0 |
| 2014-10-22 08:55:00 | AAPL | Stock | 25.655 | 25.7125 | 25.655 | 25.7125 | 188848.0 |
| 2014-10-22 09:00:00 | AAPL | Stock | 25.695 | 25.6975 | 25.675 | 25.675 | 75116.0 |
| 2014-10-22 09:05:00 | AAPL | Stock | 25.66 | 25.685 | 25.6575 | 25.685 | 26224.0 |
| 2014-10-22 09:10:00 | AAPL | Stock | 25.6875 | 25.6925 | 25.675 | 25.6875 | 53408.0 |
> showing 50 of 357,724 rows — these rows as CSV