PREVIEW / stock_1min / 2009-01-19
file: by_date/stock_1min/2009/2009-01-19.parquet size: 14 KB rows: 868 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 |
|---|---|---|---|---|---|---|---|
| 2009-01-19 09:30:00 | C.K | Stock | 22.23 | 22.23 | 22.06 | 22.1 | 36600.0 |
| 2009-01-19 09:30:00 | C.K-DELISTED | Stock | 22.23 | 22.23 | 22.06 | 22.1 | 36600.0 |
| 2009-01-19 09:30:00 | C.L-DELISTED | Stock | 36.45 | 36.45 | 36.45 | 36.45 | 1700.0 |
| 2009-01-19 09:31:00 | C.K | Stock | 22.11 | 22.12 | 22.05 | 22.05 | 13900.0 |
| 2009-01-19 09:31:00 | C.K-DELISTED | Stock | 22.11 | 22.12 | 22.05 | 22.05 | 13900.0 |
| 2009-01-19 09:31:00 | C.L-DELISTED | Stock | 36.7 | 36.7 | 36.7 | 36.7 | 1300.0 |
| 2009-01-19 09:32:00 | C.K | Stock | 22.05 | 22.07 | 22.04 | 22.05 | 7500.0 |
| 2009-01-19 09:32:00 | C.K-DELISTED | Stock | 22.05 | 22.07 | 22.04 | 22.05 | 7500.0 |
| 2009-01-19 09:33:00 | C.K | Stock | 22.05 | 22.15 | 22.05 | 22.15 | 5500.0 |
| 2009-01-19 09:33:00 | C.K-DELISTED | Stock | 22.05 | 22.15 | 22.05 | 22.15 | 5500.0 |
| 2009-01-19 09:33:00 | C.L-DELISTED | Stock | 36.86 | 36.86 | 36.86 | 36.86 | 100.0 |
| 2009-01-19 09:34:00 | C.K | Stock | 22.15 | 22.16 | 22.15 | 22.15 | 15300.0 |
| 2009-01-19 09:34:00 | C.K-DELISTED | Stock | 22.15 | 22.16 | 22.15 | 22.15 | 15300.0 |
| 2009-01-19 09:34:00 | C.L-DELISTED | Stock | 36.86 | 36.86 | 36.86 | 36.86 | 100.0 |
| 2009-01-19 09:35:00 | C.K | Stock | 22.14 | 22.18 | 22.13 | 22.18 | 12300.0 |
| 2009-01-19 09:35:00 | C.K-DELISTED | Stock | 22.14 | 22.18 | 22.13 | 22.18 | 12300.0 |
| 2009-01-19 09:36:00 | C.K | Stock | 22.15 | 22.18 | 22.15 | 22.18 | 1200.0 |
| 2009-01-19 09:36:00 | C.K-DELISTED | Stock | 22.15 | 22.18 | 22.15 | 22.18 | 1200.0 |
| 2009-01-19 09:36:00 | C.L-DELISTED | Stock | 36.8 | 36.8 | 36.8 | 36.8 | 500.0 |
| 2009-01-19 09:37:00 | C.K | Stock | 22.19 | 22.19 | 22.15 | 22.15 | 11200.0 |
| 2009-01-19 09:37:00 | C.K-DELISTED | Stock | 22.19 | 22.19 | 22.15 | 22.15 | 11200.0 |
| 2009-01-19 09:37:00 | C.L-DELISTED | Stock | 36.8 | 36.8 | 36.8 | 36.8 | 400.0 |
| 2009-01-19 09:38:00 | C.K | Stock | 22.17 | 22.19 | 22.17 | 22.19 | 4100.0 |
| 2009-01-19 09:38:00 | C.K-DELISTED | Stock | 22.17 | 22.19 | 22.17 | 22.19 | 4100.0 |
| 2009-01-19 09:39:00 | C.K | Stock | 22.19 | 22.26 | 22.19 | 22.2 | 18400.0 |
| 2009-01-19 09:39:00 | C.K-DELISTED | Stock | 22.19 | 22.26 | 22.19 | 22.2 | 18400.0 |
| 2009-01-19 09:40:00 | C.K | Stock | 22.22 | 22.23 | 22.17 | 22.2 | 8800.0 |
| 2009-01-19 09:40:00 | C.K-DELISTED | Stock | 22.22 | 22.23 | 22.17 | 22.2 | 8800.0 |
| 2009-01-19 09:41:00 | C.K | Stock | 22.2 | 22.2 | 22.15 | 22.18 | 6400.0 |
| 2009-01-19 09:41:00 | C.K-DELISTED | Stock | 22.2 | 22.2 | 22.15 | 22.18 | 6400.0 |
| 2009-01-19 09:42:00 | C.K | Stock | 22.18 | 22.18 | 22.15 | 22.15 | 3400.0 |
| 2009-01-19 09:42:00 | C.K-DELISTED | Stock | 22.18 | 22.18 | 22.15 | 22.15 | 3400.0 |
| 2009-01-19 09:43:00 | C.K | Stock | 22.17 | 22.18 | 22.15 | 22.17 | 11400.0 |
| 2009-01-19 09:43:00 | C.K-DELISTED | Stock | 22.17 | 22.18 | 22.15 | 22.17 | 11400.0 |
| 2009-01-19 09:44:00 | C.K | Stock | 22.17 | 22.18 | 22.06 | 22.11 | 17200.0 |
| 2009-01-19 09:44:00 | C.K-DELISTED | Stock | 22.17 | 22.18 | 22.06 | 22.11 | 17200.0 |
| 2009-01-19 09:44:00 | C.L-DELISTED | Stock | 36.79 | 36.79 | 36.79 | 36.79 | 200.0 |
| 2009-01-19 09:45:00 | C.K | Stock | 22.11 | 22.13 | 22.09 | 22.11 | 2100.0 |
| 2009-01-19 09:45:00 | C.K-DELISTED | Stock | 22.11 | 22.13 | 22.09 | 22.11 | 2100.0 |
| 2009-01-19 09:45:00 | C.L-DELISTED | Stock | 36.79 | 36.79 | 36.79 | 36.79 | 100.0 |
| 2009-01-19 09:46:00 | C.K | Stock | 22.13 | 22.13 | 22.1 | 22.1 | 22900.0 |
| 2009-01-19 09:46:00 | C.K-DELISTED | Stock | 22.13 | 22.13 | 22.1 | 22.1 | 22900.0 |
| 2009-01-19 09:46:00 | C.L-DELISTED | Stock | 36.79 | 36.79 | 36.79 | 36.79 | 200.0 |
| 2009-01-19 09:47:00 | C.K | Stock | 22.09 | 22.1 | 22.07 | 22.1 | 2100.0 |
| 2009-01-19 09:47:00 | C.K-DELISTED | Stock | 22.09 | 22.1 | 22.07 | 22.1 | 2100.0 |
| 2009-01-19 09:48:00 | C.K | Stock | 22.11 | 22.11 | 22.04 | 22.1 | 6300.0 |
| 2009-01-19 09:48:00 | C.K-DELISTED | Stock | 22.11 | 22.11 | 22.04 | 22.1 | 6300.0 |
| 2009-01-19 09:48:00 | C.L-DELISTED | Stock | 36.79 | 36.79 | 36.68 | 36.68 | 200.0 |
| 2009-01-19 09:49:00 | C.K | Stock | 22.1 | 22.1 | 22.1 | 22.1 | 3500.0 |
| 2009-01-19 09:49:00 | C.K-DELISTED | Stock | 22.1 | 22.1 | 22.1 | 22.1 | 3500.0 |
> showing 50 of 868 rows — these rows as CSV