PREVIEW / stock_daily / 2015-02-20

all stock daily files

  file:    by_date/stock_daily/2015/2015-02-20.parquet
  size:    223 KB
  rows:    6,631
  symbols: 3,509

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-02-20	AAPL	Stock	32.155	32.375	32.0125	32.375	195793600.0
2015-02-20	MSFT	Stock	43.51	43.88	43.29	43.86	29721100.0
2015-02-20	NVDA	Stock	0.554	0.5588	0.55	0.5585	157752000.0
2015-02-20	AMZN	Stock	18.931	19.185	18.792	19.183	65160000.0
2015-02-20	GOOGL	Stock	27.379	27.379	26.905	27.09	38234640.0
2015-02-20	META	Stock	79.55	80.34	79.2	79.9	36931700.0
2015-02-20	TSLA	Stock	14.052	14.5067	13.9873	14.474	89731500.0
2015-02-20	TLT	Stock	127.05	128.01	126.0	126.54	12502546.0
2015-02-20	ES	Stock	52.36	52.62	51.61	52.54	1880600.0
2015-02-20	CL	Stock	70.13	70.35	69.57	70.24	2358900.0
2015-02-20	A	Stock	41.09	42.11	40.88	41.95	2971900.0
2015-02-20	AA.B-DELISTED	Stock	51.27	51.27	50.25	50.68	20895.0
2015-02-20	AABA-DELISTED	Stock	44.31	44.36	43.76	44.11	11440290.0
2015-02-20	AAC-DELISTED	Stock	29.51	30.54	29.2	30.22	91582.0
2015-02-20	AACG	Stock	4.23	4.37	4.23	4.37	500.0
2015-02-20	AAIC-DELISTED	Stock	24.85	24.94	24.61	24.83	198907.0
2015-02-20	AAL	Stock	49.81	51.12	49.13	51.02	10537900.0
2015-02-20	AAMC-DELISTED	Stock	59.5824	59.7059	57.8353	59.7059	7276.0
2015-02-20	AAME	Stock	3.97	3.99	3.97	3.99	700.0
2015-02-20	AAMI	Stock	17.12	17.3	17.05	17.2	191700.0
2015-02-20	AAOI	Stock	10.22	10.3	10.11	10.22	93700.0
2015-02-20	AAON	Stock	15.58	15.8267	15.46	15.8267	146700.0
2015-02-20	AAP	Stock	152.64	155.14	151.82	155.06	928900.0
2015-02-20	AAT	Stock	42.4	42.81	42.3	42.69	69800.0
2015-02-20	AAU-DELISTED	Stock	1.1	1.14	1.1	1.1	137579.0
2015-02-20	AAUAF-DELISTED	Stock	1.07	1.11	1.07	1.1	142539.0
2015-02-20	AAV-DELISTED	Stock	5.47	5.53	5.37	5.39	152166.0
2015-02-20	AAVL-DELISTED	Stock	39.95	40.35	38.02	40.09	233802.0
2015-02-20	AAWW-DELISTED	Stock	47.83	48.0	46.73	47.22	240695.0
2015-02-20	AAXJ	Stock	63.35	63.75	63.13	63.66	1084692.0
2015-02-20	AAXN-DELISTED	Stock	27.23	27.77	27.04	27.59	1061840.0
2015-02-20	AB	Stock	27.07	27.22	26.94	27.17	254900.0
2015-02-20	ABAC-DELISTED	Stock	1.6	1.652	1.55	1.61	1400.0
2015-02-20	ABAX-DELISTED	Stock	60.09	60.75	59.1	60.1501	160805.0
2015-02-20	ABB-DELISTED	Stock	21.31	21.62	21.205	21.571	1880753.0
2015-02-20	ABBNY-DELISTED	Stock	21.31	21.62	21.205	21.57	1979333.0
2015-02-20	ABBV	Stock	59.61	61.34	59.22	61.3	15534000.0
2015-02-20	ABC-DELISTED	Stock	101.02	102.0	100.18	101.98	1334972.0
2015-02-20	ABCB	Stock	25.83	26.03	25.53	26.0	52900.0
2015-02-20	ABCD-DELISTED	Stock	2.68	2.7	2.65	2.66	14744.0
2015-02-20	ABCO-DELISTED	Stock	53.64	53.7	52.46	53.5	208188.0
2015-02-20	ABCW-DELISTED	Stock	34.4	35.0	34.0	34.7	6513.0
2015-02-20	ABDC-DELISTED	Stock	13.75	13.77	13.4901	13.59	443410.0
2015-02-20	ABE-DELISTED	Stock	12.99	13.135	12.99	13.135	6428.0
2015-02-20	ABEO	Stock	77.25	77.5	77.25	77.5	336.0
2015-02-20	ABEV	Stock	6.32	6.38	6.27	6.36	7588900.0
2015-02-20	ABG	Stock	78.73	79.0	77.68	78.87	151500.0
2015-02-20	ABGB-DELISTED	Stock	16.89	17.95	16.76	17.64	99561.0
2015-02-20	ABM	Stock	30.59	30.72	30.32	30.62	142800.0
2015-02-20	ABMD-DELISTED	Stock	60.62	60.65	59.72	60.33	387635.0

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

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