PREVIEW / stock_5min / 2011-07-21
file: by_date/stock_5min/2011/2011-07-21.parquet size: 4.9 MB rows: 329,574 symbols: 3,544
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-07-21 04:00:00 | AAPL | Stock | 13.8071 | 13.8071 | 13.8057 | 13.8057 | 16800.0 |
| 2011-07-21 04:15:00 | AAPL | Stock | 13.7857 | 13.7857 | 13.7857 | 13.7857 | 2800.0 |
| 2011-07-21 04:25:00 | AAPL | Stock | 13.7857 | 13.7857 | 13.7857 | 13.7857 | 11200.0 |
| 2011-07-21 04:35:00 | AAPL | Stock | 13.7746 | 13.7746 | 13.7746 | 13.7746 | 2800.0 |
| 2011-07-21 04:55:00 | AAPL | Stock | 13.7754 | 13.7754 | 13.7754 | 13.7754 | 2800.0 |
| 2011-07-21 05:00:00 | AAPL | Stock | 13.7736 | 13.7736 | 13.7564 | 13.7564 | 11200.0 |
| 2011-07-21 05:10:00 | AAPL | Stock | 13.7461 | 13.7461 | 13.7461 | 13.7461 | 2800.0 |
| 2011-07-21 05:15:00 | AAPL | Stock | 13.7393 | 13.7393 | 13.7393 | 13.7393 | 14000.0 |
| 2011-07-21 05:20:00 | AAPL | Stock | 13.7143 | 13.7143 | 13.7 | 13.7 | 11200.0 |
| 2011-07-21 05:25:00 | AAPL | Stock | 13.705 | 13.7089 | 13.705 | 13.7089 | 5600.0 |
| 2011-07-21 05:30:00 | AAPL | Stock | 13.7143 | 13.7143 | 13.7143 | 13.7143 | 2800.0 |
| 2011-07-21 05:35:00 | AAPL | Stock | 13.7071 | 13.7071 | 13.7071 | 13.7071 | 2800.0 |
| 2011-07-21 05:40:00 | AAPL | Stock | 13.7107 | 13.7107 | 13.7107 | 13.7107 | 2800.0 |
| 2011-07-21 05:50:00 | AAPL | Stock | 13.7107 | 13.7143 | 13.7071 | 13.7071 | 14000.0 |
| 2011-07-21 05:55:00 | AAPL | Stock | 13.6911 | 13.7143 | 13.6911 | 13.7143 | 20020.0 |
| 2011-07-21 06:10:00 | AAPL | Stock | 13.6993 | 13.6993 | 13.6982 | 13.6982 | 5600.0 |
| 2011-07-21 06:15:00 | AAPL | Stock | 13.7 | 13.7 | 13.7 | 13.7 | 2800.0 |
| 2011-07-21 06:20:00 | AAPL | Stock | 13.7 | 13.7 | 13.7 | 13.7 | 24920.0 |
| 2011-07-21 06:30:00 | AAPL | Stock | 13.7039 | 13.705 | 13.7039 | 13.705 | 5600.0 |
| 2011-07-21 06:35:00 | AAPL | Stock | 13.7096 | 13.7107 | 13.7075 | 13.7107 | 8400.0 |
| 2011-07-21 06:40:00 | AAPL | Stock | 13.7079 | 13.7093 | 13.7079 | 13.7093 | 11200.0 |
| 2011-07-21 06:45:00 | AAPL | Stock | 13.7014 | 13.7107 | 13.7014 | 13.7107 | 5600.0 |
| 2011-07-21 06:50:00 | AAPL | Stock | 13.7321 | 13.7321 | 13.7321 | 13.7321 | 5600.0 |
| 2011-07-21 07:00:00 | AAPL | Stock | 13.7696 | 13.7754 | 13.7561 | 13.7561 | 41048.0 |
| 2011-07-21 07:05:00 | AAPL | Stock | 13.7732 | 13.8018 | 13.7732 | 13.7857 | 14000.0 |
| 2011-07-21 07:10:00 | AAPL | Stock | 13.8061 | 13.8071 | 13.8061 | 13.8071 | 5600.0 |
| 2011-07-21 07:15:00 | AAPL | Stock | 13.8132 | 13.8136 | 13.8132 | 13.8136 | 8400.0 |
| 2011-07-21 07:20:00 | AAPL | Stock | 13.8075 | 13.8075 | 13.7857 | 13.7964 | 64400.0 |
| 2011-07-21 07:25:00 | AAPL | Stock | 13.7996 | 13.8036 | 13.7996 | 13.8036 | 45808.0 |
| 2011-07-21 07:30:00 | AAPL | Stock | 13.8054 | 13.8107 | 13.8046 | 13.8107 | 8400.0 |
| 2011-07-21 07:35:00 | AAPL | Stock | 13.8143 | 13.8154 | 13.7964 | 13.7964 | 68992.0 |
| 2011-07-21 07:40:00 | AAPL | Stock | 13.8011 | 13.8014 | 13.7857 | 13.7857 | 90216.0 |
| 2011-07-21 07:45:00 | AAPL | Stock | 13.7875 | 13.7893 | 13.7861 | 13.7861 | 18200.0 |
| 2011-07-21 07:50:00 | AAPL | Stock | 13.7857 | 13.8086 | 13.7857 | 13.8086 | 101584.0 |
| 2011-07-21 07:55:00 | AAPL | Stock | 13.8161 | 13.8236 | 13.8143 | 13.8236 | 65128.0 |
| 2011-07-21 08:00:00 | AAPL | Stock | 13.8214 | 13.8571 | 13.8214 | 13.8393 | 372596.0 |
| 2011-07-21 08:05:00 | AAPL | Stock | 13.8375 | 13.8482 | 13.8346 | 13.8429 | 103208.0 |
| 2011-07-21 08:10:00 | AAPL | Stock | 13.8357 | 13.8521 | 13.8343 | 13.8521 | 72744.0 |
| 2011-07-21 08:15:00 | AAPL | Stock | 13.8179 | 13.8786 | 13.8179 | 13.8711 | 2172240.0 |
| 2011-07-21 08:20:00 | AAPL | Stock | 13.875 | 13.8786 | 13.8571 | 13.8782 | 338268.0 |
| 2011-07-21 08:25:00 | AAPL | Stock | 13.865 | 13.8771 | 13.8571 | 13.8607 | 567112.0 |
| 2011-07-21 08:30:00 | AAPL | Stock | 13.8579 | 13.8836 | 13.8489 | 13.8821 | 284620.0 |
| 2011-07-21 08:35:00 | AAPL | Stock | 13.8736 | 13.8821 | 13.8582 | 13.8718 | 93688.0 |
| 2011-07-21 08:40:00 | AAPL | Stock | 13.8807 | 13.8814 | 13.8721 | 13.8721 | 25200.0 |
| 2011-07-21 08:45:00 | AAPL | Stock | 13.8721 | 13.8814 | 13.8721 | 13.8768 | 217868.0 |
| 2011-07-21 08:50:00 | AAPL | Stock | 13.8768 | 13.8886 | 13.8768 | 13.8886 | 233212.0 |
| 2011-07-21 08:55:00 | AAPL | Stock | 13.8886 | 13.8986 | 13.8771 | 13.8818 | 148960.0 |
| 2011-07-21 09:00:00 | AAPL | Stock | 13.8804 | 13.8804 | 13.8714 | 13.875 | 168644.0 |
| 2011-07-21 09:05:00 | AAPL | Stock | 13.875 | 13.8786 | 13.8671 | 13.8671 | 254184.0 |
| 2011-07-21 09:10:00 | AAPL | Stock | 13.8646 | 13.875 | 13.8618 | 13.8679 | 142716.0 |
> showing 50 of 329,574 rows — these rows as CSV