PREVIEW / stock_daily / 2014-06-24

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-24.parquet
  size:    221 KB
  rows:    6,592
  symbols: 3,576

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-24	AAPL	Stock	22.6875	22.935	22.5475	22.57	156144000.0
2014-06-24	MSFT	Stock	41.83	41.94	41.56	41.75	26509100.0
2014-06-24	NVDA	Stock	0.467	0.4708	0.4585	0.4605	275780000.0
2014-06-24	AMZN	Stock	16.377	16.4865	16.137	16.208	52532000.0
2014-06-24	GOOGL	Stock	28.711	29.1125	28.458	28.627	56886500.0
2014-06-24	META	Stock	65.36	67.17	65.27	65.72	57335000.0
2014-06-24	TSLA	Stock	15.9313	16.1253	15.442	15.5	121138500.0
2014-06-24	TLT	Stock	112.15	112.65	111.815	112.58	9698714.0
2014-06-24	ES	Stock	46.29	46.63	46.18	46.53	1687900.0
2014-06-24	CL	Stock	67.76	68.22	67.55	67.95	2438700.0
2014-06-24	A	Stock	41.5093	41.8383	41.1874	41.2375	1573868.0
2014-06-24	AABA-DELISTED	Stock	33.79	33.99	33.35	33.47	14188323.0
2014-06-24	AACG	Stock	4.64	4.75	4.64	4.75	2500.0
2014-06-24	AAIC-DELISTED	Stock	28.01	28.05	27.71	27.72	301620.0
2014-06-24	AAL	Stock	44.14	44.61	42.76	43.18	13248100.0
2014-06-24	AAMC-DELISTED	Stock	237.0588	238.2382	214.5588	219.9853	292988.0
2014-06-24	AAME	Stock	3.97	4.0	3.74	3.94	9500.0
2014-06-24	AAOI	Stock	23.32	24.18	23.19	23.46	426600.0
2014-06-24	AAON	Stock	14.52	14.8578	14.3778	14.4267	241425.0
2014-06-24	AAP	Stock	130.67	133.92	130.67	131.66	1509100.0
2014-06-24	AAT	Stock	34.5	34.76	34.45	34.74	182800.0
2014-06-24	AAU-DELISTED	Stock	1.54	1.5426	1.45	1.45	312323.0
2014-06-24	AAUAF-DELISTED	Stock	1.5	1.5	1.41	1.45	322322.0
2014-06-24	AAV-DELISTED	Stock	6.86	6.88	6.58	6.64	365612.0
2014-06-24	AAWW-DELISTED	Stock	36.3	37.14	36.02	36.53	273649.0
2014-06-24	AAXJ	Stock	62.67	62.88	62.3	62.34	443305.0
2014-06-24	AAXN-DELISTED	Stock	13.6	13.73	13.36	13.435	746941.0
2014-06-24	AB	Stock	25.5	25.59	24.85	24.93	315000.0
2014-06-24	ABAC-DELISTED	Stock	2.18	2.25	2.18	2.24	34453.0
2014-06-24	ABAX-DELISTED	Stock	44.24	44.99	43.882	44.28	102615.0
2014-06-24	ABB-DELISTED	Stock	23.01	23.11	22.9	22.94	1418991.0
2014-06-24	ABBNY-DELISTED	Stock	23.01	23.11	22.9	22.94	1512026.0
2014-06-24	ABBV	Stock	53.74	53.95	53.43	53.59	5483500.0
2014-06-24	ABC-DELISTED	Stock	72.18	72.74	71.91	72.55	1247575.0
2014-06-24	ABCB	Stock	21.19	21.51	20.96	21.0	56100.0
2014-06-24	ABCD-DELISTED	Stock	1.95	2.05	1.95	2.05	6401.0
2014-06-24	ABCO-DELISTED	Stock	51.22	52.05	50.86	51.22	160278.0
2014-06-24	ABDC-DELISTED	Stock	14.25	14.39	14.25	14.26	22299.0
2014-06-24	ABE-DELISTED	Stock	14.22	14.39	14.22	14.24	10393.0
2014-06-24	ABEV	Stock	6.99	7.03	6.97	7.0	19776100.0
2014-06-24	ABG	Stock	65.8	66.74	65.54	65.63	237400.0
2014-06-24	ABGB-DELISTED	Stock	27.26	27.5	26.82	26.86	20493.0
2014-06-24	ABIL-DELISTED	Stock	9.76	9.76	9.76	9.76	153.0
2014-06-24	ABM	Stock	26.37	26.67	26.23	26.25	202100.0
2014-06-24	ABMD-DELISTED	Stock	23.15	23.77	23.008	23.36	238339.0
2014-06-24	ABR	Stock	7.11	7.13	6.96	6.96	153400.0
2014-06-24	ABR.A-DELISTED	Stock	24.41	24.45	24.37	24.44	9420.0
2014-06-24	ABR.B-DELISTED	Stock	23.82	24.04	23.82	24.0	850.0
2014-06-24	ABR.C-DELISTED	Stock	25.11	25.11	24.67	24.67	21200.0
2014-06-24	ABRN-DELISTED	Stock	24.95	24.99	24.94	24.99	2800.0

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

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