PREVIEW / stock_1hour / 2014-07-04
file: by_date/stock_1hour/2014/2014-07-04.parquet size: 6 KB rows: 33 symbols: 4
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 |
|---|---|---|---|---|---|---|---|
| 2014-07-04 09:00:00 | C.K | Stock | 4.45 | 4.5 | 4.45 | 4.46 | 31600.0 |
| 2014-07-04 09:00:00 | C.K-DELISTED | Stock | 4.45 | 4.5 | 4.45 | 4.46 | 31600.0 |
| 2014-07-04 09:00:00 | C.L-DELISTED | Stock | 47.25 | 47.59 | 47.25 | 47.56 | 17100.0 |
| 2014-07-04 09:00:00 | C.PRC-DELISTED | Stock | 0.475 | 0.48 | 0.475 | 0.48 | 154000.0 |
| 2014-07-04 09:00:00 | GEL | Stock | 0.49 | 0.5 | 0.455 | 0.5 | 42000.0 |
| 2014-07-04 10:00:00 | C.K | Stock | 4.46 | 4.47 | 4.45 | 4.46 | 52100.0 |
| 2014-07-04 10:00:00 | C.K-DELISTED | Stock | 4.46 | 4.47 | 4.45 | 4.46 | 52100.0 |
| 2014-07-04 10:00:00 | C.L-DELISTED | Stock | 47.55 | 47.6 | 47.51 | 47.58 | 12400.0 |
| 2014-07-04 10:00:00 | C.PRC-DELISTED | Stock | 0.48 | 0.485 | 0.475 | 0.485 | 76000.0 |
| 2014-07-04 11:00:00 | C.K | Stock | 4.465 | 4.47 | 4.46 | 4.465 | 22900.0 |
| 2014-07-04 11:00:00 | C.K-DELISTED | Stock | 4.465 | 4.47 | 4.46 | 4.465 | 22900.0 |
| 2014-07-04 11:00:00 | C.L-DELISTED | Stock | 47.55 | 47.71 | 47.54 | 47.71 | 237800.0 |
| 2014-07-04 11:00:00 | C.PRC-DELISTED | Stock | 0.485 | 0.5 | 0.485 | 0.495 | 441500.0 |
| 2014-07-04 12:00:00 | C.K | Stock | 4.465 | 4.48 | 4.46 | 4.47 | 35900.0 |
| 2014-07-04 12:00:00 | C.K-DELISTED | Stock | 4.465 | 4.48 | 4.46 | 4.47 | 35900.0 |
| 2014-07-04 12:00:00 | C.L-DELISTED | Stock | 47.72 | 47.8 | 47.71 | 47.77 | 46900.0 |
| 2014-07-04 12:00:00 | GEL | Stock | 0.475 | 0.475 | 0.475 | 0.475 | 10000.0 |
| 2014-07-04 13:00:00 | C.K | Stock | 4.46 | 4.46 | 4.45 | 4.45 | 18400.0 |
| 2014-07-04 13:00:00 | C.K-DELISTED | Stock | 4.46 | 4.46 | 4.45 | 4.45 | 18400.0 |
| 2014-07-04 13:00:00 | C.L-DELISTED | Stock | 47.76 | 47.82 | 47.72 | 47.8 | 6100.0 |
| 2014-07-04 13:00:00 | C.PRC-DELISTED | Stock | 0.495 | 0.495 | 0.495 | 0.495 | 19500.0 |
| 2014-07-04 14:00:00 | C.K | Stock | 4.45 | 4.47 | 4.45 | 4.47 | 13100.0 |
| 2014-07-04 14:00:00 | C.K-DELISTED | Stock | 4.45 | 4.47 | 4.45 | 4.47 | 13100.0 |
| 2014-07-04 14:00:00 | C.L-DELISTED | Stock | 47.8 | 47.94 | 47.79 | 47.9 | 12900.0 |
| 2014-07-04 14:00:00 | C.PRC-DELISTED | Stock | 0.5 | 0.5 | 0.5 | 0.5 | 307000.0 |
| 2014-07-04 14:00:00 | C.PRK-DELISTED | Stock | 0.27 | 0.27 | 0.27 | 0.27 | 2000.0 |
| 2014-07-04 15:00:00 | C.K | Stock | 4.46 | 4.46 | 4.45 | 4.45 | 46000.0 |
| 2014-07-04 15:00:00 | C.K-DELISTED | Stock | 4.46 | 4.46 | 4.45 | 4.45 | 46000.0 |
| 2014-07-04 15:00:00 | C.L-DELISTED | Stock | 47.9 | 47.9 | 47.72 | 47.73 | 33200.0 |
| 2014-07-04 15:00:00 | C.PRC-DELISTED | Stock | 0.5 | 0.51 | 0.49 | 0.5 | 339500.0 |
| 2014-07-04 16:00:00 | C.K | Stock | 4.44 | 4.44 | 4.44 | 4.44 | 17900.0 |
| 2014-07-04 16:00:00 | C.K-DELISTED | Stock | 4.44 | 4.44 | 4.44 | 4.44 | 17900.0 |
| 2014-07-04 16:00:00 | C.L-DELISTED | Stock | 47.72 | 47.72 | 47.72 | 47.72 | 4700.0 |
> showing 33 of 33 rows — these rows as CSV