PREVIEW / etf_daily / 2015-09-09

all etf daily files

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

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-09	SPY	ETF	199.32	199.47	194.35	194.79	149347700.0
2015-09-09	QQQ	ETF	106.28	106.31	103.59	103.86	47146743.0
2015-09-09	IWM	ETF	116.17	116.42	114.01	114.12	40963000.0
2015-09-09	DIA	ETF	166.53	166.71	162.23	162.52	7865700.0
2015-09-09	GLD	ETF	106.64	106.71	105.48	106.13	8855100.0
2015-09-09	TLT	ETF	119.63	121.71	119.56	121.45	7441900.0
2015-09-09	AADR	ETF	36.3	36.53	36.29	36.53	800.0
2015-09-09	AAXJ	ETF	54.0	54.2	53.12	53.17	1185500.0
2015-09-09	ACTX	ETF	2.36	2.36	2.065	2.36	451.0
2015-09-09	ACWI	ETF	56.06	56.24	54.87	54.94	2794000.0
2015-09-09	ACWV	ETF	67.94	68.0	66.58	66.66	187800.0
2015-09-09	ACWX	ETF	40.82	40.895	40.06	40.09	631167.0
2015-09-09	ADRE	ETF	29.75	30.0	29.36	29.47	11326.0
2015-09-09	AFK	ETF	20.39	20.39	19.94	19.96	50616.0
2015-09-09	AFTY	ETF	15.28	15.34	14.93	15.15	121800.0
2015-09-09	AGG	ETF	108.78	109.08	108.7	109.05	2891400.0
2015-09-09	AGQ	ETF	31.24	31.59	30.9	30.98	107500.0
2015-09-09	AGZ	ETF	113.43	113.54	113.0501	113.4101	18452.0
2015-09-09	AGZD	ETF	24.08	24.08	24.065	24.07	3400.0
2015-09-09	AIA	ETF	43.19	43.33	42.53	42.53	42758.0
2015-09-09	AIQ	ETF	14.88	15.32	14.74	14.99	25444.0
2015-09-09	AIRR	ETF	16.56	16.69	16.52	16.54	11500.0
2015-09-09	AIVI	ETF	40.39	40.39	39.61	39.61	20800.0
2015-09-09	ALTY	ETF	14.35	14.35	14.32	14.32	200.0
2015-09-09	AMJ	ETF	35.22	35.39	34.51	34.55	1161777.0
2015-09-09	AMLP	ETF	71.95	72.1	70.7	70.8	1167820.0
2015-09-09	AMZA	ETF	165.0	167.0	161.4	161.9	3600.0
2015-09-09	ANGL	ETF	26.51	26.51	26.44	26.47	15600.0
2015-09-09	AOA	ETF	45.0	45.0	44.17	44.18	55600.0
2015-09-09	AOK	ETF	31.72	31.79	31.6	31.61	21465.0
2015-09-09	AOM	ETF	34.19	34.2668	34.02	34.02	36749.0
2015-09-09	AOR	ETF	38.99	38.99	38.495	38.58	55231.0
2015-09-09	ARGT	ETF	18.18	18.28	17.83	17.91	18100.0
2015-09-09	ARKG	ETF	21.33	21.33	21.33	21.33	400.0
2015-09-09	ARKK	ETF	20.42	20.42	20.09	20.09	1800.0
2015-09-09	ARKQ	ETF	18.21	18.21	18.21	18.21	100.0
2015-09-09	ARKW	ETF	22.19	22.19	21.94	21.95	1200.0
2015-09-09	ASEA	ETF	12.62	12.62	12.47	12.47	2500.0
2015-09-09	ASHR	ETF	33.43	33.49	32.5	32.51	3962700.0
2015-09-09	ASHS	ETF	37.56	37.56	36.5	36.66	37700.0
2015-09-09	ATMP	ETF	24.05	24.05	23.48	23.48	11900.0
2015-09-09	AWAY	ETF	28.72	28.99	28.2	28.26	707623.0
2015-09-09	BAB	ETF	28.81	28.9362	28.71	28.8	153681.0
2015-09-09	BAL	ETF	42.3	42.4426	42.08	42.08	1835.0
2015-09-09	BBC	ETF	33.1	33.1	31.66	31.7	5339.0
2015-09-09	BBH	ETF	130.9	131.75	127.13	127.53	242400.0
2015-09-09	BBP	ETF	33.72	33.72	32.45	32.45	27900.0
2015-09-09	BCM	ETF	26.982	26.99	26.802	26.802	8641.0
2015-09-09	BFOR	ETF	7.81	7.835	7.6825	7.685	54000.0
2015-09-09	BIB	ETF	81.99	82.27	76.21	76.8	1198352.0

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

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