PREVIEW / stock_daily / 2015-08-20

all stock daily files

  file:    by_date/stock_daily/2015/2015-08-20.parquet
  size:    223 KB
  rows:    6,646
  symbols: 3,451

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
2015-08-20	AAPL	Stock	28.52	28.5875	27.9075	28.1625	274006400.0
2015-08-20	MSFT	Stock	46.07	46.47	45.66	45.66	36238200.0
2015-08-20	NVDA	Stock	0.5682	0.571	0.5512	0.554	426932000.0
2015-08-20	AMZN	Stock	26.5195	26.6625	25.7885	25.789	88160000.0
2015-08-20	GOOGL	Stock	34.455	34.808	33.764	33.974	57797540.0
2015-08-20	META	Stock	93.54	94.77	90.46	90.56	44598200.0
2015-08-20	TSLA	Stock	16.804	16.9707	16.1267	16.1453	73587000.0
2015-08-20	TLT	Stock	125.37	126.1	125.18	126.02	9078313.0
2015-08-20	ES	Stock	51.44	52.15	51.3	51.62	1366900.0
2015-08-20	CL	Stock	66.2	66.55	65.96	65.99	3715900.0
2015-08-20	A	Stock	38.01	38.31	37.5	37.51	2144600.0
2015-08-20	AA.B-DELISTED	Stock	34.25	34.28	33.6	33.66	48953.0
2015-08-20	AABA-DELISTED	Stock	34.77	34.95	33.87	34.1	14811992.0
2015-08-20	AAC-DELISTED	Stock	22.59	22.8092	21.16	21.85	412766.0
2015-08-20	AACG	Stock	2.98	3.1	2.88	2.96	27000.0
2015-08-20	AAIC-DELISTED	Stock	17.84	18.0	17.82	17.82	192050.0
2015-08-20	AAL	Stock	42.84	43.52	41.78	41.98	8905700.0
2015-08-20	AAMC-DELISTED	Stock	12.2206	14.1176	10.7464	11.0882	146492.0
2015-08-20	AAME	Stock	3.44	3.64	3.44	3.58	1800.0
2015-08-20	AAMI	Stock	17.24	17.49	17.13	17.17	126100.0
2015-08-20	AAOI	Stock	21.44	21.6	20.31	20.33	402100.0
2015-08-20	AAON	Stock	14.96	15.14	14.8267	14.8533	192900.0
2015-08-20	AAP	Stock	187.48	187.65	184.37	184.45	591500.0
2015-08-20	AAT	Stock	41.74	42.09	41.52	41.71	133200.0
2015-08-20	AAU-DELISTED	Stock	0.66	0.66	0.6225	0.6354	63246.0
2015-08-20	AAUAF-DELISTED	Stock	0.66	0.66	0.6225	0.6354	64010.0
2015-08-20	AAV-DELISTED	Stock	5.24	5.28	5.12	5.13	142335.0
2015-08-20	AAVL-DELISTED	Stock	10.69	10.93	10.18	10.27	644652.0
2015-08-20	AAWW-DELISTED	Stock	43.47	44.15	41.78	41.87	451833.0
2015-08-20	AAXJ	Stock	54.13	54.2701	53.8	53.83	2665670.0
2015-08-20	AAXN-DELISTED	Stock	22.55	22.87	21.45	21.7	2211138.0
2015-08-20	AB	Stock	27.85	27.92	27.17	27.31	300400.0
2015-08-20	ABAC-DELISTED	Stock	0.8001	0.8259	0.77	0.7899	14300.0
2015-08-20	ABAX-DELISTED	Stock	47.5	47.86	47.09	47.34	178908.0
2015-08-20	ABB-DELISTED	Stock	19.65	19.655	19.29	19.305	2093666.0
2015-08-20	ABBNY-DELISTED	Stock	19.65	19.655	19.29	19.29	2135250.0
2015-08-20	ABBV	Stock	68.0	68.43	67.48	67.48	9600900.0
2015-08-20	ABC-DELISTED	Stock	105.1	105.7	103.34	103.38	1459528.0
2015-08-20	ABCB	Stock	27.95	27.97	27.46	27.7	132700.0
2015-08-20	ABCD-DELISTED	Stock	4.71	4.86	4.63	4.67	107334.0
2015-08-20	ABCO-DELISTED	Stock	51.86	52.22	50.92	51.21	229186.0
2015-08-20	ABCW-DELISTED	Stock	39.89	40.64	39.77	39.77	13570.0
2015-08-20	ABDC-DELISTED	Stock	12.94	12.96	12.78	12.8	15167.0
2015-08-20	ABE-DELISTED	Stock	11.6999	11.7201	11.54	11.55	4998.0
2015-08-20	ABEO	Stock	134.75	134.75	122.25	125.25	12792.0
2015-08-20	ABEOW-DELISTED	Stock	1.81	1.81	1.69	1.69	3900.0
2015-08-20	ABEV	Stock	5.16	5.33	5.14	5.3	20276600.0
2015-08-20	ABG	Stock	82.4	82.85	79.57	79.63	318500.0
2015-08-20	ABGB-DELISTED	Stock	4.12	4.12	3.91	3.91	155918.0
2015-08-20	ABIL-DELISTED	Stock	9.95	9.95	9.95	9.95	200.0

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

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