PREVIEW / stock_5min / 2012-10-29
file: by_date/stock_5min/2012/2012-10-29.parquet size: 8 KB rows: 230 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 |
|---|---|---|---|---|---|---|---|
| 2012-10-29 09:30:00 | C.K | Stock | 9.65 | 9.69 | 9.63 | 9.65 | 21000.0 |
| 2012-10-29 09:30:00 | C.K-DELISTED | Stock | 9.65 | 9.69 | 9.63 | 9.65 | 21000.0 |
| 2012-10-29 09:30:00 | C.L-DELISTED | Stock | 33.8 | 34.18 | 33.8 | 34.14 | 1700.0 |
| 2012-10-29 09:30:00 | C.PRJ-DELISTED | Stock | 1.53 | 1.53 | 1.53 | 1.53 | 7000.0 |
| 2012-10-29 09:35:00 | C.K | Stock | 9.65 | 9.66 | 9.64 | 9.64 | 10200.0 |
| 2012-10-29 09:35:00 | C.K-DELISTED | Stock | 9.65 | 9.66 | 9.64 | 9.64 | 10200.0 |
| 2012-10-29 09:35:00 | C.L-DELISTED | Stock | 34.12 | 34.17 | 34.05 | 34.17 | 1400.0 |
| 2012-10-29 09:40:00 | C.K | Stock | 9.64 | 9.645 | 9.6 | 9.63 | 20100.0 |
| 2012-10-29 09:40:00 | C.K-DELISTED | Stock | 9.64 | 9.645 | 9.6 | 9.63 | 20100.0 |
| 2012-10-29 09:40:00 | C.L-DELISTED | Stock | 34.2 | 34.2 | 34.15 | 34.15 | 300.0 |
| 2012-10-29 09:45:00 | C.K | Stock | 9.63 | 9.63 | 9.63 | 9.63 | 3700.0 |
| 2012-10-29 09:45:00 | C.K-DELISTED | Stock | 9.63 | 9.63 | 9.63 | 9.63 | 3700.0 |
| 2012-10-29 09:45:00 | C.L-DELISTED | Stock | 34.18 | 34.2 | 34.18 | 34.2 | 400.0 |
| 2012-10-29 09:50:00 | C.K | Stock | 9.63 | 9.65 | 9.63 | 9.65 | 1600.0 |
| 2012-10-29 09:50:00 | C.K-DELISTED | Stock | 9.63 | 9.65 | 9.63 | 9.65 | 1600.0 |
| 2012-10-29 09:50:00 | C.L-DELISTED | Stock | 34.25 | 34.27 | 34.23 | 34.27 | 300.0 |
| 2012-10-29 09:50:00 | C.PRJ-DELISTED | Stock | 1.52 | 1.52 | 1.52 | 1.52 | 1000.0 |
| 2012-10-29 09:55:00 | C.K | Stock | 9.65 | 9.66 | 9.65 | 9.66 | 8100.0 |
| 2012-10-29 09:55:00 | C.K-DELISTED | Stock | 9.65 | 9.66 | 9.65 | 9.66 | 8100.0 |
| 2012-10-29 09:55:00 | C.L-DELISTED | Stock | 34.27 | 34.28 | 34.27 | 34.28 | 300.0 |
| 2012-10-29 10:00:00 | C.K | Stock | 9.66 | 9.66 | 9.64 | 9.65 | 12500.0 |
| 2012-10-29 10:00:00 | C.K-DELISTED | Stock | 9.66 | 9.66 | 9.64 | 9.65 | 12500.0 |
| 2012-10-29 10:00:00 | C.L-DELISTED | Stock | 34.23 | 34.3 | 34.23 | 34.3 | 1200.0 |
| 2012-10-29 10:00:00 | C.PRJ-DELISTED | Stock | 1.52 | 1.52 | 1.52 | 1.52 | 1200.0 |
| 2012-10-29 10:05:00 | C.K | Stock | 9.65 | 9.65 | 9.64 | 9.65 | 9400.0 |
| 2012-10-29 10:05:00 | C.K-DELISTED | Stock | 9.65 | 9.65 | 9.64 | 9.65 | 9400.0 |
| 2012-10-29 10:05:00 | C.L-DELISTED | Stock | 34.28 | 34.28 | 34.28 | 34.28 | 400.0 |
| 2012-10-29 10:05:00 | C.PRJ-DELISTED | Stock | 1.52 | 1.52 | 1.51 | 1.51 | 7200.0 |
| 2012-10-29 10:10:00 | C.K | Stock | 9.65 | 9.65 | 9.64 | 9.64 | 4300.0 |
| 2012-10-29 10:10:00 | C.K-DELISTED | Stock | 9.65 | 9.65 | 9.64 | 9.64 | 4300.0 |
| 2012-10-29 10:10:00 | C.L-DELISTED | Stock | 34.3 | 34.3 | 34.3 | 34.3 | 100.0 |
| 2012-10-29 10:15:00 | C.K | Stock | 9.64 | 9.65 | 9.64 | 9.65 | 13300.0 |
| 2012-10-29 10:15:00 | C.K-DELISTED | Stock | 9.64 | 9.65 | 9.64 | 9.65 | 13300.0 |
| 2012-10-29 10:15:00 | C.L-DELISTED | Stock | 34.3 | 34.38 | 34.3 | 34.38 | 700.0 |
| 2012-10-29 10:15:00 | C.PRJ-DELISTED | Stock | 1.51 | 1.51 | 1.51 | 1.51 | 1000.0 |
| 2012-10-29 10:20:00 | C.C-DELISTED | Stock | 0.045 | 0.045 | 0.045 | 0.045 | 15000.0 |
| 2012-10-29 10:20:00 | C.K | Stock | 9.65 | 9.65 | 9.64 | 9.64 | 4500.0 |
| 2012-10-29 10:20:00 | C.K-DELISTED | Stock | 9.65 | 9.65 | 9.64 | 9.64 | 4500.0 |
| 2012-10-29 10:25:00 | C.K | Stock | 9.64 | 9.64 | 9.64 | 9.64 | 400.0 |
| 2012-10-29 10:25:00 | C.K-DELISTED | Stock | 9.64 | 9.64 | 9.64 | 9.64 | 400.0 |
| 2012-10-29 10:30:00 | C.K | Stock | 9.63 | 9.63 | 9.63 | 9.63 | 2500.0 |
| 2012-10-29 10:30:00 | C.K-DELISTED | Stock | 9.63 | 9.63 | 9.63 | 9.63 | 2500.0 |
| 2012-10-29 10:30:00 | C.L-DELISTED | Stock | 34.34 | 34.34 | 34.34 | 34.34 | 200.0 |
| 2012-10-29 10:35:00 | C.K | Stock | 9.63 | 9.64 | 9.63 | 9.64 | 4600.0 |
| 2012-10-29 10:35:00 | C.K-DELISTED | Stock | 9.63 | 9.64 | 9.63 | 9.64 | 4600.0 |
| 2012-10-29 10:35:00 | C.L-DELISTED | Stock | 34.35 | 34.35 | 34.26 | 34.26 | 700.0 |
| 2012-10-29 10:40:00 | C.K | Stock | 9.63 | 9.64 | 9.63 | 9.64 | 4200.0 |
| 2012-10-29 10:40:00 | C.K-DELISTED | Stock | 9.63 | 9.64 | 9.63 | 9.64 | 4200.0 |
| 2012-10-29 10:40:00 | C.L-DELISTED | Stock | 34.27 | 34.28 | 34.27 | 34.28 | 400.0 |
| 2012-10-29 10:45:00 | C.K | Stock | 9.63 | 9.64 | 9.63 | 9.64 | 4600.0 |
> showing 50 of 230 rows — these rows as CSV