PREVIEW / stock_1min / 2014-01-30
file: by_date/stock_1min/2014/2014-01-30.parquet size: 14.7 MB rows: 1,059,820 symbols: 2,850
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-30 04:03:00 | AAPL | Stock | 17.8232 | 17.8232 | 17.8232 | 17.8232 | 5600.0 |
| 2014-01-30 04:20:00 | AAPL | Stock | 17.8289 | 17.8289 | 17.8289 | 17.8289 | 2800.0 |
| 2014-01-30 04:42:00 | AAPL | Stock | 17.8346 | 17.8346 | 17.8346 | 17.8346 | 7672.0 |
| 2014-01-30 04:43:00 | AAPL | Stock | 17.8286 | 17.8286 | 17.8214 | 17.8214 | 8400.0 |
| 2014-01-30 04:45:00 | AAPL | Stock | 17.8196 | 17.8196 | 17.8196 | 17.8196 | 5600.0 |
| 2014-01-30 04:59:00 | AAPL | Stock | 17.7893 | 17.7893 | 17.7857 | 17.7857 | 8400.0 |
| 2014-01-30 05:02:00 | AAPL | Stock | 17.7893 | 17.7893 | 17.7893 | 17.7893 | 2800.0 |
| 2014-01-30 05:09:00 | AAPL | Stock | 17.7864 | 17.7864 | 17.7864 | 17.7864 | 2800.0 |
| 2014-01-30 05:12:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 2800.0 |
| 2014-01-30 05:13:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 11872.0 |
| 2014-01-30 05:25:00 | AAPL | Stock | 17.7764 | 17.7764 | 17.7764 | 17.7764 | 13608.0 |
| 2014-01-30 05:27:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 2800.0 |
| 2014-01-30 05:28:00 | AAPL | Stock | 17.7964 | 17.7993 | 17.7964 | 17.7993 | 8400.0 |
| 2014-01-30 05:29:00 | AAPL | Stock | 17.7886 | 17.7886 | 17.7886 | 17.7886 | 8400.0 |
| 2014-01-30 05:31:00 | AAPL | Stock | 17.7989 | 17.8057 | 17.7989 | 17.8057 | 28140.0 |
| 2014-01-30 05:32:00 | AAPL | Stock | 17.8257 | 17.8257 | 17.8257 | 17.8257 | 2800.0 |
| 2014-01-30 05:38:00 | AAPL | Stock | 17.8282 | 17.8282 | 17.8282 | 17.8282 | 7476.0 |
| 2014-01-30 06:12:00 | AAPL | Stock | 17.8164 | 17.8164 | 17.8164 | 17.8164 | 7000.0 |
| 2014-01-30 06:16:00 | AAPL | Stock | 17.8036 | 17.8039 | 17.8036 | 17.8036 | 11200.0 |
| 2014-01-30 06:18:00 | AAPL | Stock | 17.83 | 17.83 | 17.83 | 17.83 | 2800.0 |
| 2014-01-30 06:21:00 | AAPL | Stock | 17.8343 | 17.835 | 17.8343 | 17.835 | 9352.0 |
| 2014-01-30 06:25:00 | AAPL | Stock | 17.8493 | 17.8496 | 17.8493 | 17.8496 | 6160.0 |
| 2014-01-30 06:26:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.8214 | 17.8214 | 2800.0 |
| 2014-01-30 06:32:00 | AAPL | Stock | 17.8543 | 17.8543 | 17.8543 | 17.8543 | 5600.0 |
| 2014-01-30 06:41:00 | AAPL | Stock | 17.8714 | 17.8714 | 17.8714 | 17.8714 | 2800.0 |
| 2014-01-30 06:44:00 | AAPL | Stock | 17.8714 | 17.8714 | 17.8714 | 17.8714 | 2800.0 |
| 2014-01-30 06:50:00 | AAPL | Stock | 17.8571 | 17.8607 | 17.8571 | 17.8607 | 8372.0 |
| 2014-01-30 06:51:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 9324.0 |
| 2014-01-30 06:56:00 | AAPL | Stock | 17.8839 | 17.8839 | 17.8839 | 17.8839 | 2800.0 |
| 2014-01-30 07:00:00 | AAPL | Stock | 17.8857 | 17.8857 | 17.8857 | 17.8857 | 2800.0 |
| 2014-01-30 07:07:00 | AAPL | Stock | 17.8911 | 17.8914 | 17.8911 | 17.8914 | 9800.0 |
| 2014-01-30 07:08:00 | AAPL | Stock | 17.8932 | 17.8932 | 17.8932 | 17.8932 | 5600.0 |
| 2014-01-30 07:12:00 | AAPL | Stock | 17.9 | 17.905 | 17.9 | 17.905 | 10080.0 |
| 2014-01-30 07:13:00 | AAPL | Stock | 17.9096 | 17.9096 | 17.9054 | 17.9054 | 14000.0 |
| 2014-01-30 07:15:00 | AAPL | Stock | 17.9096 | 17.9125 | 17.9096 | 17.9125 | 16436.0 |
| 2014-01-30 07:18:00 | AAPL | Stock | 17.9071 | 17.9071 | 17.9036 | 17.9036 | 8400.0 |
| 2014-01-30 07:21:00 | AAPL | Stock | 17.9082 | 17.9082 | 17.8929 | 17.8929 | 11200.0 |
| 2014-01-30 07:22:00 | AAPL | Stock | 17.905 | 17.9093 | 17.905 | 17.9093 | 18900.0 |
| 2014-01-30 07:23:00 | AAPL | Stock | 17.9107 | 17.9121 | 17.8929 | 17.8929 | 47600.0 |
| 2014-01-30 07:25:00 | AAPL | Stock | 17.9107 | 17.9229 | 17.9107 | 17.9107 | 93940.0 |
| 2014-01-30 07:28:00 | AAPL | Stock | 17.9118 | 17.9118 | 17.9118 | 17.9118 | 2800.0 |
| 2014-01-30 07:29:00 | AAPL | Stock | 17.9107 | 17.9107 | 17.8929 | 17.8929 | 11200.0 |
| 2014-01-30 07:36:00 | AAPL | Stock | 17.8968 | 17.9029 | 17.8968 | 17.8968 | 21700.0 |
| 2014-01-30 07:39:00 | AAPL | Stock | 17.9089 | 17.91 | 17.9068 | 17.9089 | 49560.0 |
| 2014-01-30 07:40:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 5600.0 |
| 2014-01-30 07:41:00 | AAPL | Stock | 17.8929 | 17.8939 | 17.8929 | 17.8939 | 5600.0 |
| 2014-01-30 07:48:00 | AAPL | Stock | 17.9071 | 17.9071 | 17.8982 | 17.8982 | 5600.0 |
| 2014-01-30 07:49:00 | AAPL | Stock | 17.8982 | 17.8982 | 17.8857 | 17.8929 | 22400.0 |
| 2014-01-30 07:50:00 | AAPL | Stock | 17.8857 | 17.8857 | 17.8857 | 17.8857 | 2800.0 |
| 2014-01-30 07:52:00 | AAPL | Stock | 17.8625 | 17.8857 | 17.8625 | 17.8857 | 24360.0 |
> showing 50 of 1,059,820 rows — these rows as CSV