PREVIEW / stock_1hour / 2009-01-19
file: by_date/stock_1hour/2009/2009-01-19.parquet size: 6 KB rows: 27 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 |
|---|---|---|---|---|---|---|---|
| 2009-01-19 09:00:00 | C.K | Stock | 22.23 | 22.26 | 21.94 | 22.0 | 289400.0 |
| 2009-01-19 09:00:00 | C.K-DELISTED | Stock | 22.23 | 22.26 | 21.94 | 22.0 | 289400.0 |
| 2009-01-19 09:00:00 | C.L-DELISTED | Stock | 36.45 | 36.86 | 36.45 | 36.79 | 5400.0 |
| 2009-01-19 10:00:00 | C.K | Stock | 21.99 | 22.01 | 21.76 | 22.0 | 239700.0 |
| 2009-01-19 10:00:00 | C.K-DELISTED | Stock | 21.99 | 22.01 | 21.76 | 22.0 | 239700.0 |
| 2009-01-19 10:00:00 | C.L-DELISTED | Stock | 36.69 | 36.79 | 36.65 | 36.68 | 7500.0 |
| 2009-01-19 11:00:00 | C.C-DELISTED | Stock | 0.07 | 0.07 | 0.07 | 0.07 | 5000.0 |
| 2009-01-19 11:00:00 | C.K | Stock | 21.98 | 22.0 | 21.81 | 21.93 | 122000.0 |
| 2009-01-19 11:00:00 | C.K-DELISTED | Stock | 21.98 | 22.0 | 21.81 | 21.93 | 122000.0 |
| 2009-01-19 11:00:00 | C.L-DELISTED | Stock | 36.71 | 36.79 | 36.62 | 36.77 | 16000.0 |
| 2009-01-19 12:00:00 | C.K | Stock | 21.94 | 21.97 | 21.91 | 21.95 | 52800.0 |
| 2009-01-19 12:00:00 | C.K-DELISTED | Stock | 21.94 | 21.97 | 21.91 | 21.95 | 52800.0 |
| 2009-01-19 12:00:00 | C.L-DELISTED | Stock | 36.76 | 36.76 | 36.6 | 36.75 | 5000.0 |
| 2009-01-19 13:00:00 | C.K | Stock | 21.96 | 22.0 | 21.95 | 22.0 | 56500.0 |
| 2009-01-19 13:00:00 | C.K-DELISTED | Stock | 21.96 | 22.0 | 21.95 | 22.0 | 56500.0 |
| 2009-01-19 13:00:00 | C.L-DELISTED | Stock | 36.73 | 36.74 | 36.59 | 36.73 | 7800.0 |
| 2009-01-19 14:00:00 | C.K | Stock | 22.0 | 22.15 | 21.98 | 22.08 | 224300.0 |
| 2009-01-19 14:00:00 | C.K-DELISTED | Stock | 22.0 | 22.15 | 21.98 | 22.08 | 224300.0 |
| 2009-01-19 14:00:00 | C.L-DELISTED | Stock | 36.73 | 36.73 | 36.57 | 36.68 | 5700.0 |
| 2009-01-19 15:00:00 | C.K | Stock | 22.07 | 22.08 | 21.89 | 21.94 | 175000.0 |
| 2009-01-19 15:00:00 | C.K-DELISTED | Stock | 22.07 | 22.08 | 21.89 | 21.94 | 175000.0 |
| 2009-01-19 15:00:00 | C.L-DELISTED | Stock | 36.68 | 36.83 | 36.61 | 36.63 | 34200.0 |
| 2009-01-19 15:00:00 | C.PRK-DELISTED | Stock | 3.1 | 3.2 | 3.1 | 3.2 | 3600.0 |
| 2009-01-19 15:00:00 | C.PRP-DELISTED | Stock | 0.13 | 0.13 | 0.13 | 0.13 | 500.0 |
| 2009-01-19 16:00:00 | C.K | Stock | 22.0 | 22.0 | 22.0 | 22.0 | 349100.0 |
| 2009-01-19 16:00:00 | C.K-DELISTED | Stock | 22.0 | 22.0 | 22.0 | 22.0 | 349100.0 |
| 2009-01-19 16:00:00 | C.L-DELISTED | Stock | 36.61 | 36.61 | 36.61 | 36.61 | 67600.0 |
> showing 27 of 27 rows — these rows as CSV