PREVIEW / stock_5min / 2013-10-03
file: by_date/stock_5min/2013/2013-10-03.parquet size: 5.2 MB rows: 344,019 symbols: 3,519
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-10-03 04:00:00 | AAPL | Stock | 17.3982 | 17.3982 | 17.3982 | 17.3982 | 8400.0 |
| 2013-10-03 04:05:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.4107 | 17.4107 | 5600.0 |
| 2013-10-03 05:30:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4286 | 17.4286 | 5600.0 |
| 2013-10-03 05:40:00 | AAPL | Stock | 17.4186 | 17.4186 | 17.4107 | 17.4107 | 6160.0 |
| 2013-10-03 05:50:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.4107 | 17.4107 | 5600.0 |
| 2013-10-03 05:55:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.4107 | 17.4107 | 3360.0 |
| 2013-10-03 06:00:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.4107 | 17.4107 | 5040.0 |
| 2013-10-03 06:45:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4286 | 17.4286 | 5600.0 |
| 2013-10-03 06:50:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4286 | 17.4286 | 2800.0 |
| 2013-10-03 06:55:00 | AAPL | Stock | 17.4354 | 17.4354 | 17.4354 | 17.4354 | 2800.0 |
| 2013-10-03 07:10:00 | AAPL | Stock | 17.4561 | 17.4561 | 17.4339 | 17.4339 | 36400.0 |
| 2013-10-03 07:15:00 | AAPL | Stock | 17.45 | 17.4586 | 17.45 | 17.4586 | 8400.0 |
| 2013-10-03 07:20:00 | AAPL | Stock | 17.4382 | 17.4396 | 17.4382 | 17.4396 | 5600.0 |
| 2013-10-03 07:25:00 | AAPL | Stock | 17.4464 | 17.4571 | 17.4464 | 17.4571 | 14420.0 |
| 2013-10-03 07:30:00 | AAPL | Stock | 17.4571 | 17.4643 | 17.4571 | 17.4643 | 25200.0 |
| 2013-10-03 07:35:00 | AAPL | Stock | 17.4571 | 17.4589 | 17.4571 | 17.4589 | 25900.0 |
| 2013-10-03 07:45:00 | AAPL | Stock | 17.4679 | 17.4732 | 17.4679 | 17.4732 | 35028.0 |
| 2013-10-03 07:50:00 | AAPL | Stock | 17.4814 | 17.4939 | 17.4814 | 17.4939 | 44800.0 |
| 2013-10-03 07:55:00 | AAPL | Stock | 17.4982 | 17.5118 | 17.4975 | 17.5 | 58100.0 |
| 2013-10-03 08:00:00 | AAPL | Stock | 17.4964 | 17.5214 | 17.4354 | 17.5214 | 268688.0 |
| 2013-10-03 08:05:00 | AAPL | Stock | 17.5268 | 17.5339 | 17.5161 | 17.5282 | 125832.0 |
| 2013-10-03 08:10:00 | AAPL | Stock | 17.5179 | 17.5229 | 17.5 | 17.5025 | 156380.0 |
| 2013-10-03 08:15:00 | AAPL | Stock | 17.4911 | 17.4911 | 17.4857 | 17.4893 | 21700.0 |
| 2013-10-03 08:20:00 | AAPL | Stock | 17.4993 | 17.5125 | 17.4975 | 17.5125 | 33600.0 |
| 2013-10-03 08:25:00 | AAPL | Stock | 17.5054 | 17.5089 | 17.5 | 17.5089 | 70000.0 |
| 2013-10-03 08:30:00 | AAPL | Stock | 17.5054 | 17.5054 | 17.4968 | 17.4968 | 55804.0 |
| 2013-10-03 08:35:00 | AAPL | Stock | 17.4968 | 17.5107 | 17.4968 | 17.5075 | 65520.0 |
| 2013-10-03 08:40:00 | AAPL | Stock | 17.5089 | 17.5107 | 17.5018 | 17.5018 | 50400.0 |
| 2013-10-03 08:45:00 | AAPL | Stock | 17.4982 | 17.5136 | 17.4982 | 17.5136 | 89684.0 |
| 2013-10-03 08:50:00 | AAPL | Stock | 17.5143 | 17.5314 | 17.5071 | 17.5246 | 200200.0 |
| 2013-10-03 08:55:00 | AAPL | Stock | 17.5246 | 17.5314 | 17.5214 | 17.525 | 41020.0 |
| 2013-10-03 09:00:00 | AAPL | Stock | 17.5196 | 17.5246 | 17.5104 | 17.5246 | 50540.0 |
| 2013-10-03 09:05:00 | AAPL | Stock | 17.525 | 17.5304 | 17.5221 | 17.5221 | 28000.0 |
| 2013-10-03 09:10:00 | AAPL | Stock | 17.5232 | 17.5264 | 17.5168 | 17.5264 | 130200.0 |
| 2013-10-03 09:15:00 | AAPL | Stock | 17.5314 | 17.5532 | 17.5314 | 17.5429 | 353052.0 |
| 2013-10-03 09:20:00 | AAPL | Stock | 17.5518 | 17.5518 | 17.5357 | 17.5357 | 349076.0 |
| 2013-10-03 09:25:00 | AAPL | Stock | 17.5271 | 17.5286 | 17.5007 | 17.5179 | 307244.0 |
| 2013-10-03 09:30:00 | AAPL | Stock | 17.5182 | 17.5536 | 17.4896 | 17.5371 | 10953068.0 |
| 2013-10-03 09:35:00 | AAPL | Stock | 17.5368 | 17.5839 | 17.4521 | 17.4861 | 14381472.0 |
| 2013-10-03 09:40:00 | AAPL | Stock | 17.4821 | 17.5114 | 17.4589 | 17.5004 | 4540200.0 |
| 2013-10-03 09:45:00 | AAPL | Stock | 17.5007 | 17.5007 | 17.45 | 17.4625 | 4672136.0 |
| 2013-10-03 09:50:00 | AAPL | Stock | 17.4596 | 17.4621 | 17.4146 | 17.4404 | 6302688.0 |
| 2013-10-03 09:55:00 | AAPL | Stock | 17.4411 | 17.4536 | 17.4289 | 17.4289 | 3130708.0 |
| 2013-10-03 10:00:00 | AAPL | Stock | 17.43 | 17.43 | 17.3829 | 17.4046 | 6528536.0 |
| 2013-10-03 10:05:00 | AAPL | Stock | 17.4014 | 17.4204 | 17.3875 | 17.4007 | 5254172.0 |
| 2013-10-03 10:10:00 | AAPL | Stock | 17.3989 | 17.4149 | 17.3857 | 17.4086 | 4241244.0 |
| 2013-10-03 10:15:00 | AAPL | Stock | 17.4082 | 17.4141 | 17.3432 | 17.3568 | 8045968.0 |
| 2013-10-03 10:20:00 | AAPL | Stock | 17.3546 | 17.3589 | 17.2986 | 17.2986 | 10271296.0 |
| 2013-10-03 10:25:00 | AAPL | Stock | 17.2986 | 17.3343 | 17.2911 | 17.3184 | 5626376.0 |
| 2013-10-03 10:30:00 | AAPL | Stock | 17.3136 | 17.3454 | 17.3071 | 17.3446 | 4434248.0 |
> showing 50 of 344,019 rows — these rows as CSV