PREVIEW / stock_1min / 2010-06-02
file: by_date/stock_1min/2010/2010-06-02.parquet size: 13.3 MB rows: 1,020,116 symbols: 2,819
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-02 04:09:00 | AAPL | Stock | 9.3932 | 9.3932 | 9.3932 | 9.3932 | 14000.0 |
| 2010-06-02 04:11:00 | AAPL | Stock | 9.3868 | 9.3868 | 9.3868 | 9.3868 | 11200.0 |
| 2010-06-02 04:12:00 | AAPL | Stock | 9.3886 | 9.3886 | 9.3886 | 9.3886 | 14000.0 |
| 2010-06-02 04:15:00 | AAPL | Stock | 9.3843 | 9.3843 | 9.3754 | 9.3754 | 16800.0 |
| 2010-06-02 04:17:00 | AAPL | Stock | 9.3843 | 9.3843 | 9.3843 | 9.3843 | 2800.0 |
| 2010-06-02 04:21:00 | AAPL | Stock | 9.4314 | 9.4314 | 9.4314 | 9.4314 | 2800.0 |
| 2010-06-02 04:24:00 | AAPL | Stock | 9.3654 | 9.3664 | 9.3654 | 9.3664 | 28000.0 |
| 2010-06-02 05:30:00 | AAPL | Stock | 9.4204 | 9.4204 | 9.4204 | 9.4204 | 2800.0 |
| 2010-06-02 05:33:00 | AAPL | Stock | 9.4261 | 9.4261 | 9.4261 | 9.4261 | 2800.0 |
| 2010-06-02 06:12:00 | AAPL | Stock | 9.425 | 9.425 | 9.425 | 9.425 | 8120.0 |
| 2010-06-02 06:16:00 | AAPL | Stock | 9.42 | 9.42 | 9.4186 | 9.4186 | 14000.0 |
| 2010-06-02 06:19:00 | AAPL | Stock | 9.4407 | 9.4407 | 9.4407 | 9.4407 | 2800.0 |
| 2010-06-02 06:46:00 | AAPL | Stock | 9.425 | 9.425 | 9.425 | 9.425 | 2800.0 |
| 2010-06-02 06:56:00 | AAPL | Stock | 9.425 | 9.425 | 9.425 | 9.425 | 2800.0 |
| 2010-06-02 07:00:00 | AAPL | Stock | 9.425 | 9.4286 | 9.425 | 9.425 | 18900.0 |
| 2010-06-02 07:01:00 | AAPL | Stock | 9.4118 | 9.4118 | 9.4118 | 9.4118 | 2800.0 |
| 2010-06-02 07:02:00 | AAPL | Stock | 9.4221 | 9.4286 | 9.4221 | 9.4286 | 16800.0 |
| 2010-06-02 07:03:00 | AAPL | Stock | 9.4143 | 9.4143 | 9.4129 | 9.4129 | 14000.0 |
| 2010-06-02 07:04:00 | AAPL | Stock | 9.4196 | 9.4196 | 9.4143 | 9.4143 | 30800.0 |
| 2010-06-02 07:05:00 | AAPL | Stock | 9.4118 | 9.4118 | 9.41 | 9.41 | 9240.0 |
| 2010-06-02 07:07:00 | AAPL | Stock | 9.4175 | 9.4175 | 9.4154 | 9.4175 | 11200.0 |
| 2010-06-02 07:08:00 | AAPL | Stock | 9.4143 | 9.4143 | 9.4096 | 9.4104 | 21560.0 |
| 2010-06-02 07:10:00 | AAPL | Stock | 9.4179 | 9.4179 | 9.4179 | 9.4179 | 10276.0 |
| 2010-06-02 07:11:00 | AAPL | Stock | 9.4179 | 9.4179 | 9.4179 | 9.4179 | 2800.0 |
| 2010-06-02 07:12:00 | AAPL | Stock | 9.4179 | 9.4214 | 9.4179 | 9.4214 | 9800.0 |
| 2010-06-02 07:15:00 | AAPL | Stock | 9.4114 | 9.4179 | 9.4107 | 9.4179 | 25200.0 |
| 2010-06-02 07:16:00 | AAPL | Stock | 9.4286 | 9.4286 | 9.4286 | 9.4286 | 23184.0 |
| 2010-06-02 07:19:00 | AAPL | Stock | 9.425 | 9.425 | 9.425 | 9.425 | 11200.0 |
| 2010-06-02 07:23:00 | AAPL | Stock | 9.4239 | 9.4239 | 9.4239 | 9.4239 | 13580.0 |
| 2010-06-02 07:24:00 | AAPL | Stock | 9.4143 | 9.4143 | 9.4143 | 9.4143 | 2800.0 |
| 2010-06-02 07:27:00 | AAPL | Stock | 9.4214 | 9.4214 | 9.4214 | 9.4214 | 5600.0 |
| 2010-06-02 07:29:00 | AAPL | Stock | 9.4211 | 9.4321 | 9.4211 | 9.4321 | 67200.0 |
| 2010-06-02 07:31:00 | AAPL | Stock | 9.4368 | 9.4368 | 9.4368 | 9.4368 | 8400.0 |
| 2010-06-02 07:32:00 | AAPL | Stock | 9.4289 | 9.4289 | 9.4286 | 9.4286 | 16800.0 |
| 2010-06-02 07:34:00 | AAPL | Stock | 9.4146 | 9.4146 | 9.4146 | 9.4146 | 2800.0 |
| 2010-06-02 07:35:00 | AAPL | Stock | 9.4132 | 9.4132 | 9.4132 | 9.4132 | 5600.0 |
| 2010-06-02 07:38:00 | AAPL | Stock | 9.4204 | 9.4204 | 9.4204 | 9.4204 | 2800.0 |
| 2010-06-02 07:40:00 | AAPL | Stock | 9.425 | 9.425 | 9.425 | 9.425 | 5600.0 |
| 2010-06-02 07:41:00 | AAPL | Stock | 9.4282 | 9.4286 | 9.4282 | 9.4286 | 28000.0 |
| 2010-06-02 07:42:00 | AAPL | Stock | 9.4286 | 9.4286 | 9.4279 | 9.4279 | 12824.0 |
| 2010-06-02 07:44:00 | AAPL | Stock | 9.4189 | 9.4189 | 9.4189 | 9.4189 | 7000.0 |
| 2010-06-02 07:45:00 | AAPL | Stock | 9.4186 | 9.4186 | 9.4132 | 9.4132 | 19600.0 |
| 2010-06-02 07:46:00 | AAPL | Stock | 9.4132 | 9.4264 | 9.4132 | 9.4264 | 16800.0 |
| 2010-06-02 07:48:00 | AAPL | Stock | 9.4157 | 9.4164 | 9.3971 | 9.3971 | 129080.0 |
| 2010-06-02 07:50:00 | AAPL | Stock | 9.3971 | 9.3996 | 9.3946 | 9.3946 | 11200.0 |
| 2010-06-02 07:51:00 | AAPL | Stock | 9.3964 | 9.4064 | 9.3964 | 9.4064 | 19600.0 |
| 2010-06-02 07:52:00 | AAPL | Stock | 9.4018 | 9.4018 | 9.4018 | 9.4018 | 2800.0 |
| 2010-06-02 07:53:00 | AAPL | Stock | 9.4018 | 9.4046 | 9.4018 | 9.4046 | 47824.0 |
| 2010-06-02 07:58:00 | AAPL | Stock | 9.4096 | 9.4143 | 9.4096 | 9.4143 | 5600.0 |
| 2010-06-02 07:59:00 | AAPL | Stock | 9.4143 | 9.4143 | 9.4071 | 9.4071 | 42700.0 |
> showing 50 of 1,020,116 rows — these rows as CSV