PREVIEW / stock_daily / 2014-07-11

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-11.parquet
  size:    218 KB
  rows:    6,542
  symbols: 3,536

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-07-11	AAPL	Stock	23.84	23.9725	23.715	23.805	136072000.0
2014-07-11	MSFT	Stock	41.7	42.09	41.48	42.09	24083000.0
2014-07-11	NVDA	Stock	0.4758	0.4778	0.474	0.4763	191188000.0
2014-07-11	AMZN	Stock	16.7355	17.35	16.7355	17.31	166016000.0
2014-07-11	GOOGL	Stock	29.05	29.4115	29.0288	29.3325	30285300.0
2014-07-11	META	Stock	65.28	66.59	64.79	66.34	39212000.0
2014-07-11	TSLA	Stock	14.7073	14.7733	14.5067	14.542	49534500.0
2014-07-11	TLT	Stock	113.35	113.68	113.28	113.58	4676510.0
2014-07-11	ES	Stock	46.08	46.18	45.6	45.73	785500.0
2014-07-11	CL	Stock	69.47	69.62	69.25	69.52	1681500.0
2014-07-11	A	Stock	40.2933	40.5866	40.1645	40.4864	1654253.0
2014-07-11	AABA-DELISTED	Stock	34.94	35.56	34.78	35.42	16877423.0
2014-07-11	AACG	Stock	4.28	4.43	4.15	4.21	29300.0
2014-07-11	AAIC-DELISTED	Stock	26.73	26.751	26.55	26.62	100892.0
2014-07-11	AAL	Stock	42.91	43.23	42.52	42.88	8135500.0
2014-07-11	AAMC-DELISTED	Stock	194.1147	208.8235	194.1147	208.8235	43574.0
2014-07-11	AAME	Stock	3.93	3.99	3.85	3.9	83200.0
2014-07-11	AAOI	Stock	22.76	23.64	22.49	23.38	263200.0
2014-07-11	AAON	Stock	14.44	14.64	14.36	14.5244	197775.0
2014-07-11	AAP	Stock	132.96	133.57	132.49	133.29	484700.0
2014-07-11	AAT	Stock	34.9	35.03	34.62	34.85	136800.0
2014-07-11	AAU-DELISTED	Stock	1.4301	1.4499	1.39	1.44	143129.0
2014-07-11	AAUAF-DELISTED	Stock	1.46	1.46	1.4	1.44	144300.0
2014-07-11	AAV-DELISTED	Stock	6.16	6.18	5.92	5.95	596475.0
2014-07-11	AAWW-DELISTED	Stock	34.75	34.89	34.17	34.54	161428.0
2014-07-11	AAXJ	Stock	63.41	63.52	63.29	63.46	206732.0
2014-07-11	AAXN-DELISTED	Stock	11.26	11.48	11.0	11.2	924930.0
2014-07-11	AB	Stock	26.29	27.15	26.29	26.82	645600.0
2014-07-11	ABAC-DELISTED	Stock	2.08	2.1	2.08	2.0801	20311.0
2014-07-11	ABAX-DELISTED	Stock	43.26	43.71	42.95	43.05	99413.0
2014-07-11	ABB-DELISTED	Stock	22.73	22.81	22.655	22.78	781218.0
2014-07-11	ABBNY-DELISTED	Stock	22.73	22.81	22.655	22.79	863875.0
2014-07-11	ABBV	Stock	55.34	56.6	54.48	54.96	13586800.0
2014-07-11	ABC-DELISTED	Stock	72.94	73.1	72.43	72.99	458036.0
2014-07-11	ABCB	Stock	21.42	21.58	21.2	21.42	23700.0
2014-07-11	ABCD-DELISTED	Stock	1.99	2.0845	1.99	2.07	52484.0
2014-07-11	ABCO-DELISTED	Stock	50.7	51.13	50.39	50.65	78620.0
2014-07-11	ABDC-DELISTED	Stock	13.86	14.187	13.25	13.71	208638.0
2014-07-11	ABE-DELISTED	Stock	14.44	14.5199	14.43	14.45	7518.0
2014-07-11	ABEO	Stock	325.0	350.0	325.0	337.5	3.0
2014-07-11	ABEV	Stock	6.99	7.05	6.97	7.02	9660000.0
2014-07-11	ABG	Stock	70.76	71.28	70.51	71.13	165700.0
2014-07-11	ABGB-DELISTED	Stock	25.27	25.329	24.673	24.883	6031.0
2014-07-11	ABM	Stock	26.08	26.39	25.87	26.16	200800.0
2014-07-11	ABMD-DELISTED	Stock	25.45	25.45	24.82	24.94	103236.0
2014-07-11	ABR	Stock	6.89	6.92	6.85	6.89	105400.0
2014-07-11	ABR.A-DELISTED	Stock	24.8256	24.86	24.72	24.7845	29200.0
2014-07-11	ABR.B-DELISTED	Stock	24.4999	24.5	24.48	24.5	1200.0
2014-07-11	ABR.C-DELISTED	Stock	25.1999	25.24	25.12	25.16	17709.0
2014-07-11	ABRN-DELISTED	Stock	25.08	25.08	24.91	25.0199	13546.0

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

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