PREVIEW / etf_daily / 2014-11-28

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-28.parquet
  size:    45 KB
  rows:    1,107

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-11-28	SPY	ETF	207.49	207.87	206.91	207.2	57890100.0
2014-11-28	QQQ	ETF	105.795	106.245	105.73	106.01	17360420.0
2014-11-28	IWM	ETF	118.48	118.52	116.57	116.69	21110700.0
2014-11-28	DIA	ETF	178.12	178.69	177.86	178.1	4037500.0
2014-11-28	GLD	ETF	113.53	113.83	111.95	112.11	9616300.0
2014-11-28	TLT	ETF	122.13	122.67	122.13	122.49	4562200.0
2014-11-28	AAXJ	ETF	63.05	63.08	62.8	62.89	1127500.0
2014-11-28	ACWI	ETF	60.42	60.56	60.32	60.43	775200.0
2014-11-28	ACWV	ETF	69.91	70.26	69.91	70.04	30600.0
2014-11-28	ACWX	ETF	45.53	45.53	45.3	45.34	119246.0
2014-11-28	ADRE	ETF	39.32	39.32	38.95	38.9634	3174.0
2014-11-28	AFK	ETF	29.15	29.15	28.51	28.53	18856.0
2014-11-28	AGG	ETF	110.43	110.62	110.4	110.61	2072800.0
2014-11-28	AGQ	ETF	39.15	39.42	37.06	37.32	355900.0
2014-11-28	AGZ	ETF	113.6	113.6	113.39	113.4	3375.0
2014-11-28	AGZD	ETF	24.715	24.765	24.715	24.765	4000.0
2014-11-28	AIA	ETF	48.35	48.35	48.07	48.07	15907.0
2014-11-28	AIQ	ETF	22.42	22.73	21.69	22.52	13903.0
2014-11-28	AIRR	ETF	19.24	19.24	18.32	18.32	9200.0
2014-11-28	AIVI	ETF	46.08	46.08	46.0	46.03	2400.0
2014-11-28	ALTL	ETF	36.81	36.81	36.81	36.81	400.0
2014-11-28	AMJ	ETF	50.62	50.62	48.423	48.72	1643129.0
2014-11-28	AMLP	ETF	92.55	92.95	90.35	90.5	1134420.0
2014-11-28	AMZA	ETF	243.6	243.6	241.1	241.6	320.0
2014-11-28	ANGL	ETF	27.49	27.49	27.4	27.4	900.0
2014-11-28	AOA	ETF	47.08	47.14	47.04	47.05	12300.0
2014-11-28	AOK	ETF	32.96	32.97	32.93	32.93	13088.0
2014-11-28	AOM	ETF	35.64	35.64	35.54	35.55	18873.0
2014-11-28	AOR	ETF	40.71	40.71	40.5544	40.56	5749.0
2014-11-28	ARGT	ETF	21.14	21.14	20.67	20.76	33900.0
2014-11-28	ARKG	ETF	20.49	20.63	20.49	20.506	1300.0
2014-11-28	ARKK	ETF	20.54	20.65	20.53	20.59	1500.0
2014-11-28	ARKQ	ETF	20.45	20.45	20.438	20.438	400.0
2014-11-28	ARKW	ETF	20.72	20.72	20.709	20.709	1400.0
2014-11-28	ASEA	ETF	16.93	16.93	16.75	16.82	6100.0
2014-11-28	ASHR	ETF	30.27	30.38	30.09	30.3	533800.0
2014-11-28	ASHS	ETF	35.63	35.7	35.54	35.65	72000.0
2014-11-28	ATMP	ETF	33.47	33.47	30.92	31.04	16200.0
2014-11-28	AVIV	ETF	33.38	34.14	33.33	33.7	209753.0
2014-11-28	AWAY	ETF	31.57	31.87	31.02	31.36	426399.0
2014-11-28	BAB	ETF	30.08	30.08	29.97	30.08	37866.0
2014-11-28	BAL	ETF	41.14	41.3201	40.99	40.99	8583.0
2014-11-28	BALT	ETF	3.42	3.44	3.0	3.14	1027267.0
2014-11-28	BAR	ETF	2.825	2.9	2.668	2.668	55920.0
2014-11-28	BBH	ETF	117.0	118.22	116.58	117.09	90900.0
2014-11-28	BCM	ETF	34.3	34.3	34.3	34.3	514.0
2014-11-28	BFOR	ETF	7.9925	8.03	7.9075	7.9075	194800.0
2014-11-28	BIB	ETF	63.665	64.84	63.0589	63.875	395626.0
2014-11-28	BICK	ETF	25.22	25.37	25.22	25.23	840.0
2014-11-28	BIL	ETF	91.48	91.5	91.48	91.5	383200.0

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

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