PREVIEW / stock_5min / 2019-02-11
file: by_date/stock_5min/2019/2019-02-11.parquet size: 5.4 MB rows: 345,585 symbols: 2,675
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-11 04:05:00 | AAPL | Stock | 42.8175 | 42.8175 | 42.8175 | 42.8175 | 800.0 |
| 2019-02-11 04:25:00 | AAPL | Stock | 42.7475 | 42.7475 | 42.7375 | 42.7375 | 1600.0 |
| 2019-02-11 04:55:00 | AAPL | Stock | 42.8125 | 42.8125 | 42.8125 | 42.8125 | 400.0 |
| 2019-02-11 05:15:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 800.0 |
| 2019-02-11 05:30:00 | AAPL | Stock | 42.8 | 42.8 | 42.8 | 42.8 | 400.0 |
| 2019-02-11 05:35:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 1276.0 |
| 2019-02-11 05:45:00 | AAPL | Stock | 42.725 | 42.8125 | 42.725 | 42.8125 | 2788.0 |
| 2019-02-11 05:50:00 | AAPL | Stock | 42.73 | 42.73 | 42.7275 | 42.7275 | 1320.0 |
| 2019-02-11 05:55:00 | AAPL | Stock | 42.755 | 42.755 | 42.705 | 42.705 | 11540.0 |
| 2019-02-11 06:00:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 400.0 |
| 2019-02-11 06:05:00 | AAPL | Stock | 42.72 | 42.72 | 42.72 | 42.72 | 760.0 |
| 2019-02-11 06:20:00 | AAPL | Stock | 42.725 | 42.725 | 42.7 | 42.7 | 1600.0 |
| 2019-02-11 06:35:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 1560.0 |
| 2019-02-11 06:40:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 400.0 |
| 2019-02-11 06:45:00 | AAPL | Stock | 42.7 | 42.7 | 42.675 | 42.675 | 2344.0 |
| 2019-02-11 06:50:00 | AAPL | Stock | 42.6875 | 42.6875 | 42.6875 | 42.6875 | 3600.0 |
| 2019-02-11 06:55:00 | AAPL | Stock | 42.6925 | 42.6925 | 42.6375 | 42.6875 | 6400.0 |
| 2019-02-11 07:00:00 | AAPL | Stock | 42.6975 | 42.7075 | 42.6375 | 42.6425 | 22028.0 |
| 2019-02-11 07:05:00 | AAPL | Stock | 42.6525 | 42.675 | 42.6375 | 42.675 | 5004.0 |
| 2019-02-11 07:10:00 | AAPL | Stock | 42.675 | 42.6875 | 42.675 | 42.6875 | 2000.0 |
| 2019-02-11 07:15:00 | AAPL | Stock | 42.7225 | 42.735 | 42.7225 | 42.7325 | 3200.0 |
| 2019-02-11 07:20:00 | AAPL | Stock | 42.7175 | 42.75 | 42.7025 | 42.7275 | 20400.0 |
| 2019-02-11 07:25:00 | AAPL | Stock | 42.725 | 42.7325 | 42.7225 | 42.7325 | 2800.0 |
| 2019-02-11 07:30:00 | AAPL | Stock | 42.745 | 42.745 | 42.7375 | 42.7375 | 1400.0 |
| 2019-02-11 07:35:00 | AAPL | Stock | 42.73 | 42.73 | 42.72 | 42.725 | 10544.0 |
| 2019-02-11 07:40:00 | AAPL | Stock | 42.72 | 42.72 | 42.72 | 42.72 | 4800.0 |
| 2019-02-11 07:45:00 | AAPL | Stock | 42.74 | 42.75 | 42.7375 | 42.75 | 40636.0 |
| 2019-02-11 07:50:00 | AAPL | Stock | 42.7625 | 42.7725 | 42.7625 | 42.7725 | 7748.0 |
| 2019-02-11 07:55:00 | AAPL | Stock | 42.7725 | 42.785 | 42.7725 | 42.785 | 5796.0 |
| 2019-02-11 08:00:00 | AAPL | Stock | 42.6875 | 42.7875 | 42.67 | 42.7875 | 58380.0 |
| 2019-02-11 08:05:00 | AAPL | Stock | 42.7825 | 42.7875 | 42.765 | 42.7775 | 9972.0 |
| 2019-02-11 08:10:00 | AAPL | Stock | 42.7775 | 42.81 | 42.765 | 42.8 | 17424.0 |
| 2019-02-11 08:15:00 | AAPL | Stock | 42.8 | 42.845 | 42.785 | 42.815 | 23136.0 |
| 2019-02-11 08:20:00 | AAPL | Stock | 42.8 | 42.815 | 42.8 | 42.8125 | 9720.0 |
| 2019-02-11 08:25:00 | AAPL | Stock | 42.7925 | 42.8225 | 42.785 | 42.8 | 33608.0 |
| 2019-02-11 08:30:00 | AAPL | Stock | 42.8 | 42.8 | 42.7625 | 42.775 | 18472.0 |
| 2019-02-11 08:35:00 | AAPL | Stock | 42.7875 | 42.8075 | 42.7875 | 42.8075 | 6600.0 |
| 2019-02-11 08:40:00 | AAPL | Stock | 42.8025 | 42.805 | 42.79 | 42.805 | 11632.0 |
| 2019-02-11 08:45:00 | AAPL | Stock | 42.805 | 42.805 | 42.7875 | 42.8 | 20184.0 |
| 2019-02-11 08:50:00 | AAPL | Stock | 42.7875 | 42.7875 | 42.7525 | 42.76 | 49180.0 |
| 2019-02-11 08:55:00 | AAPL | Stock | 42.76 | 42.7975 | 42.76 | 42.7875 | 8920.0 |
| 2019-02-11 09:00:00 | AAPL | Stock | 42.795 | 42.795 | 42.75 | 42.7625 | 24988.0 |
| 2019-02-11 09:05:00 | AAPL | Stock | 42.775 | 42.8 | 42.7525 | 42.8 | 21040.0 |
| 2019-02-11 09:10:00 | AAPL | Stock | 42.8 | 42.8025 | 42.775 | 42.775 | 15384.0 |
| 2019-02-11 09:15:00 | AAPL | Stock | 42.78 | 42.78 | 42.75 | 42.7575 | 22204.0 |
| 2019-02-11 09:20:00 | AAPL | Stock | 42.75 | 42.75 | 42.71 | 42.7275 | 22088.0 |
| 2019-02-11 09:25:00 | AAPL | Stock | 42.7325 | 42.7675 | 42.7325 | 42.7475 | 19972.0 |
| 2019-02-11 09:30:00 | AAPL | Stock | 42.7625 | 42.8025 | 42.5825 | 42.67 | 3418484.0 |
| 2019-02-11 09:35:00 | AAPL | Stock | 42.6675 | 42.78 | 42.5875 | 42.595 | 1558692.0 |
| 2019-02-11 09:40:00 | AAPL | Stock | 42.595 | 42.6 | 42.3975 | 42.4 | 2399396.0 |
> showing 50 of 345,585 rows — these rows as CSV