PREVIEW / etf_daily / 2015-12-16

all etf daily files

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

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-16	SPY	ETF	206.37	208.39	204.8	208.03	197017000.0
2015-12-16	QQQ	ETF	113.07	114.17	111.89	113.98	44944106.0
2015-12-16	IWM	ETF	113.49	114.65	112.83	114.43	44560600.0
2015-12-16	DIA	ETF	176.43	178.0	174.97	177.64	11286600.0
2015-12-16	GLD	ETF	102.59	103.2	101.66	102.75	8292200.0
2015-12-16	TLT	ETF	121.07	122.17	120.5	121.18	10988600.0
2015-12-16	AADR	ETF	38.77	39.09	38.43	38.5	7300.0
2015-12-16	AAXJ	ETF	54.24	55.02	54.07	54.8	1173400.0
2015-12-16	ACTX	ETF	10.0301	10.6201	7.6701	8.2601	5292.0
2015-12-16	ACWF	ETF	23.38	23.39	23.28	23.31	10500.0
2015-12-16	ACWI	ETF	56.61	57.26	56.39	57.15	3872100.0
2015-12-16	ACWV	ETF	69.87	70.51	69.5	70.46	204100.0
2015-12-16	ACWX	ETF	39.98	40.38	39.76	40.3	2926218.0
2015-12-16	ADRE	ETF	29.94	30.32	29.82	30.29	8333.0
2015-12-16	AFK	ETF	17.84	18.14	17.67	18.0799	74918.0
2015-12-16	AFTY	ETF	16.484	16.78	16.415	16.72	46500.0
2015-12-16	AGG	ETF	108.12	108.27	107.93	108.0	2946800.0
2015-12-16	AGQ	ETF	28.28	29.04	27.9	28.43	280500.0
2015-12-16	AGZ	ETF	112.9	113.09	112.62	112.87	33910.0
2015-12-16	AGZD	ETF	23.965	23.995	23.92	23.975	2600.0
2015-12-16	AIA	ETF	43.68	44.02	43.41	43.872	66922.0
2015-12-16	AIQ	ETF	8.36	9.0	8.36	8.965	15954.0
2015-12-16	AIRR	ETF	16.76	16.94	16.71	16.91	7300.0
2015-12-16	AIVI	ETF	38.22	38.56	37.98	38.49	81200.0
2015-12-16	AMJ	ETF	24.91	26.4	24.89	26.03	7929808.0
2015-12-16	AMLP	ETF	51.15	53.55	50.4	53.1	5228920.0
2015-12-16	AMZA	ETF	89.4	97.2	89.4	97.0	3350.0
2015-12-16	ANGL	ETF	24.71	24.71	24.23	24.52	7200.0
2015-12-16	AOA	ETF	45.26	45.6	45.07	45.55	293500.0
2015-12-16	AOK	ETF	31.69	31.88	31.67	31.83	126811.0
2015-12-16	AOM	ETF	34.36	34.4299	34.19	34.34	353666.0
2015-12-16	AOR	ETF	39.16	39.3353	38.9801	39.26	725674.0
2015-12-16	ARGT	ETF	17.81	17.89	17.52	17.87	34200.0
2015-12-16	ARKG	ETF	20.05	20.055	20.05	20.055	300.0
2015-12-16	ARKK	ETF	20.8	20.8	20.78	20.78	1100.0
2015-12-16	ARKQ	ETF	19.355	19.355	19.355	19.355	300.0
2015-12-16	ARKW	ETF	23.58	23.58	23.5	23.5	3900.0
2015-12-16	ASEA	ETF	12.61	12.82	12.6	12.72	2900.0
2015-12-16	ASET	ETF	24.21	24.46	24.21	24.46	21250.0
2015-12-16	ASHR	ETF	28.08	28.49	27.95	28.35	1842100.0
2015-12-16	ASHS	ETF	40.93	42.31	40.93	41.82	137800.0
2015-12-16	ASHX	ETF	25.62	25.62	25.26	25.35	3073.0
2015-12-16	ATMP	ETF	16.87	17.33	16.57	17.09	205300.0
2015-12-16	BAB	ETF	29.02	29.094	28.93	29.04	77953.0
2015-12-16	BAL	ETF	42.06	42.06	42.06	42.06	339.0
2015-12-16	BBC	ETF	28.5505	29.57	28.5505	29.57	5089.0
2015-12-16	BBH	ETF	124.85	126.54	123.87	126.3	58200.0
2015-12-16	BBP	ETF	29.873	30.711	29.873	30.711	8500.0
2015-12-16	BCM	ETF	23.82	23.82	23.6501	23.655	9991.0
2015-12-16	BFOR	ETF	7.61	7.675	7.5825	7.675	21600.0

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

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