PREVIEW / stock_5min / 2012-09-12
file: by_date/stock_5min/2012/2012-09-12.parquet size: 4.6 MB rows: 312,432 symbols: 3,466
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-09-12 04:00:00 | AAPL | Stock | 23.7507 | 23.7507 | 23.75 | 23.75 | 25200.0 |
| 2012-09-12 04:05:00 | AAPL | Stock | 23.75 | 23.7504 | 23.7496 | 23.7496 | 11200.0 |
| 2012-09-12 04:10:00 | AAPL | Stock | 23.7218 | 23.7321 | 23.7218 | 23.7321 | 16800.0 |
| 2012-09-12 04:15:00 | AAPL | Stock | 23.7321 | 23.75 | 23.7061 | 23.75 | 28000.0 |
| 2012-09-12 04:20:00 | AAPL | Stock | 23.7679 | 23.7679 | 23.7679 | 23.7679 | 16800.0 |
| 2012-09-12 04:25:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 2800.0 |
| 2012-09-12 04:30:00 | AAPL | Stock | 23.7561 | 23.7564 | 23.7561 | 23.7564 | 5600.0 |
| 2012-09-12 04:35:00 | AAPL | Stock | 23.785 | 23.785 | 23.785 | 23.785 | 2800.0 |
| 2012-09-12 04:40:00 | AAPL | Stock | 23.7857 | 23.7857 | 23.7857 | 23.7857 | 26180.0 |
| 2012-09-12 05:10:00 | AAPL | Stock | 23.7857 | 23.8029 | 23.7857 | 23.8029 | 5600.0 |
| 2012-09-12 05:15:00 | AAPL | Stock | 23.8025 | 23.8032 | 23.8025 | 23.8032 | 5600.0 |
| 2012-09-12 05:25:00 | AAPL | Stock | 23.8036 | 23.8036 | 23.8036 | 23.8036 | 18200.0 |
| 2012-09-12 05:30:00 | AAPL | Stock | 23.8193 | 23.8193 | 23.8193 | 23.8193 | 2800.0 |
| 2012-09-12 05:35:00 | AAPL | Stock | 23.8043 | 23.8043 | 23.7893 | 23.7893 | 11844.0 |
| 2012-09-12 05:40:00 | AAPL | Stock | 23.8029 | 23.8036 | 23.8029 | 23.8036 | 11200.0 |
| 2012-09-12 05:45:00 | AAPL | Stock | 23.8454 | 23.8568 | 23.8454 | 23.8568 | 8400.0 |
| 2012-09-12 05:50:00 | AAPL | Stock | 23.8568 | 23.8568 | 23.8568 | 23.8568 | 2800.0 |
| 2012-09-12 05:55:00 | AAPL | Stock | 23.8532 | 23.8532 | 23.8532 | 23.8532 | 11200.0 |
| 2012-09-12 06:05:00 | AAPL | Stock | 23.8393 | 23.8393 | 23.8393 | 23.8393 | 2800.0 |
| 2012-09-12 06:15:00 | AAPL | Stock | 23.8393 | 23.8429 | 23.8393 | 23.8429 | 5600.0 |
| 2012-09-12 06:25:00 | AAPL | Stock | 23.8286 | 23.8286 | 23.8286 | 23.8286 | 4312.0 |
| 2012-09-12 06:30:00 | AAPL | Stock | 23.8421 | 23.8429 | 23.8421 | 23.8429 | 16800.0 |
| 2012-09-12 06:35:00 | AAPL | Stock | 23.8286 | 23.8286 | 23.8214 | 23.8214 | 16800.0 |
| 2012-09-12 06:45:00 | AAPL | Stock | 23.8214 | 23.8214 | 23.8214 | 23.8214 | 5600.0 |
| 2012-09-12 06:55:00 | AAPL | Stock | 23.7861 | 23.7861 | 23.7857 | 23.7857 | 35616.0 |
| 2012-09-12 07:00:00 | AAPL | Stock | 23.8089 | 23.8393 | 23.8071 | 23.8107 | 306264.0 |
| 2012-09-12 07:05:00 | AAPL | Stock | 23.8039 | 23.8039 | 23.75 | 23.75 | 127876.0 |
| 2012-09-12 07:10:00 | AAPL | Stock | 23.75 | 23.7679 | 23.75 | 23.7607 | 127792.0 |
| 2012-09-12 07:15:00 | AAPL | Stock | 23.7682 | 23.8061 | 23.7679 | 23.7857 | 103320.0 |
| 2012-09-12 07:20:00 | AAPL | Stock | 23.7857 | 23.7914 | 23.7857 | 23.7875 | 33600.0 |
| 2012-09-12 07:25:00 | AAPL | Stock | 23.7854 | 23.7854 | 23.7768 | 23.7768 | 21056.0 |
| 2012-09-12 07:35:00 | AAPL | Stock | 23.7714 | 23.7714 | 23.75 | 23.75 | 62524.0 |
| 2012-09-12 07:40:00 | AAPL | Stock | 23.7539 | 23.7679 | 23.7271 | 23.7271 | 94612.0 |
| 2012-09-12 07:45:00 | AAPL | Stock | 23.7318 | 23.7318 | 23.7196 | 23.7243 | 53816.0 |
| 2012-09-12 07:50:00 | AAPL | Stock | 23.7232 | 23.7286 | 23.7179 | 23.7214 | 73668.0 |
| 2012-09-12 07:55:00 | AAPL | Stock | 23.7186 | 23.7186 | 23.7132 | 23.7139 | 58744.0 |
| 2012-09-12 08:00:00 | AAPL | Stock | 23.7143 | 23.8125 | 23.7107 | 23.725 | 246092.0 |
| 2012-09-12 08:05:00 | AAPL | Stock | 23.7332 | 23.7407 | 23.7232 | 23.7354 | 165368.0 |
| 2012-09-12 08:10:00 | AAPL | Stock | 23.7389 | 23.7818 | 23.7389 | 23.7764 | 270872.0 |
| 2012-09-12 08:15:00 | AAPL | Stock | 23.7736 | 23.7921 | 23.75 | 23.7571 | 417144.0 |
| 2012-09-12 08:20:00 | AAPL | Stock | 23.7571 | 23.78 | 23.7571 | 23.7657 | 217504.0 |
| 2012-09-12 08:25:00 | AAPL | Stock | 23.7657 | 23.7657 | 23.7429 | 23.7504 | 205240.0 |
| 2012-09-12 08:30:00 | AAPL | Stock | 23.7504 | 23.7604 | 23.7482 | 23.75 | 64148.0 |
| 2012-09-12 08:35:00 | AAPL | Stock | 23.7536 | 23.7625 | 23.7536 | 23.7564 | 81536.0 |
| 2012-09-12 08:40:00 | AAPL | Stock | 23.7646 | 23.7893 | 23.7646 | 23.7789 | 361760.0 |
| 2012-09-12 08:45:00 | AAPL | Stock | 23.7868 | 23.7918 | 23.7786 | 23.7857 | 236012.0 |
| 2012-09-12 08:50:00 | AAPL | Stock | 23.7821 | 23.7821 | 23.755 | 23.7561 | 127428.0 |
| 2012-09-12 08:55:00 | AAPL | Stock | 23.7586 | 23.7768 | 23.7561 | 23.7714 | 177044.0 |
| 2012-09-12 09:00:00 | AAPL | Stock | 23.775 | 23.78 | 23.7593 | 23.7664 | 163604.0 |
| 2012-09-12 09:05:00 | AAPL | Stock | 23.7668 | 23.7739 | 23.7607 | 23.7671 | 196420.0 |
> showing 50 of 312,432 rows — these rows as CSV