PREVIEW / stock_1min / 2011-12-29
file: by_date/stock_1min/2011/2011-12-29.parquet size: 12.1 MB rows: 898,729 symbols: 2,888
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-29 06:48:00 | AAPL | Stock | 14.3707 | 14.3707 | 14.3707 | 14.3707 | 5600.0 |
| 2011-12-29 06:49:00 | AAPL | Stock | 14.3696 | 14.3696 | 14.3696 | 14.3696 | 11200.0 |
| 2011-12-29 06:55:00 | AAPL | Stock | 14.3696 | 14.3696 | 14.3696 | 14.3696 | 5600.0 |
| 2011-12-29 06:56:00 | AAPL | Stock | 14.375 | 14.375 | 14.375 | 14.375 | 12600.0 |
| 2011-12-29 07:00:00 | AAPL | Stock | 14.3821 | 14.3821 | 14.3821 | 14.3821 | 8400.0 |
| 2011-12-29 07:01:00 | AAPL | Stock | 14.3857 | 14.3857 | 14.3857 | 14.3857 | 5600.0 |
| 2011-12-29 07:03:00 | AAPL | Stock | 14.3893 | 14.3893 | 14.3893 | 14.3893 | 25200.0 |
| 2011-12-29 07:10:00 | AAPL | Stock | 14.3954 | 14.4018 | 14.3954 | 14.4018 | 23492.0 |
| 2011-12-29 07:12:00 | AAPL | Stock | 14.4007 | 14.4007 | 14.3979 | 14.3986 | 8400.0 |
| 2011-12-29 07:14:00 | AAPL | Stock | 14.3982 | 14.3982 | 14.3929 | 14.3954 | 28000.0 |
| 2011-12-29 07:17:00 | AAPL | Stock | 14.3954 | 14.3954 | 14.3954 | 14.3954 | 2800.0 |
| 2011-12-29 07:21:00 | AAPL | Stock | 14.4 | 14.4 | 14.4 | 14.4 | 6300.0 |
| 2011-12-29 07:26:00 | AAPL | Stock | 14.4036 | 14.4039 | 14.4036 | 14.4039 | 8400.0 |
| 2011-12-29 07:31:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4107 | 14.4107 | 2800.0 |
| 2011-12-29 07:34:00 | AAPL | Stock | 14.42 | 14.42 | 14.42 | 14.42 | 5600.0 |
| 2011-12-29 07:36:00 | AAPL | Stock | 14.4196 | 14.4196 | 14.4196 | 14.4196 | 5600.0 |
| 2011-12-29 07:38:00 | AAPL | Stock | 14.4346 | 14.4346 | 14.4346 | 14.4346 | 3360.0 |
| 2011-12-29 07:39:00 | AAPL | Stock | 14.4314 | 14.4343 | 14.4314 | 14.4343 | 14000.0 |
| 2011-12-29 07:40:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 14000.0 |
| 2011-12-29 07:42:00 | AAPL | Stock | 14.4286 | 14.4293 | 14.4286 | 14.4293 | 5600.0 |
| 2011-12-29 07:46:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 13860.0 |
| 2011-12-29 07:50:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 2800.0 |
| 2011-12-29 07:53:00 | AAPL | Stock | 14.4254 | 14.4254 | 14.425 | 14.425 | 5600.0 |
| 2011-12-29 07:55:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 2800.0 |
| 2011-12-29 07:57:00 | AAPL | Stock | 14.4282 | 14.4282 | 14.4282 | 14.4282 | 5600.0 |
| 2011-12-29 08:00:00 | AAPL | Stock | 14.4125 | 14.4243 | 14.4125 | 14.4243 | 40432.0 |
| 2011-12-29 08:01:00 | AAPL | Stock | 14.4243 | 14.4243 | 14.4243 | 14.4243 | 2800.0 |
| 2011-12-29 08:02:00 | AAPL | Stock | 14.4282 | 14.4282 | 14.4264 | 14.4264 | 7000.0 |
| 2011-12-29 08:03:00 | AAPL | Stock | 14.4304 | 14.4307 | 14.4304 | 14.4307 | 5600.0 |
| 2011-12-29 08:04:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.425 | 14.425 | 14000.0 |
| 2011-12-29 08:05:00 | AAPL | Stock | 14.4286 | 14.4321 | 14.4282 | 14.4321 | 33600.0 |
| 2011-12-29 08:06:00 | AAPL | Stock | 14.4321 | 14.4375 | 14.4321 | 14.4375 | 24920.0 |
| 2011-12-29 08:08:00 | AAPL | Stock | 14.4393 | 14.4393 | 14.4393 | 14.4393 | 8400.0 |
| 2011-12-29 08:09:00 | AAPL | Stock | 14.4454 | 14.4454 | 14.4454 | 14.4454 | 2800.0 |
| 2011-12-29 08:10:00 | AAPL | Stock | 14.445 | 14.4454 | 14.4407 | 14.4407 | 16940.0 |
| 2011-12-29 08:11:00 | AAPL | Stock | 14.4357 | 14.4357 | 14.4357 | 14.4357 | 5600.0 |
| 2011-12-29 08:13:00 | AAPL | Stock | 14.4393 | 14.4454 | 14.4357 | 14.4454 | 43680.0 |
| 2011-12-29 08:14:00 | AAPL | Stock | 14.4396 | 14.4464 | 14.4396 | 14.4446 | 26040.0 |
| 2011-12-29 08:16:00 | AAPL | Stock | 14.4375 | 14.4446 | 14.4375 | 14.4446 | 54992.0 |
| 2011-12-29 08:18:00 | AAPL | Stock | 14.4439 | 14.4464 | 14.4439 | 14.4439 | 67340.0 |
| 2011-12-29 08:19:00 | AAPL | Stock | 14.4457 | 14.4457 | 14.4457 | 14.4457 | 2800.0 |
| 2011-12-29 08:20:00 | AAPL | Stock | 14.4457 | 14.4464 | 14.4357 | 14.4357 | 89796.0 |
| 2011-12-29 08:21:00 | AAPL | Stock | 14.4443 | 14.4443 | 14.4443 | 14.4443 | 5600.0 |
| 2011-12-29 08:22:00 | AAPL | Stock | 14.4375 | 14.4421 | 14.4375 | 14.4421 | 19264.0 |
| 2011-12-29 08:23:00 | AAPL | Stock | 14.4321 | 14.4321 | 14.4321 | 14.4321 | 26572.0 |
| 2011-12-29 08:25:00 | AAPL | Stock | 14.4321 | 14.4321 | 14.4321 | 14.4321 | 53200.0 |
| 2011-12-29 08:27:00 | AAPL | Stock | 14.4375 | 14.4429 | 14.4375 | 14.4429 | 12012.0 |
| 2011-12-29 08:29:00 | AAPL | Stock | 14.4429 | 14.4429 | 14.4429 | 14.4429 | 5600.0 |
| 2011-12-29 08:30:00 | AAPL | Stock | 14.4289 | 14.4289 | 14.4286 | 14.4286 | 7868.0 |
| 2011-12-29 08:33:00 | AAPL | Stock | 14.4161 | 14.4161 | 14.415 | 14.415 | 5600.0 |
> showing 50 of 898,729 rows — these rows as CSV