PREVIEW / stock_daily / 2016-06-10

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-10.parquet
  size:    217 KB
  rows:    6,511
  symbols: 3,244

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-06-10	AAPL	Stock	24.6325	24.8375	24.62	24.7075	126851600.0
2016-06-10	MSFT	Stock	51.05	52.05	51.04	51.48	25833200.0
2016-06-10	NVDA	Stock	1.1705	1.181	1.1535	1.155	400024000.0
2016-06-10	AMZN	Stock	36.1175	36.249	35.7105	35.8955	68514000.0
2016-06-10	GOOGL	Stock	36.7975	36.982	36.5255	36.6595	29049120.0
2016-06-10	META	Stock	117.54	118.11	116.26	116.62	18510800.0
2016-06-10	TSLA	Stock	15.1593	15.198	14.5613	14.586	90399000.0
2016-06-10	TLT	Stock	134.79	135.33	134.2643	134.78	6984577.0
2016-06-10	ES	Stock	56.84	57.19	56.51	56.68	993800.0
2016-06-10	CL	Stock	72.0	72.23	71.74	72.12	2232300.0
2016-06-10	A	Stock	45.73	45.78	45.19	45.36	1261700.0
2016-06-10	AA.B-DELISTED	Stock	34.68	34.68	33.58	33.95	33416.0
2016-06-10	AAAP-DELISTED	Stock	31.76	31.76	30.79	31.01	18767.0
2016-06-10	AABA-DELISTED	Stock	36.97	37.14	36.59	36.82	10620238.0
2016-06-10	AAC-DELISTED	Stock	20.87	20.87	20.01	20.21	100105.0
2016-06-10	AACG	Stock	5.08	5.25	5.08	5.14	3400.0
2016-06-10	AAIC-DELISTED	Stock	13.6	13.84	13.55	13.7	203958.0
2016-06-10	AAL	Stock	32.8	33.48	32.64	33.14	8252300.0
2016-06-10	AAMC-DELISTED	Stock	5.9588	6.0083	5.5676	5.5676	93391.0
2016-06-10	AAME	Stock	3.51	3.53	3.51	3.53	700.0
2016-06-10	AAMI	Stock	14.61	14.7	14.26	14.35	189800.0
2016-06-10	AAOI	Stock	10.65	10.898	10.12	10.26	438200.0
2016-06-10	AAON	Stock	18.2467	18.34	18.06	18.0933	95250.0
2016-06-10	AAP	Stock	154.9	155.64	152.7	153.02	965700.0
2016-06-10	AAT	Stock	41.11	41.44	41.06	41.19	88100.0
2016-06-10	AAU-DELISTED	Stock	1.26	1.3	1.118	1.1385	615872.0
2016-06-10	AAUAF-DELISTED	Stock	1.26	1.3	1.118	1.17	620558.0
2016-06-10	AAV-DELISTED	Stock	5.93	5.93	5.7101	5.81	135224.0
2016-06-10	AAWW-DELISTED	Stock	46.32	47.06	45.62	46.02	222079.0
2016-06-10	AAXJ	Stock	53.99	54.02	53.54	53.73	813608.0
2016-06-10	AAXN-DELISTED	Stock	23.14	23.22	22.65	22.76	623937.0
2016-06-10	AB	Stock	23.38	23.42	22.93	22.98	171000.0
2016-06-10	ABAC-DELISTED	Stock	0.8	0.8142	0.71	0.75	2357.0
2016-06-10	ABAX-DELISTED	Stock	46.54	46.54	45.45	45.53	63686.0
2016-06-10	ABB-DELISTED	Stock	20.78	20.85	20.59	20.67	1600603.0
2016-06-10	ABBNY-DELISTED	Stock	20.78	20.85	20.59	20.68	1662499.0
2016-06-10	ABBV	Stock	59.99	61.01	59.72	61.0	11052300.0
2016-06-10	ABC-DELISTED	Stock	75.87	77.24	75.37	76.47	2491200.0
2016-06-10	ABCB	Stock	31.38	31.73	31.3	31.56	98200.0
2016-06-10	ABCD-DELISTED	Stock	4.58	4.69	4.58	4.65	7139.0
2016-06-10	ABCO-DELISTED	Stock	34.27	35.41	33.363	33.8	184183.0
2016-06-10	ABDC-DELISTED	Stock	12.2	12.37	12.2	12.21	30277.0
2016-06-10	ABEO	Stock	78.25	80.75	76.5	77.75	2084.0
2016-06-10	ABEOW-DELISTED	Stock	1.25	1.25	1.2	1.2	6000.0
2016-06-10	ABEV	Stock	5.53	5.53	5.41	5.41	7358800.0
2016-06-10	ABG	Stock	54.84	55.4	53.98	54.42	371300.0
2016-06-10	ABIL-DELISTED	Stock	3.5	3.5467	3.38	3.39	18543.0
2016-06-10	ABM	Stock	37.08	37.85	36.87	37.3	601000.0
2016-06-10	ABMD-DELISTED	Stock	103.31	103.635	101.93	102.53	285722.0
2016-06-10	ABR	Stock	7.0	7.05	6.95	6.99	29400.0

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

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