PREVIEW / stock_daily / 2017-05-05

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-05.parquet
  size:    215 KB
  rows:    6,446
  symbols: 3,021

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-05-05	AAPL	Stock	36.69	37.245	36.69	37.24	109310800.0
2017-05-05	MSFT	Stock	68.9	69.03	68.49	69.0	19128800.0
2017-05-05	NVDA	Stock	2.5845	2.6038	2.5688	2.5965	228428000.0
2017-05-05	AMZN	Stock	47.026	47.0395	46.515	46.7075	57328000.0
2017-05-05	GOOGL	Stock	47.836	47.922	47.4049	47.514	32310960.0
2017-05-05	META	Stock	151.45	151.63	149.79	150.24	17148500.0
2017-05-05	TSLA	Stock	19.8667	20.57	19.7867	20.5567	122659500.0
2017-05-05	TLT	Stock	121.38	121.47	120.89	121.29	5605412.0
2017-05-05	ES	Stock	59.71	59.89	59.49	59.55	926500.0
2017-05-05	CL	Stock	72.01	72.14	71.54	71.81	2700400.0
2017-05-05	A	Stock	56.85	56.96	56.59	56.64	1571500.0
2017-05-05	AA	Stock	31.35	31.96	31.05	31.82	4191200.0
2017-05-05	AAAP-DELISTED	Stock	38.23	38.25	37.25	37.7	43012.0
2017-05-05	AABA-DELISTED	Stock	48.45	48.66	48.27	48.49	4421001.0
2017-05-05	AAC-DELISTED	Stock	7.93	7.93	6.87	7.09	254988.0
2017-05-05	AACG	Stock	3.63	3.92	3.61	3.66	34300.0
2017-05-05	AAIC-DELISTED	Stock	14.12	14.34	14.0548	14.3	246030.0
2017-05-05	AAL	Stock	44.0	44.52	43.77	44.51	5462800.0
2017-05-05	AAM.A-DELISTED	Stock	25.5908	25.73	25.5908	25.7	53428.0
2017-05-05	AAMC-DELISTED	Stock	20.6706	21.0882	19.3382	21.0882	26132.0
2017-05-05	AAME	Stock	3.85	3.85	3.75	3.8	900.0
2017-05-05	AAMI	Stock	15.16	15.33	14.89	14.96	714900.0
2017-05-05	AAOI	Stock	51.53	56.3	48.5	55.96	10854900.0
2017-05-05	AAON	Stock	25.0	25.0333	24.0667	24.1667	281850.0
2017-05-05	AAP	Stock	144.98	145.02	143.6	144.98	617500.0
2017-05-05	AAT	Stock	41.55	41.77	41.24	41.57	224200.0
2017-05-05	AAU-DELISTED	Stock	1.35	1.42	1.34	1.355	294333.0
2017-05-05	AAUAF-DELISTED	Stock	1.35	1.42	1.34	1.38	296381.0
2017-05-05	AAV-DELISTED	Stock	6.0	6.2	5.925	6.15	141321.0
2017-05-05	AAWW-DELISTED	Stock	52.95	53.1	52.0	52.25	273992.0
2017-05-05	AAXJ	Stock	63.97	64.29	63.945	64.27	1269087.0
2017-05-05	AAXN-DELISTED	Stock	24.88	24.95	24.675	24.95	359117.0
2017-05-05	AB	Stock	20.7	21.05	20.55	20.9	486100.0
2017-05-05	ABAC-DELISTED	Stock	1.7	1.7	1.62	1.67	5295.0
2017-05-05	ABAX-DELISTED	Stock	47.64	47.74	46.98	47.66	69428.0
2017-05-05	ABB-DELISTED	Stock	24.61	24.92	24.6	24.91	1881436.0
2017-05-05	ABBNY-DELISTED	Stock	24.61	24.92	24.6	24.91	1930436.0
2017-05-05	ABBV	Stock	67.19	67.22	66.32	66.99	4587800.0
2017-05-05	ABC-DELISTED	Stock	86.66	86.97	85.54	85.9	1461883.0
2017-05-05	ABCB	Stock	47.35	47.35	46.55	47.0	91400.0
2017-05-05	ABCD-DELISTED	Stock	5.01	5.4	5.01	5.31	37828.0
2017-05-05	ABCO-DELISTED	Stock	54.5	54.5	50.65	51.5	379571.0
2017-05-05	ABDC-DELISTED	Stock	13.94	14.44	13.9	14.3	49489.0
2017-05-05	ABE-DELISTED	Stock	13.5612	13.665	13.56	13.6496	14966.0
2017-05-05	ABEO	Stock	140.0	141.25	137.0	138.75	6924.0
2017-05-05	ABEV	Stock	5.95	5.97	5.91	5.92	26298700.0
2017-05-05	ABG	Stock	58.45	59.65	57.35	59.55	217800.0
2017-05-05	ABIL-DELISTED	Stock	0.772	0.831	0.772	0.79	28186.0
2017-05-05	ABM	Stock	43.54	43.62	43.3	43.61	227200.0
2017-05-05	ABMD-DELISTED	Stock	132.13	134.81	131.63	132.96	264866.0

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

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