PREVIEW / stock_1hour / 2012-10-29
file: by_date/stock_1hour/2012/2012-10-29.parquet size: 6 KB rows: 32 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-10-29 09:00:00 | C.K | Stock | 9.65 | 9.69 | 9.6 | 9.66 | 64700.0 |
| 2012-10-29 09:00:00 | C.K-DELISTED | Stock | 9.65 | 9.69 | 9.6 | 9.66 | 64700.0 |
| 2012-10-29 09:00:00 | C.L-DELISTED | Stock | 33.8 | 34.28 | 33.8 | 34.28 | 4400.0 |
| 2012-10-29 09:00:00 | C.PRJ-DELISTED | Stock | 1.53 | 1.53 | 1.52 | 1.52 | 8000.0 |
| 2012-10-29 10:00:00 | C.C-DELISTED | Stock | 0.045 | 0.045 | 0.045 | 0.045 | 15000.0 |
| 2012-10-29 10:00:00 | C.K | Stock | 9.66 | 9.66 | 9.62 | 9.62 | 74300.0 |
| 2012-10-29 10:00:00 | C.K-DELISTED | Stock | 9.66 | 9.66 | 9.62 | 9.62 | 74300.0 |
| 2012-10-29 10:00:00 | C.L-DELISTED | Stock | 34.23 | 34.38 | 34.23 | 34.33 | 4100.0 |
| 2012-10-29 10:00:00 | C.PRJ-DELISTED | Stock | 1.52 | 1.52 | 1.51 | 1.51 | 9400.0 |
| 2012-10-29 11:00:00 | C.K | Stock | 9.62 | 9.65 | 9.61 | 9.65 | 36900.0 |
| 2012-10-29 11:00:00 | C.K-DELISTED | Stock | 9.62 | 9.65 | 9.61 | 9.65 | 36900.0 |
| 2012-10-29 11:00:00 | C.L-DELISTED | Stock | 34.31 | 34.41 | 34.31 | 34.34 | 4500.0 |
| 2012-10-29 11:00:00 | C.PRJ-DELISTED | Stock | 1.51 | 1.53 | 1.51 | 1.53 | 9000.0 |
| 2012-10-29 12:00:00 | C.K | Stock | 9.65 | 9.66 | 9.6 | 9.62 | 35300.0 |
| 2012-10-29 12:00:00 | C.K-DELISTED | Stock | 9.65 | 9.66 | 9.6 | 9.62 | 35300.0 |
| 2012-10-29 12:00:00 | C.L-DELISTED | Stock | 34.31 | 34.36 | 34.15 | 34.22 | 3500.0 |
| 2012-10-29 12:00:00 | C.PRP-DELISTED | Stock | 1.01 | 1.01 | 1.01 | 1.01 | 2100.0 |
| 2012-10-29 13:00:00 | C.K | Stock | 9.63 | 9.63 | 9.61 | 9.62 | 35700.0 |
| 2012-10-29 13:00:00 | C.K-DELISTED | Stock | 9.63 | 9.63 | 9.61 | 9.62 | 35700.0 |
| 2012-10-29 13:00:00 | C.L-DELISTED | Stock | 34.2 | 34.28 | 34.1 | 34.27 | 4700.0 |
| 2012-10-29 14:00:00 | C.K | Stock | 9.62 | 9.64 | 9.6 | 9.64 | 62600.0 |
| 2012-10-29 14:00:00 | C.K-DELISTED | Stock | 9.62 | 9.64 | 9.6 | 9.64 | 62600.0 |
| 2012-10-29 14:00:00 | C.L-DELISTED | Stock | 34.24 | 34.31 | 34.16 | 34.16 | 6300.0 |
| 2012-10-29 14:00:00 | C.PRJ-DELISTED | Stock | 1.53 | 1.53 | 1.51 | 1.51 | 7100.0 |
| 2012-10-29 14:00:00 | C.PRP-DELISTED | Stock | 1.01 | 1.01 | 1.01 | 1.01 | 100.0 |
| 2012-10-29 15:00:00 | C.K | Stock | 9.65 | 9.7 | 9.62 | 9.7 | 147900.0 |
| 2012-10-29 15:00:00 | C.K-DELISTED | Stock | 9.65 | 9.7 | 9.62 | 9.7 | 147900.0 |
| 2012-10-29 15:00:00 | C.L-DELISTED | Stock | 34.16 | 34.25 | 34.11 | 34.18 | 5100.0 |
| 2012-10-29 15:00:00 | C.PRJ-DELISTED | Stock | 1.5 | 1.53 | 1.5 | 1.53 | 6600.0 |
| 2012-10-29 16:00:00 | C.K | Stock | 9.77 | 9.77 | 9.77 | 9.77 | 63300.0 |
| 2012-10-29 16:00:00 | C.K-DELISTED | Stock | 9.77 | 9.77 | 9.77 | 9.77 | 63300.0 |
| 2012-10-29 16:00:00 | C.L-DELISTED | Stock | 34.32 | 34.32 | 34.32 | 34.32 | 4400.0 |
> showing 32 of 32 rows — these rows as CSV