PREVIEW / stock_1min / 2014-02-27
file: by_date/stock_1min/2014/2014-02-27.parquet size: 14.5 MB rows: 1,060,297 symbols: 2,862
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-02-27 04:02:00 | AAPL | Stock | 18.4964 | 18.4964 | 18.4964 | 18.4964 | 2800.0 |
| 2014-02-27 04:11:00 | AAPL | Stock | 18.4511 | 18.4511 | 18.4511 | 18.4511 | 2800.0 |
| 2014-02-27 04:12:00 | AAPL | Stock | 18.4511 | 18.4511 | 18.4511 | 18.4511 | 2800.0 |
| 2014-02-27 04:16:00 | AAPL | Stock | 18.4511 | 18.4511 | 18.4511 | 18.4511 | 2800.0 |
| 2014-02-27 04:17:00 | AAPL | Stock | 18.4511 | 18.4511 | 18.4511 | 18.4511 | 2800.0 |
| 2014-02-27 04:20:00 | AAPL | Stock | 18.4511 | 18.4511 | 18.4511 | 18.4511 | 8400.0 |
| 2014-02-27 04:21:00 | AAPL | Stock | 18.4511 | 18.4511 | 18.4511 | 18.4511 | 7644.0 |
| 2014-02-27 04:29:00 | AAPL | Stock | 18.4161 | 18.4161 | 18.4161 | 18.4161 | 5432.0 |
| 2014-02-27 04:30:00 | AAPL | Stock | 18.5054 | 18.5054 | 18.5054 | 18.5054 | 2800.0 |
| 2014-02-27 04:31:00 | AAPL | Stock | 18.4 | 18.4 | 18.3929 | 18.3929 | 5600.0 |
| 2014-02-27 04:49:00 | AAPL | Stock | 18.4082 | 18.4082 | 18.3929 | 18.3929 | 20664.0 |
| 2014-02-27 04:56:00 | AAPL | Stock | 18.3768 | 18.3768 | 18.3768 | 18.3768 | 2800.0 |
| 2014-02-27 04:57:00 | AAPL | Stock | 18.3764 | 18.3764 | 18.3764 | 18.3764 | 2800.0 |
| 2014-02-27 05:11:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 2800.0 |
| 2014-02-27 06:01:00 | AAPL | Stock | 18.4196 | 18.4196 | 18.4196 | 18.4196 | 2800.0 |
| 2014-02-27 06:09:00 | AAPL | Stock | 18.3946 | 18.3946 | 18.3939 | 18.3939 | 8400.0 |
| 2014-02-27 06:14:00 | AAPL | Stock | 18.3629 | 18.3629 | 18.3629 | 18.3629 | 2800.0 |
| 2014-02-27 06:17:00 | AAPL | Stock | 18.3704 | 18.3704 | 18.3704 | 18.3704 | 2800.0 |
| 2014-02-27 06:29:00 | AAPL | Stock | 18.3746 | 18.3746 | 18.3746 | 18.3746 | 5908.0 |
| 2014-02-27 06:34:00 | AAPL | Stock | 18.3736 | 18.3736 | 18.3736 | 18.3736 | 2800.0 |
| 2014-02-27 06:39:00 | AAPL | Stock | 18.3886 | 18.3886 | 18.3886 | 18.3886 | 5600.0 |
| 2014-02-27 06:44:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 2800.0 |
| 2014-02-27 06:58:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 5600.0 |
| 2014-02-27 07:02:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 2800.0 |
| 2014-02-27 07:03:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 5600.0 |
| 2014-02-27 07:08:00 | AAPL | Stock | 18.4086 | 18.4107 | 18.4086 | 18.4107 | 8400.0 |
| 2014-02-27 07:09:00 | AAPL | Stock | 18.4246 | 18.4275 | 18.4246 | 18.4275 | 9800.0 |
| 2014-02-27 07:18:00 | AAPL | Stock | 18.4 | 18.4 | 18.4 | 18.4 | 5600.0 |
| 2014-02-27 07:20:00 | AAPL | Stock | 18.4071 | 18.4071 | 18.4071 | 18.4071 | 12628.0 |
| 2014-02-27 07:24:00 | AAPL | Stock | 18.4107 | 18.4107 | 18.4107 | 18.4107 | 2800.0 |
| 2014-02-27 07:27:00 | AAPL | Stock | 18.4275 | 18.4286 | 18.4211 | 18.4286 | 42140.0 |
| 2014-02-27 07:29:00 | AAPL | Stock | 18.4546 | 18.4546 | 18.4546 | 18.4546 | 2800.0 |
| 2014-02-27 07:31:00 | AAPL | Stock | 18.4357 | 18.4357 | 18.4275 | 18.4275 | 28000.0 |
| 2014-02-27 07:32:00 | AAPL | Stock | 18.4214 | 18.4214 | 18.4175 | 18.4175 | 14000.0 |
| 2014-02-27 07:33:00 | AAPL | Stock | 18.4143 | 18.4143 | 18.4107 | 18.4107 | 57400.0 |
| 2014-02-27 07:37:00 | AAPL | Stock | 18.4107 | 18.4107 | 18.4107 | 18.4107 | 2800.0 |
| 2014-02-27 07:38:00 | AAPL | Stock | 18.4054 | 18.4054 | 18.4054 | 18.4054 | 11200.0 |
| 2014-02-27 07:44:00 | AAPL | Stock | 18.4036 | 18.4036 | 18.4036 | 18.4036 | 4536.0 |
| 2014-02-27 07:45:00 | AAPL | Stock | 18.4036 | 18.4036 | 18.4036 | 18.4036 | 17332.0 |
| 2014-02-27 07:53:00 | AAPL | Stock | 18.4093 | 18.4093 | 18.4036 | 18.4036 | 24248.0 |
| 2014-02-27 07:58:00 | AAPL | Stock | 18.4125 | 18.4125 | 18.4104 | 18.4125 | 38948.0 |
| 2014-02-27 08:00:00 | AAPL | Stock | 18.4268 | 18.4268 | 18.375 | 18.4107 | 54096.0 |
| 2014-02-27 08:01:00 | AAPL | Stock | 18.4129 | 18.4129 | 18.4107 | 18.4107 | 11900.0 |
| 2014-02-27 08:02:00 | AAPL | Stock | 18.4107 | 18.4107 | 18.4107 | 18.4107 | 11900.0 |
| 2014-02-27 08:03:00 | AAPL | Stock | 18.4071 | 18.4071 | 18.4004 | 18.4004 | 27468.0 |
| 2014-02-27 08:05:00 | AAPL | Stock | 18.3971 | 18.3971 | 18.395 | 18.3968 | 13300.0 |
| 2014-02-27 08:06:00 | AAPL | Stock | 18.3946 | 18.3946 | 18.3911 | 18.3911 | 120036.0 |
| 2014-02-27 08:07:00 | AAPL | Stock | 18.3914 | 18.3914 | 18.3914 | 18.3914 | 2800.0 |
| 2014-02-27 08:08:00 | AAPL | Stock | 18.3968 | 18.3968 | 18.3929 | 18.3968 | 36400.0 |
| 2014-02-27 08:09:00 | AAPL | Stock | 18.3857 | 18.3857 | 18.3839 | 18.3839 | 16800.0 |
> showing 50 of 1,060,297 rows — these rows as CSV