PREVIEW / stock_1min / 2013-06-19
file: by_date/stock_1min/2013/2013-06-19.parquet size: 13.3 MB rows: 982,463 symbols: 2,843
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-06-19 06:28:00 | AAPL | Stock | 15.4325 | 15.4325 | 15.4325 | 15.4325 | 2800.0 |
| 2013-06-19 06:43:00 | AAPL | Stock | 15.4279 | 15.4279 | 15.4279 | 15.4279 | 2800.0 |
| 2013-06-19 07:01:00 | AAPL | Stock | 15.4221 | 15.4221 | 15.4221 | 15.4221 | 2800.0 |
| 2013-06-19 07:02:00 | AAPL | Stock | 15.4221 | 15.4221 | 15.4164 | 15.4164 | 14000.0 |
| 2013-06-19 07:04:00 | AAPL | Stock | 15.4118 | 15.4118 | 15.4118 | 15.4118 | 8400.0 |
| 2013-06-19 07:05:00 | AAPL | Stock | 15.4107 | 15.4125 | 15.4107 | 15.4125 | 5600.0 |
| 2013-06-19 07:07:00 | AAPL | Stock | 15.4139 | 15.4193 | 15.4139 | 15.4193 | 8400.0 |
| 2013-06-19 07:10:00 | AAPL | Stock | 15.4071 | 15.4121 | 15.4071 | 15.4121 | 5600.0 |
| 2013-06-19 07:11:00 | AAPL | Stock | 15.4039 | 15.4039 | 15.4039 | 15.4039 | 8400.0 |
| 2013-06-19 07:21:00 | AAPL | Stock | 15.4086 | 15.4086 | 15.4086 | 15.4086 | 8400.0 |
| 2013-06-19 07:30:00 | AAPL | Stock | 15.4043 | 15.4043 | 15.3982 | 15.3982 | 18900.0 |
| 2013-06-19 07:31:00 | AAPL | Stock | 15.3936 | 15.4032 | 15.3929 | 15.4032 | 16800.0 |
| 2013-06-19 07:34:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 2800.0 |
| 2013-06-19 07:36:00 | AAPL | Stock | 15.3932 | 15.3932 | 15.3932 | 15.3932 | 2800.0 |
| 2013-06-19 07:44:00 | AAPL | Stock | 15.3932 | 15.3964 | 15.3932 | 15.3964 | 8400.0 |
| 2013-06-19 07:46:00 | AAPL | Stock | 15.4029 | 15.4032 | 15.4029 | 15.4032 | 9380.0 |
| 2013-06-19 07:53:00 | AAPL | Stock | 15.3971 | 15.3975 | 15.3971 | 15.3975 | 11200.0 |
| 2013-06-19 07:55:00 | AAPL | Stock | 15.3989 | 15.3989 | 15.3964 | 15.3964 | 21476.0 |
| 2013-06-19 07:56:00 | AAPL | Stock | 15.4025 | 15.4025 | 15.3939 | 15.3939 | 5600.0 |
| 2013-06-19 07:59:00 | AAPL | Stock | 15.4032 | 15.4032 | 15.4029 | 15.4029 | 11200.0 |
| 2013-06-19 08:00:00 | AAPL | Stock | 15.4036 | 15.4125 | 15.4 | 15.4 | 62524.0 |
| 2013-06-19 08:01:00 | AAPL | Stock | 15.3968 | 15.4 | 15.3946 | 15.4 | 30660.0 |
| 2013-06-19 08:03:00 | AAPL | Stock | 15.3971 | 15.3986 | 15.3929 | 15.3982 | 51100.0 |
| 2013-06-19 08:04:00 | AAPL | Stock | 15.4125 | 15.4154 | 15.4107 | 15.4107 | 12096.0 |
| 2013-06-19 08:05:00 | AAPL | Stock | 15.4107 | 15.4107 | 15.4107 | 15.4107 | 5264.0 |
| 2013-06-19 08:06:00 | AAPL | Stock | 15.4036 | 15.4036 | 15.4036 | 15.4036 | 2800.0 |
| 2013-06-19 08:09:00 | AAPL | Stock | 15.4036 | 15.4036 | 15.4014 | 15.4014 | 5600.0 |
| 2013-06-19 08:16:00 | AAPL | Stock | 15.4125 | 15.4125 | 15.4125 | 15.4125 | 5600.0 |
| 2013-06-19 08:21:00 | AAPL | Stock | 15.4107 | 15.4107 | 15.4107 | 15.4107 | 2800.0 |
| 2013-06-19 08:30:00 | AAPL | Stock | 15.4018 | 15.4018 | 15.4011 | 15.4011 | 8400.0 |
| 2013-06-19 08:31:00 | AAPL | Stock | 15.4018 | 15.4018 | 15.4018 | 15.4018 | 6524.0 |
| 2013-06-19 08:32:00 | AAPL | Stock | 15.4 | 15.4 | 15.4 | 15.4 | 2800.0 |
| 2013-06-19 08:37:00 | AAPL | Stock | 15.4036 | 15.4036 | 15.4036 | 15.4036 | 8400.0 |
| 2013-06-19 08:38:00 | AAPL | Stock | 15.4032 | 15.4032 | 15.4 | 15.4 | 11200.0 |
| 2013-06-19 08:39:00 | AAPL | Stock | 15.4036 | 15.4036 | 15.4036 | 15.4036 | 2800.0 |
| 2013-06-19 08:40:00 | AAPL | Stock | 15.3982 | 15.3982 | 15.3982 | 15.3982 | 2800.0 |
| 2013-06-19 08:43:00 | AAPL | Stock | 15.4036 | 15.405 | 15.4036 | 15.405 | 16800.0 |
| 2013-06-19 08:49:00 | AAPL | Stock | 15.4086 | 15.4086 | 15.4086 | 15.4086 | 2800.0 |
| 2013-06-19 08:50:00 | AAPL | Stock | 15.4086 | 15.4086 | 15.4086 | 15.4086 | 2800.0 |
| 2013-06-19 08:57:00 | AAPL | Stock | 15.4068 | 15.4071 | 15.4068 | 15.4071 | 5600.0 |
| 2013-06-19 09:03:00 | AAPL | Stock | 15.4089 | 15.4089 | 15.4089 | 15.4089 | 2800.0 |
| 2013-06-19 09:05:00 | AAPL | Stock | 15.4093 | 15.4093 | 15.4093 | 15.4093 | 2800.0 |
| 2013-06-19 09:06:00 | AAPL | Stock | 15.4093 | 15.4093 | 15.4093 | 15.4093 | 2800.0 |
| 2013-06-19 09:14:00 | AAPL | Stock | 15.4093 | 15.4093 | 15.4093 | 15.4093 | 2800.0 |
| 2013-06-19 09:18:00 | AAPL | Stock | 15.4018 | 15.4036 | 15.4018 | 15.4036 | 5600.0 |
| 2013-06-19 09:20:00 | AAPL | Stock | 15.3968 | 15.3986 | 15.3893 | 15.3893 | 50428.0 |
| 2013-06-19 09:21:00 | AAPL | Stock | 15.3864 | 15.3864 | 15.3861 | 15.3861 | 5600.0 |
| 2013-06-19 09:23:00 | AAPL | Stock | 15.3921 | 15.3929 | 15.3921 | 15.3929 | 29204.0 |
| 2013-06-19 09:24:00 | AAPL | Stock | 15.4036 | 15.4036 | 15.4036 | 15.4036 | 2800.0 |
| 2013-06-19 09:25:00 | AAPL | Stock | 15.3954 | 15.3954 | 15.3929 | 15.3929 | 28000.0 |
> showing 50 of 982,463 rows — these rows as CSV