PREVIEW / stock_1hour / 2011-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-17.parquet
  size:    6 KB
  rows:    38
  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
2011-01-17 09:00:00	C.C-DELISTED	Stock	0.125	0.125	0.125	0.125	1500.0
2011-01-17 09:00:00	C.K	Stock	16.6	16.72	16.59	16.7	325000.0
2011-01-17 09:00:00	C.K-DELISTED	Stock	16.6	16.72	16.59	16.7	325000.0
2011-01-17 09:00:00	C.L-DELISTED	Stock	39.71	39.86	39.7	39.85	11000.0
2011-01-17 09:00:00	C.PRP-DELISTED	Stock	0.1	0.105	0.1	0.105	40000.0
2011-01-17 10:00:00	C.C-DELISTED	Stock	0.13	0.13	0.12	0.12	117000.0
2011-01-17 10:00:00	C.K	Stock	16.69	16.72	16.62	16.63	173500.0
2011-01-17 10:00:00	C.K-DELISTED	Stock	16.69	16.72	16.62	16.63	173500.0
2011-01-17 10:00:00	C.L-DELISTED	Stock	39.83	40.1	39.83	39.99	34600.0
2011-01-17 10:00:00	C.PRP-DELISTED	Stock	0.1	0.1	0.1	0.1	16000.0
2011-01-17 11:00:00	C.C-DELISTED	Stock	0.12	0.12	0.115	0.115	75000.0
2011-01-17 11:00:00	C.K	Stock	16.63	16.71	16.6	16.67	193700.0
2011-01-17 11:00:00	C.K-DELISTED	Stock	16.63	16.71	16.6	16.67	193700.0
2011-01-17 11:00:00	C.L-DELISTED	Stock	39.99	40.05	39.87	39.87	11000.0
2011-01-17 11:00:00	C.PRP-DELISTED	Stock	0.1	0.105	0.1	0.105	31500.0
2011-01-17 12:00:00	C.C-DELISTED	Stock	0.12	0.12	0.115	0.115	7500.0
2011-01-17 12:00:00	C.K	Stock	16.67	16.68	16.61	16.66	148900.0
2011-01-17 12:00:00	C.K-DELISTED	Stock	16.67	16.68	16.61	16.66	148900.0
2011-01-17 12:00:00	C.L-DELISTED	Stock	39.86	39.9	39.81	39.83	6700.0
2011-01-17 12:00:00	C.PRC-DELISTED	Stock	0.22	0.22	0.215	0.215	20000.0
2011-01-17 13:00:00	C.C-DELISTED	Stock	0.12	0.12	0.115	0.115	21000.0
2011-01-17 13:00:00	C.K	Stock	16.66	16.68	16.65	16.67	38100.0
2011-01-17 13:00:00	C.K-DELISTED	Stock	16.66	16.68	16.65	16.67	38100.0
2011-01-17 13:00:00	C.L-DELISTED	Stock	39.83	39.87	39.75	39.81	9300.0
2011-01-17 13:00:00	C.PRP-DELISTED	Stock	0.105	0.105	0.1	0.1	26000.0
2011-01-17 14:00:00	C.C-DELISTED	Stock	0.115	0.115	0.11	0.115	89500.0
2011-01-17 14:00:00	C.K	Stock	16.68	16.74	16.68	16.73	62800.0
2011-01-17 14:00:00	C.K-DELISTED	Stock	16.68	16.74	16.68	16.73	62800.0
2011-01-17 14:00:00	C.L-DELISTED	Stock	39.8	39.8	39.7	39.75	19700.0
2011-01-17 15:00:00	C.C-DELISTED	Stock	0.115	0.12	0.11	0.11	33500.0
2011-01-17 15:00:00	C.K	Stock	16.73	16.75	16.64	16.65	123400.0
2011-01-17 15:00:00	C.K-DELISTED	Stock	16.73	16.75	16.64	16.65	123400.0
2011-01-17 15:00:00	C.L-DELISTED	Stock	39.75	39.75	39.45	39.5	22600.0
2011-01-17 15:00:00	C.PRC-DELISTED	Stock	0.245	0.245	0.245	0.245	1500.0
2011-01-17 15:00:00	C.PRP-DELISTED	Stock	0.105	0.105	0.105	0.105	4000.0
2011-01-17 16:00:00	C.K	Stock	16.63	16.63	16.63	16.63	24600.0
2011-01-17 16:00:00	C.K-DELISTED	Stock	16.63	16.63	16.63	16.63	24600.0
2011-01-17 16:00:00	C.L-DELISTED	Stock	39.46	39.46	39.46	39.46	3300.0

> showing 38 of 38 rows — these rows as CSV

> unlock the full archive -- $79 one-time