PREVIEW / stock_1min / 2010-09-09
file: by_date/stock_1min/2010/2010-09-09.parquet size: 11.9 MB rows: 895,329 symbols: 2,810
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-09-09 04:50:00 | AAPL | Stock | 9.3757 | 9.3757 | 9.3757 | 9.3757 | 4200.0 |
| 2010-09-09 05:20:00 | AAPL | Stock | 9.4046 | 9.405 | 9.4046 | 9.405 | 28000.0 |
| 2010-09-09 07:01:00 | AAPL | Stock | 9.4071 | 9.4071 | 9.4071 | 9.4071 | 19600.0 |
| 2010-09-09 07:02:00 | AAPL | Stock | 9.4111 | 9.4111 | 9.4111 | 9.4111 | 2800.0 |
| 2010-09-09 07:10:00 | AAPL | Stock | 9.4196 | 9.4196 | 9.4196 | 9.4196 | 5600.0 |
| 2010-09-09 07:11:00 | AAPL | Stock | 9.4196 | 9.4196 | 9.4196 | 9.4196 | 2800.0 |
| 2010-09-09 07:22:00 | AAPL | Stock | 9.41 | 9.41 | 9.41 | 9.41 | 2800.0 |
| 2010-09-09 07:26:00 | AAPL | Stock | 9.41 | 9.41 | 9.41 | 9.41 | 2800.0 |
| 2010-09-09 07:27:00 | AAPL | Stock | 9.41 | 9.41 | 9.41 | 9.41 | 22400.0 |
| 2010-09-09 07:32:00 | AAPL | Stock | 9.4171 | 9.4186 | 9.4171 | 9.4186 | 56000.0 |
| 2010-09-09 07:33:00 | AAPL | Stock | 9.4204 | 9.4204 | 9.4179 | 9.4179 | 8400.0 |
| 2010-09-09 07:34:00 | AAPL | Stock | 9.4179 | 9.4179 | 9.4179 | 9.4179 | 2800.0 |
| 2010-09-09 07:38:00 | AAPL | Stock | 9.4239 | 9.425 | 9.4239 | 9.425 | 23436.0 |
| 2010-09-09 07:39:00 | AAPL | Stock | 9.4114 | 9.4114 | 9.4111 | 9.4111 | 16800.0 |
| 2010-09-09 07:40:00 | AAPL | Stock | 9.4214 | 9.4214 | 9.4211 | 9.4211 | 8400.0 |
| 2010-09-09 07:45:00 | AAPL | Stock | 9.4182 | 9.4182 | 9.4182 | 9.4182 | 2800.0 |
| 2010-09-09 07:48:00 | AAPL | Stock | 9.4143 | 9.4143 | 9.4143 | 9.4143 | 2800.0 |
| 2010-09-09 07:50:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 5600.0 |
| 2010-09-09 07:51:00 | AAPL | Stock | 9.4143 | 9.4143 | 9.4143 | 9.4143 | 2800.0 |
| 2010-09-09 07:55:00 | AAPL | Stock | 9.4125 | 9.4125 | 9.4125 | 9.4125 | 2800.0 |
| 2010-09-09 08:00:00 | AAPL | Stock | 9.4139 | 9.4154 | 9.4057 | 9.4057 | 83720.0 |
| 2010-09-09 08:01:00 | AAPL | Stock | 9.4146 | 9.4146 | 9.4111 | 9.4111 | 8400.0 |
| 2010-09-09 08:02:00 | AAPL | Stock | 9.4107 | 9.4193 | 9.4107 | 9.4146 | 38360.0 |
| 2010-09-09 08:03:00 | AAPL | Stock | 9.4154 | 9.4154 | 9.4154 | 9.4154 | 2800.0 |
| 2010-09-09 08:04:00 | AAPL | Stock | 9.4175 | 9.4175 | 9.4125 | 9.4154 | 47600.0 |
| 2010-09-09 08:05:00 | AAPL | Stock | 9.4146 | 9.4175 | 9.4143 | 9.4154 | 19516.0 |
| 2010-09-09 08:06:00 | AAPL | Stock | 9.4114 | 9.4154 | 9.4111 | 9.4143 | 53648.0 |
| 2010-09-09 08:07:00 | AAPL | Stock | 9.4154 | 9.4154 | 9.4143 | 9.4143 | 18956.0 |
| 2010-09-09 08:08:00 | AAPL | Stock | 9.4132 | 9.4143 | 9.4132 | 9.4143 | 8680.0 |
| 2010-09-09 08:09:00 | AAPL | Stock | 9.4139 | 9.4143 | 9.4114 | 9.4114 | 16800.0 |
| 2010-09-09 08:10:00 | AAPL | Stock | 9.4114 | 9.4114 | 9.4107 | 9.4107 | 48300.0 |
| 2010-09-09 08:11:00 | AAPL | Stock | 9.4061 | 9.4125 | 9.4061 | 9.4125 | 151200.0 |
| 2010-09-09 08:12:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 21700.0 |
| 2010-09-09 08:14:00 | AAPL | Stock | 9.4054 | 9.4054 | 9.4036 | 9.4036 | 25200.0 |
| 2010-09-09 08:15:00 | AAPL | Stock | 9.4036 | 9.4036 | 9.4 | 9.4 | 28000.0 |
| 2010-09-09 08:17:00 | AAPL | Stock | 9.3982 | 9.3982 | 9.3982 | 9.3982 | 11200.0 |
| 2010-09-09 08:18:00 | AAPL | Stock | 9.3964 | 9.3964 | 9.3964 | 9.3964 | 22400.0 |
| 2010-09-09 08:19:00 | AAPL | Stock | 9.3982 | 9.4 | 9.3968 | 9.4 | 72800.0 |
| 2010-09-09 08:20:00 | AAPL | Stock | 9.4 | 9.4 | 9.4 | 9.4 | 2800.0 |
| 2010-09-09 08:21:00 | AAPL | Stock | 9.3982 | 9.4 | 9.3964 | 9.4 | 60760.0 |
| 2010-09-09 08:24:00 | AAPL | Stock | 9.4018 | 9.4018 | 9.4018 | 9.4018 | 8400.0 |
| 2010-09-09 08:25:00 | AAPL | Stock | 9.4018 | 9.4018 | 9.3964 | 9.3964 | 66500.0 |
| 2010-09-09 08:26:00 | AAPL | Stock | 9.3964 | 9.3964 | 9.395 | 9.3964 | 36400.0 |
| 2010-09-09 08:27:00 | AAPL | Stock | 9.3929 | 9.3964 | 9.3929 | 9.3964 | 22652.0 |
| 2010-09-09 08:28:00 | AAPL | Stock | 9.3964 | 9.3964 | 9.3964 | 9.3964 | 28840.0 |
| 2010-09-09 08:29:00 | AAPL | Stock | 9.3964 | 9.3964 | 9.3946 | 9.3964 | 22400.0 |
| 2010-09-09 08:30:00 | AAPL | Stock | 9.3964 | 9.4382 | 9.3964 | 9.4382 | 415380.0 |
| 2010-09-09 08:31:00 | AAPL | Stock | 9.4364 | 9.4604 | 9.4357 | 9.4489 | 315420.0 |
| 2010-09-09 08:32:00 | AAPL | Stock | 9.4514 | 9.4571 | 9.4393 | 9.4554 | 474460.0 |
| 2010-09-09 08:33:00 | AAPL | Stock | 9.4539 | 9.4629 | 9.4518 | 9.4629 | 212240.0 |
> showing 50 of 895,329 rows — these rows as CSV