PREVIEW / stock_5min / 2016-09-21
file: by_date/stock_5min/2016/2016-09-21.parquet size: 5.3 MB rows: 352,436 symbols: 3,217
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-21 04:00:00 | AAPL | Stock | 28.505 | 28.505 | 28.505 | 28.505 | 3360.0 |
| 2016-09-21 04:15:00 | AAPL | Stock | 28.53 | 28.53 | 28.53 | 28.53 | 400.0 |
| 2016-09-21 04:20:00 | AAPL | Stock | 28.53 | 28.53 | 28.53 | 28.53 | 1640.0 |
| 2016-09-21 04:40:00 | AAPL | Stock | 28.53 | 28.53 | 28.53 | 28.53 | 960.0 |
| 2016-09-21 04:45:00 | AAPL | Stock | 28.53 | 28.53 | 28.53 | 28.53 | 436.0 |
| 2016-09-21 04:50:00 | AAPL | Stock | 28.55 | 28.55 | 28.55 | 28.55 | 400.0 |
| 2016-09-21 04:55:00 | AAPL | Stock | 28.55 | 28.5725 | 28.55 | 28.5725 | 1032.0 |
| 2016-09-21 05:15:00 | AAPL | Stock | 28.53 | 28.53 | 28.53 | 28.53 | 400.0 |
| 2016-09-21 05:35:00 | AAPL | Stock | 28.5525 | 28.5525 | 28.5525 | 28.5525 | 400.0 |
| 2016-09-21 05:55:00 | AAPL | Stock | 28.5625 | 28.65 | 28.5625 | 28.65 | 32768.0 |
| 2016-09-21 06:00:00 | AAPL | Stock | 28.665 | 28.735 | 28.3075 | 28.605 | 51732.0 |
| 2016-09-21 06:05:00 | AAPL | Stock | 28.575 | 28.575 | 28.575 | 28.575 | 2800.0 |
| 2016-09-21 06:30:00 | AAPL | Stock | 28.5675 | 28.5675 | 28.5675 | 28.5675 | 1956.0 |
| 2016-09-21 06:50:00 | AAPL | Stock | 28.565 | 28.565 | 28.565 | 28.565 | 1200.0 |
| 2016-09-21 07:00:00 | AAPL | Stock | 28.555 | 28.5625 | 28.555 | 28.56 | 4800.0 |
| 2016-09-21 07:05:00 | AAPL | Stock | 28.56 | 28.56 | 28.56 | 28.56 | 4000.0 |
| 2016-09-21 07:15:00 | AAPL | Stock | 28.56 | 28.56 | 28.53 | 28.53 | 4800.0 |
| 2016-09-21 07:20:00 | AAPL | Stock | 28.5375 | 28.5475 | 28.5375 | 28.5475 | 6800.0 |
| 2016-09-21 07:25:00 | AAPL | Stock | 28.56 | 28.56 | 28.5575 | 28.5575 | 4400.0 |
| 2016-09-21 07:30:00 | AAPL | Stock | 28.5475 | 28.605 | 28.5475 | 28.5875 | 9952.0 |
| 2016-09-21 07:35:00 | AAPL | Stock | 28.6175 | 28.63 | 28.575 | 28.575 | 14000.0 |
| 2016-09-21 07:40:00 | AAPL | Stock | 28.575 | 28.575 | 28.5525 | 28.5525 | 6200.0 |
| 2016-09-21 07:45:00 | AAPL | Stock | 28.5525 | 28.5525 | 28.55 | 28.55 | 9280.0 |
| 2016-09-21 07:50:00 | AAPL | Stock | 28.55 | 28.575 | 28.535 | 28.55 | 14200.0 |
| 2016-09-21 07:55:00 | AAPL | Stock | 28.55 | 28.55 | 28.55 | 28.55 | 800.0 |
| 2016-09-21 08:00:00 | AAPL | Stock | 28.545 | 28.5625 | 28.5 | 28.505 | 94188.0 |
| 2016-09-21 08:05:00 | AAPL | Stock | 28.505 | 28.51 | 28.48 | 28.51 | 28468.0 |
| 2016-09-21 08:10:00 | AAPL | Stock | 28.5125 | 28.5125 | 28.5125 | 28.5125 | 2304.0 |
| 2016-09-21 08:15:00 | AAPL | Stock | 28.5175 | 28.5375 | 28.5125 | 28.535 | 31812.0 |
| 2016-09-21 08:20:00 | AAPL | Stock | 28.525 | 28.5625 | 28.525 | 28.5625 | 14504.0 |
| 2016-09-21 08:25:00 | AAPL | Stock | 28.55 | 28.5525 | 28.5375 | 28.55 | 9440.0 |
| 2016-09-21 08:30:00 | AAPL | Stock | 28.55 | 28.575 | 28.55 | 28.56 | 34240.0 |
| 2016-09-21 08:35:00 | AAPL | Stock | 28.55 | 28.55 | 28.5375 | 28.5375 | 35736.0 |
| 2016-09-21 08:40:00 | AAPL | Stock | 28.525 | 28.54 | 28.525 | 28.535 | 18128.0 |
| 2016-09-21 08:45:00 | AAPL | Stock | 28.5425 | 28.5625 | 28.5325 | 28.5325 | 8380.0 |
| 2016-09-21 08:50:00 | AAPL | Stock | 28.5375 | 28.5375 | 28.525 | 28.5375 | 14784.0 |
| 2016-09-21 08:55:00 | AAPL | Stock | 28.5375 | 28.5375 | 28.51 | 28.5275 | 20404.0 |
| 2016-09-21 09:00:00 | AAPL | Stock | 28.52 | 28.52 | 28.5 | 28.5025 | 22000.0 |
| 2016-09-21 09:05:00 | AAPL | Stock | 28.5025 | 28.515 | 28.5025 | 28.515 | 5380.0 |
| 2016-09-21 09:10:00 | AAPL | Stock | 28.5075 | 28.515 | 28.5 | 28.5 | 10480.0 |
| 2016-09-21 09:15:00 | AAPL | Stock | 28.5 | 28.5175 | 28.5 | 28.5 | 7036.0 |
| 2016-09-21 09:20:00 | AAPL | Stock | 28.5 | 28.5 | 28.485 | 28.5 | 9516.0 |
| 2016-09-21 09:25:00 | AAPL | Stock | 28.4975 | 28.4975 | 28.4625 | 28.475 | 21428.0 |
| 2016-09-21 09:30:00 | AAPL | Stock | 28.4625 | 28.4972 | 28.3075 | 28.38 | 4893060.0 |
| 2016-09-21 09:35:00 | AAPL | Stock | 28.3815 | 28.4025 | 28.279 | 28.3275 | 3913920.0 |
| 2016-09-21 09:40:00 | AAPL | Stock | 28.325 | 28.375 | 28.3125 | 28.3125 | 2523084.0 |
| 2016-09-21 09:45:00 | AAPL | Stock | 28.32 | 28.3525 | 28.32 | 28.35 | 1186532.0 |
| 2016-09-21 09:50:00 | AAPL | Stock | 28.3485 | 28.365 | 28.3175 | 28.3225 | 1937420.0 |
| 2016-09-21 09:55:00 | AAPL | Stock | 28.3225 | 28.3252 | 28.2625 | 28.2868 | 2860152.0 |
| 2016-09-21 10:00:00 | AAPL | Stock | 28.285 | 28.2925 | 28.2575 | 28.28 | 2223708.0 |
> showing 50 of 352,436 rows — these rows as CSV