PREVIEW / stock_daily / 2016-08-29

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-29.parquet
  size:    220 KB
  rows:    6,561
  symbols: 3,246

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
2016-08-29	AAPL	Stock	26.655	26.86	26.5725	26.705	99881200.0
2016-08-29	MSFT	Stock	58.18	58.6	58.1	58.1	16417200.0
2016-08-29	NVDA	Stock	1.557	1.5632	1.5472	1.5498	274652000.0
2016-08-29	AMZN	Stock	38.436	38.749	38.43	38.5645	43972000.0
2016-08-29	GOOGL	Stock	39.6525	39.926	39.516	39.791	15473960.0
2016-08-29	META	Stock	124.35	126.73	124.35	126.54	15925900.0
2016-08-29	TSLA	Stock	14.6767	14.6933	14.3333	14.3467	48994500.0
2016-08-29	TLT	Stock	139.38	140.35	139.21	140.21	7310409.0
2016-08-29	ES	Stock	54.29	54.68	54.25	54.37	995100.0
2016-08-29	CL	Stock	74.44	74.93	74.43	74.81	2397600.0
2016-08-29	A	Stock	47.45	47.89	47.31	47.62	1333000.0
2016-08-29	AA.B-DELISTED	Stock	34.7	35.05	34.4	34.88	67962.0
2016-08-29	AAAP-DELISTED	Stock	33.14	34.38	32.9701	34.0	23138.0
2016-08-29	AABA-DELISTED	Stock	42.2	42.46	42.0801	42.26	4226056.0
2016-08-29	AAC-DELISTED	Stock	18.68	18.86	18.5	18.77	260123.0
2016-08-29	AACG	Stock	4.45	4.5	4.12	4.45	2900.0
2016-08-29	AAIC-DELISTED	Stock	14.56	14.74	14.56	14.63	173682.0
2016-08-29	AAL	Stock	36.13	36.41	36.05	36.17	4760700.0
2016-08-29	AAMC-DELISTED	Stock	3.7412	3.8676	3.7235	3.8676	11421.0
2016-08-29	AAME	Stock	3.56	3.56	3.34	3.54	2800.0
2016-08-29	AAMI	Stock	13.29	13.52	13.23	13.47	156400.0
2016-08-29	AAOI	Stock	16.47	17.17	16.09	16.85	643100.0
2016-08-29	AAON	Stock	18.4867	18.7	18.4533	18.6467	71100.0
2016-08-29	AAP	Stock	156.83	158.39	156.71	157.67	550100.0
2016-08-29	AAT	Stock	44.09	44.8	44.09	44.56	81100.0
2016-08-29	AAU-DELISTED	Stock	1.35	1.43	1.33	1.42	293587.0
2016-08-29	AAUAF-DELISTED	Stock	1.35	1.43	1.33	1.43	295830.0
2016-08-29	AAV-DELISTED	Stock	7.05	7.085	6.93	7.04	57652.0
2016-08-29	AAWW-DELISTED	Stock	36.54	36.5999	35.43	35.79	245453.0
2016-08-29	AAXJ	Stock	58.82	59.13	58.76	59.04	519746.0
2016-08-29	AAXN-DELISTED	Stock	28.56	28.95	28.56	28.76	396269.0
2016-08-29	AB	Stock	21.96	22.13	21.85	22.06	231900.0
2016-08-29	ABAC-DELISTED	Stock	0.8	0.8001	0.76	0.76	28392.0
2016-08-29	ABAX-DELISTED	Stock	50.48	50.98	50.14	50.82	83632.0
2016-08-29	ABB-DELISTED	Stock	21.81	21.935	21.8	21.9	869764.0
2016-08-29	ABBNY-DELISTED	Stock	21.81	21.935	21.8	21.91	930967.0
2016-08-29	ABBV	Stock	64.84	65.09	64.19	64.51	5099200.0
2016-08-29	ABC-DELISTED	Stock	85.82	86.445	85.3103	86.32	1146916.0
2016-08-29	ABCB	Stock	34.03	34.21	34.0	34.11	97400.0
2016-08-29	ABCD-DELISTED	Stock	4.59	4.88	4.59	4.77	12249.0
2016-08-29	ABCO-DELISTED	Stock	42.2	42.32	42.01	42.15	138834.0
2016-08-29	ABDC-DELISTED	Stock	12.45	12.54	12.45	12.53	20283.0
2016-08-29	ABE-DELISTED	Stock	12.57	12.62	12.57	12.6101	1291.0
2016-08-29	ABEO	Stock	106.0	106.5	104.0	105.0	3440.0
2016-08-29	ABEOW-DELISTED	Stock	1.8	1.8	1.79	1.79	200.0
2016-08-29	ABEV	Stock	5.88	5.97	5.84	5.95	39292500.0
2016-08-29	ABG	Stock	52.98	53.75	52.77	53.61	213000.0
2016-08-29	ABIL-DELISTED	Stock	4.37	4.5	4.22	4.3799	47183.0
2016-08-29	ABM	Stock	38.06	38.29	37.87	38.03	135300.0
2016-08-29	ABMD-DELISTED	Stock	119.03	121.44	118.9	120.7	262781.0

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

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