PREVIEW / stock_1hour / 2012-07-04
file: by_date/stock_1hour/2012/2012-07-04.parquet size: 6 KB rows: 36 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 |
|---|---|---|---|---|---|---|---|
| 2012-07-04 09:00:00 | C.C-DELISTED | Stock | 0.06 | 0.06 | 0.06 | 0.06 | 20000.0 |
| 2012-07-04 09:00:00 | C.K | Stock | 8.93 | 8.93 | 8.83 | 8.89 | 68900.0 |
| 2012-07-04 09:00:00 | C.K-DELISTED | Stock | 8.93 | 8.93 | 8.83 | 8.89 | 68900.0 |
| 2012-07-04 09:00:00 | C.L-DELISTED | Stock | 33.35 | 33.59 | 33.23 | 33.57 | 7400.0 |
| 2012-07-04 09:00:00 | C.PRJ-DELISTED | Stock | 1.7 | 1.7 | 1.69 | 1.7 | 1900.0 |
| 2012-07-04 09:00:00 | C.PRP-DELISTED | Stock | 0.07 | 0.07 | 0.07 | 0.07 | 10000.0 |
| 2012-07-04 10:00:00 | C.C-DELISTED | Stock | 0.06 | 0.06 | 0.055 | 0.055 | 189000.0 |
| 2012-07-04 10:00:00 | C.K | Stock | 8.88 | 8.94 | 8.86 | 8.92 | 164400.0 |
| 2012-07-04 10:00:00 | C.K-DELISTED | Stock | 8.88 | 8.94 | 8.86 | 8.92 | 164400.0 |
| 2012-07-04 10:00:00 | C.L-DELISTED | Stock | 33.6 | 33.6 | 33.49 | 33.51 | 12700.0 |
| 2012-07-04 10:00:00 | C.PRJ-DELISTED | Stock | 1.7 | 1.7 | 1.7 | 1.7 | 1600.0 |
| 2012-07-04 10:00:00 | C.PRP-DELISTED | Stock | 0.07 | 0.07 | 0.07 | 0.07 | 5000.0 |
| 2012-07-04 11:00:00 | C.K | Stock | 8.93 | 9.0 | 8.93 | 9.0 | 110100.0 |
| 2012-07-04 11:00:00 | C.K-DELISTED | Stock | 8.93 | 9.0 | 8.93 | 9.0 | 110100.0 |
| 2012-07-04 11:00:00 | C.L-DELISTED | Stock | 33.52 | 33.69 | 33.52 | 33.68 | 11200.0 |
| 2012-07-04 11:00:00 | C.PRJ-DELISTED | Stock | 1.7 | 1.7 | 1.7 | 1.7 | 21500.0 |
| 2012-07-04 12:00:00 | C.K | Stock | 9.0 | 9.01 | 8.95 | 8.95 | 66800.0 |
| 2012-07-04 12:00:00 | C.K-DELISTED | Stock | 9.0 | 9.01 | 8.95 | 8.95 | 66800.0 |
| 2012-07-04 12:00:00 | C.L-DELISTED | Stock | 33.69 | 33.7 | 33.58 | 33.67 | 24000.0 |
| 2012-07-04 13:00:00 | C.C-DELISTED | Stock | 0.06 | 0.06 | 0.06 | 0.06 | 8000.0 |
| 2012-07-04 13:00:00 | C.K | Stock | 8.96 | 9.05 | 8.94 | 9.04 | 124800.0 |
| 2012-07-04 13:00:00 | C.K-DELISTED | Stock | 8.96 | 9.05 | 8.94 | 9.04 | 124800.0 |
| 2012-07-04 13:00:00 | C.L-DELISTED | Stock | 33.68 | 33.68 | 33.36 | 33.51 | 15200.0 |
| 2012-07-04 13:00:00 | C.PRJ-DELISTED | Stock | 1.7 | 1.7 | 1.7 | 1.7 | 1500.0 |
| 2012-07-04 14:00:00 | C.C-DELISTED | Stock | 0.06 | 0.06 | 0.06 | 0.06 | 19000.0 |
| 2012-07-04 14:00:00 | C.K | Stock | 9.03 | 9.12 | 9.03 | 9.04 | 66300.0 |
| 2012-07-04 14:00:00 | C.K-DELISTED | Stock | 9.03 | 9.12 | 9.03 | 9.04 | 66300.0 |
| 2012-07-04 14:00:00 | C.L-DELISTED | Stock | 33.54 | 33.7 | 33.49 | 33.69 | 21300.0 |
| 2012-07-04 14:00:00 | C.PRJ-DELISTED | Stock | 1.7 | 1.7 | 1.7 | 1.7 | 1200.0 |
| 2012-07-04 15:00:00 | C.C-DELISTED | Stock | 0.06 | 0.06 | 0.06 | 0.06 | 24000.0 |
| 2012-07-04 15:00:00 | C.K | Stock | 9.04 | 9.15 | 9.02 | 9.12 | 207400.0 |
| 2012-07-04 15:00:00 | C.K-DELISTED | Stock | 9.04 | 9.15 | 9.02 | 9.12 | 207400.0 |
| 2012-07-04 15:00:00 | C.L-DELISTED | Stock | 33.68 | 33.69 | 33.46 | 33.55 | 23500.0 |
| 2012-07-04 16:00:00 | C.K | Stock | 9.14 | 9.14 | 9.14 | 9.14 | 109300.0 |
| 2012-07-04 16:00:00 | C.K-DELISTED | Stock | 9.14 | 9.14 | 9.14 | 9.14 | 109300.0 |
| 2012-07-04 16:00:00 | C.L-DELISTED | Stock | 33.49 | 33.49 | 33.49 | 33.49 | 1600.0 |
> showing 36 of 36 rows — these rows as CSV