PREVIEW / stock_daily / 2015-02-09

all stock daily files

  file:    by_date/stock_daily/2015/2015-02-09.parquet
  size:    223 KB
  rows:    6,642
  symbols: 3,518

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2015-02-09	AAPL	Stock	29.6375	29.96	29.6075	29.93	155559200.0
2015-02-09	MSFT	Stock	42.24	42.74	42.21	42.36	31381100.0
2015-02-09	NVDA	Stock	0.507	0.511	0.5038	0.5095	273944000.0
2015-02-09	AMZN	Stock	18.55	18.7205	18.36	18.528	54492000.0
2015-02-09	GOOGL	Stock	26.553	26.694	26.3775	26.464	30313740.0
2015-02-09	META	Stock	74.05	74.83	73.45	74.44	16194300.0
2015-02-09	TSLA	Stock	14.3587	14.5287	14.1327	14.4987	52086000.0
2015-02-09	TLT	Stock	131.97	131.98	130.75	130.75	8025546.0
2015-02-09	ES	Stock	53.72	54.0	52.91	53.15	1465000.0
2015-02-09	CL	Stock	69.13	69.41	68.9	69.07	2113000.0
2015-02-09	A	Stock	39.23	39.43	38.95	39.04	3586100.0
2015-02-09	AA.B-DELISTED	Stock	51.86	51.86	50.15	50.27	84663.0
2015-02-09	AABA-DELISTED	Stock	42.61	43.15	42.54	42.57	14230659.0
2015-02-09	AAC-DELISTED	Stock	28.75	28.8239	27.69	27.96	46290.0
2015-02-09	AACG	Stock	4.63	4.9	4.23	4.48	25100.0
2015-02-09	AAIC-DELISTED	Stock	24.54	24.7295	24.51	24.57	386924.0
2015-02-09	AAL	Stock	46.41	47.24	45.95	46.53	12961900.0
2015-02-09	AAMC-DELISTED	Stock	57.9412	58.8235	52.6471	53.9735	92531.0
2015-02-09	AAME	Stock	3.97	3.98	3.88	3.98	3900.0
2015-02-09	AAMI	Stock	15.91	16.04	15.75	15.85	58300.0
2015-02-09	AAOI	Stock	9.53	9.89	9.43	9.85	90600.0
2015-02-09	AAON	Stock	15.3933	15.5533	15.0333	15.1067	197700.0
2015-02-09	AAP	Stock	161.62	161.76	159.07	160.74	1064200.0
2015-02-09	AAT	Stock	42.59	43.04	42.28	42.31	122300.0
2015-02-09	AAU-DELISTED	Stock	1.13	1.15	1.11	1.13	143464.0
2015-02-09	AAUAF-DELISTED	Stock	1.13	1.15	1.11	1.13	146165.0
2015-02-09	AAV-DELISTED	Stock	4.48	4.63	4.44	4.61	108273.0
2015-02-09	AAVL-DELISTED	Stock	33.06	37.54	32.511	36.32	667651.0
2015-02-09	AAWW-DELISTED	Stock	48.21	48.7	47.47	48.46	193498.0
2015-02-09	AAXJ	Stock	62.65	62.66	62.41	62.52	376999.0
2015-02-09	AAXN-DELISTED	Stock	26.31	26.77	26.1201	26.28	669724.0
2015-02-09	AB	Stock	25.39	25.48	24.8	24.83	351500.0
2015-02-09	ABAC-DELISTED	Stock	1.73	1.73	1.68	1.68	1800.0
2015-02-09	ABAX-DELISTED	Stock	60.5	61.512	59.61	59.74	190535.0
2015-02-09	ABB-DELISTED	Stock	20.55	20.81	20.55	20.77	4870948.0
2015-02-09	ABBNY-DELISTED	Stock	20.55	20.81	20.55	20.76	5050603.0
2015-02-09	ABBV	Stock	55.67	56.35	55.18	55.48	22522000.0
2015-02-09	ABC-DELISTED	Stock	96.97	96.97	95.075	95.54	1476141.0
2015-02-09	ABCB	Stock	25.33	25.59	24.99	25.16	42000.0
2015-02-09	ABCD-DELISTED	Stock	2.62	2.65	2.51	2.54	15910.0
2015-02-09	ABCO-DELISTED	Stock	50.74	51.26	49.88	50.57	277386.0
2015-02-09	ABCW-DELISTED	Stock	33.5	33.73	32.65	32.7	12383.0
2015-02-09	ABDC-DELISTED	Stock	13.73	13.87	13.46	13.73	44515.0
2015-02-09	ABE-DELISTED	Stock	13.01	13.07	13.001	13.07	1746.0
2015-02-09	ABEO	Stock	77.5	77.5	74.0	75.0	200.0
2015-02-09	ABEV	Stock	6.39	6.58	6.39	6.53	12648100.0
2015-02-09	ABG	Stock	79.5	79.86	78.39	78.69	294600.0
2015-02-09	ABGB-DELISTED	Stock	15.0	15.3	15.0	15.14	71334.0
2015-02-09	ABIL-DELISTED	Stock	9.98	9.98	9.95	9.98	5600.0
2015-02-09	ABM	Stock	30.05	30.32	29.74	29.81	106900.0

> showing 50 of 6,642 rows — these rows as CSV

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