PREVIEW / stock_1min / 2013-11-15
file: by_date/stock_1min/2013/2013-11-15.parquet size: 13.7 MB rows: 995,815 symbols: 2,871
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-15 04:06:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 2800.0 |
| 2013-11-15 04:23:00 | AAPL | Stock | 18.8854 | 18.8854 | 18.8629 | 18.8629 | 5600.0 |
| 2013-11-15 04:25:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 2800.0 |
| 2013-11-15 04:26:00 | AAPL | Stock | 18.8868 | 18.8932 | 18.8868 | 18.8932 | 8400.0 |
| 2013-11-15 05:07:00 | AAPL | Stock | 18.8589 | 18.8589 | 18.8589 | 18.8589 | 2800.0 |
| 2013-11-15 05:10:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 2800.0 |
| 2013-11-15 05:12:00 | AAPL | Stock | 18.8457 | 18.8457 | 18.8457 | 18.8457 | 5600.0 |
| 2013-11-15 05:49:00 | AAPL | Stock | 18.8689 | 18.8689 | 18.8689 | 18.8689 | 2800.0 |
| 2013-11-15 05:50:00 | AAPL | Stock | 18.8807 | 18.8807 | 18.8807 | 18.8807 | 2800.0 |
| 2013-11-15 05:52:00 | AAPL | Stock | 18.8611 | 18.8611 | 18.8611 | 18.8611 | 2800.0 |
| 2013-11-15 06:17:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 5600.0 |
| 2013-11-15 06:35:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 5376.0 |
| 2013-11-15 06:50:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 11200.0 |
| 2013-11-15 06:58:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 8288.0 |
| 2013-11-15 07:00:00 | AAPL | Stock | 18.8929 | 18.8932 | 18.8929 | 18.8929 | 48048.0 |
| 2013-11-15 07:01:00 | AAPL | Stock | 18.8925 | 18.8929 | 18.8925 | 18.8929 | 15400.0 |
| 2013-11-15 07:04:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 11200.0 |
| 2013-11-15 07:06:00 | AAPL | Stock | 18.8936 | 18.8936 | 18.8936 | 18.8936 | 2968.0 |
| 2013-11-15 07:07:00 | AAPL | Stock | 18.9 | 18.9004 | 18.9 | 18.9004 | 5600.0 |
| 2013-11-15 07:08:00 | AAPL | Stock | 18.9004 | 18.9054 | 18.9004 | 18.9054 | 16100.0 |
| 2013-11-15 07:16:00 | AAPL | Stock | 18.9036 | 18.9036 | 18.9036 | 18.9036 | 2800.0 |
| 2013-11-15 07:17:00 | AAPL | Stock | 18.8982 | 18.8982 | 18.8982 | 18.8982 | 12600.0 |
| 2013-11-15 07:19:00 | AAPL | Stock | 18.8982 | 18.8982 | 18.8929 | 18.8929 | 14000.0 |
| 2013-11-15 07:20:00 | AAPL | Stock | 18.8993 | 18.9029 | 18.8993 | 18.9029 | 5600.0 |
| 2013-11-15 07:24:00 | AAPL | Stock | 18.9021 | 18.9036 | 18.9021 | 18.9036 | 21980.0 |
| 2013-11-15 07:31:00 | AAPL | Stock | 18.9036 | 18.9071 | 18.9036 | 18.9071 | 43400.0 |
| 2013-11-15 07:33:00 | AAPL | Stock | 18.9114 | 18.9121 | 18.9114 | 18.9121 | 5600.0 |
| 2013-11-15 07:34:00 | AAPL | Stock | 18.9121 | 18.9121 | 18.9104 | 18.9104 | 5600.0 |
| 2013-11-15 07:35:00 | AAPL | Stock | 18.9064 | 18.9064 | 18.9064 | 18.9064 | 2800.0 |
| 2013-11-15 07:36:00 | AAPL | Stock | 18.9043 | 18.905 | 18.8982 | 18.8982 | 73808.0 |
| 2013-11-15 07:37:00 | AAPL | Stock | 18.8982 | 18.8982 | 18.8929 | 18.8929 | 30548.0 |
| 2013-11-15 07:38:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 35728.0 |
| 2013-11-15 07:39:00 | AAPL | Stock | 18.8839 | 18.8839 | 18.8839 | 18.8839 | 2800.0 |
| 2013-11-15 07:40:00 | AAPL | Stock | 18.8839 | 18.8839 | 18.8839 | 18.8839 | 8400.0 |
| 2013-11-15 07:41:00 | AAPL | Stock | 18.8839 | 18.8839 | 18.8839 | 18.8839 | 7476.0 |
| 2013-11-15 07:43:00 | AAPL | Stock | 18.8839 | 18.8839 | 18.8839 | 18.8839 | 5600.0 |
| 2013-11-15 07:45:00 | AAPL | Stock | 18.8761 | 18.8761 | 18.875 | 18.875 | 24304.0 |
| 2013-11-15 07:51:00 | AAPL | Stock | 18.8825 | 18.8839 | 18.8825 | 18.8839 | 11200.0 |
| 2013-11-15 07:52:00 | AAPL | Stock | 18.875 | 18.875 | 18.8679 | 18.8679 | 36400.0 |
| 2013-11-15 07:53:00 | AAPL | Stock | 18.8721 | 18.8721 | 18.8571 | 18.8711 | 14000.0 |
| 2013-11-15 07:57:00 | AAPL | Stock | 18.8679 | 18.8679 | 18.8571 | 18.8571 | 69160.0 |
| 2013-11-15 08:00:00 | AAPL | Stock | 18.875 | 18.9036 | 18.8636 | 18.8736 | 68600.0 |
| 2013-11-15 08:01:00 | AAPL | Stock | 18.8214 | 18.8625 | 18.8214 | 18.8461 | 58800.0 |
| 2013-11-15 08:02:00 | AAPL | Stock | 18.8393 | 18.8432 | 18.8393 | 18.8432 | 15400.0 |
| 2013-11-15 08:03:00 | AAPL | Stock | 18.8489 | 18.8489 | 18.845 | 18.845 | 14000.0 |
| 2013-11-15 08:04:00 | AAPL | Stock | 18.8439 | 18.845 | 18.8404 | 18.8404 | 8400.0 |
| 2013-11-15 08:05:00 | AAPL | Stock | 18.8561 | 18.8561 | 18.8561 | 18.8561 | 2800.0 |
| 2013-11-15 08:06:00 | AAPL | Stock | 18.8629 | 18.8629 | 18.8546 | 18.8546 | 196000.0 |
| 2013-11-15 08:09:00 | AAPL | Stock | 18.8414 | 18.8504 | 18.8389 | 18.8504 | 41440.0 |
| 2013-11-15 08:10:00 | AAPL | Stock | 18.8471 | 18.8482 | 18.8471 | 18.8482 | 16800.0 |
> showing 50 of 995,815 rows — these rows as CSV