PREVIEW / stock_1min / 2013-10-10
file: by_date/stock_1min/2013/2013-10-10.parquet size: 13.9 MB rows: 1,017,954 symbols: 2,867
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-10 04:08:00 | AAPL | Stock | 17.4707 | 17.4707 | 17.4707 | 17.4707 | 3416.0 |
| 2013-10-10 04:14:00 | AAPL | Stock | 17.5064 | 17.5064 | 17.5064 | 17.5064 | 2800.0 |
| 2013-10-10 04:55:00 | AAPL | Stock | 17.5004 | 17.5011 | 17.5004 | 17.5011 | 12600.0 |
| 2013-10-10 04:57:00 | AAPL | Stock | 17.5011 | 17.5011 | 17.5011 | 17.5011 | 4900.0 |
| 2013-10-10 05:00:00 | AAPL | Stock | 17.5068 | 17.5068 | 17.5068 | 17.5068 | 5600.0 |
| 2013-10-10 05:02:00 | AAPL | Stock | 17.5 | 17.5 | 17.5 | 17.5 | 4760.0 |
| 2013-10-10 05:11:00 | AAPL | Stock | 17.4864 | 17.4864 | 17.4857 | 17.4857 | 31080.0 |
| 2013-10-10 05:29:00 | AAPL | Stock | 17.4996 | 17.5 | 17.4996 | 17.4996 | 30800.0 |
| 2013-10-10 05:30:00 | AAPL | Stock | 17.4857 | 17.4857 | 17.4857 | 17.4857 | 25480.0 |
| 2013-10-10 05:39:00 | AAPL | Stock | 17.4732 | 17.4732 | 17.4732 | 17.4732 | 3080.0 |
| 2013-10-10 05:40:00 | AAPL | Stock | 17.5 | 17.5 | 17.5 | 17.5 | 28000.0 |
| 2013-10-10 05:47:00 | AAPL | Stock | 17.4946 | 17.4946 | 17.4946 | 17.4946 | 2800.0 |
| 2013-10-10 06:02:00 | AAPL | Stock | 17.4821 | 17.4821 | 17.4821 | 17.4821 | 2800.0 |
| 2013-10-10 06:06:00 | AAPL | Stock | 17.5 | 17.5 | 17.4993 | 17.5 | 14000.0 |
| 2013-10-10 06:07:00 | AAPL | Stock | 17.4821 | 17.4821 | 17.4821 | 17.4821 | 19460.0 |
| 2013-10-10 06:17:00 | AAPL | Stock | 17.4993 | 17.4993 | 17.4993 | 17.4993 | 2828.0 |
| 2013-10-10 06:29:00 | AAPL | Stock | 17.5 | 17.5 | 17.4993 | 17.5 | 25200.0 |
| 2013-10-10 06:30:00 | AAPL | Stock | 17.5 | 17.5 | 17.5 | 17.5 | 76692.0 |
| 2013-10-10 06:32:00 | AAPL | Stock | 17.4996 | 17.5 | 17.4996 | 17.5 | 14000.0 |
| 2013-10-10 06:40:00 | AAPL | Stock | 17.5 | 17.5 | 17.5 | 17.5 | 5600.0 |
| 2013-10-10 06:41:00 | AAPL | Stock | 17.5 | 17.5 | 17.5 | 17.5 | 14588.0 |
| 2013-10-10 06:42:00 | AAPL | Stock | 17.5089 | 17.5179 | 17.5089 | 17.5179 | 21224.0 |
| 2013-10-10 06:52:00 | AAPL | Stock | 17.5089 | 17.5089 | 17.5089 | 17.5089 | 5600.0 |
| 2013-10-10 06:54:00 | AAPL | Stock | 17.5004 | 17.5004 | 17.5004 | 17.5004 | 6300.0 |
| 2013-10-10 06:57:00 | AAPL | Stock | 17.5143 | 17.5146 | 17.5143 | 17.5146 | 8400.0 |
| 2013-10-10 07:01:00 | AAPL | Stock | 17.5104 | 17.5104 | 17.5104 | 17.5104 | 5600.0 |
| 2013-10-10 07:02:00 | AAPL | Stock | 17.5179 | 17.5179 | 17.5179 | 17.5179 | 19600.0 |
| 2013-10-10 07:03:00 | AAPL | Stock | 17.5111 | 17.5111 | 17.5039 | 17.5039 | 32060.0 |
| 2013-10-10 07:04:00 | AAPL | Stock | 17.5086 | 17.5132 | 17.5071 | 17.5132 | 56000.0 |
| 2013-10-10 07:05:00 | AAPL | Stock | 17.5132 | 17.5139 | 17.5132 | 17.5132 | 16800.0 |
| 2013-10-10 07:06:00 | AAPL | Stock | 17.5139 | 17.5179 | 17.5139 | 17.5179 | 40460.0 |
| 2013-10-10 07:07:00 | AAPL | Stock | 17.5175 | 17.5268 | 17.5175 | 17.5268 | 57148.0 |
| 2013-10-10 07:08:00 | AAPL | Stock | 17.5218 | 17.5218 | 17.5118 | 17.5118 | 20860.0 |
| 2013-10-10 07:09:00 | AAPL | Stock | 17.5207 | 17.5214 | 17.5207 | 17.5214 | 17080.0 |
| 2013-10-10 07:11:00 | AAPL | Stock | 17.5257 | 17.5257 | 17.5257 | 17.5257 | 5600.0 |
| 2013-10-10 07:12:00 | AAPL | Stock | 17.5182 | 17.5182 | 17.5114 | 17.5114 | 25200.0 |
| 2013-10-10 07:14:00 | AAPL | Stock | 17.5175 | 17.5243 | 17.5175 | 17.5243 | 21896.0 |
| 2013-10-10 07:15:00 | AAPL | Stock | 17.5239 | 17.5246 | 17.5196 | 17.5246 | 48020.0 |
| 2013-10-10 07:16:00 | AAPL | Stock | 17.5243 | 17.525 | 17.5243 | 17.525 | 28000.0 |
| 2013-10-10 07:17:00 | AAPL | Stock | 17.5243 | 17.5243 | 17.5243 | 17.5243 | 4844.0 |
| 2013-10-10 07:18:00 | AAPL | Stock | 17.525 | 17.5268 | 17.525 | 17.5268 | 71456.0 |
| 2013-10-10 07:19:00 | AAPL | Stock | 17.53 | 17.5357 | 17.5286 | 17.5357 | 59920.0 |
| 2013-10-10 07:23:00 | AAPL | Stock | 17.5361 | 17.5361 | 17.5339 | 17.5339 | 24500.0 |
| 2013-10-10 07:24:00 | AAPL | Stock | 17.5318 | 17.5357 | 17.5318 | 17.5357 | 33600.0 |
| 2013-10-10 07:26:00 | AAPL | Stock | 17.5354 | 17.5464 | 17.5314 | 17.5464 | 138460.0 |
| 2013-10-10 07:27:00 | AAPL | Stock | 17.5457 | 17.5511 | 17.5446 | 17.55 | 30800.0 |
| 2013-10-10 07:28:00 | AAPL | Stock | 17.5482 | 17.5482 | 17.5482 | 17.5482 | 5600.0 |
| 2013-10-10 07:29:00 | AAPL | Stock | 17.5436 | 17.55 | 17.5418 | 17.55 | 30800.0 |
| 2013-10-10 07:30:00 | AAPL | Stock | 17.5489 | 17.5514 | 17.5421 | 17.5421 | 33600.0 |
| 2013-10-10 07:31:00 | AAPL | Stock | 17.5525 | 17.5529 | 17.5429 | 17.5529 | 27160.0 |
> showing 50 of 1,017,954 rows — these rows as CSV