PREVIEW / stock_1min / 2014-04-08
file: by_date/stock_1min/2014/2014-04-08.parquet size: 15.0 MB rows: 1,086,422 symbols: 2,880
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-04-08 04:37:00 | AAPL | Stock | 18.7725 | 18.7725 | 18.7725 | 18.7725 | 5600.0 |
| 2014-04-08 04:52:00 | AAPL | Stock | 18.7786 | 18.7839 | 18.7786 | 18.7839 | 14000.0 |
| 2014-04-08 05:01:00 | AAPL | Stock | 18.7557 | 18.7557 | 18.7557 | 18.7557 | 2800.0 |
| 2014-04-08 05:03:00 | AAPL | Stock | 18.7518 | 18.7518 | 18.7518 | 18.7518 | 2800.0 |
| 2014-04-08 05:14:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 4116.0 |
| 2014-04-08 05:33:00 | AAPL | Stock | 18.7479 | 18.7479 | 18.7479 | 18.7479 | 2800.0 |
| 2014-04-08 05:35:00 | AAPL | Stock | 18.7457 | 18.7479 | 18.7457 | 18.7479 | 5600.0 |
| 2014-04-08 05:40:00 | AAPL | Stock | 18.7311 | 18.7311 | 18.7311 | 18.7311 | 5600.0 |
| 2014-04-08 05:44:00 | AAPL | Stock | 18.7161 | 18.7161 | 18.7161 | 18.7161 | 2800.0 |
| 2014-04-08 05:58:00 | AAPL | Stock | 18.7161 | 18.7161 | 18.7161 | 18.7161 | 2800.0 |
| 2014-04-08 06:20:00 | AAPL | Stock | 18.71 | 18.71 | 18.71 | 18.71 | 2800.0 |
| 2014-04-08 06:53:00 | AAPL | Stock | 18.6964 | 18.6964 | 18.6964 | 18.6964 | 2800.0 |
| 2014-04-08 07:36:00 | AAPL | Stock | 18.6986 | 18.6986 | 18.6986 | 18.6986 | 2800.0 |
| 2014-04-08 07:43:00 | AAPL | Stock | 18.7021 | 18.7021 | 18.7 | 18.7 | 11200.0 |
| 2014-04-08 07:49:00 | AAPL | Stock | 18.6857 | 18.6857 | 18.6857 | 18.6857 | 5600.0 |
| 2014-04-08 07:55:00 | AAPL | Stock | 18.7025 | 18.7025 | 18.7025 | 18.7025 | 3892.0 |
| 2014-04-08 07:57:00 | AAPL | Stock | 18.7036 | 18.7036 | 18.7036 | 18.7036 | 2800.0 |
| 2014-04-08 08:00:00 | AAPL | Stock | 18.6986 | 18.7143 | 18.6986 | 18.7143 | 27440.0 |
| 2014-04-08 08:04:00 | AAPL | Stock | 18.7129 | 18.7214 | 18.7107 | 18.7143 | 37604.0 |
| 2014-04-08 08:06:00 | AAPL | Stock | 18.7232 | 18.7232 | 18.7232 | 18.7232 | 2800.0 |
| 2014-04-08 08:07:00 | AAPL | Stock | 18.735 | 18.735 | 18.735 | 18.735 | 2800.0 |
| 2014-04-08 08:09:00 | AAPL | Stock | 18.7382 | 18.7411 | 18.7382 | 18.7411 | 5600.0 |
| 2014-04-08 08:10:00 | AAPL | Stock | 18.7679 | 18.7732 | 18.7504 | 18.7504 | 18480.0 |
| 2014-04-08 08:11:00 | AAPL | Stock | 18.7521 | 18.7521 | 18.7521 | 18.7521 | 2800.0 |
| 2014-04-08 08:12:00 | AAPL | Stock | 18.7521 | 18.7607 | 18.7521 | 18.7607 | 5600.0 |
| 2014-04-08 08:15:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7679 | 18.7679 | 2800.0 |
| 2014-04-08 08:16:00 | AAPL | Stock | 18.7589 | 18.7593 | 18.7589 | 18.7593 | 5600.0 |
| 2014-04-08 08:18:00 | AAPL | Stock | 18.7671 | 18.7743 | 18.7671 | 18.7679 | 28084.0 |
| 2014-04-08 08:20:00 | AAPL | Stock | 18.7589 | 18.7589 | 18.7589 | 18.7589 | 5600.0 |
| 2014-04-08 08:21:00 | AAPL | Stock | 18.7586 | 18.7586 | 18.7586 | 18.7586 | 2800.0 |
| 2014-04-08 08:25:00 | AAPL | Stock | 18.7454 | 18.7454 | 18.7454 | 18.7454 | 2800.0 |
| 2014-04-08 08:27:00 | AAPL | Stock | 18.7568 | 18.7589 | 18.7568 | 18.7589 | 17640.0 |
| 2014-04-08 08:28:00 | AAPL | Stock | 18.7664 | 18.8079 | 18.7664 | 18.7714 | 120288.0 |
| 2014-04-08 08:29:00 | AAPL | Stock | 18.7857 | 18.7857 | 18.7857 | 18.7857 | 2800.0 |
| 2014-04-08 08:30:00 | AAPL | Stock | 18.7957 | 18.8036 | 18.7957 | 18.8029 | 24360.0 |
| 2014-04-08 08:31:00 | AAPL | Stock | 18.7896 | 18.7896 | 18.7893 | 18.7893 | 19600.0 |
| 2014-04-08 08:32:00 | AAPL | Stock | 18.8011 | 18.8068 | 18.8011 | 18.8043 | 62048.0 |
| 2014-04-08 08:33:00 | AAPL | Stock | 18.8036 | 18.8075 | 18.8036 | 18.8068 | 30800.0 |
| 2014-04-08 08:34:00 | AAPL | Stock | 18.8054 | 18.8054 | 18.8036 | 18.8036 | 11200.0 |
| 2014-04-08 08:35:00 | AAPL | Stock | 18.7929 | 18.7929 | 18.7929 | 18.7929 | 2800.0 |
| 2014-04-08 08:36:00 | AAPL | Stock | 18.7954 | 18.7957 | 18.7911 | 18.7911 | 8400.0 |
| 2014-04-08 08:38:00 | AAPL | Stock | 18.8025 | 18.815 | 18.8025 | 18.8068 | 142800.0 |
| 2014-04-08 08:39:00 | AAPL | Stock | 18.8068 | 18.8068 | 18.8043 | 18.8068 | 37800.0 |
| 2014-04-08 08:40:00 | AAPL | Stock | 18.8068 | 18.8068 | 18.8025 | 18.8025 | 14000.0 |
| 2014-04-08 08:41:00 | AAPL | Stock | 18.7936 | 18.7936 | 18.7936 | 18.7936 | 2800.0 |
| 2014-04-08 08:44:00 | AAPL | Stock | 18.8014 | 18.8014 | 18.8 | 18.8011 | 8400.0 |
| 2014-04-08 08:46:00 | AAPL | Stock | 18.7943 | 18.7975 | 18.7943 | 18.7964 | 29120.0 |
| 2014-04-08 08:47:00 | AAPL | Stock | 18.7971 | 18.7971 | 18.7871 | 18.7879 | 14840.0 |
| 2014-04-08 08:48:00 | AAPL | Stock | 18.7893 | 18.7893 | 18.7893 | 18.7893 | 14000.0 |
| 2014-04-08 08:52:00 | AAPL | Stock | 18.795 | 18.7964 | 18.795 | 18.7964 | 11060.0 |
> showing 50 of 1,086,422 rows — these rows as CSV