PREVIEW / stock_1hour / 2008-01-21
file: by_date/stock_1hour/2008/2008-01-21.parquet size: 6 KB rows: 28 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 |
|---|---|---|---|---|---|---|---|
| 2008-01-21 09:00:00 | C.K | Stock | 19.6 | 19.67 | 19.26 | 19.5 | 595711.0 |
| 2008-01-21 09:00:00 | C.K-DELISTED | Stock | 19.6 | 19.67 | 19.26 | 19.5 | 595711.0 |
| 2008-01-21 09:00:00 | C.L-DELISTED | Stock | 33.8 | 33.8 | 33.28 | 33.5 | 37146.0 |
| 2008-01-21 09:00:00 | C.PRK-DELISTED | Stock | 5.11 | 5.11 | 5.11 | 5.11 | 1000.0 |
| 2008-01-21 10:00:00 | C.K | Stock | 19.5 | 20.0 | 19.38 | 19.96 | 452155.0 |
| 2008-01-21 10:00:00 | C.K-DELISTED | Stock | 19.5 | 20.0 | 19.38 | 19.96 | 452155.0 |
| 2008-01-21 10:00:00 | C.L-DELISTED | Stock | 33.5 | 33.65 | 33.3 | 33.5 | 38967.0 |
| 2008-01-21 11:00:00 | C.K | Stock | 19.96 | 20.05 | 19.78 | 19.85 | 309365.0 |
| 2008-01-21 11:00:00 | C.K-DELISTED | Stock | 19.96 | 20.05 | 19.78 | 19.85 | 309365.0 |
| 2008-01-21 11:00:00 | C.L-DELISTED | Stock | 33.46 | 33.49 | 33.24 | 33.26 | 25839.0 |
| 2008-01-21 11:00:00 | C.PRK-DELISTED | Stock | 5.11 | 5.11 | 5.11 | 5.11 | 65.0 |
| 2008-01-21 12:00:00 | C.K | Stock | 19.82 | 20.05 | 19.72 | 19.99 | 204924.0 |
| 2008-01-21 12:00:00 | C.K-DELISTED | Stock | 19.82 | 20.05 | 19.72 | 19.99 | 204924.0 |
| 2008-01-21 12:00:00 | C.L-DELISTED | Stock | 33.26 | 33.4 | 33.15 | 33.15 | 28609.0 |
| 2008-01-21 13:00:00 | C.K | Stock | 19.99 | 20.02 | 19.82 | 19.89 | 110522.0 |
| 2008-01-21 13:00:00 | C.K-DELISTED | Stock | 19.99 | 20.02 | 19.82 | 19.89 | 110522.0 |
| 2008-01-21 13:00:00 | C.L-DELISTED | Stock | 33.12 | 33.12 | 32.55 | 33.0 | 101268.0 |
| 2008-01-21 13:00:00 | C.PRK-DELISTED | Stock | 5.11 | 5.11 | 5.11 | 5.11 | 1.0 |
| 2008-01-21 14:00:00 | C.K | Stock | 19.89 | 19.94 | 19.75 | 19.76 | 168981.0 |
| 2008-01-21 14:00:00 | C.K-DELISTED | Stock | 19.89 | 19.94 | 19.75 | 19.76 | 168981.0 |
| 2008-01-21 14:00:00 | C.L-DELISTED | Stock | 33.03 | 33.22 | 33.0 | 33.09 | 24715.0 |
| 2008-01-21 14:00:00 | C.PRK-DELISTED | Stock | 5.46 | 5.5 | 5.46 | 5.5 | 900.0 |
| 2008-01-21 15:00:00 | C.K | Stock | 19.77 | 19.84 | 19.75 | 19.79 | 645109.0 |
| 2008-01-21 15:00:00 | C.K-DELISTED | Stock | 19.77 | 19.84 | 19.75 | 19.79 | 645109.0 |
| 2008-01-21 15:00:00 | C.L-DELISTED | Stock | 33.09 | 33.35 | 32.75 | 33.13 | 117067.0 |
| 2008-01-21 16:00:00 | C.K | Stock | 19.66 | 19.66 | 19.66 | 19.66 | 420800.0 |
| 2008-01-21 16:00:00 | C.K-DELISTED | Stock | 19.66 | 19.66 | 19.66 | 19.66 | 420800.0 |
| 2008-01-21 16:00:00 | C.L-DELISTED | Stock | 33.02 | 33.02 | 33.02 | 33.02 | 53900.0 |
> showing 28 of 28 rows — these rows as CSV