PREVIEW / stock_1hour / 2013-01-21
file: by_date/stock_1hour/2013/2013-01-21.parquet size: 6 KB rows: 36 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 |
|---|---|---|---|---|---|---|---|
| 2013-01-21 09:00:00 | C.K | Stock | 9.42 | 9.54 | 9.42 | 9.52 | 140400.0 |
| 2013-01-21 09:00:00 | C.K-DELISTED | Stock | 9.42 | 9.54 | 9.42 | 9.52 | 140400.0 |
| 2013-01-21 09:00:00 | C.L-DELISTED | Stock | 40.33 | 40.57 | 40.33 | 40.5 | 16600.0 |
| 2013-01-21 09:00:00 | C.PRJ-DELISTED | Stock | 1.22 | 1.22 | 1.19 | 1.21 | 10900.0 |
| 2013-01-21 09:00:00 | C.PRK-DELISTED | Stock | 0.78 | 0.78 | 0.78 | 0.78 | 3500.0 |
| 2013-01-21 10:00:00 | C.K | Stock | 9.52 | 9.56 | 9.5 | 9.54 | 275300.0 |
| 2013-01-21 10:00:00 | C.K-DELISTED | Stock | 9.52 | 9.56 | 9.5 | 9.54 | 275300.0 |
| 2013-01-21 10:00:00 | C.L-DELISTED | Stock | 40.51 | 40.54 | 40.36 | 40.49 | 9300.0 |
| 2013-01-21 10:00:00 | C.PRJ-DELISTED | Stock | 1.2 | 1.2 | 1.19 | 1.19 | 89400.0 |
| 2013-01-21 11:00:00 | C.K | Stock | 9.55 | 9.55 | 9.53 | 9.53 | 180900.0 |
| 2013-01-21 11:00:00 | C.K-DELISTED | Stock | 9.55 | 9.55 | 9.53 | 9.53 | 180900.0 |
| 2013-01-21 11:00:00 | C.L-DELISTED | Stock | 40.48 | 40.52 | 40.43 | 40.45 | 69100.0 |
| 2013-01-21 11:00:00 | C.PRJ-DELISTED | Stock | 1.19 | 1.19 | 1.18 | 1.18 | 11000.0 |
| 2013-01-21 12:00:00 | C.K | Stock | 9.54 | 9.54 | 9.51 | 9.53 | 84400.0 |
| 2013-01-21 12:00:00 | C.K-DELISTED | Stock | 9.54 | 9.54 | 9.51 | 9.53 | 84400.0 |
| 2013-01-21 12:00:00 | C.L-DELISTED | Stock | 40.45 | 40.48 | 40.45 | 40.47 | 6200.0 |
| 2013-01-21 13:00:00 | C.K | Stock | 9.52 | 9.54 | 9.52 | 9.53 | 45100.0 |
| 2013-01-21 13:00:00 | C.K-DELISTED | Stock | 9.52 | 9.54 | 9.52 | 9.53 | 45100.0 |
| 2013-01-21 13:00:00 | C.L-DELISTED | Stock | 40.44 | 40.54 | 40.44 | 40.49 | 5400.0 |
| 2013-01-21 13:00:00 | C.PRJ-DELISTED | Stock | 1.18 | 1.18 | 1.18 | 1.18 | 179400.0 |
| 2013-01-21 13:00:00 | C.PRK-DELISTED | Stock | 0.75 | 0.75 | 0.75 | 0.75 | 5000.0 |
| 2013-01-21 14:00:00 | C.K | Stock | 9.53 | 9.54 | 9.52 | 9.54 | 4966800.0 |
| 2013-01-21 14:00:00 | C.K-DELISTED | Stock | 9.53 | 9.54 | 9.52 | 9.54 | 4966800.0 |
| 2013-01-21 14:00:00 | C.L-DELISTED | Stock | 40.55 | 40.59 | 40.47 | 40.56 | 3900.0 |
| 2013-01-21 14:00:00 | C.PRJ-DELISTED | Stock | 1.18 | 1.18 | 1.16 | 1.16 | 54800.0 |
| 2013-01-21 14:00:00 | C.PRK-DELISTED | Stock | 0.75 | 0.75 | 0.75 | 0.75 | 5000.0 |
| 2013-01-21 15:00:00 | C.C-DELISTED | Stock | 0.045 | 0.045 | 0.04 | 0.04 | 138000.0 |
| 2013-01-21 15:00:00 | C.K | Stock | 9.54 | 9.56 | 9.53 | 9.55 | 207100.0 |
| 2013-01-21 15:00:00 | C.K-DELISTED | Stock | 9.54 | 9.56 | 9.53 | 9.55 | 207100.0 |
| 2013-01-21 15:00:00 | C.L-DELISTED | Stock | 40.55 | 40.55 | 40.44 | 40.49 | 75400.0 |
| 2013-01-21 15:00:00 | C.PRC-DELISTED | Stock | 0.08 | 0.08 | 0.08 | 0.08 | 10000.0 |
| 2013-01-21 15:00:00 | C.PRJ-DELISTED | Stock | 1.18 | 1.18 | 1.17 | 1.17 | 5500.0 |
| 2013-01-21 15:00:00 | C.PRK-DELISTED | Stock | 0.75 | 0.75 | 0.75 | 0.75 | 7000.0 |
| 2013-01-21 16:00:00 | C.K | Stock | 9.53 | 9.53 | 9.53 | 9.53 | 34400.0 |
| 2013-01-21 16:00:00 | C.K-DELISTED | Stock | 9.53 | 9.53 | 9.53 | 9.53 | 34400.0 |
| 2013-01-21 16:00:00 | C.L-DELISTED | Stock | 40.53 | 40.53 | 40.53 | 40.53 | 700.0 |
> showing 36 of 36 rows — these rows as CSV