PREVIEW / stock_5min / 2014-04-09
file: by_date/stock_5min/2014/2014-04-09.parquet size: 5.4 MB rows: 359,464 symbols: 3,531
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-09 04:25:00 | AAPL | Stock | 18.7493 | 18.7493 | 18.7493 | 18.7493 | 2800.0 |
| 2014-04-09 07:20:00 | AAPL | Stock | 18.7736 | 18.7736 | 18.7736 | 18.7736 | 3836.0 |
| 2014-04-09 08:00:00 | AAPL | Stock | 18.7661 | 18.7675 | 18.745 | 18.7504 | 133588.0 |
| 2014-04-09 08:05:00 | AAPL | Stock | 18.7486 | 18.7543 | 18.7486 | 18.7543 | 17808.0 |
| 2014-04-09 08:10:00 | AAPL | Stock | 18.7604 | 18.7618 | 18.75 | 18.75 | 19936.0 |
| 2014-04-09 08:25:00 | AAPL | Stock | 18.7521 | 18.7546 | 18.75 | 18.7525 | 16800.0 |
| 2014-04-09 08:30:00 | AAPL | Stock | 18.7439 | 18.7439 | 18.7321 | 18.7321 | 58800.0 |
| 2014-04-09 08:35:00 | AAPL | Stock | 18.7286 | 18.7386 | 18.7257 | 18.7325 | 67844.0 |
| 2014-04-09 08:40:00 | AAPL | Stock | 18.7461 | 18.7461 | 18.7329 | 18.7332 | 37800.0 |
| 2014-04-09 08:45:00 | AAPL | Stock | 18.7239 | 18.7354 | 18.7218 | 18.7354 | 137620.0 |
| 2014-04-09 08:50:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7146 | 18.7154 | 35980.0 |
| 2014-04-09 08:55:00 | AAPL | Stock | 18.715 | 18.715 | 18.7139 | 18.715 | 52976.0 |
| 2014-04-09 09:00:00 | AAPL | Stock | 18.7196 | 18.73 | 18.7007 | 18.7061 | 74760.0 |
| 2014-04-09 09:05:00 | AAPL | Stock | 18.7071 | 18.7086 | 18.6771 | 18.68 | 121660.0 |
| 2014-04-09 09:10:00 | AAPL | Stock | 18.6804 | 18.6979 | 18.6796 | 18.6979 | 46900.0 |
| 2014-04-09 09:15:00 | AAPL | Stock | 18.6986 | 18.6986 | 18.6914 | 18.6918 | 84280.0 |
| 2014-04-09 09:20:00 | AAPL | Stock | 18.6939 | 18.7086 | 18.6939 | 18.7086 | 48244.0 |
| 2014-04-09 09:25:00 | AAPL | Stock | 18.6996 | 18.7046 | 18.6643 | 18.6707 | 302932.0 |
| 2014-04-09 09:30:00 | AAPL | Stock | 18.6625 | 18.7082 | 18.6436 | 18.6764 | 8997660.0 |
| 2014-04-09 09:35:00 | AAPL | Stock | 18.6785 | 18.7175 | 18.6686 | 18.7109 | 5460532.0 |
| 2014-04-09 09:40:00 | AAPL | Stock | 18.7098 | 18.7282 | 18.6904 | 18.7111 | 4386592.0 |
| 2014-04-09 09:45:00 | AAPL | Stock | 18.7121 | 18.8111 | 18.7082 | 18.7768 | 7685944.0 |
| 2014-04-09 09:50:00 | AAPL | Stock | 18.7786 | 18.7929 | 18.75 | 18.7864 | 3987872.0 |
| 2014-04-09 09:55:00 | AAPL | Stock | 18.7864 | 18.8089 | 18.7507 | 18.7507 | 3554516.0 |
| 2014-04-09 10:00:00 | AAPL | Stock | 18.7539 | 18.7761 | 18.725 | 18.7318 | 3128944.0 |
| 2014-04-09 10:05:00 | AAPL | Stock | 18.7321 | 18.7369 | 18.7082 | 18.7089 | 2556596.0 |
| 2014-04-09 10:10:00 | AAPL | Stock | 18.7104 | 18.7196 | 18.6993 | 18.7154 | 2003484.0 |
| 2014-04-09 10:15:00 | AAPL | Stock | 18.7093 | 18.7571 | 18.7093 | 18.7482 | 1880648.0 |
| 2014-04-09 10:20:00 | AAPL | Stock | 18.7482 | 18.7807 | 18.7482 | 18.7644 | 2927400.0 |
| 2014-04-09 10:25:00 | AAPL | Stock | 18.7692 | 18.7693 | 18.7325 | 18.7357 | 3333568.0 |
| 2014-04-09 10:30:00 | AAPL | Stock | 18.7361 | 18.7561 | 18.7261 | 18.7514 | 2573900.0 |
| 2014-04-09 10:35:00 | AAPL | Stock | 18.75 | 18.775 | 18.75 | 18.7533 | 2310588.0 |
| 2014-04-09 10:40:00 | AAPL | Stock | 18.7524 | 18.7657 | 18.7496 | 18.7596 | 1028972.0 |
| 2014-04-09 10:45:00 | AAPL | Stock | 18.7579 | 18.7786 | 18.7543 | 18.7786 | 1438612.0 |
| 2014-04-09 10:50:00 | AAPL | Stock | 18.7786 | 18.7971 | 18.7743 | 18.7818 | 2300816.0 |
| 2014-04-09 10:55:00 | AAPL | Stock | 18.7804 | 18.835 | 18.7804 | 18.8208 | 4962692.0 |
| 2014-04-09 11:00:00 | AAPL | Stock | 18.8214 | 18.8264 | 18.8018 | 18.8137 | 1928528.0 |
| 2014-04-09 11:05:00 | AAPL | Stock | 18.8161 | 18.8424 | 18.8161 | 18.8393 | 2167032.0 |
| 2014-04-09 11:10:00 | AAPL | Stock | 18.8389 | 18.8396 | 18.8154 | 18.8197 | 2076844.0 |
| 2014-04-09 11:15:00 | AAPL | Stock | 18.82 | 18.8429 | 18.82 | 18.84 | 1464092.0 |
| 2014-04-09 11:20:00 | AAPL | Stock | 18.8418 | 18.8571 | 18.835 | 18.8482 | 1617168.0 |
| 2014-04-09 11:25:00 | AAPL | Stock | 18.8486 | 18.8579 | 18.8454 | 18.8468 | 1625848.0 |
| 2014-04-09 11:30:00 | AAPL | Stock | 18.8468 | 18.8546 | 18.829 | 18.8344 | 1730988.0 |
| 2014-04-09 11:35:00 | AAPL | Stock | 18.8364 | 18.85 | 18.8271 | 18.8279 | 956060.0 |
| 2014-04-09 11:40:00 | AAPL | Stock | 18.8336 | 18.8414 | 18.8257 | 18.8261 | 891352.0 |
| 2014-04-09 11:45:00 | AAPL | Stock | 18.8261 | 18.8307 | 18.8218 | 18.825 | 1032752.0 |
| 2014-04-09 11:50:00 | AAPL | Stock | 18.8243 | 18.8382 | 18.8214 | 18.8268 | 1126356.0 |
| 2014-04-09 11:55:00 | AAPL | Stock | 18.8225 | 18.8318 | 18.8139 | 18.8139 | 856324.0 |
| 2014-04-09 12:00:00 | AAPL | Stock | 18.8146 | 18.8164 | 18.7968 | 18.8132 | 1037988.0 |
| 2014-04-09 12:05:00 | AAPL | Stock | 18.8104 | 18.8241 | 18.8083 | 18.8196 | 1093120.0 |
> showing 50 of 359,464 rows — these rows as CSV