PREVIEW / etf_daily / 2015-07-31

all etf daily files

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

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-31	SPY	ETF	211.42	211.45	210.16	210.5	103266900.0
2015-07-31	QQQ	ETF	112.43	112.49	111.72	111.95	22081731.0
2015-07-31	IWM	ETF	122.45	123.67	122.22	122.96	31812700.0
2015-07-31	DIA	ETF	177.67	177.73	176.49	176.68	4483800.0
2015-07-31	GLD	ETF	105.41	105.75	104.69	104.93	6689200.0
2015-07-31	TLT	ETF	122.44	122.9	122.06	122.53	9178400.0
2015-07-31	AADR	ETF	40.05	40.05	40.05	40.05	100.0
2015-07-31	AAXJ	ETF	59.46	59.63	59.13	59.27	979400.0
2015-07-31	ACTX	ETF	1.18	1.77	1.18	1.77	448.0
2015-07-31	ACWI	ETF	60.13	60.24	59.85	59.94	994300.0
2015-07-31	ACWV	ETF	71.07	71.35	71.01	71.13	72000.0
2015-07-31	ACWX	ETF	44.14	44.217	43.96	44.08	791870.0
2015-07-31	ADRE	ETF	32.84	32.9893	32.68	32.68	6480.0
2015-07-31	AFK	ETF	22.53	22.54	22.28	22.41	36118.0
2015-07-31	AFTY	ETF	18.13	18.28	18.13	18.25	45200.0
2015-07-31	AGG	ETF	109.44	109.51	109.35	109.5	2084300.0
2015-07-31	AGQ	ETF	32.8	33.02	31.76	31.81	116000.0
2015-07-31	AGZ	ETF	113.37	113.628	113.34	113.52	13897.0
2015-07-31	AGZD	ETF	24.33	24.5	24.31	24.32	23200.0
2015-07-31	AIA	ETF	47.36	47.4599	47.16	47.16	18297.0
2015-07-31	AIQ	ETF	13.97	15.16	13.71	14.96	23371.0
2015-07-31	AIRR	ETF	17.56	17.56	17.29	17.47	55900.0
2015-07-31	AIVI	ETF	43.35	43.4	43.12	43.15	9000.0
2015-07-31	ALTY	ETF	14.87	14.882	14.84	14.882	1900.0
2015-07-31	AMJ	ETF	38.54	38.59	38.28	38.3	1873857.0
2015-07-31	AMLP	ETF	77.4	77.85	77.0	77.05	712840.0
2015-07-31	AMZA	ETF	186.0	191.6	184.0	185.0	2050.0
2015-07-31	ANGL	ETF	27.2	27.2	27.0	27.05	26500.0
2015-07-31	AOA	ETF	47.43	47.53	47.35	47.42	30800.0
2015-07-31	AOK	ETF	32.54	32.6	32.5	32.58	19400.0
2015-07-31	AOM	ETF	35.26	35.31	35.1433	35.28	43470.0
2015-07-31	AOR	ETF	40.65	40.7159	40.51	40.6	25365.0
2015-07-31	ARGT	ETF	18.46	18.47	18.28	18.32	2200.0
2015-07-31	ARKG	ETF	22.79	22.79	22.79	22.79	300.0
2015-07-31	ARKK	ETF	21.63	21.64	21.5	21.5	3400.0
2015-07-31	ARKQ	ETF	19.6	19.6	19.5	19.5	400.0
2015-07-31	ARKW	ETF	23.9	23.9	23.72	23.73	3300.0
2015-07-31	ASEA	ETF	14.6	14.72	14.6	14.64	10800.0
2015-07-31	ASHR	ETF	39.65	39.8	39.42	39.5	1423000.0
2015-07-31	ASHS	ETF	48.01	48.43	48.0	48.39	90700.0
2015-07-31	ATMP	ETF	26.2	26.39	26.2	26.23	36300.0
2015-07-31	AWAY	ETF	29.78	30.16	29.56	30.04	1391641.0
2015-07-31	BAB	ETF	29.17	29.2	29.08	29.12	62982.0
2015-07-31	BAL	ETF	42.88	43.09	42.72	42.72	3651.0
2015-07-31	BBC	ETF	35.858	36.7903	35.5801	36.1718	13280.0
2015-07-31	BBH	ETF	139.5	141.01	139.3	139.92	174000.0
2015-07-31	BBP	ETF	35.84	36.39	35.44	36.06	14300.0
2015-07-31	BCHP	ETF	19.36	19.36	19.25	19.29	803.0
2015-07-31	BCM	ETF	28.06	28.06	27.8023	27.8023	3334.0
2015-07-31	BFOR	ETF	8.2825	8.2925	8.2325	8.235	65200.0

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

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