PREVIEW / etf_daily / 2015-05-06

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-06.parquet
  size:    48 KB
  rows:    1,186

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-05-06	SPY	ETF	209.56	209.93	206.76	208.04	135060200.0
2015-05-06	QQQ	ETF	107.64	107.95	105.995	106.71	42687150.0
2015-05-06	IWM	ETF	121.11	121.49	120.24	121.27	34348300.0
2015-05-06	DIA	ETF	179.87	180.25	177.25	178.39	7534200.0
2015-05-06	GLD	ETF	114.59	114.75	114.02	114.36	3280700.0
2015-05-06	TLT	ETF	121.99	122.06	120.37	120.56	14355000.0
2015-05-06	AAXJ	ETF	67.76	67.9	67.01	67.14	1473500.0
2015-05-06	ACTX	ETF	2.95	3.54	2.36	3.245	4152.0
2015-05-06	ACWF	ETF	24.86	24.86	24.86	24.86	3000.0
2015-05-06	ACWI	ETF	61.93	62.01	61.21	61.48	1785400.0
2015-05-06	ACWV	ETF	72.98	73.11	72.32	72.59	122100.0
2015-05-06	ACWX	ETF	46.89	46.89	46.41	46.58	186418.0
2015-05-06	ADRE	ETF	37.73	37.73	37.11	37.145	4282.0
2015-05-06	AFK	ETF	26.86	26.91	26.67	26.81	24491.0
2015-05-06	AFTY	ETF	22.08	22.15	21.82	21.89	26200.0
2015-05-06	AGG	ETF	109.95	109.97	109.61	109.66	1566000.0
2015-05-06	AGQ	ETF	41.34	41.42	40.42	40.64	110900.0
2015-05-06	AGZ	ETF	113.11	113.22	113.03	113.05	15668.0
2015-05-06	AGZD	ETF	24.525	24.54	24.52	24.53	14800.0
2015-05-06	AIA	ETF	53.56	53.57	52.935	52.96	33724.0
2015-05-06	AIQ	ETF	20.84	20.85	20.51	20.55	17781.0
2015-05-06	AIRR	ETF	18.293	18.293	18.09	18.22	22800.0
2015-05-06	AIVI	ETF	46.06	46.07	45.67	45.78	31900.0
2015-05-06	AMJ	ETF	45.54	45.605	44.73	44.98	941538.0
2015-05-06	AMLP	ETF	86.65	86.75	85.2	85.4	917760.0
2015-05-06	AMZA	ETF	222.4	222.9	220.3	220.9	730.0
2015-05-06	ANGL	ETF	27.67	27.67	27.51	27.65	14400.0
2015-05-06	AOA	ETF	48.13	48.36	47.81	47.93	40700.0
2015-05-06	AOK	ETF	32.9699	32.9699	32.7	32.78	27993.0
2015-05-06	AOM	ETF	35.81	35.81	35.5	35.58	115650.0
2015-05-06	AOR	ETF	41.28	41.28	40.9087	40.97	37735.0
2015-05-06	ARGT	ETF	22.39	22.41	22.18	22.18	6900.0
2015-05-06	ARKG	ETF	22.49	22.685	22.49	22.67	3500.0
2015-05-06	ARKK	ETF	20.611	20.64	20.611	20.64	1300.0
2015-05-06	ARKQ	ETF	19.5	19.5	19.5	19.5	700.0
2015-05-06	ARKW	ETF	22.3	22.38	22.02	22.128	1800.0
2015-05-06	ASEA	ETF	16.02	16.02	15.95	15.98	3000.0
2015-05-06	ASHR	ETF	46.9	46.91	46.05	46.19	1644400.0
2015-05-06	ASHS	ETF	53.0	53.0	52.07	52.22	90000.0
2015-05-06	ATMP	ETF	30.7	30.7	29.95	30.12	30900.0
2015-05-06	AWAY	ETF	27.16	27.23	26.79	26.95	1158556.0
2015-05-06	BAB	ETF	29.56	29.56	29.111	29.14	373467.0
2015-05-06	BAL	ETF	44.96	44.98	44.5901	44.82	10131.0
2015-05-06	BALT	ETF	1.4	1.42	1.4	1.41	410037.0
2015-05-06	BAR	ETF	2.694	2.695	2.694	2.695	4120.0
2015-05-06	BBC	ETF	30.78	31.75	30.78	31.59	9859.0
2015-05-06	BBH	ETF	127.28	127.54	125.38	126.88	63200.0
2015-05-06	BBP	ETF	29.91	30.47	29.61	30.32	20500.0
2015-05-06	BCHP	ETF	20.4101	20.55	20.4101	20.55	16049.0
2015-05-06	BCM	ETF	33.07	33.07	32.69	32.724	15961.0

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

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