PREVIEW / stock_5min / 2016-10-11
file: by_date/stock_5min/2016/2016-10-11.parquet size: 5.2 MB rows: 342,779 symbols: 3,190
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-10-11 04:00:00 | AAPL | Stock | 29.1025 | 29.125 | 29.1025 | 29.125 | 1600.0 |
| 2016-10-11 04:05:00 | AAPL | Stock | 29.1025 | 29.1025 | 29.1025 | 29.1025 | 400.0 |
| 2016-10-11 04:10:00 | AAPL | Stock | 29.1825 | 29.1825 | 29.1825 | 29.1825 | 720.0 |
| 2016-10-11 04:20:00 | AAPL | Stock | 29.15 | 29.15 | 29.135 | 29.135 | 4800.0 |
| 2016-10-11 04:25:00 | AAPL | Stock | 29.15 | 29.175 | 29.15 | 29.175 | 62904.0 |
| 2016-10-11 04:30:00 | AAPL | Stock | 29.1875 | 29.2375 | 29.175 | 29.2 | 6240.0 |
| 2016-10-11 04:35:00 | AAPL | Stock | 29.2125 | 29.2125 | 29.2 | 29.2 | 1728.0 |
| 2016-10-11 04:40:00 | AAPL | Stock | 29.2125 | 29.225 | 29.2125 | 29.225 | 800.0 |
| 2016-10-11 04:45:00 | AAPL | Stock | 29.225 | 29.2375 | 29.225 | 29.2375 | 1600.0 |
| 2016-10-11 04:50:00 | AAPL | Stock | 29.2175 | 29.2175 | 29.2175 | 29.2175 | 400.0 |
| 2016-10-11 04:55:00 | AAPL | Stock | 29.2125 | 29.2125 | 29.2125 | 29.2125 | 724.0 |
| 2016-10-11 05:00:00 | AAPL | Stock | 29.2275 | 29.23 | 29.225 | 29.225 | 4324.0 |
| 2016-10-11 05:05:00 | AAPL | Stock | 29.2225 | 29.2375 | 29.2225 | 29.2375 | 20072.0 |
| 2016-10-11 05:10:00 | AAPL | Stock | 29.2375 | 29.25 | 29.2375 | 29.2375 | 11816.0 |
| 2016-10-11 05:15:00 | AAPL | Stock | 29.215 | 29.215 | 29.215 | 29.215 | 1880.0 |
| 2016-10-11 05:20:00 | AAPL | Stock | 29.215 | 29.215 | 29.215 | 29.215 | 1536.0 |
| 2016-10-11 05:30:00 | AAPL | Stock | 29.2375 | 29.2375 | 29.2375 | 29.2375 | 400.0 |
| 2016-10-11 05:35:00 | AAPL | Stock | 29.2375 | 29.2375 | 29.2375 | 29.2375 | 4000.0 |
| 2016-10-11 05:45:00 | AAPL | Stock | 29.215 | 29.215 | 29.175 | 29.175 | 10696.0 |
| 2016-10-11 05:50:00 | AAPL | Stock | 29.2025 | 29.2025 | 29.2025 | 29.2025 | 6000.0 |
| 2016-10-11 06:00:00 | AAPL | Stock | 29.22 | 29.22 | 29.22 | 29.22 | 11136.0 |
| 2016-10-11 06:05:00 | AAPL | Stock | 29.2 | 29.22 | 29.2 | 29.22 | 16356.0 |
| 2016-10-11 06:10:00 | AAPL | Stock | 29.22 | 29.2475 | 29.2175 | 29.2175 | 62968.0 |
| 2016-10-11 06:15:00 | AAPL | Stock | 29.22 | 29.22 | 29.22 | 29.22 | 400.0 |
| 2016-10-11 06:20:00 | AAPL | Stock | 29.22 | 29.2375 | 29.215 | 29.2375 | 1400.0 |
| 2016-10-11 06:25:00 | AAPL | Stock | 29.235 | 29.245 | 29.235 | 29.245 | 10300.0 |
| 2016-10-11 06:30:00 | AAPL | Stock | 29.245 | 29.245 | 29.235 | 29.235 | 4616.0 |
| 2016-10-11 06:35:00 | AAPL | Stock | 29.245 | 29.2725 | 29.245 | 29.2725 | 6096.0 |
| 2016-10-11 06:40:00 | AAPL | Stock | 29.275 | 29.3 | 29.275 | 29.3 | 170848.0 |
| 2016-10-11 06:45:00 | AAPL | Stock | 29.3175 | 29.3375 | 29.3175 | 29.3275 | 79440.0 |
| 2016-10-11 06:50:00 | AAPL | Stock | 29.325 | 29.3675 | 29.325 | 29.3625 | 55548.0 |
| 2016-10-11 06:55:00 | AAPL | Stock | 29.3625 | 29.375 | 29.34 | 29.3525 | 30876.0 |
| 2016-10-11 07:00:00 | AAPL | Stock | 29.3525 | 29.3575 | 29.3 | 29.3425 | 131452.0 |
| 2016-10-11 07:05:00 | AAPL | Stock | 29.3425 | 29.36 | 29.3425 | 29.36 | 97456.0 |
| 2016-10-11 07:10:00 | AAPL | Stock | 29.3625 | 29.37 | 29.3375 | 29.35 | 126428.0 |
| 2016-10-11 07:15:00 | AAPL | Stock | 29.3475 | 29.37 | 29.3375 | 29.3375 | 109704.0 |
| 2016-10-11 07:20:00 | AAPL | Stock | 29.3475 | 29.425 | 29.3475 | 29.4175 | 123156.0 |
| 2016-10-11 07:25:00 | AAPL | Stock | 29.425 | 29.445 | 29.39 | 29.425 | 173304.0 |
| 2016-10-11 07:30:00 | AAPL | Stock | 29.4325 | 29.65 | 29.4325 | 29.6125 | 286304.0 |
| 2016-10-11 07:35:00 | AAPL | Stock | 29.605 | 29.75 | 29.595 | 29.625 | 276600.0 |
| 2016-10-11 07:40:00 | AAPL | Stock | 29.6125 | 29.6425 | 29.5775 | 29.6125 | 338940.0 |
| 2016-10-11 07:45:00 | AAPL | Stock | 29.6125 | 29.66 | 29.59 | 29.6025 | 287588.0 |
| 2016-10-11 07:50:00 | AAPL | Stock | 29.6 | 29.75 | 29.5625 | 29.5825 | 142128.0 |
| 2016-10-11 07:55:00 | AAPL | Stock | 29.5825 | 29.5875 | 29.5425 | 29.5875 | 116072.0 |
| 2016-10-11 08:00:00 | AAPL | Stock | 29.5625 | 29.6475 | 29.2725 | 29.4775 | 1153096.0 |
| 2016-10-11 08:05:00 | AAPL | Stock | 29.4775 | 29.51 | 29.4575 | 29.4775 | 399532.0 |
| 2016-10-11 08:10:00 | AAPL | Stock | 29.48 | 29.525 | 29.475 | 29.52 | 170824.0 |
| 2016-10-11 08:15:00 | AAPL | Stock | 29.525 | 29.5875 | 29.5 | 29.585 | 481184.0 |
| 2016-10-11 08:20:00 | AAPL | Stock | 29.5825 | 29.5875 | 29.5525 | 29.565 | 525092.0 |
| 2016-10-11 08:25:00 | AAPL | Stock | 29.565 | 29.5775 | 29.5075 | 29.5625 | 444616.0 |
> showing 50 of 342,779 rows — these rows as CSV