PREVIEW / etf_daily / 2014-10-20

all etf daily files

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

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-20	SPY	ETF	188.13	190.45	188.07	190.3	130011000.0
2014-10-20	QQQ	ETF	92.96	94.47	92.8	94.39	41479253.0
2014-10-20	IWM	ETF	107.01	108.74	107.0	108.74	34914400.0
2014-10-20	DIA	ETF	162.35	163.68	162.25	163.65	7156500.0
2014-10-20	GLD	ETF	119.68	119.86	119.54	119.8	3033700.0
2014-10-20	TLT	ETF	121.78	121.85	120.94	121.51	7742500.0
2014-10-20	AADR	ETF	35.95	35.95	35.95	35.95	500.0
2014-10-20	AAXJ	ETF	60.6	60.95	60.49	60.92	363800.0
2014-10-20	ACWI	ETF	56.24	56.75	56.19	56.71	1408800.0
2014-10-20	ACWV	ETF	65.76	66.35	65.76	66.35	62700.0
2014-10-20	ACWX	ETF	43.25	43.55	43.19	43.55	574233.0
2014-10-20	ADRE	ETF	38.39	38.89	38.1	38.78	136913.0
2014-10-20	AFK	ETF	28.82	29.22	28.82	29.06	14050.0
2014-10-20	AGG	ETF	110.69	110.73	110.57	110.65	1518300.0
2014-10-20	AGQ	ETF	48.06	48.48	47.44	48.1	208100.0
2014-10-20	AGZ	ETF	113.34	113.49	113.2	113.2001	11553.0
2014-10-20	AGZD	ETF	24.795	24.795	24.69	24.69	4200.0
2014-10-20	AIA	ETF	46.1	46.33	46.05	46.29	24907.0
2014-10-20	AIQ	ETF	22.96	23.79	22.53	22.74	17644.0
2014-10-20	AIRR	ETF	17.68	17.7	17.51	17.55	26400.0
2014-10-20	AIVI	ETF	44.0	44.5	44.0	44.5	21800.0
2014-10-20	ALTL	ETF	34.07	34.07	34.07	34.07	202.0
2014-10-20	AMJ	ETF	49.65	50.44	49.31	50.28	1616552.0
2014-10-20	AMLP	ETF	92.1	92.65	91.2	92.45	1052360.0
2014-10-20	AMZA	ETF	240.0	242.3	236.9	239.72	540.0
2014-10-20	ANGL	ETF	27.6	27.63	27.56	27.63	2300.0
2014-10-20	AOA	ETF	44.05	44.42	44.05	44.41	13100.0
2014-10-20	AOK	ETF	32.11	32.25	32.11	32.25	62436.0
2014-10-20	AOM	ETF	34.38	34.51	34.36	34.51	24028.0
2014-10-20	AOR	ETF	38.56	38.79	38.4701	38.79	52336.0
2014-10-20	ARGT	ETF	19.2	19.51	19.2	19.4	7000.0
2014-10-20	ARKQ	ETF	19.09	19.15	19.08	19.15	8000.0
2014-10-20	ARKW	ETF	18.98	19.06	18.98	19.06	5000.0
2014-10-20	ASEA	ETF	16.36	16.43	16.36	16.43	3600.0
2014-10-20	ASHR	ETF	25.8	25.91	25.73	25.85	858500.0
2014-10-20	ASHS	ETF	33.69	33.73	33.62	33.67	15700.0
2014-10-20	ATMP	ETF	30.47	30.82	30.38	30.82	51800.0
2014-10-20	AVIV	ETF	28.01	28.91	28.01	28.8	148482.0
2014-10-20	AWAY	ETF	31.76	32.58	31.518	32.04	558823.0
2014-10-20	BAB	ETF	30.06	30.24	30.02	30.09	145145.0
2014-10-20	BAL	ETF	41.79	41.796	41.5301	41.54	7326.0
2014-10-20	BALT	ETF	3.41	3.66	3.41	3.49	642776.0
2014-10-20	BAR	ETF	3.299	3.31	3.281	3.298	42100.0
2014-10-20	BBH	ETF	101.97	103.73	101.97	103.63	97900.0
2014-10-20	BCM	ETF	35.76	35.859	35.76	35.859	467.0
2014-10-20	BFOR	ETF	7.25	7.34	7.235	7.3375	155600.0
2014-10-20	BIB	ETF	48.85	50.475	48.675	50.28	617678.0
2014-10-20	BICK	ETF	24.42	24.42	24.4144	24.4144	963.0
2014-10-20	BIL	ETF	91.5	91.52	91.48	91.5	4556600.0
2014-10-20	BIS	ETF	501.2	505.88	486.4	489.6	11135.5

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

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