PREVIEW / stock_5min / 2017-02-24
file: by_date/stock_5min/2017/2017-02-24.parquet size: 5.4 MB rows: 354,053 symbols: 3,099
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-24 04:00:00 | AAPL | Stock | 34.0375 | 34.0375 | 34.0 | 34.0 | 8936.0 |
| 2017-02-24 04:15:00 | AAPL | Stock | 33.99 | 33.99 | 33.99 | 33.99 | 400.0 |
| 2017-02-24 04:30:00 | AAPL | Stock | 33.975 | 33.975 | 33.9125 | 33.9425 | 5436.0 |
| 2017-02-24 04:35:00 | AAPL | Stock | 33.9425 | 33.9425 | 33.8775 | 33.8775 | 1488.0 |
| 2017-02-24 04:40:00 | AAPL | Stock | 33.95 | 33.9575 | 33.8775 | 33.88 | 5064.0 |
| 2017-02-24 04:45:00 | AAPL | Stock | 33.88 | 33.88 | 33.88 | 33.88 | 400.0 |
| 2017-02-24 05:10:00 | AAPL | Stock | 33.87 | 33.87 | 33.7525 | 33.7575 | 4132.0 |
| 2017-02-24 05:15:00 | AAPL | Stock | 33.7575 | 33.81 | 33.7575 | 33.81 | 6016.0 |
| 2017-02-24 05:25:00 | AAPL | Stock | 33.81 | 33.81 | 33.7975 | 33.7975 | 1844.0 |
| 2017-02-24 05:30:00 | AAPL | Stock | 33.8 | 33.8 | 33.795 | 33.795 | 2188.0 |
| 2017-02-24 05:35:00 | AAPL | Stock | 33.795 | 33.795 | 33.795 | 33.795 | 1600.0 |
| 2017-02-24 05:40:00 | AAPL | Stock | 33.8 | 33.8 | 33.795 | 33.795 | 1200.0 |
| 2017-02-24 05:45:00 | AAPL | Stock | 33.775 | 33.775 | 33.675 | 33.675 | 12964.0 |
| 2017-02-24 05:50:00 | AAPL | Stock | 33.675 | 33.675 | 33.655 | 33.655 | 4900.0 |
| 2017-02-24 05:55:00 | AAPL | Stock | 33.6775 | 33.715 | 33.6775 | 33.715 | 4432.0 |
| 2017-02-24 06:05:00 | AAPL | Stock | 33.7175 | 33.7275 | 33.7175 | 33.7175 | 8260.0 |
| 2017-02-24 06:10:00 | AAPL | Stock | 33.7275 | 33.7275 | 33.7175 | 33.725 | 2400.0 |
| 2017-02-24 06:15:00 | AAPL | Stock | 33.7175 | 33.725 | 33.7175 | 33.725 | 16604.0 |
| 2017-02-24 06:20:00 | AAPL | Stock | 33.7175 | 33.7175 | 33.7175 | 33.7175 | 5848.0 |
| 2017-02-24 06:25:00 | AAPL | Stock | 33.7175 | 33.72 | 33.7175 | 33.7175 | 5572.0 |
| 2017-02-24 06:30:00 | AAPL | Stock | 33.7225 | 33.7275 | 33.7225 | 33.7275 | 11372.0 |
| 2017-02-24 06:35:00 | AAPL | Stock | 33.765 | 33.825 | 33.765 | 33.7775 | 16236.0 |
| 2017-02-24 06:40:00 | AAPL | Stock | 33.7525 | 33.7875 | 33.75 | 33.7875 | 5920.0 |
| 2017-02-24 06:45:00 | AAPL | Stock | 33.75 | 33.75 | 33.6875 | 33.7 | 10880.0 |
| 2017-02-24 06:50:00 | AAPL | Stock | 33.7 | 33.7 | 33.6875 | 33.6875 | 3200.0 |
| 2017-02-24 06:55:00 | AAPL | Stock | 33.6875 | 33.6875 | 33.665 | 33.665 | 16724.0 |
| 2017-02-24 07:00:00 | AAPL | Stock | 33.665 | 33.7225 | 33.655 | 33.7125 | 14492.0 |
| 2017-02-24 07:05:00 | AAPL | Stock | 33.7075 | 33.7525 | 33.7075 | 33.75 | 31000.0 |
| 2017-02-24 07:10:00 | AAPL | Stock | 33.7525 | 33.755 | 33.7525 | 33.755 | 2944.0 |
| 2017-02-24 07:15:00 | AAPL | Stock | 33.755 | 33.775 | 33.755 | 33.775 | 8580.0 |
| 2017-02-24 07:20:00 | AAPL | Stock | 33.755 | 33.7675 | 33.7525 | 33.7525 | 4600.0 |
| 2017-02-24 07:25:00 | AAPL | Stock | 33.7675 | 33.775 | 33.7525 | 33.775 | 10780.0 |
| 2017-02-24 07:30:00 | AAPL | Stock | 33.7525 | 33.785 | 33.7525 | 33.785 | 6444.0 |
| 2017-02-24 07:35:00 | AAPL | Stock | 33.785 | 33.815 | 33.785 | 33.815 | 17604.0 |
| 2017-02-24 07:40:00 | AAPL | Stock | 33.815 | 33.82 | 33.8125 | 33.8125 | 17816.0 |
| 2017-02-24 07:45:00 | AAPL | Stock | 33.8125 | 33.825 | 33.8125 | 33.8125 | 35728.0 |
| 2017-02-24 07:50:00 | AAPL | Stock | 33.8 | 33.8 | 33.7975 | 33.8 | 10560.0 |
| 2017-02-24 07:55:00 | AAPL | Stock | 33.8 | 33.8 | 33.78 | 33.78 | 2200.0 |
| 2017-02-24 08:00:00 | AAPL | Stock | 33.8225 | 33.835 | 33.655 | 33.815 | 98320.0 |
| 2017-02-24 08:05:00 | AAPL | Stock | 33.81 | 33.8275 | 33.81 | 33.815 | 28676.0 |
| 2017-02-24 08:10:00 | AAPL | Stock | 33.8125 | 33.835 | 33.8075 | 33.835 | 17648.0 |
| 2017-02-24 08:15:00 | AAPL | Stock | 33.8275 | 33.8475 | 33.8075 | 33.8475 | 58232.0 |
| 2017-02-24 08:20:00 | AAPL | Stock | 33.8375 | 33.8725 | 33.8275 | 33.8275 | 44200.0 |
| 2017-02-24 08:25:00 | AAPL | Stock | 33.8375 | 33.865 | 33.8375 | 33.85 | 19312.0 |
| 2017-02-24 08:30:00 | AAPL | Stock | 33.8525 | 33.865 | 33.8525 | 33.855 | 23096.0 |
| 2017-02-24 08:35:00 | AAPL | Stock | 33.8525 | 33.875 | 33.8525 | 33.86 | 33240.0 |
| 2017-02-24 08:40:00 | AAPL | Stock | 33.85 | 33.8625 | 33.84 | 33.8625 | 32576.0 |
| 2017-02-24 08:45:00 | AAPL | Stock | 33.8625 | 33.8625 | 33.825 | 33.8425 | 54256.0 |
| 2017-02-24 08:50:00 | AAPL | Stock | 33.8325 | 33.85 | 33.815 | 33.815 | 36220.0 |
| 2017-02-24 08:55:00 | AAPL | Stock | 33.8125 | 33.83 | 33.8075 | 33.83 | 35024.0 |
> showing 50 of 354,053 rows — these rows as CSV