PREVIEW / stock_5min / 2018-10-19
file: by_date/stock_5min/2018/2018-10-19.parquet size: 5.7 MB rows: 357,901 symbols: 2,746
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-10-19 04:00:00 | AAPL | Stock | 54.2975 | 54.3125 | 54.2975 | 54.3125 | 2800.0 |
| 2018-10-19 04:05:00 | AAPL | Stock | 54.27 | 54.27 | 54.255 | 54.255 | 800.0 |
| 2018-10-19 04:20:00 | AAPL | Stock | 54.2125 | 54.2125 | 54.17 | 54.17 | 4032.0 |
| 2018-10-19 04:55:00 | AAPL | Stock | 54.19 | 54.2375 | 54.19 | 54.2375 | 1940.0 |
| 2018-10-19 05:05:00 | AAPL | Stock | 54.35 | 54.38 | 54.35 | 54.38 | 10616.0 |
| 2018-10-19 05:15:00 | AAPL | Stock | 54.35 | 54.375 | 54.3475 | 54.375 | 2800.0 |
| 2018-10-19 05:35:00 | AAPL | Stock | 54.4 | 54.4625 | 54.4 | 54.4625 | 12436.0 |
| 2018-10-19 05:40:00 | AAPL | Stock | 54.5 | 54.5 | 54.5 | 54.5 | 400.0 |
| 2018-10-19 05:45:00 | AAPL | Stock | 54.4575 | 54.4575 | 54.4375 | 54.4375 | 3200.0 |
| 2018-10-19 05:50:00 | AAPL | Stock | 54.4 | 54.4 | 54.4 | 54.4 | 800.0 |
| 2018-10-19 05:55:00 | AAPL | Stock | 54.395 | 54.395 | 54.395 | 54.395 | 1488.0 |
| 2018-10-19 06:00:00 | AAPL | Stock | 54.3725 | 54.4 | 54.3725 | 54.39 | 14432.0 |
| 2018-10-19 06:05:00 | AAPL | Stock | 54.39 | 54.45 | 54.39 | 54.45 | 16244.0 |
| 2018-10-19 06:10:00 | AAPL | Stock | 54.375 | 54.375 | 54.37 | 54.375 | 4820.0 |
| 2018-10-19 06:15:00 | AAPL | Stock | 54.375 | 54.375 | 54.375 | 54.375 | 11180.0 |
| 2018-10-19 06:20:00 | AAPL | Stock | 54.4 | 54.4 | 54.4 | 54.4 | 400.0 |
| 2018-10-19 06:25:00 | AAPL | Stock | 54.4425 | 54.49 | 54.4425 | 54.4425 | 12280.0 |
| 2018-10-19 06:30:00 | AAPL | Stock | 54.5 | 54.5 | 54.5 | 54.5 | 400.0 |
| 2018-10-19 06:35:00 | AAPL | Stock | 54.5 | 54.5 | 54.485 | 54.4875 | 3600.0 |
| 2018-10-19 06:40:00 | AAPL | Stock | 54.4875 | 54.4975 | 54.4875 | 54.4975 | 1200.0 |
| 2018-10-19 06:45:00 | AAPL | Stock | 54.5 | 54.53 | 54.4975 | 54.53 | 13200.0 |
| 2018-10-19 06:50:00 | AAPL | Stock | 54.525 | 54.525 | 54.5 | 54.5 | 2400.0 |
| 2018-10-19 06:55:00 | AAPL | Stock | 54.5 | 54.53 | 54.4925 | 54.4925 | 12164.0 |
| 2018-10-19 07:00:00 | AAPL | Stock | 54.4625 | 54.5 | 54.4175 | 54.5 | 59872.0 |
| 2018-10-19 07:05:00 | AAPL | Stock | 54.5 | 54.5375 | 54.48 | 54.5 | 11620.0 |
| 2018-10-19 07:10:00 | AAPL | Stock | 54.54 | 54.55 | 54.5125 | 54.55 | 12368.0 |
| 2018-10-19 07:15:00 | AAPL | Stock | 54.5375 | 54.5625 | 54.525 | 54.5625 | 19112.0 |
| 2018-10-19 07:20:00 | AAPL | Stock | 54.5775 | 54.615 | 54.5775 | 54.6025 | 12400.0 |
| 2018-10-19 07:25:00 | AAPL | Stock | 54.6 | 54.6775 | 54.6 | 54.645 | 48252.0 |
| 2018-10-19 07:30:00 | AAPL | Stock | 54.625 | 54.63 | 54.5625 | 54.5625 | 39872.0 |
| 2018-10-19 07:35:00 | AAPL | Stock | 54.5625 | 54.595 | 54.55 | 54.585 | 20960.0 |
| 2018-10-19 07:40:00 | AAPL | Stock | 54.5875 | 54.6025 | 54.5775 | 54.6025 | 7936.0 |
| 2018-10-19 07:45:00 | AAPL | Stock | 54.6025 | 54.65 | 54.6025 | 54.6375 | 17076.0 |
| 2018-10-19 07:50:00 | AAPL | Stock | 54.625 | 54.625 | 54.59 | 54.62 | 29740.0 |
| 2018-10-19 07:55:00 | AAPL | Stock | 54.6175 | 54.6375 | 54.6 | 54.6375 | 30272.0 |
| 2018-10-19 08:00:00 | AAPL | Stock | 54.4795 | 54.7325 | 54.4425 | 54.7 | 185016.0 |
| 2018-10-19 08:05:00 | AAPL | Stock | 54.7175 | 54.725 | 54.5 | 54.7125 | 38236.0 |
| 2018-10-19 08:10:00 | AAPL | Stock | 54.7125 | 54.76 | 54.7125 | 54.76 | 89688.0 |
| 2018-10-19 08:15:00 | AAPL | Stock | 54.76 | 54.785 | 54.7225 | 54.765 | 72120.0 |
| 2018-10-19 08:20:00 | AAPL | Stock | 54.7475 | 54.75 | 54.7125 | 54.72 | 41544.0 |
| 2018-10-19 08:25:00 | AAPL | Stock | 54.735 | 54.735 | 54.6525 | 54.6825 | 57892.0 |
| 2018-10-19 08:30:00 | AAPL | Stock | 54.665 | 54.7025 | 54.6525 | 54.69 | 23512.0 |
| 2018-10-19 08:35:00 | AAPL | Stock | 54.6875 | 54.7 | 54.67 | 54.7 | 36028.0 |
| 2018-10-19 08:40:00 | AAPL | Stock | 54.6725 | 54.6725 | 54.625 | 54.6425 | 52304.0 |
| 2018-10-19 08:45:00 | AAPL | Stock | 54.65 | 54.6625 | 54.5825 | 54.5825 | 55468.0 |
| 2018-10-19 08:50:00 | AAPL | Stock | 54.5925 | 54.65 | 54.59 | 54.635 | 79444.0 |
| 2018-10-19 08:55:00 | AAPL | Stock | 54.6325 | 54.6625 | 54.615 | 54.6625 | 36480.0 |
| 2018-10-19 09:00:00 | AAPL | Stock | 54.6625 | 54.6625 | 54.5875 | 54.605 | 30992.0 |
| 2018-10-19 09:05:00 | AAPL | Stock | 54.6 | 54.6925 | 54.6 | 54.6775 | 29964.0 |
| 2018-10-19 09:10:00 | AAPL | Stock | 54.6875 | 54.6875 | 54.625 | 54.65 | 55192.0 |
> showing 50 of 357,901 rows — these rows as CSV