PREVIEW / stock_5min / 2013-08-14
file: by_date/stock_5min/2013/2013-08-14.parquet size: 5.1 MB rows: 340,226 symbols: 3,519
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-08-14 04:00:00 | AAPL | Stock | 17.6071 | 17.7129 | 17.6071 | 17.6839 | 67256.0 |
| 2013-08-14 04:05:00 | AAPL | Stock | 17.6464 | 17.6839 | 17.6464 | 17.6832 | 24752.0 |
| 2013-08-14 04:15:00 | AAPL | Stock | 17.6714 | 17.6714 | 17.6714 | 17.6714 | 5432.0 |
| 2013-08-14 04:20:00 | AAPL | Stock | 17.6696 | 17.6696 | 17.6696 | 17.6696 | 6524.0 |
| 2013-08-14 04:25:00 | AAPL | Stock | 17.6696 | 17.6696 | 17.6696 | 17.6696 | 5600.0 |
| 2013-08-14 04:30:00 | AAPL | Stock | 17.6714 | 17.6714 | 17.6714 | 17.6714 | 2800.0 |
| 2013-08-14 04:35:00 | AAPL | Stock | 17.6689 | 17.6689 | 17.6464 | 17.6464 | 23128.0 |
| 2013-08-14 04:40:00 | AAPL | Stock | 17.65 | 17.65 | 17.6429 | 17.6429 | 22400.0 |
| 2013-08-14 05:05:00 | AAPL | Stock | 17.6321 | 17.6457 | 17.6282 | 17.6457 | 10192.0 |
| 2013-08-14 05:15:00 | AAPL | Stock | 17.6304 | 17.6304 | 17.6304 | 17.6304 | 2800.0 |
| 2013-08-14 05:20:00 | AAPL | Stock | 17.6386 | 17.6386 | 17.6386 | 17.6386 | 2800.0 |
| 2013-08-14 05:25:00 | AAPL | Stock | 17.6304 | 17.6429 | 17.6304 | 17.6429 | 5600.0 |
| 2013-08-14 05:35:00 | AAPL | Stock | 17.6457 | 17.6607 | 17.6457 | 17.6607 | 16604.0 |
| 2013-08-14 05:40:00 | AAPL | Stock | 17.6786 | 17.6786 | 17.6786 | 17.6786 | 5600.0 |
| 2013-08-14 05:45:00 | AAPL | Stock | 17.6786 | 17.6786 | 17.6761 | 17.6761 | 5600.0 |
| 2013-08-14 05:55:00 | AAPL | Stock | 17.6786 | 17.6982 | 17.6786 | 17.6982 | 19600.0 |
| 2013-08-14 06:00:00 | AAPL | Stock | 17.6982 | 17.6982 | 17.6982 | 17.6982 | 5600.0 |
| 2013-08-14 06:05:00 | AAPL | Stock | 17.7107 | 17.7482 | 17.7071 | 17.7111 | 81200.0 |
| 2013-08-14 06:15:00 | AAPL | Stock | 17.7107 | 17.7411 | 17.6825 | 17.6825 | 42700.0 |
| 2013-08-14 06:20:00 | AAPL | Stock | 17.6796 | 17.6986 | 17.6789 | 17.6986 | 32760.0 |
| 2013-08-14 06:25:00 | AAPL | Stock | 17.7143 | 17.7425 | 17.7125 | 17.7143 | 49672.0 |
| 2013-08-14 06:30:00 | AAPL | Stock | 17.7143 | 17.7143 | 17.6986 | 17.6986 | 32816.0 |
| 2013-08-14 06:35:00 | AAPL | Stock | 17.6914 | 17.6964 | 17.6911 | 17.6964 | 19600.0 |
| 2013-08-14 06:40:00 | AAPL | Stock | 17.6861 | 17.6964 | 17.6804 | 17.6964 | 31220.0 |
| 2013-08-14 06:45:00 | AAPL | Stock | 17.6839 | 17.7143 | 17.6839 | 17.7143 | 144872.0 |
| 2013-08-14 06:50:00 | AAPL | Stock | 17.7143 | 17.7143 | 17.6964 | 17.7036 | 11200.0 |
| 2013-08-14 06:55:00 | AAPL | Stock | 17.7114 | 17.7114 | 17.6964 | 17.6964 | 7308.0 |
| 2013-08-14 07:00:00 | AAPL | Stock | 17.7143 | 17.7321 | 17.7143 | 17.7321 | 134764.0 |
| 2013-08-14 07:05:00 | AAPL | Stock | 17.7354 | 17.75 | 17.7143 | 17.7332 | 217644.0 |
| 2013-08-14 07:10:00 | AAPL | Stock | 17.7321 | 17.7339 | 17.7179 | 17.7321 | 156184.0 |
| 2013-08-14 07:15:00 | AAPL | Stock | 17.7321 | 17.7429 | 17.7214 | 17.7279 | 125580.0 |
| 2013-08-14 07:20:00 | AAPL | Stock | 17.7225 | 17.7311 | 17.7221 | 17.7264 | 31640.0 |
| 2013-08-14 07:25:00 | AAPL | Stock | 17.7264 | 17.7289 | 17.7179 | 17.72 | 161700.0 |
| 2013-08-14 07:30:00 | AAPL | Stock | 17.7257 | 17.7268 | 17.72 | 17.72 | 69076.0 |
| 2013-08-14 07:35:00 | AAPL | Stock | 17.7186 | 17.7189 | 17.6893 | 17.7004 | 365736.0 |
| 2013-08-14 07:40:00 | AAPL | Stock | 17.7 | 17.7421 | 17.7 | 17.7421 | 141036.0 |
| 2013-08-14 07:45:00 | AAPL | Stock | 17.7414 | 17.7539 | 17.7214 | 17.7236 | 466704.0 |
| 2013-08-14 07:50:00 | AAPL | Stock | 17.7293 | 17.7425 | 17.7286 | 17.7393 | 118020.0 |
| 2013-08-14 07:55:00 | AAPL | Stock | 17.7389 | 17.75 | 17.7268 | 17.7361 | 346304.0 |
| 2013-08-14 08:00:00 | AAPL | Stock | 17.7371 | 17.7589 | 17.4643 | 17.7236 | 1234184.0 |
| 2013-08-14 08:05:00 | AAPL | Stock | 17.725 | 17.7254 | 17.67 | 17.6893 | 1315860.0 |
| 2013-08-14 08:10:00 | AAPL | Stock | 17.6957 | 17.7179 | 17.6893 | 17.7086 | 917028.0 |
| 2013-08-14 08:15:00 | AAPL | Stock | 17.7068 | 17.7143 | 17.69 | 17.7143 | 669424.0 |
| 2013-08-14 08:20:00 | AAPL | Stock | 17.7139 | 17.7143 | 17.6539 | 17.6539 | 715204.0 |
| 2013-08-14 08:25:00 | AAPL | Stock | 17.6582 | 17.6582 | 17.6214 | 17.6293 | 774032.0 |
| 2013-08-14 08:30:00 | AAPL | Stock | 17.6225 | 17.6554 | 17.6193 | 17.6429 | 1008084.0 |
| 2013-08-14 08:35:00 | AAPL | Stock | 17.6379 | 17.6786 | 17.625 | 17.6507 | 479976.0 |
| 2013-08-14 08:40:00 | AAPL | Stock | 17.6507 | 17.6596 | 17.6429 | 17.645 | 343784.0 |
| 2013-08-14 08:45:00 | AAPL | Stock | 17.645 | 17.6571 | 17.645 | 17.6529 | 363412.0 |
| 2013-08-14 08:50:00 | AAPL | Stock | 17.6543 | 17.6786 | 17.6543 | 17.6771 | 863464.0 |
> showing 50 of 340,226 rows — these rows as CSV