PREVIEW / stock_1hour / 2013-11-28
file: by_date/stock_1hour/2013/2013-11-28.parquet size: 5 KB rows: 35 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 |
|---|---|---|---|---|---|---|---|
| 2013-11-28 09:00:00 | C.K | Stock | 4.94 | 4.95 | 4.92 | 4.93 | 33300.0 |
| 2013-11-28 09:00:00 | C.K-DELISTED | Stock | 4.94 | 4.95 | 4.92 | 4.93 | 33300.0 |
| 2013-11-28 09:00:00 | C.L-DELISTED | Stock | 43.51 | 43.58 | 43.5 | 43.52 | 9400.0 |
| 2013-11-28 09:00:00 | C.PRJ-DELISTED | Stock | 0.145 | 0.145 | 0.145 | 0.145 | 3000.0 |
| 2013-11-28 09:00:00 | C.PRK-DELISTED | Stock | 0.12 | 0.12 | 0.115 | 0.115 | 156000.0 |
| 2013-11-28 10:00:00 | C.K | Stock | 4.93 | 4.94 | 4.93 | 4.93 | 32900.0 |
| 2013-11-28 10:00:00 | C.K-DELISTED | Stock | 4.93 | 4.94 | 4.93 | 4.93 | 32900.0 |
| 2013-11-28 10:00:00 | C.L-DELISTED | Stock | 43.51 | 43.6 | 43.48 | 43.58 | 10600.0 |
| 2013-11-28 10:00:00 | C.PRK-DELISTED | Stock | 0.115 | 0.115 | 0.115 | 0.115 | 35500.0 |
| 2013-11-28 11:00:00 | C.K | Stock | 4.94 | 4.94 | 4.92 | 4.94 | 41700.0 |
| 2013-11-28 11:00:00 | C.K-DELISTED | Stock | 4.94 | 4.94 | 4.92 | 4.94 | 41700.0 |
| 2013-11-28 11:00:00 | C.L-DELISTED | Stock | 43.61 | 43.65 | 43.41 | 43.42 | 15700.0 |
| 2013-11-28 11:00:00 | C.PRK-DELISTED | Stock | 0.115 | 0.115 | 0.11 | 0.11 | 157000.0 |
| 2013-11-28 11:00:00 | GEL | Stock | 0.28 | 0.28 | 0.28 | 0.28 | 3500.0 |
| 2013-11-28 12:00:00 | C.K | Stock | 4.94 | 4.95 | 4.94 | 4.94 | 28000.0 |
| 2013-11-28 12:00:00 | C.K-DELISTED | Stock | 4.94 | 4.95 | 4.94 | 4.94 | 28000.0 |
| 2013-11-28 12:00:00 | C.L-DELISTED | Stock | 43.41 | 43.42 | 43.4 | 43.41 | 14400.0 |
| 2013-11-28 12:00:00 | C.PRK-DELISTED | Stock | 0.12 | 0.12 | 0.12 | 0.12 | 10000.0 |
| 2013-11-28 12:00:00 | GEL | Stock | 0.28 | 0.28 | 0.28 | 0.28 | 36500.0 |
| 2013-11-28 13:00:00 | C.K | Stock | 4.93 | 4.94 | 4.92 | 4.94 | 23200.0 |
| 2013-11-28 13:00:00 | C.K-DELISTED | Stock | 4.93 | 4.94 | 4.92 | 4.94 | 23200.0 |
| 2013-11-28 13:00:00 | C.L-DELISTED | Stock | 43.4 | 43.45 | 43.4 | 43.43 | 12200.0 |
| 2013-11-28 13:00:00 | GEL | Stock | 0.28 | 0.28 | 0.28 | 0.28 | 10000.0 |
| 2013-11-28 14:00:00 | C.K | Stock | 4.94 | 4.95 | 4.93 | 4.94 | 102400.0 |
| 2013-11-28 14:00:00 | C.K-DELISTED | Stock | 4.94 | 4.95 | 4.93 | 4.94 | 102400.0 |
| 2013-11-28 14:00:00 | C.L-DELISTED | Stock | 43.43 | 43.46 | 43.41 | 43.44 | 8200.0 |
| 2013-11-28 14:00:00 | C.PRJ-DELISTED | Stock | 0.145 | 0.145 | 0.145 | 0.145 | 1500.0 |
| 2013-11-28 14:00:00 | C.PRK-DELISTED | Stock | 0.115 | 0.115 | 0.11 | 0.11 | 100000.0 |
| 2013-11-28 15:00:00 | C.K | Stock | 4.94 | 4.95 | 4.92 | 4.95 | 104300.0 |
| 2013-11-28 15:00:00 | C.K-DELISTED | Stock | 4.94 | 4.95 | 4.92 | 4.95 | 104300.0 |
| 2013-11-28 15:00:00 | C.L-DELISTED | Stock | 43.42 | 43.5 | 43.4 | 43.45 | 12100.0 |
| 2013-11-28 15:00:00 | C.PRJ-DELISTED | Stock | 0.145 | 0.145 | 0.145 | 0.145 | 3000.0 |
| 2013-11-28 16:00:00 | C.K | Stock | 4.94 | 4.94 | 4.94 | 4.94 | 10700.0 |
| 2013-11-28 16:00:00 | C.K-DELISTED | Stock | 4.94 | 4.94 | 4.94 | 4.94 | 10700.0 |
| 2013-11-28 16:00:00 | C.L-DELISTED | Stock | 43.42 | 43.42 | 43.42 | 43.42 | 5500.0 |
> showing 35 of 35 rows — these rows as CSV