PREVIEW / etf_daily / 2014-01-07

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-07.parquet
  size:    43 KB
  rows:    1,065

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-01-07	SPY	ETF	183.09	183.79	182.95	183.48	86144200.0
2014-01-07	QQQ	ETF	86.7	87.25	86.56	87.12	25913225.0
2014-01-07	IWM	ETF	114.19	115.16	114.11	114.71	28545300.0
2014-01-07	DIA	ETF	164.66	165.29	164.52	164.97	5387200.0
2014-01-07	GLD	ETF	118.46	118.92	118.13	118.82	6433700.0
2014-01-07	TLT	ETF	102.82	102.99	102.56	102.86	4428100.0
2014-01-07	AADR	ETF	37.45	37.76	37.26	37.36	9700.0
2014-01-07	AAXJ	ETF	57.9	57.99	57.68	57.91	500900.0
2014-01-07	ACWI	ETF	56.77	56.95	56.77	56.89	2486000.0
2014-01-07	ACWV	ETF	62.76	62.82	62.72	62.73	72300.0
2014-01-07	ACWX	ETF	45.84	45.85	45.73	45.79	396817.0
2014-01-07	ADRE	ETF	35.95	36.0	35.68	35.68	11862.0
2014-01-07	AFK	ETF	30.32	30.53	30.1201	30.27	20445.0
2014-01-07	AGG	ETF	106.74	106.78	106.67	106.73	1255700.0
2014-01-07	AGQ	ETF	64.68	65.88	64.16	65.6	509575.0
2014-01-07	AGZ	ETF	110.8085	110.8085	110.67	110.7	14904.0
2014-01-07	AGZD	ETF	25.075	25.075	25.025	25.04	17400.0
2014-01-07	AIA	ETF	45.78	45.956	45.78	45.89	35553.0
2014-01-07	AIQ	ETF	27.3	27.53	26.92	27.06	31727.0
2014-01-07	AIVI	ETF	46.55	46.71	46.55	46.63	10500.0
2014-01-07	ALTL	ETF	32.77	32.77	32.71	32.71	300.0
2014-01-07	AMJ	ETF	45.88	45.9	45.5	45.71	497759.0
2014-01-07	AMLP	ETF	88.5	88.6	87.5	87.85	560660.0
2014-01-07	ANGL	ETF	26.95	27.09	26.95	27.09	2800.0
2014-01-07	AOA	ETF	44.22	44.35	44.2	44.32	32400.0
2014-01-07	AOK	ETF	31.93	31.9818	31.93	31.98	29608.0
2014-01-07	AOM	ETF	34.22	34.26	34.2	34.2	26236.0
2014-01-07	AOR	ETF	38.3	38.4	38.3	38.4	68529.0
2014-01-07	ARGT	ETF	19.2	19.2	18.81	18.98	4600.0
2014-01-07	ASEA	ETF	14.97	15.0	14.95	15.0	43200.0
2014-01-07	ASHR	ETF	23.58	23.63	23.5	23.54	190900.0
2014-01-07	ATMP	ETF	27.15	27.15	26.79	26.92	144800.0
2014-01-07	AVIV	ETF	23.3	23.89	22.74	23.77	164911.0
2014-01-07	AWAY	ETF	41.14	42.26	40.62	41.8725	1426446.0
2014-01-07	BAB	ETF	27.49	27.49	27.43	27.47	107532.0
2014-01-07	BAL	ETF	53.0401	53.1905	53.02	53.0701	2741.0
2014-01-07	BALT	ETF	6.52	6.74	6.47	6.51	888526.0
2014-01-07	BBH	ETF	87.75	88.67	87.75	88.48	77000.0
2014-01-07	BCM	ETF	39.01	39.0599	38.8	39.0	21564.0
2014-01-07	BFOR	ETF	7.37	7.4375	7.37	7.4275	269200.0
2014-01-07	BIB	ETF	36.7575	37.75	36.7575	37.585	123456.0
2014-01-07	BICK	ETF	23.92	23.92	23.81	23.84	817.0
2014-01-07	BIL	ETF	91.54	91.56	91.54	91.56	214700.0
2014-01-07	BIS	ETF	838.8	838.8	826.04	826.04	252.0
2014-01-07	BIV	ETF	82.25	82.27	82.15	82.21	365300.0
2014-01-07	BIZD	ETF	21.05	21.05	20.88	20.94	18100.0
2014-01-07	BJK	ETF	53.94	54.36	53.94	54.31	56500.0
2014-01-07	BKF	ETF	36.14	36.3	36.0	36.05	205219.0
2014-01-07	BKLN	ETF	24.91	24.93	24.9	24.92	1789500.0
2014-01-07	BLV	ETF	82.64	82.64	82.46	82.55	31900.0

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

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