PREVIEW / stock_1min / 2010-01-22
file: by_date/stock_1min/2010/2010-01-22.parquet size: 13.4 MB rows: 998,959 symbols: 2,809
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-01-22 04:26:00 | AAPL | Stock | 7.4554 | 7.4554 | 7.4554 | 7.4554 | 2800.0 |
| 2010-01-22 05:39:00 | AAPL | Stock | 7.4389 | 7.4389 | 7.4389 | 7.4389 | 2800.0 |
| 2010-01-22 05:50:00 | AAPL | Stock | 7.4311 | 7.4311 | 7.4311 | 7.4311 | 2800.0 |
| 2010-01-22 06:27:00 | AAPL | Stock | 7.4264 | 7.4264 | 7.4264 | 7.4264 | 5600.0 |
| 2010-01-22 06:42:00 | AAPL | Stock | 7.4143 | 7.4143 | 7.4143 | 7.4143 | 16800.0 |
| 2010-01-22 06:49:00 | AAPL | Stock | 7.4229 | 7.4229 | 7.4057 | 7.4057 | 5600.0 |
| 2010-01-22 06:50:00 | AAPL | Stock | 7.4054 | 7.4054 | 7.4054 | 7.4054 | 2800.0 |
| 2010-01-22 06:51:00 | AAPL | Stock | 7.4021 | 7.4021 | 7.4021 | 7.4021 | 11648.0 |
| 2010-01-22 07:00:00 | AAPL | Stock | 7.395 | 7.395 | 7.395 | 7.395 | 4732.0 |
| 2010-01-22 07:07:00 | AAPL | Stock | 7.3982 | 7.3982 | 7.3939 | 7.3939 | 5600.0 |
| 2010-01-22 07:12:00 | AAPL | Stock | 7.3968 | 7.3968 | 7.3968 | 7.3968 | 11200.0 |
| 2010-01-22 07:16:00 | AAPL | Stock | 7.3964 | 7.3964 | 7.3929 | 7.3929 | 5600.0 |
| 2010-01-22 07:18:00 | AAPL | Stock | 7.3925 | 7.3925 | 7.3911 | 7.3911 | 5600.0 |
| 2010-01-22 07:19:00 | AAPL | Stock | 7.3943 | 7.3943 | 7.3943 | 7.3943 | 5600.0 |
| 2010-01-22 07:25:00 | AAPL | Stock | 7.39 | 7.4018 | 7.39 | 7.4018 | 8568.0 |
| 2010-01-22 07:29:00 | AAPL | Stock | 7.3911 | 7.3911 | 7.3911 | 7.3911 | 2800.0 |
| 2010-01-22 07:32:00 | AAPL | Stock | 7.4018 | 7.4018 | 7.4018 | 7.4018 | 5600.0 |
| 2010-01-22 07:47:00 | AAPL | Stock | 7.4007 | 7.4018 | 7.4007 | 7.4018 | 5600.0 |
| 2010-01-22 07:48:00 | AAPL | Stock | 7.4029 | 7.4032 | 7.4029 | 7.4032 | 5600.0 |
| 2010-01-22 07:49:00 | AAPL | Stock | 7.4089 | 7.41 | 7.3932 | 7.3932 | 25200.0 |
| 2010-01-22 08:00:00 | AAPL | Stock | 7.4232 | 7.4254 | 7.4107 | 7.4107 | 25844.0 |
| 2010-01-22 08:01:00 | AAPL | Stock | 7.4107 | 7.4107 | 7.4107 | 7.4107 | 19600.0 |
| 2010-01-22 08:02:00 | AAPL | Stock | 7.4114 | 7.4254 | 7.4114 | 7.4254 | 46200.0 |
| 2010-01-22 08:03:00 | AAPL | Stock | 7.4229 | 7.4229 | 7.4116 | 7.4116 | 14280.0 |
| 2010-01-22 08:04:00 | AAPL | Stock | 7.4125 | 7.4125 | 7.4116 | 7.4116 | 11200.0 |
| 2010-01-22 08:05:00 | AAPL | Stock | 7.4179 | 7.4211 | 7.4107 | 7.4111 | 15792.0 |
| 2010-01-22 08:06:00 | AAPL | Stock | 7.4107 | 7.4107 | 7.4107 | 7.4107 | 8400.0 |
| 2010-01-22 08:07:00 | AAPL | Stock | 7.4125 | 7.4189 | 7.4107 | 7.4189 | 28000.0 |
| 2010-01-22 08:08:00 | AAPL | Stock | 7.4114 | 7.4121 | 7.4107 | 7.4107 | 33600.0 |
| 2010-01-22 08:09:00 | AAPL | Stock | 7.4093 | 7.4111 | 7.4079 | 7.4111 | 25200.0 |
| 2010-01-22 08:10:00 | AAPL | Stock | 7.4125 | 7.4125 | 7.4107 | 7.4125 | 29904.0 |
| 2010-01-22 08:11:00 | AAPL | Stock | 7.4114 | 7.4114 | 7.4079 | 7.4079 | 16884.0 |
| 2010-01-22 08:13:00 | AAPL | Stock | 7.4107 | 7.4107 | 7.4071 | 7.4071 | 8400.0 |
| 2010-01-22 08:14:00 | AAPL | Stock | 7.4107 | 7.4107 | 7.4107 | 7.4107 | 2800.0 |
| 2010-01-22 08:15:00 | AAPL | Stock | 7.4071 | 7.4071 | 7.4071 | 7.4071 | 8092.0 |
| 2010-01-22 08:17:00 | AAPL | Stock | 7.4054 | 7.4054 | 7.4054 | 7.4054 | 4200.0 |
| 2010-01-22 08:19:00 | AAPL | Stock | 7.4071 | 7.4071 | 7.4071 | 7.4071 | 16632.0 |
| 2010-01-22 08:21:00 | AAPL | Stock | 7.4107 | 7.4107 | 7.4071 | 7.4071 | 59976.0 |
| 2010-01-22 08:22:00 | AAPL | Stock | 7.4075 | 7.4096 | 7.4054 | 7.4096 | 27664.0 |
| 2010-01-22 08:23:00 | AAPL | Stock | 7.4125 | 7.4136 | 7.4125 | 7.4136 | 32004.0 |
| 2010-01-22 08:24:00 | AAPL | Stock | 7.4136 | 7.4136 | 7.4136 | 7.4136 | 5600.0 |
| 2010-01-22 08:25:00 | AAPL | Stock | 7.4136 | 7.4179 | 7.4132 | 7.4179 | 180404.0 |
| 2010-01-22 08:26:00 | AAPL | Stock | 7.4175 | 7.4214 | 7.4175 | 7.4186 | 78400.0 |
| 2010-01-22 08:27:00 | AAPL | Stock | 7.4214 | 7.4254 | 7.4214 | 7.4254 | 148596.0 |
| 2010-01-22 08:28:00 | AAPL | Stock | 7.4254 | 7.4254 | 7.42 | 7.4254 | 114436.0 |
| 2010-01-22 08:29:00 | AAPL | Stock | 7.4229 | 7.4282 | 7.4211 | 7.4261 | 28000.0 |
| 2010-01-22 08:31:00 | AAPL | Stock | 7.4246 | 7.425 | 7.4243 | 7.425 | 76832.0 |
| 2010-01-22 08:32:00 | AAPL | Stock | 7.4282 | 7.4321 | 7.4279 | 7.4321 | 22400.0 |
| 2010-01-22 08:33:00 | AAPL | Stock | 7.4321 | 7.4343 | 7.4321 | 7.4343 | 25200.0 |
| 2010-01-22 08:34:00 | AAPL | Stock | 7.435 | 7.435 | 7.4282 | 7.4282 | 55804.0 |
> showing 50 of 998,959 rows — these rows as CSV