PREVIEW / etf_daily / 2016-07-11

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-11.parquet
  size:    52 KB
  rows:    1,299

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
2016-07-11	SPY	ETF	213.19	214.07	212.95	213.4	73633900.0
2016-07-11	QQQ	ETF	110.68	111.335	110.66	110.93	20218504.0
2016-07-11	IWM	ETF	117.56	118.43	117.47	118.14	26987300.0
2016-07-11	DIA	ETF	181.86	182.72	181.78	182.12	2358700.0
2016-07-11	GLD	ETF	129.49	129.9	129.16	129.29	10855600.0
2016-07-11	TLT	ETF	143.05	143.47	142.24	142.34	8099000.0
2016-07-11	AADR	ETF	39.49	39.74	39.28	39.28	2500.0
2016-07-11	AAXJ	ETF	55.25	55.7	55.25	55.49	1550000.0
2016-07-11	ACTX	ETF	4.13	4.72	3.54	4.72	1475.0
2016-07-11	ACWI	ETF	56.87	57.08	56.81	56.95	1674200.0
2016-07-11	ACWV	ETF	77.62	77.75	77.38	77.6	136400.0
2016-07-11	ACWX	ETF	39.16	39.4099	39.16	39.29	386813.0
2016-07-11	ADRE	ETF	31.56	32.046	31.56	32.0034	17766.0
2016-07-11	AFK	ETF	20.28	20.7699	20.1699	20.5101	38191.0
2016-07-11	AFTY	ETF	12.81	12.829	12.809	12.829	3200.0
2016-07-11	AGG	ETF	113.19	113.24	112.93	112.95	4424000.0
2016-07-11	AGGY	ETF	52.24	52.26	52.184	52.184	118000.0
2016-07-11	AGNG	ETF	15.41	15.41	15.41	15.41	100.0
2016-07-11	AGQ	ETF	54.9	56.15	54.8	55.15	508300.0
2016-07-11	AGZ	ETF	115.8352	115.87	115.58	115.72	43464.0
2016-07-11	AGZD	ETF	23.575	23.945	23.575	23.945	1000.0
2016-07-11	AIA	ETF	45.2101	45.31	45.06	45.21	567137.0
2016-07-11	AIQ	ETF	5.99	6.18	5.9711	6.07	17568.0
2016-07-11	AIRR	ETF	19.1	19.22	19.1	19.21	9800.0
2016-07-11	AIVI	ETF	37.98	38.14	37.96	37.98	43700.0
2016-07-11	ALTY	ETF	16.58	16.58	15.11	15.259	2800.0
2016-07-11	AMJ	ETF	31.66	32.0	31.42	31.45	1045509.0
2016-07-11	AMLP	ETF	64.25	64.25	63.45	63.55	1721860.0
2016-07-11	AMZA	ETF	109.6	110.0	108.0	108.4	23560.0
2016-07-11	ANGL	ETF	28.05	28.11	27.97	28.02	270600.0
2016-07-11	AOA	ETF	46.0	46.2	46.0	46.12	25200.0
2016-07-11	AOK	ETF	33.09	33.14	33.03	33.05	68240.0
2016-07-11	AOM	ETF	35.59	35.65	35.4701	35.51	77278.0
2016-07-11	AOR	ETF	40.28	40.28	40.071	40.22	129086.0
2016-07-11	ARGT	ETF	22.6	22.75	22.5	22.67	92400.0
2016-07-11	ARKG	ETF	17.84	17.928	17.84	17.928	800.0
2016-07-11	ARKK	ETF	20.18	20.203	20.11	20.11	2200.0
2016-07-11	ARKQ	ETF	19.98	20.037	19.96	19.96	1000.0
2016-07-11	ARKW	ETF	23.0	23.305	23.0	23.28	3000.0
2016-07-11	ASEA	ETF	13.8	13.81	13.8	13.81	400.0
2016-07-11	ASHR	ETF	24.02	24.08	23.98	24.08	1011200.0
2016-07-11	ASHS	ETF	34.51	34.78	34.51	34.66	10000.0
2016-07-11	ASHX	ETF	22.07	22.07	22.07	22.07	365.0
2016-07-11	ATMP	ETF	22.18	22.26	21.99	22.03	7900.0
2016-07-11	BAB	ETF	31.86	31.9199	31.75	31.8	221174.0
2016-07-11	BAL	ETF	44.265	45.0	44.235	44.98	16507.0
2016-07-11	BBC	ETF	19.27	19.42	19.12	19.12	21771.0
2016-07-11	BBH	ETF	108.4	109.0	107.93	107.98	51700.0
2016-07-11	BBP	ETF	28.81	28.96	28.7	28.7	3900.0
2016-07-11	BCM	ETF	26.96	26.96	26.6801	26.688	46072.0

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

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