PREVIEW / stock_5min / 2015-05-08
file: by_date/stock_5min/2015/2015-05-08.parquet size: 5.5 MB rows: 362,709 symbols: 3,494
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-05-08 04:00:00 | AAPL | Stock | 31.505 | 31.505 | 31.375 | 31.48 | 2192.0 |
| 2015-05-08 04:10:00 | AAPL | Stock | 31.4525 | 31.4525 | 31.45 | 31.45 | 1400.0 |
| 2015-05-08 04:25:00 | AAPL | Stock | 31.5 | 31.5 | 31.5 | 31.5 | 1600.0 |
| 2015-05-08 04:30:00 | AAPL | Stock | 31.4275 | 31.4275 | 31.425 | 31.425 | 800.0 |
| 2015-05-08 04:45:00 | AAPL | Stock | 31.4475 | 31.4475 | 31.4475 | 31.4475 | 1600.0 |
| 2015-05-08 04:50:00 | AAPL | Stock | 31.4475 | 31.4475 | 31.4375 | 31.4375 | 5200.0 |
| 2015-05-08 05:20:00 | AAPL | Stock | 31.4475 | 31.4475 | 31.4475 | 31.4475 | 800.0 |
| 2015-05-08 05:30:00 | AAPL | Stock | 31.4825 | 31.5 | 31.4825 | 31.5 | 7460.0 |
| 2015-05-08 05:35:00 | AAPL | Stock | 31.5 | 31.575 | 31.5 | 31.575 | 22000.0 |
| 2015-05-08 05:45:00 | AAPL | Stock | 31.5325 | 31.5625 | 31.5325 | 31.5625 | 7088.0 |
| 2015-05-08 05:50:00 | AAPL | Stock | 31.535 | 31.535 | 31.5325 | 31.5325 | 2800.0 |
| 2015-05-08 05:55:00 | AAPL | Stock | 31.5325 | 31.5325 | 31.5325 | 31.5325 | 2400.0 |
| 2015-05-08 06:10:00 | AAPL | Stock | 31.5125 | 31.5225 | 31.5125 | 31.5225 | 3460.0 |
| 2015-05-08 06:30:00 | AAPL | Stock | 31.4525 | 31.4525 | 31.45 | 31.45 | 1400.0 |
| 2015-05-08 06:35:00 | AAPL | Stock | 31.4675 | 31.4675 | 31.4675 | 31.4675 | 1600.0 |
| 2015-05-08 06:40:00 | AAPL | Stock | 31.4975 | 31.4975 | 31.4975 | 31.4975 | 1676.0 |
| 2015-05-08 06:50:00 | AAPL | Stock | 31.485 | 31.485 | 31.485 | 31.485 | 2800.0 |
| 2015-05-08 06:55:00 | AAPL | Stock | 31.4925 | 31.4925 | 31.4925 | 31.4925 | 400.0 |
| 2015-05-08 07:00:00 | AAPL | Stock | 31.475 | 31.475 | 31.455 | 31.4625 | 13320.0 |
| 2015-05-08 07:05:00 | AAPL | Stock | 31.4625 | 31.4625 | 31.4625 | 31.4625 | 992.0 |
| 2015-05-08 07:10:00 | AAPL | Stock | 31.4675 | 31.4725 | 31.4675 | 31.4675 | 13440.0 |
| 2015-05-08 07:15:00 | AAPL | Stock | 31.47 | 31.47 | 31.47 | 31.47 | 3600.0 |
| 2015-05-08 07:20:00 | AAPL | Stock | 31.47 | 31.47 | 31.47 | 31.47 | 4000.0 |
| 2015-05-08 07:25:00 | AAPL | Stock | 31.4625 | 31.4625 | 31.4625 | 31.4625 | 4000.0 |
| 2015-05-08 07:30:00 | AAPL | Stock | 31.4625 | 31.4625 | 31.4625 | 31.4625 | 2400.0 |
| 2015-05-08 07:35:00 | AAPL | Stock | 31.4625 | 31.4625 | 31.4375 | 31.4375 | 29148.0 |
| 2015-05-08 07:40:00 | AAPL | Stock | 31.425 | 31.4425 | 31.4125 | 31.4425 | 16880.0 |
| 2015-05-08 07:45:00 | AAPL | Stock | 31.4375 | 31.4425 | 31.4375 | 31.4375 | 15828.0 |
| 2015-05-08 07:50:00 | AAPL | Stock | 31.4375 | 31.4375 | 31.435 | 31.4375 | 19560.0 |
| 2015-05-08 07:55:00 | AAPL | Stock | 31.435 | 31.4375 | 31.435 | 31.4375 | 12000.0 |
| 2015-05-08 08:00:00 | AAPL | Stock | 31.44 | 31.475 | 31.4 | 31.41 | 64284.0 |
| 2015-05-08 08:05:00 | AAPL | Stock | 31.395 | 31.4175 | 31.395 | 31.4175 | 29696.0 |
| 2015-05-08 08:10:00 | AAPL | Stock | 31.43 | 31.43 | 31.4 | 31.4025 | 43448.0 |
| 2015-05-08 08:15:00 | AAPL | Stock | 31.405 | 31.4125 | 31.3925 | 31.4 | 130044.0 |
| 2015-05-08 08:20:00 | AAPL | Stock | 31.4025 | 31.4125 | 31.38 | 31.385 | 81360.0 |
| 2015-05-08 08:25:00 | AAPL | Stock | 31.38 | 31.41 | 31.38 | 31.4 | 58916.0 |
| 2015-05-08 08:30:00 | AAPL | Stock | 31.4 | 31.525 | 31.4 | 31.5175 | 469852.0 |
| 2015-05-08 08:35:00 | AAPL | Stock | 31.5325 | 31.5725 | 31.5125 | 31.5375 | 286580.0 |
| 2015-05-08 08:40:00 | AAPL | Stock | 31.54 | 31.6475 | 31.525 | 31.6125 | 264240.0 |
| 2015-05-08 08:45:00 | AAPL | Stock | 31.605 | 31.635 | 31.5875 | 31.5875 | 166916.0 |
| 2015-05-08 08:50:00 | AAPL | Stock | 31.5925 | 31.625 | 31.59 | 31.625 | 97736.0 |
| 2015-05-08 08:55:00 | AAPL | Stock | 31.625 | 31.6372 | 31.6125 | 31.625 | 65760.0 |
| 2015-05-08 09:00:00 | AAPL | Stock | 31.6375 | 31.6375 | 31.5625 | 31.585 | 97588.0 |
| 2015-05-08 09:05:00 | AAPL | Stock | 31.585 | 31.5925 | 31.5625 | 31.5725 | 56532.0 |
| 2015-05-08 09:10:00 | AAPL | Stock | 31.5702 | 31.585 | 31.5625 | 31.585 | 67472.0 |
| 2015-05-08 09:15:00 | AAPL | Stock | 31.585 | 31.585 | 31.57 | 31.5725 | 26220.0 |
| 2015-05-08 09:20:00 | AAPL | Stock | 31.5675 | 31.5725 | 31.565 | 31.57 | 37096.0 |
| 2015-05-08 09:25:00 | AAPL | Stock | 31.5725 | 31.675 | 31.5725 | 31.62 | 252844.0 |
| 2015-05-08 09:30:00 | AAPL | Stock | 31.6225 | 31.7325 | 31.58 | 31.725 | 10112324.0 |
| 2015-05-08 09:35:00 | AAPL | Stock | 31.7275 | 31.7325 | 31.575 | 31.59 | 5970064.0 |
> showing 50 of 362,709 rows — these rows as CSV