PREVIEW / stock_daily / 2014-02-20

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-20.parquet
  size:    217 KB
  rows:    6,492
  symbols: 3,552

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-02-20	AAPL	Stock	19.0354	19.1786	18.8929	18.9696	305858000.0
2014-02-20	MSFT	Stock	37.57	37.87	37.4	37.75	27526100.0
2014-02-20	NVDA	Stock	0.4545	0.4705	0.4538	0.4695	398088000.0
2014-02-20	AMZN	Stock	17.44	17.523	17.219	17.49	69856000.0
2014-02-20	META	Stock	67.73	70.11	65.73	69.63	130928900.0
2014-02-20	TSLA	Stock	14.334	14.3473	13.7513	13.998	270034500.0
2014-02-20	TLT	Stock	106.32	106.63	105.69	106.11	5103383.0
2014-02-20	ES	Stock	44.47	44.8	44.34	44.67	1576000.0
2014-02-20	CL	Stock	61.48	62.11	61.35	61.86	2658300.0
2014-02-20	A	Stock	40.1574	41.1588	40.093	40.98	6471482.0
2014-02-20	AABA-DELISTED	Stock	37.83	38.04	37.3	37.78	10620522.0
2014-02-20	AAIC-DELISTED	Stock	25.68	25.94	25.5	25.88	82179.0
2014-02-20	AAL	Stock	34.43	35.67	34.43	35.66	9282100.0
2014-02-20	AAMC-DELISTED	Stock	273.7206	273.7206	245.0147	267.65	327736.0
2014-02-20	AAME	Stock	3.93	3.97	3.93	3.94	9200.0
2014-02-20	AAOI	Stock	15.5	18.75	15.5	17.98	469000.0
2014-02-20	AAON	Stock	12.8133	13.2089	12.64	13.1289	276075.0
2014-02-20	AAP	Stock	125.98	128.06	125.77	127.56	882700.0
2014-02-20	AAT	Stock	33.76	34.07	33.68	33.8	237200.0
2014-02-20	AAU-DELISTED	Stock	1.62	1.709	1.61	1.7	130358.0
2014-02-20	AAUAF-DELISTED	Stock	1.64	1.729	1.63	1.7	131197.0
2014-02-20	AAV-DELISTED	Stock	3.98	4.06	3.97	4.02	82583.0
2014-02-20	AAWW-DELISTED	Stock	32.11	32.935	32.11	32.61	222067.0
2014-02-20	AAXJ	Stock	57.22	57.61	57.03	57.54	372265.0
2014-02-20	AAXN-DELISTED	Stock	18.64	19.06	17.82	19.02	1701053.0
2014-02-20	AB	Stock	24.75	24.95	23.75	24.23	968900.0
2014-02-20	ABAC-DELISTED	Stock	1.7099	1.7099	1.68	1.69	11220.0
2014-02-20	ABAX-DELISTED	Stock	38.69	39.62	38.52	39.45	141147.0
2014-02-20	ABB-DELISTED	Stock	25.01	25.25	24.95	25.06	3098481.0
2014-02-20	ABBNY-DELISTED	Stock	25.01	25.25	24.95	25.04	3781748.0
2014-02-20	ABBV	Stock	51.19	52.11	50.73	51.86	6078900.0
2014-02-20	ABC-DELISTED	Stock	68.4	68.65	67.57	68.4	1358403.0
2014-02-20	ABCB	Stock	20.15	20.47	20.15	20.23	40500.0
2014-02-20	ABCD-DELISTED	Stock	1.97	2.0	1.8501	1.9307	23251.0
2014-02-20	ABCO-DELISTED	Stock	64.0	64.72	63.28	64.05	249735.0
2014-02-20	ABE-DELISTED	Stock	12.54	12.54	12.45	12.45	12974.0
2014-02-20	ABEO	Stock	412.5	475.0	412.5	462.5	45.0
2014-02-20	ABEV	Stock	6.82	7.05	6.81	6.97	13301000.0
2014-02-20	ABFS-DELISTED	Stock	31.61	32.13	30.96	31.89	364779.0
2014-02-20	ABG	Stock	49.01	49.55	48.47	48.89	145200.0
2014-02-20	ABGB-DELISTED	Stock	20.32	21.033	20.2	20.7	42520.0
2014-02-20	ABIL-DELISTED	Stock	9.55	9.64	9.55	9.59	37196.0
2014-02-20	ABM	Stock	27.38	27.66	27.28	27.59	183800.0
2014-02-20	ABMD-DELISTED	Stock	28.4	28.85	27.79	28.55	510682.0
2014-02-20	ABR	Stock	7.04	7.05	6.96	6.97	233000.0
2014-02-20	ABR.A-DELISTED	Stock	24.08	24.3	23.76	24.07	37795.0
2014-02-20	ABR.B-DELISTED	Stock	22.85	23.0	22.71	22.95	10551.0
2014-02-20	ABT	Stock	38.82	39.09	38.53	38.95	8611900.0
2014-02-20	ABTL-DELISTED	Stock	17.9	18.824	17.3	18.63	357824.0
2014-02-20	ABUS	Stock	18.81	20.64	18.81	20.46	408200.0

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

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