PREVIEW / stock_5min / 2012-10-16
file: by_date/stock_5min/2012/2012-10-16.parquet size: 4.7 MB rows: 316,202 symbols: 3,476
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-10-16 04:25:00 | AAPL | Stock | 22.7464 | 22.7464 | 22.7464 | 22.7464 | 13440.0 |
| 2012-10-16 04:35:00 | AAPL | Stock | 22.7557 | 22.7557 | 22.7557 | 22.7557 | 2800.0 |
| 2012-10-16 04:55:00 | AAPL | Stock | 22.7679 | 22.7679 | 22.7679 | 22.7679 | 2800.0 |
| 2012-10-16 05:10:00 | AAPL | Stock | 22.7571 | 22.7571 | 22.7429 | 22.7429 | 23044.0 |
| 2012-10-16 05:15:00 | AAPL | Stock | 22.7679 | 22.7679 | 22.7679 | 22.7679 | 2800.0 |
| 2012-10-16 05:30:00 | AAPL | Stock | 22.7607 | 22.7607 | 22.7607 | 22.7607 | 5600.0 |
| 2012-10-16 05:35:00 | AAPL | Stock | 22.7607 | 22.7607 | 22.7607 | 22.7607 | 10360.0 |
| 2012-10-16 05:45:00 | AAPL | Stock | 22.7571 | 22.8014 | 22.7571 | 22.7936 | 25032.0 |
| 2012-10-16 06:20:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7786 | 22.7786 | 2800.0 |
| 2012-10-16 06:25:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7786 | 22.7786 | 5600.0 |
| 2012-10-16 06:30:00 | AAPL | Stock | 22.7718 | 22.7786 | 22.7714 | 22.7786 | 12432.0 |
| 2012-10-16 06:35:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7786 | 22.7786 | 5600.0 |
| 2012-10-16 06:45:00 | AAPL | Stock | 22.7596 | 22.7786 | 22.7593 | 22.7786 | 27356.0 |
| 2012-10-16 06:50:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 2800.0 |
| 2012-10-16 06:55:00 | AAPL | Stock | 22.7804 | 22.7936 | 22.7804 | 22.7936 | 28448.0 |
| 2012-10-16 07:00:00 | AAPL | Stock | 22.7986 | 22.7986 | 22.7679 | 22.7679 | 66052.0 |
| 2012-10-16 07:05:00 | AAPL | Stock | 22.7536 | 22.7643 | 22.7536 | 22.7643 | 59472.0 |
| 2012-10-16 07:10:00 | AAPL | Stock | 22.7629 | 22.7629 | 22.7614 | 22.7614 | 11200.0 |
| 2012-10-16 07:15:00 | AAPL | Stock | 22.7593 | 22.7593 | 22.7164 | 22.7164 | 42056.0 |
| 2012-10-16 07:20:00 | AAPL | Stock | 22.7318 | 22.7318 | 22.7196 | 22.73 | 24500.0 |
| 2012-10-16 07:25:00 | AAPL | Stock | 22.73 | 22.7418 | 22.725 | 22.7264 | 45500.0 |
| 2012-10-16 07:30:00 | AAPL | Stock | 22.7418 | 22.7457 | 22.7214 | 22.7411 | 109200.0 |
| 2012-10-16 07:35:00 | AAPL | Stock | 22.7411 | 22.7589 | 22.7214 | 22.7214 | 48356.0 |
| 2012-10-16 07:40:00 | AAPL | Stock | 22.7296 | 22.7296 | 22.7075 | 22.7161 | 78400.0 |
| 2012-10-16 07:45:00 | AAPL | Stock | 22.7325 | 22.7482 | 22.7286 | 22.7432 | 134456.0 |
| 2012-10-16 07:50:00 | AAPL | Stock | 22.7329 | 22.7329 | 22.6357 | 22.6714 | 194292.0 |
| 2012-10-16 07:55:00 | AAPL | Stock | 22.7096 | 22.7096 | 22.6675 | 22.6875 | 93912.0 |
| 2012-10-16 08:00:00 | AAPL | Stock | 22.7046 | 22.75 | 22.6921 | 22.7429 | 390600.0 |
| 2012-10-16 08:05:00 | AAPL | Stock | 22.7411 | 22.7589 | 22.7357 | 22.7507 | 213472.0 |
| 2012-10-16 08:10:00 | AAPL | Stock | 22.7514 | 22.7596 | 22.7396 | 22.7507 | 204064.0 |
| 2012-10-16 08:15:00 | AAPL | Stock | 22.7504 | 22.765 | 22.7446 | 22.7536 | 157528.0 |
| 2012-10-16 08:20:00 | AAPL | Stock | 22.7643 | 22.7686 | 22.7321 | 22.75 | 244944.0 |
| 2012-10-16 08:25:00 | AAPL | Stock | 22.75 | 22.7511 | 22.7393 | 22.7493 | 205212.0 |
| 2012-10-16 08:30:00 | AAPL | Stock | 22.7329 | 22.7464 | 22.7286 | 22.7289 | 212520.0 |
| 2012-10-16 08:35:00 | AAPL | Stock | 22.7321 | 22.7343 | 22.7025 | 22.7025 | 273868.0 |
| 2012-10-16 08:40:00 | AAPL | Stock | 22.7036 | 22.7107 | 22.6911 | 22.7011 | 153748.0 |
| 2012-10-16 08:45:00 | AAPL | Stock | 22.6986 | 22.7054 | 22.6625 | 22.6768 | 369656.0 |
| 2012-10-16 08:50:00 | AAPL | Stock | 22.675 | 22.6825 | 22.675 | 22.6786 | 290780.0 |
| 2012-10-16 08:55:00 | AAPL | Stock | 22.6782 | 22.6839 | 22.6714 | 22.6807 | 279020.0 |
| 2012-10-16 09:00:00 | AAPL | Stock | 22.6889 | 22.6989 | 22.6821 | 22.6989 | 221732.0 |
| 2012-10-16 09:05:00 | AAPL | Stock | 22.6982 | 22.71 | 22.6971 | 22.6979 | 94752.0 |
| 2012-10-16 09:10:00 | AAPL | Stock | 22.6986 | 22.7032 | 22.6879 | 22.7032 | 173180.0 |
| 2012-10-16 09:15:00 | AAPL | Stock | 22.7032 | 22.7032 | 22.6964 | 22.7011 | 130732.0 |
| 2012-10-16 09:20:00 | AAPL | Stock | 22.6964 | 22.6964 | 22.6843 | 22.6846 | 68516.0 |
| 2012-10-16 09:25:00 | AAPL | Stock | 22.6857 | 22.7018 | 22.6786 | 22.7018 | 575876.0 |
| 2012-10-16 09:30:00 | AAPL | Stock | 22.6979 | 22.7107 | 22.5964 | 22.6168 | 16269512.0 |
| 2012-10-16 09:35:00 | AAPL | Stock | 22.6186 | 22.6607 | 22.5714 | 22.5857 | 12922700.0 |
| 2012-10-16 09:40:00 | AAPL | Stock | 22.5854 | 22.6418 | 22.5598 | 22.6082 | 7019180.0 |
| 2012-10-16 09:45:00 | AAPL | Stock | 22.6071 | 22.6207 | 22.5536 | 22.5869 | 6910092.0 |
| 2012-10-16 09:50:00 | AAPL | Stock | 22.5779 | 22.625 | 22.5468 | 22.5543 | 8125880.0 |
> showing 50 of 316,202 rows — these rows as CSV