PREVIEW / stock_1hour / 2008-07-04
file: by_date/stock_1hour/2008/2008-07-04.parquet size: 6 KB rows: 30 symbols: 4
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-07-04 09:00:00 | C.K | Stock | 22.92 | 23.37 | 22.88 | 22.95 | 177000.0 |
| 2008-07-04 09:00:00 | C.K-DELISTED | Stock | 22.92 | 23.37 | 22.88 | 22.95 | 177000.0 |
| 2008-07-04 09:00:00 | C.L-DELISTED | Stock | 30.5 | 30.9 | 30.33 | 30.39 | 18800.0 |
| 2008-07-04 09:00:00 | C.PRP-DELISTED | Stock | 0.37 | 0.37 | 0.365 | 0.365 | 1000.0 |
| 2008-07-04 10:00:00 | C.K | Stock | 22.95 | 23.06 | 22.9 | 22.97 | 74900.0 |
| 2008-07-04 10:00:00 | C.K-DELISTED | Stock | 22.95 | 23.06 | 22.9 | 22.97 | 74900.0 |
| 2008-07-04 10:00:00 | C.L-DELISTED | Stock | 30.35 | 30.58 | 30.2 | 30.5 | 16300.0 |
| 2008-07-04 11:00:00 | C.K | Stock | 22.97 | 23.03 | 22.87 | 22.95 | 147300.0 |
| 2008-07-04 11:00:00 | C.K-DELISTED | Stock | 22.97 | 23.03 | 22.87 | 22.95 | 147300.0 |
| 2008-07-04 11:00:00 | C.L-DELISTED | Stock | 30.5 | 30.67 | 30.35 | 30.41 | 19900.0 |
| 2008-07-04 11:00:00 | C.PRP-DELISTED | Stock | 0.365 | 0.38 | 0.365 | 0.38 | 54500.0 |
| 2008-07-04 12:00:00 | C.K | Stock | 22.96 | 23.05 | 22.91 | 22.96 | 278400.0 |
| 2008-07-04 12:00:00 | C.K-DELISTED | Stock | 22.96 | 23.05 | 22.91 | 22.96 | 278400.0 |
| 2008-07-04 12:00:00 | C.L-DELISTED | Stock | 30.41 | 30.42 | 30.21 | 30.3 | 8700.0 |
| 2008-07-04 12:00:00 | C.PRP-DELISTED | Stock | 0.385 | 0.385 | 0.38 | 0.38 | 13000.0 |
| 2008-07-04 13:00:00 | C.K | Stock | 22.95 | 23.15 | 22.94 | 23.15 | 102300.0 |
| 2008-07-04 13:00:00 | C.K-DELISTED | Stock | 22.95 | 23.15 | 22.94 | 23.15 | 102300.0 |
| 2008-07-04 13:00:00 | C.L-DELISTED | Stock | 30.33 | 30.51 | 30.28 | 30.35 | 10100.0 |
| 2008-07-04 13:00:00 | C.PRK-DELISTED | Stock | 5.02 | 5.02 | 5.02 | 5.02 | 400.0 |
| 2008-07-04 13:00:00 | C.PRP-DELISTED | Stock | 0.38 | 0.38 | 0.38 | 0.38 | 2000.0 |
| 2008-07-04 14:00:00 | C.K | Stock | 23.13 | 23.15 | 23.0 | 23.1 | 78600.0 |
| 2008-07-04 14:00:00 | C.K-DELISTED | Stock | 23.13 | 23.15 | 23.0 | 23.1 | 78600.0 |
| 2008-07-04 14:00:00 | C.L-DELISTED | Stock | 30.5 | 30.63 | 30.34 | 30.43 | 13300.0 |
| 2008-07-04 15:00:00 | C.K | Stock | 23.13 | 23.2 | 23.01 | 23.18 | 163000.0 |
| 2008-07-04 15:00:00 | C.K-DELISTED | Stock | 23.13 | 23.2 | 23.01 | 23.18 | 163000.0 |
| 2008-07-04 15:00:00 | C.L-DELISTED | Stock | 30.45 | 30.54 | 30.2 | 30.5 | 21700.0 |
| 2008-07-04 15:00:00 | C.PRP-DELISTED | Stock | 0.375 | 0.375 | 0.375 | 0.375 | 24500.0 |
| 2008-07-04 16:00:00 | C.K | Stock | 23.18 | 23.18 | 23.18 | 23.18 | 64200.0 |
| 2008-07-04 16:00:00 | C.K-DELISTED | Stock | 23.18 | 23.18 | 23.18 | 23.18 | 64200.0 |
| 2008-07-04 16:00:00 | C.L-DELISTED | Stock | 30.2 | 30.2 | 30.2 | 30.2 | 1500.0 |
> showing 30 of 30 rows — these rows as CSV