PREVIEW / stock_5min / 2013-05-01
file: by_date/stock_5min/2013/2013-05-01.parquet size: 5.2 MB rows: 344,579 symbols: 3,479
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-05-01 05:45:00 | AAPL | Stock | 15.8332 | 15.8332 | 15.8332 | 15.8332 | 12180.0 |
| 2013-05-01 06:50:00 | AAPL | Stock | 15.855 | 15.855 | 15.855 | 15.855 | 2800.0 |
| 2013-05-01 07:00:00 | AAPL | Stock | 15.8429 | 15.8786 | 15.8429 | 15.8786 | 46200.0 |
| 2013-05-01 07:05:00 | AAPL | Stock | 15.8839 | 15.9107 | 15.8614 | 15.8614 | 121856.0 |
| 2013-05-01 07:10:00 | AAPL | Stock | 15.8743 | 15.8929 | 15.8618 | 15.8654 | 63840.0 |
| 2013-05-01 07:15:00 | AAPL | Stock | 15.8679 | 15.8679 | 15.8679 | 15.8679 | 11032.0 |
| 2013-05-01 07:20:00 | AAPL | Stock | 15.8911 | 15.8911 | 15.8911 | 15.8911 | 2800.0 |
| 2013-05-01 07:25:00 | AAPL | Stock | 15.875 | 15.9086 | 15.875 | 15.9046 | 145600.0 |
| 2013-05-01 07:30:00 | AAPL | Stock | 15.9118 | 15.9421 | 15.9118 | 15.9332 | 133252.0 |
| 2013-05-01 07:35:00 | AAPL | Stock | 15.9229 | 15.9229 | 15.8786 | 15.8786 | 78120.0 |
| 2013-05-01 07:40:00 | AAPL | Stock | 15.8786 | 15.9064 | 15.8693 | 15.8904 | 93492.0 |
| 2013-05-01 07:45:00 | AAPL | Stock | 15.9082 | 15.9282 | 15.9071 | 15.9282 | 140140.0 |
| 2013-05-01 07:50:00 | AAPL | Stock | 15.9229 | 15.9229 | 15.9071 | 15.9086 | 114240.0 |
| 2013-05-01 07:55:00 | AAPL | Stock | 15.9107 | 15.9111 | 15.8904 | 15.9086 | 180768.0 |
| 2013-05-01 08:00:00 | AAPL | Stock | 15.9107 | 15.9286 | 15.8693 | 15.8968 | 927136.0 |
| 2013-05-01 08:05:00 | AAPL | Stock | 15.9007 | 15.9054 | 15.8936 | 15.9011 | 179872.0 |
| 2013-05-01 08:10:00 | AAPL | Stock | 15.9011 | 15.905 | 15.8957 | 15.8957 | 92316.0 |
| 2013-05-01 08:15:00 | AAPL | Stock | 15.8964 | 15.8964 | 15.8764 | 15.8875 | 348964.0 |
| 2013-05-01 08:20:00 | AAPL | Stock | 15.88 | 15.8989 | 15.8754 | 15.8929 | 299600.0 |
| 2013-05-01 08:25:00 | AAPL | Stock | 15.8929 | 15.9086 | 15.8929 | 15.8986 | 64736.0 |
| 2013-05-01 08:30:00 | AAPL | Stock | 15.8989 | 15.9082 | 15.8929 | 15.8929 | 222824.0 |
| 2013-05-01 08:35:00 | AAPL | Stock | 15.8929 | 15.9068 | 15.89 | 15.9011 | 182028.0 |
| 2013-05-01 08:40:00 | AAPL | Stock | 15.9036 | 15.905 | 15.8857 | 15.8857 | 358316.0 |
| 2013-05-01 08:45:00 | AAPL | Stock | 15.8857 | 15.895 | 15.8789 | 15.8789 | 225120.0 |
| 2013-05-01 08:50:00 | AAPL | Stock | 15.8786 | 15.8821 | 15.8575 | 15.8714 | 583072.0 |
| 2013-05-01 08:55:00 | AAPL | Stock | 15.8718 | 15.8764 | 15.8196 | 15.8279 | 688100.0 |
| 2013-05-01 09:00:00 | AAPL | Stock | 15.8321 | 15.8414 | 15.8211 | 15.8339 | 297836.0 |
| 2013-05-01 09:05:00 | AAPL | Stock | 15.8364 | 15.8482 | 15.8043 | 15.8293 | 363300.0 |
| 2013-05-01 09:10:00 | AAPL | Stock | 15.8232 | 15.8311 | 15.8196 | 15.8232 | 322840.0 |
| 2013-05-01 09:15:00 | AAPL | Stock | 15.8296 | 15.8304 | 15.8189 | 15.8293 | 440020.0 |
| 2013-05-01 09:20:00 | AAPL | Stock | 15.8314 | 15.8379 | 15.8154 | 15.8211 | 283052.0 |
| 2013-05-01 09:25:00 | AAPL | Stock | 15.8225 | 15.8821 | 15.8207 | 15.875 | 1164464.0 |
| 2013-05-01 09:30:00 | AAPL | Stock | 15.875 | 15.8904 | 15.8025 | 15.8571 | 23862020.0 |
| 2013-05-01 09:35:00 | AAPL | Stock | 15.8564 | 15.8589 | 15.7614 | 15.7791 | 16213400.0 |
| 2013-05-01 09:40:00 | AAPL | Stock | 15.7836 | 15.7968 | 15.7221 | 15.7943 | 17785012.0 |
| 2013-05-01 09:45:00 | AAPL | Stock | 15.7921 | 15.8171 | 15.7629 | 15.7757 | 10786440.0 |
| 2013-05-01 09:50:00 | AAPL | Stock | 15.7821 | 15.7821 | 15.7071 | 15.7071 | 11106368.0 |
| 2013-05-01 09:55:00 | AAPL | Stock | 15.7089 | 15.7118 | 15.6575 | 15.7054 | 17385060.0 |
| 2013-05-01 10:00:00 | AAPL | Stock | 15.7054 | 15.75 | 15.6725 | 15.6725 | 12530812.0 |
| 2013-05-01 10:05:00 | AAPL | Stock | 15.6725 | 15.7143 | 15.6723 | 15.6782 | 5852560.0 |
| 2013-05-01 10:10:00 | AAPL | Stock | 15.6757 | 15.6957 | 15.6125 | 15.6136 | 12243392.0 |
| 2013-05-01 10:15:00 | AAPL | Stock | 15.6136 | 15.6371 | 15.5554 | 15.5725 | 17232852.0 |
| 2013-05-01 10:20:00 | AAPL | Stock | 15.5727 | 15.6179 | 15.5429 | 15.6127 | 12180868.0 |
| 2013-05-01 10:25:00 | AAPL | Stock | 15.6181 | 15.6225 | 15.5825 | 15.6071 | 6726720.0 |
| 2013-05-01 10:30:00 | AAPL | Stock | 15.6041 | 15.6071 | 15.55 | 15.5611 | 9663024.0 |
| 2013-05-01 10:35:00 | AAPL | Stock | 15.5643 | 15.5793 | 15.5139 | 15.5779 | 13297340.0 |
| 2013-05-01 10:40:00 | AAPL | Stock | 15.5775 | 15.6196 | 15.5739 | 15.6082 | 8590148.0 |
| 2013-05-01 10:45:00 | AAPL | Stock | 15.6082 | 15.6564 | 15.6071 | 15.6382 | 10978968.0 |
| 2013-05-01 10:50:00 | AAPL | Stock | 15.6321 | 15.6675 | 15.6154 | 15.6664 | 8260560.0 |
| 2013-05-01 10:55:00 | AAPL | Stock | 15.6618 | 15.7071 | 15.6618 | 15.6971 | 10571960.0 |
> showing 50 of 344,579 rows — these rows as CSV