PREVIEW / stock_1min / 2012-03-02
file: by_date/stock_1min/2012/2012-03-02.parquet size: 13.5 MB rows: 1,010,539 symbols: 2,829
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-02 06:24:00 | AAPL | Stock | 19.4464 | 19.4464 | 19.4464 | 19.4464 | 5600.0 |
| 2012-03-02 06:34:00 | AAPL | Stock | 19.4464 | 19.4464 | 19.4464 | 19.4464 | 2800.0 |
| 2012-03-02 07:00:00 | AAPL | Stock | 19.4443 | 19.4443 | 19.4357 | 19.4357 | 8680.0 |
| 2012-03-02 07:01:00 | AAPL | Stock | 19.4357 | 19.4357 | 19.4286 | 19.4286 | 35728.0 |
| 2012-03-02 07:03:00 | AAPL | Stock | 19.4129 | 19.4129 | 19.4125 | 19.4125 | 5600.0 |
| 2012-03-02 07:04:00 | AAPL | Stock | 19.4111 | 19.4111 | 19.4096 | 19.4096 | 38948.0 |
| 2012-03-02 07:05:00 | AAPL | Stock | 19.4104 | 19.4104 | 19.4104 | 19.4104 | 2800.0 |
| 2012-03-02 07:06:00 | AAPL | Stock | 19.4129 | 19.4129 | 19.4129 | 19.4129 | 2800.0 |
| 2012-03-02 07:07:00 | AAPL | Stock | 19.4104 | 19.4104 | 19.4104 | 19.4104 | 2800.0 |
| 2012-03-02 07:08:00 | AAPL | Stock | 19.4061 | 19.4061 | 19.4061 | 19.4061 | 14000.0 |
| 2012-03-02 07:09:00 | AAPL | Stock | 19.4061 | 19.4061 | 19.4036 | 19.4036 | 28000.0 |
| 2012-03-02 07:10:00 | AAPL | Stock | 19.4082 | 19.4082 | 19.4082 | 19.4082 | 2800.0 |
| 2012-03-02 07:11:00 | AAPL | Stock | 19.4054 | 19.4054 | 19.4054 | 19.4054 | 4480.0 |
| 2012-03-02 07:12:00 | AAPL | Stock | 19.4036 | 19.4036 | 19.4014 | 19.4014 | 5600.0 |
| 2012-03-02 07:13:00 | AAPL | Stock | 19.41 | 19.4129 | 19.41 | 19.4129 | 25200.0 |
| 2012-03-02 07:14:00 | AAPL | Stock | 19.4132 | 19.4136 | 19.4125 | 19.4129 | 19040.0 |
| 2012-03-02 07:15:00 | AAPL | Stock | 19.4196 | 19.42 | 19.4196 | 19.4196 | 58800.0 |
| 2012-03-02 07:16:00 | AAPL | Stock | 19.4196 | 19.4196 | 19.4196 | 19.4196 | 3164.0 |
| 2012-03-02 07:17:00 | AAPL | Stock | 19.4261 | 19.4268 | 19.425 | 19.425 | 25200.0 |
| 2012-03-02 07:21:00 | AAPL | Stock | 19.4154 | 19.4261 | 19.4154 | 19.4232 | 16044.0 |
| 2012-03-02 07:22:00 | AAPL | Stock | 19.4196 | 19.4196 | 19.4196 | 19.4196 | 11200.0 |
| 2012-03-02 07:23:00 | AAPL | Stock | 19.4196 | 19.4196 | 19.4196 | 19.4196 | 2800.0 |
| 2012-03-02 07:24:00 | AAPL | Stock | 19.4232 | 19.4232 | 19.4232 | 19.4232 | 2800.0 |
| 2012-03-02 07:26:00 | AAPL | Stock | 19.4179 | 19.4179 | 19.4179 | 19.4179 | 7280.0 |
| 2012-03-02 07:28:00 | AAPL | Stock | 19.4196 | 19.4196 | 19.4196 | 19.4196 | 5600.0 |
| 2012-03-02 07:30:00 | AAPL | Stock | 19.4161 | 19.4161 | 19.4161 | 19.4161 | 2800.0 |
| 2012-03-02 07:31:00 | AAPL | Stock | 19.4161 | 19.4161 | 19.4161 | 19.4161 | 25200.0 |
| 2012-03-02 07:32:00 | AAPL | Stock | 19.4204 | 19.4204 | 19.4125 | 19.4125 | 14280.0 |
| 2012-03-02 07:33:00 | AAPL | Stock | 19.4193 | 19.4193 | 19.4193 | 19.4193 | 4844.0 |
| 2012-03-02 07:34:00 | AAPL | Stock | 19.4196 | 19.4196 | 19.4189 | 19.4196 | 30800.0 |
| 2012-03-02 07:35:00 | AAPL | Stock | 19.4136 | 19.4136 | 19.3982 | 19.4004 | 185920.0 |
| 2012-03-02 07:36:00 | AAPL | Stock | 19.3975 | 19.3975 | 19.3929 | 19.3929 | 31640.0 |
| 2012-03-02 07:37:00 | AAPL | Stock | 19.3929 | 19.3964 | 19.3929 | 19.3964 | 14000.0 |
| 2012-03-02 07:38:00 | AAPL | Stock | 19.3964 | 19.3964 | 19.3854 | 19.3907 | 23380.0 |
| 2012-03-02 07:39:00 | AAPL | Stock | 19.3839 | 19.3839 | 19.3714 | 19.375 | 16800.0 |
| 2012-03-02 07:40:00 | AAPL | Stock | 19.3743 | 19.3804 | 19.3743 | 19.375 | 156380.0 |
| 2012-03-02 07:41:00 | AAPL | Stock | 19.3804 | 19.3875 | 19.38 | 19.38 | 11200.0 |
| 2012-03-02 07:42:00 | AAPL | Stock | 19.3907 | 19.3911 | 19.3764 | 19.3911 | 23380.0 |
| 2012-03-02 07:43:00 | AAPL | Stock | 19.3911 | 19.3911 | 19.3911 | 19.3911 | 8400.0 |
| 2012-03-02 07:44:00 | AAPL | Stock | 19.3929 | 19.3929 | 19.3929 | 19.3929 | 11200.0 |
| 2012-03-02 07:46:00 | AAPL | Stock | 19.3946 | 19.3946 | 19.3946 | 19.3946 | 2800.0 |
| 2012-03-02 07:48:00 | AAPL | Stock | 19.3907 | 19.3907 | 19.3864 | 19.3864 | 5600.0 |
| 2012-03-02 07:50:00 | AAPL | Stock | 19.3929 | 19.3964 | 19.3893 | 19.3964 | 76300.0 |
| 2012-03-02 07:51:00 | AAPL | Stock | 19.3964 | 19.3964 | 19.3964 | 19.3964 | 2800.0 |
| 2012-03-02 07:52:00 | AAPL | Stock | 19.4036 | 19.4064 | 19.3982 | 19.3982 | 53200.0 |
| 2012-03-02 07:55:00 | AAPL | Stock | 19.3939 | 19.3982 | 19.3939 | 19.3982 | 6300.0 |
| 2012-03-02 07:56:00 | AAPL | Stock | 19.3982 | 19.3986 | 19.3957 | 19.3957 | 8400.0 |
| 2012-03-02 07:57:00 | AAPL | Stock | 19.3957 | 19.3957 | 19.3957 | 19.3957 | 8820.0 |
| 2012-03-02 07:58:00 | AAPL | Stock | 19.4029 | 19.4029 | 19.4029 | 19.4029 | 2800.0 |
| 2012-03-02 08:00:00 | AAPL | Stock | 19.4071 | 19.4357 | 19.3982 | 19.4082 | 303632.0 |
> showing 50 of 1,010,539 rows — these rows as CSV