PREVIEW / stock_5min / 2012-03-30
file: by_date/stock_5min/2012/2012-03-30.parquet size: 4.9 MB rows: 330,243 symbols: 3,557
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-30 04:20:00 | AAPL | Stock | 21.6193 | 21.6193 | 21.6193 | 21.6193 | 9800.0 |
| 2012-03-30 04:40:00 | AAPL | Stock | 21.6196 | 21.6196 | 21.6196 | 21.6196 | 14000.0 |
| 2012-03-30 04:45:00 | AAPL | Stock | 21.655 | 21.655 | 21.655 | 21.655 | 2800.0 |
| 2012-03-30 05:15:00 | AAPL | Stock | 21.6189 | 21.6189 | 21.6189 | 21.6189 | 11788.0 |
| 2012-03-30 05:25:00 | AAPL | Stock | 21.6425 | 21.655 | 21.6425 | 21.655 | 16800.0 |
| 2012-03-30 05:30:00 | AAPL | Stock | 21.6429 | 21.6429 | 21.6429 | 21.6429 | 2800.0 |
| 2012-03-30 05:55:00 | AAPL | Stock | 21.6782 | 21.6782 | 21.6782 | 21.6782 | 2800.0 |
| 2012-03-30 06:05:00 | AAPL | Stock | 21.6789 | 21.6789 | 21.6789 | 21.6789 | 11200.0 |
| 2012-03-30 06:15:00 | AAPL | Stock | 21.6575 | 21.6575 | 21.6432 | 21.6432 | 22456.0 |
| 2012-03-30 06:25:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 5600.0 |
| 2012-03-30 06:30:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 2800.0 |
| 2012-03-30 06:35:00 | AAPL | Stock | 21.6957 | 21.6957 | 21.6957 | 21.6957 | 2800.0 |
| 2012-03-30 06:40:00 | AAPL | Stock | 21.6968 | 21.7143 | 21.6968 | 21.7143 | 14000.0 |
| 2012-03-30 06:50:00 | AAPL | Stock | 21.7104 | 21.7104 | 21.7104 | 21.7104 | 8008.0 |
| 2012-03-30 07:00:00 | AAPL | Stock | 21.7068 | 21.7457 | 21.7068 | 21.7186 | 138572.0 |
| 2012-03-30 07:05:00 | AAPL | Stock | 21.725 | 21.7589 | 21.725 | 21.7504 | 163660.0 |
| 2012-03-30 07:10:00 | AAPL | Stock | 21.7568 | 21.7671 | 21.7407 | 21.7639 | 202160.0 |
| 2012-03-30 07:15:00 | AAPL | Stock | 21.7657 | 21.7975 | 21.7571 | 21.7793 | 287812.0 |
| 2012-03-30 07:20:00 | AAPL | Stock | 21.7786 | 21.7814 | 21.7496 | 21.7543 | 145320.0 |
| 2012-03-30 07:25:00 | AAPL | Stock | 21.7675 | 21.7768 | 21.7607 | 21.7768 | 96600.0 |
| 2012-03-30 07:30:00 | AAPL | Stock | 21.7732 | 21.7814 | 21.77 | 21.7804 | 207200.0 |
| 2012-03-30 07:35:00 | AAPL | Stock | 21.7814 | 21.8071 | 21.7786 | 21.8018 | 206108.0 |
| 2012-03-30 07:40:00 | AAPL | Stock | 21.8036 | 21.8429 | 21.8036 | 21.8207 | 325080.0 |
| 2012-03-30 07:45:00 | AAPL | Stock | 21.8196 | 21.8393 | 21.8143 | 21.8393 | 173740.0 |
| 2012-03-30 07:50:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8111 | 21.8111 | 189504.0 |
| 2012-03-30 07:55:00 | AAPL | Stock | 21.8171 | 21.8179 | 21.8075 | 21.8111 | 67200.0 |
| 2012-03-30 08:00:00 | AAPL | Stock | 21.8179 | 21.8661 | 21.7496 | 21.8568 | 782684.0 |
| 2012-03-30 08:05:00 | AAPL | Stock | 21.8536 | 21.8571 | 21.8289 | 21.8429 | 434700.0 |
| 2012-03-30 08:10:00 | AAPL | Stock | 21.8464 | 21.8496 | 21.8107 | 21.8107 | 355796.0 |
| 2012-03-30 08:15:00 | AAPL | Stock | 21.8171 | 21.8179 | 21.7714 | 21.7714 | 752360.0 |
| 2012-03-30 08:20:00 | AAPL | Stock | 21.7696 | 21.7804 | 21.75 | 21.7679 | 757568.0 |
| 2012-03-30 08:25:00 | AAPL | Stock | 21.7654 | 21.7821 | 21.7654 | 21.7768 | 299628.0 |
| 2012-03-30 08:30:00 | AAPL | Stock | 21.7761 | 21.7761 | 21.7393 | 21.7496 | 867972.0 |
| 2012-03-30 08:35:00 | AAPL | Stock | 21.7482 | 21.7679 | 21.7379 | 21.7579 | 499716.0 |
| 2012-03-30 08:40:00 | AAPL | Stock | 21.7557 | 21.7568 | 21.7179 | 21.7186 | 382284.0 |
| 2012-03-30 08:45:00 | AAPL | Stock | 21.7229 | 21.7354 | 21.7193 | 21.7214 | 180936.0 |
| 2012-03-30 08:50:00 | AAPL | Stock | 21.7214 | 21.7325 | 21.7179 | 21.7282 | 152320.0 |
| 2012-03-30 08:55:00 | AAPL | Stock | 21.7243 | 21.7254 | 21.7 | 21.7036 | 767676.0 |
| 2012-03-30 09:00:00 | AAPL | Stock | 21.7064 | 21.7071 | 21.6536 | 21.6929 | 1098216.0 |
| 2012-03-30 09:05:00 | AAPL | Stock | 21.6943 | 21.7107 | 21.6825 | 21.7014 | 366268.0 |
| 2012-03-30 09:10:00 | AAPL | Stock | 21.7014 | 21.7054 | 21.675 | 21.6829 | 860916.0 |
| 2012-03-30 09:15:00 | AAPL | Stock | 21.685 | 21.7086 | 21.6818 | 21.7086 | 208824.0 |
| 2012-03-30 09:20:00 | AAPL | Stock | 21.7082 | 21.7714 | 21.7082 | 21.7679 | 1224244.0 |
| 2012-03-30 09:25:00 | AAPL | Stock | 21.7686 | 21.7821 | 21.7264 | 21.7264 | 980112.0 |
| 2012-03-30 09:30:00 | AAPL | Stock | 21.7418 | 21.8057 | 21.72 | 21.7636 | 24006472.0 |
| 2012-03-30 09:35:00 | AAPL | Stock | 21.7678 | 21.7761 | 21.635 | 21.685 | 25373040.0 |
| 2012-03-30 09:40:00 | AAPL | Stock | 21.6879 | 21.725 | 21.6632 | 21.6807 | 12945352.0 |
| 2012-03-30 09:45:00 | AAPL | Stock | 21.6782 | 21.6879 | 21.6171 | 21.6308 | 18766076.0 |
| 2012-03-30 09:50:00 | AAPL | Stock | 21.6329 | 21.6779 | 21.6286 | 21.6654 | 12339936.0 |
| 2012-03-30 09:55:00 | AAPL | Stock | 21.6671 | 21.69 | 21.6329 | 21.6407 | 12228356.0 |
> showing 50 of 330,243 rows — these rows as CSV