PREVIEW / stock_5min / 2011-06-15
file: by_date/stock_5min/2011/2011-06-15.parquet size: 5.0 MB rows: 341,581 symbols: 3,558
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-15 04:00:00 | AAPL | Stock | 11.875 | 11.875 | 11.875 | 11.875 | 2800.0 |
| 2011-06-15 04:35:00 | AAPL | Stock | 11.8432 | 11.8439 | 11.8432 | 11.8439 | 5600.0 |
| 2011-06-15 05:05:00 | AAPL | Stock | 11.8036 | 11.8036 | 11.8036 | 11.8036 | 5600.0 |
| 2011-06-15 05:10:00 | AAPL | Stock | 11.7964 | 11.7986 | 11.7964 | 11.7979 | 16800.0 |
| 2011-06-15 05:15:00 | AAPL | Stock | 11.7929 | 11.7929 | 11.7896 | 11.7911 | 16800.0 |
| 2011-06-15 06:05:00 | AAPL | Stock | 11.8121 | 11.8121 | 11.8111 | 11.8111 | 5600.0 |
| 2011-06-15 06:10:00 | AAPL | Stock | 11.8039 | 11.8039 | 11.8039 | 11.8039 | 2800.0 |
| 2011-06-15 06:20:00 | AAPL | Stock | 11.795 | 11.795 | 11.795 | 11.795 | 2800.0 |
| 2011-06-15 06:35:00 | AAPL | Stock | 11.8157 | 11.8157 | 11.8157 | 11.8157 | 2800.0 |
| 2011-06-15 06:55:00 | AAPL | Stock | 11.8107 | 11.8107 | 11.8089 | 11.8089 | 15820.0 |
| 2011-06-15 07:00:00 | AAPL | Stock | 11.8057 | 11.8057 | 11.8057 | 11.8057 | 5600.0 |
| 2011-06-15 07:05:00 | AAPL | Stock | 11.81 | 11.8286 | 11.81 | 11.8286 | 11200.0 |
| 2011-06-15 07:10:00 | AAPL | Stock | 11.8286 | 11.8318 | 11.8286 | 11.8318 | 19600.0 |
| 2011-06-15 07:15:00 | AAPL | Stock | 11.8268 | 11.8304 | 11.825 | 11.8304 | 44800.0 |
| 2011-06-15 07:20:00 | AAPL | Stock | 11.8286 | 11.8289 | 11.8286 | 11.8289 | 11200.0 |
| 2011-06-15 07:25:00 | AAPL | Stock | 11.8268 | 11.8268 | 11.8261 | 11.8261 | 8400.0 |
| 2011-06-15 07:30:00 | AAPL | Stock | 11.8307 | 11.8307 | 11.8307 | 11.8307 | 25200.0 |
| 2011-06-15 07:35:00 | AAPL | Stock | 11.8354 | 11.8354 | 11.8354 | 11.8354 | 5600.0 |
| 2011-06-15 07:40:00 | AAPL | Stock | 11.8289 | 11.8339 | 11.8289 | 11.8339 | 8400.0 |
| 2011-06-15 07:45:00 | AAPL | Stock | 11.8286 | 11.8286 | 11.8286 | 11.8286 | 2800.0 |
| 2011-06-15 07:50:00 | AAPL | Stock | 11.8286 | 11.8286 | 11.8257 | 11.8261 | 25200.0 |
| 2011-06-15 07:55:00 | AAPL | Stock | 11.8261 | 11.8261 | 11.825 | 11.8254 | 25648.0 |
| 2011-06-15 08:00:00 | AAPL | Stock | 11.8254 | 11.8379 | 11.8114 | 11.8139 | 258972.0 |
| 2011-06-15 08:05:00 | AAPL | Stock | 11.8143 | 11.8157 | 11.8036 | 11.8143 | 76608.0 |
| 2011-06-15 08:10:00 | AAPL | Stock | 11.8207 | 11.8214 | 11.8207 | 11.8214 | 6720.0 |
| 2011-06-15 08:15:00 | AAPL | Stock | 11.8218 | 11.8361 | 11.8218 | 11.8361 | 33460.0 |
| 2011-06-15 08:20:00 | AAPL | Stock | 11.8304 | 11.8304 | 11.8286 | 11.8286 | 8400.0 |
| 2011-06-15 08:25:00 | AAPL | Stock | 11.8279 | 11.8286 | 11.8039 | 11.8186 | 141624.0 |
| 2011-06-15 08:30:00 | AAPL | Stock | 11.8093 | 11.8093 | 11.7632 | 11.7679 | 562828.0 |
| 2011-06-15 08:35:00 | AAPL | Stock | 11.7707 | 11.7839 | 11.765 | 11.7671 | 196588.0 |
| 2011-06-15 08:40:00 | AAPL | Stock | 11.7689 | 11.7779 | 11.7689 | 11.7746 | 114100.0 |
| 2011-06-15 08:45:00 | AAPL | Stock | 11.7768 | 11.7857 | 11.7754 | 11.7754 | 121856.0 |
| 2011-06-15 08:50:00 | AAPL | Stock | 11.7768 | 11.7839 | 11.7754 | 11.7786 | 62496.0 |
| 2011-06-15 08:55:00 | AAPL | Stock | 11.7807 | 11.7814 | 11.7696 | 11.7754 | 183484.0 |
| 2011-06-15 09:00:00 | AAPL | Stock | 11.7696 | 11.775 | 11.7604 | 11.7725 | 224196.0 |
| 2011-06-15 09:05:00 | AAPL | Stock | 11.7696 | 11.7775 | 11.7679 | 11.7746 | 194460.0 |
| 2011-06-15 09:10:00 | AAPL | Stock | 11.7739 | 11.7804 | 11.7732 | 11.775 | 104328.0 |
| 2011-06-15 09:15:00 | AAPL | Stock | 11.7732 | 11.7768 | 11.7682 | 11.775 | 109676.0 |
| 2011-06-15 09:20:00 | AAPL | Stock | 11.775 | 11.7857 | 11.7718 | 11.775 | 133924.0 |
| 2011-06-15 09:25:00 | AAPL | Stock | 11.7718 | 11.7768 | 11.7682 | 11.7768 | 119784.0 |
| 2011-06-15 09:30:00 | AAPL | Stock | 11.7764 | 11.7804 | 11.7339 | 11.7486 | 15966720.0 |
| 2011-06-15 09:35:00 | AAPL | Stock | 11.7482 | 11.7586 | 11.7321 | 11.7356 | 7186648.0 |
| 2011-06-15 09:40:00 | AAPL | Stock | 11.7375 | 11.7643 | 11.7293 | 11.7594 | 8114596.0 |
| 2011-06-15 09:45:00 | AAPL | Stock | 11.7618 | 11.7725 | 11.7482 | 11.7596 | 6550348.0 |
| 2011-06-15 09:50:00 | AAPL | Stock | 11.76 | 11.7675 | 11.7435 | 11.7579 | 6084484.0 |
| 2011-06-15 09:55:00 | AAPL | Stock | 11.7586 | 11.7607 | 11.7464 | 11.7546 | 3440864.0 |
| 2011-06-15 10:00:00 | AAPL | Stock | 11.7539 | 11.7639 | 11.7482 | 11.7593 | 3885560.0 |
| 2011-06-15 10:05:00 | AAPL | Stock | 11.7607 | 11.785 | 11.7589 | 11.7814 | 6184220.0 |
| 2011-06-15 10:10:00 | AAPL | Stock | 11.7829 | 11.7964 | 11.7679 | 11.7779 | 5841612.0 |
| 2011-06-15 10:15:00 | AAPL | Stock | 11.7789 | 11.7839 | 11.7643 | 11.7675 | 2575916.0 |
> showing 50 of 341,581 rows — these rows as CSV