PREVIEW / stock_1hour / 2007-07-04
file: by_date/stock_1hour/2007/2007-07-04.parquet size: 5 KB rows: 27 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 |
|---|---|---|---|---|---|---|---|
| 2007-07-04 09:00:00 | C.K | Stock | 13.12 | 13.12 | 12.96 | 13.05 | 535000.0 |
| 2007-07-04 09:00:00 | C.K-DELISTED | Stock | 13.12 | 13.12 | 12.96 | 13.05 | 535000.0 |
| 2007-07-04 09:00:00 | C.L-DELISTED | Stock | 51.75 | 52.15 | 51.75 | 52.1 | 10900.0 |
| 2007-07-04 10:00:00 | C.K | Stock | 13.05 | 13.1 | 13.05 | 13.06 | 527600.0 |
| 2007-07-04 10:00:00 | C.K-DELISTED | Stock | 13.05 | 13.1 | 13.05 | 13.06 | 527600.0 |
| 2007-07-04 10:00:00 | C.L-DELISTED | Stock | 52.06 | 52.2 | 52.02 | 52.15 | 17100.0 |
| 2007-07-04 11:00:00 | C.K | Stock | 13.05 | 13.05 | 12.98 | 13.0 | 788200.0 |
| 2007-07-04 11:00:00 | C.K-DELISTED | Stock | 13.05 | 13.05 | 12.98 | 13.0 | 788200.0 |
| 2007-07-04 11:00:00 | C.L-DELISTED | Stock | 52.15 | 52.19 | 52.01 | 52.03 | 10900.0 |
| 2007-07-04 12:00:00 | C.K | Stock | 13.0 | 13.07 | 13.0 | 13.07 | 135400.0 |
| 2007-07-04 12:00:00 | C.K-DELISTED | Stock | 13.0 | 13.07 | 13.0 | 13.07 | 135400.0 |
| 2007-07-04 12:00:00 | C.L-DELISTED | Stock | 52.03 | 52.08 | 51.84 | 52.04 | 25900.0 |
| 2007-07-04 12:00:00 | C.PRK-DELISTED | Stock | 6.65 | 6.65 | 6.65 | 6.65 | 2800.0 |
| 2007-07-04 13:00:00 | C.K | Stock | 13.06 | 13.06 | 12.99 | 13.01 | 145900.0 |
| 2007-07-04 13:00:00 | C.K-DELISTED | Stock | 13.06 | 13.06 | 12.99 | 13.01 | 145900.0 |
| 2007-07-04 13:00:00 | C.L-DELISTED | Stock | 52.05 | 52.05 | 52.0 | 52.01 | 10300.0 |
| 2007-07-04 13:00:00 | C.PRK-DELISTED | Stock | 6.6 | 6.6 | 6.6 | 6.6 | 500.0 |
| 2007-07-04 14:00:00 | C.K | Stock | 13.01 | 13.01 | 12.95 | 12.98 | 183500.0 |
| 2007-07-04 14:00:00 | C.K-DELISTED | Stock | 13.01 | 13.01 | 12.95 | 12.98 | 183500.0 |
| 2007-07-04 14:00:00 | C.L-DELISTED | Stock | 52.05 | 52.05 | 52.0 | 52.0 | 7400.0 |
| 2007-07-04 15:00:00 | C.K | Stock | 12.99 | 13.06 | 12.99 | 13.02 | 330200.0 |
| 2007-07-04 15:00:00 | C.K-DELISTED | Stock | 12.99 | 13.06 | 12.99 | 13.02 | 330200.0 |
| 2007-07-04 15:00:00 | C.L-DELISTED | Stock | 52.0 | 52.05 | 51.82 | 51.83 | 22300.0 |
| 2007-07-04 15:00:00 | C.PRK-DELISTED | Stock | 6.6 | 6.6 | 6.55 | 6.55 | 400.0 |
| 2007-07-04 16:00:00 | C.K | Stock | 13.02 | 13.02 | 13.02 | 13.02 | 11700.0 |
| 2007-07-04 16:00:00 | C.K-DELISTED | Stock | 13.02 | 13.02 | 13.02 | 13.02 | 11700.0 |
| 2007-07-04 16:00:00 | C.L-DELISTED | Stock | 51.83 | 51.83 | 51.83 | 51.83 | 1700.0 |
> showing 27 of 27 rows — these rows as CSV