PREVIEW / etf_daily / 2014-10-09

all etf daily files

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

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-09	SPY	ETF	196.33	196.6	192.58	192.74	210705000.0
2014-10-09	QQQ	ETF	98.33	98.57	96.71	96.86	62497086.0
2014-10-09	IWM	ETF	108.89	108.9	106.01	106.03	60783400.0
2014-10-09	DIA	ETF	169.16	169.48	166.2	166.34	13387300.0
2014-10-09	GLD	ETF	117.86	118.26	117.49	117.64	6610500.0
2014-10-09	TLT	ETF	119.27	119.67	118.78	118.87	10291700.0
2014-10-09	AADR	ETF	36.1	36.1	36.1	36.1	400.0
2014-10-09	AAXJ	ETF	61.5	61.51	60.7	60.85	628500.0
2014-10-09	ACWI	ETF	58.37	58.39	57.22	57.27	3523800.0
2014-10-09	ACWV	ETF	67.02	67.18	66.11	66.22	87900.0
2014-10-09	ACWX	ETF	44.59	44.61	43.78	43.84	719855.0
2014-10-09	ADRE	ETF	40.12	40.184	39.588	39.66	8161.0
2014-10-09	AFK	ETF	30.86	30.97	30.31	30.43	24627.0
2014-10-09	AGG	ETF	110.07	110.07	109.87	109.91	1502800.0
2014-10-09	AGQ	ETF	48.43	49.54	47.5	47.54	332100.0
2014-10-09	AGZ	ETF	112.84	113.19	112.577	112.5801	9287.0
2014-10-09	AGZD	ETF	24.82	24.835	24.705	24.83	11600.0
2014-10-09	AIA	ETF	47.03	47.03	46.35	46.56	15932.0
2014-10-09	AIQ	ETF	22.7	22.82	21.75	21.88	37137.0
2014-10-09	AIRR	ETF	17.86	17.86	17.4	17.412	21400.0
2014-10-09	AIVI	ETF	45.59	45.59	44.62	44.68	45600.0
2014-10-09	ALTL	ETF	34.53	34.53	34.53	34.53	5001.0
2014-10-09	AMJ	ETF	51.11	51.33	49.22	49.5	1644918.0
2014-10-09	AMLP	ETF	93.7	93.75	91.25	91.5	1914880.0
2014-10-09	AMZA	ETF	244.9	244.9	235.9	237.9	6120.0
2014-10-09	ANGL	ETF	27.7	27.7	27.55	27.7	800.0
2014-10-09	AOA	ETF	44.9	45.16	44.46	44.47	25700.0
2014-10-09	AOK	ETF	32.3901	32.44	32.18	32.2	48140.0
2014-10-09	AOM	ETF	34.72	34.77	34.46	34.46	41827.0
2014-10-09	AOR	ETF	39.26	39.26	38.77	38.7886	28074.0
2014-10-09	ARGT	ETF	19.96	19.96	19.5	19.5	8500.0
2014-10-09	ARKQ	ETF	19.53	19.53	19.09	19.2	6800.0
2014-10-09	ARKW	ETF	19.91	19.96	19.59	19.65	16400.0
2014-10-09	ASEA	ETF	16.56	16.57	16.41	16.43	14200.0
2014-10-09	ASHR	ETF	26.05	26.05	25.8	25.86	523100.0
2014-10-09	ASHS	ETF	34.42	34.42	33.94	34.1	10000.0
2014-10-09	ATMP	ETF	31.53	31.54	30.09	30.2	41500.0
2014-10-09	AVIV	ETF	27.45	27.82	27.41	27.74	229015.0
2014-10-09	AWAY	ETF	34.72	35.11	33.95	34.44	737345.0
2014-10-09	BAB	ETF	30.04	30.07	29.94	30.0	194274.0
2014-10-09	BAL	ETF	42.69	42.83	42.47	42.71	10687.0
2014-10-09	BALT	ETF	3.41	3.44	3.21	3.23	989809.0
2014-10-09	BAR	ETF	3.165	3.181	3.132	3.147	32690.0
2014-10-09	BBH	ETF	105.12	105.26	103.02	103.21	72900.0
2014-10-09	BCHP	ETF	18.0303	18.0303	18.0	18.0	2476.0
2014-10-09	BFOR	ETF	7.46	7.46	7.3125	7.3125	94000.0
2014-10-09	BIB	ETF	51.88	51.975	49.275	49.685	485148.0
2014-10-09	BICK	ETF	25.049	25.2	25.049	25.049	703.0
2014-10-09	BIL	ETF	91.48	91.5	91.48	91.5	978250.0
2014-10-09	BIS	ETF	478.4	501.996	477.6	498.0	20736.0

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

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