PREVIEW / stock_5min / 2012-02-08
file: by_date/stock_5min/2012/2012-02-08.parquet size: 4.9 MB rows: 325,900 symbols: 3,557
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-02-08 04:00:00 | AAPL | Stock | 16.8093 | 16.8214 | 16.8093 | 16.8214 | 11200.0 |
| 2012-02-08 04:05:00 | AAPL | Stock | 16.8314 | 16.8314 | 16.8314 | 16.8314 | 5600.0 |
| 2012-02-08 04:10:00 | AAPL | Stock | 16.8571 | 16.8686 | 16.8568 | 16.8686 | 46452.0 |
| 2012-02-08 04:15:00 | AAPL | Stock | 16.8589 | 16.8589 | 16.8589 | 16.8589 | 16800.0 |
| 2012-02-08 04:25:00 | AAPL | Stock | 16.8471 | 16.8471 | 16.8471 | 16.8471 | 5600.0 |
| 2012-02-08 04:30:00 | AAPL | Stock | 16.8393 | 16.8393 | 16.8393 | 16.8393 | 11900.0 |
| 2012-02-08 04:45:00 | AAPL | Stock | 16.8571 | 16.8589 | 16.8571 | 16.8589 | 9800.0 |
| 2012-02-08 05:00:00 | AAPL | Stock | 16.8286 | 16.8286 | 16.8286 | 16.8286 | 14000.0 |
| 2012-02-08 05:15:00 | AAPL | Stock | 16.8111 | 16.8111 | 16.8107 | 16.8107 | 15120.0 |
| 2012-02-08 05:20:00 | AAPL | Stock | 16.8107 | 16.8107 | 16.8096 | 16.8096 | 10920.0 |
| 2012-02-08 05:25:00 | AAPL | Stock | 16.8036 | 16.8036 | 16.8036 | 16.8036 | 11200.0 |
| 2012-02-08 05:40:00 | AAPL | Stock | 16.8214 | 16.8214 | 16.8214 | 16.8214 | 2800.0 |
| 2012-02-08 05:55:00 | AAPL | Stock | 16.8204 | 16.8204 | 16.8204 | 16.8204 | 2800.0 |
| 2012-02-08 06:05:00 | AAPL | Stock | 16.8321 | 16.8321 | 16.8321 | 16.8321 | 2800.0 |
| 2012-02-08 06:10:00 | AAPL | Stock | 16.8321 | 16.8343 | 16.8264 | 16.8343 | 16660.0 |
| 2012-02-08 06:15:00 | AAPL | Stock | 16.8343 | 16.8343 | 16.8343 | 16.8343 | 19600.0 |
| 2012-02-08 06:30:00 | AAPL | Stock | 16.8214 | 16.8214 | 16.8146 | 16.8146 | 14000.0 |
| 2012-02-08 06:40:00 | AAPL | Stock | 16.8271 | 16.8275 | 16.8271 | 16.8275 | 11200.0 |
| 2012-02-08 06:50:00 | AAPL | Stock | 16.8214 | 16.8214 | 16.8214 | 16.8214 | 14000.0 |
| 2012-02-08 06:55:00 | AAPL | Stock | 16.8214 | 16.8214 | 16.8214 | 16.8214 | 5600.0 |
| 2012-02-08 07:00:00 | AAPL | Stock | 16.8179 | 16.8207 | 16.7864 | 16.8207 | 58660.0 |
| 2012-02-08 07:05:00 | AAPL | Stock | 16.8075 | 16.8139 | 16.8071 | 16.8071 | 27440.0 |
| 2012-02-08 07:10:00 | AAPL | Stock | 16.8071 | 16.8136 | 16.8036 | 16.8036 | 22400.0 |
| 2012-02-08 07:15:00 | AAPL | Stock | 16.8132 | 16.8132 | 16.8132 | 16.8132 | 2800.0 |
| 2012-02-08 07:20:00 | AAPL | Stock | 16.8093 | 16.8125 | 16.8093 | 16.8125 | 8400.0 |
| 2012-02-08 07:25:00 | AAPL | Stock | 16.8107 | 16.8107 | 16.8036 | 16.8036 | 20104.0 |
| 2012-02-08 07:30:00 | AAPL | Stock | 16.8 | 16.8071 | 16.8 | 16.8071 | 50400.0 |
| 2012-02-08 07:35:00 | AAPL | Stock | 16.8125 | 16.8232 | 16.8111 | 16.8232 | 178024.0 |
| 2012-02-08 07:40:00 | AAPL | Stock | 16.8179 | 16.8179 | 16.8111 | 16.8114 | 23800.0 |
| 2012-02-08 07:45:00 | AAPL | Stock | 16.8111 | 16.8143 | 16.8111 | 16.8143 | 19600.0 |
| 2012-02-08 07:50:00 | AAPL | Stock | 16.8143 | 16.8193 | 16.8129 | 16.8193 | 47600.0 |
| 2012-02-08 07:55:00 | AAPL | Stock | 16.8189 | 16.8189 | 16.8071 | 16.8121 | 35000.0 |
| 2012-02-08 08:00:00 | AAPL | Stock | 16.8175 | 16.8175 | 16.7143 | 16.7143 | 409640.0 |
| 2012-02-08 08:05:00 | AAPL | Stock | 16.8071 | 16.8161 | 16.8 | 16.8157 | 210868.0 |
| 2012-02-08 08:10:00 | AAPL | Stock | 16.815 | 16.8214 | 16.8089 | 16.8175 | 304892.0 |
| 2012-02-08 08:15:00 | AAPL | Stock | 16.8143 | 16.8179 | 16.8071 | 16.8179 | 62300.0 |
| 2012-02-08 08:20:00 | AAPL | Stock | 16.8136 | 16.8139 | 16.7439 | 16.8071 | 300720.0 |
| 2012-02-08 08:25:00 | AAPL | Stock | 16.8114 | 16.8114 | 16.8054 | 16.8064 | 108612.0 |
| 2012-02-08 08:30:00 | AAPL | Stock | 16.8071 | 16.8107 | 16.8054 | 16.8071 | 93128.0 |
| 2012-02-08 08:35:00 | AAPL | Stock | 16.81 | 16.8104 | 16.7964 | 16.8 | 220276.0 |
| 2012-02-08 08:40:00 | AAPL | Stock | 16.7954 | 16.8032 | 16.7946 | 16.7979 | 78260.0 |
| 2012-02-08 08:45:00 | AAPL | Stock | 16.8025 | 16.8036 | 16.8 | 16.8 | 73724.0 |
| 2012-02-08 08:50:00 | AAPL | Stock | 16.8004 | 16.8036 | 16.8004 | 16.8036 | 76132.0 |
| 2012-02-08 08:55:00 | AAPL | Stock | 16.8036 | 16.8068 | 16.8 | 16.8018 | 68376.0 |
| 2012-02-08 09:00:00 | AAPL | Stock | 16.8018 | 16.8036 | 16.7946 | 16.7993 | 127400.0 |
| 2012-02-08 09:05:00 | AAPL | Stock | 16.795 | 16.805 | 16.795 | 16.8018 | 134596.0 |
| 2012-02-08 09:10:00 | AAPL | Stock | 16.7986 | 16.8 | 16.7964 | 16.8 | 65884.0 |
| 2012-02-08 09:15:00 | AAPL | Stock | 16.8 | 16.8 | 16.7979 | 16.8 | 29848.0 |
| 2012-02-08 09:20:00 | AAPL | Stock | 16.7982 | 16.8068 | 16.7946 | 16.8039 | 522704.0 |
| 2012-02-08 09:25:00 | AAPL | Stock | 16.8039 | 16.8107 | 16.7857 | 16.8096 | 523656.0 |
> showing 50 of 325,900 rows — these rows as CSV