PREVIEW / stock_1min / 2009-05-18
file: by_date/stock_1min/2009/2009-05-18.parquet size: 12.5 MB rows: 956,994 symbols: 2,702
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-18 08:00:00 | AAPL | Stock | 4.3929 | 4.3929 | 4.39 | 4.39 | 10500.0 |
| 2009-05-18 08:01:00 | AAPL | Stock | 4.39 | 4.3929 | 4.39 | 4.3929 | 35700.0 |
| 2009-05-18 08:02:00 | AAPL | Stock | 4.3929 | 4.3929 | 4.3929 | 4.3929 | 62020.0 |
| 2009-05-18 08:03:00 | AAPL | Stock | 4.3929 | 4.3929 | 4.3929 | 4.3929 | 8400.0 |
| 2009-05-18 08:05:00 | AAPL | Stock | 4.3946 | 4.3946 | 4.3946 | 4.3946 | 14000.0 |
| 2009-05-18 08:06:00 | AAPL | Stock | 4.4 | 4.4 | 4.4 | 4.4 | 24892.0 |
| 2009-05-18 08:07:00 | AAPL | Stock | 4.4036 | 4.4036 | 4.4036 | 4.4036 | 2800.0 |
| 2009-05-18 08:08:00 | AAPL | Stock | 4.41 | 4.41 | 4.41 | 4.41 | 2800.0 |
| 2009-05-18 08:10:00 | AAPL | Stock | 4.41 | 4.41 | 4.41 | 4.41 | 5488.0 |
| 2009-05-18 08:11:00 | AAPL | Stock | 4.4111 | 4.4111 | 4.4111 | 4.4111 | 2800.0 |
| 2009-05-18 08:12:00 | AAPL | Stock | 4.41 | 4.4107 | 4.41 | 4.4107 | 18592.0 |
| 2009-05-18 08:13:00 | AAPL | Stock | 4.4107 | 4.4107 | 4.4107 | 4.4107 | 2800.0 |
| 2009-05-18 08:14:00 | AAPL | Stock | 4.4107 | 4.4107 | 4.4107 | 4.4107 | 78568.0 |
| 2009-05-18 08:15:00 | AAPL | Stock | 4.4107 | 4.4107 | 4.4107 | 4.4107 | 18200.0 |
| 2009-05-18 08:16:00 | AAPL | Stock | 4.4107 | 4.4125 | 4.4107 | 4.4125 | 19600.0 |
| 2009-05-18 08:17:00 | AAPL | Stock | 4.4129 | 4.4143 | 4.4107 | 4.4107 | 35000.0 |
| 2009-05-18 08:18:00 | AAPL | Stock | 4.4139 | 4.4139 | 4.4139 | 4.4139 | 4200.0 |
| 2009-05-18 08:19:00 | AAPL | Stock | 4.4139 | 4.4139 | 4.4139 | 4.4139 | 15400.0 |
| 2009-05-18 08:20:00 | AAPL | Stock | 4.4139 | 4.4139 | 4.4139 | 4.4139 | 7000.0 |
| 2009-05-18 08:21:00 | AAPL | Stock | 4.4139 | 4.4139 | 4.4139 | 4.4139 | 4200.0 |
| 2009-05-18 08:22:00 | AAPL | Stock | 4.4143 | 4.4143 | 4.4125 | 4.4129 | 65100.0 |
| 2009-05-18 08:23:00 | AAPL | Stock | 4.4232 | 4.4232 | 4.4232 | 4.4232 | 3500.0 |
| 2009-05-18 08:25:00 | AAPL | Stock | 4.4193 | 4.4214 | 4.4193 | 4.4214 | 24640.0 |
| 2009-05-18 08:26:00 | AAPL | Stock | 4.4204 | 4.4214 | 4.4204 | 4.4214 | 105280.0 |
| 2009-05-18 08:27:00 | AAPL | Stock | 4.42 | 4.4214 | 4.4136 | 4.4136 | 96292.0 |
| 2009-05-18 08:29:00 | AAPL | Stock | 4.4207 | 4.4207 | 4.4207 | 4.4207 | 2800.0 |
| 2009-05-18 08:32:00 | AAPL | Stock | 4.4121 | 4.4121 | 4.4107 | 4.4107 | 55412.0 |
| 2009-05-18 08:34:00 | AAPL | Stock | 4.4139 | 4.4143 | 4.4139 | 4.4143 | 16240.0 |
| 2009-05-18 08:35:00 | AAPL | Stock | 4.4207 | 4.4211 | 4.4207 | 4.4211 | 43008.0 |
| 2009-05-18 08:37:00 | AAPL | Stock | 4.4211 | 4.4214 | 4.4211 | 4.4214 | 16800.0 |
| 2009-05-18 08:43:00 | AAPL | Stock | 4.4179 | 4.4196 | 4.4179 | 4.4196 | 22400.0 |
| 2009-05-18 08:45:00 | AAPL | Stock | 4.4196 | 4.4196 | 4.4196 | 4.4196 | 2800.0 |
| 2009-05-18 08:46:00 | AAPL | Stock | 4.4196 | 4.4196 | 4.4146 | 4.4146 | 10080.0 |
| 2009-05-18 08:48:00 | AAPL | Stock | 4.415 | 4.4157 | 4.415 | 4.4154 | 30100.0 |
| 2009-05-18 08:52:00 | AAPL | Stock | 4.4193 | 4.4193 | 4.4193 | 4.4193 | 2800.0 |
| 2009-05-18 08:53:00 | AAPL | Stock | 4.4196 | 4.4196 | 4.4196 | 4.4196 | 2800.0 |
| 2009-05-18 08:54:00 | AAPL | Stock | 4.4193 | 4.4193 | 4.4193 | 4.4193 | 5600.0 |
| 2009-05-18 08:58:00 | AAPL | Stock | 4.4196 | 4.4196 | 4.4196 | 4.4196 | 2800.0 |
| 2009-05-18 08:59:00 | AAPL | Stock | 4.4189 | 4.4189 | 4.4189 | 4.4189 | 14000.0 |
| 2009-05-18 09:03:00 | AAPL | Stock | 4.4186 | 4.4189 | 4.4186 | 4.4189 | 18200.0 |
| 2009-05-18 09:04:00 | AAPL | Stock | 4.4196 | 4.4196 | 4.4196 | 4.4196 | 14000.0 |
| 2009-05-18 09:05:00 | AAPL | Stock | 4.4211 | 4.4211 | 4.4211 | 4.4211 | 8092.0 |
| 2009-05-18 09:06:00 | AAPL | Stock | 4.4211 | 4.4232 | 4.4211 | 4.4232 | 17108.0 |
| 2009-05-18 09:07:00 | AAPL | Stock | 4.4232 | 4.4246 | 4.4232 | 4.4246 | 53900.0 |
| 2009-05-18 09:08:00 | AAPL | Stock | 4.4257 | 4.4268 | 4.4257 | 4.4268 | 6300.0 |
| 2009-05-18 09:09:00 | AAPL | Stock | 4.4268 | 4.4268 | 4.4268 | 4.4268 | 2800.0 |
| 2009-05-18 09:10:00 | AAPL | Stock | 4.4271 | 4.4271 | 4.4271 | 4.4271 | 23744.0 |
| 2009-05-18 09:11:00 | AAPL | Stock | 4.4282 | 4.4282 | 4.4271 | 4.4271 | 25760.0 |
| 2009-05-18 09:12:00 | AAPL | Stock | 4.4271 | 4.4271 | 4.425 | 4.425 | 44492.0 |
| 2009-05-18 09:13:00 | AAPL | Stock | 4.4254 | 4.4282 | 4.425 | 4.4268 | 16800.0 |
> showing 50 of 956,994 rows — these rows as CSV