PREVIEW / stock_1hour / 2012-10-30
file: by_date/stock_1hour/2012/2012-10-30.parquet size: 6 KB rows: 27 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 |
|---|---|---|---|---|---|---|---|
| 2012-10-30 09:00:00 | C.K | Stock | 9.67 | 9.75 | 9.67 | 9.73 | 49100.0 |
| 2012-10-30 09:00:00 | C.K-DELISTED | Stock | 9.67 | 9.75 | 9.67 | 9.73 | 49100.0 |
| 2012-10-30 09:00:00 | C.L-DELISTED | Stock | 34.2 | 34.4 | 34.13 | 34.35 | 4800.0 |
| 2012-10-30 10:00:00 | C.K | Stock | 9.72 | 9.84 | 9.71 | 9.83 | 96400.0 |
| 2012-10-30 10:00:00 | C.K-DELISTED | Stock | 9.72 | 9.84 | 9.71 | 9.83 | 96400.0 |
| 2012-10-30 10:00:00 | C.L-DELISTED | Stock | 34.23 | 34.35 | 34.16 | 34.32 | 3700.0 |
| 2012-10-30 11:00:00 | C.K | Stock | 9.83 | 9.87 | 9.82 | 9.87 | 129200.0 |
| 2012-10-30 11:00:00 | C.K-DELISTED | Stock | 9.83 | 9.87 | 9.82 | 9.87 | 129200.0 |
| 2012-10-30 11:00:00 | C.L-DELISTED | Stock | 34.33 | 34.49 | 34.33 | 34.47 | 7800.0 |
| 2012-10-30 11:00:00 | C.PRJ-DELISTED | Stock | 1.5 | 1.5 | 1.5 | 1.5 | 1700.0 |
| 2012-10-30 12:00:00 | C.K | Stock | 9.87 | 9.9 | 9.8 | 9.9 | 2259500.0 |
| 2012-10-30 12:00:00 | C.K-DELISTED | Stock | 9.87 | 9.9 | 9.8 | 9.9 | 2259500.0 |
| 2012-10-30 12:00:00 | C.L-DELISTED | Stock | 34.4 | 34.49 | 34.36 | 34.49 | 2500.0 |
| 2012-10-30 13:00:00 | C.K | Stock | 9.9 | 9.95 | 9.86 | 9.92 | 87000.0 |
| 2012-10-30 13:00:00 | C.K-DELISTED | Stock | 9.9 | 9.95 | 9.86 | 9.92 | 87000.0 |
| 2012-10-30 13:00:00 | C.L-DELISTED | Stock | 34.49 | 34.5 | 34.44 | 34.5 | 3800.0 |
| 2012-10-30 14:00:00 | C.K | Stock | 9.92 | 9.93 | 9.88 | 9.92 | 82100.0 |
| 2012-10-30 14:00:00 | C.K-DELISTED | Stock | 9.92 | 9.93 | 9.88 | 9.92 | 82100.0 |
| 2012-10-30 14:00:00 | C.L-DELISTED | Stock | 34.48 | 34.5 | 34.43 | 34.49 | 9300.0 |
| 2012-10-30 15:00:00 | C.C-DELISTED | Stock | 0.05 | 0.05 | 0.05 | 0.05 | 35000.0 |
| 2012-10-30 15:00:00 | C.K | Stock | 9.92 | 9.98 | 9.9 | 9.97 | 201800.0 |
| 2012-10-30 15:00:00 | C.K-DELISTED | Stock | 9.92 | 9.98 | 9.9 | 9.97 | 201800.0 |
| 2012-10-30 15:00:00 | C.L-DELISTED | Stock | 34.46 | 34.64 | 34.46 | 34.64 | 27000.0 |
| 2012-10-30 15:00:00 | C.PRJ-DELISTED | Stock | 1.5 | 1.5 | 1.48 | 1.48 | 21100.0 |
| 2012-10-30 16:00:00 | C.K | Stock | 9.98 | 9.98 | 9.98 | 9.98 | 86300.0 |
| 2012-10-30 16:00:00 | C.K-DELISTED | Stock | 9.98 | 9.98 | 9.98 | 9.98 | 86300.0 |
| 2012-10-30 16:00:00 | C.L-DELISTED | Stock | 34.64 | 34.64 | 34.64 | 34.64 | 10000.0 |
> showing 27 of 27 rows — these rows as CSV