PREVIEW / stock_1hour / 2015-01-19
file: by_date/stock_1hour/2015/2015-01-19.parquet size: 6 KB rows: 30 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 |
|---|---|---|---|---|---|---|---|
| 2015-01-19 09:00:00 | C.K | Stock | 4.3 | 4.36 | 4.3 | 4.34 | 177000.0 |
| 2015-01-19 09:00:00 | C.K-DELISTED | Stock | 4.3 | 4.36 | 4.3 | 4.34 | 177100.0 |
| 2015-01-19 09:00:00 | C.L-DELISTED | Stock | 59.5 | 59.9 | 59.36 | 59.77 | 10100.0 |
| 2015-01-19 09:00:00 | C.PRJ-DELISTED | Stock | 0.75 | 0.75 | 0.75 | 0.75 | 500.0 |
| 2015-01-19 10:00:00 | C.K | Stock | 4.345 | 4.35 | 4.22 | 4.23 | 161800.0 |
| 2015-01-19 10:00:00 | C.K-DELISTED | Stock | 4.345 | 4.35 | 4.22 | 4.23 | 161800.0 |
| 2015-01-19 10:00:00 | C.L-DELISTED | Stock | 59.77 | 60.07 | 59.61 | 59.84 | 26600.0 |
| 2015-01-19 11:00:00 | C.K | Stock | 4.24 | 4.24 | 4.17 | 4.21 | 206800.0 |
| 2015-01-19 11:00:00 | C.K-DELISTED | Stock | 4.24 | 4.24 | 4.17 | 4.21 | 206800.0 |
| 2015-01-19 11:00:00 | C.L-DELISTED | Stock | 59.83 | 60.17 | 59.81 | 60.08 | 55900.0 |
| 2015-01-19 11:00:00 | GEL | Stock | 0.37 | 0.37 | 0.36 | 0.36 | 5000.0 |
| 2015-01-19 12:00:00 | C.K | Stock | 4.22 | 4.23 | 4.2 | 4.21 | 86200.0 |
| 2015-01-19 12:00:00 | C.K-DELISTED | Stock | 4.22 | 4.23 | 4.2 | 4.21 | 86200.0 |
| 2015-01-19 12:00:00 | C.L-DELISTED | Stock | 60.1 | 60.16 | 60.0 | 60.02 | 26900.0 |
| 2015-01-19 12:00:00 | GEL | Stock | 0.36 | 0.36 | 0.36 | 0.36 | 7500.0 |
| 2015-01-19 13:00:00 | C.K | Stock | 4.215 | 4.285 | 4.21 | 4.27 | 159400.0 |
| 2015-01-19 13:00:00 | C.K-DELISTED | Stock | 4.215 | 4.285 | 4.21 | 4.27 | 159400.0 |
| 2015-01-19 13:00:00 | C.L-DELISTED | Stock | 60.07 | 60.19 | 60.07 | 60.14 | 8800.0 |
| 2015-01-19 13:00:00 | GEL | Stock | 0.355 | 0.365 | 0.355 | 0.36 | 55000.0 |
| 2015-01-19 14:00:00 | C.K | Stock | 4.265 | 4.27 | 4.26 | 4.26 | 35600.0 |
| 2015-01-19 14:00:00 | C.K-DELISTED | Stock | 4.265 | 4.27 | 4.26 | 4.26 | 35600.0 |
| 2015-01-19 14:00:00 | C.L-DELISTED | Stock | 60.15 | 60.19 | 59.79 | 59.9 | 15500.0 |
| 2015-01-19 14:00:00 | GEL | Stock | 0.36 | 0.365 | 0.35 | 0.35 | 80000.0 |
| 2015-01-19 15:00:00 | C.K | Stock | 4.27 | 4.32 | 4.26 | 4.31 | 182500.0 |
| 2015-01-19 15:00:00 | C.K-DELISTED | Stock | 4.27 | 4.32 | 4.26 | 4.31 | 182500.0 |
| 2015-01-19 15:00:00 | C.L-DELISTED | Stock | 59.91 | 60.21 | 59.9 | 59.99 | 21100.0 |
| 2015-01-19 15:00:00 | GEL | Stock | 0.35 | 0.35 | 0.34 | 0.35 | 113000.0 |
| 2015-01-19 16:00:00 | C.K | Stock | 4.31 | 4.31 | 4.31 | 4.31 | 29000.0 |
| 2015-01-19 16:00:00 | C.K-DELISTED | Stock | 4.31 | 4.31 | 4.31 | 4.31 | 29000.0 |
| 2015-01-19 16:00:00 | C.L-DELISTED | Stock | 59.92 | 59.92 | 59.92 | 59.92 | 1300.0 |
> showing 30 of 30 rows — these rows as CSV