PREVIEW / stock_5min / 2013-11-18
file: by_date/stock_5min/2013/2013-11-18.parquet size: 5.4 MB rows: 353,596 symbols: 3,557
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-11-18 04:00:00 | AAPL | Stock | 18.7496 | 18.7589 | 18.7496 | 18.7571 | 10500.0 |
| 2013-11-18 04:20:00 | AAPL | Stock | 18.7632 | 18.7632 | 18.7632 | 18.7632 | 2800.0 |
| 2013-11-18 04:40:00 | AAPL | Stock | 18.7789 | 18.7804 | 18.7789 | 18.7804 | 8400.0 |
| 2013-11-18 05:00:00 | AAPL | Stock | 18.7986 | 18.7986 | 18.7929 | 18.7929 | 8400.0 |
| 2013-11-18 05:55:00 | AAPL | Stock | 18.8011 | 18.8011 | 18.8011 | 18.8011 | 2800.0 |
| 2013-11-18 06:00:00 | AAPL | Stock | 18.7875 | 18.8175 | 18.7679 | 18.7679 | 198268.0 |
| 2013-11-18 06:05:00 | AAPL | Stock | 18.7682 | 18.7714 | 18.7682 | 18.7714 | 8400.0 |
| 2013-11-18 06:10:00 | AAPL | Stock | 18.7643 | 18.7643 | 18.7589 | 18.7589 | 5600.0 |
| 2013-11-18 06:15:00 | AAPL | Stock | 18.7571 | 18.7589 | 18.75 | 18.75 | 14000.0 |
| 2013-11-18 06:20:00 | AAPL | Stock | 18.7518 | 18.7518 | 18.7518 | 18.7518 | 2800.0 |
| 2013-11-18 06:35:00 | AAPL | Stock | 18.7507 | 18.7507 | 18.7143 | 18.7143 | 21084.0 |
| 2013-11-18 07:05:00 | AAPL | Stock | 18.7679 | 18.7768 | 18.7679 | 18.7679 | 14000.0 |
| 2013-11-18 07:10:00 | AAPL | Stock | 18.7807 | 18.8071 | 18.7807 | 18.7979 | 133000.0 |
| 2013-11-18 07:15:00 | AAPL | Stock | 18.7946 | 18.7946 | 18.7946 | 18.7946 | 12600.0 |
| 2013-11-18 07:20:00 | AAPL | Stock | 18.7907 | 18.8036 | 18.7907 | 18.8036 | 39200.0 |
| 2013-11-18 07:25:00 | AAPL | Stock | 18.81 | 18.8196 | 18.81 | 18.8196 | 70728.0 |
| 2013-11-18 07:30:00 | AAPL | Stock | 18.8257 | 18.8368 | 18.8257 | 18.8357 | 65100.0 |
| 2013-11-18 07:35:00 | AAPL | Stock | 18.8218 | 18.8218 | 18.8218 | 18.8218 | 5600.0 |
| 2013-11-18 07:50:00 | AAPL | Stock | 18.8114 | 18.8114 | 18.8114 | 18.8114 | 2800.0 |
| 2013-11-18 07:55:00 | AAPL | Stock | 18.8114 | 18.8143 | 18.8114 | 18.8143 | 22120.0 |
| 2013-11-18 08:00:00 | AAPL | Stock | 18.8036 | 18.8357 | 18.7143 | 18.7725 | 248948.0 |
| 2013-11-18 08:05:00 | AAPL | Stock | 18.7786 | 18.7786 | 18.7589 | 18.775 | 261408.0 |
| 2013-11-18 08:10:00 | AAPL | Stock | 18.7714 | 18.7732 | 18.7643 | 18.7711 | 53200.0 |
| 2013-11-18 08:15:00 | AAPL | Stock | 18.7711 | 18.7714 | 18.7646 | 18.7679 | 42840.0 |
| 2013-11-18 08:20:00 | AAPL | Stock | 18.7679 | 18.7714 | 18.7679 | 18.7679 | 112140.0 |
| 2013-11-18 08:25:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7529 | 18.7589 | 422240.0 |
| 2013-11-18 08:30:00 | AAPL | Stock | 18.7639 | 18.7675 | 18.7589 | 18.7589 | 127904.0 |
| 2013-11-18 08:35:00 | AAPL | Stock | 18.7589 | 18.7657 | 18.7589 | 18.7657 | 70420.0 |
| 2013-11-18 08:40:00 | AAPL | Stock | 18.7657 | 18.7757 | 18.7657 | 18.7757 | 67200.0 |
| 2013-11-18 08:45:00 | AAPL | Stock | 18.7718 | 18.7893 | 18.7718 | 18.7893 | 180320.0 |
| 2013-11-18 08:50:00 | AAPL | Stock | 18.7893 | 18.7964 | 18.7886 | 18.7964 | 79100.0 |
| 2013-11-18 08:55:00 | AAPL | Stock | 18.8011 | 18.8011 | 18.7929 | 18.795 | 36400.0 |
| 2013-11-18 09:00:00 | AAPL | Stock | 18.7893 | 18.7893 | 18.7893 | 18.7893 | 14000.0 |
| 2013-11-18 09:05:00 | AAPL | Stock | 18.7893 | 18.7943 | 18.7821 | 18.7821 | 96320.0 |
| 2013-11-18 09:10:00 | AAPL | Stock | 18.7857 | 18.7857 | 18.7821 | 18.7821 | 87920.0 |
| 2013-11-18 09:15:00 | AAPL | Stock | 18.7807 | 18.7814 | 18.78 | 18.7814 | 13720.0 |
| 2013-11-18 09:20:00 | AAPL | Stock | 18.7839 | 18.7911 | 18.7839 | 18.7911 | 81200.0 |
| 2013-11-18 09:25:00 | AAPL | Stock | 18.7857 | 18.7882 | 18.7482 | 18.7496 | 428092.0 |
| 2013-11-18 09:30:00 | AAPL | Stock | 18.7496 | 18.8282 | 18.7379 | 18.8232 | 11087916.0 |
| 2013-11-18 09:35:00 | AAPL | Stock | 18.8225 | 18.8282 | 18.7636 | 18.7764 | 5576648.0 |
| 2013-11-18 09:40:00 | AAPL | Stock | 18.7718 | 18.775 | 18.6964 | 18.7321 | 7457660.0 |
| 2013-11-18 09:45:00 | AAPL | Stock | 18.7354 | 18.7586 | 18.7311 | 18.7429 | 3897292.0 |
| 2013-11-18 09:50:00 | AAPL | Stock | 18.7425 | 18.7429 | 18.6789 | 18.68 | 4837588.0 |
| 2013-11-18 09:55:00 | AAPL | Stock | 18.6786 | 18.6918 | 18.6539 | 18.6679 | 4523764.0 |
| 2013-11-18 10:00:00 | AAPL | Stock | 18.668 | 18.6811 | 18.6571 | 18.6657 | 3400320.0 |
| 2013-11-18 10:05:00 | AAPL | Stock | 18.6611 | 18.6911 | 18.645 | 18.6743 | 4660656.0 |
| 2013-11-18 10:10:00 | AAPL | Stock | 18.675 | 18.6811 | 18.6482 | 18.6693 | 3248252.0 |
| 2013-11-18 10:15:00 | AAPL | Stock | 18.667 | 18.6714 | 18.6529 | 18.6664 | 1908200.0 |
| 2013-11-18 10:20:00 | AAPL | Stock | 18.6679 | 18.6993 | 18.6571 | 18.6607 | 3531304.0 |
| 2013-11-18 10:25:00 | AAPL | Stock | 18.6689 | 18.6689 | 18.6471 | 18.6627 | 3067400.0 |
> showing 50 of 353,596 rows — these rows as CSV