PREVIEW / stock_daily / 2017-06-09

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-09.parquet
  size:    216 KB
  rows:    6,472
  symbols: 3,013

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
2017-06-09	AAPL	Stock	38.7975	38.7975	36.505	37.245	259530800.0
2017-06-09	MSFT	Stock	72.04	72.08	68.59	70.32	49187400.0
2017-06-09	NVDA	Stock	4.1185	4.2125	3.5688	3.74	3692928000.0
2017-06-09	AMZN	Stock	50.625	50.6495	46.35	48.9155	152954000.0
2017-06-09	GOOGL	Stock	50.2745	50.275	47.6685	48.506	72957140.0
2017-06-09	META	Stock	154.77	155.59	146.61	149.6	35577700.0
2017-06-09	TSLA	Stock	24.9613	25.1247	23.6533	23.8213	258921000.0
2017-06-09	TLT	Stock	124.08	124.64	123.98	124.4	5130548.0
2017-06-09	ES	Stock	61.93	62.37	61.63	62.3	1226700.0
2017-06-09	CL	Stock	75.85	76.09	75.36	75.77	2985600.0
2017-06-09	A	Stock	60.31	60.45	59.13	59.21	2352300.0
2017-06-09	AA	Stock	33.64	34.0	32.85	33.01	3073600.0
2017-06-09	AAAP-DELISTED	Stock	36.59	36.8521	36.0	36.55	26179.0
2017-06-09	AABA-DELISTED	Stock	56.155	57.39	53.66	54.01	59201788.0
2017-06-09	AAC-DELISTED	Stock	6.32	6.7	6.26	6.47	79012.0
2017-06-09	AACG	Stock	4.0	4.9	3.95	4.89	295300.0
2017-06-09	AAIC-DELISTED	Stock	14.32	14.6	14.32	14.55	559316.0
2017-06-09	AAL	Stock	51.61	51.95	50.25	50.27	7204300.0
2017-06-09	AAM.A-DELISTED	Stock	25.5	25.5	25.4	25.45	64667.0
2017-06-09	AAMC-DELISTED	Stock	25.1765	26.1765	25.1765	26.0882	8796.0
2017-06-09	AAME	Stock	3.8	3.8	3.6	3.65	6800.0
2017-06-09	AAMI	Stock	14.6	14.61	14.41	14.58	1167600.0
2017-06-09	AAOI	Stock	73.89	74.0	62.04	64.71	5292300.0
2017-06-09	AAON	Stock	24.6	25.1	24.5	25.0333	274950.0
2017-06-09	AAP	Stock	125.94	128.63	123.49	128.36	1679200.0
2017-06-09	AAT	Stock	40.05	40.75	39.8	40.52	208100.0
2017-06-09	AAU-DELISTED	Stock	1.38	1.4	1.335	1.335	169239.0
2017-06-09	AAUAF-DELISTED	Stock	1.38	1.4	1.335	1.34	174430.0
2017-06-09	AAV-DELISTED	Stock	5.95	6.15	5.95	6.05	146921.0
2017-06-09	AAWW-DELISTED	Stock	52.7	53.5	52.25	53.475	141359.0
2017-06-09	AAXJ	Stock	68.43	68.48	67.49	67.85	4041354.0
2017-06-09	AAXN-DELISTED	Stock	24.34	24.67	24.1754	24.37	419714.0
2017-06-09	AB	Stock	23.0	23.55	23.0	23.25	496100.0
2017-06-09	ABAC-DELISTED	Stock	2.0531	2.0976	1.92	2.01	4175.0
2017-06-09	ABAX-DELISTED	Stock	50.39	51.97	50.19	51.85	103131.0
2017-06-09	ABB-DELISTED	Stock	25.35	25.4063	25.205	25.34	1214203.0
2017-06-09	ABBNY-DELISTED	Stock	25.35	25.4063	25.205	25.35	1262289.0
2017-06-09	ABBV	Stock	68.8	69.83	68.72	69.67	6159800.0
2017-06-09	ABC-DELISTED	Stock	91.28	92.31	91.025	92.1	975250.0
2017-06-09	ABCB	Stock	46.6	49.3	46.35	49.25	293600.0
2017-06-09	ABCD-DELISTED	Stock	4.955	5.06	4.95	5.02	19181.0
2017-06-09	ABCO-DELISTED	Stock	51.05	51.625	50.95	51.225	414445.0
2017-06-09	ABDC-DELISTED	Stock	13.15	13.34	13.13	13.15	30658.0
2017-06-09	ABE-DELISTED	Stock	13.87	13.9189	13.832	13.85	1696.0
2017-06-09	ABEO	Stock	126.5	132.5	125.0	126.25	4560.0
2017-06-09	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	100.0
2017-06-09	ABEV	Stock	5.59	5.6	5.44	5.47	30828300.0
2017-06-09	ABG	Stock	54.25	55.65	53.65	55.35	153300.0
2017-06-09	ABIL-DELISTED	Stock	1.3	1.3	0.901	1.06	1711308.0
2017-06-09	ABM	Stock	43.95	43.99	42.55	43.05	515700.0

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

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