PREVIEW / stock_5min / 2013-05-20
file: by_date/stock_5min/2013/2013-05-20.parquet size: 5.1 MB rows: 337,559 symbols: 3,507
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-05-20 04:00:00 | AAPL | Stock | 15.4696 | 15.4696 | 15.4696 | 15.4696 | 2800.0 |
| 2013-05-20 05:40:00 | AAPL | Stock | 15.4857 | 15.4857 | 15.4857 | 15.4857 | 2800.0 |
| 2013-05-20 06:35:00 | AAPL | Stock | 15.51 | 15.51 | 15.51 | 15.51 | 2800.0 |
| 2013-05-20 06:50:00 | AAPL | Stock | 15.5175 | 15.5175 | 15.5175 | 15.5175 | 2800.0 |
| 2013-05-20 06:55:00 | AAPL | Stock | 15.5154 | 15.5154 | 15.5154 | 15.5154 | 2800.0 |
| 2013-05-20 07:00:00 | AAPL | Stock | 15.5154 | 15.5154 | 15.5143 | 15.5143 | 5600.0 |
| 2013-05-20 07:05:00 | AAPL | Stock | 15.5125 | 15.5143 | 15.5125 | 15.5125 | 11480.0 |
| 2013-05-20 07:10:00 | AAPL | Stock | 15.5032 | 15.5032 | 15.5021 | 15.5021 | 5600.0 |
| 2013-05-20 07:30:00 | AAPL | Stock | 15.4964 | 15.4964 | 15.4964 | 15.4964 | 5600.0 |
| 2013-05-20 07:40:00 | AAPL | Stock | 15.4879 | 15.4889 | 15.4879 | 15.4889 | 14000.0 |
| 2013-05-20 07:50:00 | AAPL | Stock | 15.4821 | 15.4821 | 15.4821 | 15.4821 | 2800.0 |
| 2013-05-20 07:55:00 | AAPL | Stock | 15.4754 | 15.4754 | 15.4639 | 15.4639 | 26096.0 |
| 2013-05-20 08:00:00 | AAPL | Stock | 15.4643 | 15.5143 | 15.4643 | 15.4925 | 52220.0 |
| 2013-05-20 08:05:00 | AAPL | Stock | 15.4821 | 15.49 | 15.4286 | 15.4286 | 29036.0 |
| 2013-05-20 08:10:00 | AAPL | Stock | 15.4711 | 15.4711 | 15.4643 | 15.4643 | 26992.0 |
| 2013-05-20 08:15:00 | AAPL | Stock | 15.4564 | 15.48 | 15.4554 | 15.48 | 53564.0 |
| 2013-05-20 08:20:00 | AAPL | Stock | 15.4786 | 15.48 | 15.4646 | 15.4661 | 42000.0 |
| 2013-05-20 08:25:00 | AAPL | Stock | 15.4643 | 15.4646 | 15.4468 | 15.4554 | 51800.0 |
| 2013-05-20 08:30:00 | AAPL | Stock | 15.4529 | 15.4529 | 15.4396 | 15.4464 | 61600.0 |
| 2013-05-20 08:35:00 | AAPL | Stock | 15.4514 | 15.4518 | 15.44 | 15.4518 | 30800.0 |
| 2013-05-20 08:40:00 | AAPL | Stock | 15.4643 | 15.4643 | 15.4561 | 15.4561 | 42952.0 |
| 2013-05-20 08:45:00 | AAPL | Stock | 15.4575 | 15.4575 | 15.4557 | 15.4571 | 11200.0 |
| 2013-05-20 08:50:00 | AAPL | Stock | 15.46 | 15.46 | 15.4329 | 15.4404 | 89600.0 |
| 2013-05-20 08:55:00 | AAPL | Stock | 15.4557 | 15.4596 | 15.4464 | 15.4464 | 14000.0 |
| 2013-05-20 09:00:00 | AAPL | Stock | 15.45 | 15.45 | 15.4293 | 15.4396 | 99400.0 |
| 2013-05-20 09:05:00 | AAPL | Stock | 15.45 | 15.4571 | 15.4432 | 15.4432 | 16800.0 |
| 2013-05-20 09:10:00 | AAPL | Stock | 15.4543 | 15.4543 | 15.4482 | 15.4493 | 37800.0 |
| 2013-05-20 09:15:00 | AAPL | Stock | 15.4536 | 15.4536 | 15.4464 | 15.4464 | 43260.0 |
| 2013-05-20 09:20:00 | AAPL | Stock | 15.4393 | 15.4393 | 15.4175 | 15.4271 | 86800.0 |
| 2013-05-20 09:25:00 | AAPL | Stock | 15.4261 | 15.4289 | 15.4179 | 15.42 | 105784.0 |
| 2013-05-20 09:30:00 | AAPL | Stock | 15.4211 | 15.4443 | 15.3607 | 15.4357 | 13083504.0 |
| 2013-05-20 09:35:00 | AAPL | Stock | 15.4329 | 15.5389 | 15.4114 | 15.5389 | 9877616.0 |
| 2013-05-20 09:40:00 | AAPL | Stock | 15.54 | 15.5596 | 15.4829 | 15.5289 | 9206764.0 |
| 2013-05-20 09:45:00 | AAPL | Stock | 15.5275 | 15.6075 | 15.5 | 15.6029 | 9867956.0 |
| 2013-05-20 09:50:00 | AAPL | Stock | 15.6007 | 15.6425 | 15.5811 | 15.6425 | 10538976.0 |
| 2013-05-20 09:55:00 | AAPL | Stock | 15.6425 | 15.6896 | 15.6289 | 15.6767 | 11987164.0 |
| 2013-05-20 10:00:00 | AAPL | Stock | 15.6789 | 15.6929 | 15.6296 | 15.6461 | 8900920.0 |
| 2013-05-20 10:05:00 | AAPL | Stock | 15.6461 | 15.6836 | 15.6454 | 15.6643 | 6435464.0 |
| 2013-05-20 10:10:00 | AAPL | Stock | 15.6646 | 15.6718 | 15.6361 | 15.664 | 3630788.0 |
| 2013-05-20 10:15:00 | AAPL | Stock | 15.6661 | 15.7396 | 15.65 | 15.7376 | 11716600.0 |
| 2013-05-20 10:20:00 | AAPL | Stock | 15.7382 | 15.7732 | 15.7068 | 15.7732 | 8664684.0 |
| 2013-05-20 10:25:00 | AAPL | Stock | 15.7736 | 15.7936 | 15.735 | 15.7911 | 9885988.0 |
| 2013-05-20 10:30:00 | AAPL | Stock | 15.7911 | 15.7942 | 15.7329 | 15.7764 | 7092260.0 |
| 2013-05-20 10:35:00 | AAPL | Stock | 15.7771 | 15.7771 | 15.7207 | 15.7414 | 7938672.0 |
| 2013-05-20 10:40:00 | AAPL | Stock | 15.7414 | 15.7621 | 15.7329 | 15.7486 | 3053484.0 |
| 2013-05-20 10:45:00 | AAPL | Stock | 15.7518 | 15.7614 | 15.7275 | 15.7529 | 5004300.0 |
| 2013-05-20 10:50:00 | AAPL | Stock | 15.7536 | 15.7586 | 15.7361 | 15.7502 | 3040044.0 |
| 2013-05-20 10:55:00 | AAPL | Stock | 15.7504 | 15.7821 | 15.7443 | 15.7682 | 3272080.0 |
| 2013-05-20 11:00:00 | AAPL | Stock | 15.7668 | 15.8329 | 15.7664 | 15.8329 | 7454664.0 |
| 2013-05-20 11:05:00 | AAPL | Stock | 15.8321 | 15.8618 | 15.8246 | 15.8354 | 8828876.0 |
> showing 50 of 337,559 rows — these rows as CSV