PREVIEW / stock_5min / 2017-07-12
file: by_date/stock_5min/2017/2017-07-12.parquet size: 5.3 MB rows: 350,824 symbols: 3,007
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-07-12 05:10:00 | AAPL | Stock | 36.45 | 36.45 | 36.45 | 36.45 | 400.0 |
| 2017-07-12 05:45:00 | AAPL | Stock | 36.4425 | 36.4425 | 36.4425 | 36.4425 | 1200.0 |
| 2017-07-12 05:50:00 | AAPL | Stock | 36.45 | 36.45 | 36.45 | 36.45 | 5504.0 |
| 2017-07-12 05:55:00 | AAPL | Stock | 36.5 | 36.5 | 36.5 | 36.5 | 400.0 |
| 2017-07-12 06:10:00 | AAPL | Stock | 36.4875 | 36.4875 | 36.4875 | 36.4875 | 14000.0 |
| 2017-07-12 06:50:00 | AAPL | Stock | 36.4675 | 36.4925 | 36.465 | 36.465 | 15796.0 |
| 2017-07-12 07:10:00 | AAPL | Stock | 36.4625 | 36.5 | 36.4625 | 36.5 | 12452.0 |
| 2017-07-12 07:15:00 | AAPL | Stock | 36.4875 | 36.4875 | 36.4875 | 36.4875 | 5400.0 |
| 2017-07-12 07:20:00 | AAPL | Stock | 36.4875 | 36.5 | 36.4875 | 36.5 | 19264.0 |
| 2017-07-12 07:25:00 | AAPL | Stock | 36.5375 | 36.5375 | 36.5375 | 36.5375 | 400.0 |
| 2017-07-12 07:30:00 | AAPL | Stock | 36.5375 | 36.5375 | 36.47 | 36.4775 | 14420.0 |
| 2017-07-12 07:35:00 | AAPL | Stock | 36.48 | 36.5 | 36.48 | 36.5 | 26064.0 |
| 2017-07-12 07:40:00 | AAPL | Stock | 36.5025 | 36.5025 | 36.5 | 36.5 | 12000.0 |
| 2017-07-12 07:45:00 | AAPL | Stock | 36.5 | 36.5 | 36.475 | 36.475 | 8516.0 |
| 2017-07-12 07:50:00 | AAPL | Stock | 36.475 | 36.475 | 36.45 | 36.4575 | 8964.0 |
| 2017-07-12 07:55:00 | AAPL | Stock | 36.4625 | 36.465 | 36.45 | 36.4625 | 52980.0 |
| 2017-07-12 08:00:00 | AAPL | Stock | 36.45 | 36.5525 | 36.4 | 36.42 | 53964.0 |
| 2017-07-12 08:05:00 | AAPL | Stock | 36.42 | 36.425 | 36.3975 | 36.4225 | 22960.0 |
| 2017-07-12 08:10:00 | AAPL | Stock | 36.4225 | 36.4225 | 36.4225 | 36.4225 | 800.0 |
| 2017-07-12 08:20:00 | AAPL | Stock | 36.4125 | 36.42 | 36.4025 | 36.42 | 24944.0 |
| 2017-07-12 08:25:00 | AAPL | Stock | 36.4225 | 36.4375 | 36.42 | 36.4375 | 26348.0 |
| 2017-07-12 08:30:00 | AAPL | Stock | 36.4475 | 36.5 | 36.4475 | 36.485 | 29316.0 |
| 2017-07-12 08:35:00 | AAPL | Stock | 36.4875 | 36.51 | 36.485 | 36.51 | 61548.0 |
| 2017-07-12 08:40:00 | AAPL | Stock | 36.5125 | 36.5175 | 36.5 | 36.51 | 33012.0 |
| 2017-07-12 08:45:00 | AAPL | Stock | 36.51 | 36.535 | 36.5 | 36.525 | 58556.0 |
| 2017-07-12 08:50:00 | AAPL | Stock | 36.5375 | 36.57 | 36.525 | 36.5275 | 60760.0 |
| 2017-07-12 08:55:00 | AAPL | Stock | 36.53 | 36.5375 | 36.53 | 36.53 | 30276.0 |
| 2017-07-12 09:00:00 | AAPL | Stock | 36.53 | 36.5475 | 36.45 | 36.45 | 171948.0 |
| 2017-07-12 09:05:00 | AAPL | Stock | 36.45 | 36.5 | 36.45 | 36.5 | 76024.0 |
| 2017-07-12 09:10:00 | AAPL | Stock | 36.4975 | 36.52 | 36.4825 | 36.52 | 52736.0 |
| 2017-07-12 09:15:00 | AAPL | Stock | 36.5175 | 36.545 | 36.51 | 36.51 | 129820.0 |
| 2017-07-12 09:20:00 | AAPL | Stock | 36.5025 | 36.505 | 36.4425 | 36.4625 | 147380.0 |
| 2017-07-12 09:25:00 | AAPL | Stock | 36.4575 | 36.5 | 36.45 | 36.4525 | 66064.0 |
| 2017-07-12 09:30:00 | AAPL | Stock | 36.455 | 36.545 | 36.315 | 36.3962 | 4938296.0 |
| 2017-07-12 09:35:00 | AAPL | Stock | 36.3975 | 36.4462 | 36.2925 | 36.375 | 2994340.0 |
| 2017-07-12 09:40:00 | AAPL | Stock | 36.3775 | 36.4425 | 36.375 | 36.4125 | 1897092.0 |
| 2017-07-12 09:45:00 | AAPL | Stock | 36.415 | 36.415 | 36.3425 | 36.345 | 1819560.0 |
| 2017-07-12 09:50:00 | AAPL | Stock | 36.3425 | 36.3975 | 36.24 | 36.2662 | 2791208.0 |
| 2017-07-12 09:55:00 | AAPL | Stock | 36.2625 | 36.3325 | 36.255 | 36.3225 | 1833188.0 |
| 2017-07-12 10:00:00 | AAPL | Stock | 36.325 | 36.38 | 36.3175 | 36.3225 | 1229588.0 |
| 2017-07-12 10:05:00 | AAPL | Stock | 36.3237 | 36.375 | 36.3025 | 36.31 | 1613348.0 |
| 2017-07-12 10:10:00 | AAPL | Stock | 36.31 | 36.31 | 36.2475 | 36.2775 | 1806740.0 |
| 2017-07-12 10:15:00 | AAPL | Stock | 36.2775 | 36.28 | 36.242 | 36.2425 | 1752776.0 |
| 2017-07-12 10:20:00 | AAPL | Stock | 36.2425 | 36.305 | 36.22 | 36.275 | 1518724.0 |
| 2017-07-12 10:25:00 | AAPL | Stock | 36.2775 | 36.3275 | 36.2525 | 36.3175 | 1157832.0 |
| 2017-07-12 10:30:00 | AAPL | Stock | 36.318 | 36.3225 | 36.2375 | 36.2375 | 1649788.0 |
| 2017-07-12 10:35:00 | AAPL | Stock | 36.2388 | 36.2625 | 36.2275 | 36.255 | 1315472.0 |
| 2017-07-12 10:40:00 | AAPL | Stock | 36.255 | 36.2662 | 36.205 | 36.2612 | 1363148.0 |
| 2017-07-12 10:45:00 | AAPL | Stock | 36.262 | 36.2975 | 36.26 | 36.2712 | 955100.0 |
| 2017-07-12 10:50:00 | AAPL | Stock | 36.27 | 36.2775 | 36.2275 | 36.2412 | 1017564.0 |
> showing 50 of 350,824 rows — these rows as CSV