PREVIEW / stock_1hour / 2013-07-04
file: by_date/stock_1hour/2013/2013-07-04.parquet size: 6 KB rows: 35 symbols: 6
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-07-04 09:00:00 | C.K | Stock | 5.25 | 5.29 | 5.225 | 5.29 | 67600.0 |
| 2013-07-04 09:00:00 | C.K-DELISTED | Stock | 5.25 | 5.29 | 5.225 | 5.29 | 67600.0 |
| 2013-07-04 09:00:00 | C.L-DELISTED | Stock | 47.76 | 47.95 | 47.74 | 47.9 | 15800.0 |
| 2013-07-04 09:00:00 | C.PRJ-DELISTED | Stock | 0.56 | 0.56 | 0.56 | 0.56 | 500.0 |
| 2013-07-04 10:00:00 | C.K | Stock | 5.29 | 5.29 | 5.26 | 5.26 | 44200.0 |
| 2013-07-04 10:00:00 | C.K-DELISTED | Stock | 5.29 | 5.29 | 5.26 | 5.26 | 44200.0 |
| 2013-07-04 10:00:00 | C.L-DELISTED | Stock | 47.9 | 47.9 | 47.3 | 47.46 | 22000.0 |
| 2013-07-04 10:00:00 | C.PRJ-DELISTED | Stock | 0.56 | 0.56 | 0.56 | 0.56 | 500.0 |
| 2013-07-04 10:00:00 | C.PRK-DELISTED | Stock | 0.4 | 0.4 | 0.4 | 0.4 | 5000.0 |
| 2013-07-04 11:00:00 | C.K | Stock | 5.26 | 5.26 | 5.24 | 5.24 | 48700.0 |
| 2013-07-04 11:00:00 | C.K-DELISTED | Stock | 5.26 | 5.26 | 5.24 | 5.24 | 48700.0 |
| 2013-07-04 11:00:00 | C.L-DELISTED | Stock | 47.47 | 47.505 | 47.33 | 47.44 | 23300.0 |
| 2013-07-04 11:00:00 | C.PRC-DELISTED | Stock | 0.035 | 0.035 | 0.035 | 0.035 | 1000.0 |
| 2013-07-04 11:00:00 | C.PRJ-DELISTED | Stock | 0.56 | 0.57 | 0.54 | 0.55 | 6000.0 |
| 2013-07-04 12:00:00 | C.C-DELISTED | Stock | 0.005 | 0.005 | 0.005 | 0.005 | 262000.0 |
| 2013-07-04 12:00:00 | C.K | Stock | 5.24 | 5.25 | 5.23 | 5.23 | 15500.0 |
| 2013-07-04 12:00:00 | C.K-DELISTED | Stock | 5.24 | 5.25 | 5.23 | 5.23 | 15500.0 |
| 2013-07-04 12:00:00 | C.L-DELISTED | Stock | 47.46 | 47.5 | 47.45 | 47.46 | 28600.0 |
| 2013-07-04 12:00:00 | C.PRJ-DELISTED | Stock | 0.54 | 0.54 | 0.54 | 0.54 | 5000.0 |
| 2013-07-04 13:00:00 | C.K | Stock | 5.23 | 5.27 | 5.23 | 5.25 | 26500.0 |
| 2013-07-04 13:00:00 | C.K-DELISTED | Stock | 5.23 | 5.27 | 5.23 | 5.25 | 26500.0 |
| 2013-07-04 13:00:00 | C.L-DELISTED | Stock | 47.47 | 47.5 | 47.47 | 47.49 | 4400.0 |
| 2013-07-04 13:00:00 | C.PRJ-DELISTED | Stock | 0.55 | 0.55 | 0.55 | 0.55 | 1500.0 |
| 2013-07-04 13:00:00 | C.PRK-DELISTED | Stock | 0.4 | 0.4 | 0.4 | 0.4 | 10000.0 |
| 2013-07-04 14:00:00 | C.K | Stock | 5.25 | 5.25 | 5.24 | 5.24 | 13400.0 |
| 2013-07-04 14:00:00 | C.K-DELISTED | Stock | 5.25 | 5.25 | 5.24 | 5.24 | 13400.0 |
| 2013-07-04 14:00:00 | C.L-DELISTED | Stock | 47.5 | 47.625 | 47.4 | 47.45 | 80800.0 |
| 2013-07-04 14:00:00 | C.PRJ-DELISTED | Stock | 0.55 | 0.55 | 0.54 | 0.54 | 10500.0 |
| 2013-07-04 15:00:00 | C.K | Stock | 5.24 | 5.27 | 5.23 | 5.25 | 56000.0 |
| 2013-07-04 15:00:00 | C.K-DELISTED | Stock | 5.24 | 5.27 | 5.23 | 5.25 | 56000.0 |
| 2013-07-04 15:00:00 | C.L-DELISTED | Stock | 47.45 | 47.49 | 47.39 | 47.4 | 18500.0 |
| 2013-07-04 15:00:00 | C.PRJ-DELISTED | Stock | 0.55 | 0.55 | 0.55 | 0.55 | 3000.0 |
| 2013-07-04 16:00:00 | C.K | Stock | 5.23 | 5.23 | 5.23 | 5.23 | 14900.0 |
| 2013-07-04 16:00:00 | C.K-DELISTED | Stock | 5.23 | 5.23 | 5.23 | 5.23 | 14900.0 |
| 2013-07-04 16:00:00 | C.L-DELISTED | Stock | 47.48 | 47.48 | 47.48 | 47.48 | 13100.0 |
> showing 35 of 35 rows — these rows as CSV