PREVIEW / stock_5min / 2014-08-01
file: by_date/stock_5min/2014/2014-08-01.parquet size: 5.6 MB rows: 375,635 symbols: 3,559
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-08-01 04:00:00 | AAPL | Stock | 23.82 | 23.82 | 23.725 | 23.725 | 9460.0 |
| 2014-08-01 04:05:00 | AAPL | Stock | 23.7175 | 23.7175 | 23.7175 | 23.7175 | 4000.0 |
| 2014-08-01 04:10:00 | AAPL | Stock | 23.7175 | 23.7175 | 23.715 | 23.715 | 4260.0 |
| 2014-08-01 04:15:00 | AAPL | Stock | 23.7 | 23.705 | 23.7 | 23.705 | 1200.0 |
| 2014-08-01 04:20:00 | AAPL | Stock | 23.675 | 23.675 | 23.65 | 23.65 | 2400.0 |
| 2014-08-01 04:25:00 | AAPL | Stock | 23.625 | 23.625 | 23.625 | 23.625 | 3600.0 |
| 2014-08-01 04:30:00 | AAPL | Stock | 23.6 | 23.6 | 23.5775 | 23.5775 | 7968.0 |
| 2014-08-01 04:35:00 | AAPL | Stock | 23.55 | 23.5775 | 23.5375 | 23.5375 | 23304.0 |
| 2014-08-01 04:40:00 | AAPL | Stock | 23.535 | 23.6 | 23.535 | 23.6 | 28320.0 |
| 2014-08-01 04:45:00 | AAPL | Stock | 23.525 | 23.525 | 23.525 | 23.525 | 13044.0 |
| 2014-08-01 04:50:00 | AAPL | Stock | 23.5125 | 23.5275 | 23.5 | 23.5275 | 16800.0 |
| 2014-08-01 04:55:00 | AAPL | Stock | 23.55 | 23.55 | 23.5375 | 23.54 | 14760.0 |
| 2014-08-01 05:00:00 | AAPL | Stock | 23.5575 | 23.5575 | 23.5375 | 23.5375 | 32104.0 |
| 2014-08-01 05:05:00 | AAPL | Stock | 23.5 | 23.535 | 23.5 | 23.5175 | 5092.0 |
| 2014-08-01 05:10:00 | AAPL | Stock | 23.5225 | 23.5225 | 23.51 | 23.51 | 5600.0 |
| 2014-08-01 05:15:00 | AAPL | Stock | 23.52 | 23.52 | 23.52 | 23.52 | 1600.0 |
| 2014-08-01 05:20:00 | AAPL | Stock | 23.5125 | 23.5125 | 23.47 | 23.47 | 17224.0 |
| 2014-08-01 05:25:00 | AAPL | Stock | 23.47 | 23.47 | 23.425 | 23.425 | 10428.0 |
| 2014-08-01 05:30:00 | AAPL | Stock | 23.425 | 23.425 | 23.4125 | 23.415 | 11512.0 |
| 2014-08-01 05:35:00 | AAPL | Stock | 23.415 | 23.435 | 23.4075 | 23.4075 | 10756.0 |
| 2014-08-01 05:40:00 | AAPL | Stock | 23.405 | 23.405 | 23.345 | 23.375 | 15564.0 |
| 2014-08-01 05:45:00 | AAPL | Stock | 23.355 | 23.405 | 23.3275 | 23.405 | 23680.0 |
| 2014-08-01 05:50:00 | AAPL | Stock | 23.375 | 23.425 | 23.375 | 23.3875 | 44212.0 |
| 2014-08-01 05:55:00 | AAPL | Stock | 23.375 | 23.4 | 23.375 | 23.3875 | 20732.0 |
| 2014-08-01 06:00:00 | AAPL | Stock | 23.4 | 23.4325 | 23.3875 | 23.3875 | 18320.0 |
| 2014-08-01 06:05:00 | AAPL | Stock | 23.42 | 23.445 | 23.42 | 23.435 | 13660.0 |
| 2014-08-01 06:10:00 | AAPL | Stock | 23.425 | 23.46 | 23.425 | 23.46 | 7152.0 |
| 2014-08-01 06:15:00 | AAPL | Stock | 23.44 | 23.4625 | 23.44 | 23.4625 | 33172.0 |
| 2014-08-01 06:20:00 | AAPL | Stock | 23.45 | 23.485 | 23.445 | 23.445 | 76000.0 |
| 2014-08-01 06:30:00 | AAPL | Stock | 23.445 | 23.445 | 23.4275 | 23.4275 | 8000.0 |
| 2014-08-01 06:35:00 | AAPL | Stock | 23.445 | 23.5 | 23.445 | 23.475 | 49868.0 |
| 2014-08-01 06:40:00 | AAPL | Stock | 23.4625 | 23.545 | 23.4625 | 23.53 | 29752.0 |
| 2014-08-01 06:45:00 | AAPL | Stock | 23.545 | 23.555 | 23.5375 | 23.555 | 35812.0 |
| 2014-08-01 06:50:00 | AAPL | Stock | 23.555 | 23.5575 | 23.55 | 23.5575 | 26752.0 |
| 2014-08-01 06:55:00 | AAPL | Stock | 23.55 | 23.55 | 23.55 | 23.55 | 3968.0 |
| 2014-08-01 07:00:00 | AAPL | Stock | 23.54 | 23.555 | 23.515 | 23.5225 | 97736.0 |
| 2014-08-01 07:05:00 | AAPL | Stock | 23.5175 | 23.5575 | 23.5 | 23.525 | 27784.0 |
| 2014-08-01 07:10:00 | AAPL | Stock | 23.5275 | 23.5475 | 23.515 | 23.5475 | 54932.0 |
| 2014-08-01 07:15:00 | AAPL | Stock | 23.5475 | 23.575 | 23.5475 | 23.5725 | 121792.0 |
| 2014-08-01 07:20:00 | AAPL | Stock | 23.585 | 23.585 | 23.5625 | 23.575 | 38800.0 |
| 2014-08-01 07:25:00 | AAPL | Stock | 23.575 | 23.575 | 23.57 | 23.5725 | 12648.0 |
| 2014-08-01 07:30:00 | AAPL | Stock | 23.5725 | 23.59 | 23.57 | 23.575 | 62620.0 |
| 2014-08-01 07:35:00 | AAPL | Stock | 23.585 | 23.625 | 23.585 | 23.6225 | 122284.0 |
| 2014-08-01 07:40:00 | AAPL | Stock | 23.62 | 23.635 | 23.6125 | 23.63 | 62204.0 |
| 2014-08-01 07:45:00 | AAPL | Stock | 23.625 | 23.635 | 23.625 | 23.635 | 8600.0 |
| 2014-08-01 07:50:00 | AAPL | Stock | 23.635 | 23.66 | 23.635 | 23.66 | 54056.0 |
| 2014-08-01 07:55:00 | AAPL | Stock | 23.66 | 23.6775 | 23.655 | 23.6775 | 35420.0 |
| 2014-08-01 08:00:00 | AAPL | Stock | 23.6825 | 23.8925 | 23.5 | 23.685 | 401768.0 |
| 2014-08-01 08:05:00 | AAPL | Stock | 23.685 | 23.72 | 23.6525 | 23.72 | 97728.0 |
| 2014-08-01 08:10:00 | AAPL | Stock | 23.72 | 23.7275 | 23.7 | 23.7075 | 64192.0 |
> showing 50 of 375,635 rows — these rows as CSV