PREVIEW / stock_1hour / 2012-11-22
file: by_date/stock_1hour/2012/2012-11-22.parquet size: 6 KB rows: 34 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:00:00 | C.K | Stock | 9.9 | 10.0 | 9.84 | 10.0 | 164200.0 |
| 2012-11-22 09:00:00 | C.K-DELISTED | Stock | 9.9 | 10.0 | 9.84 | 10.0 | 164200.0 |
| 2012-11-22 09:00:00 | C.L-DELISTED | Stock | 32.77 | 33.12 | 32.77 | 33.12 | 17200.0 |
| 2012-11-22 09:00:00 | C.PRJ-DELISTED | Stock | 1.26 | 1.26 | 1.26 | 1.26 | 2300.0 |
| 2012-11-22 10:00:00 | C.K | Stock | 9.99 | 9.99 | 9.89 | 9.91 | 129800.0 |
| 2012-11-22 10:00:00 | C.K-DELISTED | Stock | 9.99 | 9.99 | 9.89 | 9.91 | 129800.0 |
| 2012-11-22 10:00:00 | C.L-DELISTED | Stock | 33.11 | 33.12 | 33.03 | 33.04 | 15500.0 |
| 2012-11-22 10:00:00 | C.PRC-DELISTED | Stock | 0.08 | 0.08 | 0.08 | 0.08 | 1000.0 |
| 2012-11-22 10:00:00 | C.PRJ-DELISTED | Stock | 1.23 | 1.23 | 1.21 | 1.23 | 5300.0 |
| 2012-11-22 11:00:00 | C.C-DELISTED | Stock | 0.045 | 0.045 | 0.045 | 0.045 | 15000.0 |
| 2012-11-22 11:00:00 | C.K | Stock | 9.91 | 9.92 | 9.89 | 9.89 | 34100.0 |
| 2012-11-22 11:00:00 | C.K-DELISTED | Stock | 9.91 | 9.92 | 9.89 | 9.89 | 34100.0 |
| 2012-11-22 11:00:00 | C.L-DELISTED | Stock | 33.04 | 33.05 | 32.92 | 33.03 | 8900.0 |
| 2012-11-22 11:00:00 | C.PRJ-DELISTED | Stock | 1.22 | 1.24 | 1.22 | 1.24 | 4900.0 |
| 2012-11-22 12:00:00 | C.K | Stock | 9.89 | 9.89 | 9.86 | 9.87 | 55500.0 |
| 2012-11-22 12:00:00 | C.K-DELISTED | Stock | 9.89 | 9.89 | 9.86 | 9.87 | 55500.0 |
| 2012-11-22 12:00:00 | C.L-DELISTED | Stock | 33.03 | 33.09 | 32.97 | 33.09 | 11500.0 |
| 2012-11-22 12:00:00 | C.PRC-DELISTED | Stock | 0.08 | 0.08 | 0.08 | 0.08 | 60000.0 |
| 2012-11-22 12:00:00 | C.PRJ-DELISTED | Stock | 1.24 | 1.24 | 1.24 | 1.24 | 8100.0 |
| 2012-11-22 13:00:00 | C.K | Stock | 9.87 | 9.87 | 9.85 | 9.85 | 70800.0 |
| 2012-11-22 13:00:00 | C.K-DELISTED | Stock | 9.87 | 9.87 | 9.85 | 9.85 | 70800.0 |
| 2012-11-22 13:00:00 | C.L-DELISTED | Stock | 33.07 | 33.24 | 33.03 | 33.18 | 14400.0 |
| 2012-11-22 13:00:00 | C.PRJ-DELISTED | Stock | 1.24 | 1.25 | 1.24 | 1.25 | 9100.0 |
| 2012-11-22 14:00:00 | C.K | Stock | 9.85 | 9.88 | 9.85 | 9.85 | 32200.0 |
| 2012-11-22 14:00:00 | C.K-DELISTED | Stock | 9.85 | 9.88 | 9.85 | 9.85 | 32200.0 |
| 2012-11-22 14:00:00 | C.L-DELISTED | Stock | 33.22 | 33.34 | 33.08 | 33.11 | 7800.0 |
| 2012-11-22 14:00:00 | C.PRJ-DELISTED | Stock | 1.26 | 1.3 | 1.26 | 1.3 | 31200.0 |
| 2012-11-22 15:00:00 | C.K | Stock | 9.84 | 9.86 | 9.83 | 9.86 | 64800.0 |
| 2012-11-22 15:00:00 | C.K-DELISTED | Stock | 9.84 | 9.86 | 9.83 | 9.86 | 64800.0 |
| 2012-11-22 15:00:00 | C.L-DELISTED | Stock | 33.11 | 33.15 | 33.06 | 33.09 | 12000.0 |
| 2012-11-22 15:00:00 | C.PRJ-DELISTED | Stock | 1.31 | 1.31 | 1.3 | 1.31 | 19900.0 |
| 2012-11-22 16:00:00 | C.K | Stock | 9.81 | 9.81 | 9.81 | 9.81 | 23100.0 |
| 2012-11-22 16:00:00 | C.K-DELISTED | Stock | 9.81 | 9.81 | 9.81 | 9.81 | 23100.0 |
| 2012-11-22 16:00:00 | C.L-DELISTED | Stock | 32.95 | 32.95 | 32.95 | 32.95 | 7500.0 |
> showing 34 of 34 rows — these rows as CSV