PREVIEW / stock_5min / 2019-01-11
file: by_date/stock_5min/2019/2019-01-11.parquet size: 5.5 MB rows: 352,440 symbols: 2,669
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 |
|---|---|---|---|---|---|---|---|
| 2019-01-11 04:00:00 | AAPL | Stock | 38.635 | 38.635 | 38.635 | 38.635 | 1200.0 |
| 2019-01-11 04:05:00 | AAPL | Stock | 38.565 | 38.565 | 38.56 | 38.56 | 884.0 |
| 2019-01-11 04:30:00 | AAPL | Stock | 38.62 | 38.635 | 38.6 | 38.6 | 3048.0 |
| 2019-01-11 04:35:00 | AAPL | Stock | 38.6 | 38.6325 | 38.6 | 38.6325 | 5004.0 |
| 2019-01-11 04:40:00 | AAPL | Stock | 38.575 | 38.575 | 38.575 | 38.575 | 1068.0 |
| 2019-01-11 05:00:00 | AAPL | Stock | 38.625 | 38.625 | 38.625 | 38.625 | 400.0 |
| 2019-01-11 05:05:00 | AAPL | Stock | 38.6325 | 38.6325 | 38.62 | 38.62 | 3924.0 |
| 2019-01-11 05:10:00 | AAPL | Stock | 38.6 | 38.6 | 38.6 | 38.6 | 5200.0 |
| 2019-01-11 05:15:00 | AAPL | Stock | 38.605 | 38.605 | 38.605 | 38.605 | 1676.0 |
| 2019-01-11 05:20:00 | AAPL | Stock | 38.55 | 38.55 | 38.5275 | 38.5275 | 5340.0 |
| 2019-01-11 05:25:00 | AAPL | Stock | 38.56 | 38.5875 | 38.56 | 38.5875 | 4136.0 |
| 2019-01-11 05:30:00 | AAPL | Stock | 38.5275 | 38.5275 | 38.5275 | 38.5275 | 1960.0 |
| 2019-01-11 05:35:00 | AAPL | Stock | 38.525 | 38.525 | 38.5 | 38.5 | 3200.0 |
| 2019-01-11 05:40:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 400.0 |
| 2019-01-11 05:45:00 | AAPL | Stock | 38.45 | 38.5 | 38.45 | 38.5 | 2504.0 |
| 2019-01-11 05:50:00 | AAPL | Stock | 38.5 | 38.5225 | 38.5 | 38.5225 | 948.0 |
| 2019-01-11 06:10:00 | AAPL | Stock | 38.565 | 38.62 | 38.565 | 38.62 | 3280.0 |
| 2019-01-11 06:20:00 | AAPL | Stock | 38.49 | 38.49 | 38.4625 | 38.4625 | 6800.0 |
| 2019-01-11 06:25:00 | AAPL | Stock | 38.49 | 38.49 | 38.49 | 38.49 | 5976.0 |
| 2019-01-11 06:30:00 | AAPL | Stock | 38.48 | 38.4875 | 38.475 | 38.4875 | 7136.0 |
| 2019-01-11 06:35:00 | AAPL | Stock | 38.565 | 38.565 | 38.565 | 38.565 | 400.0 |
| 2019-01-11 06:50:00 | AAPL | Stock | 38.55 | 38.55 | 38.5425 | 38.5425 | 800.0 |
| 2019-01-11 06:55:00 | AAPL | Stock | 38.54 | 38.54 | 38.475 | 38.495 | 8328.0 |
| 2019-01-11 07:00:00 | AAPL | Stock | 38.5125 | 38.5125 | 38.43 | 38.43 | 25604.0 |
| 2019-01-11 07:05:00 | AAPL | Stock | 38.4125 | 38.4625 | 38.4125 | 38.4625 | 1856.0 |
| 2019-01-11 07:10:00 | AAPL | Stock | 38.4625 | 38.4625 | 38.425 | 38.4625 | 6760.0 |
| 2019-01-11 07:15:00 | AAPL | Stock | 38.4425 | 38.4625 | 38.4425 | 38.4625 | 3600.0 |
| 2019-01-11 07:20:00 | AAPL | Stock | 38.4625 | 38.475 | 38.4575 | 38.4575 | 7348.0 |
| 2019-01-11 07:25:00 | AAPL | Stock | 38.4625 | 38.4625 | 38.4625 | 38.4625 | 3200.0 |
| 2019-01-11 07:30:00 | AAPL | Stock | 38.4625 | 38.48 | 38.4625 | 38.48 | 2836.0 |
| 2019-01-11 07:35:00 | AAPL | Stock | 38.455 | 38.4625 | 38.45 | 38.45 | 1600.0 |
| 2019-01-11 07:40:00 | AAPL | Stock | 38.45 | 38.4625 | 38.45 | 38.45 | 3472.0 |
| 2019-01-11 07:45:00 | AAPL | Stock | 38.455 | 38.4725 | 38.455 | 38.4725 | 1072.0 |
| 2019-01-11 07:50:00 | AAPL | Stock | 38.45 | 38.4525 | 38.4 | 38.4 | 22180.0 |
| 2019-01-11 07:55:00 | AAPL | Stock | 38.4 | 38.4 | 38.325 | 38.3275 | 19616.0 |
| 2019-01-11 08:00:00 | AAPL | Stock | 38.5 | 38.55 | 38.295 | 38.296 | 98796.0 |
| 2019-01-11 08:05:00 | AAPL | Stock | 38.295 | 38.3 | 38.2125 | 38.25 | 46540.0 |
| 2019-01-11 08:10:00 | AAPL | Stock | 38.2525 | 38.3125 | 38.25 | 38.2775 | 28104.0 |
| 2019-01-11 08:15:00 | AAPL | Stock | 38.275 | 38.2975 | 38.2725 | 38.275 | 14576.0 |
| 2019-01-11 08:20:00 | AAPL | Stock | 38.2625 | 38.275 | 38.255 | 38.255 | 47352.0 |
| 2019-01-11 08:25:00 | AAPL | Stock | 38.255 | 38.2725 | 38.1675 | 38.225 | 60272.0 |
| 2019-01-11 08:30:00 | AAPL | Stock | 38.25 | 38.295 | 38.25 | 38.26 | 39584.0 |
| 2019-01-11 08:35:00 | AAPL | Stock | 38.275 | 38.275 | 38.1875 | 38.22 | 53484.0 |
| 2019-01-11 08:40:00 | AAPL | Stock | 38.2125 | 38.225 | 38.1875 | 38.2125 | 48372.0 |
| 2019-01-11 08:45:00 | AAPL | Stock | 38.225 | 38.2275 | 38.205 | 38.205 | 11424.0 |
| 2019-01-11 08:50:00 | AAPL | Stock | 38.2075 | 38.2225 | 38.1875 | 38.1875 | 28168.0 |
| 2019-01-11 08:55:00 | AAPL | Stock | 38.2 | 38.24 | 38.1875 | 38.2375 | 37448.0 |
| 2019-01-11 09:00:00 | AAPL | Stock | 38.2475 | 38.2625 | 38.2125 | 38.2625 | 23980.0 |
| 2019-01-11 09:05:00 | AAPL | Stock | 38.2625 | 38.285 | 38.25 | 38.265 | 17176.0 |
| 2019-01-11 09:10:00 | AAPL | Stock | 38.275 | 38.285 | 38.25 | 38.25 | 43724.0 |
> showing 50 of 352,440 rows — these rows as CSV