PREVIEW / stock_1hour / 2009-05-25
file: by_date/stock_1hour/2009/2009-05-25.parquet size: 6 KB rows: 34 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-05-25 09:00:00 | C.C-DELISTED | Stock | 0.075 | 0.075 | 0.07 | 0.07 | 3000.0 |
| 2009-05-25 09:00:00 | C.K | Stock | 21.4 | 21.4 | 21.08 | 21.23 | 93600.0 |
| 2009-05-25 09:00:00 | C.K-DELISTED | Stock | 21.4 | 21.4 | 21.08 | 21.23 | 93600.0 |
| 2009-05-25 09:00:00 | C.L-DELISTED | Stock | 35.4 | 35.59 | 35.4 | 35.5 | 5500.0 |
| 2009-05-25 09:00:00 | C.PRP-DELISTED | Stock | 0.22 | 0.22 | 0.22 | 0.22 | 500.0 |
| 2009-05-25 10:00:00 | C.K | Stock | 21.24 | 21.44 | 21.23 | 21.29 | 102000.0 |
| 2009-05-25 10:00:00 | C.K-DELISTED | Stock | 21.24 | 21.44 | 21.23 | 21.29 | 102000.0 |
| 2009-05-25 10:00:00 | C.L-DELISTED | Stock | 35.49 | 35.6 | 35.38 | 35.52 | 8100.0 |
| 2009-05-25 10:00:00 | C.PRK-DELISTED | Stock | 3.4 | 3.4 | 3.4 | 3.4 | 500.0 |
| 2009-05-25 11:00:00 | C.K | Stock | 21.29 | 21.3 | 21.18 | 21.23 | 78700.0 |
| 2009-05-25 11:00:00 | C.K-DELISTED | Stock | 21.29 | 21.3 | 21.18 | 21.23 | 78700.0 |
| 2009-05-25 11:00:00 | C.L-DELISTED | Stock | 35.52 | 35.6 | 35.41 | 35.41 | 10300.0 |
| 2009-05-25 11:00:00 | C.PRP-DELISTED | Stock | 0.23 | 0.25 | 0.23 | 0.25 | 65000.0 |
| 2009-05-25 12:00:00 | C.K | Stock | 21.23 | 21.27 | 21.2 | 21.21 | 30200.0 |
| 2009-05-25 12:00:00 | C.K-DELISTED | Stock | 21.23 | 21.27 | 21.2 | 21.21 | 30200.0 |
| 2009-05-25 12:00:00 | C.L-DELISTED | Stock | 35.44 | 35.44 | 35.25 | 35.25 | 30600.0 |
| 2009-05-25 12:00:00 | C.PRK-DELISTED | Stock | 3.45 | 3.45 | 3.45 | 3.45 | 1400.0 |
| 2009-05-25 12:00:00 | C.PRP-DELISTED | Stock | 0.225 | 0.245 | 0.225 | 0.245 | 9500.0 |
| 2009-05-25 13:00:00 | C.C-DELISTED | Stock | 0.09 | 0.09 | 0.07 | 0.07 | 10000.0 |
| 2009-05-25 13:00:00 | C.K | Stock | 21.24 | 21.32 | 21.18 | 21.23 | 36800.0 |
| 2009-05-25 13:00:00 | C.K-DELISTED | Stock | 21.24 | 21.32 | 21.18 | 21.23 | 36800.0 |
| 2009-05-25 13:00:00 | C.L-DELISTED | Stock | 35.25 | 35.34 | 35.25 | 35.31 | 9300.0 |
| 2009-05-25 13:00:00 | C.PRP-DELISTED | Stock | 0.24 | 0.24 | 0.24 | 0.24 | 40000.0 |
| 2009-05-25 14:00:00 | C.K | Stock | 21.23 | 21.24 | 21.03 | 21.07 | 77400.0 |
| 2009-05-25 14:00:00 | C.K-DELISTED | Stock | 21.23 | 21.24 | 21.03 | 21.07 | 77400.0 |
| 2009-05-25 14:00:00 | C.L-DELISTED | Stock | 35.29 | 35.3 | 35.07 | 35.25 | 22600.0 |
| 2009-05-25 14:00:00 | C.PRP-DELISTED | Stock | 0.235 | 0.235 | 0.235 | 0.235 | 15000.0 |
| 2009-05-25 15:00:00 | C.K | Stock | 21.08 | 21.12 | 21.05 | 21.09 | 109400.0 |
| 2009-05-25 15:00:00 | C.K-DELISTED | Stock | 21.08 | 21.12 | 21.05 | 21.09 | 109400.0 |
| 2009-05-25 15:00:00 | C.L-DELISTED | Stock | 35.25 | 35.43 | 35.16 | 35.43 | 27900.0 |
| 2009-05-25 15:00:00 | C.PRP-DELISTED | Stock | 0.235 | 0.235 | 0.235 | 0.235 | 10000.0 |
| 2009-05-25 16:00:00 | C.K | Stock | 21.09 | 21.09 | 21.09 | 21.09 | 99400.0 |
| 2009-05-25 16:00:00 | C.K-DELISTED | Stock | 21.09 | 21.09 | 21.09 | 21.09 | 99400.0 |
| 2009-05-25 16:00:00 | C.L-DELISTED | Stock | 35.27 | 35.27 | 35.27 | 35.27 | 15400.0 |
> showing 34 of 34 rows — these rows as CSV