PREVIEW / stock_5min / 2011-02-14
file: by_date/stock_5min/2011/2011-02-14.parquet size: 4.9 MB rows: 330,455 symbols: 3,563
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-02-14 04:05:00 | AAPL | Stock | 12.7436 | 12.7436 | 12.7436 | 12.7436 | 5600.0 |
| 2011-02-14 04:15:00 | AAPL | Stock | 12.7439 | 12.7439 | 12.7439 | 12.7439 | 2800.0 |
| 2011-02-14 04:20:00 | AAPL | Stock | 12.7479 | 12.7479 | 12.7479 | 12.7479 | 2800.0 |
| 2011-02-14 04:25:00 | AAPL | Stock | 12.7475 | 12.7521 | 12.7475 | 12.7518 | 8400.0 |
| 2011-02-14 04:55:00 | AAPL | Stock | 12.7393 | 12.7393 | 12.7393 | 12.7393 | 2800.0 |
| 2011-02-14 05:00:00 | AAPL | Stock | 12.7396 | 12.7396 | 12.7396 | 12.7396 | 2800.0 |
| 2011-02-14 05:05:00 | AAPL | Stock | 12.7425 | 12.7425 | 12.7393 | 12.7393 | 11200.0 |
| 2011-02-14 05:25:00 | AAPL | Stock | 12.7393 | 12.7393 | 12.7393 | 12.7393 | 5600.0 |
| 2011-02-14 06:30:00 | AAPL | Stock | 12.7393 | 12.7393 | 12.7393 | 12.7393 | 2800.0 |
| 2011-02-14 06:35:00 | AAPL | Stock | 12.7636 | 12.7636 | 12.7636 | 12.7636 | 2800.0 |
| 2011-02-14 07:00:00 | AAPL | Stock | 12.7393 | 12.7393 | 12.7232 | 12.7232 | 25200.0 |
| 2011-02-14 07:05:00 | AAPL | Stock | 12.75 | 12.7529 | 12.75 | 12.7529 | 29400.0 |
| 2011-02-14 07:10:00 | AAPL | Stock | 12.7532 | 12.76 | 12.7532 | 12.76 | 17780.0 |
| 2011-02-14 07:15:00 | AAPL | Stock | 12.7639 | 12.7657 | 12.7625 | 12.7657 | 30520.0 |
| 2011-02-14 07:25:00 | AAPL | Stock | 12.7714 | 12.7714 | 12.7714 | 12.7714 | 2800.0 |
| 2011-02-14 07:30:00 | AAPL | Stock | 12.7829 | 12.7929 | 12.7829 | 12.7918 | 132720.0 |
| 2011-02-14 07:35:00 | AAPL | Stock | 12.7929 | 12.7996 | 12.7929 | 12.7996 | 138712.0 |
| 2011-02-14 07:40:00 | AAPL | Stock | 12.7907 | 12.7964 | 12.7768 | 12.7768 | 84728.0 |
| 2011-02-14 07:45:00 | AAPL | Stock | 12.7807 | 12.7807 | 12.7807 | 12.7807 | 11200.0 |
| 2011-02-14 07:50:00 | AAPL | Stock | 12.7682 | 12.7686 | 12.7682 | 12.7686 | 8400.0 |
| 2011-02-14 07:55:00 | AAPL | Stock | 12.775 | 12.775 | 12.7704 | 12.7704 | 12600.0 |
| 2011-02-14 08:00:00 | AAPL | Stock | 12.775 | 12.7768 | 12.7511 | 12.7604 | 335272.0 |
| 2011-02-14 08:05:00 | AAPL | Stock | 12.7596 | 12.7596 | 12.7486 | 12.7486 | 144200.0 |
| 2011-02-14 08:10:00 | AAPL | Stock | 12.7464 | 12.75 | 12.7429 | 12.75 | 160804.0 |
| 2011-02-14 08:15:00 | AAPL | Stock | 12.7486 | 12.7536 | 12.7421 | 12.7446 | 360640.0 |
| 2011-02-14 08:20:00 | AAPL | Stock | 12.745 | 12.75 | 12.74 | 12.7414 | 44800.0 |
| 2011-02-14 08:25:00 | AAPL | Stock | 12.75 | 12.7514 | 12.7482 | 12.75 | 38360.0 |
| 2011-02-14 08:30:00 | AAPL | Stock | 12.7482 | 12.7507 | 12.74 | 12.7429 | 72800.0 |
| 2011-02-14 08:35:00 | AAPL | Stock | 12.7446 | 12.7482 | 12.7429 | 12.7429 | 119840.0 |
| 2011-02-14 08:40:00 | AAPL | Stock | 12.7404 | 12.7404 | 12.7364 | 12.7396 | 74760.0 |
| 2011-02-14 08:45:00 | AAPL | Stock | 12.74 | 12.7443 | 12.7375 | 12.7443 | 128800.0 |
| 2011-02-14 08:50:00 | AAPL | Stock | 12.7496 | 12.7496 | 12.7421 | 12.7429 | 36400.0 |
| 2011-02-14 08:55:00 | AAPL | Stock | 12.7432 | 12.7493 | 12.7432 | 12.7482 | 25200.0 |
| 2011-02-14 09:00:00 | AAPL | Stock | 12.7482 | 12.7543 | 12.7482 | 12.75 | 225960.0 |
| 2011-02-14 09:05:00 | AAPL | Stock | 12.7525 | 12.7536 | 12.7493 | 12.75 | 187684.0 |
| 2011-02-14 09:10:00 | AAPL | Stock | 12.7482 | 12.7482 | 12.7454 | 12.7454 | 69244.0 |
| 2011-02-14 09:15:00 | AAPL | Stock | 12.75 | 12.75 | 12.7461 | 12.75 | 114296.0 |
| 2011-02-14 09:20:00 | AAPL | Stock | 12.7496 | 12.7496 | 12.7464 | 12.7482 | 63140.0 |
| 2011-02-14 09:25:00 | AAPL | Stock | 12.7471 | 12.75 | 12.7382 | 12.7382 | 456092.0 |
| 2011-02-14 09:30:00 | AAPL | Stock | 12.7436 | 12.8018 | 12.7396 | 12.8014 | 13909028.0 |
| 2011-02-14 09:35:00 | AAPL | Stock | 12.8004 | 12.8386 | 12.7971 | 12.8193 | 19747504.0 |
| 2011-02-14 09:40:00 | AAPL | Stock | 12.8189 | 12.8261 | 12.8036 | 12.8107 | 8597736.0 |
| 2011-02-14 09:45:00 | AAPL | Stock | 12.8111 | 12.8243 | 12.8082 | 12.8094 | 6676348.0 |
| 2011-02-14 09:50:00 | AAPL | Stock | 12.8089 | 12.8104 | 12.7871 | 12.8007 | 7892640.0 |
| 2011-02-14 09:55:00 | AAPL | Stock | 12.8004 | 12.8204 | 12.7996 | 12.8125 | 5597396.0 |
| 2011-02-14 10:00:00 | AAPL | Stock | 12.8136 | 12.8254 | 12.8107 | 12.8182 | 7151032.0 |
| 2011-02-14 10:05:00 | AAPL | Stock | 12.8164 | 12.8279 | 12.8054 | 12.8166 | 5312020.0 |
| 2011-02-14 10:10:00 | AAPL | Stock | 12.8166 | 12.8286 | 12.8139 | 12.822 | 5371156.0 |
| 2011-02-14 10:15:00 | AAPL | Stock | 12.8221 | 12.8314 | 12.8107 | 12.8236 | 5641356.0 |
| 2011-02-14 10:20:00 | AAPL | Stock | 12.8221 | 12.8321 | 12.8218 | 12.8296 | 3616732.0 |
> showing 50 of 330,455 rows — these rows as CSV