PREVIEW / stock_5min / 2012-12-20
file: by_date/stock_5min/2012/2012-12-20.parquet size: 5.0 MB rows: 337,121 symbols: 3,498
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-20 05:15:00 | AAPL | Stock | 18.8393 | 18.8661 | 18.8393 | 18.8661 | 32200.0 |
| 2012-12-20 05:20:00 | AAPL | Stock | 18.8661 | 18.8661 | 18.8661 | 18.8661 | 2800.0 |
| 2012-12-20 05:25:00 | AAPL | Stock | 18.8661 | 18.8661 | 18.8661 | 18.8661 | 18200.0 |
| 2012-12-20 05:55:00 | AAPL | Stock | 18.875 | 18.875 | 18.8661 | 18.8661 | 11200.0 |
| 2012-12-20 06:10:00 | AAPL | Stock | 18.8821 | 18.8821 | 18.8821 | 18.8821 | 2800.0 |
| 2012-12-20 06:50:00 | AAPL | Stock | 18.8914 | 18.8914 | 18.8914 | 18.8914 | 2800.0 |
| 2012-12-20 07:00:00 | AAPL | Stock | 18.9232 | 18.9261 | 18.9179 | 18.9246 | 39200.0 |
| 2012-12-20 07:05:00 | AAPL | Stock | 18.9107 | 18.9107 | 18.8929 | 18.8932 | 47600.0 |
| 2012-12-20 07:10:00 | AAPL | Stock | 18.91 | 18.91 | 18.91 | 18.91 | 2800.0 |
| 2012-12-20 07:15:00 | AAPL | Stock | 18.9243 | 18.925 | 18.9107 | 18.9107 | 27020.0 |
| 2012-12-20 07:20:00 | AAPL | Stock | 18.9107 | 18.9107 | 18.9107 | 18.9107 | 2800.0 |
| 2012-12-20 07:25:00 | AAPL | Stock | 18.895 | 18.895 | 18.8893 | 18.8893 | 31500.0 |
| 2012-12-20 07:30:00 | AAPL | Stock | 18.8896 | 18.8896 | 18.8839 | 18.8839 | 30800.0 |
| 2012-12-20 07:35:00 | AAPL | Stock | 18.8786 | 18.8786 | 18.8532 | 18.8575 | 66080.0 |
| 2012-12-20 07:40:00 | AAPL | Stock | 18.8579 | 18.8661 | 18.8393 | 18.8393 | 44744.0 |
| 2012-12-20 07:45:00 | AAPL | Stock | 18.8479 | 18.8479 | 18.8321 | 18.8321 | 36400.0 |
| 2012-12-20 07:50:00 | AAPL | Stock | 18.8321 | 18.8321 | 18.7932 | 18.7932 | 154252.0 |
| 2012-12-20 07:55:00 | AAPL | Stock | 18.7939 | 18.8232 | 18.7939 | 18.8214 | 67396.0 |
| 2012-12-20 08:00:00 | AAPL | Stock | 18.9107 | 18.9107 | 18.7668 | 18.7786 | 322476.0 |
| 2012-12-20 08:05:00 | AAPL | Stock | 18.7718 | 18.8114 | 18.7718 | 18.8114 | 189140.0 |
| 2012-12-20 08:10:00 | AAPL | Stock | 18.8161 | 18.8179 | 18.7914 | 18.7914 | 101892.0 |
| 2012-12-20 08:15:00 | AAPL | Stock | 18.7914 | 18.7975 | 18.7818 | 18.7857 | 116480.0 |
| 2012-12-20 08:20:00 | AAPL | Stock | 18.7857 | 18.8107 | 18.7857 | 18.8068 | 155372.0 |
| 2012-12-20 08:25:00 | AAPL | Stock | 18.8057 | 18.8125 | 18.7929 | 18.7964 | 120932.0 |
| 2012-12-20 08:30:00 | AAPL | Stock | 18.7886 | 18.8343 | 18.7886 | 18.8343 | 239764.0 |
| 2012-12-20 08:35:00 | AAPL | Stock | 18.8389 | 18.8389 | 18.8179 | 18.8214 | 207816.0 |
| 2012-12-20 08:40:00 | AAPL | Stock | 18.8271 | 18.8393 | 18.8214 | 18.8339 | 154196.0 |
| 2012-12-20 08:45:00 | AAPL | Stock | 18.8339 | 18.8536 | 18.8321 | 18.85 | 222040.0 |
| 2012-12-20 08:50:00 | AAPL | Stock | 18.8518 | 18.9107 | 18.85 | 18.9107 | 448560.0 |
| 2012-12-20 08:55:00 | AAPL | Stock | 18.9086 | 18.9161 | 18.8968 | 18.9121 | 232204.0 |
| 2012-12-20 09:00:00 | AAPL | Stock | 18.9139 | 18.9568 | 18.9125 | 18.9425 | 528864.0 |
| 2012-12-20 09:05:00 | AAPL | Stock | 18.9325 | 18.9368 | 18.9282 | 18.9286 | 386316.0 |
| 2012-12-20 09:10:00 | AAPL | Stock | 18.9289 | 18.9343 | 18.9018 | 18.9093 | 395752.0 |
| 2012-12-20 09:15:00 | AAPL | Stock | 18.9032 | 18.9321 | 18.9018 | 18.9321 | 277256.0 |
| 2012-12-20 09:20:00 | AAPL | Stock | 18.9168 | 18.9196 | 18.9 | 18.9 | 108136.0 |
| 2012-12-20 09:25:00 | AAPL | Stock | 18.8961 | 18.9404 | 18.8929 | 18.9268 | 597492.0 |
| 2012-12-20 09:30:00 | AAPL | Stock | 18.9325 | 18.9357 | 18.8118 | 18.8196 | 14996744.0 |
| 2012-12-20 09:35:00 | AAPL | Stock | 18.8151 | 18.8457 | 18.7291 | 18.7482 | 12971756.0 |
| 2012-12-20 09:40:00 | AAPL | Stock | 18.7404 | 18.7854 | 18.6821 | 18.6981 | 11581808.0 |
| 2012-12-20 09:45:00 | AAPL | Stock | 18.7038 | 18.7204 | 18.6493 | 18.7164 | 12910604.0 |
| 2012-12-20 09:50:00 | AAPL | Stock | 18.7171 | 18.7596 | 18.7011 | 18.7086 | 11132352.0 |
| 2012-12-20 09:55:00 | AAPL | Stock | 18.7104 | 18.7196 | 18.6876 | 18.7136 | 6093976.0 |
| 2012-12-20 10:00:00 | AAPL | Stock | 18.7107 | 18.8068 | 18.6921 | 18.8018 | 11879364.0 |
| 2012-12-20 10:05:00 | AAPL | Stock | 18.8004 | 18.8536 | 18.7714 | 18.8343 | 11253592.0 |
| 2012-12-20 10:10:00 | AAPL | Stock | 18.835 | 18.8532 | 18.7929 | 18.8166 | 6842696.0 |
| 2012-12-20 10:15:00 | AAPL | Stock | 18.8144 | 18.8354 | 18.7707 | 18.7895 | 4473056.0 |
| 2012-12-20 10:20:00 | AAPL | Stock | 18.7886 | 18.7918 | 18.7071 | 18.7254 | 7991592.0 |
| 2012-12-20 10:25:00 | AAPL | Stock | 18.7251 | 18.7511 | 18.7154 | 18.7179 | 4464264.0 |
| 2012-12-20 10:30:00 | AAPL | Stock | 18.7193 | 18.7286 | 18.6786 | 18.7254 | 6697404.0 |
| 2012-12-20 10:35:00 | AAPL | Stock | 18.7243 | 18.7693 | 18.7161 | 18.7429 | 5222952.0 |
> showing 50 of 337,121 rows — these rows as CSV