PREVIEW / stock_5min / 2018-06-20
file: by_date/stock_5min/2018/2018-06-20.parquet size: 5.7 MB rows: 366,047 symbols: 2,825
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 |
|---|---|---|---|---|---|---|---|
| 2018-06-20 04:05:00 | AAPL | Stock | 46.65 | 46.65 | 46.5 | 46.5 | 1176.0 |
| 2018-06-20 04:45:00 | AAPL | Stock | 46.62 | 46.62 | 46.62 | 46.62 | 400.0 |
| 2018-06-20 05:05:00 | AAPL | Stock | 46.62 | 46.62 | 46.62 | 46.62 | 3956.0 |
| 2018-06-20 05:10:00 | AAPL | Stock | 46.5925 | 46.5925 | 46.5925 | 46.5925 | 400.0 |
| 2018-06-20 05:15:00 | AAPL | Stock | 46.575 | 46.575 | 46.575 | 46.575 | 400.0 |
| 2018-06-20 05:45:00 | AAPL | Stock | 46.685 | 46.6875 | 46.685 | 46.6875 | 6600.0 |
| 2018-06-20 05:50:00 | AAPL | Stock | 46.675 | 46.675 | 46.675 | 46.675 | 3836.0 |
| 2018-06-20 06:15:00 | AAPL | Stock | 46.625 | 46.625 | 46.625 | 46.625 | 880.0 |
| 2018-06-20 06:20:00 | AAPL | Stock | 46.65 | 46.65 | 46.65 | 46.65 | 400.0 |
| 2018-06-20 06:35:00 | AAPL | Stock | 46.625 | 46.625 | 46.625 | 46.625 | 400.0 |
| 2018-06-20 06:45:00 | AAPL | Stock | 46.6275 | 46.6275 | 46.6275 | 46.6275 | 1200.0 |
| 2018-06-20 06:50:00 | AAPL | Stock | 46.6225 | 46.625 | 46.6225 | 46.625 | 1600.0 |
| 2018-06-20 07:00:00 | AAPL | Stock | 46.675 | 46.735 | 46.655 | 46.7175 | 42988.0 |
| 2018-06-20 07:05:00 | AAPL | Stock | 46.715 | 46.725 | 46.675 | 46.675 | 27220.0 |
| 2018-06-20 07:10:00 | AAPL | Stock | 46.685 | 46.69 | 46.6375 | 46.65 | 23484.0 |
| 2018-06-20 07:15:00 | AAPL | Stock | 46.6475 | 46.685 | 46.6475 | 46.6775 | 23776.0 |
| 2018-06-20 07:20:00 | AAPL | Stock | 46.675 | 46.675 | 46.6375 | 46.645 | 7164.0 |
| 2018-06-20 07:25:00 | AAPL | Stock | 46.6425 | 46.6725 | 46.6425 | 46.6725 | 5820.0 |
| 2018-06-20 07:30:00 | AAPL | Stock | 46.6825 | 46.6925 | 46.6825 | 46.6925 | 13820.0 |
| 2018-06-20 07:35:00 | AAPL | Stock | 46.6925 | 46.7 | 46.6825 | 46.6825 | 10772.0 |
| 2018-06-20 07:40:00 | AAPL | Stock | 46.6925 | 46.7 | 46.67 | 46.67 | 18900.0 |
| 2018-06-20 07:45:00 | AAPL | Stock | 46.6525 | 46.6625 | 46.6525 | 46.6625 | 3400.0 |
| 2018-06-20 07:50:00 | AAPL | Stock | 46.6625 | 46.675 | 46.6625 | 46.675 | 13752.0 |
| 2018-06-20 07:55:00 | AAPL | Stock | 46.6575 | 46.665 | 46.64 | 46.65 | 18532.0 |
| 2018-06-20 08:00:00 | AAPL | Stock | 46.665 | 46.75 | 46.64 | 46.65 | 151288.0 |
| 2018-06-20 08:05:00 | AAPL | Stock | 46.65 | 46.6625 | 46.6425 | 46.6625 | 26680.0 |
| 2018-06-20 08:10:00 | AAPL | Stock | 46.675 | 46.6825 | 46.6625 | 46.6825 | 5592.0 |
| 2018-06-20 08:15:00 | AAPL | Stock | 46.675 | 46.6975 | 46.675 | 46.685 | 33740.0 |
| 2018-06-20 08:20:00 | AAPL | Stock | 46.6775 | 46.7 | 46.6775 | 46.7 | 15412.0 |
| 2018-06-20 08:25:00 | AAPL | Stock | 46.6875 | 46.6925 | 46.665 | 46.675 | 14080.0 |
| 2018-06-20 08:30:00 | AAPL | Stock | 46.675 | 46.675 | 46.65 | 46.6575 | 13660.0 |
| 2018-06-20 08:35:00 | AAPL | Stock | 46.65 | 46.6575 | 46.635 | 46.65 | 30548.0 |
| 2018-06-20 08:40:00 | AAPL | Stock | 46.65 | 46.67 | 46.645 | 46.6575 | 16700.0 |
| 2018-06-20 08:45:00 | AAPL | Stock | 46.6575 | 46.6625 | 46.655 | 46.6575 | 16976.0 |
| 2018-06-20 08:50:00 | AAPL | Stock | 46.6675 | 46.675 | 46.6575 | 46.675 | 24348.0 |
| 2018-06-20 08:55:00 | AAPL | Stock | 46.6725 | 46.6975 | 46.6725 | 46.675 | 32072.0 |
| 2018-06-20 09:00:00 | AAPL | Stock | 46.685 | 46.695 | 46.675 | 46.6875 | 14448.0 |
| 2018-06-20 09:05:00 | AAPL | Stock | 46.6775 | 46.69 | 46.6775 | 46.69 | 14868.0 |
| 2018-06-20 09:10:00 | AAPL | Stock | 46.695 | 46.695 | 46.685 | 46.695 | 15996.0 |
| 2018-06-20 09:15:00 | AAPL | Stock | 46.6775 | 46.695 | 46.6775 | 46.695 | 11144.0 |
| 2018-06-20 09:20:00 | AAPL | Stock | 46.6925 | 46.695 | 46.685 | 46.685 | 14100.0 |
| 2018-06-20 09:25:00 | AAPL | Stock | 46.685 | 46.685 | 46.575 | 46.59 | 105748.0 |
| 2018-06-20 09:30:00 | AAPL | Stock | 46.5975 | 46.675 | 46.525 | 46.618 | 3475896.0 |
| 2018-06-20 09:35:00 | AAPL | Stock | 46.615 | 46.725 | 46.5875 | 46.6925 | 1936372.0 |
| 2018-06-20 09:40:00 | AAPL | Stock | 46.6925 | 46.74 | 46.665 | 46.6948 | 1836664.0 |
| 2018-06-20 09:45:00 | AAPL | Stock | 46.695 | 46.7425 | 46.6675 | 46.6825 | 1629112.0 |
| 2018-06-20 09:50:00 | AAPL | Stock | 46.6825 | 46.705 | 46.6125 | 46.6125 | 1313160.0 |
| 2018-06-20 09:55:00 | AAPL | Stock | 46.6162 | 46.6925 | 46.615 | 46.686 | 1299648.0 |
| 2018-06-20 10:00:00 | AAPL | Stock | 46.685 | 46.7125 | 46.64 | 46.6475 | 1116596.0 |
| 2018-06-20 10:05:00 | AAPL | Stock | 46.6475 | 46.7175 | 46.6465 | 46.67 | 958676.0 |
> showing 50 of 366,047 rows — these rows as CSV