PREVIEW / stock_daily / 2014-06-12

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-12.parquet
  size:    218 KB
  rows:    6,512
  symbols: 3,525

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-06-12	AAPL	Stock	23.51	23.53	22.975	23.0725	218996000.0
2014-06-12	MSFT	Stock	40.81	40.88	40.29	40.58	29818900.0
2014-06-12	NVDA	Stock	0.485	0.4902	0.4808	0.488	337148000.0
2014-06-12	AMZN	Stock	16.7775	16.7775	16.233	16.2955	85526000.0
2014-06-12	GOOGL	Stock	28.35	28.35	27.8575	27.975	30989740.0
2014-06-12	META	Stock	65.85	66.47	64.06	64.29	55730000.0
2014-06-12	TSLA	Stock	13.6733	13.992	13.514	13.568	89905500.0
2014-06-12	TLT	Stock	111.3	112.35	111.0	112.21	9775925.0
2014-06-12	ES	Stock	44.68	45.14	44.28	45.07	1395400.0
2014-06-12	CL	Stock	68.35	68.6	67.63	67.84	2131500.0
2014-06-12	A	Stock	42.1316	42.2031	41.6309	41.774	2345844.0
2014-06-12	AABA-DELISTED	Stock	36.5	36.79	36.34	36.78	11967950.0
2014-06-12	AACG	Stock	4.7	4.75	4.7	4.73	1800.0
2014-06-12	AAIC-DELISTED	Stock	27.73	27.799	27.53	27.63	208564.0
2014-06-12	AAL	Stock	41.27	41.41	38.85	40.2	37320100.0
2014-06-12	AAMC-DELISTED	Stock	320.3471	323.5294	317.7985	320.5735	42282.0
2014-06-12	AAME	Stock	3.73	3.88	3.73	3.74	7500.0
2014-06-12	AAOI	Stock	22.2	22.45	21.87	22.3	160700.0
2014-06-12	AAON	Stock	14.3689	14.3867	14.1111	14.3022	184050.0
2014-06-12	AAP	Stock	125.8	125.91	123.52	124.28	541900.0
2014-06-12	AAT	Stock	33.94	33.94	33.51	33.86	118600.0
2014-06-12	AAU-DELISTED	Stock	1.34	1.45	1.33	1.45	470252.0
2014-06-12	AAUAF-DELISTED	Stock	1.34	1.46	1.33	1.46	472697.0
2014-06-12	AAV-DELISTED	Stock	6.66	6.82	6.65	6.76	330296.0
2014-06-12	AAWW-DELISTED	Stock	37.89	38.0	36.88	37.07	130685.0
2014-06-12	AAXJ	Stock	63.06	63.18	62.55	62.64	174104.0
2014-06-12	AAXN-DELISTED	Stock	13.9	14.0799	13.51	14.03	640013.0
2014-06-12	AB	Stock	25.71	26.36	24.66	25.24	1139700.0
2014-06-12	ABAC-DELISTED	Stock	2.17	2.18	2.12	2.14	21048.0
2014-06-12	ABAX-DELISTED	Stock	43.15	43.35	42.9125	43.12	89276.0
2014-06-12	ABB-DELISTED	Stock	23.31	23.4	23.25	23.3	2596429.0
2014-06-12	ABBNY-DELISTED	Stock	23.31	23.4	23.25	23.3	2641559.0
2014-06-12	ABBV	Stock	54.22	54.25	53.46	53.66	3941600.0
2014-06-12	ABC-DELISTED	Stock	71.79	72.05	71.1	71.46	1378303.0
2014-06-12	ABCB	Stock	21.75	21.97	21.37	21.68	29700.0
2014-06-12	ABCD-DELISTED	Stock	2.03	2.1	2.0	2.035	23579.0
2014-06-12	ABCO-DELISTED	Stock	50.74	50.74	49.08	49.65	269266.0
2014-06-12	ABDC-DELISTED	Stock	14.52	14.84	14.496	14.53	16553.0
2014-06-12	ABE-DELISTED	Stock	14.61	14.71	14.5625	14.58	10020.0
2014-06-12	ABEO	Stock	400.0	400.0	400.0	400.0	22.0
2014-06-12	ABEV	Stock	7.19	7.27	7.13	7.14	3380900.0
2014-06-12	ABG	Stock	64.43	64.52	62.13	62.44	422900.0
2014-06-12	ABGB-DELISTED	Stock	27.75	27.85	27.5701	27.7699	22348.0
2014-06-12	ABIL-DELISTED	Stock	9.75	9.75	9.75	9.75	349.0
2014-06-12	ABM	Stock	26.78	26.92	26.52	26.71	243300.0
2014-06-12	ABMD-DELISTED	Stock	22.84	23.12	22.62	23.02	144678.0
2014-06-12	ABR	Stock	7.17	7.21	7.09	7.14	157400.0
2014-06-12	ABR.A-DELISTED	Stock	24.31	24.33	24.22	24.301	15324.0
2014-06-12	ABR.B-DELISTED	Stock	23.74	23.81	23.63	23.75	2100.0
2014-06-12	ABR.C-DELISTED	Stock	25.1	25.1	25.02	25.05	4808.0

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

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