PREVIEW / stock_1hour / 2013-05-27
file: by_date/stock_1hour/2013/2013-05-27.parquet size: 6 KB rows: 39 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-05-27 09:00:00 | C.K | Stock | 6.05 | 6.09 | 6.05 | 6.05 | 338100.0 |
| 2013-05-27 09:00:00 | C.K-DELISTED | Stock | 6.05 | 6.09 | 6.05 | 6.05 | 338100.0 |
| 2013-05-27 09:00:00 | C.L-DELISTED | Stock | 49.11 | 49.85 | 49.11 | 49.83 | 100000.0 |
| 2013-05-27 09:00:00 | C.PRJ-DELISTED | Stock | 0.73 | 0.73 | 0.71 | 0.73 | 35500.0 |
| 2013-05-27 09:00:00 | C.PRP-DELISTED | Stock | 0.2 | 0.2 | 0.2 | 0.2 | 1000.0 |
| 2013-05-27 10:00:00 | C.K | Stock | 6.06 | 6.06 | 6.02 | 6.03 | 54500.0 |
| 2013-05-27 10:00:00 | C.K-DELISTED | Stock | 6.06 | 6.06 | 6.02 | 6.03 | 54500.0 |
| 2013-05-27 10:00:00 | C.L-DELISTED | Stock | 49.81 | 49.99 | 49.71 | 49.74 | 31800.0 |
| 2013-05-27 10:00:00 | C.PRP-DELISTED | Stock | 0.16 | 0.18 | 0.16 | 0.18 | 2000.0 |
| 2013-05-27 11:00:00 | C.C-DELISTED | Stock | 0.02 | 0.02 | 0.02 | 0.02 | 1000.0 |
| 2013-05-27 11:00:00 | C.K | Stock | 6.04 | 6.04 | 6.02 | 6.03 | 27300.0 |
| 2013-05-27 11:00:00 | C.K-DELISTED | Stock | 6.04 | 6.04 | 6.02 | 6.03 | 27300.0 |
| 2013-05-27 11:00:00 | C.L-DELISTED | Stock | 49.78 | 49.83 | 49.69 | 49.77 | 42500.0 |
| 2013-05-27 11:00:00 | C.PRP-DELISTED | Stock | 0.13 | 0.175 | 0.1 | 0.14 | 22000.0 |
| 2013-05-27 12:00:00 | C.K | Stock | 6.04 | 6.04 | 6.02 | 6.02 | 63800.0 |
| 2013-05-27 12:00:00 | C.K-DELISTED | Stock | 6.04 | 6.04 | 6.02 | 6.02 | 63800.0 |
| 2013-05-27 12:00:00 | C.L-DELISTED | Stock | 49.77 | 49.99 | 49.7 | 49.83 | 16600.0 |
| 2013-05-27 12:00:00 | C.PRJ-DELISTED | Stock | 0.72 | 0.72 | 0.72 | 0.72 | 1000.0 |
| 2013-05-27 12:00:00 | C.PRP-DELISTED | Stock | 0.15 | 0.16 | 0.12 | 0.135 | 13000.0 |
| 2013-05-27 13:00:00 | C.C-DELISTED | Stock | 0.015 | 0.015 | 0.015 | 0.015 | 4000.0 |
| 2013-05-27 13:00:00 | C.K | Stock | 6.02 | 6.03 | 6.02 | 6.02 | 44300.0 |
| 2013-05-27 13:00:00 | C.K-DELISTED | Stock | 6.02 | 6.03 | 6.02 | 6.02 | 44300.0 |
| 2013-05-27 13:00:00 | C.L-DELISTED | Stock | 49.83 | 49.85 | 49.57 | 49.69 | 35200.0 |
| 2013-05-27 13:00:00 | C.PRJ-DELISTED | Stock | 0.72 | 0.72 | 0.72 | 0.72 | 500.0 |
| 2013-05-27 14:00:00 | C.K | Stock | 6.03 | 6.03 | 6.02 | 6.02 | 5300.0 |
| 2013-05-27 14:00:00 | C.K-DELISTED | Stock | 6.03 | 6.03 | 6.02 | 6.02 | 5300.0 |
| 2013-05-27 14:00:00 | C.L-DELISTED | Stock | 49.69 | 49.76 | 49.66 | 49.68 | 8100.0 |
| 2013-05-27 14:00:00 | C.PRK-DELISTED | Stock | 0.4 | 0.4 | 0.4 | 0.4 | 10000.0 |
| 2013-05-27 15:00:00 | C.K | Stock | 6.02 | 6.03 | 6.02 | 6.02 | 30400.0 |
| 2013-05-27 15:00:00 | C.K-DELISTED | Stock | 6.02 | 6.03 | 6.02 | 6.02 | 30400.0 |
| 2013-05-27 15:00:00 | C.L-DELISTED | Stock | 49.69 | 49.8 | 49.65 | 49.69 | 13200.0 |
| 2013-05-27 15:00:00 | C.PRJ-DELISTED | Stock | 0.72 | 0.72 | 0.72 | 0.72 | 36000.0 |
| 2013-05-27 16:00:00 | C.K | Stock | 6.02 | 6.02 | 6.02 | 6.02 | 22600.0 |
| 2013-05-27 16:00:00 | C.K-DELISTED | Stock | 6.02 | 6.02 | 6.02 | 6.02 | 22600.0 |
| 2013-05-27 16:00:00 | C.L-DELISTED | Stock | 49.69 | 49.69 | 49.69 | 49.69 | 3300.0 |
> showing 35 of 39 rows — these rows as CSV