PREVIEW / stock_5min / 2014-06-27
file: by_date/stock_5min/2014/2014-06-27.parquet size: 5.6 MB rows: 370,150 symbols: 3,574
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-06-27 04:00:00 | AAPL | Stock | 22.7375 | 22.7375 | 22.7375 | 22.7375 | 3600.0 |
| 2014-06-27 04:30:00 | AAPL | Stock | 22.735 | 22.735 | 22.735 | 22.735 | 400.0 |
| 2014-06-27 04:35:00 | AAPL | Stock | 22.74 | 22.74 | 22.74 | 22.74 | 400.0 |
| 2014-06-27 05:25:00 | AAPL | Stock | 22.7475 | 22.7475 | 22.7475 | 22.7475 | 7160.0 |
| 2014-06-27 05:40:00 | AAPL | Stock | 22.7475 | 22.7475 | 22.7475 | 22.7475 | 3920.0 |
| 2014-06-27 05:55:00 | AAPL | Stock | 22.7475 | 22.7475 | 22.7475 | 22.7475 | 1200.0 |
| 2014-06-27 06:00:00 | AAPL | Stock | 22.75 | 22.75 | 22.75 | 22.75 | 4000.0 |
| 2014-06-27 06:05:00 | AAPL | Stock | 22.7475 | 22.7475 | 22.7475 | 22.7475 | 860.0 |
| 2014-06-27 06:10:00 | AAPL | Stock | 22.7475 | 22.7475 | 22.7475 | 22.7475 | 3212.0 |
| 2014-06-27 06:20:00 | AAPL | Stock | 22.75 | 22.75 | 22.75 | 22.75 | 1600.0 |
| 2014-06-27 06:25:00 | AAPL | Stock | 22.7575 | 22.7575 | 22.75 | 22.75 | 1200.0 |
| 2014-06-27 06:30:00 | AAPL | Stock | 22.78 | 22.78 | 22.78 | 22.78 | 4000.0 |
| 2014-06-27 06:35:00 | AAPL | Stock | 22.775 | 22.775 | 22.77 | 22.775 | 4320.0 |
| 2014-06-27 06:40:00 | AAPL | Stock | 22.775 | 22.775 | 22.775 | 22.775 | 1600.0 |
| 2014-06-27 06:45:00 | AAPL | Stock | 22.775 | 22.775 | 22.7725 | 22.7725 | 800.0 |
| 2014-06-27 06:50:00 | AAPL | Stock | 22.775 | 22.775 | 22.775 | 22.775 | 400.0 |
| 2014-06-27 06:55:00 | AAPL | Stock | 22.7625 | 22.7625 | 22.7625 | 22.7625 | 800.0 |
| 2014-06-27 07:00:00 | AAPL | Stock | 22.7575 | 22.7575 | 22.75 | 22.75 | 6800.0 |
| 2014-06-27 07:05:00 | AAPL | Stock | 22.7275 | 22.75 | 22.7275 | 22.75 | 4400.0 |
| 2014-06-27 07:10:00 | AAPL | Stock | 22.74 | 22.74 | 22.74 | 22.74 | 3200.0 |
| 2014-06-27 07:15:00 | AAPL | Stock | 22.75 | 22.7575 | 22.75 | 22.75 | 3200.0 |
| 2014-06-27 07:20:00 | AAPL | Stock | 22.75 | 22.75 | 22.75 | 22.75 | 800.0 |
| 2014-06-27 07:25:00 | AAPL | Stock | 22.75 | 22.75 | 22.75 | 22.75 | 2516.0 |
| 2014-06-27 07:30:00 | AAPL | Stock | 22.73 | 22.73 | 22.73 | 22.73 | 400.0 |
| 2014-06-27 07:40:00 | AAPL | Stock | 22.7325 | 22.7325 | 22.7325 | 22.7325 | 1200.0 |
| 2014-06-27 07:45:00 | AAPL | Stock | 22.7325 | 22.735 | 22.7325 | 22.735 | 1200.0 |
| 2014-06-27 07:50:00 | AAPL | Stock | 22.75 | 22.75 | 22.7425 | 22.7425 | 7880.0 |
| 2014-06-27 07:55:00 | AAPL | Stock | 22.7425 | 22.7575 | 22.7425 | 22.7575 | 51616.0 |
| 2014-06-27 08:00:00 | AAPL | Stock | 22.76 | 22.7725 | 22.665 | 22.725 | 111960.0 |
| 2014-06-27 08:05:00 | AAPL | Stock | 22.7175 | 22.7275 | 22.7175 | 22.7175 | 16248.0 |
| 2014-06-27 08:10:00 | AAPL | Stock | 22.725 | 22.7325 | 22.725 | 22.725 | 14400.0 |
| 2014-06-27 08:15:00 | AAPL | Stock | 22.725 | 22.7325 | 22.725 | 22.73 | 16176.0 |
| 2014-06-27 08:20:00 | AAPL | Stock | 22.725 | 22.725 | 22.715 | 22.715 | 5600.0 |
| 2014-06-27 08:25:00 | AAPL | Stock | 22.715 | 22.72 | 22.715 | 22.715 | 20768.0 |
| 2014-06-27 08:30:00 | AAPL | Stock | 22.7125 | 22.72 | 22.705 | 22.7125 | 18884.0 |
| 2014-06-27 08:35:00 | AAPL | Stock | 22.7125 | 22.7175 | 22.71 | 22.71 | 10324.0 |
| 2014-06-27 08:40:00 | AAPL | Stock | 22.71 | 22.715 | 22.705 | 22.705 | 21452.0 |
| 2014-06-27 08:45:00 | AAPL | Stock | 22.7075 | 22.7075 | 22.6975 | 22.6975 | 25780.0 |
| 2014-06-27 08:50:00 | AAPL | Stock | 22.695 | 22.7075 | 22.6925 | 22.7025 | 33044.0 |
| 2014-06-27 08:55:00 | AAPL | Stock | 22.7125 | 22.715 | 22.705 | 22.705 | 23600.0 |
| 2014-06-27 09:00:00 | AAPL | Stock | 22.705 | 22.71 | 22.7025 | 22.7025 | 2800.0 |
| 2014-06-27 09:05:00 | AAPL | Stock | 22.7075 | 22.71 | 22.7075 | 22.71 | 5832.0 |
| 2014-06-27 09:10:00 | AAPL | Stock | 22.71 | 22.7125 | 22.705 | 22.705 | 22432.0 |
| 2014-06-27 09:15:00 | AAPL | Stock | 22.7025 | 22.7025 | 22.6925 | 22.6925 | 16596.0 |
| 2014-06-27 09:20:00 | AAPL | Stock | 22.7 | 22.7 | 22.6725 | 22.6725 | 42536.0 |
| 2014-06-27 09:25:00 | AAPL | Stock | 22.6775 | 22.715 | 22.6675 | 22.7125 | 289396.0 |
| 2014-06-27 09:30:00 | AAPL | Stock | 22.705 | 22.8162 | 22.6925 | 22.7925 | 9987892.0 |
| 2014-06-27 09:35:00 | AAPL | Stock | 22.7915 | 22.84 | 22.7525 | 22.8388 | 4376888.0 |
| 2014-06-27 09:40:00 | AAPL | Stock | 22.84 | 22.8925 | 22.8275 | 22.8912 | 5715584.0 |
| 2014-06-27 09:45:00 | AAPL | Stock | 22.8925 | 22.9138 | 22.855 | 22.9038 | 4778200.0 |
> showing 50 of 370,150 rows — these rows as CSV