PREVIEW / etf_daily / 2015-07-17

all etf daily files

  file:    by_date/etf_daily/2015/2015-07-17.parquet
  size:    48 KB
  rows:    1,197

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-07-17	SPY	ETF	212.29	212.55	211.8	212.48	89030000.0
2015-07-17	QQQ	ETF	112.84	113.59	112.65	113.59	35926804.0
2015-07-17	IWM	ETF	126.31	126.38	125.36	125.76	24739900.0
2015-07-17	DIA	ETF	180.49	180.62	180.01	180.54	2762300.0
2015-07-17	GLD	ETF	109.11	109.16	108.4	108.65	14858300.0
2015-07-17	TLT	ETF	118.37	118.89	118.36	118.72	7404900.0
2015-07-17	AADR	ETF	39.61	39.61	39.61	39.61	100.0
2015-07-17	AAXJ	ETF	61.85	61.85	61.52	61.62	427500.0
2015-07-17	ACTX	ETF	1.18	1.77	1.18	1.77	1218.0
2015-07-17	ACWF	ETF	24.82	24.82	24.82	24.82	230.0
2015-07-17	ACWI	ETF	60.95	60.95	60.66	60.79	731000.0
2015-07-17	ACWV	ETF	71.41	71.41	71.11	71.19	161300.0
2015-07-17	ACWX	ETF	44.8	44.89	44.72	44.77	188011.0
2015-07-17	ADRE	ETF	34.3	34.3	34.16	34.22	4900.0
2015-07-17	AFK	ETF	23.58	23.632	23.39	23.39	22201.0
2015-07-17	AFTY	ETF	20.81	20.81	20.46	20.65	54900.0
2015-07-17	AGG	ETF	108.73	108.86	108.72	108.79	897600.0
2015-07-17	AGQ	ETF	32.85	32.89	32.42	32.67	140800.0
2015-07-17	AGZ	ETF	113.2	113.36	113.0668	113.29	10913.0
2015-07-17	AGZD	ETF	24.345	24.425	24.345	24.375	13600.0
2015-07-17	AIA	ETF	49.01	49.06	48.91	49.06	15845.0
2015-07-17	AIQ	ETF	16.92	17.2	16.58	16.77	35440.0
2015-07-17	AIRR	ETF	17.937	18.0	17.92	17.98	9600.0
2015-07-17	AIVI	ETF	43.65	43.65	43.47	43.53	29700.0
2015-07-17	ALTY	ETF	15.38	15.38	15.13	15.16	10100.0
2015-07-17	AMJ	ETF	39.34	39.39	38.67	38.83	2612395.0
2015-07-17	AMLP	ETF	77.85	78.05	77.05	77.35	971160.0
2015-07-17	AMZA	ETF	190.2	194.2	185.7	187.4	1860.0
2015-07-17	ANGL	ETF	27.04	27.12	27.04	27.12	15000.0
2015-07-17	AOA	ETF	47.76	47.78	47.67	47.78	41700.0
2015-07-17	AOK	ETF	32.55	32.5599	32.45	32.5599	15978.0
2015-07-17	AOM	ETF	35.19	35.34	35.19	35.34	39660.0
2015-07-17	AOR	ETF	40.77	40.88	40.657	40.7304	65757.0
2015-07-17	ARGT	ETF	20.09	20.09	19.85	20.05	17000.0
2015-07-17	ARKG	ETF	23.85	23.92	23.81	23.92	1400.0
2015-07-17	ARKK	ETF	21.94	21.94	21.92	21.92	400.0
2015-07-17	ARKQ	ETF	19.979	19.979	19.959	19.959	400.0
2015-07-17	ARKW	ETF	23.82	23.98	23.766	23.85	5800.0
2015-07-17	ASEA	ETF	14.94	14.94	14.94	14.94	700.0
2015-07-17	ASHR	ETF	43.37	43.52	43.06	43.46	3270000.0
2015-07-17	ASHS	ETF	51.6	52.0	50.57	50.81	211700.0
2015-07-17	ATMP	ETF	26.64	26.64	26.5	26.58	22000.0
2015-07-17	AWAY	ETF	31.81	32.3	31.6	31.74	793280.0
2015-07-17	BAB	ETF	28.86	28.86	28.612	28.78	75209.0
2015-07-17	BAL	ETF	43.482	43.66	43.47	43.5955	3140.0
2015-07-17	BALT	ETF	1.59	1.65	1.5	1.5	1203167.0
2015-07-17	BBC	ETF	39.5	39.59	38.89	39.55	39137.0
2015-07-17	BBH	ETF	144.47	144.63	142.8	144.61	137800.0
2015-07-17	BBP	ETF	37.63	38.625	36.9	37.31	48800.0
2015-07-17	BCM	ETF	29.66	29.66	29.57	29.65	2364.0

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

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