PREVIEW / etf_daily / 2015-01-30

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-30.parquet
  size:    47 KB
  rows:    1,162

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-01-30	SPY	ETF	200.57	202.17	199.13	199.45	197729700.0
2015-01-30	QQQ	ETF	101.8	102.58	100.96	101.1	42927638.0
2015-01-30	IWM	ETF	117.48	117.96	115.6	115.7	49739800.0
2015-01-30	DIA	ETF	173.2	173.95	171.27	171.45	11138500.0
2015-01-30	GLD	ETF	121.3	123.55	120.92	123.45	14555900.0
2015-01-30	TLT	ETF	137.71	138.5	137.18	138.28	14871200.0
2015-01-30	AADR	ETF	36.41	36.56	36.41	36.49	900.0
2015-01-30	AAXJ	ETF	62.44	62.54	61.87	61.91	1800700.0
2015-01-30	ACWI	ETF	57.92	58.36	57.64	57.73	4620400.0
2015-01-30	ACWV	ETF	70.25	70.53	69.75	69.75	370500.0
2015-01-30	ACWX	ETF	43.02	43.27	42.84	42.87	856512.0
2015-01-30	ADRE	ETF	35.4	35.5206	35.22	35.22	23720.0
2015-01-30	AFK	ETF	25.03	25.25	24.92	25.11	8238.0
2015-01-30	AGG	ETF	112.35	112.52	112.24	112.38	6252800.0
2015-01-30	AGQ	ETF	43.54	45.73	43.16	45.47	393400.0
2015-01-30	AGZ	ETF	115.08	115.4999	114.722	115.16	89229.0
2015-01-30	AGZD	ETF	24.575	24.575	24.415	24.415	8800.0
2015-01-30	AIA	ETF	48.18	48.241	47.83	47.88	55578.0
2015-01-30	AIQ	ETF	23.55	24.24	22.53	22.54	23782.0
2015-01-30	AIRR	ETF	16.93	16.93	16.64	16.683	40500.0
2015-01-30	AIVI	ETF	43.57	43.77	43.35	43.39	19200.0
2015-01-30	ALTL	ETF	37.76	37.76	37.76	37.76	500.0
2015-01-30	AMJ	ETF	44.11	45.089	43.6	44.4	1503574.0
2015-01-30	AMLP	ETF	84.35	86.3	84.2	85.5	1378320.0
2015-01-30	AMZA	ETF	211.0	211.0	210.2	210.2	130.0
2015-01-30	ANGL	ETF	26.74	26.74	26.66	26.67	3700.0
2015-01-30	AOA	ETF	46.25	46.38	45.94	45.96	46800.0
2015-01-30	AOK	ETF	32.83	32.83	32.71	32.72	15936.0
2015-01-30	AOM	ETF	35.28	35.3277	35.13	35.16	42601.0
2015-01-30	AOR	ETF	40.04	40.2198	39.914	39.94	55276.0
2015-01-30	ARGT	ETF	18.24	18.35	18.11	18.29	34300.0
2015-01-30	ARKG	ETF	23.0	23.0	22.45	22.52	3400.0
2015-01-30	ARKK	ETF	20.42	20.42	20.24	20.24	1900.0
2015-01-30	ARKQ	ETF	19.13	19.13	18.99	19.06	900.0
2015-01-30	ARKW	ETF	20.48	20.48	20.45	20.47	500.0
2015-01-30	ASEA	ETF	15.5	15.53	15.41	15.41	10400.0
2015-01-30	ASHR	ETF	35.0	35.0	33.85	33.9	3023400.0
2015-01-30	ASHS	ETF	36.7	36.7	36.04	36.04	12000.0
2015-01-30	ATMP	ETF	29.29	29.84	28.9	29.47	27500.0
2015-01-30	AVIV	ETF	39.97	40.029	39.33	39.33	185422.0
2015-01-30	AWAY	ETF	25.72	26.05	25.32	25.49	1908167.0
2015-01-30	BAB	ETF	31.39	31.4248	31.1852	31.3601	144462.0
2015-01-30	BAL	ETF	40.46	40.5	40.4	40.5	1467.0
2015-01-30	BALT	ETF	1.48	1.679	1.48	1.62	1056961.0
2015-01-30	BAR	ETF	3.443	3.456	3.4324	3.456	7900.0
2015-01-30	BBC	ETF	29.69	29.69	28.79	28.79	14823.0
2015-01-30	BBH	ETF	123.6	125.95	122.97	123.01	195500.0
2015-01-30	BBP	ETF	28.6	28.6	28.0	28.0	4800.0
2015-01-30	BCM	ETF	31.64	31.64	30.19	30.99	549.0
2015-01-30	BFOR	ETF	7.7175	7.745	7.5675	7.6575	75200.0

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

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