PREVIEW / stock_1hour / 2012-01-16
file: by_date/stock_1hour/2012/2012-01-16.parquet size: 6 KB rows: 34 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-01-16 09:00:00 | C.C-DELISTED | Stock | 0.11 | 0.11 | 0.11 | 0.11 | 28000.0 |
| 2012-01-16 09:00:00 | C.K | Stock | 13.0 | 13.16 | 12.94 | 13.14 | 166400.0 |
| 2012-01-16 09:00:00 | C.K-DELISTED | Stock | 13.0 | 13.16 | 12.94 | 13.14 | 166400.0 |
| 2012-01-16 09:00:00 | C.L-DELISTED | Stock | 36.71 | 36.85 | 36.71 | 36.77 | 7300.0 |
| 2012-01-16 09:00:00 | C.PRC-DELISTED | Stock | 0.19 | 0.19 | 0.19 | 0.19 | 6000.0 |
| 2012-01-16 09:00:00 | C.PRJ-DELISTED | Stock | 2.45 | 2.52 | 2.42 | 2.47 | 39600.0 |
| 2012-01-16 09:00:00 | C.PRP-DELISTED | Stock | 0.09 | 0.09 | 0.09 | 0.09 | 70000.0 |
| 2012-01-16 10:00:00 | C.K | Stock | 13.14 | 13.16 | 13.12 | 13.14 | 124500.0 |
| 2012-01-16 10:00:00 | C.K-DELISTED | Stock | 13.14 | 13.16 | 13.12 | 13.14 | 124500.0 |
| 2012-01-16 10:00:00 | C.L-DELISTED | Stock | 36.76 | 36.85 | 36.7 | 36.83 | 8100.0 |
| 2012-01-16 10:00:00 | C.PRJ-DELISTED | Stock | 2.49 | 2.5 | 2.47 | 2.48 | 6900.0 |
| 2012-01-16 11:00:00 | C.K | Stock | 13.15 | 13.2 | 13.14 | 13.16 | 135000.0 |
| 2012-01-16 11:00:00 | C.K-DELISTED | Stock | 13.15 | 13.2 | 13.14 | 13.16 | 135000.0 |
| 2012-01-16 11:00:00 | C.L-DELISTED | Stock | 36.82 | 36.84 | 36.75 | 36.82 | 6900.0 |
| 2012-01-16 11:00:00 | C.PRJ-DELISTED | Stock | 2.49 | 2.5 | 2.45 | 2.45 | 17200.0 |
| 2012-01-16 12:00:00 | C.K | Stock | 13.16 | 13.18 | 13.14 | 13.15 | 108000.0 |
| 2012-01-16 12:00:00 | C.K-DELISTED | Stock | 13.16 | 13.18 | 13.14 | 13.15 | 108000.0 |
| 2012-01-16 12:00:00 | C.L-DELISTED | Stock | 36.81 | 36.84 | 36.75 | 36.84 | 7300.0 |
| 2012-01-16 12:00:00 | C.PRJ-DELISTED | Stock | 2.48 | 2.48 | 2.43 | 2.43 | 12200.0 |
| 2012-01-16 13:00:00 | C.K | Stock | 13.15 | 13.16 | 13.14 | 13.16 | 29300.0 |
| 2012-01-16 13:00:00 | C.K-DELISTED | Stock | 13.15 | 13.16 | 13.14 | 13.16 | 29300.0 |
| 2012-01-16 13:00:00 | C.L-DELISTED | Stock | 36.81 | 36.84 | 36.72 | 36.8 | 6800.0 |
| 2012-01-16 13:00:00 | C.PRJ-DELISTED | Stock | 2.43 | 2.45 | 2.4 | 2.41 | 17700.0 |
| 2012-01-16 14:00:00 | C.K | Stock | 13.16 | 13.18 | 13.14 | 13.17 | 52500.0 |
| 2012-01-16 14:00:00 | C.K-DELISTED | Stock | 13.16 | 13.18 | 13.14 | 13.17 | 52500.0 |
| 2012-01-16 14:00:00 | C.L-DELISTED | Stock | 36.76 | 36.81 | 36.6 | 36.6 | 22400.0 |
| 2012-01-16 14:00:00 | C.PRJ-DELISTED | Stock | 2.41 | 2.41 | 2.39 | 2.4 | 14700.0 |
| 2012-01-16 15:00:00 | C.K | Stock | 13.18 | 13.2 | 13.17 | 13.2 | 131000.0 |
| 2012-01-16 15:00:00 | C.K-DELISTED | Stock | 13.18 | 13.2 | 13.17 | 13.2 | 131000.0 |
| 2012-01-16 15:00:00 | C.L-DELISTED | Stock | 36.63 | 36.75 | 36.52 | 36.65 | 26700.0 |
| 2012-01-16 15:00:00 | C.PRJ-DELISTED | Stock | 2.4 | 2.41 | 2.37 | 2.38 | 28300.0 |
| 2012-01-16 16:00:00 | C.K | Stock | 13.2 | 13.2 | 13.2 | 13.2 | 22800.0 |
| 2012-01-16 16:00:00 | C.K-DELISTED | Stock | 13.2 | 13.2 | 13.2 | 13.2 | 22800.0 |
| 2012-01-16 16:00:00 | C.L-DELISTED | Stock | 36.69 | 36.69 | 36.69 | 36.69 | 3700.0 |
> showing 34 of 34 rows — these rows as CSV