PREVIEW / stock_1min / 2014-01-15
file: by_date/stock_1min/2014/2014-01-15.parquet size: 14.5 MB rows: 1,050,481 symbols: 2,849
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-01-15 04:00:00 | AAPL | Stock | 19.5507 | 19.6429 | 19.5507 | 19.6429 | 11200.0 |
| 2014-01-15 04:01:00 | AAPL | Stock | 19.8036 | 19.8036 | 19.8036 | 19.8036 | 2800.0 |
| 2014-01-15 04:05:00 | AAPL | Stock | 19.8071 | 19.8071 | 19.8071 | 19.8071 | 2800.0 |
| 2014-01-15 04:09:00 | AAPL | Stock | 19.8082 | 19.8143 | 19.8082 | 19.8143 | 10640.0 |
| 2014-01-15 04:12:00 | AAPL | Stock | 19.8143 | 19.8143 | 19.8143 | 19.8143 | 2800.0 |
| 2014-01-15 04:13:00 | AAPL | Stock | 19.8143 | 19.8143 | 19.7893 | 19.7893 | 22400.0 |
| 2014-01-15 04:17:00 | AAPL | Stock | 19.7857 | 19.7857 | 19.7857 | 19.7857 | 25900.0 |
| 2014-01-15 04:27:00 | AAPL | Stock | 19.7846 | 19.7846 | 19.7846 | 19.7846 | 8708.0 |
| 2014-01-15 04:29:00 | AAPL | Stock | 19.7875 | 19.7875 | 19.7875 | 19.7875 | 2800.0 |
| 2014-01-15 04:38:00 | AAPL | Stock | 19.8096 | 19.8114 | 19.8096 | 19.8114 | 5600.0 |
| 2014-01-15 04:44:00 | AAPL | Stock | 19.8093 | 19.8093 | 19.8093 | 19.8093 | 2800.0 |
| 2014-01-15 04:49:00 | AAPL | Stock | 19.8071 | 19.8093 | 19.8071 | 19.8093 | 5600.0 |
| 2014-01-15 04:50:00 | AAPL | Stock | 19.805 | 19.805 | 19.805 | 19.805 | 2800.0 |
| 2014-01-15 04:51:00 | AAPL | Stock | 19.805 | 19.805 | 19.8014 | 19.8014 | 14140.0 |
| 2014-01-15 04:52:00 | AAPL | Stock | 19.7857 | 19.7857 | 19.7857 | 19.7857 | 18592.0 |
| 2014-01-15 04:55:00 | AAPL | Stock | 19.7857 | 19.7857 | 19.7857 | 19.7857 | 7000.0 |
| 2014-01-15 04:56:00 | AAPL | Stock | 19.7818 | 19.7854 | 19.7818 | 19.7854 | 5600.0 |
| 2014-01-15 05:05:00 | AAPL | Stock | 19.7836 | 19.7836 | 19.7818 | 19.7818 | 8400.0 |
| 2014-01-15 05:06:00 | AAPL | Stock | 19.7818 | 19.7818 | 19.7818 | 19.7818 | 6608.0 |
| 2014-01-15 05:07:00 | AAPL | Stock | 19.7775 | 19.7775 | 19.7775 | 19.7775 | 5264.0 |
| 2014-01-15 05:08:00 | AAPL | Stock | 19.7775 | 19.7775 | 19.7775 | 19.7775 | 2800.0 |
| 2014-01-15 05:09:00 | AAPL | Stock | 19.7775 | 19.7775 | 19.7775 | 19.7775 | 2800.0 |
| 2014-01-15 05:19:00 | AAPL | Stock | 19.7732 | 19.7732 | 19.7732 | 19.7732 | 2800.0 |
| 2014-01-15 05:41:00 | AAPL | Stock | 19.7657 | 19.7657 | 19.7657 | 19.7657 | 2800.0 |
| 2014-01-15 05:42:00 | AAPL | Stock | 19.7543 | 19.7543 | 19.7543 | 19.7543 | 2800.0 |
| 2014-01-15 05:47:00 | AAPL | Stock | 19.7539 | 19.7539 | 19.7539 | 19.7539 | 2800.0 |
| 2014-01-15 05:48:00 | AAPL | Stock | 19.7504 | 19.7504 | 19.7504 | 19.7504 | 14000.0 |
| 2014-01-15 05:49:00 | AAPL | Stock | 19.7504 | 19.7504 | 19.7504 | 19.7504 | 5656.0 |
| 2014-01-15 05:52:00 | AAPL | Stock | 19.7589 | 19.7589 | 19.7579 | 19.7579 | 8400.0 |
| 2014-01-15 05:54:00 | AAPL | Stock | 19.7579 | 19.7579 | 19.7579 | 19.7579 | 2800.0 |
| 2014-01-15 05:59:00 | AAPL | Stock | 19.7654 | 19.7654 | 19.7654 | 19.7654 | 3304.0 |
| 2014-01-15 06:01:00 | AAPL | Stock | 19.7836 | 19.7836 | 19.7836 | 19.7836 | 4200.0 |
| 2014-01-15 06:03:00 | AAPL | Stock | 19.7836 | 19.7839 | 19.7836 | 19.7839 | 7168.0 |
| 2014-01-15 06:07:00 | AAPL | Stock | 19.7679 | 19.7679 | 19.7679 | 19.7679 | 11200.0 |
| 2014-01-15 06:08:00 | AAPL | Stock | 19.7621 | 19.7621 | 19.7504 | 19.7504 | 28336.0 |
| 2014-01-15 06:09:00 | AAPL | Stock | 19.7357 | 19.7357 | 19.7357 | 19.7357 | 17304.0 |
| 2014-01-15 06:12:00 | AAPL | Stock | 19.7621 | 19.7621 | 19.7621 | 19.7621 | 2800.0 |
| 2014-01-15 06:13:00 | AAPL | Stock | 19.7589 | 19.7589 | 19.7589 | 19.7589 | 2800.0 |
| 2014-01-15 06:16:00 | AAPL | Stock | 19.7475 | 19.7475 | 19.7475 | 19.7475 | 2800.0 |
| 2014-01-15 06:17:00 | AAPL | Stock | 19.7375 | 19.7375 | 19.7357 | 19.7357 | 5600.0 |
| 2014-01-15 06:18:00 | AAPL | Stock | 19.7339 | 19.7339 | 19.7254 | 19.7254 | 11536.0 |
| 2014-01-15 06:19:00 | AAPL | Stock | 19.7146 | 19.7254 | 19.7146 | 19.7246 | 9800.0 |
| 2014-01-15 06:22:00 | AAPL | Stock | 19.7143 | 19.7143 | 19.7143 | 19.7143 | 2800.0 |
| 2014-01-15 06:23:00 | AAPL | Stock | 19.725 | 19.725 | 19.725 | 19.725 | 15512.0 |
| 2014-01-15 06:25:00 | AAPL | Stock | 19.725 | 19.725 | 19.725 | 19.725 | 8400.0 |
| 2014-01-15 06:26:00 | AAPL | Stock | 19.735 | 19.735 | 19.735 | 19.735 | 2800.0 |
| 2014-01-15 06:28:00 | AAPL | Stock | 19.735 | 19.735 | 19.735 | 19.735 | 2800.0 |
| 2014-01-15 06:29:00 | AAPL | Stock | 19.7321 | 19.7321 | 19.7321 | 19.7321 | 5600.0 |
| 2014-01-15 06:34:00 | AAPL | Stock | 19.7411 | 19.7411 | 19.7411 | 19.7411 | 2800.0 |
| 2014-01-15 06:37:00 | AAPL | Stock | 19.7321 | 19.7321 | 19.7268 | 19.7268 | 8400.0 |
> showing 50 of 1,050,481 rows — these rows as CSV