PREVIEW / stock_daily / 2017-05-30

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-30.parquet
  size:    213 KB
  rows:    6,473
  symbols: 3,027

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-30	AAPL	Stock	38.355	38.6075	38.3325	38.4175	80507600.0
2017-05-30	MSFT	Stock	69.79	70.41	69.77	70.41	17072800.0
2017-05-30	NVDA	Stock	3.5925	3.6572	3.5763	3.6218	989652000.0
2017-05-30	AMZN	Stock	49.8255	50.06	49.776	49.835	65262000.0
2017-05-30	GOOGL	Stock	49.625	49.881	49.568	49.8085	30333700.0
2017-05-30	META	Stock	151.97	152.9	151.64	152.38	13226000.0
2017-05-30	TSLA	Stock	21.7333	22.4187	21.7173	22.34	116743500.0
2017-05-30	TLT	Stock	124.03	124.14	123.74	124.09	4819358.0
2017-05-30	ES	Stock	61.4	61.66	61.3	61.48	908400.0
2017-05-30	CL	Stock	75.52	76.16	75.24	76.09	4698400.0
2017-05-30	A	Stock	59.54	60.48	59.41	60.37	2576400.0
2017-05-30	AA	Stock	33.03	33.16	32.53	32.99	3223500.0
2017-05-30	AAAP-DELISTED	Stock	38.6	39.0	37.94	38.39	43613.0
2017-05-30	AABA-DELISTED	Stock	50.56	50.94	50.5	50.56	7115878.0
2017-05-30	AAC-DELISTED	Stock	6.7	6.7	6.05	6.29	298421.0
2017-05-30	AACG	Stock	3.48	3.55	3.4	3.46	15800.0
2017-05-30	AAIC-DELISTED	Stock	14.4	14.48	14.3558	14.39	202468.0
2017-05-30	AAL	Stock	48.32	48.58	47.79	47.96	5512900.0
2017-05-30	AAM.A-DELISTED	Stock	25.55	25.55	25.36	25.4	105828.0
2017-05-30	AAMC-DELISTED	Stock	26.4853	27.0588	26.0	26.4706	16453.0
2017-05-30	AAME	Stock	3.65	3.8	3.65	3.8	1300.0
2017-05-30	AAMI	Stock	13.96	14.1	13.8	13.86	374200.0
2017-05-30	AAOI	Stock	71.2	71.81	69.11	70.48	2283700.0
2017-05-30	AAON	Stock	24.2667	24.3667	24.0	24.1	127800.0
2017-05-30	AAP	Stock	134.65	135.21	132.77	132.99	1543800.0
2017-05-30	AAT	Stock	39.43	39.43	38.96	38.98	179100.0
2017-05-30	AAU-DELISTED	Stock	1.44	1.44	1.33	1.335	248924.0
2017-05-30	AAUAF-DELISTED	Stock	1.44	1.44	1.33	1.34	254315.0
2017-05-30	AAV-DELISTED	Stock	6.45	6.45	6.25	6.3	115871.0
2017-05-30	AAWW-DELISTED	Stock	49.7	50.0	48.95	49.0	162260.0
2017-05-30	AAXJ	Stock	67.02	67.15	66.91	67.05	702842.0
2017-05-30	AAXN-DELISTED	Stock	24.75	24.8657	24.45	24.58	431634.0
2017-05-30	AB	Stock	21.9	22.3	21.75	22.15	812500.0
2017-05-30	ABAC-DELISTED	Stock	2.0899	2.1	2.06	2.06	6292.0
2017-05-30	ABAX-DELISTED	Stock	49.31	50.14	48.965	49.75	87741.0
2017-05-30	ABB-DELISTED	Stock	24.9	25.03	24.8807	24.99	681477.0
2017-05-30	ABBNY-DELISTED	Stock	24.9	25.03	24.8807	24.98	711696.0
2017-05-30	ABBV	Stock	65.89	66.2	65.81	66.02	4803900.0
2017-05-30	ABC-DELISTED	Stock	90.66	91.39	90.53	91.0	1101667.0
2017-05-30	ABCB	Stock	44.55	44.55	43.7	43.95	75900.0
2017-05-30	ABCD-DELISTED	Stock	5.05	5.07	4.98	5.01	11903.0
2017-05-30	ABCO-DELISTED	Stock	51.05	51.25	50.525	51.0	280671.0
2017-05-30	ABDC-DELISTED	Stock	13.3	13.45	13.2	13.2014	46719.0
2017-05-30	ABE-DELISTED	Stock	13.84	13.84	13.84	13.84	101.0
2017-05-30	ABEO	Stock	142.5	143.75	132.0	140.0	11044.0
2017-05-30	ABEV	Stock	5.74	5.76	5.72	5.72	36833000.0
2017-05-30	ABG	Stock	56.15	56.6	55.5	55.75	116500.0
2017-05-30	ABIL-DELISTED	Stock	0.64	0.65	0.5812	0.5812	35800.0
2017-05-30	ABM	Stock	42.03	42.4	41.82	42.37	159900.0
2017-05-30	ABMD-DELISTED	Stock	138.2	140.62	138.2	139.77	325162.0

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

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