PREVIEW / stock_5min / 2016-03-04
file: by_date/stock_5min/2016/2016-03-04.parquet size: 5.6 MB rows: 366,426 symbols: 3,350
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-03-04 04:05:00 | AAPL | Stock | 25.4 | 25.4 | 25.4 | 25.4 | 3600.0 |
| 2016-03-04 05:15:00 | AAPL | Stock | 25.4125 | 25.4125 | 25.4125 | 25.4125 | 800.0 |
| 2016-03-04 05:20:00 | AAPL | Stock | 25.4125 | 25.4125 | 25.4125 | 25.4125 | 6888.0 |
| 2016-03-04 05:30:00 | AAPL | Stock | 25.4375 | 25.4375 | 25.4375 | 25.4375 | 1376.0 |
| 2016-03-04 05:35:00 | AAPL | Stock | 25.475 | 25.475 | 25.39 | 25.3975 | 16224.0 |
| 2016-03-04 05:40:00 | AAPL | Stock | 25.445 | 25.445 | 25.445 | 25.445 | 4228.0 |
| 2016-03-04 05:50:00 | AAPL | Stock | 25.445 | 25.445 | 25.445 | 25.445 | 2000.0 |
| 2016-03-04 06:35:00 | AAPL | Stock | 25.4725 | 25.4725 | 25.4725 | 25.4725 | 1200.0 |
| 2016-03-04 06:40:00 | AAPL | Stock | 25.475 | 25.475 | 25.4575 | 25.4575 | 1200.0 |
| 2016-03-04 06:45:00 | AAPL | Stock | 25.475 | 25.475 | 25.475 | 25.475 | 1200.0 |
| 2016-03-04 06:50:00 | AAPL | Stock | 25.475 | 25.475 | 25.475 | 25.475 | 1000.0 |
| 2016-03-04 07:05:00 | AAPL | Stock | 25.475 | 25.475 | 25.475 | 25.475 | 400.0 |
| 2016-03-04 07:10:00 | AAPL | Stock | 25.475 | 25.4925 | 25.475 | 25.4925 | 18208.0 |
| 2016-03-04 07:15:00 | AAPL | Stock | 25.4925 | 25.5 | 25.4925 | 25.5 | 10216.0 |
| 2016-03-04 07:20:00 | AAPL | Stock | 25.5125 | 25.5125 | 25.4975 | 25.5125 | 1600.0 |
| 2016-03-04 07:25:00 | AAPL | Stock | 25.52 | 25.52 | 25.5125 | 25.5125 | 6400.0 |
| 2016-03-04 07:30:00 | AAPL | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 4000.0 |
| 2016-03-04 07:35:00 | AAPL | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 1600.0 |
| 2016-03-04 07:45:00 | AAPL | Stock | 25.4875 | 25.4875 | 25.4875 | 25.4875 | 2440.0 |
| 2016-03-04 07:50:00 | AAPL | Stock | 25.5 | 25.5 | 25.4775 | 25.4775 | 13840.0 |
| 2016-03-04 07:55:00 | AAPL | Stock | 25.4775 | 25.4775 | 25.4725 | 25.4725 | 5268.0 |
| 2016-03-04 08:00:00 | AAPL | Stock | 25.475 | 25.5 | 25.425 | 25.4325 | 60208.0 |
| 2016-03-04 08:05:00 | AAPL | Stock | 25.4375 | 25.4375 | 25.425 | 25.4375 | 4580.0 |
| 2016-03-04 08:10:00 | AAPL | Stock | 25.4425 | 25.4475 | 25.425 | 25.4275 | 38704.0 |
| 2016-03-04 08:15:00 | AAPL | Stock | 25.4325 | 25.4325 | 25.4 | 25.4175 | 35000.0 |
| 2016-03-04 08:20:00 | AAPL | Stock | 25.425 | 25.435 | 25.4125 | 25.435 | 33860.0 |
| 2016-03-04 08:25:00 | AAPL | Stock | 25.425 | 25.4675 | 25.425 | 25.4675 | 24520.0 |
| 2016-03-04 08:30:00 | AAPL | Stock | 25.455 | 25.5625 | 25.43 | 25.5625 | 177964.0 |
| 2016-03-04 08:35:00 | AAPL | Stock | 25.5375 | 25.6225 | 25.5075 | 25.575 | 152096.0 |
| 2016-03-04 08:40:00 | AAPL | Stock | 25.58 | 25.6 | 25.55 | 25.5525 | 88000.0 |
| 2016-03-04 08:45:00 | AAPL | Stock | 25.5525 | 25.565 | 25.505 | 25.5075 | 83616.0 |
| 2016-03-04 08:50:00 | AAPL | Stock | 25.52 | 25.52 | 25.48 | 25.51 | 100540.0 |
| 2016-03-04 08:55:00 | AAPL | Stock | 25.525 | 25.525 | 25.455 | 25.4975 | 136160.0 |
| 2016-03-04 09:00:00 | AAPL | Stock | 25.4875 | 25.5225 | 25.4625 | 25.52 | 44604.0 |
| 2016-03-04 09:05:00 | AAPL | Stock | 25.515 | 25.525 | 25.51 | 25.515 | 11400.0 |
| 2016-03-04 09:10:00 | AAPL | Stock | 25.515 | 25.525 | 25.5125 | 25.5175 | 39836.0 |
| 2016-03-04 09:15:00 | AAPL | Stock | 25.525 | 25.525 | 25.5 | 25.5 | 57548.0 |
| 2016-03-04 09:20:00 | AAPL | Stock | 25.5175 | 25.5275 | 25.5 | 25.5025 | 24896.0 |
| 2016-03-04 09:25:00 | AAPL | Stock | 25.5225 | 25.5925 | 25.5 | 25.59 | 697760.0 |
| 2016-03-04 09:30:00 | AAPL | Stock | 25.5925 | 25.595 | 25.44 | 25.465 | 6492544.0 |
| 2016-03-04 09:35:00 | AAPL | Stock | 25.465 | 25.485 | 25.365 | 25.375 | 4414424.0 |
| 2016-03-04 09:40:00 | AAPL | Stock | 25.3725 | 25.4375 | 25.3425 | 25.425 | 2466900.0 |
| 2016-03-04 09:45:00 | AAPL | Stock | 25.43 | 25.555 | 25.4125 | 25.5192 | 3099300.0 |
| 2016-03-04 09:50:00 | AAPL | Stock | 25.52 | 25.525 | 25.3775 | 25.3775 | 3007052.0 |
| 2016-03-04 09:55:00 | AAPL | Stock | 25.38 | 25.47 | 25.355 | 25.45 | 2948480.0 |
| 2016-03-04 10:00:00 | AAPL | Stock | 25.45 | 25.4525 | 25.3618 | 25.39 | 1711848.0 |
| 2016-03-04 10:05:00 | AAPL | Stock | 25.39 | 25.4375 | 25.3475 | 25.4362 | 2023140.0 |
| 2016-03-04 10:10:00 | AAPL | Stock | 25.4355 | 25.47 | 25.3875 | 25.455 | 1690452.0 |
| 2016-03-04 10:15:00 | AAPL | Stock | 25.455 | 25.4625 | 25.3825 | 25.42 | 1872244.0 |
| 2016-03-04 10:20:00 | AAPL | Stock | 25.42 | 25.4525 | 25.4012 | 25.4172 | 1249028.0 |
> showing 50 of 366,426 rows — these rows as CSV