PREVIEW / etf_daily / 2014-10-07

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-07.parquet
  size:    46 KB
  rows:    1,123

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-10-07	SPY	ETF	195.28	195.72	193.22	193.26	147913000.0
2014-10-07	QQQ	ETF	97.485	97.7799	96.56	96.57	45153968.0
2014-10-07	IWM	ETF	108.02	108.5	106.85	106.92	40271900.0
2014-10-07	DIA	ETF	168.73	168.94	166.86	166.86	7128800.0
2014-10-07	GLD	ETF	116.31	116.63	116.09	116.36	5274700.0
2014-10-07	TLT	ETF	118.31	119.43	118.18	119.36	8837700.0
2014-10-07	AADR	ETF	36.82	36.82	36.56	36.56	600.0
2014-10-07	AAXJ	ETF	61.33	61.33	60.82	60.87	443700.0
2014-10-07	ACWI	ETF	58.25	58.29	57.64	57.64	2276100.0
2014-10-07	ACWV	ETF	66.75	66.75	66.19	66.24	66100.0
2014-10-07	ACWX	ETF	44.72	44.755	44.27	44.28	658434.0
2014-10-07	ADRE	ETF	39.94	40.0644	39.68	39.6896	6057.0
2014-10-07	AFK	ETF	31.09	31.09	30.8242	30.8242	6335.0
2014-10-07	AGG	ETF	109.61	109.85	109.56	109.82	2328400.0
2014-10-07	AGQ	ETF	47.42	47.67	46.32	46.82	294900.0
2014-10-07	AGZ	ETF	112.59	112.6658	112.34	112.49	9729.0
2014-10-07	AGZD	ETF	24.895	24.895	24.795	24.88	6000.0
2014-10-07	AIA	ETF	46.88	46.8894	46.59	46.59	8176.0
2014-10-07	AIQ	ETF	22.0	22.29	21.53	21.59	17623.0
2014-10-07	AIRR	ETF	17.8	17.902	17.7	17.7	10000.0
2014-10-07	AIVI	ETF	45.74	45.78	45.29	45.29	27300.0
2014-10-07	AMJ	ETF	51.8	52.22	51.4915	51.54	378750.0
2014-10-07	AMLP	ETF	94.65	95.0	94.0	94.1	634560.0
2014-10-07	AMZA	ETF	250.9	250.9	246.54	246.54	3840.0
2014-10-07	AOA	ETF	45.07	45.09	44.66	44.66	33300.0
2014-10-07	AOK	ETF	32.37	32.37	32.24	32.25	30963.0
2014-10-07	AOM	ETF	34.7	34.7	34.51	34.51	40115.0
2014-10-07	AOR	ETF	39.16	39.16	38.86	38.88	37366.0
2014-10-07	ARGT	ETF	20.12	20.13	19.84	19.84	6600.0
2014-10-07	ARKQ	ETF	19.57	19.57	19.5	19.5	4800.0
2014-10-07	ARKW	ETF	19.849	19.85	19.8	19.8	4600.0
2014-10-07	ASEA	ETF	16.51	16.52	16.46	16.47	6800.0
2014-10-07	ASHR	ETF	26.06	26.06	25.72	25.73	504500.0
2014-10-07	ASHS	ETF	33.97	33.97	33.77	33.77	7100.0
2014-10-07	ATMP	ETF	31.94	31.94	31.51	31.51	16200.0
2014-10-07	AVIV	ETF	27.25	27.26	26.94	27.07	240178.0
2014-10-07	AWAY	ETF	34.84	35.35	34.33	34.38	1211380.0
2014-10-07	BAB	ETF	29.95	29.98	29.85	29.89	181395.0
2014-10-07	BAL	ETF	43.2	43.7699	43.2	43.74	10665.0
2014-10-07	BALT	ETF	3.51	3.61	3.35	3.35	1380689.0
2014-10-07	BAR	ETF	3.045	3.0668	2.986	3.0668	34870.0
2014-10-07	BBH	ETF	104.17	104.17	102.56	102.63	61900.0
2014-10-07	BCM	ETF	36.837	36.837	36.757	36.802	2553.0
2014-10-07	BFOR	ETF	7.4175	7.4675	7.3675	7.3675	99600.0
2014-10-07	BIB	ETF	50.625	50.787	49.14	49.305	484678.0
2014-10-07	BICK	ETF	24.97	24.97	24.896	24.896	661.0
2014-10-07	BIL	ETF	91.5	91.5	91.48	91.5	134150.0
2014-10-07	BIS	ETF	494.4	506.088	488.0	504.8	15044.5
2014-10-07	BIV	ETF	84.69	84.91	84.58	84.88	309400.0
2014-10-07	BIZD	ETF	19.07	19.15	19.01	19.02	13400.0

> showing 50 of 1,123 rows — these rows as CSV

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