PREVIEW / stock_5min / 2014-09-26
file: by_date/stock_5min/2014/2014-09-26.parquet size: 5.3 MB rows: 352,855 symbols: 3,557
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-09-26 04:00:00 | AAPL | Stock | 24.6875 | 24.6875 | 24.4675 | 24.5225 | 13608.0 |
| 2014-09-26 04:05:00 | AAPL | Stock | 24.4975 | 24.4975 | 24.4975 | 24.4975 | 400.0 |
| 2014-09-26 04:10:00 | AAPL | Stock | 24.4875 | 24.4875 | 24.475 | 24.475 | 2000.0 |
| 2014-09-26 04:30:00 | AAPL | Stock | 24.525 | 24.525 | 24.52 | 24.52 | 3572.0 |
| 2014-09-26 04:35:00 | AAPL | Stock | 24.525 | 24.525 | 24.52 | 24.52 | 2400.0 |
| 2014-09-26 04:45:00 | AAPL | Stock | 24.52 | 24.525 | 24.52 | 24.525 | 14828.0 |
| 2014-09-26 04:50:00 | AAPL | Stock | 24.52 | 24.52 | 24.52 | 24.52 | 560.0 |
| 2014-09-26 05:00:00 | AAPL | Stock | 24.5175 | 24.5175 | 24.4925 | 24.4925 | 1200.0 |
| 2014-09-26 05:05:00 | AAPL | Stock | 24.5175 | 24.5175 | 24.5175 | 24.5175 | 1136.0 |
| 2014-09-26 05:10:00 | AAPL | Stock | 24.525 | 24.525 | 24.525 | 24.525 | 2800.0 |
| 2014-09-26 05:15:00 | AAPL | Stock | 24.5175 | 24.5875 | 24.5175 | 24.5875 | 10352.0 |
| 2014-09-26 05:30:00 | AAPL | Stock | 24.5875 | 24.5875 | 24.5875 | 24.5875 | 3544.0 |
| 2014-09-26 05:35:00 | AAPL | Stock | 24.6225 | 24.625 | 24.6225 | 24.625 | 1600.0 |
| 2014-09-26 05:40:00 | AAPL | Stock | 24.6575 | 24.6875 | 24.65 | 24.6875 | 12360.0 |
| 2014-09-26 05:45:00 | AAPL | Stock | 24.655 | 24.655 | 24.6275 | 24.6275 | 5656.0 |
| 2014-09-26 05:50:00 | AAPL | Stock | 24.69 | 24.69 | 24.6775 | 24.6775 | 12356.0 |
| 2014-09-26 06:00:00 | AAPL | Stock | 24.675 | 24.675 | 24.64 | 24.6725 | 12112.0 |
| 2014-09-26 06:05:00 | AAPL | Stock | 24.675 | 24.675 | 24.64 | 24.65 | 6400.0 |
| 2014-09-26 06:10:00 | AAPL | Stock | 24.625 | 24.625 | 24.6 | 24.6075 | 21888.0 |
| 2014-09-26 06:15:00 | AAPL | Stock | 24.6225 | 24.625 | 24.5775 | 24.625 | 7208.0 |
| 2014-09-26 06:20:00 | AAPL | Stock | 24.5875 | 24.625 | 24.5875 | 24.5875 | 21320.0 |
| 2014-09-26 06:25:00 | AAPL | Stock | 24.5875 | 24.6125 | 24.5875 | 24.6125 | 2800.0 |
| 2014-09-26 06:30:00 | AAPL | Stock | 24.5975 | 24.5975 | 24.5975 | 24.5975 | 1600.0 |
| 2014-09-26 06:55:00 | AAPL | Stock | 24.5925 | 24.5925 | 24.5925 | 24.5925 | 2400.0 |
| 2014-09-26 07:00:00 | AAPL | Stock | 24.5925 | 24.615 | 24.5925 | 24.6 | 13400.0 |
| 2014-09-26 07:05:00 | AAPL | Stock | 24.5925 | 24.65 | 24.5675 | 24.65 | 47836.0 |
| 2014-09-26 07:10:00 | AAPL | Stock | 24.65 | 24.7675 | 24.65 | 24.75 | 115676.0 |
| 2014-09-26 07:15:00 | AAPL | Stock | 24.75 | 24.75 | 24.7 | 24.705 | 18580.0 |
| 2014-09-26 07:20:00 | AAPL | Stock | 24.705 | 24.705 | 24.6875 | 24.69 | 15188.0 |
| 2014-09-26 07:25:00 | AAPL | Stock | 24.69 | 24.69 | 24.66 | 24.665 | 51296.0 |
| 2014-09-26 07:30:00 | AAPL | Stock | 24.6775 | 24.685 | 24.665 | 24.685 | 31600.0 |
| 2014-09-26 07:35:00 | AAPL | Stock | 24.7 | 24.7125 | 24.6875 | 24.6875 | 39400.0 |
| 2014-09-26 07:40:00 | AAPL | Stock | 24.6975 | 24.6975 | 24.6625 | 24.6625 | 43300.0 |
| 2014-09-26 07:45:00 | AAPL | Stock | 24.6625 | 24.68 | 24.6625 | 24.68 | 15652.0 |
| 2014-09-26 07:50:00 | AAPL | Stock | 24.6675 | 24.675 | 24.65 | 24.67 | 29280.0 |
| 2014-09-26 07:55:00 | AAPL | Stock | 24.6725 | 24.6725 | 24.6375 | 24.6375 | 70340.0 |
| 2014-09-26 08:00:00 | AAPL | Stock | 24.66 | 24.775 | 24.575 | 24.6875 | 313520.0 |
| 2014-09-26 08:05:00 | AAPL | Stock | 24.6875 | 24.72 | 24.685 | 24.6975 | 46832.0 |
| 2014-09-26 08:10:00 | AAPL | Stock | 24.7 | 24.7475 | 24.6975 | 24.7275 | 102244.0 |
| 2014-09-26 08:15:00 | AAPL | Stock | 24.7125 | 24.7375 | 24.7125 | 24.73 | 144560.0 |
| 2014-09-26 08:20:00 | AAPL | Stock | 24.735 | 24.7375 | 24.72 | 24.725 | 78720.0 |
| 2014-09-26 08:25:00 | AAPL | Stock | 24.73 | 24.7575 | 24.725 | 24.7475 | 252644.0 |
| 2014-09-26 08:30:00 | AAPL | Stock | 24.74 | 24.7425 | 24.69 | 24.7 | 258584.0 |
| 2014-09-26 08:35:00 | AAPL | Stock | 24.7175 | 24.735 | 24.7 | 24.725 | 125780.0 |
| 2014-09-26 08:40:00 | AAPL | Stock | 24.735 | 24.7475 | 24.69 | 24.69 | 189068.0 |
| 2014-09-26 08:45:00 | AAPL | Stock | 24.69 | 24.7 | 24.6725 | 24.695 | 141084.0 |
| 2014-09-26 08:50:00 | AAPL | Stock | 24.6975 | 24.7 | 24.675 | 24.675 | 114288.0 |
| 2014-09-26 08:55:00 | AAPL | Stock | 24.69 | 24.7 | 24.675 | 24.6875 | 83204.0 |
| 2014-09-26 09:00:00 | AAPL | Stock | 24.6875 | 24.6875 | 24.64 | 24.6525 | 154548.0 |
| 2014-09-26 09:05:00 | AAPL | Stock | 24.6575 | 24.6975 | 24.6475 | 24.68 | 112176.0 |
> showing 50 of 352,855 rows — these rows as CSV