PREVIEW / stock_5min / 2017-09-12
file: by_date/stock_5min/2017/2017-09-12.parquet size: 5.4 MB rows: 352,393 symbols: 2,973
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-09-12 04:00:00 | AAPL | Stock | 40.6125 | 40.6125 | 40.6125 | 40.6125 | 464.0 |
| 2017-09-12 04:05:00 | AAPL | Stock | 40.5675 | 40.5675 | 40.5675 | 40.5675 | 400.0 |
| 2017-09-12 04:10:00 | AAPL | Stock | 40.56 | 40.56 | 40.5525 | 40.5525 | 2800.0 |
| 2017-09-12 04:15:00 | AAPL | Stock | 40.575 | 40.5925 | 40.575 | 40.5925 | 1184.0 |
| 2017-09-12 04:20:00 | AAPL | Stock | 40.595 | 40.595 | 40.595 | 40.595 | 400.0 |
| 2017-09-12 04:50:00 | AAPL | Stock | 40.645 | 40.645 | 40.645 | 40.645 | 800.0 |
| 2017-09-12 04:55:00 | AAPL | Stock | 40.625 | 40.625 | 40.625 | 40.625 | 400.0 |
| 2017-09-12 05:00:00 | AAPL | Stock | 40.625 | 40.625 | 40.625 | 40.625 | 800.0 |
| 2017-09-12 05:05:00 | AAPL | Stock | 40.625 | 40.6425 | 40.625 | 40.625 | 12232.0 |
| 2017-09-12 05:10:00 | AAPL | Stock | 40.6425 | 40.6425 | 40.6425 | 40.6425 | 1080.0 |
| 2017-09-12 05:20:00 | AAPL | Stock | 40.6425 | 40.645 | 40.6425 | 40.645 | 2936.0 |
| 2017-09-12 05:25:00 | AAPL | Stock | 40.6575 | 40.6575 | 40.6575 | 40.6575 | 1308.0 |
| 2017-09-12 05:30:00 | AAPL | Stock | 40.74 | 40.745 | 40.74 | 40.745 | 1520.0 |
| 2017-09-12 05:35:00 | AAPL | Stock | 40.75 | 40.75 | 40.75 | 40.75 | 1860.0 |
| 2017-09-12 05:40:00 | AAPL | Stock | 40.7625 | 40.775 | 40.74 | 40.775 | 4992.0 |
| 2017-09-12 05:45:00 | AAPL | Stock | 40.8 | 40.845 | 40.7975 | 40.845 | 5988.0 |
| 2017-09-12 05:50:00 | AAPL | Stock | 40.8675 | 40.8675 | 40.825 | 40.825 | 1200.0 |
| 2017-09-12 06:00:00 | AAPL | Stock | 40.85 | 40.87 | 40.8 | 40.8125 | 15124.0 |
| 2017-09-12 06:05:00 | AAPL | Stock | 40.8125 | 40.8125 | 40.7975 | 40.8 | 2000.0 |
| 2017-09-12 06:10:00 | AAPL | Stock | 40.79 | 40.8 | 40.7875 | 40.7875 | 14920.0 |
| 2017-09-12 06:15:00 | AAPL | Stock | 40.7925 | 40.7925 | 40.765 | 40.765 | 8600.0 |
| 2017-09-12 06:20:00 | AAPL | Stock | 40.7925 | 40.8 | 40.775 | 40.79 | 6732.0 |
| 2017-09-12 06:25:00 | AAPL | Stock | 40.8 | 40.8 | 40.785 | 40.7875 | 32140.0 |
| 2017-09-12 06:30:00 | AAPL | Stock | 40.7975 | 40.8 | 40.7875 | 40.7875 | 16380.0 |
| 2017-09-12 06:35:00 | AAPL | Stock | 40.7775 | 40.7775 | 40.75 | 40.75 | 10396.0 |
| 2017-09-12 06:40:00 | AAPL | Stock | 40.7175 | 40.7175 | 40.7175 | 40.7175 | 800.0 |
| 2017-09-12 06:45:00 | AAPL | Stock | 40.7275 | 40.735 | 40.7125 | 40.725 | 30692.0 |
| 2017-09-12 06:50:00 | AAPL | Stock | 40.725 | 40.745 | 40.725 | 40.725 | 11792.0 |
| 2017-09-12 06:55:00 | AAPL | Stock | 40.7125 | 40.725 | 40.7125 | 40.725 | 6528.0 |
| 2017-09-12 07:00:00 | AAPL | Stock | 40.715 | 40.7225 | 40.6975 | 40.7125 | 45756.0 |
| 2017-09-12 07:05:00 | AAPL | Stock | 40.7175 | 40.725 | 40.6975 | 40.7 | 12172.0 |
| 2017-09-12 07:10:00 | AAPL | Stock | 40.68 | 40.705 | 40.68 | 40.705 | 21024.0 |
| 2017-09-12 07:15:00 | AAPL | Stock | 40.695 | 40.725 | 40.6925 | 40.725 | 14920.0 |
| 2017-09-12 07:20:00 | AAPL | Stock | 40.725 | 40.8125 | 40.7 | 40.8125 | 46020.0 |
| 2017-09-12 07:25:00 | AAPL | Stock | 40.825 | 40.85 | 40.825 | 40.825 | 52732.0 |
| 2017-09-12 07:30:00 | AAPL | Stock | 40.8225 | 40.8225 | 40.7625 | 40.7625 | 17268.0 |
| 2017-09-12 07:35:00 | AAPL | Stock | 40.775 | 40.775 | 40.7475 | 40.75 | 73752.0 |
| 2017-09-12 07:40:00 | AAPL | Stock | 40.75 | 40.7625 | 40.7325 | 40.7325 | 22180.0 |
| 2017-09-12 07:45:00 | AAPL | Stock | 40.7475 | 40.75 | 40.7275 | 40.7275 | 18308.0 |
| 2017-09-12 07:50:00 | AAPL | Stock | 40.7375 | 40.745 | 40.7125 | 40.7425 | 37792.0 |
| 2017-09-12 07:55:00 | AAPL | Stock | 40.745 | 40.795 | 40.745 | 40.75 | 72452.0 |
| 2017-09-12 08:00:00 | AAPL | Stock | 40.7525 | 40.8475 | 40.375 | 40.75 | 343764.0 |
| 2017-09-12 08:05:00 | AAPL | Stock | 40.75 | 40.75 | 40.7175 | 40.74 | 97120.0 |
| 2017-09-12 08:10:00 | AAPL | Stock | 40.72 | 40.725 | 40.705 | 40.7075 | 33316.0 |
| 2017-09-12 08:15:00 | AAPL | Stock | 40.705 | 40.72 | 40.7 | 40.715 | 61044.0 |
| 2017-09-12 08:20:00 | AAPL | Stock | 40.72 | 40.72 | 40.6775 | 40.6875 | 61592.0 |
| 2017-09-12 08:25:00 | AAPL | Stock | 40.6775 | 40.7 | 40.375 | 40.665 | 94276.0 |
| 2017-09-12 08:30:00 | AAPL | Stock | 40.665 | 40.705 | 40.6625 | 40.705 | 49940.0 |
| 2017-09-12 08:35:00 | AAPL | Stock | 40.7025 | 40.7125 | 40.695 | 40.7 | 113360.0 |
| 2017-09-12 08:40:00 | AAPL | Stock | 40.7 | 40.7 | 40.65 | 40.65 | 72828.0 |
> showing 50 of 352,393 rows — these rows as CSV