PREVIEW / stock_5min / 2014-10-21
file: by_date/stock_5min/2014/2014-10-21.parquet size: 5.5 MB rows: 360,824 symbols: 3,553
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-21 04:00:00 | AAPL | Stock | 25.525 | 25.525 | 25.4225 | 25.4375 | 27184.0 |
| 2014-10-21 04:05:00 | AAPL | Stock | 25.4375 | 25.455 | 25.4375 | 25.4375 | 14300.0 |
| 2014-10-21 04:10:00 | AAPL | Stock | 25.475 | 25.49 | 25.4375 | 25.45 | 27644.0 |
| 2014-10-21 04:15:00 | AAPL | Stock | 25.455 | 25.455 | 25.44 | 25.44 | 8116.0 |
| 2014-10-21 04:20:00 | AAPL | Stock | 25.4475 | 25.4475 | 25.4325 | 25.4325 | 5056.0 |
| 2014-10-21 04:25:00 | AAPL | Stock | 25.4325 | 25.4325 | 25.4275 | 25.4275 | 4000.0 |
| 2014-10-21 04:30:00 | AAPL | Stock | 25.4275 | 25.4475 | 25.4275 | 25.4475 | 9000.0 |
| 2014-10-21 04:35:00 | AAPL | Stock | 25.4475 | 25.45 | 25.4475 | 25.45 | 10712.0 |
| 2014-10-21 04:40:00 | AAPL | Stock | 25.45 | 25.45 | 25.45 | 25.45 | 12700.0 |
| 2014-10-21 04:45:00 | AAPL | Stock | 25.455 | 25.4625 | 25.455 | 25.4625 | 7364.0 |
| 2014-10-21 04:50:00 | AAPL | Stock | 25.4625 | 25.4625 | 25.4625 | 25.4625 | 25332.0 |
| 2014-10-21 04:55:00 | AAPL | Stock | 25.4675 | 25.4675 | 25.46 | 25.4625 | 10892.0 |
| 2014-10-21 05:00:00 | AAPL | Stock | 25.4625 | 25.4625 | 25.4475 | 25.4475 | 14400.0 |
| 2014-10-21 05:05:00 | AAPL | Stock | 25.4575 | 25.4575 | 25.4575 | 25.4575 | 1600.0 |
| 2014-10-21 05:10:00 | AAPL | Stock | 25.4625 | 25.4625 | 25.46 | 25.46 | 9600.0 |
| 2014-10-21 05:15:00 | AAPL | Stock | 25.46 | 25.4625 | 25.455 | 25.455 | 9004.0 |
| 2014-10-21 05:20:00 | AAPL | Stock | 25.455 | 25.455 | 25.4475 | 25.4475 | 7336.0 |
| 2014-10-21 05:25:00 | AAPL | Stock | 25.45 | 25.45 | 25.42 | 25.42 | 24208.0 |
| 2014-10-21 05:30:00 | AAPL | Stock | 25.415 | 25.42 | 25.4075 | 25.42 | 21608.0 |
| 2014-10-21 05:35:00 | AAPL | Stock | 25.445 | 25.45 | 25.445 | 25.4475 | 7200.0 |
| 2014-10-21 05:40:00 | AAPL | Stock | 25.4475 | 25.45 | 25.44 | 25.45 | 4604.0 |
| 2014-10-21 05:45:00 | AAPL | Stock | 25.4575 | 25.4575 | 25.435 | 25.45 | 10416.0 |
| 2014-10-21 05:50:00 | AAPL | Stock | 25.45 | 25.455 | 25.4475 | 25.4525 | 10684.0 |
| 2014-10-21 05:55:00 | AAPL | Stock | 25.4525 | 25.4625 | 25.4525 | 25.4625 | 23392.0 |
| 2014-10-21 06:00:00 | AAPL | Stock | 25.47 | 25.475 | 25.45 | 25.4625 | 51556.0 |
| 2014-10-21 06:05:00 | AAPL | Stock | 25.475 | 25.475 | 25.4525 | 25.4675 | 23056.0 |
| 2014-10-21 06:10:00 | AAPL | Stock | 25.4625 | 25.4625 | 25.455 | 25.46 | 10864.0 |
| 2014-10-21 06:15:00 | AAPL | Stock | 25.4625 | 25.4675 | 25.4625 | 25.4625 | 44868.0 |
| 2014-10-21 06:20:00 | AAPL | Stock | 25.4675 | 25.4675 | 25.455 | 25.4625 | 30220.0 |
| 2014-10-21 06:25:00 | AAPL | Stock | 25.4625 | 25.4625 | 25.4475 | 25.4575 | 9344.0 |
| 2014-10-21 06:30:00 | AAPL | Stock | 25.4575 | 25.4625 | 25.445 | 25.445 | 33628.0 |
| 2014-10-21 06:35:00 | AAPL | Stock | 25.4475 | 25.46 | 25.445 | 25.46 | 3600.0 |
| 2014-10-21 06:40:00 | AAPL | Stock | 25.4525 | 25.455 | 25.4475 | 25.4475 | 14528.0 |
| 2014-10-21 06:45:00 | AAPL | Stock | 25.4325 | 25.45 | 25.4 | 25.45 | 15436.0 |
| 2014-10-21 06:50:00 | AAPL | Stock | 25.4375 | 25.47 | 25.4375 | 25.47 | 18080.0 |
| 2014-10-21 06:55:00 | AAPL | Stock | 25.4675 | 25.5 | 25.465 | 25.5 | 118764.0 |
| 2014-10-21 07:00:00 | AAPL | Stock | 25.5 | 25.52 | 25.47 | 25.5025 | 222116.0 |
| 2014-10-21 07:05:00 | AAPL | Stock | 25.5075 | 25.5225 | 25.45 | 25.45 | 148888.0 |
| 2014-10-21 07:10:00 | AAPL | Stock | 25.4575 | 25.49 | 25.4525 | 25.475 | 40576.0 |
| 2014-10-21 07:15:00 | AAPL | Stock | 25.47 | 25.47 | 25.4125 | 25.4325 | 70628.0 |
| 2014-10-21 07:20:00 | AAPL | Stock | 25.4275 | 25.4475 | 25.4125 | 25.425 | 44716.0 |
| 2014-10-21 07:25:00 | AAPL | Stock | 25.4175 | 25.4225 | 25.375 | 25.3875 | 150156.0 |
| 2014-10-21 07:30:00 | AAPL | Stock | 25.3875 | 25.4425 | 25.3875 | 25.435 | 54128.0 |
| 2014-10-21 07:35:00 | AAPL | Stock | 25.425 | 25.4375 | 25.4 | 25.4 | 104880.0 |
| 2014-10-21 07:40:00 | AAPL | Stock | 25.4 | 25.4425 | 25.3625 | 25.4425 | 156936.0 |
| 2014-10-21 07:45:00 | AAPL | Stock | 25.445 | 25.4625 | 25.4375 | 25.4625 | 124676.0 |
| 2014-10-21 07:50:00 | AAPL | Stock | 25.4625 | 25.5 | 25.4525 | 25.495 | 276184.0 |
| 2014-10-21 07:55:00 | AAPL | Stock | 25.495 | 25.5 | 25.455 | 25.475 | 287336.0 |
| 2014-10-21 08:00:00 | AAPL | Stock | 25.5 | 25.55 | 25.2 | 25.5225 | 1156108.0 |
| 2014-10-21 08:05:00 | AAPL | Stock | 25.5125 | 25.5375 | 25.5 | 25.52 | 284604.0 |
> showing 50 of 360,824 rows — these rows as CSV