PREVIEW / stock_1min / 2013-04-12
file: by_date/stock_1min/2013/2013-04-12.parquet size: 12.7 MB rows: 931,974 symbols: 2,828
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 |
|---|---|---|---|---|---|---|---|
| 2013-04-12 04:35:00 | AAPL | Stock | 15.4821 | 15.4821 | 15.4821 | 15.4821 | 2800.0 |
| 2013-04-12 06:53:00 | AAPL | Stock | 15.4579 | 15.4579 | 15.4579 | 15.4579 | 11200.0 |
| 2013-04-12 07:10:00 | AAPL | Stock | 15.4568 | 15.4568 | 15.4568 | 15.4568 | 2800.0 |
| 2013-04-12 07:23:00 | AAPL | Stock | 15.4143 | 15.4143 | 15.4107 | 15.4143 | 14000.0 |
| 2013-04-12 07:37:00 | AAPL | Stock | 15.4154 | 15.4154 | 15.4154 | 15.4154 | 5600.0 |
| 2013-04-12 07:46:00 | AAPL | Stock | 15.4282 | 15.4282 | 15.4282 | 15.4282 | 2800.0 |
| 2013-04-12 07:52:00 | AAPL | Stock | 15.4379 | 15.4393 | 15.4379 | 15.4393 | 5600.0 |
| 2013-04-12 07:53:00 | AAPL | Stock | 15.4393 | 15.4607 | 15.4393 | 15.4607 | 25004.0 |
| 2013-04-12 07:59:00 | AAPL | Stock | 15.4464 | 15.4464 | 15.4464 | 15.4464 | 2800.0 |
| 2013-04-12 08:00:00 | AAPL | Stock | 15.4421 | 15.5143 | 15.4286 | 15.4339 | 39816.0 |
| 2013-04-12 08:02:00 | AAPL | Stock | 15.4414 | 15.4414 | 15.4414 | 15.4414 | 2800.0 |
| 2013-04-12 08:07:00 | AAPL | Stock | 15.4286 | 15.4286 | 15.4286 | 15.4286 | 22400.0 |
| 2013-04-12 08:08:00 | AAPL | Stock | 15.4479 | 15.4479 | 15.4464 | 15.4464 | 12040.0 |
| 2013-04-12 08:11:00 | AAPL | Stock | 15.4571 | 15.4571 | 15.4464 | 15.4464 | 7700.0 |
| 2013-04-12 08:12:00 | AAPL | Stock | 15.4411 | 15.4411 | 15.4404 | 15.4411 | 19600.0 |
| 2013-04-12 08:13:00 | AAPL | Stock | 15.4414 | 15.4436 | 15.4414 | 15.4436 | 7000.0 |
| 2013-04-12 08:14:00 | AAPL | Stock | 15.4368 | 15.4368 | 15.4357 | 15.4357 | 25200.0 |
| 2013-04-12 08:16:00 | AAPL | Stock | 15.4368 | 15.4368 | 15.4368 | 15.4368 | 2800.0 |
| 2013-04-12 08:17:00 | AAPL | Stock | 15.4425 | 15.4425 | 15.4425 | 15.4425 | 4312.0 |
| 2013-04-12 08:20:00 | AAPL | Stock | 15.4339 | 15.4339 | 15.4336 | 15.4339 | 8400.0 |
| 2013-04-12 08:22:00 | AAPL | Stock | 15.4339 | 15.4339 | 15.4339 | 15.4339 | 2800.0 |
| 2013-04-12 08:23:00 | AAPL | Stock | 15.4357 | 15.4357 | 15.4289 | 15.4307 | 24920.0 |
| 2013-04-12 08:24:00 | AAPL | Stock | 15.4321 | 15.4339 | 15.4321 | 15.4339 | 16800.0 |
| 2013-04-12 08:26:00 | AAPL | Stock | 15.4314 | 15.4314 | 15.4311 | 15.4311 | 30800.0 |
| 2013-04-12 08:27:00 | AAPL | Stock | 15.435 | 15.4389 | 15.4304 | 15.4311 | 22120.0 |
| 2013-04-12 08:28:00 | AAPL | Stock | 15.4304 | 15.4393 | 15.4304 | 15.4393 | 5600.0 |
| 2013-04-12 08:30:00 | AAPL | Stock | 15.4311 | 15.4314 | 15.4296 | 15.4296 | 31360.0 |
| 2013-04-12 08:31:00 | AAPL | Stock | 15.4293 | 15.4293 | 15.4196 | 15.4286 | 88116.0 |
| 2013-04-12 08:32:00 | AAPL | Stock | 15.4289 | 15.4289 | 15.4207 | 15.4257 | 68740.0 |
| 2013-04-12 08:33:00 | AAPL | Stock | 15.4218 | 15.4225 | 15.4121 | 15.4121 | 139580.0 |
| 2013-04-12 08:34:00 | AAPL | Stock | 15.4125 | 15.4282 | 15.4125 | 15.4146 | 110040.0 |
| 2013-04-12 08:35:00 | AAPL | Stock | 15.415 | 15.4179 | 15.4093 | 15.4093 | 181020.0 |
| 2013-04-12 08:36:00 | AAPL | Stock | 15.415 | 15.415 | 15.4107 | 15.4114 | 25200.0 |
| 2013-04-12 08:37:00 | AAPL | Stock | 15.4143 | 15.4193 | 15.3929 | 15.3929 | 129220.0 |
| 2013-04-12 08:38:00 | AAPL | Stock | 15.3946 | 15.4025 | 15.3929 | 15.4025 | 17892.0 |
| 2013-04-12 08:39:00 | AAPL | Stock | 15.4036 | 15.4107 | 15.3964 | 15.3964 | 172508.0 |
| 2013-04-12 08:40:00 | AAPL | Stock | 15.3932 | 15.3932 | 15.3793 | 15.3793 | 101724.0 |
| 2013-04-12 08:41:00 | AAPL | Stock | 15.3907 | 15.3914 | 15.3793 | 15.3825 | 91504.0 |
| 2013-04-12 08:42:00 | AAPL | Stock | 15.3904 | 15.3921 | 15.3904 | 15.3921 | 15624.0 |
| 2013-04-12 08:43:00 | AAPL | Stock | 15.3864 | 15.3968 | 15.3861 | 15.3943 | 138320.0 |
| 2013-04-12 08:44:00 | AAPL | Stock | 15.3939 | 15.3939 | 15.3893 | 15.3893 | 67200.0 |
| 2013-04-12 08:45:00 | AAPL | Stock | 15.3893 | 15.3932 | 15.3893 | 15.3932 | 34300.0 |
| 2013-04-12 08:46:00 | AAPL | Stock | 15.3943 | 15.4 | 15.3943 | 15.4 | 11200.0 |
| 2013-04-12 08:47:00 | AAPL | Stock | 15.4018 | 15.4064 | 15.3964 | 15.3964 | 22400.0 |
| 2013-04-12 08:49:00 | AAPL | Stock | 15.4068 | 15.4193 | 15.4068 | 15.4189 | 40292.0 |
| 2013-04-12 08:50:00 | AAPL | Stock | 15.4121 | 15.4196 | 15.4089 | 15.4089 | 44800.0 |
| 2013-04-12 08:52:00 | AAPL | Stock | 15.4129 | 15.4129 | 15.4096 | 15.4125 | 72800.0 |
| 2013-04-12 08:53:00 | AAPL | Stock | 15.4125 | 15.4179 | 15.4125 | 15.4168 | 25200.0 |
| 2013-04-12 08:54:00 | AAPL | Stock | 15.4146 | 15.4146 | 15.4096 | 15.4096 | 42000.0 |
| 2013-04-12 08:55:00 | AAPL | Stock | 15.4136 | 15.4143 | 15.4136 | 15.4143 | 7000.0 |
> showing 50 of 931,974 rows — these rows as CSV