PREVIEW / stock_daily / 2017-11-20

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-20.parquet
  size:    216 KB
  rows:    6,477
  symbols: 2,900

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-11-20	AAPL	Stock	42.5725	42.64	42.39	42.495	65049600.0
2017-11-20	MSFT	Stock	82.4	82.59	82.25	82.53	16315000.0
2017-11-20	NVDA	Stock	5.2998	5.3642	5.2625	5.352	396100000.0
2017-11-20	AMZN	Stock	56.4885	56.671	56.1275	56.3155	43278000.0
2017-11-20	GOOGL	Stock	51.8	51.9348	51.6338	51.733	17526420.0
2017-11-20	META	Stock	178.87	179.5	178.1	178.74	10052400.0
2017-11-20	TSLA	Stock	20.9193	21.0333	20.3167	20.5827	123715500.0
2017-11-20	TLT	Stock	125.91	126.38	125.91	126.34	4232349.0
2017-11-20	ES	Stock	64.25	64.26	63.6	63.84	1486000.0
2017-11-20	CL	Stock	71.94	72.41	71.87	72.07	2799500.0
2017-11-20	A	Stock	69.28	70.23	68.95	69.96	4143500.0
2017-11-20	AA	Stock	42.29	42.55	41.75	42.21	4846200.0
2017-11-20	AAAP-DELISTED	Stock	81.15	81.27	81.11	81.17	279167.0
2017-11-20	AABA-DELISTED	Stock	71.6	72.53	71.43	71.93	13001309.0
2017-11-20	AAC-DELISTED	Stock	9.65	9.8	8.79	8.88	243536.0
2017-11-20	AACG	Stock	4.37	4.43	4.37	4.43	1400.0
2017-11-20	AAIC-DELISTED	Stock	11.51	11.67	11.4654	11.61	249673.0
2017-11-20	AAL	Stock	47.33	47.88	47.12	47.69	2436000.0
2017-11-20	AAM.A-DELISTED	Stock	26.39	26.44	26.25	26.29	33378.0
2017-11-20	AAME	Stock	3.7	3.8	3.7	3.79	3400.0
2017-11-20	AAMI	Stock	15.89	16.08	15.86	15.94	431600.0
2017-11-20	AAOI	Stock	44.55	45.71	43.45	43.48	1672600.0
2017-11-20	AAON	Stock	23.0333	23.3333	23.0	23.3	170850.0
2017-11-20	AAP	Stock	89.21	91.68	88.24	91.43	1498100.0
2017-11-20	AAT	Stock	39.55	39.56	39.23	39.3	186300.0
2017-11-20	AAU-DELISTED	Stock	0.92	0.9297	0.89	0.91	297349.0
2017-11-20	AAUAF-DELISTED	Stock	0.92	0.9297	0.89	0.91	311330.0
2017-11-20	AAV-DELISTED	Stock	5.15	5.15	5.0	5.0	176838.0
2017-11-20	AAWW-DELISTED	Stock	53.55	53.9	53.0	53.125	152838.0
2017-11-20	AAXJ	Stock	76.75	77.175	76.75	77.11	689469.0
2017-11-20	AAXN-DELISTED	Stock	23.19	23.85	23.19	23.62	1001858.0
2017-11-20	AB	Stock	25.45	25.75	25.35	25.65	171400.0
2017-11-20	ABAC-DELISTED	Stock	3.003	3.3403	3.0008	3.13	18806.0
2017-11-20	ABAX-DELISTED	Stock	49.32	49.57	48.54	49.57	70206.0
2017-11-20	ABB-DELISTED	Stock	25.37	25.455	25.36	25.38	1103514.0
2017-11-20	ABBNY-DELISTED	Stock	25.37	25.455	25.36	25.38	1140181.0
2017-11-20	ABBV	Stock	93.92	94.31	92.89	93.6	4352200.0
2017-11-20	ABC-DELISTED	Stock	78.3	78.76	76.48	77.46	1494619.0
2017-11-20	ABCB	Stock	47.8	47.9	46.95	47.7	574100.0
2017-11-20	ABCD-DELISTED	Stock	5.56	5.98	5.55	5.97	68334.0
2017-11-20	ABDC-DELISTED	Stock	7.77	7.97	7.56	7.72	132433.0
2017-11-20	ABE-DELISTED	Stock	14.26	14.2688	14.22	14.2688	9216.0
2017-11-20	ABEO	Stock	386.25	396.25	360.0	367.5	28184.0
2017-11-20	ABEOW-DELISTED	Stock	10.6	10.6	10.0	10.0	450.0
2017-11-20	ABEV	Stock	6.22	6.28	6.18	6.27	8360200.0
2017-11-20	ABG	Stock	61.85	62.3	61.55	62.25	183700.0
2017-11-20	ABIL-DELISTED	Stock	0.549	0.549	0.505	0.5289	160647.0
2017-11-20	ABLX-DELISTED	Stock	22.38	23.24	22.25	23.06	407152.0
2017-11-20	ABM	Stock	39.9	40.29	39.82	40.08	255800.0
2017-11-20	ABMD-DELISTED	Stock	200.0	200.0	195.11	195.66	322964.0

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

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