PREVIEW / stock_5min / 2007-11-22
file: by_date/stock_5min/2007/2007-11-22.parquet size: 8 KB rows: 242 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-11-22 09:30:00 | C.K | Stock | 17.42 | 17.59 | 17.41 | 17.58 | 31532.0 |
| 2007-11-22 09:30:00 | C.K-DELISTED | Stock | 17.42 | 17.59 | 17.41 | 17.58 | 31532.0 |
| 2007-11-22 09:30:00 | C.L-DELISTED | Stock | 33.41 | 33.63 | 33.39 | 33.63 | 12295.0 |
| 2007-11-22 09:35:00 | C.K | Stock | 17.57 | 17.72 | 17.57 | 17.7 | 66650.0 |
| 2007-11-22 09:35:00 | C.K-DELISTED | Stock | 17.57 | 17.72 | 17.57 | 17.7 | 66650.0 |
| 2007-11-22 09:35:00 | C.L-DELISTED | Stock | 33.63 | 33.63 | 33.45 | 33.47 | 10198.0 |
| 2007-11-22 09:40:00 | C.K | Stock | 17.72 | 17.8 | 17.72 | 17.74 | 102560.0 |
| 2007-11-22 09:40:00 | C.K-DELISTED | Stock | 17.72 | 17.8 | 17.72 | 17.74 | 102560.0 |
| 2007-11-22 09:40:00 | C.L-DELISTED | Stock | 33.4 | 33.4 | 33.3 | 33.3 | 4099.0 |
| 2007-11-22 09:45:00 | C.K | Stock | 17.74 | 17.74 | 17.7 | 17.7 | 58080.0 |
| 2007-11-22 09:45:00 | C.K-DELISTED | Stock | 17.74 | 17.74 | 17.7 | 17.7 | 58080.0 |
| 2007-11-22 09:45:00 | C.L-DELISTED | Stock | 33.3 | 33.3 | 33.3 | 33.3 | 451.0 |
| 2007-11-22 09:45:00 | C.PRK-DELISTED | Stock | 6.05 | 6.05 | 6.05 | 6.05 | 930.0 |
| 2007-11-22 09:50:00 | C.K | Stock | 17.7 | 17.7 | 17.56 | 17.65 | 11455.0 |
| 2007-11-22 09:50:00 | C.K-DELISTED | Stock | 17.7 | 17.7 | 17.56 | 17.65 | 11455.0 |
| 2007-11-22 09:50:00 | C.L-DELISTED | Stock | 33.28 | 33.35 | 33.27 | 33.34 | 8660.0 |
| 2007-11-22 09:55:00 | C.K | Stock | 17.65 | 17.68 | 17.65 | 17.68 | 5333.0 |
| 2007-11-22 09:55:00 | C.K-DELISTED | Stock | 17.65 | 17.68 | 17.65 | 17.68 | 5333.0 |
| 2007-11-22 09:55:00 | C.L-DELISTED | Stock | 33.34 | 33.34 | 33.33 | 33.33 | 2105.0 |
| 2007-11-22 10:00:00 | C.K | Stock | 17.67 | 17.7 | 17.66 | 17.66 | 17300.0 |
| 2007-11-22 10:00:00 | C.K-DELISTED | Stock | 17.67 | 17.7 | 17.66 | 17.66 | 17300.0 |
| 2007-11-22 10:00:00 | C.L-DELISTED | Stock | 33.27 | 33.27 | 33.27 | 33.27 | 407.0 |
| 2007-11-22 10:05:00 | C.K | Stock | 17.67 | 17.67 | 17.62 | 17.64 | 6667.0 |
| 2007-11-22 10:05:00 | C.K-DELISTED | Stock | 17.67 | 17.67 | 17.62 | 17.64 | 6667.0 |
| 2007-11-22 10:05:00 | C.L-DELISTED | Stock | 33.27 | 33.31 | 33.27 | 33.31 | 1235.0 |
| 2007-11-22 10:10:00 | C.K | Stock | 17.64 | 17.65 | 17.6 | 17.62 | 7799.0 |
| 2007-11-22 10:10:00 | C.K-DELISTED | Stock | 17.64 | 17.65 | 17.6 | 17.62 | 7799.0 |
| 2007-11-22 10:10:00 | C.L-DELISTED | Stock | 33.26 | 33.26 | 33.25 | 33.25 | 5200.0 |
| 2007-11-22 10:15:00 | C.K | Stock | 17.62 | 17.62 | 17.6 | 17.62 | 14047.0 |
| 2007-11-22 10:15:00 | C.K-DELISTED | Stock | 17.62 | 17.62 | 17.6 | 17.62 | 14047.0 |
| 2007-11-22 10:15:00 | C.L-DELISTED | Stock | 33.28 | 33.28 | 33.25 | 33.25 | 1200.0 |
| 2007-11-22 10:20:00 | C.K | Stock | 17.62 | 17.69 | 17.61 | 17.66 | 23523.0 |
| 2007-11-22 10:20:00 | C.K-DELISTED | Stock | 17.62 | 17.69 | 17.61 | 17.66 | 23523.0 |
| 2007-11-22 10:20:00 | C.L-DELISTED | Stock | 33.25 | 33.29 | 33.25 | 33.26 | 17920.0 |
| 2007-11-22 10:25:00 | C.K | Stock | 17.66 | 17.67 | 17.65 | 17.67 | 3092.0 |
| 2007-11-22 10:25:00 | C.K-DELISTED | Stock | 17.66 | 17.67 | 17.65 | 17.67 | 3092.0 |
| 2007-11-22 10:25:00 | C.L-DELISTED | Stock | 33.26 | 33.26 | 33.25 | 33.26 | 1528.0 |
| 2007-11-22 10:30:00 | C.K | Stock | 17.66 | 17.66 | 17.65 | 17.65 | 2000.0 |
| 2007-11-22 10:30:00 | C.K-DELISTED | Stock | 17.66 | 17.66 | 17.65 | 17.65 | 2000.0 |
| 2007-11-22 10:30:00 | C.L-DELISTED | Stock | 33.25 | 33.25 | 33.25 | 33.25 | 1051.0 |
| 2007-11-22 10:35:00 | C.K | Stock | 17.65 | 17.65 | 17.65 | 17.65 | 2133.0 |
| 2007-11-22 10:35:00 | C.K-DELISTED | Stock | 17.65 | 17.65 | 17.65 | 17.65 | 2133.0 |
| 2007-11-22 10:35:00 | C.L-DELISTED | Stock | 33.25 | 33.27 | 33.25 | 33.25 | 7550.0 |
| 2007-11-22 10:40:00 | C.K | Stock | 17.65 | 17.66 | 17.63 | 17.65 | 5928.0 |
| 2007-11-22 10:40:00 | C.K-DELISTED | Stock | 17.65 | 17.66 | 17.63 | 17.65 | 5928.0 |
| 2007-11-22 10:40:00 | C.L-DELISTED | Stock | 33.25 | 33.26 | 33.25 | 33.26 | 246.0 |
| 2007-11-22 10:45:00 | C.K | Stock | 17.64 | 17.64 | 17.62 | 17.62 | 3892.0 |
| 2007-11-22 10:45:00 | C.K-DELISTED | Stock | 17.64 | 17.64 | 17.62 | 17.62 | 3892.0 |
| 2007-11-22 10:45:00 | C.L-DELISTED | Stock | 33.31 | 33.32 | 33.3 | 33.3 | 8917.0 |
| 2007-11-22 10:50:00 | C.K | Stock | 17.63 | 17.63 | 17.62 | 17.62 | 1100.0 |
> showing 50 of 242 rows — these rows as CSV