PREVIEW / stock_5min / 2012-11-22
file: by_date/stock_5min/2012/2012-11-22.parquet size: 8 KB rows: 251 symbols: 5
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-11-22 09:30:00 | C.K | Stock | 9.9 | 9.93 | 9.84 | 9.91 | 53800.0 |
| 2012-11-22 09:30:00 | C.K-DELISTED | Stock | 9.9 | 9.93 | 9.84 | 9.91 | 53800.0 |
| 2012-11-22 09:30:00 | C.L-DELISTED | Stock | 32.77 | 33.0 | 32.77 | 32.99 | 8100.0 |
| 2012-11-22 09:35:00 | C.K | Stock | 9.93 | 9.95 | 9.91 | 9.95 | 12600.0 |
| 2012-11-22 09:35:00 | C.K-DELISTED | Stock | 9.93 | 9.95 | 9.91 | 9.95 | 12600.0 |
| 2012-11-22 09:35:00 | C.L-DELISTED | Stock | 33.0 | 33.07 | 33.0 | 33.07 | 2100.0 |
| 2012-11-22 09:40:00 | C.K | Stock | 9.95 | 9.96 | 9.92 | 9.95 | 12600.0 |
| 2012-11-22 09:40:00 | C.K-DELISTED | Stock | 9.95 | 9.96 | 9.92 | 9.95 | 12600.0 |
| 2012-11-22 09:40:00 | C.L-DELISTED | Stock | 33.1 | 33.1 | 33.1 | 33.1 | 300.0 |
| 2012-11-22 09:40:00 | C.PRJ-DELISTED | Stock | 1.26 | 1.26 | 1.26 | 1.26 | 2300.0 |
| 2012-11-22 09:45:00 | C.K | Stock | 9.96 | 9.99 | 9.89 | 9.99 | 50600.0 |
| 2012-11-22 09:45:00 | C.K-DELISTED | Stock | 9.96 | 9.99 | 9.89 | 9.99 | 50600.0 |
| 2012-11-22 09:45:00 | C.L-DELISTED | Stock | 33.09 | 33.1 | 33.08 | 33.1 | 4900.0 |
| 2012-11-22 09:50:00 | C.K | Stock | 9.99 | 10.0 | 9.99 | 10.0 | 25300.0 |
| 2012-11-22 09:50:00 | C.K-DELISTED | Stock | 9.99 | 10.0 | 9.99 | 10.0 | 25300.0 |
| 2012-11-22 09:55:00 | C.K | Stock | 9.99 | 10.0 | 9.98 | 10.0 | 9300.0 |
| 2012-11-22 09:55:00 | C.K-DELISTED | Stock | 9.99 | 10.0 | 9.98 | 10.0 | 9300.0 |
| 2012-11-22 09:55:00 | C.L-DELISTED | Stock | 33.12 | 33.12 | 33.12 | 33.12 | 1800.0 |
| 2012-11-22 10:00:00 | C.K | Stock | 9.99 | 9.99 | 9.96 | 9.97 | 19500.0 |
| 2012-11-22 10:00:00 | C.K-DELISTED | Stock | 9.99 | 9.99 | 9.96 | 9.97 | 19500.0 |
| 2012-11-22 10:00:00 | C.L-DELISTED | Stock | 33.11 | 33.12 | 33.1 | 33.1 | 3100.0 |
| 2012-11-22 10:00:00 | C.PRJ-DELISTED | Stock | 1.23 | 1.23 | 1.21 | 1.21 | 4300.0 |
| 2012-11-22 10:05:00 | C.K | Stock | 9.97 | 9.97 | 9.96 | 9.96 | 31300.0 |
| 2012-11-22 10:05:00 | C.K-DELISTED | Stock | 9.97 | 9.97 | 9.96 | 9.96 | 31300.0 |
| 2012-11-22 10:05:00 | C.L-DELISTED | Stock | 33.09 | 33.09 | 33.04 | 33.05 | 2100.0 |
| 2012-11-22 10:10:00 | C.K | Stock | 9.95 | 9.96 | 9.95 | 9.96 | 11400.0 |
| 2012-11-22 10:10:00 | C.K-DELISTED | Stock | 9.95 | 9.96 | 9.95 | 9.96 | 11400.0 |
| 2012-11-22 10:10:00 | C.L-DELISTED | Stock | 33.05 | 33.05 | 33.03 | 33.03 | 400.0 |
| 2012-11-22 10:15:00 | C.K | Stock | 9.96 | 9.96 | 9.92 | 9.92 | 29100.0 |
| 2012-11-22 10:15:00 | C.K-DELISTED | Stock | 9.96 | 9.96 | 9.92 | 9.92 | 29100.0 |
| 2012-11-22 10:15:00 | C.L-DELISTED | Stock | 33.04 | 33.08 | 33.04 | 33.07 | 1700.0 |
| 2012-11-22 10:20:00 | C.K | Stock | 9.93 | 9.94 | 9.89 | 9.9 | 16000.0 |
| 2012-11-22 10:20:00 | C.K-DELISTED | Stock | 9.93 | 9.94 | 9.89 | 9.9 | 16000.0 |
| 2012-11-22 10:20:00 | C.L-DELISTED | Stock | 33.07 | 33.07 | 33.07 | 33.07 | 200.0 |
| 2012-11-22 10:25:00 | C.K | Stock | 9.9 | 9.94 | 9.9 | 9.94 | 11900.0 |
| 2012-11-22 10:25:00 | C.K-DELISTED | Stock | 9.9 | 9.94 | 9.9 | 9.94 | 11900.0 |
| 2012-11-22 10:25:00 | C.L-DELISTED | Stock | 33.08 | 33.1 | 33.07 | 33.1 | 600.0 |
| 2012-11-22 10:30:00 | C.K | Stock | 9.94 | 9.94 | 9.93 | 9.93 | 4000.0 |
| 2012-11-22 10:30:00 | C.K-DELISTED | Stock | 9.94 | 9.94 | 9.93 | 9.93 | 4000.0 |
| 2012-11-22 10:30:00 | C.L-DELISTED | Stock | 33.09 | 33.09 | 33.09 | 33.09 | 400.0 |
| 2012-11-22 10:30:00 | C.PRJ-DELISTED | Stock | 1.22 | 1.22 | 1.22 | 1.22 | 300.0 |
| 2012-11-22 10:35:00 | C.K | Stock | 9.92 | 9.93 | 9.92 | 9.93 | 700.0 |
| 2012-11-22 10:35:00 | C.K-DELISTED | Stock | 9.92 | 9.93 | 9.92 | 9.93 | 700.0 |
| 2012-11-22 10:35:00 | C.L-DELISTED | Stock | 33.09 | 33.1 | 33.09 | 33.1 | 500.0 |
| 2012-11-22 10:40:00 | C.K | Stock | 9.93 | 9.93 | 9.92 | 9.92 | 400.0 |
| 2012-11-22 10:40:00 | C.K-DELISTED | Stock | 9.93 | 9.93 | 9.92 | 9.92 | 400.0 |
| 2012-11-22 10:40:00 | C.L-DELISTED | Stock | 33.1 | 33.1 | 33.09 | 33.1 | 400.0 |
| 2012-11-22 10:40:00 | C.PRC-DELISTED | Stock | 0.08 | 0.08 | 0.08 | 0.08 | 1000.0 |
| 2012-11-22 10:45:00 | C.K | Stock | 9.93 | 9.93 | 9.92 | 9.92 | 4100.0 |
| 2012-11-22 10:45:00 | C.K-DELISTED | Stock | 9.93 | 9.93 | 9.92 | 9.92 | 4100.0 |
> showing 50 of 251 rows — these rows as CSV