PREVIEW / stock_daily / 2017-09-22

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-22.parquet
  size:    214 KB
  rows:    6,436
  symbols: 2,931

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-09-22	AAPL	Stock	37.885	38.0675	37.64	37.9725	186581600.0
2017-09-22	MSFT	Stock	73.99	74.51	73.85	74.41	14111400.0
2017-09-22	NVDA	Stock	4.5075	4.5578	4.465	4.475	491232000.0
2017-09-22	AMZN	Stock	48.0505	48.2805	47.721	47.755	52836000.0
2017-09-22	GOOGL	Stock	47.1385	47.5	47.0418	47.163	21496120.0
2017-09-22	META	Stock	170.21	171.73	169.22	170.54	12097100.0
2017-09-22	TSLA	Stock	24.4327	24.66	23.392	23.406	122391000.0
2017-09-22	TLT	Stock	126.5	126.73	126.06	126.2	5660664.0
2017-09-22	ES	Stock	61.59	61.65	60.67	60.71	1678500.0
2017-09-22	CL	Stock	71.38	71.65	71.0	71.19	2533300.0
2017-09-22	A	Stock	65.85	66.27	65.71	65.78	1296200.0
2017-09-22	AA	Stock	45.31	45.78	44.67	45.38	3224600.0
2017-09-22	AAAP-DELISTED	Stock	56.4	56.94	53.0	55.24	236050.0
2017-09-22	AABA-DELISTED	Stock	66.45	67.39	66.23	67.28	8162703.0
2017-09-22	AAC-DELISTED	Stock	9.63	9.939	9.44	9.76	90806.0
2017-09-22	AACG	Stock	4.79	4.85	4.79	4.85	12200.0
2017-09-22	AAIC-DELISTED	Stock	13.37	13.4099	13.35	13.38	384521.0
2017-09-22	AAL	Stock	46.57	47.46	46.35	47.06	5342000.0
2017-09-22	AAM.A-DELISTED	Stock	26.26	26.26	26.08	26.14	25840.0
2017-09-22	AAMC-DELISTED	Stock	25.8088	26.1618	25.5	26.1618	7402.0
2017-09-22	AAME	Stock	3.3	3.3	3.25	3.3	1300.0
2017-09-22	AAMI	Stock	13.71	13.99	13.67	13.96	287600.0
2017-09-22	AAOI	Stock	62.87	64.68	62.72	63.8	1108400.0
2017-09-22	AAON	Stock	22.1	22.4	22.0667	22.2	207450.0
2017-09-22	AAP	Stock	93.9	95.91	93.68	95.59	1784100.0
2017-09-22	AAT	Stock	39.99	40.18	39.81	39.81	131300.0
2017-09-22	AAU-DELISTED	Stock	1.15	1.1642	1.12	1.14	188076.0
2017-09-22	AAUAF-DELISTED	Stock	1.15	1.1642	1.12	1.13	193384.0
2017-09-22	AAV-DELISTED	Stock	6.6	6.6	6.475	6.55	116638.0
2017-09-22	AAWW-DELISTED	Stock	67.4	68.0	67.3	67.6	96383.0
2017-09-22	AAXJ	Stock	72.98	73.0	72.83	72.92	634657.0
2017-09-22	AAXN-DELISTED	Stock	22.77	23.14	22.64	22.645	247273.0
2017-09-22	AB	Stock	23.8	24.63	23.8	24.5	187000.0
2017-09-22	ABAC-DELISTED	Stock	2.1101	2.35	2.1	2.3147	3197.0
2017-09-22	ABAX-DELISTED	Stock	44.39	45.21	44.135	44.85	153174.0
2017-09-22	ABB-DELISTED	Stock	24.64	24.745	24.64	24.74	617728.0
2017-09-22	ABBNY-DELISTED	Stock	24.64	24.745	24.64	24.73	647646.0
2017-09-22	ABBV	Stock	87.22	87.75	86.77	87.48	6807000.0
2017-09-22	ABC-DELISTED	Stock	80.53	81.2	80.33	81.05	685077.0
2017-09-22	ABCB	Stock	45.75	45.85	45.3	45.4	187700.0
2017-09-22	ABCD-DELISTED	Stock	6.22	6.33	6.1557	6.26	33103.0
2017-09-22	ABCO-DELISTED	Stock	53.35	53.5	53.325	53.5	556899.0
2017-09-22	ABDC-DELISTED	Stock	10.82	10.93	10.75	10.85	56020.0
2017-09-22	ABE-DELISTED	Stock	14.24	14.3	14.208	14.2715	8024.0
2017-09-22	ABEO	Stock	397.5	397.5	365.0	373.75	57864.0
2017-09-22	ABEOW-DELISTED	Stock	9.5801	11.25	9.5801	10.89	850.0
2017-09-22	ABEV	Stock	6.79	6.86	6.77	6.85	12116400.0
2017-09-22	ABG	Stock	58.65	60.6	58.65	59.6	330500.0
2017-09-22	ABIL-DELISTED	Stock	0.76	0.78	0.75	0.7562	35901.0
2017-09-22	ABM	Stock	38.94	39.5	38.94	39.31	407300.0

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

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