PREVIEW / stock_5min / 2014-07-22
file: by_date/stock_5min/2014/2014-07-22.parquet size: 5.2 MB rows: 350,633 symbols: 3,572
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-07-22 04:00:00 | AAPL | Stock | 23.625 | 23.625 | 23.625 | 23.625 | 3200.0 |
| 2014-07-22 04:30:00 | AAPL | Stock | 23.6475 | 23.6475 | 23.6475 | 23.6475 | 400.0 |
| 2014-07-22 04:40:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.6375 | 23.6375 | 2400.0 |
| 2014-07-22 04:45:00 | AAPL | Stock | 23.645 | 23.645 | 23.6425 | 23.6425 | 24960.0 |
| 2014-07-22 04:50:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.6375 | 23.6375 | 1024.0 |
| 2014-07-22 04:55:00 | AAPL | Stock | 23.6425 | 23.65 | 23.6425 | 23.65 | 12520.0 |
| 2014-07-22 05:15:00 | AAPL | Stock | 23.6825 | 23.7 | 23.6825 | 23.695 | 8920.0 |
| 2014-07-22 05:20:00 | AAPL | Stock | 23.6825 | 23.69 | 23.6825 | 23.69 | 5600.0 |
| 2014-07-22 05:25:00 | AAPL | Stock | 23.69 | 23.69 | 23.69 | 23.69 | 800.0 |
| 2014-07-22 05:30:00 | AAPL | Stock | 23.6875 | 23.69 | 23.6875 | 23.69 | 1844.0 |
| 2014-07-22 05:35:00 | AAPL | Stock | 23.69 | 23.69 | 23.6875 | 23.69 | 2400.0 |
| 2014-07-22 05:40:00 | AAPL | Stock | 23.69 | 23.695 | 23.69 | 23.69 | 15032.0 |
| 2014-07-22 05:45:00 | AAPL | Stock | 23.705 | 23.705 | 23.705 | 23.705 | 400.0 |
| 2014-07-22 05:50:00 | AAPL | Stock | 23.7125 | 23.7125 | 23.705 | 23.705 | 7000.0 |
| 2014-07-22 05:55:00 | AAPL | Stock | 23.705 | 23.705 | 23.69 | 23.7 | 6000.0 |
| 2014-07-22 06:00:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 6800.0 |
| 2014-07-22 06:05:00 | AAPL | Stock | 23.7075 | 23.7075 | 23.7075 | 23.7075 | 1580.0 |
| 2014-07-22 06:10:00 | AAPL | Stock | 23.6975 | 23.6975 | 23.69 | 23.6975 | 6528.0 |
| 2014-07-22 06:15:00 | AAPL | Stock | 23.6975 | 23.6975 | 23.6975 | 23.6975 | 1592.0 |
| 2014-07-22 06:20:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 1200.0 |
| 2014-07-22 06:25:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 572.0 |
| 2014-07-22 06:30:00 | AAPL | Stock | 23.7075 | 23.7075 | 23.7 | 23.7 | 19560.0 |
| 2014-07-22 06:35:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 3920.0 |
| 2014-07-22 06:40:00 | AAPL | Stock | 23.705 | 23.705 | 23.69 | 23.69 | 1600.0 |
| 2014-07-22 06:50:00 | AAPL | Stock | 23.695 | 23.7 | 23.695 | 23.7 | 8800.0 |
| 2014-07-22 06:55:00 | AAPL | Stock | 23.7 | 23.7 | 23.6875 | 23.6875 | 8748.0 |
| 2014-07-22 07:00:00 | AAPL | Stock | 23.695 | 23.7 | 23.675 | 23.695 | 66712.0 |
| 2014-07-22 07:05:00 | AAPL | Stock | 23.69 | 23.6975 | 23.6875 | 23.6875 | 78080.0 |
| 2014-07-22 07:10:00 | AAPL | Stock | 23.675 | 23.7 | 23.675 | 23.695 | 26604.0 |
| 2014-07-22 07:15:00 | AAPL | Stock | 23.695 | 23.695 | 23.665 | 23.6825 | 120840.0 |
| 2014-07-22 07:20:00 | AAPL | Stock | 23.6825 | 23.6925 | 23.675 | 23.68 | 26040.0 |
| 2014-07-22 07:25:00 | AAPL | Stock | 23.68 | 23.7 | 23.68 | 23.6925 | 87180.0 |
| 2014-07-22 07:30:00 | AAPL | Stock | 23.7 | 23.7025 | 23.69 | 23.69 | 35600.0 |
| 2014-07-22 07:35:00 | AAPL | Stock | 23.69 | 23.69 | 23.6725 | 23.6725 | 13092.0 |
| 2014-07-22 07:40:00 | AAPL | Stock | 23.6725 | 23.71 | 23.6725 | 23.71 | 49900.0 |
| 2014-07-22 07:45:00 | AAPL | Stock | 23.7 | 23.71 | 23.6975 | 23.7075 | 21352.0 |
| 2014-07-22 07:50:00 | AAPL | Stock | 23.7025 | 23.7025 | 23.675 | 23.6875 | 43120.0 |
| 2014-07-22 07:55:00 | AAPL | Stock | 23.6875 | 23.7 | 23.6525 | 23.6525 | 39524.0 |
| 2014-07-22 08:00:00 | AAPL | Stock | 23.665 | 23.71 | 23.6075 | 23.6575 | 296252.0 |
| 2014-07-22 08:05:00 | AAPL | Stock | 23.655 | 23.675 | 23.65 | 23.67 | 88580.0 |
| 2014-07-22 08:10:00 | AAPL | Stock | 23.67 | 23.6725 | 23.6375 | 23.6525 | 65200.0 |
| 2014-07-22 08:15:00 | AAPL | Stock | 23.65 | 23.6575 | 23.625 | 23.655 | 70404.0 |
| 2014-07-22 08:20:00 | AAPL | Stock | 23.655 | 23.6625 | 23.6475 | 23.6475 | 51436.0 |
| 2014-07-22 08:25:00 | AAPL | Stock | 23.65 | 23.6575 | 23.6475 | 23.6575 | 29352.0 |
| 2014-07-22 08:30:00 | AAPL | Stock | 23.66 | 23.6625 | 23.6325 | 23.6325 | 89920.0 |
| 2014-07-22 08:35:00 | AAPL | Stock | 23.6325 | 23.65 | 23.625 | 23.65 | 79672.0 |
| 2014-07-22 08:40:00 | AAPL | Stock | 23.6475 | 23.6575 | 23.6425 | 23.655 | 26704.0 |
| 2014-07-22 08:45:00 | AAPL | Stock | 23.66 | 23.67 | 23.6475 | 23.6625 | 119100.0 |
| 2014-07-22 08:50:00 | AAPL | Stock | 23.6675 | 23.67 | 23.6575 | 23.6575 | 65248.0 |
| 2014-07-22 08:55:00 | AAPL | Stock | 23.66 | 23.6625 | 23.645 | 23.6475 | 78264.0 |
> showing 50 of 350,633 rows — these rows as CSV