PREVIEW / stock_1hour / 2012-05-28
file: by_date/stock_1hour/2012/2012-05-28.parquet size: 6 KB rows: 37 symbols: 6
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-05-28 09:00:00 | C.K | Stock | 8.59 | 8.59 | 8.52 | 8.56 | 26700.0 |
| 2012-05-28 09:00:00 | C.K-DELISTED | Stock | 8.59 | 8.59 | 8.52 | 8.56 | 26700.0 |
| 2012-05-28 09:00:00 | C.L-DELISTED | Stock | 31.85 | 31.85 | 31.76 | 31.76 | 7900.0 |
| 2012-05-28 09:00:00 | C.PRJ-DELISTED | Stock | 1.95 | 1.95 | 1.95 | 1.95 | 1700.0 |
| 2012-05-28 09:00:00 | C.PRP-DELISTED | Stock | 0.07 | 0.07 | 0.07 | 0.07 | 1000.0 |
| 2012-05-28 10:00:00 | C.K | Stock | 8.56 | 8.56 | 8.5 | 8.52 | 27900.0 |
| 2012-05-28 10:00:00 | C.K-DELISTED | Stock | 8.56 | 8.56 | 8.5 | 8.52 | 27900.0 |
| 2012-05-28 10:00:00 | C.L-DELISTED | Stock | 31.77 | 31.85 | 31.76 | 31.79 | 31000.0 |
| 2012-05-28 10:00:00 | C.PRJ-DELISTED | Stock | 1.95 | 1.95 | 1.95 | 1.95 | 3300.0 |
| 2012-05-28 11:00:00 | C.C-DELISTED | Stock | 0.07 | 0.07 | 0.07 | 0.07 | 10000.0 |
| 2012-05-28 11:00:00 | C.K | Stock | 8.52 | 8.52 | 8.5 | 8.52 | 13800.0 |
| 2012-05-28 11:00:00 | C.K-DELISTED | Stock | 8.52 | 8.52 | 8.5 | 8.52 | 13800.0 |
| 2012-05-28 11:00:00 | C.L-DELISTED | Stock | 31.8 | 31.8 | 31.75 | 31.75 | 2700.0 |
| 2012-05-28 11:00:00 | C.PRC-DELISTED | Stock | 0.085 | 0.085 | 0.085 | 0.085 | 2000.0 |
| 2012-05-28 11:00:00 | C.PRJ-DELISTED | Stock | 1.97 | 1.97 | 1.95 | 1.95 | 2000.0 |
| 2012-05-28 12:00:00 | C.C-DELISTED | Stock | 0.07 | 0.07 | 0.07 | 0.07 | 10000.0 |
| 2012-05-28 12:00:00 | C.K | Stock | 8.52 | 8.53 | 8.51 | 8.52 | 18000.0 |
| 2012-05-28 12:00:00 | C.K-DELISTED | Stock | 8.52 | 8.53 | 8.51 | 8.52 | 18000.0 |
| 2012-05-28 12:00:00 | C.L-DELISTED | Stock | 31.71 | 31.71 | 31.56 | 31.56 | 4000.0 |
| 2012-05-28 13:00:00 | C.K | Stock | 8.53 | 8.54 | 8.52 | 8.53 | 19800.0 |
| 2012-05-28 13:00:00 | C.K-DELISTED | Stock | 8.53 | 8.54 | 8.52 | 8.53 | 19800.0 |
| 2012-05-28 13:00:00 | C.L-DELISTED | Stock | 31.57 | 31.74 | 31.57 | 31.74 | 3200.0 |
| 2012-05-28 13:00:00 | C.PRJ-DELISTED | Stock | 1.97 | 2.0 | 1.97 | 2.0 | 6800.0 |
| 2012-05-28 13:00:00 | C.PRP-DELISTED | Stock | 0.06 | 0.06 | 0.06 | 0.06 | 45000.0 |
| 2012-05-28 14:00:00 | C.K | Stock | 8.52 | 8.52 | 8.46 | 8.46 | 73800.0 |
| 2012-05-28 14:00:00 | C.K-DELISTED | Stock | 8.52 | 8.52 | 8.46 | 8.46 | 73800.0 |
| 2012-05-28 14:00:00 | C.L-DELISTED | Stock | 31.74 | 31.74 | 31.61 | 31.61 | 6600.0 |
| 2012-05-28 14:00:00 | C.PRC-DELISTED | Stock | 0.09 | 0.09 | 0.09 | 0.09 | 15000.0 |
| 2012-05-28 14:00:00 | C.PRJ-DELISTED | Stock | 1.99 | 1.99 | 1.99 | 1.99 | 18700.0 |
| 2012-05-28 15:00:00 | C.K | Stock | 8.47 | 8.51 | 8.42 | 8.42 | 88500.0 |
| 2012-05-28 15:00:00 | C.K-DELISTED | Stock | 8.47 | 8.51 | 8.42 | 8.42 | 88500.0 |
| 2012-05-28 15:00:00 | C.L-DELISTED | Stock | 31.66 | 31.72 | 31.66 | 31.69 | 29900.0 |
| 2012-05-28 15:00:00 | C.PRJ-DELISTED | Stock | 1.98 | 1.99 | 1.98 | 1.99 | 2600.0 |
| 2012-05-28 15:00:00 | C.PRP-DELISTED | Stock | 0.06 | 0.065 | 0.06 | 0.065 | 16000.0 |
| 2012-05-28 16:00:00 | C.K | Stock | 8.42 | 8.42 | 8.42 | 8.42 | 31000.0 |
| 2012-05-28 16:00:00 | C.K-DELISTED | Stock | 8.42 | 8.42 | 8.42 | 8.42 | 31000.0 |
| 2012-05-28 16:00:00 | C.L-DELISTED | Stock | 31.72 | 31.72 | 31.72 | 31.72 | 3300.0 |
> showing 37 of 37 rows — these rows as CSV