PREVIEW / stock_5min / 2019-02-21
file: by_date/stock_5min/2019/2019-02-21.parquet size: 5.5 MB rows: 351,452 symbols: 2,653
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-21 04:00:00 | AAPL | Stock | 43.0 | 43.0075 | 43.0 | 43.0075 | 2000.0 |
| 2019-02-21 04:05:00 | AAPL | Stock | 42.9625 | 42.9625 | 42.9625 | 42.9625 | 400.0 |
| 2019-02-21 04:10:00 | AAPL | Stock | 42.975 | 42.975 | 42.975 | 42.975 | 400.0 |
| 2019-02-21 04:15:00 | AAPL | Stock | 42.9875 | 42.9875 | 42.9875 | 42.9875 | 400.0 |
| 2019-02-21 04:30:00 | AAPL | Stock | 42.9275 | 42.9275 | 42.9275 | 42.9275 | 400.0 |
| 2019-02-21 04:50:00 | AAPL | Stock | 42.9125 | 42.9125 | 42.91 | 42.91 | 3240.0 |
| 2019-02-21 05:50:00 | AAPL | Stock | 42.9825 | 42.9825 | 42.9825 | 42.9825 | 1600.0 |
| 2019-02-21 06:05:00 | AAPL | Stock | 43.1 | 43.1 | 43.1 | 43.1 | 800.0 |
| 2019-02-21 06:20:00 | AAPL | Stock | 43.0825 | 43.0825 | 43.0825 | 43.0825 | 2388.0 |
| 2019-02-21 07:05:00 | AAPL | Stock | 43.08 | 43.08 | 43.08 | 43.08 | 404.0 |
| 2019-02-21 07:10:00 | AAPL | Stock | 43.0625 | 43.0625 | 42.9725 | 42.9725 | 12084.0 |
| 2019-02-21 07:15:00 | AAPL | Stock | 42.975 | 43.005 | 42.9375 | 43.0 | 18976.0 |
| 2019-02-21 07:25:00 | AAPL | Stock | 43.02 | 43.02 | 42.975 | 42.975 | 20180.0 |
| 2019-02-21 07:30:00 | AAPL | Stock | 42.9925 | 42.995 | 42.93 | 42.93 | 25556.0 |
| 2019-02-21 07:40:00 | AAPL | Stock | 42.9625 | 42.975 | 42.9625 | 42.975 | 2400.0 |
| 2019-02-21 07:45:00 | AAPL | Stock | 42.95 | 42.95 | 42.94 | 42.95 | 2588.0 |
| 2019-02-21 07:50:00 | AAPL | Stock | 42.9625 | 42.9625 | 42.9625 | 42.9625 | 1700.0 |
| 2019-02-21 07:55:00 | AAPL | Stock | 42.9525 | 42.955 | 42.94 | 42.94 | 7684.0 |
| 2019-02-21 08:00:00 | AAPL | Stock | 42.94 | 43.0925 | 42.9325 | 42.95 | 30728.0 |
| 2019-02-21 08:05:00 | AAPL | Stock | 42.95 | 42.9575 | 42.95 | 42.9575 | 4896.0 |
| 2019-02-21 08:10:00 | AAPL | Stock | 42.9875 | 43.0248 | 42.9875 | 43.0125 | 17320.0 |
| 2019-02-21 08:15:00 | AAPL | Stock | 43.005 | 43.03 | 42.9825 | 43.0 | 37032.0 |
| 2019-02-21 08:20:00 | AAPL | Stock | 43.02 | 43.045 | 43.0175 | 43.0375 | 8800.0 |
| 2019-02-21 08:25:00 | AAPL | Stock | 43.025 | 43.025 | 43.025 | 43.025 | 7448.0 |
| 2019-02-21 08:30:00 | AAPL | Stock | 43.0075 | 43.0125 | 42.9525 | 42.955 | 10952.0 |
| 2019-02-21 08:35:00 | AAPL | Stock | 42.98 | 42.995 | 42.955 | 42.9558 | 16216.0 |
| 2019-02-21 08:40:00 | AAPL | Stock | 42.965 | 42.985 | 42.965 | 42.9825 | 39988.0 |
| 2019-02-21 08:45:00 | AAPL | Stock | 42.98 | 42.9975 | 42.98 | 42.9975 | 2940.0 |
| 2019-02-21 08:50:00 | AAPL | Stock | 42.995 | 42.995 | 42.98 | 42.98 | 800.0 |
| 2019-02-21 08:55:00 | AAPL | Stock | 42.995 | 43.025 | 42.9825 | 43.0175 | 14980.0 |
| 2019-02-21 09:00:00 | AAPL | Stock | 43.0175 | 43.0175 | 42.97 | 42.9975 | 8900.0 |
| 2019-02-21 09:05:00 | AAPL | Stock | 42.98 | 42.9875 | 42.955 | 42.955 | 14020.0 |
| 2019-02-21 09:10:00 | AAPL | Stock | 42.9525 | 42.9525 | 42.9325 | 42.95 | 11060.0 |
| 2019-02-21 09:15:00 | AAPL | Stock | 42.9625 | 42.9725 | 42.9505 | 42.9505 | 2000.0 |
| 2019-02-21 09:20:00 | AAPL | Stock | 42.965 | 42.9875 | 42.95 | 42.9525 | 4668.0 |
| 2019-02-21 09:25:00 | AAPL | Stock | 42.965 | 42.9775 | 42.95 | 42.95 | 3028.0 |
| 2019-02-21 09:30:00 | AAPL | Stock | 42.95 | 43.0925 | 42.875 | 43.06 | 2921120.0 |
| 2019-02-21 09:35:00 | AAPL | Stock | 43.065 | 43.0775 | 42.9175 | 42.935 | 1835808.0 |
| 2019-02-21 09:40:00 | AAPL | Stock | 42.935 | 42.98 | 42.775 | 42.815 | 2012648.0 |
| 2019-02-21 09:45:00 | AAPL | Stock | 42.805 | 42.8425 | 42.705 | 42.722 | 1928628.0 |
| 2019-02-21 09:50:00 | AAPL | Stock | 42.72 | 42.8175 | 42.7088 | 42.7525 | 1769180.0 |
| 2019-02-21 09:55:00 | AAPL | Stock | 42.7525 | 42.845 | 42.72 | 42.8175 | 1342704.0 |
| 2019-02-21 10:00:00 | AAPL | Stock | 42.815 | 42.8175 | 42.7425 | 42.8125 | 1058520.0 |
| 2019-02-21 10:05:00 | AAPL | Stock | 42.815 | 42.85 | 42.755 | 42.795 | 1031120.0 |
| 2019-02-21 10:10:00 | AAPL | Stock | 42.7975 | 42.8075 | 42.7075 | 42.7225 | 1364380.0 |
| 2019-02-21 10:15:00 | AAPL | Stock | 42.7225 | 42.8375 | 42.705 | 42.7975 | 1175504.0 |
| 2019-02-21 10:20:00 | AAPL | Stock | 42.7975 | 42.8225 | 42.75 | 42.7975 | 884212.0 |
| 2019-02-21 10:25:00 | AAPL | Stock | 42.8 | 42.8088 | 42.7325 | 42.755 | 816848.0 |
| 2019-02-21 10:30:00 | AAPL | Stock | 42.7525 | 42.8 | 42.7525 | 42.77 | 671472.0 |
| 2019-02-21 10:35:00 | AAPL | Stock | 42.77 | 42.7825 | 42.7475 | 42.78 | 837352.0 |
> showing 50 of 351,452 rows — these rows as CSV