PREVIEW / etf_daily / 2014-10-08

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-08.parquet
  size:    45 KB
  rows:    1,122

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-08	SPY	ETF	193.37	196.92	192.36	196.64	186461000.0
2014-10-08	QQQ	ETF	96.66	98.76	96.06	98.45	64931636.0
2014-10-08	IWM	ETF	106.68	109.04	105.76	108.97	51589200.0
2014-10-08	DIA	ETF	166.87	169.82	166.35	169.62	8893200.0
2014-10-08	GLD	ETF	117.03	117.71	115.85	117.47	10670900.0
2014-10-08	TLT	ETF	119.45	119.52	118.51	119.39	9391300.0
2014-10-08	AADR	ETF	36.84	36.84	36.84	36.84	300.0
2014-10-08	AAXJ	ETF	60.82	61.74	60.48	61.65	672200.0
2014-10-08	ACWI	ETF	57.74	58.67	57.38	58.59	1720000.0
2014-10-08	ACWV	ETF	66.31	67.38	66.09	67.29	95200.0
2014-10-08	ACWX	ETF	44.39	44.94	44.07	44.91	1242245.0
2014-10-08	ADRE	ETF	39.68	40.07	39.17	40.05	10892.0
2014-10-08	AFK	ETF	30.6	31.18	30.4	31.01	30603.0
2014-10-08	AGG	ETF	109.9	110.14	109.68	110.13	2477900.0
2014-10-08	AGQ	ETF	47.48	48.23	46.0	47.84	384900.0
2014-10-08	AGZ	ETF	112.41	112.87	112.41	112.87	4789.0
2014-10-08	AGZD	ETF	24.88	24.885	24.8	24.8	8200.0
2014-10-08	AIA	ETF	46.51	47.13	46.21	47.03	63596.0
2014-10-08	AIQ	ETF	21.55	22.49	21.18	22.22	33036.0
2014-10-08	AIRR	ETF	17.64	18.02	17.5	18.02	81900.0
2014-10-08	AIVI	ETF	45.35	46.05	45.19	46.04	47400.0
2014-10-08	AMJ	ETF	51.55	51.55	50.06	51.1	2198280.0
2014-10-08	AMLP	ETF	94.15	94.25	92.3	93.7	955120.0
2014-10-08	AMZA	ETF	246.9	246.9	240.5	245.5	5950.0
2014-10-08	ANGL	ETF	27.77	27.77	27.75	27.75	1800.0
2014-10-08	AOA	ETF	44.72	45.32	44.52	45.31	21000.0
2014-10-08	AOK	ETF	32.21	32.49	32.184	32.48	47088.0
2014-10-08	AOM	ETF	34.5	34.85	34.45	34.8	68174.0
2014-10-08	AOR	ETF	38.94	39.35	38.8	39.35	27483.0
2014-10-08	ARGT	ETF	19.76	20.0	19.55	19.99	29000.0
2014-10-08	ARKQ	ETF	19.35	19.56	19.19	19.56	4100.0
2014-10-08	ARKW	ETF	19.57	19.93	19.42	19.93	4200.0
2014-10-08	ASEA	ETF	16.4	16.57	16.31	16.57	7000.0
2014-10-08	ASHR	ETF	25.99	26.28	25.86	26.25	360300.0
2014-10-08	ASHS	ETF	34.09	34.56	34.06	34.56	9500.0
2014-10-08	ATMP	ETF	31.42	31.43	30.78	31.34	28500.0
2014-10-08	AVIV	ETF	27.06	27.44	26.944	27.44	184776.0
2014-10-08	AWAY	ETF	34.9	35.24	34.09	34.79	977187.0
2014-10-08	BAB	ETF	29.99	30.08	29.9	30.03	84195.0
2014-10-08	BAL	ETF	43.47	43.6838	43.42	43.42	9603.0
2014-10-08	BALT	ETF	3.4	3.475	3.255	3.46	857518.0
2014-10-08	BAR	ETF	3.098	3.136	2.9931	3.136	259960.0
2014-10-08	BBH	ETF	102.51	105.73	102.13	105.59	72000.0
2014-10-08	BCM	ETF	36.468	36.581	36.44	36.581	5196.0
2014-10-08	BFOR	ETF	7.3625	7.49	7.2875	7.4875	83200.0
2014-10-08	BIB	ETF	49.43	52.25	48.5406	52.175	440840.0
2014-10-08	BICK	ETF	24.7499	25.21	24.7499	25.21	719.0
2014-10-08	BIL	ETF	91.5	91.5	91.48	91.5	147550.0
2014-10-08	BIS	ETF	503.2	513.2	474.0	475.6	18221.0
2014-10-08	BIV	ETF	85.0	85.29	84.73	85.27	310500.0

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

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