PREVIEW / etf_daily / 2016-10-03

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-03.parquet
  size:    52 KB
  rows:    1,308

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-10-03	SPY	ETF	215.82	216.04	215.04	215.78	83512100.0
2016-10-03	QQQ	ETF	118.53	118.7	118.09	118.55	19216438.0
2016-10-03	IWM	ETF	123.83	124.1	123.13	123.82	18674300.0
2016-10-03	DIA	ETF	182.31	182.57	181.78	182.32	1987600.0
2016-10-03	GLD	ETF	125.32	125.46	124.9	125.32	9044100.0
2016-10-03	TLT	ETF	137.68	137.77	136.76	136.81	7588800.0
2016-10-03	AAXJ	ETF	60.42	60.86	60.37	60.84	1464500.0
2016-10-03	ACTX	ETF	4.72	4.72	4.72	4.72	129.0
2016-10-03	ACWI	ETF	58.97	59.08	58.83	58.98	2640000.0
2016-10-03	ACWV	ETF	76.13	76.13	75.7	75.91	536300.0
2016-10-03	ACWX	ETF	41.41	41.48	41.31	41.45	144102.0
2016-10-03	ADRE	ETF	34.89	35.0	34.8	35.0	6504.0
2016-10-03	AFK	ETF	20.75	20.7858	20.29	20.78	4902.0
2016-10-03	AFTY	ETF	13.453	13.49	13.453	13.49	1100.0
2016-10-03	AGG	ETF	112.21	112.25	112.07	112.09	9372900.0
2016-10-03	AGGY	ETF	51.9	51.959	51.79	51.91	55500.0
2016-10-03	AGQ	ETF	47.52	47.52	45.75	46.34	258100.0
2016-10-03	AGZ	ETF	115.61	115.61	115.435	115.49	16383.0
2016-10-03	AIA	ETF	49.83	50.2299	49.79	50.21	92481.0
2016-10-03	AIQ	ETF	6.9	7.06	6.845	7.03	22440.0
2016-10-03	AIRR	ETF	20.5	20.5	20.32	20.447	12400.0
2016-10-03	AIVI	ETF	38.75	38.82	38.66	38.75	9600.0
2016-10-03	ALTY	ETF	15.555	15.555	15.378	15.49	7500.0
2016-10-03	AMJ	ETF	31.44	31.74	31.14	31.23	1521497.0
2016-10-03	AMLP	ETF	63.55	63.75	62.9	63.1	1010520.0
2016-10-03	AMZA	ETF	115.4	116.3	113.9	114.1	34560.0
2016-10-03	ANGL	ETF	28.78	28.83	28.71	28.81	201100.0
2016-10-03	AOA	ETF	47.48	47.49	47.29	47.42	13600.0
2016-10-03	AOK	ETF	33.51	33.51	33.26	33.33	46248.0
2016-10-03	AOM	ETF	35.95	36.0499	35.8985	35.99	62716.0
2016-10-03	AOR	ETF	41.0	41.07	40.9101	41.07	52362.0
2016-10-03	ARGT	ETF	23.95	24.04	23.88	24.03	137900.0
2016-10-03	ARKG	ETF	19.67	19.88	19.67	19.742	3700.0
2016-10-03	ARKK	ETF	22.21	22.21	22.21	22.21	300.0
2016-10-03	ARKQ	ETF	23.03	23.03	22.314	22.32	1700.0
2016-10-03	ARKW	ETF	25.53	25.78	24.51	25.78	4200.0
2016-10-03	ASEA	ETF	13.95	14.08	13.95	14.08	500.0
2016-10-03	ASHR	ETF	24.58	24.6	24.42	24.55	452800.0
2016-10-03	ASHS	ETF	34.62	34.63	34.54	34.6	2700.0
2016-10-03	ATMP	ETF	23.36	23.36	23.14	23.16	8500.0
2016-10-03	BAB	ETF	31.38	31.39	31.22	31.23	92196.0
2016-10-03	BAL	ETF	44.81	45.497	44.81	45.31	3763.0
2016-10-03	BBC	ETF	22.38	22.51	22.3494	22.51	1688.0
2016-10-03	BBH	ETF	115.07	115.14	113.69	115.1	45400.0
2016-10-03	BBP	ETF	33.02	33.212	33.02	33.16	1400.0
2016-10-03	BFIT	ETF	15.81	15.81	15.81	15.81	167.0
2016-10-03	BFOR	ETF	8.0575	8.0575	8.0325	8.045	33200.0
2016-10-03	BIB	ETF	48.26	48.72	47.11	48.72	315506.0
2016-10-03	BICK	ETF	23.0744	23.1	22.99	23.1	2540.0
2016-10-03	BIL	ETF	91.46	91.46	91.44	91.44	231800.0

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

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