PREVIEW / stock_5min / 2016-09-22
file: by_date/stock_5min/2016/2016-09-22.parquet size: 5.4 MB rows: 356,115 symbols: 3,242
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-22 04:00:00 | AAPL | Stock | 28.455 | 28.455 | 28.455 | 28.455 | 400.0 |
| 2016-09-22 05:20:00 | AAPL | Stock | 28.4675 | 28.4675 | 28.4675 | 28.4675 | 400.0 |
| 2016-09-22 05:25:00 | AAPL | Stock | 28.4925 | 28.4925 | 28.4925 | 28.4925 | 1336.0 |
| 2016-09-22 05:40:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 4232.0 |
| 2016-09-22 05:50:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 480.0 |
| 2016-09-22 05:55:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 1200.0 |
| 2016-09-22 06:30:00 | AAPL | Stock | 28.5325 | 28.5325 | 28.5325 | 28.5325 | 1860.0 |
| 2016-09-22 06:55:00 | AAPL | Stock | 28.5325 | 28.5325 | 28.5325 | 28.5325 | 2000.0 |
| 2016-09-22 07:00:00 | AAPL | Stock | 28.5325 | 28.5325 | 28.5125 | 28.5125 | 9640.0 |
| 2016-09-22 07:05:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 4700.0 |
| 2016-09-22 07:10:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 12676.0 |
| 2016-09-22 07:15:00 | AAPL | Stock | 28.5125 | 28.5125 | 28.5125 | 28.5125 | 2060.0 |
| 2016-09-22 07:20:00 | AAPL | Stock | 28.525 | 28.525 | 28.525 | 28.525 | 600.0 |
| 2016-09-22 07:25:00 | AAPL | Stock | 28.5175 | 28.5175 | 28.5 | 28.5 | 3644.0 |
| 2016-09-22 07:30:00 | AAPL | Stock | 28.505 | 28.505 | 28.4775 | 28.5 | 11600.0 |
| 2016-09-22 07:35:00 | AAPL | Stock | 28.5 | 28.5 | 28.4825 | 28.4825 | 2556.0 |
| 2016-09-22 07:40:00 | AAPL | Stock | 28.5 | 28.5175 | 28.5 | 28.5175 | 8924.0 |
| 2016-09-22 07:45:00 | AAPL | Stock | 28.5175 | 28.525 | 28.495 | 28.525 | 20000.0 |
| 2016-09-22 07:55:00 | AAPL | Stock | 28.5225 | 28.5225 | 28.5225 | 28.5225 | 400.0 |
| 2016-09-22 08:00:00 | AAPL | Stock | 28.5225 | 28.53 | 28.4925 | 28.5 | 113596.0 |
| 2016-09-22 08:05:00 | AAPL | Stock | 28.505 | 28.515 | 28.4975 | 28.505 | 55048.0 |
| 2016-09-22 08:10:00 | AAPL | Stock | 28.5125 | 28.515 | 28.5 | 28.5 | 17156.0 |
| 2016-09-22 08:15:00 | AAPL | Stock | 28.5 | 28.5175 | 28.4875 | 28.5 | 74272.0 |
| 2016-09-22 08:20:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 14220.0 |
| 2016-09-22 08:25:00 | AAPL | Stock | 28.495 | 28.51 | 28.495 | 28.505 | 9140.0 |
| 2016-09-22 08:30:00 | AAPL | Stock | 28.5 | 28.5225 | 28.5 | 28.5175 | 4292.0 |
| 2016-09-22 08:35:00 | AAPL | Stock | 28.5125 | 28.52 | 28.505 | 28.505 | 14168.0 |
| 2016-09-22 08:40:00 | AAPL | Stock | 28.5025 | 28.525 | 28.5 | 28.525 | 40140.0 |
| 2016-09-22 08:45:00 | AAPL | Stock | 28.525 | 28.525 | 28.5125 | 28.5125 | 18800.0 |
| 2016-09-22 08:50:00 | AAPL | Stock | 28.5125 | 28.5175 | 28.505 | 28.5175 | 16060.0 |
| 2016-09-22 08:55:00 | AAPL | Stock | 28.52 | 28.52 | 28.5075 | 28.515 | 7656.0 |
| 2016-09-22 09:00:00 | AAPL | Stock | 28.515 | 28.515 | 28.5 | 28.5025 | 24856.0 |
| 2016-09-22 09:05:00 | AAPL | Stock | 28.505 | 28.5325 | 28.505 | 28.5325 | 29444.0 |
| 2016-09-22 09:10:00 | AAPL | Stock | 28.535 | 28.5625 | 28.535 | 28.555 | 93092.0 |
| 2016-09-22 09:15:00 | AAPL | Stock | 28.555 | 28.5625 | 28.5525 | 28.56 | 91816.0 |
| 2016-09-22 09:20:00 | AAPL | Stock | 28.56 | 28.575 | 28.5575 | 28.575 | 51104.0 |
| 2016-09-22 09:25:00 | AAPL | Stock | 28.575 | 28.5825 | 28.5375 | 28.5825 | 224752.0 |
| 2016-09-22 09:30:00 | AAPL | Stock | 28.58 | 28.6875 | 28.5 | 28.6412 | 8506348.0 |
| 2016-09-22 09:35:00 | AAPL | Stock | 28.6402 | 28.6875 | 28.585 | 28.6125 | 4694848.0 |
| 2016-09-22 09:40:00 | AAPL | Stock | 28.6122 | 28.655 | 28.61 | 28.6225 | 3464296.0 |
| 2016-09-22 09:45:00 | AAPL | Stock | 28.6225 | 28.655 | 28.615 | 28.6425 | 2286276.0 |
| 2016-09-22 09:50:00 | AAPL | Stock | 28.6425 | 28.7175 | 28.635 | 28.705 | 3535680.0 |
| 2016-09-22 09:55:00 | AAPL | Stock | 28.7075 | 28.7125 | 28.6875 | 28.6975 | 1971884.0 |
| 2016-09-22 10:00:00 | AAPL | Stock | 28.6998 | 28.7012 | 28.6225 | 28.6375 | 2098048.0 |
| 2016-09-22 10:05:00 | AAPL | Stock | 28.6375 | 28.6675 | 28.6275 | 28.63 | 1608512.0 |
| 2016-09-22 10:10:00 | AAPL | Stock | 28.63 | 28.6375 | 28.6025 | 28.605 | 2187212.0 |
| 2016-09-22 10:15:00 | AAPL | Stock | 28.6058 | 28.665 | 28.5975 | 28.6485 | 1753136.0 |
| 2016-09-22 10:20:00 | AAPL | Stock | 28.6475 | 28.665 | 28.6325 | 28.6612 | 934348.0 |
| 2016-09-22 10:25:00 | AAPL | Stock | 28.665 | 28.7325 | 28.665 | 28.72 | 2820576.0 |
| 2016-09-22 10:30:00 | AAPL | Stock | 28.7188 | 28.735 | 28.695 | 28.7248 | 1999384.0 |
> showing 50 of 356,115 rows — these rows as CSV