PREVIEW / stock_5min / 2015-05-19
file: by_date/stock_5min/2015/2015-05-19.parquet size: 5.5 MB rows: 363,662 symbols: 3,518
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-05-19 04:00:00 | AAPL | Stock | 32.675 | 32.7225 | 32.675 | 32.71 | 20644.0 |
| 2015-05-19 04:05:00 | AAPL | Stock | 32.7175 | 32.7175 | 32.7075 | 32.7175 | 19320.0 |
| 2015-05-19 04:10:00 | AAPL | Stock | 32.7175 | 32.7225 | 32.715 | 32.7175 | 9340.0 |
| 2015-05-19 04:15:00 | AAPL | Stock | 32.715 | 32.715 | 32.7025 | 32.7125 | 9584.0 |
| 2015-05-19 04:20:00 | AAPL | Stock | 32.6925 | 32.6925 | 32.6925 | 32.6925 | 1952.0 |
| 2015-05-19 04:25:00 | AAPL | Stock | 32.6875 | 32.6875 | 32.6675 | 32.6675 | 7324.0 |
| 2015-05-19 04:45:00 | AAPL | Stock | 32.7075 | 32.7075 | 32.7075 | 32.7075 | 716.0 |
| 2015-05-19 04:55:00 | AAPL | Stock | 32.7125 | 32.7125 | 32.7125 | 32.7125 | 1016.0 |
| 2015-05-19 05:00:00 | AAPL | Stock | 32.71 | 32.71 | 32.71 | 32.71 | 400.0 |
| 2015-05-19 05:05:00 | AAPL | Stock | 32.7 | 32.715 | 32.7 | 32.7125 | 2800.0 |
| 2015-05-19 05:10:00 | AAPL | Stock | 32.715 | 32.715 | 32.7 | 32.7 | 2400.0 |
| 2015-05-19 05:15:00 | AAPL | Stock | 32.7 | 32.7 | 32.7 | 32.7 | 1200.0 |
| 2015-05-19 05:20:00 | AAPL | Stock | 32.715 | 32.72 | 32.715 | 32.72 | 3636.0 |
| 2015-05-19 05:25:00 | AAPL | Stock | 32.72 | 32.72 | 32.72 | 32.72 | 708.0 |
| 2015-05-19 05:30:00 | AAPL | Stock | 32.72 | 32.7225 | 32.7125 | 32.7125 | 14000.0 |
| 2015-05-19 05:35:00 | AAPL | Stock | 32.7125 | 32.715 | 32.7125 | 32.715 | 1600.0 |
| 2015-05-19 05:40:00 | AAPL | Stock | 32.7225 | 32.7225 | 32.69 | 32.7075 | 27736.0 |
| 2015-05-19 05:50:00 | AAPL | Stock | 32.6875 | 32.6875 | 32.6875 | 32.6875 | 5684.0 |
| 2015-05-19 05:55:00 | AAPL | Stock | 32.705 | 32.705 | 32.705 | 32.705 | 560.0 |
| 2015-05-19 06:00:00 | AAPL | Stock | 32.7075 | 32.7225 | 32.6975 | 32.7125 | 25700.0 |
| 2015-05-19 06:05:00 | AAPL | Stock | 32.7125 | 32.7125 | 32.7125 | 32.7125 | 1640.0 |
| 2015-05-19 06:15:00 | AAPL | Stock | 32.7225 | 32.7225 | 32.7175 | 32.7175 | 1320.0 |
| 2015-05-19 06:20:00 | AAPL | Stock | 32.7225 | 32.7225 | 32.7225 | 32.7225 | 6024.0 |
| 2015-05-19 06:25:00 | AAPL | Stock | 32.705 | 32.705 | 32.6925 | 32.7025 | 5656.0 |
| 2015-05-19 06:30:00 | AAPL | Stock | 32.7075 | 32.7225 | 32.7025 | 32.7225 | 23852.0 |
| 2015-05-19 06:35:00 | AAPL | Stock | 32.715 | 32.72 | 32.715 | 32.715 | 10400.0 |
| 2015-05-19 06:40:00 | AAPL | Stock | 32.72 | 32.7225 | 32.72 | 32.72 | 21600.0 |
| 2015-05-19 06:45:00 | AAPL | Stock | 32.725 | 32.725 | 32.71 | 32.71 | 4704.0 |
| 2015-05-19 06:50:00 | AAPL | Stock | 32.72 | 32.72 | 32.695 | 32.695 | 2856.0 |
| 2015-05-19 06:55:00 | AAPL | Stock | 32.695 | 32.705 | 32.695 | 32.705 | 6416.0 |
| 2015-05-19 07:00:00 | AAPL | Stock | 32.695 | 32.705 | 32.6875 | 32.695 | 88580.0 |
| 2015-05-19 07:05:00 | AAPL | Stock | 32.695 | 32.705 | 32.675 | 32.675 | 65028.0 |
| 2015-05-19 07:10:00 | AAPL | Stock | 32.675 | 32.6775 | 32.6725 | 32.675 | 17144.0 |
| 2015-05-19 07:15:00 | AAPL | Stock | 32.6925 | 32.7 | 32.6925 | 32.7 | 24800.0 |
| 2015-05-19 07:20:00 | AAPL | Stock | 32.6975 | 32.7 | 32.6925 | 32.7 | 26092.0 |
| 2015-05-19 07:25:00 | AAPL | Stock | 32.705 | 32.71 | 32.7 | 32.71 | 8360.0 |
| 2015-05-19 07:30:00 | AAPL | Stock | 32.7075 | 32.715 | 32.7025 | 32.7125 | 16092.0 |
| 2015-05-19 07:35:00 | AAPL | Stock | 32.7075 | 32.7125 | 32.6925 | 32.7125 | 25188.0 |
| 2015-05-19 07:40:00 | AAPL | Stock | 32.705 | 32.71 | 32.7 | 32.7 | 12808.0 |
| 2015-05-19 07:45:00 | AAPL | Stock | 32.6925 | 32.7125 | 32.6925 | 32.6975 | 23672.0 |
| 2015-05-19 07:50:00 | AAPL | Stock | 32.69 | 32.69 | 32.675 | 32.6875 | 9388.0 |
| 2015-05-19 07:55:00 | AAPL | Stock | 32.6875 | 32.7 | 32.6825 | 32.7 | 4960.0 |
| 2015-05-19 08:00:00 | AAPL | Stock | 32.7 | 32.7162 | 32.64 | 32.6725 | 284816.0 |
| 2015-05-19 08:05:00 | AAPL | Stock | 32.675 | 32.675 | 32.655 | 32.675 | 94732.0 |
| 2015-05-19 08:10:00 | AAPL | Stock | 32.675 | 32.685 | 32.6725 | 32.685 | 93500.0 |
| 2015-05-19 08:15:00 | AAPL | Stock | 32.685 | 32.695 | 32.6775 | 32.68 | 204556.0 |
| 2015-05-19 08:20:00 | AAPL | Stock | 32.6825 | 32.69 | 32.6675 | 32.6725 | 208872.0 |
| 2015-05-19 08:25:00 | AAPL | Stock | 32.675 | 32.675 | 32.655 | 32.6675 | 34028.0 |
| 2015-05-19 08:30:00 | AAPL | Stock | 32.6675 | 32.6725 | 32.655 | 32.6675 | 142572.0 |
| 2015-05-19 08:35:00 | AAPL | Stock | 32.6675 | 32.67 | 32.66 | 32.665 | 165008.0 |
> showing 50 of 363,662 rows — these rows as CSV