PREVIEW / stock_1hour / 2011-11-24
file: by_date/stock_1hour/2011/2011-11-24.parquet size: 6 KB rows: 32 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 |
|---|---|---|---|---|---|---|---|
| 2011-11-24 09:00:00 | C.C-DELISTED | Stock | 0.13 | 0.135 | 0.13 | 0.135 | 13500.0 |
| 2011-11-24 09:00:00 | C.K | Stock | 13.6 | 13.6 | 13.5 | 13.5 | 109500.0 |
| 2011-11-24 09:00:00 | C.K-DELISTED | Stock | 13.6 | 13.6 | 13.5 | 13.5 | 109500.0 |
| 2011-11-24 09:00:00 | C.L-DELISTED | Stock | 36.06 | 36.64 | 36.06 | 36.21 | 1800.0 |
| 2011-11-24 09:00:00 | C.PRJ-DELISTED | Stock | 3.44 | 3.44 | 3.44 | 3.44 | 7500.0 |
| 2011-11-24 09:00:00 | C.PRP-DELISTED | Stock | 0.05 | 0.05 | 0.05 | 0.05 | 5000.0 |
| 2011-11-24 10:00:00 | C.K | Stock | 13.5 | 13.5 | 13.4 | 13.45 | 122900.0 |
| 2011-11-24 10:00:00 | C.K-DELISTED | Stock | 13.5 | 13.5 | 13.4 | 13.45 | 122900.0 |
| 2011-11-24 10:00:00 | C.L-DELISTED | Stock | 36.23 | 36.41 | 36.21 | 36.27 | 2900.0 |
| 2011-11-24 10:00:00 | C.PRJ-DELISTED | Stock | 3.42 | 3.42 | 3.42 | 3.42 | 2000.0 |
| 2011-11-24 11:00:00 | C.K | Stock | 13.44 | 13.46 | 13.36 | 13.41 | 128100.0 |
| 2011-11-24 11:00:00 | C.K-DELISTED | Stock | 13.44 | 13.46 | 13.36 | 13.41 | 128100.0 |
| 2011-11-24 11:00:00 | C.L-DELISTED | Stock | 36.26 | 36.26 | 36.04 | 36.05 | 8700.0 |
| 2011-11-24 11:00:00 | C.PRJ-DELISTED | Stock | 3.35 | 3.35 | 3.34 | 3.35 | 4000.0 |
| 2011-11-24 12:00:00 | C.K | Stock | 13.41 | 13.49 | 13.4 | 13.4 | 59200.0 |
| 2011-11-24 12:00:00 | C.K-DELISTED | Stock | 13.41 | 13.49 | 13.4 | 13.4 | 59200.0 |
| 2011-11-24 12:00:00 | C.L-DELISTED | Stock | 36.04 | 36.13 | 36.01 | 36.1 | 5900.0 |
| 2011-11-24 13:00:00 | C.K | Stock | 13.4 | 13.42 | 13.39 | 13.41 | 73000.0 |
| 2011-11-24 13:00:00 | C.K-DELISTED | Stock | 13.4 | 13.42 | 13.39 | 13.41 | 73000.0 |
| 2011-11-24 13:00:00 | C.L-DELISTED | Stock | 36.05 | 36.18 | 36.04 | 36.13 | 6000.0 |
| 2011-11-24 13:00:00 | C.PRJ-DELISTED | Stock | 3.33 | 3.33 | 3.33 | 3.33 | 1000.0 |
| 2011-11-24 14:00:00 | C.C-DELISTED | Stock | 0.135 | 0.135 | 0.135 | 0.135 | 5000.0 |
| 2011-11-24 14:00:00 | C.K | Stock | 13.42 | 13.45 | 13.41 | 13.43 | 94300.0 |
| 2011-11-24 14:00:00 | C.K-DELISTED | Stock | 13.42 | 13.45 | 13.41 | 13.43 | 94300.0 |
| 2011-11-24 14:00:00 | C.L-DELISTED | Stock | 36.06 | 36.12 | 36.01 | 36.07 | 6700.0 |
| 2011-11-24 15:00:00 | C.K | Stock | 13.43 | 13.46 | 13.4 | 13.45 | 213900.0 |
| 2011-11-24 15:00:00 | C.K-DELISTED | Stock | 13.43 | 13.46 | 13.4 | 13.45 | 213900.0 |
| 2011-11-24 15:00:00 | C.L-DELISTED | Stock | 36.07 | 36.07 | 35.99 | 36.02 | 12800.0 |
| 2011-11-24 15:00:00 | C.PRP-DELISTED | Stock | 0.05 | 0.05 | 0.05 | 0.05 | 20000.0 |
| 2011-11-24 16:00:00 | C.K | Stock | 13.45 | 13.45 | 13.45 | 13.45 | 49500.0 |
| 2011-11-24 16:00:00 | C.K-DELISTED | Stock | 13.45 | 13.45 | 13.45 | 13.45 | 49500.0 |
| 2011-11-24 16:00:00 | C.L-DELISTED | Stock | 36.02 | 36.02 | 36.02 | 36.02 | 4800.0 |
> showing 32 of 32 rows — these rows as CSV