PREVIEW / stock_1hour / 2010-05-31
file: by_date/stock_1hour/2010/2010-05-31.parquet size: 6 KB rows: 32 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 |
|---|---|---|---|---|---|---|---|
| 2010-05-31 09:00:00 | C.K | Stock | 18.24 | 18.24 | 18.17 | 18.21 | 51900.0 |
| 2010-05-31 09:00:00 | C.K-DELISTED | Stock | 18.24 | 18.24 | 18.17 | 18.21 | 51900.0 |
| 2010-05-31 09:00:00 | C.L-DELISTED | Stock | 38.8 | 38.85 | 38.67 | 38.83 | 3000.0 |
| 2010-05-31 09:00:00 | C.PRP-DELISTED | Stock | 0.13 | 0.14 | 0.13 | 0.14 | 163000.0 |
| 2010-05-31 10:00:00 | C.K | Stock | 18.21 | 18.25 | 18.18 | 18.18 | 59400.0 |
| 2010-05-31 10:00:00 | C.K-DELISTED | Stock | 18.21 | 18.25 | 18.18 | 18.18 | 59400.0 |
| 2010-05-31 10:00:00 | C.L-DELISTED | Stock | 38.78 | 38.89 | 38.67 | 38.67 | 1800.0 |
| 2010-05-31 10:00:00 | C.PRK-DELISTED | Stock | 5.25 | 5.25 | 5.25 | 5.25 | 3600.0 |
| 2010-05-31 11:00:00 | C.K | Stock | 18.18 | 18.22 | 18.16 | 18.17 | 37600.0 |
| 2010-05-31 11:00:00 | C.K-DELISTED | Stock | 18.18 | 18.22 | 18.16 | 18.17 | 37600.0 |
| 2010-05-31 11:00:00 | C.L-DELISTED | Stock | 38.67 | 38.77 | 38.62 | 38.7 | 5900.0 |
| 2010-05-31 11:00:00 | C.PRP-DELISTED | Stock | 0.14 | 0.14 | 0.14 | 0.14 | 10500.0 |
| 2010-05-31 12:00:00 | C.K | Stock | 18.17 | 18.21 | 18.15 | 18.19 | 30500.0 |
| 2010-05-31 12:00:00 | C.K-DELISTED | Stock | 18.17 | 18.21 | 18.15 | 18.19 | 30500.0 |
| 2010-05-31 12:00:00 | C.L-DELISTED | Stock | 38.7 | 38.88 | 38.7 | 38.85 | 7400.0 |
| 2010-05-31 12:00:00 | C.PRP-DELISTED | Stock | 0.14 | 0.14 | 0.125 | 0.125 | 44500.0 |
| 2010-05-31 13:00:00 | C.K | Stock | 18.19 | 18.21 | 18.18 | 18.21 | 9300.0 |
| 2010-05-31 13:00:00 | C.K-DELISTED | Stock | 18.19 | 18.21 | 18.18 | 18.21 | 9300.0 |
| 2010-05-31 13:00:00 | C.L-DELISTED | Stock | 38.83 | 38.9 | 38.83 | 38.9 | 3000.0 |
| 2010-05-31 13:00:00 | C.PRK-DELISTED | Stock | 5.38 | 5.38 | 5.38 | 5.38 | 100.0 |
| 2010-05-31 13:00:00 | C.PRP-DELISTED | Stock | 0.13 | 0.13 | 0.13 | 0.13 | 10000.0 |
| 2010-05-31 14:00:00 | C.K | Stock | 18.21 | 18.24 | 18.2 | 18.22 | 32400.0 |
| 2010-05-31 14:00:00 | C.K-DELISTED | Stock | 18.21 | 18.24 | 18.2 | 18.22 | 32400.0 |
| 2010-05-31 14:00:00 | C.L-DELISTED | Stock | 38.9 | 38.91 | 38.81 | 38.89 | 3100.0 |
| 2010-05-31 14:00:00 | C.PRP-DELISTED | Stock | 0.125 | 0.125 | 0.12 | 0.12 | 32000.0 |
| 2010-05-31 15:00:00 | C.K | Stock | 18.22 | 18.34 | 18.17 | 18.29 | 151700.0 |
| 2010-05-31 15:00:00 | C.K-DELISTED | Stock | 18.22 | 18.34 | 18.17 | 18.29 | 151700.0 |
| 2010-05-31 15:00:00 | C.L-DELISTED | Stock | 38.87 | 38.89 | 38.51 | 38.85 | 20800.0 |
| 2010-05-31 15:00:00 | C.PRP-DELISTED | Stock | 0.12 | 0.12 | 0.12 | 0.12 | 8500.0 |
| 2010-05-31 16:00:00 | C.K | Stock | 18.32 | 18.32 | 18.32 | 18.32 | 90700.0 |
| 2010-05-31 16:00:00 | C.K-DELISTED | Stock | 18.32 | 18.32 | 18.32 | 18.32 | 90700.0 |
| 2010-05-31 16:00:00 | C.L-DELISTED | Stock | 38.92 | 38.92 | 38.92 | 38.92 | 16600.0 |
> showing 32 of 32 rows — these rows as CSV