PREVIEW / stock_5min / 2016-09-12
file: by_date/stock_5min/2016/2016-09-12.parquet size: 5.5 MB rows: 363,247 symbols: 3,239
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-09-12 04:00:00 | AAPL | Stock | 25.5025 | 25.535 | 25.5025 | 25.535 | 30800.0 |
| 2016-09-12 04:10:00 | AAPL | Stock | 25.5625 | 25.5625 | 25.5625 | 25.5625 | 1280.0 |
| 2016-09-12 04:20:00 | AAPL | Stock | 25.5175 | 25.5175 | 25.5175 | 25.5175 | 400.0 |
| 2016-09-12 04:30:00 | AAPL | Stock | 25.515 | 25.515 | 25.51 | 25.51 | 4400.0 |
| 2016-09-12 04:35:00 | AAPL | Stock | 25.51 | 25.515 | 25.51 | 25.515 | 15092.0 |
| 2016-09-12 04:45:00 | AAPL | Stock | 25.51 | 25.51 | 25.4775 | 25.4775 | 18860.0 |
| 2016-09-12 04:50:00 | AAPL | Stock | 25.51 | 25.51 | 25.51 | 25.51 | 2000.0 |
| 2016-09-12 05:05:00 | AAPL | Stock | 25.55 | 25.55 | 25.55 | 25.55 | 800.0 |
| 2016-09-12 05:20:00 | AAPL | Stock | 25.55 | 25.55 | 25.55 | 25.55 | 2796.0 |
| 2016-09-12 05:30:00 | AAPL | Stock | 25.575 | 25.575 | 25.55 | 25.55 | 800.0 |
| 2016-09-12 05:40:00 | AAPL | Stock | 25.55 | 25.55 | 25.5 | 25.5 | 2732.0 |
| 2016-09-12 05:45:00 | AAPL | Stock | 25.5 | 25.5375 | 25.5 | 25.5375 | 7340.0 |
| 2016-09-12 05:50:00 | AAPL | Stock | 25.5375 | 25.55 | 25.5375 | 25.55 | 2400.0 |
| 2016-09-12 05:55:00 | AAPL | Stock | 25.5025 | 25.5025 | 25.5 | 25.5 | 800.0 |
| 2016-09-12 06:05:00 | AAPL | Stock | 25.5025 | 25.5025 | 25.5025 | 25.5025 | 800.0 |
| 2016-09-12 06:10:00 | AAPL | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 4000.0 |
| 2016-09-12 06:15:00 | AAPL | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 2400.0 |
| 2016-09-12 06:25:00 | AAPL | Stock | 25.4975 | 25.5 | 25.475 | 25.475 | 21200.0 |
| 2016-09-12 06:30:00 | AAPL | Stock | 25.4625 | 25.4625 | 25.455 | 25.455 | 2472.0 |
| 2016-09-12 06:35:00 | AAPL | Stock | 25.4625 | 25.4625 | 25.4625 | 25.4625 | 2400.0 |
| 2016-09-12 06:40:00 | AAPL | Stock | 25.455 | 25.455 | 25.455 | 25.455 | 7020.0 |
| 2016-09-12 06:45:00 | AAPL | Stock | 25.47 | 25.4925 | 25.4575 | 25.4925 | 5252.0 |
| 2016-09-12 06:50:00 | AAPL | Stock | 25.4625 | 25.4625 | 25.4625 | 25.4625 | 440.0 |
| 2016-09-12 06:55:00 | AAPL | Stock | 25.49 | 25.4925 | 25.49 | 25.49 | 8380.0 |
| 2016-09-12 07:00:00 | AAPL | Stock | 25.4925 | 25.53 | 25.4925 | 25.53 | 46872.0 |
| 2016-09-12 07:05:00 | AAPL | Stock | 25.5275 | 25.55 | 25.5175 | 25.525 | 11296.0 |
| 2016-09-12 07:10:00 | AAPL | Stock | 25.53 | 25.545 | 25.5275 | 25.53 | 13520.0 |
| 2016-09-12 07:15:00 | AAPL | Stock | 25.53 | 25.53 | 25.525 | 25.525 | 3664.0 |
| 2016-09-12 07:20:00 | AAPL | Stock | 25.53 | 25.53 | 25.5 | 25.5275 | 35160.0 |
| 2016-09-12 07:25:00 | AAPL | Stock | 25.525 | 25.525 | 25.51 | 25.525 | 10144.0 |
| 2016-09-12 07:30:00 | AAPL | Stock | 25.5275 | 25.53 | 25.5 | 25.5125 | 13732.0 |
| 2016-09-12 07:35:00 | AAPL | Stock | 25.5125 | 25.545 | 25.5125 | 25.545 | 18480.0 |
| 2016-09-12 07:40:00 | AAPL | Stock | 25.525 | 25.525 | 25.5 | 25.525 | 8152.0 |
| 2016-09-12 07:45:00 | AAPL | Stock | 25.525 | 25.5625 | 25.5175 | 25.5625 | 10856.0 |
| 2016-09-12 07:50:00 | AAPL | Stock | 25.5625 | 25.5625 | 25.5525 | 25.555 | 5728.0 |
| 2016-09-12 07:55:00 | AAPL | Stock | 25.6 | 25.645 | 25.575 | 25.6375 | 25552.0 |
| 2016-09-12 08:00:00 | AAPL | Stock | 25.6375 | 25.6375 | 25.45 | 25.62 | 142404.0 |
| 2016-09-12 08:05:00 | AAPL | Stock | 25.6225 | 25.66 | 25.6075 | 25.65 | 72712.0 |
| 2016-09-12 08:10:00 | AAPL | Stock | 25.65 | 25.6825 | 25.65 | 25.6625 | 43228.0 |
| 2016-09-12 08:15:00 | AAPL | Stock | 25.6725 | 25.6875 | 25.6625 | 25.6825 | 64864.0 |
| 2016-09-12 08:20:00 | AAPL | Stock | 25.6675 | 25.685 | 25.6625 | 25.665 | 39840.0 |
| 2016-09-12 08:25:00 | AAPL | Stock | 25.6725 | 25.675 | 25.65 | 25.65 | 34512.0 |
| 2016-09-12 08:30:00 | AAPL | Stock | 25.68 | 25.6925 | 25.67 | 25.68 | 9144.0 |
| 2016-09-12 08:35:00 | AAPL | Stock | 25.6875 | 25.7 | 25.68 | 25.7 | 14928.0 |
| 2016-09-12 08:40:00 | AAPL | Stock | 25.7 | 25.7375 | 25.7 | 25.7125 | 75304.0 |
| 2016-09-12 08:45:00 | AAPL | Stock | 25.7075 | 25.7075 | 25.6575 | 25.6575 | 32008.0 |
| 2016-09-12 08:50:00 | AAPL | Stock | 25.675 | 25.695 | 25.6525 | 25.695 | 27760.0 |
| 2016-09-12 08:55:00 | AAPL | Stock | 25.695 | 25.7225 | 25.6925 | 25.6925 | 38000.0 |
| 2016-09-12 09:00:00 | AAPL | Stock | 25.6925 | 25.7075 | 25.69 | 25.69 | 32976.0 |
| 2016-09-12 09:05:00 | AAPL | Stock | 25.7 | 25.7 | 25.6875 | 25.69 | 25844.0 |
> showing 50 of 363,247 rows — these rows as CSV