PREVIEW / stock_5min / 2013-06-14
file: by_date/stock_5min/2013/2013-06-14.parquet size: 4.9 MB rows: 332,071 symbols: 3,500
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-06-14 05:05:00 | AAPL | Stock | 15.5607 | 15.5607 | 15.5607 | 15.5607 | 11200.0 |
| 2013-06-14 05:10:00 | AAPL | Stock | 15.5607 | 15.5607 | 15.5607 | 15.5607 | 30800.0 |
| 2013-06-14 05:15:00 | AAPL | Stock | 15.5643 | 15.5643 | 15.5643 | 15.5643 | 3920.0 |
| 2013-06-14 05:20:00 | AAPL | Stock | 15.5607 | 15.5718 | 15.5607 | 15.5718 | 22400.0 |
| 2013-06-14 06:15:00 | AAPL | Stock | 15.5536 | 15.5536 | 15.5536 | 15.5536 | 2800.0 |
| 2013-06-14 06:55:00 | AAPL | Stock | 15.5407 | 15.5429 | 15.5357 | 15.5357 | 38444.0 |
| 2013-06-14 07:00:00 | AAPL | Stock | 15.5257 | 15.5286 | 15.5243 | 15.5286 | 28000.0 |
| 2013-06-14 07:05:00 | AAPL | Stock | 15.5243 | 15.5393 | 15.5243 | 15.5393 | 28364.0 |
| 2013-06-14 07:10:00 | AAPL | Stock | 15.5464 | 15.5464 | 15.5464 | 15.5464 | 19600.0 |
| 2013-06-14 07:15:00 | AAPL | Stock | 15.5436 | 15.5436 | 15.5411 | 15.5411 | 22120.0 |
| 2013-06-14 08:00:00 | AAPL | Stock | 15.5589 | 15.5639 | 15.5243 | 15.5514 | 72044.0 |
| 2013-06-14 08:05:00 | AAPL | Stock | 15.5368 | 15.5393 | 15.5321 | 15.5321 | 42420.0 |
| 2013-06-14 08:10:00 | AAPL | Stock | 15.5357 | 15.5457 | 15.5321 | 15.5457 | 30800.0 |
| 2013-06-14 08:15:00 | AAPL | Stock | 15.5432 | 15.5446 | 15.5432 | 15.5446 | 27720.0 |
| 2013-06-14 08:20:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5321 | 15.5321 | 50736.0 |
| 2013-06-14 08:25:00 | AAPL | Stock | 15.5396 | 15.5439 | 15.5332 | 15.5439 | 23800.0 |
| 2013-06-14 08:30:00 | AAPL | Stock | 15.5425 | 15.5482 | 15.5425 | 15.5482 | 55580.0 |
| 2013-06-14 08:35:00 | AAPL | Stock | 15.5714 | 15.5714 | 15.5429 | 15.5439 | 683200.0 |
| 2013-06-14 08:40:00 | AAPL | Stock | 15.5536 | 15.5664 | 15.5536 | 15.5664 | 58800.0 |
| 2013-06-14 08:45:00 | AAPL | Stock | 15.5643 | 15.5746 | 15.5643 | 15.5714 | 70000.0 |
| 2013-06-14 08:50:00 | AAPL | Stock | 15.5714 | 15.5714 | 15.5646 | 15.5679 | 28420.0 |
| 2013-06-14 08:55:00 | AAPL | Stock | 15.5579 | 15.5811 | 15.5571 | 15.5811 | 26740.0 |
| 2013-06-14 09:00:00 | AAPL | Stock | 15.5804 | 15.5961 | 15.5804 | 15.5821 | 157696.0 |
| 2013-06-14 09:05:00 | AAPL | Stock | 15.5729 | 15.5729 | 15.5636 | 15.5636 | 30800.0 |
| 2013-06-14 09:10:00 | AAPL | Stock | 15.5679 | 15.5768 | 15.5679 | 15.5768 | 166488.0 |
| 2013-06-14 09:15:00 | AAPL | Stock | 15.5714 | 15.5771 | 15.5575 | 15.5771 | 201628.0 |
| 2013-06-14 09:20:00 | AAPL | Stock | 15.5714 | 15.5714 | 15.5571 | 15.5582 | 50400.0 |
| 2013-06-14 09:25:00 | AAPL | Stock | 15.5643 | 15.5643 | 15.5446 | 15.5557 | 449792.0 |
| 2013-06-14 09:30:00 | AAPL | Stock | 15.5554 | 15.5818 | 15.5075 | 15.5176 | 9943948.0 |
| 2013-06-14 09:35:00 | AAPL | Stock | 15.5129 | 15.5436 | 15.4907 | 15.495 | 7046116.0 |
| 2013-06-14 09:40:00 | AAPL | Stock | 15.495 | 15.55 | 15.4886 | 15.5225 | 5035380.0 |
| 2013-06-14 09:45:00 | AAPL | Stock | 15.5204 | 15.55 | 15.5143 | 15.55 | 4542272.0 |
| 2013-06-14 09:50:00 | AAPL | Stock | 15.5498 | 15.5498 | 15.5096 | 15.5204 | 3104416.0 |
| 2013-06-14 09:55:00 | AAPL | Stock | 15.5204 | 15.5211 | 15.4954 | 15.4975 | 7215908.0 |
| 2013-06-14 10:00:00 | AAPL | Stock | 15.4975 | 15.5389 | 15.49 | 15.5257 | 4196780.0 |
| 2013-06-14 10:05:00 | AAPL | Stock | 15.5275 | 15.5354 | 15.4968 | 15.5125 | 4754400.0 |
| 2013-06-14 10:10:00 | AAPL | Stock | 15.5121 | 15.5129 | 15.4722 | 15.4846 | 5873252.0 |
| 2013-06-14 10:15:00 | AAPL | Stock | 15.4797 | 15.49 | 15.4625 | 15.4625 | 5204388.0 |
| 2013-06-14 10:20:00 | AAPL | Stock | 15.4625 | 15.4764 | 15.4472 | 15.45 | 3386768.0 |
| 2013-06-14 10:25:00 | AAPL | Stock | 15.4521 | 15.4614 | 15.4289 | 15.4446 | 5030648.0 |
| 2013-06-14 10:30:00 | AAPL | Stock | 15.4436 | 15.475 | 15.4393 | 15.4664 | 3812788.0 |
| 2013-06-14 10:35:00 | AAPL | Stock | 15.4654 | 15.4736 | 15.4335 | 15.445 | 4162676.0 |
| 2013-06-14 10:40:00 | AAPL | Stock | 15.445 | 15.4468 | 15.4218 | 15.4304 | 3494680.0 |
| 2013-06-14 10:45:00 | AAPL | Stock | 15.4327 | 15.4475 | 15.4286 | 15.4382 | 2247644.0 |
| 2013-06-14 10:50:00 | AAPL | Stock | 15.4382 | 15.4382 | 15.4114 | 15.4204 | 3365180.0 |
| 2013-06-14 10:55:00 | AAPL | Stock | 15.4168 | 15.4204 | 15.3989 | 15.4131 | 5083624.0 |
| 2013-06-14 11:00:00 | AAPL | Stock | 15.4129 | 15.4318 | 15.4039 | 15.4107 | 3124856.0 |
| 2013-06-14 11:05:00 | AAPL | Stock | 15.4107 | 15.4218 | 15.4046 | 15.4107 | 2310644.0 |
| 2013-06-14 11:10:00 | AAPL | Stock | 15.4154 | 15.4339 | 15.4111 | 15.4225 | 3636192.0 |
| 2013-06-14 11:15:00 | AAPL | Stock | 15.4225 | 15.4429 | 15.4125 | 15.4132 | 2566788.0 |
> showing 50 of 332,071 rows — these rows as CSV