PREVIEW / stock_5min / 2016-06-21
file: by_date/stock_5min/2016/2016-06-21.parquet size: 5.3 MB rows: 353,392 symbols: 3,289
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 |
|---|---|---|---|---|---|---|---|
| 2016-06-21 04:00:00 | AAPL | Stock | 23.77 | 23.77 | 23.77 | 23.77 | 1200.0 |
| 2016-06-21 04:05:00 | AAPL | Stock | 23.77 | 23.77 | 23.77 | 23.77 | 800.0 |
| 2016-06-21 04:10:00 | AAPL | Stock | 23.7675 | 23.7675 | 23.7675 | 23.7675 | 800.0 |
| 2016-06-21 04:50:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.7875 | 23.7875 | 400.0 |
| 2016-06-21 04:55:00 | AAPL | Stock | 23.8 | 23.8 | 23.775 | 23.775 | 3440.0 |
| 2016-06-21 05:00:00 | AAPL | Stock | 23.7625 | 23.7625 | 23.7625 | 23.7625 | 3336.0 |
| 2016-06-21 05:35:00 | AAPL | Stock | 23.7775 | 23.7775 | 23.7775 | 23.7775 | 400.0 |
| 2016-06-21 05:40:00 | AAPL | Stock | 23.7525 | 23.7525 | 23.7525 | 23.7525 | 1668.0 |
| 2016-06-21 06:35:00 | AAPL | Stock | 23.775 | 23.775 | 23.775 | 23.775 | 400.0 |
| 2016-06-21 06:50:00 | AAPL | Stock | 23.7775 | 23.7775 | 23.765 | 23.765 | 10176.0 |
| 2016-06-21 06:55:00 | AAPL | Stock | 23.775 | 23.775 | 23.765 | 23.765 | 4368.0 |
| 2016-06-21 07:05:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.7875 | 23.7875 | 1120.0 |
| 2016-06-21 07:10:00 | AAPL | Stock | 23.795 | 23.795 | 23.795 | 23.795 | 1600.0 |
| 2016-06-21 07:15:00 | AAPL | Stock | 23.795 | 23.815 | 23.795 | 23.815 | 8560.0 |
| 2016-06-21 07:20:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.8125 | 23.8125 | 4000.0 |
| 2016-06-21 07:25:00 | AAPL | Stock | 23.79 | 23.79 | 23.79 | 23.79 | 3160.0 |
| 2016-06-21 07:30:00 | AAPL | Stock | 23.795 | 23.795 | 23.795 | 23.795 | 656.0 |
| 2016-06-21 07:35:00 | AAPL | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 800.0 |
| 2016-06-21 07:40:00 | AAPL | Stock | 23.7975 | 23.8 | 23.7975 | 23.8 | 1200.0 |
| 2016-06-21 07:45:00 | AAPL | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 400.0 |
| 2016-06-21 07:50:00 | AAPL | Stock | 23.795 | 23.795 | 23.785 | 23.785 | 12384.0 |
| 2016-06-21 07:55:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.7875 | 23.7875 | 6000.0 |
| 2016-06-21 08:00:00 | AAPL | Stock | 23.8 | 23.825 | 23.7625 | 23.825 | 56500.0 |
| 2016-06-21 08:05:00 | AAPL | Stock | 23.83 | 23.8325 | 23.815 | 23.815 | 9496.0 |
| 2016-06-21 08:10:00 | AAPL | Stock | 23.8175 | 23.8175 | 23.8025 | 23.8125 | 14888.0 |
| 2016-06-21 08:15:00 | AAPL | Stock | 23.8025 | 23.8025 | 23.7925 | 23.8025 | 7184.0 |
| 2016-06-21 08:25:00 | AAPL | Stock | 23.81 | 23.81 | 23.8075 | 23.81 | 5004.0 |
| 2016-06-21 08:30:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.7925 | 23.795 | 11560.0 |
| 2016-06-21 08:35:00 | AAPL | Stock | 23.79 | 23.795 | 23.7625 | 23.77 | 82772.0 |
| 2016-06-21 08:40:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.765 | 23.7875 | 31212.0 |
| 2016-06-21 08:45:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.775 | 23.775 | 2192.0 |
| 2016-06-21 08:50:00 | AAPL | Stock | 23.775 | 23.79 | 23.7725 | 23.79 | 6752.0 |
| 2016-06-21 08:55:00 | AAPL | Stock | 23.795 | 23.795 | 23.7925 | 23.795 | 6192.0 |
| 2016-06-21 09:00:00 | AAPL | Stock | 23.7925 | 23.8075 | 23.7925 | 23.8075 | 26580.0 |
| 2016-06-21 09:05:00 | AAPL | Stock | 23.8 | 23.8125 | 23.8 | 23.8125 | 4400.0 |
| 2016-06-21 09:10:00 | AAPL | Stock | 23.82 | 23.82 | 23.8 | 23.8125 | 6120.0 |
| 2016-06-21 09:15:00 | AAPL | Stock | 23.8025 | 23.8075 | 23.78 | 23.79 | 24732.0 |
| 2016-06-21 09:20:00 | AAPL | Stock | 23.78 | 23.8 | 23.775 | 23.78 | 36056.0 |
| 2016-06-21 09:25:00 | AAPL | Stock | 23.7825 | 23.7825 | 23.73 | 23.73 | 223544.0 |
| 2016-06-21 09:30:00 | AAPL | Stock | 23.735 | 23.9175 | 23.669 | 23.885 | 8686496.0 |
| 2016-06-21 09:35:00 | AAPL | Stock | 23.885 | 23.9925 | 23.885 | 23.9675 | 4571360.0 |
| 2016-06-21 09:40:00 | AAPL | Stock | 23.965 | 24.0075 | 23.9425 | 23.99 | 4801316.0 |
| 2016-06-21 09:45:00 | AAPL | Stock | 23.9925 | 23.9925 | 23.94 | 23.9625 | 2655876.0 |
| 2016-06-21 09:50:00 | AAPL | Stock | 23.9625 | 24.0175 | 23.955 | 24.0175 | 3011084.0 |
| 2016-06-21 09:55:00 | AAPL | Stock | 24.0175 | 24.035 | 24.005 | 24.0275 | 2435380.0 |
| 2016-06-21 10:00:00 | AAPL | Stock | 24.0275 | 24.0275 | 23.9425 | 23.955 | 3306540.0 |
| 2016-06-21 10:05:00 | AAPL | Stock | 23.955 | 23.965 | 23.9325 | 23.94 | 2413328.0 |
| 2016-06-21 10:10:00 | AAPL | Stock | 23.94 | 23.995 | 23.9225 | 23.9925 | 2360516.0 |
| 2016-06-21 10:15:00 | AAPL | Stock | 23.9938 | 23.995 | 23.9648 | 23.9888 | 1544856.0 |
| 2016-06-21 10:20:00 | AAPL | Stock | 23.9888 | 23.9975 | 23.9275 | 23.964 | 1908580.0 |
> showing 50 of 353,392 rows — these rows as CSV