PREVIEW / stock_1hour / 2014-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-20.parquet
  size:    6 KB
  rows:    40
  symbols: 4

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
2014-01-20 09:00:00	C.K	Stock	5.29	5.32	5.27	5.31	167900.0
2014-01-20 09:00:00	C.K-DELISTED	Stock	5.29	5.32	5.27	5.31	167900.0
2014-01-20 09:00:00	C.L-DELISTED	Stock	44.77	44.77	44.43	44.47	13600.0
2014-01-20 09:00:00	C.PRJ-DELISTED	Stock	0.28	0.33	0.28	0.3	461000.0
2014-01-20 09:00:00	GEL	Stock	0.42	0.42	0.41	0.42	82000.0
2014-01-20 10:00:00	C.K	Stock	5.31	5.32	5.28	5.285	223400.0
2014-01-20 10:00:00	C.K-DELISTED	Stock	5.31	5.32	5.28	5.285	223400.0
2014-01-20 10:00:00	C.L-DELISTED	Stock	44.49	44.5	44.28	44.32	51300.0
2014-01-20 10:00:00	C.PRJ-DELISTED	Stock	0.3	0.31	0.29	0.31	121000.0
2014-01-20 10:00:00	GEL	Stock	0.4	0.4	0.4	0.4	84500.0
2014-01-20 11:00:00	C.K	Stock	5.285	5.3	5.28	5.3	144500.0
2014-01-20 11:00:00	C.K-DELISTED	Stock	5.285	5.3	5.28	5.3	144500.0
2014-01-20 11:00:00	C.L-DELISTED	Stock	44.3	44.36	44.25	44.26	14800.0
2014-01-20 11:00:00	C.PRJ-DELISTED	Stock	0.31	0.31	0.305	0.305	68000.0
2014-01-20 11:00:00	GEL	Stock	0.39	0.405	0.38	0.405	180000.0
2014-01-20 12:00:00	C.C-DELISTED	Stock	0.005	0.005	0.005	0.005	155000.0
2014-01-20 12:00:00	C.K	Stock	5.3	5.3	5.29	5.3	69500.0
2014-01-20 12:00:00	C.K-DELISTED	Stock	5.3	5.3	5.29	5.3	69500.0
2014-01-20 12:00:00	C.L-DELISTED	Stock	44.26	44.33	44.26	44.3	9800.0
2014-01-20 12:00:00	C.PRJ-DELISTED	Stock	0.305	0.31	0.3	0.31	85000.0
2014-01-20 12:00:00	GEL	Stock	0.405	0.415	0.405	0.415	19000.0
2014-01-20 13:00:00	C.C-DELISTED	Stock	0.005	0.005	0.005	0.005	230000.0
2014-01-20 13:00:00	C.K	Stock	5.3	5.3	5.28	5.3	89700.0
2014-01-20 13:00:00	C.K-DELISTED	Stock	5.3	5.3	5.28	5.3	89700.0
2014-01-20 13:00:00	C.L-DELISTED	Stock	44.3	44.33	44.25	44.29	12600.0
2014-01-20 13:00:00	C.PRJ-DELISTED	Stock	0.32	0.32	0.32	0.32	10000.0
2014-01-20 13:00:00	GEL	Stock	0.41	0.41	0.41	0.41	10000.0
2014-01-20 14:00:00	C.K	Stock	5.29	5.3	5.28	5.3	51300.0
2014-01-20 14:00:00	C.K-DELISTED	Stock	5.29	5.3	5.28	5.3	51300.0
2014-01-20 14:00:00	C.L-DELISTED	Stock	44.3	44.35	44.28	44.3	8000.0
2014-01-20 14:00:00	C.PRJ-DELISTED	Stock	0.32	0.34	0.32	0.34	497000.0
2014-01-20 14:00:00	GEL	Stock	0.41	0.415	0.395	0.395	52500.0
2014-01-20 15:00:00	C.K	Stock	5.3	5.3	5.26	5.26	257400.0
2014-01-20 15:00:00	C.K-DELISTED	Stock	5.3	5.3	5.26	5.26	257400.0
2014-01-20 15:00:00	C.L-DELISTED	Stock	44.31	44.36	44.25	44.3	93600.0
2014-01-20 15:00:00	C.PRJ-DELISTED	Stock	0.34	0.34	0.33	0.335	133000.0
2014-01-20 15:00:00	GEL	Stock	0.395	0.41	0.395	0.4	76000.0
2014-01-20 16:00:00	C.K	Stock	5.3	5.3	5.3	5.3	75100.0
2014-01-20 16:00:00	C.K-DELISTED	Stock	5.3	5.3	5.3	5.3	75100.0
2014-01-20 16:00:00	C.L-DELISTED	Stock	44.48	44.48	44.48	44.48	8300.0

> showing 40 of 40 rows — these rows as CSV

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