PREVIEW / stock_5min / 2013-07-04
file: by_date/stock_5min/2013/2013-07-04.parquet size: 8 KB rows: 218 symbols: 6
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-04 09:30:00 | C.K | Stock | 5.25 | 5.26 | 5.225 | 5.26 | 30500.0 |
| 2013-07-04 09:30:00 | C.K-DELISTED | Stock | 5.25 | 5.26 | 5.225 | 5.26 | 30500.0 |
| 2013-07-04 09:30:00 | C.L-DELISTED | Stock | 47.76 | 47.95 | 47.74 | 47.84 | 2700.0 |
| 2013-07-04 09:35:00 | C.K | Stock | 5.26 | 5.28 | 5.25 | 5.28 | 16300.0 |
| 2013-07-04 09:35:00 | C.K-DELISTED | Stock | 5.26 | 5.28 | 5.25 | 5.28 | 16300.0 |
| 2013-07-04 09:35:00 | C.L-DELISTED | Stock | 47.78 | 47.93 | 47.78 | 47.87 | 4400.0 |
| 2013-07-04 09:40:00 | C.K | Stock | 5.29 | 5.29 | 5.285 | 5.29 | 400.0 |
| 2013-07-04 09:40:00 | C.K-DELISTED | Stock | 5.29 | 5.29 | 5.285 | 5.29 | 400.0 |
| 2013-07-04 09:40:00 | C.L-DELISTED | Stock | 47.86 | 47.86 | 47.81 | 47.85 | 1900.0 |
| 2013-07-04 09:40:00 | C.PRJ-DELISTED | Stock | 0.56 | 0.56 | 0.56 | 0.56 | 500.0 |
| 2013-07-04 09:45:00 | C.K | Stock | 5.28 | 5.28 | 5.27 | 5.28 | 2100.0 |
| 2013-07-04 09:45:00 | C.K-DELISTED | Stock | 5.28 | 5.28 | 5.27 | 5.28 | 2100.0 |
| 2013-07-04 09:45:00 | C.L-DELISTED | Stock | 47.87 | 47.91 | 47.83 | 47.91 | 3700.0 |
| 2013-07-04 09:50:00 | C.K | Stock | 5.28 | 5.29 | 5.28 | 5.29 | 16300.0 |
| 2013-07-04 09:50:00 | C.K-DELISTED | Stock | 5.28 | 5.29 | 5.28 | 5.29 | 16300.0 |
| 2013-07-04 09:50:00 | C.L-DELISTED | Stock | 47.91 | 47.95 | 47.91 | 47.92 | 2900.0 |
| 2013-07-04 09:55:00 | C.K | Stock | 5.28 | 5.29 | 5.28 | 5.29 | 2000.0 |
| 2013-07-04 09:55:00 | C.K-DELISTED | Stock | 5.28 | 5.29 | 5.28 | 5.29 | 2000.0 |
| 2013-07-04 09:55:00 | C.L-DELISTED | Stock | 47.9 | 47.9 | 47.9 | 47.9 | 200.0 |
| 2013-07-04 10:00:00 | C.K | Stock | 5.29 | 5.29 | 5.29 | 5.29 | 16000.0 |
| 2013-07-04 10:00:00 | C.K-DELISTED | Stock | 5.29 | 5.29 | 5.29 | 5.29 | 16000.0 |
| 2013-07-04 10:00:00 | C.L-DELISTED | Stock | 47.9 | 47.9 | 47.77 | 47.77 | 2300.0 |
| 2013-07-04 10:05:00 | C.K | Stock | 5.285 | 5.285 | 5.28 | 5.28 | 6500.0 |
| 2013-07-04 10:05:00 | C.K-DELISTED | Stock | 5.285 | 5.285 | 5.28 | 5.28 | 6500.0 |
| 2013-07-04 10:05:00 | C.L-DELISTED | Stock | 47.74 | 47.81 | 47.67 | 47.67 | 2700.0 |
| 2013-07-04 10:15:00 | C.K | Stock | 5.27 | 5.27 | 5.26 | 5.26 | 6200.0 |
| 2013-07-04 10:15:00 | C.K-DELISTED | Stock | 5.27 | 5.27 | 5.26 | 5.26 | 6200.0 |
| 2013-07-04 10:15:00 | C.L-DELISTED | Stock | 47.67 | 47.67 | 47.52 | 47.57 | 4800.0 |
| 2013-07-04 10:20:00 | C.K | Stock | 5.265 | 5.265 | 5.26 | 5.26 | 9600.0 |
| 2013-07-04 10:20:00 | C.K-DELISTED | Stock | 5.265 | 5.265 | 5.26 | 5.26 | 9600.0 |
| 2013-07-04 10:20:00 | C.L-DELISTED | Stock | 47.52 | 47.52 | 47.3 | 47.3 | 2300.0 |
| 2013-07-04 10:20:00 | C.PRK-DELISTED | Stock | 0.4 | 0.4 | 0.4 | 0.4 | 5000.0 |
| 2013-07-04 10:25:00 | C.K | Stock | 5.26 | 5.26 | 5.26 | 5.26 | 600.0 |
| 2013-07-04 10:25:00 | C.K-DELISTED | Stock | 5.26 | 5.26 | 5.26 | 5.26 | 600.0 |
| 2013-07-04 10:25:00 | C.L-DELISTED | Stock | 47.4 | 47.48 | 47.4 | 47.48 | 1600.0 |
| 2013-07-04 10:25:00 | C.PRJ-DELISTED | Stock | 0.56 | 0.56 | 0.56 | 0.56 | 500.0 |
| 2013-07-04 10:30:00 | C.K | Stock | 5.26 | 5.26 | 5.26 | 5.26 | 800.0 |
| 2013-07-04 10:30:00 | C.K-DELISTED | Stock | 5.26 | 5.26 | 5.26 | 5.26 | 800.0 |
| 2013-07-04 10:30:00 | C.L-DELISTED | Stock | 47.45 | 47.51 | 47.45 | 47.48 | 1100.0 |
| 2013-07-04 10:35:00 | C.K | Stock | 5.27 | 5.27 | 5.26 | 5.26 | 2200.0 |
| 2013-07-04 10:35:00 | C.K-DELISTED | Stock | 5.27 | 5.27 | 5.26 | 5.26 | 2200.0 |
| 2013-07-04 10:35:00 | C.L-DELISTED | Stock | 47.5 | 47.52 | 47.47 | 47.48 | 1700.0 |
| 2013-07-04 10:40:00 | C.K | Stock | 5.26 | 5.26 | 5.26 | 5.26 | 900.0 |
| 2013-07-04 10:40:00 | C.K-DELISTED | Stock | 5.26 | 5.26 | 5.26 | 5.26 | 900.0 |
| 2013-07-04 10:40:00 | C.L-DELISTED | Stock | 47.52 | 47.56 | 47.5 | 47.51 | 1800.0 |
| 2013-07-04 10:45:00 | C.K | Stock | 5.26 | 5.26 | 5.26 | 5.26 | 1100.0 |
| 2013-07-04 10:45:00 | C.K-DELISTED | Stock | 5.26 | 5.26 | 5.26 | 5.26 | 1100.0 |
| 2013-07-04 10:45:00 | C.L-DELISTED | Stock | 47.46 | 47.5 | 47.42 | 47.49 | 2500.0 |
| 2013-07-04 10:50:00 | C.L-DELISTED | Stock | 47.49 | 47.49 | 47.46 | 47.46 | 1200.0 |
| 2013-07-04 10:55:00 | C.K | Stock | 5.26 | 5.26 | 5.26 | 5.26 | 300.0 |
> showing 50 of 218 rows — these rows as CSV