PREVIEW / stock_1hour / 2010-07-05
file: by_date/stock_1hour/2010/2010-07-05.parquet size: 6 KB rows: 34 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 |
|---|---|---|---|---|---|---|---|
| 2010-07-05 09:00:00 | C.K | Stock | 17.55 | 17.56 | 17.3 | 17.37 | 138800.0 |
| 2010-07-05 09:00:00 | C.K-DELISTED | Stock | 17.55 | 17.56 | 17.3 | 17.37 | 138800.0 |
| 2010-07-05 09:00:00 | C.L-DELISTED | Stock | 38.01 | 38.25 | 38.0 | 38.1 | 9400.0 |
| 2010-07-05 09:00:00 | C.PRC-DELISTED | Stock | 0.185 | 0.185 | 0.185 | 0.185 | 2000.0 |
| 2010-07-05 09:00:00 | C.PRK-DELISTED | Stock | 5.15 | 5.15 | 5.15 | 5.15 | 2600.0 |
| 2010-07-05 09:00:00 | C.PRP-DELISTED | Stock | 0.11 | 0.11 | 0.105 | 0.105 | 60500.0 |
| 2010-07-05 10:00:00 | C.K | Stock | 17.38 | 17.53 | 17.31 | 17.44 | 89600.0 |
| 2010-07-05 10:00:00 | C.K-DELISTED | Stock | 17.38 | 17.53 | 17.31 | 17.44 | 89600.0 |
| 2010-07-05 10:00:00 | C.L-DELISTED | Stock | 38.13 | 38.13 | 37.96 | 37.96 | 4600.0 |
| 2010-07-05 10:00:00 | C.PRC-DELISTED | Stock | 0.185 | 0.185 | 0.185 | 0.185 | 3000.0 |
| 2010-07-05 11:00:00 | C.K | Stock | 17.47 | 17.47 | 17.35 | 17.4 | 36200.0 |
| 2010-07-05 11:00:00 | C.K-DELISTED | Stock | 17.47 | 17.47 | 17.35 | 17.4 | 36200.0 |
| 2010-07-05 11:00:00 | C.L-DELISTED | Stock | 37.95 | 38.15 | 37.95 | 38.1 | 4800.0 |
| 2010-07-05 11:00:00 | C.PRP-DELISTED | Stock | 0.11 | 0.11 | 0.105 | 0.105 | 28000.0 |
| 2010-07-05 12:00:00 | C.K | Stock | 17.4 | 17.42 | 17.33 | 17.4 | 26600.0 |
| 2010-07-05 12:00:00 | C.K-DELISTED | Stock | 17.4 | 17.42 | 17.33 | 17.4 | 26600.0 |
| 2010-07-05 12:00:00 | C.L-DELISTED | Stock | 38.05 | 38.1 | 38.0 | 38.06 | 8100.0 |
| 2010-07-05 12:00:00 | C.PRC-DELISTED | Stock | 0.175 | 0.175 | 0.175 | 0.175 | 10000.0 |
| 2010-07-05 12:00:00 | C.PRP-DELISTED | Stock | 0.11 | 0.11 | 0.105 | 0.105 | 53000.0 |
| 2010-07-05 13:00:00 | C.K | Stock | 17.39 | 17.41 | 17.37 | 17.37 | 17500.0 |
| 2010-07-05 13:00:00 | C.K-DELISTED | Stock | 17.39 | 17.41 | 17.37 | 17.37 | 17500.0 |
| 2010-07-05 13:00:00 | C.L-DELISTED | Stock | 38.01 | 38.09 | 37.65 | 37.65 | 4200.0 |
| 2010-07-05 14:00:00 | C.K | Stock | 17.37 | 17.47 | 17.37 | 17.44 | 23400.0 |
| 2010-07-05 14:00:00 | C.K-DELISTED | Stock | 17.37 | 17.47 | 17.37 | 17.44 | 23400.0 |
| 2010-07-05 14:00:00 | C.L-DELISTED | Stock | 37.86 | 38.29 | 37.86 | 38.29 | 10200.0 |
| 2010-07-05 14:00:00 | C.PRP-DELISTED | Stock | 0.105 | 0.105 | 0.105 | 0.105 | 7500.0 |
| 2010-07-05 15:00:00 | C.K | Stock | 17.44 | 17.46 | 17.36 | 17.36 | 68200.0 |
| 2010-07-05 15:00:00 | C.K-DELISTED | Stock | 17.44 | 17.46 | 17.36 | 17.36 | 68200.0 |
| 2010-07-05 15:00:00 | C.L-DELISTED | Stock | 38.29 | 38.53 | 38.17 | 38.31 | 23900.0 |
| 2010-07-05 15:00:00 | C.PRK-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 1600.0 |
| 2010-07-05 15:00:00 | C.PRP-DELISTED | Stock | 0.1 | 0.1 | 0.1 | 0.1 | 35000.0 |
| 2010-07-05 16:00:00 | C.K | Stock | 17.41 | 17.41 | 17.41 | 17.41 | 24000.0 |
| 2010-07-05 16:00:00 | C.K-DELISTED | Stock | 17.41 | 17.41 | 17.41 | 17.41 | 24000.0 |
| 2010-07-05 16:00:00 | C.L-DELISTED | Stock | 38.21 | 38.21 | 38.21 | 38.21 | 1900.0 |
> showing 34 of 34 rows — these rows as CSV