PREVIEW / stock_5min / 2011-03-08
file: by_date/stock_5min/2011/2011-03-08.parquet size: 4.9 MB rows: 332,853 symbols: 3,530
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-03-08 04:00:00 | AAPL | Stock | 12.7318 | 12.7318 | 12.7318 | 12.7318 | 2800.0 |
| 2011-03-08 04:05:00 | AAPL | Stock | 12.7418 | 12.7489 | 12.7418 | 12.7489 | 5600.0 |
| 2011-03-08 04:15:00 | AAPL | Stock | 12.7489 | 12.7489 | 12.7489 | 12.7489 | 5600.0 |
| 2011-03-08 04:30:00 | AAPL | Stock | 12.7489 | 12.7489 | 12.7489 | 12.7489 | 2800.0 |
| 2011-03-08 04:35:00 | AAPL | Stock | 12.7489 | 12.7489 | 12.7489 | 12.7489 | 2800.0 |
| 2011-03-08 06:55:00 | AAPL | Stock | 12.7321 | 12.7321 | 12.7321 | 12.7321 | 2800.0 |
| 2011-03-08 07:00:00 | AAPL | Stock | 12.7321 | 12.7321 | 12.7321 | 12.7321 | 16100.0 |
| 2011-03-08 07:05:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7136 | 12.7136 | 13440.0 |
| 2011-03-08 07:10:00 | AAPL | Stock | 12.6929 | 12.6929 | 12.6929 | 12.6929 | 2800.0 |
| 2011-03-08 07:15:00 | AAPL | Stock | 12.6929 | 12.7293 | 12.6929 | 12.7293 | 22400.0 |
| 2011-03-08 07:20:00 | AAPL | Stock | 12.7289 | 12.7411 | 12.7289 | 12.7393 | 33600.0 |
| 2011-03-08 07:30:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7 | 12.7 | 18648.0 |
| 2011-03-08 07:35:00 | AAPL | Stock | 12.7011 | 12.7036 | 12.7011 | 12.7036 | 7084.0 |
| 2011-03-08 07:40:00 | AAPL | Stock | 12.6982 | 12.7036 | 12.6971 | 12.7036 | 9100.0 |
| 2011-03-08 07:45:00 | AAPL | Stock | 12.7036 | 12.7136 | 12.7036 | 12.7136 | 45780.0 |
| 2011-03-08 07:50:00 | AAPL | Stock | 12.7143 | 12.7279 | 12.7036 | 12.7036 | 66220.0 |
| 2011-03-08 07:55:00 | AAPL | Stock | 12.7061 | 12.7061 | 12.7061 | 12.7061 | 5600.0 |
| 2011-03-08 08:00:00 | AAPL | Stock | 12.6804 | 12.705 | 12.6786 | 12.6925 | 168420.0 |
| 2011-03-08 08:05:00 | AAPL | Stock | 12.6929 | 12.6929 | 12.6607 | 12.6786 | 131600.0 |
| 2011-03-08 08:10:00 | AAPL | Stock | 12.6786 | 12.6929 | 12.6636 | 12.6786 | 162820.0 |
| 2011-03-08 08:15:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6625 | 12.6714 | 111160.0 |
| 2011-03-08 08:20:00 | AAPL | Stock | 12.6714 | 12.6714 | 12.6625 | 12.6629 | 25200.0 |
| 2011-03-08 08:25:00 | AAPL | Stock | 12.6625 | 12.6682 | 12.6561 | 12.6682 | 157416.0 |
| 2011-03-08 08:30:00 | AAPL | Stock | 12.6679 | 12.6761 | 12.6607 | 12.6761 | 19600.0 |
| 2011-03-08 08:35:00 | AAPL | Stock | 12.6607 | 12.6611 | 12.6557 | 12.6557 | 69020.0 |
| 2011-03-08 08:40:00 | AAPL | Stock | 12.6607 | 12.6714 | 12.6571 | 12.6654 | 61740.0 |
| 2011-03-08 08:45:00 | AAPL | Stock | 12.6914 | 12.6914 | 12.6689 | 12.6721 | 40152.0 |
| 2011-03-08 08:50:00 | AAPL | Stock | 12.6721 | 12.6761 | 12.6721 | 12.675 | 66640.0 |
| 2011-03-08 09:00:00 | AAPL | Stock | 12.6743 | 12.675 | 12.6686 | 12.6686 | 53200.0 |
| 2011-03-08 09:05:00 | AAPL | Stock | 12.6746 | 12.6746 | 12.6654 | 12.6675 | 93912.0 |
| 2011-03-08 09:10:00 | AAPL | Stock | 12.6679 | 12.6679 | 12.6575 | 12.6643 | 54852.0 |
| 2011-03-08 09:15:00 | AAPL | Stock | 12.6643 | 12.6696 | 12.6607 | 12.6632 | 94024.0 |
| 2011-03-08 09:20:00 | AAPL | Stock | 12.6589 | 12.6643 | 12.6589 | 12.6643 | 22400.0 |
| 2011-03-08 09:25:00 | AAPL | Stock | 12.6707 | 12.6814 | 12.6679 | 12.6771 | 181860.0 |
| 2011-03-08 09:30:00 | AAPL | Stock | 12.6768 | 12.7054 | 12.6429 | 12.6811 | 11159148.0 |
| 2011-03-08 09:35:00 | AAPL | Stock | 12.6811 | 12.6836 | 12.6286 | 12.6489 | 10304560.0 |
| 2011-03-08 09:40:00 | AAPL | Stock | 12.6436 | 12.6743 | 12.6379 | 12.6429 | 6448568.0 |
| 2011-03-08 09:45:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.5804 | 12.6132 | 12205396.0 |
| 2011-03-08 09:50:00 | AAPL | Stock | 12.6114 | 12.6407 | 12.5993 | 12.6279 | 9173276.0 |
| 2011-03-08 09:55:00 | AAPL | Stock | 12.6293 | 12.645 | 12.6264 | 12.6429 | 8380260.0 |
| 2011-03-08 10:00:00 | AAPL | Stock | 12.6432 | 12.6786 | 12.6329 | 12.6761 | 17567452.0 |
| 2011-03-08 10:05:00 | AAPL | Stock | 12.6757 | 12.6864 | 12.6643 | 12.6679 | 10498600.0 |
| 2011-03-08 10:10:00 | AAPL | Stock | 12.6686 | 12.7211 | 12.6618 | 12.7132 | 13259064.0 |
| 2011-03-08 10:15:00 | AAPL | Stock | 12.7118 | 12.7375 | 12.7118 | 12.7225 | 12096140.0 |
| 2011-03-08 10:20:00 | AAPL | Stock | 12.7218 | 12.7414 | 12.6968 | 12.6975 | 10005688.0 |
| 2011-03-08 10:25:00 | AAPL | Stock | 12.7004 | 12.7039 | 12.6714 | 12.6839 | 8382836.0 |
| 2011-03-08 10:30:00 | AAPL | Stock | 12.6843 | 12.7082 | 12.68 | 12.7021 | 5131420.0 |
| 2011-03-08 10:35:00 | AAPL | Stock | 12.7036 | 12.7211 | 12.7018 | 12.7075 | 4758628.0 |
| 2011-03-08 10:40:00 | AAPL | Stock | 12.7068 | 12.7214 | 12.6882 | 12.7032 | 6034308.0 |
| 2011-03-08 10:45:00 | AAPL | Stock | 12.7039 | 12.7179 | 12.6982 | 12.7039 | 4349408.0 |
> showing 50 of 332,853 rows — these rows as CSV