PREVIEW / stock_5min / 2016-06-29
file: by_date/stock_5min/2016/2016-06-29.parquet size: 5.5 MB rows: 367,084 symbols: 3,297
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-06-29 04:20:00 | AAPL | Stock | 23.45 | 23.45 | 23.45 | 23.45 | 400.0 |
| 2016-06-29 04:35:00 | AAPL | Stock | 23.45 | 23.45 | 23.45 | 23.45 | 400.0 |
| 2016-06-29 04:40:00 | AAPL | Stock | 23.46 | 23.46 | 23.46 | 23.46 | 4000.0 |
| 2016-06-29 05:30:00 | AAPL | Stock | 23.495 | 23.495 | 23.495 | 23.495 | 640.0 |
| 2016-06-29 06:00:00 | AAPL | Stock | 23.4875 | 23.52 | 23.4875 | 23.52 | 5040.0 |
| 2016-06-29 06:05:00 | AAPL | Stock | 23.505 | 23.505 | 23.505 | 23.505 | 2000.0 |
| 2016-06-29 06:25:00 | AAPL | Stock | 23.505 | 23.505 | 23.5 | 23.5 | 800.0 |
| 2016-06-29 06:45:00 | AAPL | Stock | 23.4875 | 23.4875 | 23.4875 | 23.4875 | 2200.0 |
| 2016-06-29 06:50:00 | AAPL | Stock | 23.48 | 23.48 | 23.475 | 23.475 | 4792.0 |
| 2016-06-29 06:55:00 | AAPL | Stock | 23.495 | 23.495 | 23.495 | 23.495 | 520.0 |
| 2016-06-29 07:00:00 | AAPL | Stock | 23.475 | 23.475 | 23.47 | 23.47 | 10912.0 |
| 2016-06-29 07:05:00 | AAPL | Stock | 23.485 | 23.485 | 23.485 | 23.485 | 400.0 |
| 2016-06-29 07:10:00 | AAPL | Stock | 23.4875 | 23.495 | 23.4875 | 23.495 | 800.0 |
| 2016-06-29 07:15:00 | AAPL | Stock | 23.485 | 23.485 | 23.47 | 23.47 | 2732.0 |
| 2016-06-29 07:20:00 | AAPL | Stock | 23.4675 | 23.485 | 23.4675 | 23.485 | 2400.0 |
| 2016-06-29 07:25:00 | AAPL | Stock | 23.485 | 23.485 | 23.485 | 23.485 | 1212.0 |
| 2016-06-29 07:30:00 | AAPL | Stock | 23.485 | 23.495 | 23.485 | 23.495 | 8832.0 |
| 2016-06-29 07:35:00 | AAPL | Stock | 23.495 | 23.495 | 23.49 | 23.49 | 4000.0 |
| 2016-06-29 07:40:00 | AAPL | Stock | 23.49 | 23.4975 | 23.49 | 23.4975 | 3400.0 |
| 2016-06-29 07:45:00 | AAPL | Stock | 23.4975 | 23.4975 | 23.495 | 23.495 | 1600.0 |
| 2016-06-29 07:50:00 | AAPL | Stock | 23.4875 | 23.495 | 23.4875 | 23.495 | 2176.0 |
| 2016-06-29 07:55:00 | AAPL | Stock | 23.5 | 23.5075 | 23.5 | 23.5075 | 23988.0 |
| 2016-06-29 08:00:00 | AAPL | Stock | 23.5075 | 23.5125 | 23.465 | 23.5125 | 78732.0 |
| 2016-06-29 08:05:00 | AAPL | Stock | 23.5125 | 23.5125 | 23.51 | 23.5125 | 15904.0 |
| 2016-06-29 08:10:00 | AAPL | Stock | 23.5125 | 23.525 | 23.5125 | 23.525 | 800.0 |
| 2016-06-29 08:15:00 | AAPL | Stock | 23.515 | 23.5175 | 23.51 | 23.5175 | 26596.0 |
| 2016-06-29 08:20:00 | AAPL | Stock | 23.52 | 23.52 | 23.5175 | 23.52 | 5024.0 |
| 2016-06-29 08:25:00 | AAPL | Stock | 23.5125 | 23.5175 | 23.5125 | 23.5125 | 12780.0 |
| 2016-06-29 08:30:00 | AAPL | Stock | 23.5125 | 23.5175 | 23.5025 | 23.5125 | 36400.0 |
| 2016-06-29 08:35:00 | AAPL | Stock | 23.515 | 23.5175 | 23.515 | 23.5175 | 24560.0 |
| 2016-06-29 08:40:00 | AAPL | Stock | 23.5175 | 23.5325 | 23.515 | 23.5325 | 46284.0 |
| 2016-06-29 08:45:00 | AAPL | Stock | 23.5325 | 23.5325 | 23.515 | 23.5275 | 16172.0 |
| 2016-06-29 08:50:00 | AAPL | Stock | 23.5225 | 23.5325 | 23.52 | 23.5325 | 10844.0 |
| 2016-06-29 08:55:00 | AAPL | Stock | 23.52 | 23.5275 | 23.52 | 23.5275 | 10420.0 |
| 2016-06-29 09:00:00 | AAPL | Stock | 23.52 | 23.525 | 23.52 | 23.525 | 3664.0 |
| 2016-06-29 09:05:00 | AAPL | Stock | 23.5225 | 23.525 | 23.5225 | 23.525 | 6000.0 |
| 2016-06-29 09:10:00 | AAPL | Stock | 23.53 | 23.535 | 23.53 | 23.535 | 9112.0 |
| 2016-06-29 09:15:00 | AAPL | Stock | 23.535 | 23.535 | 23.5225 | 23.53 | 18788.0 |
| 2016-06-29 09:20:00 | AAPL | Stock | 23.53 | 23.53 | 23.51 | 23.51 | 36992.0 |
| 2016-06-29 09:25:00 | AAPL | Stock | 23.51 | 23.5175 | 23.475 | 23.4925 | 48824.0 |
| 2016-06-29 09:30:00 | AAPL | Stock | 23.4925 | 23.5425 | 23.455 | 23.5375 | 4924664.0 |
| 2016-06-29 09:35:00 | AAPL | Stock | 23.5375 | 23.5675 | 23.5025 | 23.5375 | 3649760.0 |
| 2016-06-29 09:40:00 | AAPL | Stock | 23.5375 | 23.575 | 23.505 | 23.5725 | 3336268.0 |
| 2016-06-29 09:45:00 | AAPL | Stock | 23.5712 | 23.6182 | 23.535 | 23.6172 | 3168700.0 |
| 2016-06-29 09:50:00 | AAPL | Stock | 23.6162 | 23.6275 | 23.5975 | 23.6075 | 2279868.0 |
| 2016-06-29 09:55:00 | AAPL | Stock | 23.61 | 23.6175 | 23.5725 | 23.6075 | 1937764.0 |
| 2016-06-29 10:00:00 | AAPL | Stock | 23.6075 | 23.615 | 23.5638 | 23.5745 | 2391064.0 |
| 2016-06-29 10:05:00 | AAPL | Stock | 23.575 | 23.59 | 23.5025 | 23.525 | 2538428.0 |
| 2016-06-29 10:10:00 | AAPL | Stock | 23.525 | 23.5725 | 23.5162 | 23.5375 | 1985340.0 |
| 2016-06-29 10:15:00 | AAPL | Stock | 23.5375 | 23.5575 | 23.4625 | 23.4862 | 3013840.0 |
> showing 50 of 367,084 rows — these rows as CSV