PREVIEW / stock_daily / 2014-06-17

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-17.parquet
  size:    220 KB
  rows:    6,551
  symbols: 3,554

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-17	AAPL	Stock	23.0775	23.175	22.95	23.02	118904000.0
2014-06-17	MSFT	Stock	41.29	41.91	40.34	41.68	22518600.0
2014-06-17	NVDA	Stock	0.4875	0.4923	0.485	0.4902	157608000.0
2014-06-17	AMZN	Stock	16.377	16.567	16.2615	16.281	58482000.0
2014-06-17	GOOGL	Stock	27.618	27.687	27.3735	27.5308	29633380.0
2014-06-17	META	Stock	64.1	64.88	63.93	64.4	27715000.0
2014-06-17	TSLA	Stock	14.9407	15.7027	14.8567	15.4447	199573500.0
2014-06-17	TLT	Stock	112.07	112.09	111.48	111.54	6669215.0
2014-06-17	ES	Stock	45.62	45.76	45.32	45.58	912200.0
2014-06-17	CL	Stock	68.03	68.05	67.67	67.89	1644400.0
2014-06-17	A	Stock	41.681	42.3462	41.6237	42.1102	1857243.0
2014-06-17	AABA-DELISTED	Stock	34.8	34.94	34.3	34.43	23165007.0
2014-06-17	AACG	Stock	4.57	4.83	4.57	4.74	1700.0
2014-06-17	AAIC-DELISTED	Stock	27.84	27.92	27.66	27.69	354327.0
2014-06-17	AAL	Stock	41.08	42.19	40.76	41.87	12523400.0
2014-06-17	AAMC-DELISTED	Stock	322.3529	325.2368	317.9412	322.3529	62319.0
2014-06-17	AAME	Stock	3.9	3.9	3.8	3.84	6500.0
2014-06-17	AAOI	Stock	22.61	22.81	21.66	21.78	203000.0
2014-06-17	AAON	Stock	14.3333	14.5867	14.2889	14.56	269100.0
2014-06-17	AAP	Stock	125.01	126.6	125.01	125.95	571200.0
2014-06-17	AAT	Stock	33.84	34.24	33.74	34.1	207800.0
2014-06-17	AAU-DELISTED	Stock	1.35	1.44	1.34	1.4	80159.0
2014-06-17	AAUAF-DELISTED	Stock	1.35	1.43	1.34	1.41	82357.0
2014-06-17	AAV-DELISTED	Stock	6.96	7.14	6.88	7.08	326029.0
2014-06-17	AAWW-DELISTED	Stock	36.89	37.09	36.44	36.45	127005.0
2014-06-17	AAXJ	Stock	62.64	62.75	62.58	62.72	830572.0
2014-06-17	AAXN-DELISTED	Stock	13.83	14.19	13.65	14.07	680873.0
2014-06-17	AB	Stock	25.22	25.74	25.21	25.52	198400.0
2014-06-17	ABAC-DELISTED	Stock	2.12	2.18	2.1199	2.18	60900.0
2014-06-17	ABAX-DELISTED	Stock	43.86	44.39	43.5	43.72	105001.0
2014-06-17	ABB-DELISTED	Stock	23.12	23.31	23.12	23.28	876538.0
2014-06-17	ABBNY-DELISTED	Stock	23.12	23.31	23.12	23.27	903364.0
2014-06-17	ABBV	Stock	54.49	54.54	53.85	54.3	3385000.0
2014-06-17	ABC-DELISTED	Stock	71.37	71.93	71.18	71.74	768265.0
2014-06-17	ABCB	Stock	21.35	21.93	21.35	21.82	38900.0
2014-06-17	ABCD-DELISTED	Stock	2.05	2.17	2.0	2.01	13188.0
2014-06-17	ABCO-DELISTED	Stock	49.96	51.07	49.94	50.84	270483.0
2014-06-17	ABDC-DELISTED	Stock	14.71	14.71	14.4	14.42	17066.0
2014-06-17	ABE-DELISTED	Stock	14.41	14.41	14.3001	14.3799	17402.0
2014-06-17	ABEO	Stock	400.0	400.0	400.0	400.0	10.0
2014-06-17	ABEV	Stock	6.91	6.94	6.81	6.94	8236300.0
2014-06-17	ABG	Stock	63.2	64.52	62.91	63.66	179600.0
2014-06-17	ABGB-DELISTED	Stock	27.25	27.41	27.04	27.13	5678.0
2014-06-17	ABM	Stock	26.25	26.48	26.17	26.37	226500.0
2014-06-17	ABMD-DELISTED	Stock	23.24	23.48	23.068	23.43	167417.0
2014-06-17	ABR	Stock	7.06	7.07	7.01	7.01	81500.0
2014-06-17	ABR.A-DELISTED	Stock	24.4588	24.4588	24.34	24.34	2628.0
2014-06-17	ABR.B-DELISTED	Stock	23.87	23.928	23.8	23.928	3800.0
2014-06-17	ABR.C-DELISTED	Stock	25.0	25.1	25.0	25.0	5845.0
2014-06-17	ABRN-DELISTED	Stock	25.0	25.0	24.9	24.99	13022.0

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

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