PREVIEW / etf_daily / 2015-12-11

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-11.parquet
  size:    50 KB
  rows:    1,237

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-12-11	SPY	ETF	203.35	204.14	201.51	201.88	211173300.0
2015-12-11	QQQ	ETF	112.09	112.39	110.72	110.79	56022221.0
2015-12-11	IWM	ETF	113.27	113.34	111.53	111.91	52609300.0
2015-12-11	DIA	ETF	173.65	174.38	172.45	172.73	8895600.0
2015-12-11	GLD	ETF	101.91	103.32	101.85	103.11	6798400.0
2015-12-11	TLT	ETF	123.03	124.1	122.87	123.76	12300000.0
2015-12-11	AAXJ	ETF	52.85	52.93	52.51	52.56	998600.0
2015-12-11	ACTX	ETF	5.9001	7.6701	5.9001	7.6701	876.0
2015-12-11	ACWF	ETF	23.17	23.17	23.08	23.13	1801.0
2015-12-11	ACWI	ETF	55.83	55.97	55.35	55.42	3207400.0
2015-12-11	ACWV	ETF	68.63	69.06	68.5	68.59	149200.0
2015-12-11	ACWX	ETF	39.3	39.4	39.0464	39.1	2002584.0
2015-12-11	ADRE	ETF	29.53	29.53	28.95	28.95	12199.0
2015-12-11	AFK	ETF	17.81	17.81	17.535	17.68	89163.0
2015-12-11	AFTY	ETF	16.04	16.06	15.89	15.94	25000.0
2015-12-11	AGG	ETF	108.7	108.86	108.57	108.69	2321400.0
2015-12-11	AGGY	ETF	49.34	49.49	49.34	49.49	6500.0
2015-12-11	AGQ	ETF	27.18	27.79	27.12	27.69	184600.0
2015-12-11	AGZ	ETF	113.15	113.34	112.97	113.3	24032.0
2015-12-11	AGZD	ETF	24.035	24.035	23.91	23.935	2800.0
2015-12-11	AIA	ETF	42.52	42.568	42.23	42.279	20345.0
2015-12-11	AIQ	ETF	8.67	8.67	8.23	8.36	16901.0
2015-12-11	AIRR	ETF	16.71	16.71	16.54	16.54	2000.0
2015-12-11	AIVI	ETF	37.83	37.84	37.55	37.55	100900.0
2015-12-11	AMJ	ETF	26.64	26.64	25.2	25.4	8218705.0
2015-12-11	AMLP	ETF	53.6	54.05	51.0	51.5	4811680.0
2015-12-11	AMZA	ETF	100.0	100.0	92.9	93.5	2390.0
2015-12-11	ANGL	ETF	24.66	24.79	24.03	24.16	73800.0
2015-12-11	AOA	ETF	44.89	44.89	44.5	44.57	304900.0
2015-12-11	AOK	ETF	31.71	31.791	31.66	31.67	120218.0
2015-12-11	AOM	ETF	34.31	34.31	34.1101	34.14	431587.0
2015-12-11	AOR	ETF	38.85	38.95	38.7	38.73	838555.0
2015-12-11	ARGT	ETF	17.76	17.77	17.46	17.51	17300.0
2015-12-11	ARKG	ETF	20.0	20.0	19.48	19.499	4600.0
2015-12-11	ARKK	ETF	21.06	21.06	20.92	20.92	400.0
2015-12-11	ARKQ	ETF	19.55	19.55	19.08	19.08	3500.0
2015-12-11	ARKW	ETF	23.89	23.89	23.24	23.24	3300.0
2015-12-11	ASEA	ETF	12.33	12.33	12.2	12.2	2700.0
2015-12-11	ASHR	ETF	35.1	35.3	34.82	34.91	2038700.0
2015-12-11	ASHS	ETF	43.58	43.58	43.0	43.05	51600.0
2015-12-11	ATMP	ETF	18.29	18.29	16.59	16.77	299500.0
2015-12-11	AWAY	ETF	35.79	36.0203	35.46	35.56	5253661.0
2015-12-11	BAB	ETF	29.38	29.49	29.2899	29.46	139636.0
2015-12-11	BAL	ETF	42.4	42.44	42.4	42.44	740.0
2015-12-11	BBC	ETF	28.58	28.58	27.98	27.98	16439.0
2015-12-11	BBH	ETF	121.78	122.84	119.92	119.95	65300.0
2015-12-11	BBP	ETF	29.67	29.708	29.26	29.26	23900.0
2015-12-11	BCM	ETF	24.05	24.05	23.91	23.91	15236.0
2015-12-11	BFOR	ETF	7.585	7.6025	7.5	7.52	86400.0
2015-12-11	BIB	ETF	66.49	67.38	63.83	63.97	637668.0

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

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