PREVIEW / stock_5min / 2018-10-23
file: by_date/stock_5min/2018/2018-10-23.parquet size: 5.8 MB rows: 364,429 symbols: 2,786
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-23 04:00:00 | AAPL | Stock | 54.9675 | 54.9675 | 54.375 | 54.5 | 9080.0 |
| 2018-10-23 04:05:00 | AAPL | Stock | 54.525 | 54.525 | 54.525 | 54.525 | 10528.0 |
| 2018-10-23 04:10:00 | AAPL | Stock | 54.4375 | 54.5 | 54.4375 | 54.5 | 3200.0 |
| 2018-10-23 04:15:00 | AAPL | Stock | 54.38 | 54.38 | 54.38 | 54.38 | 5120.0 |
| 2018-10-23 04:20:00 | AAPL | Stock | 54.375 | 54.375 | 54.375 | 54.375 | 1444.0 |
| 2018-10-23 04:25:00 | AAPL | Stock | 54.3275 | 54.395 | 54.3275 | 54.3575 | 4880.0 |
| 2018-10-23 04:30:00 | AAPL | Stock | 54.3275 | 54.3575 | 54.3275 | 54.3575 | 5216.0 |
| 2018-10-23 04:40:00 | AAPL | Stock | 54.42 | 54.42 | 54.3325 | 54.3325 | 2384.0 |
| 2018-10-23 04:45:00 | AAPL | Stock | 54.335 | 54.335 | 54.335 | 54.335 | 2000.0 |
| 2018-10-23 04:50:00 | AAPL | Stock | 54.3725 | 54.3725 | 54.335 | 54.335 | 2320.0 |
| 2018-10-23 04:55:00 | AAPL | Stock | 54.3375 | 54.4 | 54.3375 | 54.4 | 5576.0 |
| 2018-10-23 05:00:00 | AAPL | Stock | 54.3325 | 54.3325 | 54.25 | 54.25 | 3800.0 |
| 2018-10-23 05:10:00 | AAPL | Stock | 54.32 | 54.32 | 54.32 | 54.32 | 6180.0 |
| 2018-10-23 05:30:00 | AAPL | Stock | 54.25 | 54.25 | 54.22 | 54.22 | 5160.0 |
| 2018-10-23 05:35:00 | AAPL | Stock | 54.25 | 54.275 | 54.25 | 54.275 | 1932.0 |
| 2018-10-23 05:45:00 | AAPL | Stock | 54.32 | 54.32 | 54.32 | 54.32 | 1948.0 |
| 2018-10-23 05:50:00 | AAPL | Stock | 54.255 | 54.3575 | 54.2525 | 54.3575 | 1600.0 |
| 2018-10-23 05:55:00 | AAPL | Stock | 54.3625 | 54.3625 | 54.3625 | 54.3625 | 2400.0 |
| 2018-10-23 06:10:00 | AAPL | Stock | 54.325 | 54.325 | 54.3125 | 54.3125 | 1400.0 |
| 2018-10-23 06:15:00 | AAPL | Stock | 54.3125 | 54.3875 | 54.3125 | 54.375 | 1740.0 |
| 2018-10-23 06:20:00 | AAPL | Stock | 54.36 | 54.375 | 54.35 | 54.375 | 4680.0 |
| 2018-10-23 06:25:00 | AAPL | Stock | 54.375 | 54.375 | 54.31 | 54.31 | 1600.0 |
| 2018-10-23 06:30:00 | AAPL | Stock | 54.3175 | 54.3175 | 54.2425 | 54.2425 | 4404.0 |
| 2018-10-23 06:35:00 | AAPL | Stock | 54.25 | 54.275 | 54.2125 | 54.275 | 4604.0 |
| 2018-10-23 06:45:00 | AAPL | Stock | 54.2775 | 54.36 | 54.2775 | 54.36 | 3960.0 |
| 2018-10-23 06:50:00 | AAPL | Stock | 54.31 | 54.3925 | 54.31 | 54.3775 | 4572.0 |
| 2018-10-23 06:55:00 | AAPL | Stock | 54.405 | 54.4125 | 54.405 | 54.4125 | 10968.0 |
| 2018-10-23 07:00:00 | AAPL | Stock | 54.4375 | 54.5 | 54.4125 | 54.5 | 57520.0 |
| 2018-10-23 07:05:00 | AAPL | Stock | 54.505 | 54.5225 | 54.4125 | 54.4375 | 43792.0 |
| 2018-10-23 07:10:00 | AAPL | Stock | 54.425 | 54.4425 | 54.375 | 54.375 | 16172.0 |
| 2018-10-23 07:15:00 | AAPL | Stock | 54.3975 | 54.415 | 54.33 | 54.375 | 21508.0 |
| 2018-10-23 07:20:00 | AAPL | Stock | 54.37 | 54.375 | 54.275 | 54.3 | 43776.0 |
| 2018-10-23 07:25:00 | AAPL | Stock | 54.35 | 54.3625 | 54.3475 | 54.35 | 4348.0 |
| 2018-10-23 07:30:00 | AAPL | Stock | 54.35 | 54.3675 | 54.2875 | 54.29 | 17864.0 |
| 2018-10-23 07:35:00 | AAPL | Stock | 54.2875 | 54.2875 | 54.125 | 54.125 | 76700.0 |
| 2018-10-23 07:40:00 | AAPL | Stock | 54.13 | 54.1325 | 54.085 | 54.1 | 114876.0 |
| 2018-10-23 07:45:00 | AAPL | Stock | 54.1125 | 54.22 | 54.0975 | 54.22 | 18788.0 |
| 2018-10-23 07:50:00 | AAPL | Stock | 54.1975 | 54.2425 | 54.1875 | 54.2425 | 18028.0 |
| 2018-10-23 07:55:00 | AAPL | Stock | 54.2625 | 54.2875 | 54.2375 | 54.2875 | 24124.0 |
| 2018-10-23 08:00:00 | AAPL | Stock | 54.4375 | 54.55 | 54.0825 | 54.3025 | 232036.0 |
| 2018-10-23 08:05:00 | AAPL | Stock | 54.3025 | 54.3025 | 54.225 | 54.225 | 29756.0 |
| 2018-10-23 08:10:00 | AAPL | Stock | 54.25 | 54.25 | 54.1375 | 54.1375 | 97876.0 |
| 2018-10-23 08:15:00 | AAPL | Stock | 54.1375 | 54.2275 | 54.1375 | 54.2275 | 30984.0 |
| 2018-10-23 08:20:00 | AAPL | Stock | 54.23 | 54.2675 | 54.23 | 54.25 | 41284.0 |
| 2018-10-23 08:25:00 | AAPL | Stock | 54.2375 | 54.2525 | 54.0925 | 54.095 | 104948.0 |
| 2018-10-23 08:30:00 | AAPL | Stock | 54.1075 | 54.15 | 53.965 | 53.975 | 369480.0 |
| 2018-10-23 08:35:00 | AAPL | Stock | 53.9975 | 54.025 | 53.92 | 53.9625 | 150772.0 |
| 2018-10-23 08:40:00 | AAPL | Stock | 53.9625 | 53.9925 | 53.9425 | 53.965 | 94040.0 |
| 2018-10-23 08:45:00 | AAPL | Stock | 53.975 | 53.985 | 53.9275 | 53.9275 | 79492.0 |
| 2018-10-23 08:50:00 | AAPL | Stock | 53.935 | 54.0625 | 53.925 | 54.0425 | 107992.0 |
> showing 50 of 364,429 rows — these rows as CSV