PREVIEW / stock_1hour / 2009-11-26
file: by_date/stock_1hour/2009/2009-11-26.parquet size: 6 KB rows: 40 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 |
|---|---|---|---|---|---|---|---|
| 2009-11-26 09:00:00 | C.K | Stock | 21.01 | 21.05 | 20.81 | 20.84 | 207500.0 |
| 2009-11-26 09:00:00 | C.K-DELISTED | Stock | 21.01 | 21.05 | 20.81 | 20.84 | 207500.0 |
| 2009-11-26 09:00:00 | C.L-DELISTED | Stock | 32.71 | 32.9 | 32.66 | 32.84 | 20800.0 |
| 2009-11-26 09:00:00 | C.PRK-DELISTED | Stock | 4.2 | 4.2 | 4.2 | 4.2 | 2000.0 |
| 2009-11-26 09:00:00 | C.PRP-DELISTED | Stock | 0.135 | 0.135 | 0.135 | 0.135 | 35000.0 |
| 2009-11-26 10:00:00 | C.K | Stock | 20.87 | 20.89 | 20.6 | 20.62 | 209600.0 |
| 2009-11-26 10:00:00 | C.K-DELISTED | Stock | 20.87 | 20.89 | 20.6 | 20.62 | 209600.0 |
| 2009-11-26 10:00:00 | C.L-DELISTED | Stock | 32.83 | 32.94 | 32.68 | 32.85 | 92600.0 |
| 2009-11-26 10:00:00 | C.PRK-DELISTED | Stock | 4.2 | 4.2 | 4.19 | 4.19 | 3000.0 |
| 2009-11-26 10:00:00 | C.PRP-DELISTED | Stock | 0.13 | 0.13 | 0.13 | 0.13 | 1000.0 |
| 2009-11-26 11:00:00 | C.C-DELISTED | Stock | 0.075 | 0.075 | 0.075 | 0.075 | 4000.0 |
| 2009-11-26 11:00:00 | C.K | Stock | 20.62 | 20.68 | 20.49 | 20.53 | 341900.0 |
| 2009-11-26 11:00:00 | C.K-DELISTED | Stock | 20.62 | 20.68 | 20.49 | 20.53 | 341900.0 |
| 2009-11-26 11:00:00 | C.L-DELISTED | Stock | 32.82 | 32.94 | 32.81 | 32.9 | 32600.0 |
| 2009-11-26 11:00:00 | C.PRK-DELISTED | Stock | 4.19 | 4.19 | 4.19 | 4.19 | 300.0 |
| 2009-11-26 11:00:00 | C.PRP-DELISTED | Stock | 0.13 | 0.13 | 0.13 | 0.13 | 5000.0 |
| 2009-11-26 12:00:00 | C.K | Stock | 20.53 | 20.69 | 20.53 | 20.66 | 136900.0 |
| 2009-11-26 12:00:00 | C.K-DELISTED | Stock | 20.53 | 20.69 | 20.53 | 20.66 | 136900.0 |
| 2009-11-26 12:00:00 | C.L-DELISTED | Stock | 32.89 | 33.09 | 32.8 | 32.92 | 23700.0 |
| 2009-11-26 12:00:00 | C.PRK-DELISTED | Stock | 4.19 | 4.19 | 4.19 | 4.19 | 100.0 |
| 2009-11-26 12:00:00 | C.PRP-DELISTED | Stock | 0.135 | 0.135 | 0.135 | 0.135 | 11500.0 |
| 2009-11-26 13:00:00 | C.K | Stock | 20.66 | 20.77 | 20.6 | 20.74 | 143700.0 |
| 2009-11-26 13:00:00 | C.K-DELISTED | Stock | 20.66 | 20.77 | 20.6 | 20.74 | 143700.0 |
| 2009-11-26 13:00:00 | C.L-DELISTED | Stock | 32.94 | 32.96 | 32.82 | 32.9 | 31200.0 |
| 2009-11-26 13:00:00 | C.PRC-DELISTED | Stock | 0.255 | 0.255 | 0.255 | 0.255 | 4000.0 |
| 2009-11-26 13:00:00 | C.PRK-DELISTED | Stock | 4.19 | 4.2 | 4.11 | 4.11 | 3500.0 |
| 2009-11-26 13:00:00 | C.PRP-DELISTED | Stock | 0.135 | 0.135 | 0.135 | 0.135 | 18500.0 |
| 2009-11-26 14:00:00 | C.C-DELISTED | Stock | 0.065 | 0.065 | 0.065 | 0.065 | 13000.0 |
| 2009-11-26 14:00:00 | C.K | Stock | 20.71 | 20.81 | 20.7 | 20.73 | 105300.0 |
| 2009-11-26 14:00:00 | C.K-DELISTED | Stock | 20.71 | 20.81 | 20.7 | 20.73 | 105300.0 |
| 2009-11-26 14:00:00 | C.L-DELISTED | Stock | 32.91 | 33.0 | 32.88 | 32.95 | 35900.0 |
| 2009-11-26 14:00:00 | C.PRP-DELISTED | Stock | 0.135 | 0.135 | 0.135 | 0.135 | 23500.0 |
| 2009-11-26 15:00:00 | C.K | Stock | 20.72 | 20.79 | 20.6 | 20.62 | 216300.0 |
| 2009-11-26 15:00:00 | C.K-DELISTED | Stock | 20.72 | 20.79 | 20.6 | 20.62 | 216300.0 |
| 2009-11-26 15:00:00 | C.L-DELISTED | Stock | 32.92 | 33.15 | 32.92 | 33.06 | 49000.0 |
| 2009-11-26 15:00:00 | C.PRK-DELISTED | Stock | 4.2 | 4.2 | 4.2 | 4.2 | 1200.0 |
| 2009-11-26 15:00:00 | C.PRP-DELISTED | Stock | 0.135 | 0.135 | 0.13 | 0.135 | 28500.0 |
| 2009-11-26 16:00:00 | C.K | Stock | 20.6 | 20.6 | 20.6 | 20.6 | 39200.0 |
| 2009-11-26 16:00:00 | C.K-DELISTED | Stock | 20.6 | 20.6 | 20.6 | 20.6 | 39200.0 |
| 2009-11-26 16:00:00 | C.L-DELISTED | Stock | 32.9 | 32.9 | 32.9 | 32.9 | 3200.0 |
> showing 40 of 40 rows — these rows as CSV