PREVIEW / etf_daily / 2015-07-28

all etf daily files

  file:    by_date/etf_daily/2015/2015-07-28.parquet
  size:    49 KB
  rows:    1,203

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
2015-07-28	SPY	ETF	207.79	209.5	206.8	209.33	123544800.0
2015-07-28	QQQ	ETF	110.67	111.35	109.785	111.13	33553494.0
2015-07-28	IWM	ETF	120.92	121.81	119.34	121.6	53474800.0
2015-07-28	DIA	ETF	174.86	176.28	174.3	176.11	5625900.0
2015-07-28	GLD	ETF	105.09	105.33	104.83	105.02	5549200.0
2015-07-28	TLT	ETF	121.16	121.57	120.9	121.15	9128200.0
2015-07-28	AADR	ETF	39.4	39.68	39.4	39.62	1600.0
2015-07-28	AAXJ	ETF	58.9	59.2	58.64	59.14	774000.0
2015-07-28	ACTX	ETF	1.77	1.77	1.18	1.18	2273.0
2015-07-28	ACWI	ETF	59.31	59.58	58.91	59.53	5566200.0
2015-07-28	ACWV	ETF	70.06	70.53	69.87	70.47	46700.0
2015-07-28	ACWX	ETF	43.52	43.68	43.24	43.66	286651.0
2015-07-28	ADRE	ETF	32.27	32.33	31.92	32.33	9636.0
2015-07-28	AFK	ETF	22.48	22.6497	22.26	22.26	22363.0
2015-07-28	AFTY	ETF	18.13	18.72	18.13	18.72	134500.0
2015-07-28	AGG	ETF	109.13	109.22	109.09	109.15	1873200.0
2015-07-28	AGGY	ETF	49.91	49.91	49.91	49.91	500.0
2015-07-28	AGQ	ETF	31.58	31.79	31.52	31.66	74400.0
2015-07-28	AGZ	ETF	113.3	113.32	113.113	113.22	24181.0
2015-07-28	AGZD	ETF	24.32	24.355	24.255	24.355	262400.0
2015-07-28	AIA	ETF	47.36	47.428	47.04	47.35	21671.0
2015-07-28	AIQ	ETF	15.98	16.09	15.47	15.55	43145.0
2015-07-28	AIRR	ETF	16.9	17.11	16.81	17.04	69100.0
2015-07-28	AIVI	ETF	42.45	42.7	42.3	42.69	18900.0
2015-07-28	ALTY	ETF	14.63	14.63	14.63	14.63	300.0
2015-07-28	AMJ	ETF	37.61	38.64	37.46	38.42	2358600.0
2015-07-28	AMLP	ETF	76.0	77.2	75.75	77.05	1210060.0
2015-07-28	AMZA	ETF	181.3	189.5	179.7	185.2	2820.0
2015-07-28	ANGL	ETF	26.94	27.12	26.94	27.08	20600.0
2015-07-28	AOA	ETF	46.75	47.08	46.65	47.08	29300.0
2015-07-28	AOK	ETF	32.3	32.44	32.25	32.43	25603.0
2015-07-28	AOM	ETF	35.05	35.06	34.86	35.01	52395.0
2015-07-28	AOR	ETF	40.27	40.34	40.049	40.33	49662.0
2015-07-28	ARGT	ETF	18.3	18.32	18.27	18.28	2400.0
2015-07-28	ARKG	ETF	22.65	22.74	22.65	22.74	700.0
2015-07-28	ARKK	ETF	21.528	21.97	21.525	21.97	3500.0
2015-07-28	ARKQ	ETF	19.657	19.7	19.654	19.7	300.0
2015-07-28	ARKW	ETF	23.4	23.88	23.4	23.88	1700.0
2015-07-28	ASEA	ETF	14.43	14.49	14.37	14.49	2900.0
2015-07-28	ASHR	ETF	39.43	40.0	39.28	39.94	3647400.0
2015-07-28	ASHS	ETF	47.3	48.41	46.37	48.3	134200.0
2015-07-28	ATMP	ETF	25.58	26.3	25.5	26.18	889200.0
2015-07-28	AWAY	ETF	29.3	29.76	28.96	29.37	1490868.0
2015-07-28	BAB	ETF	29.03	29.1	28.98	29.01	30612.0
2015-07-28	BAL	ETF	42.67	43.45	42.62	43.01	5813.0
2015-07-28	BBC	ETF	36.75	36.93	35.47	36.67	35806.0
2015-07-28	BBH	ETF	137.3	139.32	136.2	139.05	303400.0
2015-07-28	BBP	ETF	35.42	36.55	35.42	36.31	12200.0
2015-07-28	BCHP	ETF	18.81	19.04	18.79	19.04	11513.0
2015-07-28	BCM	ETF	28.206	28.224	28.17	28.224	2157.0

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

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