PREVIEW / etf_daily / 2015-09-11

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-11.parquet
  size:    48 KB
  rows:    1,188

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-09-11	SPY	ETF	195.38	196.82	194.53	196.74	119691200.0
2015-09-11	QQQ	ETF	104.51	105.57	104.21	105.57	29106088.0
2015-09-11	IWM	ETF	114.16	115.2	113.66	115.18	27949400.0
2015-09-11	DIA	ETF	162.9	164.44	162.51	164.39	6202300.0
2015-09-11	GLD	ETF	105.65	106.2	105.27	106.16	4023900.0
2015-09-11	TLT	ETF	121.47	122.08	121.33	121.39	5890900.0
2015-09-11	AADR	ETF	36.68	36.71	36.33	36.5	3000.0
2015-09-11	AAXJ	ETF	53.22	53.73	53.22	53.71	524200.0
2015-09-11	ACTX	ETF	2.95	2.95	2.36	2.36	1237.0
2015-09-11	ACWF	ETF	22.82	22.9801	22.82	22.9801	2050.0
2015-09-11	ACWI	ETF	55.08	55.42	54.87	55.42	1213000.0
2015-09-11	ACWV	ETF	66.66	67.23	66.61	67.22	117000.0
2015-09-11	ACWX	ETF	40.08	40.32	40.01	40.32	788543.0
2015-09-11	ADRE	ETF	29.06	29.12	28.91	29.05	7794.0
2015-09-11	AFK	ETF	20.1	20.1	19.9001	19.9001	11757.0
2015-09-11	AFTY	ETF	15.26	15.48	15.21	15.43	9500.0
2015-09-11	AGG	ETF	109.05	109.17	109.01	109.06	2001600.0
2015-09-11	AGQ	ETF	30.3	31.13	29.65	31.07	224700.0
2015-09-11	AGZ	ETF	113.48	113.55	113.3403	113.54	21114.0
2015-09-11	AIA	ETF	42.21	42.58	42.17	42.58	27357.0
2015-09-11	AIQ	ETF	15.15	15.18	14.88	15.12	10887.0
2015-09-11	AIRR	ETF	16.27	16.39	16.17	16.39	62200.0
2015-09-11	AIVI	ETF	39.59	39.79	39.53	39.79	24200.0
2015-09-11	ALTY	ETF	14.18	14.18	14.18	14.18	500.0
2015-09-11	AMJ	ETF	34.21	34.21	33.38	33.51	2861494.0
2015-09-11	AMLP	ETF	70.15	70.15	69.05	69.35	1344120.0
2015-09-11	AMZA	ETF	160.6	161.6	153.6	154.1	2250.0
2015-09-11	ANGL	ETF	26.4	26.58	26.4	26.58	8000.0
2015-09-11	AOA	ETF	44.39	44.56	44.17	44.53	26600.0
2015-09-11	AOK	ETF	31.62	31.7199	31.62	31.66	7730.0
2015-09-11	AOM	ETF	34.07	34.18	34.02	34.18	39179.0
2015-09-11	AOR	ETF	38.62	38.7	38.486	38.6725	37874.0
2015-09-11	ARGT	ETF	17.73	17.89	17.72	17.89	2300.0
2015-09-11	ARKG	ETF	21.4	21.65	21.4	21.65	900.0
2015-09-11	ARKK	ETF	20.11	20.11	20.11	20.11	200.0
2015-09-11	ARKQ	ETF	18.1	18.1	18.0	18.025	3100.0
2015-09-11	ASEA	ETF	12.5	12.5	12.46	12.46	800.0
2015-09-11	ASHR	ETF	32.91	33.48	32.82	33.33	1688800.0
2015-09-11	ASHS	ETF	38.03	38.12	37.36	37.89	43200.0
2015-09-11	ATMP	ETF	22.96	22.96	22.68	22.71	204700.0
2015-09-11	AWAY	ETF	28.74	28.92	28.32	28.48	850841.0
2015-09-11	BAB	ETF	28.79	28.86	28.675	28.83	109190.0
2015-09-11	BAL	ETF	42.02	42.8	41.41	42.13	5946.0
2015-09-11	BBC	ETF	32.6499	33.39	32.52	33.37	4771.0
2015-09-11	BBH	ETF	129.45	131.9	129.12	131.9	66500.0
2015-09-11	BBP	ETF	33.04	33.63	32.818	33.63	2600.0
2015-09-11	BCM	ETF	26.766	27.007	26.766	27.007	3528.0
2015-09-11	BFOR	ETF	7.6875	7.72	7.65	7.72	42400.0
2015-09-11	BIB	ETF	78.94	81.48	78.1	81.48	402313.0
2015-09-11	BICK	ETF	19.3236	19.45	19.191	19.3	2428.0

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

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