PREVIEW / stock_5min / 2015-07-14
file: by_date/stock_5min/2015/2015-07-14.parquet size: 5.4 MB rows: 355,256 symbols: 3,483
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-14 04:00:00 | AAPL | Stock | 31.49 | 31.49 | 31.4675 | 31.4675 | 11796.0 |
| 2015-07-14 04:15:00 | AAPL | Stock | 31.42 | 31.42 | 31.42 | 31.42 | 1216.0 |
| 2015-07-14 04:30:00 | AAPL | Stock | 31.4525 | 31.4525 | 31.4525 | 31.4525 | 400.0 |
| 2015-07-14 04:40:00 | AAPL | Stock | 31.45 | 31.45 | 31.45 | 31.45 | 1600.0 |
| 2015-07-14 04:45:00 | AAPL | Stock | 31.4475 | 31.4475 | 31.4475 | 31.4475 | 2164.0 |
| 2015-07-14 05:10:00 | AAPL | Stock | 31.4375 | 31.4375 | 31.4375 | 31.4375 | 1704.0 |
| 2015-07-14 05:50:00 | AAPL | Stock | 31.4625 | 31.4625 | 31.4625 | 31.4625 | 4160.0 |
| 2015-07-14 05:55:00 | AAPL | Stock | 31.455 | 31.455 | 31.45 | 31.45 | 4400.0 |
| 2015-07-14 06:05:00 | AAPL | Stock | 31.45 | 31.45 | 31.45 | 31.45 | 800.0 |
| 2015-07-14 06:10:00 | AAPL | Stock | 31.45 | 31.45 | 31.45 | 31.45 | 400.0 |
| 2015-07-14 06:15:00 | AAPL | Stock | 31.47 | 31.47 | 31.45 | 31.45 | 4400.0 |
| 2015-07-14 06:20:00 | AAPL | Stock | 31.4525 | 31.4525 | 31.4375 | 31.4375 | 2912.0 |
| 2015-07-14 06:25:00 | AAPL | Stock | 31.43 | 31.43 | 31.4275 | 31.4275 | 800.0 |
| 2015-07-14 06:30:00 | AAPL | Stock | 31.4275 | 31.4425 | 31.425 | 31.4275 | 10400.0 |
| 2015-07-14 06:35:00 | AAPL | Stock | 31.4575 | 31.4575 | 31.4575 | 31.4575 | 840.0 |
| 2015-07-14 06:50:00 | AAPL | Stock | 31.42 | 31.42 | 31.42 | 31.42 | 800.0 |
| 2015-07-14 06:55:00 | AAPL | Stock | 31.4125 | 31.415 | 31.4125 | 31.415 | 1400.0 |
| 2015-07-14 07:00:00 | AAPL | Stock | 31.4225 | 31.4375 | 31.4225 | 31.4375 | 8784.0 |
| 2015-07-14 07:05:00 | AAPL | Stock | 31.425 | 31.445 | 31.4125 | 31.425 | 17600.0 |
| 2015-07-14 07:10:00 | AAPL | Stock | 31.425 | 31.425 | 31.4175 | 31.4175 | 1360.0 |
| 2015-07-14 07:20:00 | AAPL | Stock | 31.4375 | 31.4475 | 31.425 | 31.425 | 3440.0 |
| 2015-07-14 07:35:00 | AAPL | Stock | 31.425 | 31.425 | 31.425 | 31.425 | 1972.0 |
| 2015-07-14 07:40:00 | AAPL | Stock | 31.425 | 31.425 | 31.4025 | 31.405 | 13872.0 |
| 2015-07-14 07:45:00 | AAPL | Stock | 31.4 | 31.405 | 31.4 | 31.405 | 1600.0 |
| 2015-07-14 07:50:00 | AAPL | Stock | 31.4075 | 31.415 | 31.4075 | 31.4075 | 2592.0 |
| 2015-07-14 07:55:00 | AAPL | Stock | 31.4125 | 31.4125 | 31.4125 | 31.4125 | 5280.0 |
| 2015-07-14 08:00:00 | AAPL | Stock | 31.415 | 31.4625 | 31.3975 | 31.43 | 58256.0 |
| 2015-07-14 08:05:00 | AAPL | Stock | 31.4275 | 31.4275 | 31.4075 | 31.415 | 42228.0 |
| 2015-07-14 08:10:00 | AAPL | Stock | 31.42 | 31.4325 | 31.4125 | 31.4325 | 21548.0 |
| 2015-07-14 08:15:00 | AAPL | Stock | 31.4225 | 31.44 | 31.4225 | 31.44 | 33032.0 |
| 2015-07-14 08:20:00 | AAPL | Stock | 31.44 | 31.46 | 31.44 | 31.46 | 19608.0 |
| 2015-07-14 08:25:00 | AAPL | Stock | 31.46 | 31.46 | 31.4425 | 31.45 | 29312.0 |
| 2015-07-14 08:30:00 | AAPL | Stock | 31.445 | 31.45 | 31.4325 | 31.4325 | 34596.0 |
| 2015-07-14 08:35:00 | AAPL | Stock | 31.4325 | 31.435 | 31.4325 | 31.435 | 12800.0 |
| 2015-07-14 08:40:00 | AAPL | Stock | 31.4375 | 31.4425 | 31.43 | 31.4425 | 25124.0 |
| 2015-07-14 08:45:00 | AAPL | Stock | 31.4382 | 31.4525 | 31.4375 | 31.4475 | 33488.0 |
| 2015-07-14 08:50:00 | AAPL | Stock | 31.44 | 31.44 | 31.415 | 31.415 | 49404.0 |
| 2015-07-14 08:55:00 | AAPL | Stock | 31.4158 | 31.43 | 31.4 | 31.4025 | 50892.0 |
| 2015-07-14 09:00:00 | AAPL | Stock | 31.405 | 31.4125 | 31.4 | 31.4 | 10136.0 |
| 2015-07-14 09:05:00 | AAPL | Stock | 31.4025 | 31.4175 | 31.4025 | 31.4175 | 8868.0 |
| 2015-07-14 09:10:00 | AAPL | Stock | 31.4225 | 31.4475 | 31.415 | 31.4282 | 118072.0 |
| 2015-07-14 09:15:00 | AAPL | Stock | 31.4375 | 31.4375 | 31.425 | 31.43 | 62336.0 |
| 2015-07-14 09:20:00 | AAPL | Stock | 31.44 | 31.4425 | 31.43 | 31.435 | 19044.0 |
| 2015-07-14 09:25:00 | AAPL | Stock | 31.4375 | 31.5125 | 31.43 | 31.4675 | 172904.0 |
| 2015-07-14 09:30:00 | AAPL | Stock | 31.51 | 31.5375 | 31.36 | 31.37 | 5298944.0 |
| 2015-07-14 09:35:00 | AAPL | Stock | 31.37 | 31.3825 | 31.33 | 31.355 | 3106424.0 |
| 2015-07-14 09:40:00 | AAPL | Stock | 31.3575 | 31.37 | 31.285 | 31.3238 | 2895464.0 |
| 2015-07-14 09:45:00 | AAPL | Stock | 31.325 | 31.3875 | 31.3125 | 31.3738 | 2417712.0 |
| 2015-07-14 09:50:00 | AAPL | Stock | 31.375 | 31.405 | 31.3325 | 31.3528 | 2491676.0 |
| 2015-07-14 09:55:00 | AAPL | Stock | 31.3538 | 31.37 | 31.3175 | 31.3238 | 1578652.0 |
> showing 50 of 355,256 rows — these rows as CSV