PREVIEW / stock_5min / 2011-06-10
file: by_date/stock_5min/2011/2011-06-10.parquet size: 5.0 MB rows: 342,109 symbols: 3,540
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-06-10 04:00:00 | AAPL | Stock | 11.8268 | 11.8268 | 11.8268 | 11.8268 | 16800.0 |
| 2011-06-10 04:05:00 | AAPL | Stock | 11.8286 | 11.8286 | 11.8275 | 11.8275 | 14000.0 |
| 2011-06-10 05:05:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 5600.0 |
| 2011-06-10 05:55:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 2800.0 |
| 2011-06-10 07:05:00 | AAPL | Stock | 11.8482 | 11.8482 | 11.8482 | 11.8482 | 5600.0 |
| 2011-06-10 07:10:00 | AAPL | Stock | 11.8429 | 11.8429 | 11.8429 | 11.8429 | 5600.0 |
| 2011-06-10 07:15:00 | AAPL | Stock | 11.8393 | 11.8446 | 11.8375 | 11.8375 | 14000.0 |
| 2011-06-10 07:30:00 | AAPL | Stock | 11.8482 | 11.8493 | 11.8482 | 11.8493 | 40684.0 |
| 2011-06-10 07:40:00 | AAPL | Stock | 11.835 | 11.8425 | 11.835 | 11.8425 | 28896.0 |
| 2011-06-10 07:45:00 | AAPL | Stock | 11.8446 | 11.8446 | 11.8446 | 11.8446 | 8400.0 |
| 2011-06-10 07:50:00 | AAPL | Stock | 11.8446 | 11.8536 | 11.8446 | 11.8529 | 30800.0 |
| 2011-06-10 07:55:00 | AAPL | Stock | 11.8532 | 11.8568 | 11.85 | 11.85 | 28000.0 |
| 2011-06-10 08:00:00 | AAPL | Stock | 11.8468 | 11.8468 | 11.8375 | 11.8443 | 155624.0 |
| 2011-06-10 08:10:00 | AAPL | Stock | 11.8482 | 11.8482 | 11.8375 | 11.8393 | 93408.0 |
| 2011-06-10 08:15:00 | AAPL | Stock | 11.8393 | 11.8393 | 11.8393 | 11.8393 | 22400.0 |
| 2011-06-10 08:20:00 | AAPL | Stock | 11.8357 | 11.8375 | 11.8321 | 11.8325 | 22120.0 |
| 2011-06-10 08:25:00 | AAPL | Stock | 11.8357 | 11.8357 | 11.8286 | 11.8286 | 34468.0 |
| 2011-06-10 08:30:00 | AAPL | Stock | 11.8293 | 11.8321 | 11.8271 | 11.8293 | 16800.0 |
| 2011-06-10 08:35:00 | AAPL | Stock | 11.8293 | 11.8321 | 11.8286 | 11.8304 | 36400.0 |
| 2011-06-10 08:40:00 | AAPL | Stock | 11.8332 | 11.8332 | 11.8232 | 11.8286 | 496916.0 |
| 2011-06-10 08:45:00 | AAPL | Stock | 11.8232 | 11.8232 | 11.8125 | 11.8139 | 109340.0 |
| 2011-06-10 08:50:00 | AAPL | Stock | 11.8107 | 11.8211 | 11.8075 | 11.8121 | 187572.0 |
| 2011-06-10 08:55:00 | AAPL | Stock | 11.8186 | 11.8211 | 11.8143 | 11.8193 | 25200.0 |
| 2011-06-10 09:00:00 | AAPL | Stock | 11.8118 | 11.8118 | 11.8011 | 11.8011 | 142520.0 |
| 2011-06-10 09:05:00 | AAPL | Stock | 11.8004 | 11.8079 | 11.7929 | 11.8079 | 173432.0 |
| 2011-06-10 09:10:00 | AAPL | Stock | 11.8068 | 11.8071 | 11.7775 | 11.7857 | 557004.0 |
| 2011-06-10 09:15:00 | AAPL | Stock | 11.7861 | 11.7982 | 11.7857 | 11.7979 | 147112.0 |
| 2011-06-10 09:20:00 | AAPL | Stock | 11.7946 | 11.7946 | 11.7857 | 11.7893 | 152460.0 |
| 2011-06-10 09:25:00 | AAPL | Stock | 11.7961 | 11.8179 | 11.79 | 11.8107 | 632240.0 |
| 2011-06-10 09:30:00 | AAPL | Stock | 11.8054 | 11.8214 | 11.7846 | 11.8111 | 19347916.0 |
| 2011-06-10 09:35:00 | AAPL | Stock | 11.8107 | 11.8261 | 11.8004 | 11.808 | 8252300.0 |
| 2011-06-10 09:40:00 | AAPL | Stock | 11.8079 | 11.845 | 11.7979 | 11.8221 | 10096884.0 |
| 2011-06-10 09:45:00 | AAPL | Stock | 11.8221 | 11.8425 | 11.8054 | 11.8136 | 7324856.0 |
| 2011-06-10 09:50:00 | AAPL | Stock | 11.8136 | 11.8214 | 11.7893 | 11.8021 | 8544060.0 |
| 2011-06-10 09:55:00 | AAPL | Stock | 11.8039 | 11.8286 | 11.7957 | 11.8279 | 7416444.0 |
| 2011-06-10 10:00:00 | AAPL | Stock | 11.8254 | 11.8282 | 11.8043 | 11.8089 | 6226360.0 |
| 2011-06-10 10:05:00 | AAPL | Stock | 11.8057 | 11.8239 | 11.7975 | 11.8061 | 4179644.0 |
| 2011-06-10 10:10:00 | AAPL | Stock | 11.8054 | 11.825 | 11.8025 | 11.8196 | 5170900.0 |
| 2011-06-10 10:15:00 | AAPL | Stock | 11.8193 | 11.83 | 11.8096 | 11.8116 | 4482380.0 |
| 2011-06-10 10:20:00 | AAPL | Stock | 11.8118 | 11.8214 | 11.7964 | 11.8031 | 5200104.0 |
| 2011-06-10 10:25:00 | AAPL | Stock | 11.8057 | 11.8075 | 11.7882 | 11.8003 | 6026048.0 |
| 2011-06-10 10:30:00 | AAPL | Stock | 11.7993 | 11.8039 | 11.7854 | 11.8007 | 7698656.0 |
| 2011-06-10 10:35:00 | AAPL | Stock | 11.8005 | 11.8143 | 11.7871 | 11.7875 | 4717524.0 |
| 2011-06-10 10:40:00 | AAPL | Stock | 11.7864 | 11.7875 | 11.7539 | 11.7743 | 14410228.0 |
| 2011-06-10 10:45:00 | AAPL | Stock | 11.7757 | 11.7757 | 11.7446 | 11.7454 | 7437556.0 |
| 2011-06-10 10:50:00 | AAPL | Stock | 11.745 | 11.7618 | 11.7243 | 11.7354 | 11379256.0 |
| 2011-06-10 10:55:00 | AAPL | Stock | 11.7343 | 11.7368 | 11.6964 | 11.7061 | 13761272.0 |
| 2011-06-10 11:00:00 | AAPL | Stock | 11.7071 | 11.7243 | 11.7054 | 11.7136 | 5495700.0 |
| 2011-06-10 11:05:00 | AAPL | Stock | 11.7139 | 11.7139 | 11.6882 | 11.6979 | 8854552.0 |
| 2011-06-10 11:10:00 | AAPL | Stock | 11.6966 | 11.6996 | 11.685 | 11.6996 | 5420072.0 |
> showing 50 of 342,109 rows — these rows as CSV