PREVIEW / stock_daily / 2014-08-21

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-21.parquet
  size:    221 KB
  rows:    6,616
  symbols: 3,582

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
2014-08-21	AAPL	Stock	25.1425	25.235	25.0275	25.145	133912000.0
2014-08-21	MSFT	Stock	44.84	45.25	44.83	45.22	22285500.0
2014-08-21	NVDA	Stock	0.48	0.4825	0.476	0.4768	272796000.0
2014-08-21	AMZN	Stock	16.824	16.829	16.6115	16.6455	39422000.0
2014-08-21	GOOGL	Stock	29.745	29.7625	29.555	29.621	22671860.0
2014-08-21	META	Stock	74.92	75.19	74.41	74.57	20102000.0
2014-08-21	TSLA	Stock	17.1013	17.2533	16.884	16.956	43734000.0
2014-08-21	TLT	Stock	116.07	116.76	116.02	116.64	6791654.0
2014-08-21	ES	Stock	45.09	45.4	44.94	45.18	1208700.0
2014-08-21	CL	Stock	64.55	65.01	64.55	64.81	2500000.0
2014-08-21	A	Stock	41.7454	41.8312	41.4664	41.4807	1717303.0
2014-08-21	AABA-DELISTED	Stock	37.63	37.75	37.31	37.64	10644255.0
2014-08-21	AACG	Stock	4.84	4.84	4.59	4.68	27500.0
2014-08-21	AAIC-DELISTED	Stock	27.72	27.92	27.61	27.89	122975.0
2014-08-21	AAL	Stock	40.75	40.85	39.45	39.51	8152000.0
2014-08-21	AAMC-DELISTED	Stock	170.7353	178.8235	166.8382	176.0735	60918.0
2014-08-21	AAME	Stock	4.16	4.17	4.07	4.17	5700.0
2014-08-21	AAOI	Stock	19.61	19.77	19.43	19.57	158600.0
2014-08-21	AAON	Stock	12.4067	12.7267	12.1333	12.5733	160350.0
2014-08-21	AAP	Stock	135.4	135.99	134.24	134.48	557000.0
2014-08-21	AAT	Stock	35.21	35.48	35.2	35.22	128100.0
2014-08-21	AAU-DELISTED	Stock	1.4	1.44	1.39	1.4	130563.0
2014-08-21	AAUAF-DELISTED	Stock	1.4	1.44	1.39	1.4	137511.0
2014-08-21	AAV-DELISTED	Stock	5.77	5.99	5.68	5.98	477969.0
2014-08-21	AAVL-DELISTED	Stock	31.35	31.78	30.02	30.3	105930.0
2014-08-21	AAWW-DELISTED	Stock	33.46	34.19	32.89	34.12	158245.0
2014-08-21	AAXJ	Stock	65.68	65.85	65.51	65.56	397749.0
2014-08-21	AAXN-DELISTED	Stock	15.63	15.91	15.305	15.9	2811455.0
2014-08-21	AB	Stock	26.8	27.2	26.41	27.04	223000.0
2014-08-21	ABAC-DELISTED	Stock	2.02	2.02	1.93	2.0	25555.0
2014-08-21	ABAX-DELISTED	Stock	46.04	46.68	45.82	46.16	117241.0
2014-08-21	ABB-DELISTED	Stock	22.83	22.97	22.83	22.89	1185505.0
2014-08-21	ABBNY-DELISTED	Stock	22.84	22.97	22.83	22.9	1324129.0
2014-08-21	ABBV	Stock	54.79	55.12	54.68	54.96	8063200.0
2014-08-21	ABC-DELISTED	Stock	77.06	77.37	76.88	76.92	624988.0
2014-08-21	ABCB	Stock	22.34	23.09	22.09	23.06	193400.0
2014-08-21	ABCD-DELISTED	Stock	1.67	1.76	1.66	1.68	55729.0
2014-08-21	ABCO-DELISTED	Stock	50.3	50.415	49.505	50.28	188542.0
2014-08-21	ABDC-DELISTED	Stock	13.31	13.45	13.3	13.39	64748.0
2014-08-21	ABE-DELISTED	Stock	14.67	14.67	14.62	14.62	515.0
2014-08-21	ABEO	Stock	412.5	412.5	375.0	412.5	22.0
2014-08-21	ABEV	Stock	7.2	7.2	7.09	7.14	8119100.0
2014-08-21	ABG	Stock	69.29	69.63	68.36	68.78	227400.0
2014-08-21	ABGB-DELISTED	Stock	26.28	26.87	26.25	26.7	39586.0
2014-08-21	ABM	Stock	25.93	26.07	25.66	26.01	190200.0
2014-08-21	ABMD-DELISTED	Stock	25.0	25.32	24.76	24.82	156262.0
2014-08-21	ABR	Stock	6.9	6.98	6.89	6.98	152000.0
2014-08-21	ABR.A-DELISTED	Stock	24.7	24.72	24.6556	24.6556	1835.0
2014-08-21	ABR.B-DELISTED	Stock	24.3803	24.3999	24.12	24.1201	4100.0
2014-08-21	ABR.C-DELISTED	Stock	25.0	25.08	25.0	25.08	3950.0

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

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