PREVIEW / stock_daily / 2014-12-17

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-17.parquet
  size:    224 KB
  rows:    6,682
  symbols: 3,567

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
2014-12-17	AAPL	Stock	26.78	27.46	26.705	27.3525	213647200.0
2014-12-17	MSFT	Stock	45.05	45.95	44.9	45.74	34970900.0
2014-12-17	NVDA	Stock	0.4935	0.5043	0.4775	0.5035	345596000.0
2014-12-17	AMZN	Stock	14.8185	14.9835	14.6515	14.944	88670000.0
2014-12-17	GOOGL	Stock	24.993	25.4535	24.9555	25.3225	72766980.0
2014-12-17	META	Stock	75.01	76.41	74.9	76.11	29203900.0
2014-12-17	TSLA	Stock	12.8707	13.7767	12.8433	13.7213	110517000.0
2014-12-17	TLT	Stock	126.91	127.19	125.7	126.4499	11558786.0
2014-12-17	ES	Stock	51.25	52.0	51.15	51.84	2330300.0
2014-12-17	CL	Stock	67.59	69.02	67.53	68.66	3811700.0
2014-12-17	A	Stock	38.34	39.99	38.09	39.76	3502700.0
2014-12-17	AA.B-DELISTED	Stock	47.29	48.46	47.1987	48.46	75757.0
2014-12-17	AABA-DELISTED	Stock	49.02	50.25	48.9	50.13	16261545.0
2014-12-17	AAC-DELISTED	Stock	29.21	30.33	27.0197	29.68	141137.0
2014-12-17	AACG	Stock	3.11	3.48	3.11	3.48	10600.0
2014-12-17	AAIC-DELISTED	Stock	26.48	27.03	26.47	27.02	390482.0
2014-12-17	AAL	Stock	48.26	49.49	46.05	48.8	24779800.0
2014-12-17	AAMC-DELISTED	Stock	127.3529	142.3499	127.3529	138.75	54346.0
2014-12-17	AAME	Stock	3.83	3.83	3.83	3.83	1100.0
2014-12-17	AAMI	Stock	15.76	16.27	15.57	16.09	610900.0
2014-12-17	AAOI	Stock	9.77	10.2	9.67	10.11	192100.0
2014-12-17	AAON	Stock	13.98	14.42	13.7867	14.36	276600.0
2014-12-17	AAP	Stock	157.28	159.7	155.87	159.55	497800.0
2014-12-17	AAT	Stock	38.44	39.14	38.3	39.1	182900.0
2014-12-17	AAU-DELISTED	Stock	0.9075	0.9911	0.9	0.97	126767.0
2014-12-17	AAUAF-DELISTED	Stock	0.8607	0.97	0.86	0.97	135437.0
2014-12-17	AAV-DELISTED	Stock	4.84	5.24	4.78	5.15	486414.0
2014-12-17	AAVL-DELISTED	Stock	50.69	52.35	50.01	50.32	170213.0
2014-12-17	AAWW-DELISTED	Stock	45.06	45.2	44.25	44.95	306182.0
2014-12-17	AAXJ	Stock	58.59	59.83	58.35	59.34	3265419.0
2014-12-17	AAXN-DELISTED	Stock	24.15	24.86	23.76	24.6	5661556.0
2014-12-17	AB	Stock	23.83	24.69	23.75	24.58	305800.0
2014-12-17	ABAC-DELISTED	Stock	1.9899	1.9899	1.8	1.8	7600.0
2014-12-17	ABAX-DELISTED	Stock	56.79	58.97	56.33	58.76	119988.0
2014-12-17	ABB-DELISTED	Stock	20.79	21.04	20.69	20.86	2863168.0
2014-12-17	ABBNY-DELISTED	Stock	20.79	21.04	20.69	20.85	3043752.0
2014-12-17	ABBV	Stock	65.5	66.74	65.09	66.57	5934900.0
2014-12-17	ABC-DELISTED	Stock	89.82	91.02	89.485	90.57	1697584.0
2014-12-17	ABCB	Stock	25.86	26.34	25.59	26.25	109000.0
2014-12-17	ABCD-DELISTED	Stock	1.6	1.61	1.6	1.61	700.0
2014-12-17	ABCO-DELISTED	Stock	48.12	51.91	48.05	51.34	451283.0
2014-12-17	ABCW-DELISTED	Stock	32.0	36.4	30.91	32.26	46634.0
2014-12-17	ABDC-DELISTED	Stock	11.4	11.6	11.4	11.5	92620.0
2014-12-17	ABE-DELISTED	Stock	12.62	13.1221	12.6	12.841	16392.0
2014-12-17	ABEO	Stock	137.0	150.0	137.0	150.0	36.0
2014-12-17	ABEV	Stock	5.7	5.99	5.68	5.84	19630200.0
2014-12-17	ABG	Stock	73.1	75.03	73.1	74.85	683000.0
2014-12-17	ABGB-DELISTED	Stock	12.03	12.44	12.0	12.3499	46541.0
2014-12-17	ABM	Stock	27.89	28.2	27.47	28.03	383800.0
2014-12-17	ABMD-DELISTED	Stock	36.0	37.05	35.705	36.92	362984.0

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

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