PREVIEW / stock_1hour / 2015-07-03
file: by_date/stock_1hour/2015/2015-07-03.parquet size: 5 KB rows: 29 symbols: 3
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-03 09:00:00 | C.K | Stock | 2.87 | 2.88 | 2.83 | 2.88 | 27300.0 |
| 2015-07-03 09:00:00 | C.K-DELISTED | Stock | 2.87 | 2.88 | 2.83 | 2.88 | 27300.0 |
| 2015-07-03 09:00:00 | C.L-DELISTED | Stock | 63.99 | 64.1 | 63.66 | 64.1 | 4400.0 |
| 2015-07-03 10:00:00 | C.K | Stock | 2.87 | 2.87 | 2.84 | 2.86 | 19300.0 |
| 2015-07-03 10:00:00 | C.K-DELISTED | Stock | 2.87 | 2.87 | 2.84 | 2.86 | 19300.0 |
| 2015-07-03 10:00:00 | C.L-DELISTED | Stock | 64.05 | 64.09 | 63.66 | 63.82 | 9200.0 |
| 2015-07-03 10:00:00 | C.PRK-DELISTED | Stock | 0.045 | 0.045 | 0.045 | 0.045 | 48000.0 |
| 2015-07-03 11:00:00 | C.K | Stock | 2.86 | 2.88 | 2.85 | 2.86 | 29300.0 |
| 2015-07-03 11:00:00 | C.K-DELISTED | Stock | 2.86 | 2.88 | 2.85 | 2.86 | 29300.0 |
| 2015-07-03 11:00:00 | C.L-DELISTED | Stock | 63.85 | 63.99 | 63.71 | 63.99 | 6000.0 |
| 2015-07-03 11:00:00 | C.PRK-DELISTED | Stock | 0.045 | 0.045 | 0.045 | 0.045 | 3000.0 |
| 2015-07-03 12:00:00 | C.K | Stock | 2.85 | 2.86 | 2.84 | 2.85 | 29800.0 |
| 2015-07-03 12:00:00 | C.K-DELISTED | Stock | 2.85 | 2.86 | 2.84 | 2.85 | 29800.0 |
| 2015-07-03 12:00:00 | C.L-DELISTED | Stock | 64.0 | 64.25 | 63.91 | 64.25 | 27500.0 |
| 2015-07-03 13:00:00 | C.K | Stock | 2.85 | 2.85 | 2.84 | 2.85 | 18200.0 |
| 2015-07-03 13:00:00 | C.K-DELISTED | Stock | 2.85 | 2.85 | 2.84 | 2.85 | 18200.0 |
| 2015-07-03 13:00:00 | C.L-DELISTED | Stock | 64.26 | 64.65 | 64.23 | 64.46 | 58200.0 |
| 2015-07-03 13:00:00 | GEL | Stock | 0.27 | 0.27 | 0.27 | 0.27 | 15000.0 |
| 2015-07-03 14:00:00 | C.K | Stock | 2.85 | 2.85 | 2.84 | 2.84 | 6600.0 |
| 2015-07-03 14:00:00 | C.K-DELISTED | Stock | 2.85 | 2.85 | 2.84 | 2.84 | 6600.0 |
| 2015-07-03 14:00:00 | C.L-DELISTED | Stock | 64.4 | 64.54 | 64.4 | 64.46 | 19900.0 |
| 2015-07-03 14:00:00 | C.PRN | Stock | 1.42 | 1.44 | 1.42 | 1.44 | 15800.0 |
| 2015-07-03 14:00:00 | GEL | Stock | 0.27 | 0.27 | 0.27 | 0.27 | 26000.0 |
| 2015-07-03 15:00:00 | C.K | Stock | 2.84 | 2.86 | 2.835 | 2.84 | 69600.0 |
| 2015-07-03 15:00:00 | C.K-DELISTED | Stock | 2.84 | 2.86 | 2.835 | 2.84 | 69600.0 |
| 2015-07-03 15:00:00 | C.L-DELISTED | Stock | 64.46 | 64.51 | 64.22 | 64.34 | 40700.0 |
| 2015-07-03 16:00:00 | C.K | Stock | 2.87 | 2.87 | 2.87 | 2.87 | 141900.0 |
| 2015-07-03 16:00:00 | C.K-DELISTED | Stock | 2.87 | 2.87 | 2.87 | 2.87 | 141900.0 |
| 2015-07-03 16:00:00 | C.L-DELISTED | Stock | 64.4 | 64.4 | 64.4 | 64.4 | 10100.0 |
> showing 29 of 29 rows — these rows as CSV