PREVIEW / stock_daily / 2014-06-25

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-25.parquet
  size:    221 KB
  rows:    6,596
  symbols: 3,567

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-25	AAPL	Stock	22.5525	22.675	22.4125	22.59	147476000.0
2014-06-25	MSFT	Stock	41.7	42.05	41.46	42.03	20049100.0
2014-06-25	NVDA	Stock	0.4618	0.4655	0.4575	0.4652	215420000.0
2014-06-25	AMZN	Stock	16.2165	16.4075	16.087	16.372	46556000.0
2014-06-25	GOOGL	Stock	28.6775	29.365	28.663	29.2965	42294860.0
2014-06-25	META	Stock	65.58	67.48	65.57	67.44	44308000.0
2014-06-25	TSLA	Stock	15.5367	15.8367	15.3493	15.7927	87024000.0
2014-06-25	TLT	Stock	113.1	113.36	112.685	112.87	5699273.0
2014-06-25	ES	Stock	46.41	46.72	46.39	46.62	1211700.0
2014-06-25	CL	Stock	67.91	68.09	67.7	67.95	2117200.0
2014-06-25	A	Stock	41.2089	41.5594	41.0658	41.4664	1482579.0
2014-06-25	AABA-DELISTED	Stock	33.38	34.0301	33.1	33.245	17380585.0
2014-06-25	AACG	Stock	4.69	4.69	4.22	4.63	17500.0
2014-06-25	AAIC-DELISTED	Stock	27.78	27.91	27.52	27.88	381244.0
2014-06-25	AAL	Stock	42.9	44.0	42.3	43.91	10944400.0
2014-06-25	AAMC-DELISTED	Stock	217.0588	230.0	208.0059	228.7235	112190.0
2014-06-25	AAME	Stock	3.96	3.96	3.87	3.93	4200.0
2014-06-25	AAOI	Stock	23.26	23.85	22.93	23.25	267900.0
2014-06-25	AAON	Stock	14.3333	14.6978	14.3111	14.6489	168075.0
2014-06-25	AAP	Stock	130.98	131.53	128.02	129.85	1124900.0
2014-06-25	AAT	Stock	34.63	34.73	34.33	34.58	90400.0
2014-06-25	AAU-DELISTED	Stock	1.47	1.5	1.369	1.4	198744.0
2014-06-25	AAUAF-DELISTED	Stock	1.42	1.45	1.32	1.4	207430.0
2014-06-25	AAV-DELISTED	Stock	6.63	6.79	6.61	6.72	176731.0
2014-06-25	AAWW-DELISTED	Stock	36.37	37.14	35.94	36.93	269802.0
2014-06-25	AAXJ	Stock	61.98	62.2	61.9	62.11	228676.0
2014-06-25	AAXN-DELISTED	Stock	13.36	13.4881	13.18	13.47	480785.0
2014-06-25	AB	Stock	24.86	25.23	24.7	24.96	150800.0
2014-06-25	ABAC-DELISTED	Stock	2.25	2.25	2.0	2.15	57462.0
2014-06-25	ABAX-DELISTED	Stock	44.06	45.2	43.77	44.62	91390.0
2014-06-25	ABB-DELISTED	Stock	22.78	22.93	22.78	22.84	1469983.0
2014-06-25	ABBNY-DELISTED	Stock	22.78	22.93	22.78	22.84	1526682.0
2014-06-25	ABBV	Stock	53.52	55.79	53.4	55.0	11085100.0
2014-06-25	ABC-DELISTED	Stock	72.58	73.11	72.4	72.73	893401.0
2014-06-25	ABCB	Stock	20.85	21.58	20.68	21.45	98200.0
2014-06-25	ABCD-DELISTED	Stock	1.98	2.08	1.98	2.07	7293.0
2014-06-25	ABCO-DELISTED	Stock	51.02	52.26	50.71	50.93	182103.0
2014-06-25	ABDC-DELISTED	Stock	14.39	14.4	14.0	14.26	43533.0
2014-06-25	ABE-DELISTED	Stock	14.3	14.35	14.28	14.32	7403.0
2014-06-25	ABEO	Stock	400.0	400.0	362.5	387.5	27.0
2014-06-25	ABEV	Stock	7.08	7.11	7.0	7.03	22881900.0
2014-06-25	ABG	Stock	65.25	66.54	65.1	66.38	154800.0
2014-06-25	ABGB-DELISTED	Stock	26.05	26.66	25.89	26.54	14748.0
2014-06-25	ABIL-DELISTED	Stock	9.75	9.75	9.75	9.75	355.0
2014-06-25	ABM	Stock	26.1	26.59	26.03	26.56	173500.0
2014-06-25	ABMD-DELISTED	Stock	23.3	24.13	23.23	24.08	203937.0
2014-06-25	ABR	Stock	6.96	7.01	6.94	6.96	66200.0
2014-06-25	ABR.A-DELISTED	Stock	24.43	24.49	24.351	24.49	35880.0
2014-06-25	ABR.B-DELISTED	Stock	24.13	24.18	24.13	24.18	1513.0
2014-06-25	ABR.C-DELISTED	Stock	24.99	25.04	24.99	25.0	1900.0

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

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