PREVIEW / stock_1hour / 2011-07-04
file: by_date/stock_1hour/2011/2011-07-04.parquet size: 6 KB rows: 32 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 |
|---|---|---|---|---|---|---|---|
| 2011-07-04 09:00:00 | C.K | Stock | 14.99 | 15.2 | 14.99 | 15.16 | 186900.0 |
| 2011-07-04 09:00:00 | C.K-DELISTED | Stock | 14.99 | 15.2 | 14.99 | 15.16 | 186900.0 |
| 2011-07-04 09:00:00 | C.L-DELISTED | Stock | 38.95 | 38.95 | 38.8 | 38.83 | 5500.0 |
| 2011-07-04 09:00:00 | C.PRJ-DELISTED | Stock | 8.8 | 8.8 | 8.7 | 8.8 | 19900.0 |
| 2011-07-04 10:00:00 | C.K | Stock | 15.16 | 15.19 | 15.16 | 15.18 | 39500.0 |
| 2011-07-04 10:00:00 | C.K-DELISTED | Stock | 15.16 | 15.19 | 15.16 | 15.18 | 39500.0 |
| 2011-07-04 10:00:00 | C.L-DELISTED | Stock | 38.85 | 38.86 | 38.79 | 38.79 | 5700.0 |
| 2011-07-04 10:00:00 | C.PRJ-DELISTED | Stock | 8.8 | 9.0 | 8.8 | 9.0 | 30600.0 |
| 2011-07-04 10:00:00 | C.PRP-DELISTED | Stock | 0.075 | 0.075 | 0.075 | 0.075 | 2000.0 |
| 2011-07-04 11:00:00 | C.K | Stock | 15.19 | 15.43 | 15.18 | 15.42 | 365900.0 |
| 2011-07-04 11:00:00 | C.K-DELISTED | Stock | 15.19 | 15.43 | 15.18 | 15.42 | 365900.0 |
| 2011-07-04 11:00:00 | C.L-DELISTED | Stock | 38.81 | 38.86 | 38.8 | 38.86 | 4200.0 |
| 2011-07-04 11:00:00 | C.PRJ-DELISTED | Stock | 9.05 | 9.05 | 8.91 | 9.0 | 8800.0 |
| 2011-07-04 12:00:00 | C.K | Stock | 15.42 | 15.53 | 15.4 | 15.46 | 174900.0 |
| 2011-07-04 12:00:00 | C.K-DELISTED | Stock | 15.42 | 15.53 | 15.4 | 15.46 | 174900.0 |
| 2011-07-04 12:00:00 | C.L-DELISTED | Stock | 38.86 | 38.9 | 38.85 | 38.9 | 11700.0 |
| 2011-07-04 12:00:00 | C.PRJ-DELISTED | Stock | 8.96 | 9.0 | 8.9 | 8.95 | 6200.0 |
| 2011-07-04 13:00:00 | C.K | Stock | 15.46 | 15.49 | 15.29 | 15.38 | 39100.0 |
| 2011-07-04 13:00:00 | C.K-DELISTED | Stock | 15.46 | 15.49 | 15.29 | 15.38 | 39100.0 |
| 2011-07-04 13:00:00 | C.L-DELISTED | Stock | 38.9 | 38.9 | 38.76 | 38.79 | 9200.0 |
| 2011-07-04 13:00:00 | C.PRJ-DELISTED | Stock | 8.95 | 9.0 | 8.95 | 9.0 | 3700.0 |
| 2011-07-04 14:00:00 | C.K | Stock | 15.38 | 15.42 | 15.33 | 15.35 | 22700.0 |
| 2011-07-04 14:00:00 | C.K-DELISTED | Stock | 15.38 | 15.42 | 15.33 | 15.35 | 22700.0 |
| 2011-07-04 14:00:00 | C.L-DELISTED | Stock | 38.79 | 38.82 | 38.79 | 38.82 | 1600.0 |
| 2011-07-04 14:00:00 | C.PRJ-DELISTED | Stock | 9.0 | 9.02 | 9.0 | 9.02 | 4700.0 |
| 2011-07-04 15:00:00 | C.K | Stock | 15.35 | 15.42 | 15.33 | 15.38 | 228900.0 |
| 2011-07-04 15:00:00 | C.K-DELISTED | Stock | 15.35 | 15.42 | 15.33 | 15.38 | 228900.0 |
| 2011-07-04 15:00:00 | C.L-DELISTED | Stock | 38.83 | 38.83 | 38.75 | 38.75 | 18000.0 |
| 2011-07-04 15:00:00 | C.PRJ-DELISTED | Stock | 9.02 | 9.3 | 9.02 | 9.3 | 50400.0 |
| 2011-07-04 16:00:00 | C.K | Stock | 15.39 | 15.39 | 15.39 | 15.39 | 30900.0 |
| 2011-07-04 16:00:00 | C.K-DELISTED | Stock | 15.39 | 15.39 | 15.39 | 15.39 | 30900.0 |
| 2011-07-04 16:00:00 | C.L-DELISTED | Stock | 38.8 | 38.8 | 38.8 | 38.8 | 1700.0 |
> showing 32 of 32 rows — these rows as CSV