PREVIEW / stock_1hour / 2008-11-27
file: by_date/stock_1hour/2008/2008-11-27.parquet size: 6 KB rows: 31 symbols: 5
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-11-27 09:00:00 | C.K | Stock | 18.05 | 18.3 | 18.05 | 18.17 | 113600.0 |
| 2008-11-27 09:00:00 | C.K-DELISTED | Stock | 18.05 | 18.3 | 18.05 | 18.17 | 113600.0 |
| 2008-11-27 09:00:00 | C.L-DELISTED | Stock | 31.25 | 31.25 | 31.05 | 31.25 | 8300.0 |
| 2008-11-27 10:00:00 | C.K | Stock | 18.17 | 18.63 | 18.16 | 18.47 | 270800.0 |
| 2008-11-27 10:00:00 | C.K-DELISTED | Stock | 18.17 | 18.63 | 18.16 | 18.47 | 270800.0 |
| 2008-11-27 10:00:00 | C.L-DELISTED | Stock | 31.1 | 31.15 | 30.78 | 30.85 | 13800.0 |
| 2008-11-27 10:00:00 | C.PRK-DELISTED | Stock | 2.18 | 2.18 | 2.15 | 2.15 | 6800.0 |
| 2008-11-27 11:00:00 | C.K | Stock | 18.45 | 18.55 | 18.35 | 18.4 | 61800.0 |
| 2008-11-27 11:00:00 | C.K-DELISTED | Stock | 18.45 | 18.55 | 18.35 | 18.4 | 61800.0 |
| 2008-11-27 11:00:00 | C.L-DELISTED | Stock | 30.89 | 31.0 | 30.75 | 30.98 | 20500.0 |
| 2008-11-27 11:00:00 | C.PRK-DELISTED | Stock | 2.14 | 2.15 | 2.14 | 2.15 | 22000.0 |
| 2008-11-27 12:00:00 | C.K | Stock | 18.4 | 18.5 | 18.21 | 18.25 | 77300.0 |
| 2008-11-27 12:00:00 | C.K-DELISTED | Stock | 18.4 | 18.5 | 18.21 | 18.25 | 77300.0 |
| 2008-11-27 12:00:00 | C.L-DELISTED | Stock | 30.97 | 31.14 | 30.96 | 31.07 | 6600.0 |
| 2008-11-27 13:00:00 | C.C-DELISTED | Stock | 0.05 | 0.05 | 0.05 | 0.05 | 1000.0 |
| 2008-11-27 13:00:00 | C.K | Stock | 18.26 | 18.46 | 18.2 | 18.42 | 42700.0 |
| 2008-11-27 13:00:00 | C.K-DELISTED | Stock | 18.26 | 18.46 | 18.2 | 18.42 | 42700.0 |
| 2008-11-27 13:00:00 | C.L-DELISTED | Stock | 31.02 | 31.12 | 30.9 | 30.98 | 6900.0 |
| 2008-11-27 13:00:00 | C.PRK-DELISTED | Stock | 2.12 | 2.16 | 2.12 | 2.16 | 39500.0 |
| 2008-11-27 14:00:00 | C.K | Stock | 18.42 | 18.46 | 18.31 | 18.42 | 35600.0 |
| 2008-11-27 14:00:00 | C.K-DELISTED | Stock | 18.42 | 18.46 | 18.31 | 18.42 | 35600.0 |
| 2008-11-27 14:00:00 | C.L-DELISTED | Stock | 30.98 | 31.15 | 30.91 | 31.13 | 13100.0 |
| 2008-11-27 14:00:00 | C.PRK-DELISTED | Stock | 2.15 | 2.15 | 2.12 | 2.12 | 17400.0 |
| 2008-11-27 15:00:00 | C.K | Stock | 18.42 | 18.57 | 18.42 | 18.47 | 188000.0 |
| 2008-11-27 15:00:00 | C.K-DELISTED | Stock | 18.42 | 18.57 | 18.42 | 18.47 | 188000.0 |
| 2008-11-27 15:00:00 | C.L-DELISTED | Stock | 31.12 | 31.5 | 31.04 | 31.48 | 61300.0 |
| 2008-11-27 15:00:00 | C.PRK-DELISTED | Stock | 2.15 | 2.15 | 2.14 | 2.15 | 15000.0 |
| 2008-11-27 15:00:00 | C.PRP-DELISTED | Stock | 0.15 | 0.15 | 0.15 | 0.15 | 4000.0 |
| 2008-11-27 16:00:00 | C.K | Stock | 18.59 | 18.59 | 18.59 | 18.59 | 32400.0 |
| 2008-11-27 16:00:00 | C.K-DELISTED | Stock | 18.59 | 18.59 | 18.59 | 18.59 | 32400.0 |
| 2008-11-27 16:00:00 | C.L-DELISTED | Stock | 31.14 | 31.14 | 31.14 | 31.14 | 11700.0 |
> showing 31 of 31 rows — these rows as CSV