PREVIEW / stock_5min / 2011-12-19
file: by_date/stock_5min/2011/2011-12-19.parquet size: 4.8 MB rows: 324,148 symbols: 3,535
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-12-19 05:35:00 | AAPL | Stock | 13.6571 | 13.6571 | 13.6571 | 13.6571 | 2800.0 |
| 2011-12-19 05:45:00 | AAPL | Stock | 13.6507 | 13.6507 | 13.6507 | 13.6507 | 2800.0 |
| 2011-12-19 05:50:00 | AAPL | Stock | 13.6507 | 13.6507 | 13.6507 | 13.6507 | 2800.0 |
| 2011-12-19 06:55:00 | AAPL | Stock | 13.6557 | 13.6557 | 13.6557 | 13.6557 | 2800.0 |
| 2011-12-19 07:00:00 | AAPL | Stock | 13.6786 | 13.6786 | 13.6786 | 13.6786 | 28000.0 |
| 2011-12-19 07:05:00 | AAPL | Stock | 13.6679 | 13.6679 | 13.6429 | 13.6579 | 33600.0 |
| 2011-12-19 07:10:00 | AAPL | Stock | 13.6579 | 13.6679 | 13.6579 | 13.6679 | 14000.0 |
| 2011-12-19 07:15:00 | AAPL | Stock | 13.6761 | 13.6761 | 13.6761 | 13.6761 | 4200.0 |
| 2011-12-19 07:20:00 | AAPL | Stock | 13.6625 | 13.6625 | 13.6607 | 13.6607 | 22484.0 |
| 2011-12-19 07:30:00 | AAPL | Stock | 13.6675 | 13.6679 | 13.6675 | 13.6679 | 8400.0 |
| 2011-12-19 07:35:00 | AAPL | Stock | 13.6714 | 13.6714 | 13.6679 | 13.6679 | 5600.0 |
| 2011-12-19 07:40:00 | AAPL | Stock | 13.6782 | 13.6782 | 13.6782 | 13.6782 | 2800.0 |
| 2011-12-19 07:45:00 | AAPL | Stock | 13.6721 | 13.6721 | 13.665 | 13.665 | 16800.0 |
| 2011-12-19 07:50:00 | AAPL | Stock | 13.6571 | 13.6571 | 13.6571 | 13.6571 | 2800.0 |
| 2011-12-19 07:55:00 | AAPL | Stock | 13.6511 | 13.6575 | 13.6479 | 13.6518 | 94080.0 |
| 2011-12-19 08:00:00 | AAPL | Stock | 13.6457 | 13.6518 | 13.625 | 13.625 | 101276.0 |
| 2011-12-19 08:05:00 | AAPL | Stock | 13.625 | 13.6429 | 13.625 | 13.6429 | 137116.0 |
| 2011-12-19 08:10:00 | AAPL | Stock | 13.6375 | 13.6518 | 13.6375 | 13.6518 | 56840.0 |
| 2011-12-19 08:15:00 | AAPL | Stock | 13.6518 | 13.6518 | 13.6375 | 13.6375 | 11424.0 |
| 2011-12-19 08:20:00 | AAPL | Stock | 13.6393 | 13.6468 | 13.6393 | 13.6429 | 52780.0 |
| 2011-12-19 08:25:00 | AAPL | Stock | 13.6504 | 13.6589 | 13.6482 | 13.6589 | 11200.0 |
| 2011-12-19 08:30:00 | AAPL | Stock | 13.6571 | 13.6643 | 13.6571 | 13.6571 | 57540.0 |
| 2011-12-19 08:35:00 | AAPL | Stock | 13.6536 | 13.6668 | 13.6536 | 13.6607 | 77896.0 |
| 2011-12-19 08:40:00 | AAPL | Stock | 13.6607 | 13.6643 | 13.6432 | 13.6432 | 73136.0 |
| 2011-12-19 08:45:00 | AAPL | Stock | 13.6582 | 13.6582 | 13.6529 | 13.6529 | 41860.0 |
| 2011-12-19 08:50:00 | AAPL | Stock | 13.6571 | 13.6654 | 13.6571 | 13.66 | 73640.0 |
| 2011-12-19 08:55:00 | AAPL | Stock | 13.6675 | 13.6675 | 13.6571 | 13.6571 | 51352.0 |
| 2011-12-19 09:00:00 | AAPL | Stock | 13.6607 | 13.6607 | 13.6607 | 13.6607 | 15400.0 |
| 2011-12-19 09:05:00 | AAPL | Stock | 13.6571 | 13.66 | 13.6518 | 13.6571 | 87696.0 |
| 2011-12-19 09:10:00 | AAPL | Stock | 13.6518 | 13.6518 | 13.65 | 13.65 | 16800.0 |
| 2011-12-19 09:15:00 | AAPL | Stock | 13.66 | 13.66 | 13.6454 | 13.6454 | 60200.0 |
| 2011-12-19 09:20:00 | AAPL | Stock | 13.6493 | 13.6557 | 13.6489 | 13.6557 | 30800.0 |
| 2011-12-19 09:25:00 | AAPL | Stock | 13.655 | 13.6593 | 13.6493 | 13.6593 | 107968.0 |
| 2011-12-19 09:30:00 | AAPL | Stock | 13.6593 | 13.7243 | 13.6593 | 13.7089 | 10231676.0 |
| 2011-12-19 09:35:00 | AAPL | Stock | 13.7107 | 13.7129 | 13.6811 | 13.6907 | 5961704.0 |
| 2011-12-19 09:40:00 | AAPL | Stock | 13.6925 | 13.7143 | 13.6917 | 13.7007 | 3168312.0 |
| 2011-12-19 09:45:00 | AAPL | Stock | 13.7011 | 13.7125 | 13.6886 | 13.7018 | 4923212.0 |
| 2011-12-19 09:50:00 | AAPL | Stock | 13.7032 | 13.7054 | 13.68 | 13.6914 | 3653384.0 |
| 2011-12-19 09:55:00 | AAPL | Stock | 13.69 | 13.7446 | 13.6896 | 13.7405 | 6853000.0 |
| 2011-12-19 10:00:00 | AAPL | Stock | 13.7407 | 13.7425 | 13.7082 | 13.7179 | 4370240.0 |
| 2011-12-19 10:05:00 | AAPL | Stock | 13.7175 | 13.7229 | 13.6996 | 13.7136 | 3054436.0 |
| 2011-12-19 10:10:00 | AAPL | Stock | 13.7168 | 13.7229 | 13.7039 | 13.7134 | 2855804.0 |
| 2011-12-19 10:15:00 | AAPL | Stock | 13.7159 | 13.7271 | 13.6982 | 13.7032 | 3404716.0 |
| 2011-12-19 10:20:00 | AAPL | Stock | 13.7096 | 13.7121 | 13.6861 | 13.6914 | 3536680.0 |
| 2011-12-19 10:25:00 | AAPL | Stock | 13.6924 | 13.7082 | 13.6887 | 13.705 | 1719956.0 |
| 2011-12-19 10:30:00 | AAPL | Stock | 13.7057 | 13.7179 | 13.7025 | 13.7146 | 2427992.0 |
| 2011-12-19 10:35:00 | AAPL | Stock | 13.7144 | 13.723 | 13.7071 | 13.7146 | 2649528.0 |
| 2011-12-19 10:40:00 | AAPL | Stock | 13.7146 | 13.7157 | 13.6929 | 13.6932 | 1676528.0 |
| 2011-12-19 10:45:00 | AAPL | Stock | 13.6961 | 13.6961 | 13.6754 | 13.6796 | 5160568.0 |
| 2011-12-19 10:50:00 | AAPL | Stock | 13.6796 | 13.6939 | 13.6775 | 13.6902 | 2798740.0 |
> showing 50 of 324,148 rows — these rows as CSV