PREVIEW / etf_daily / 2015-05-04

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-04.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-04	SPY	ETF	211.23	212.02	211.1	211.32	70927200.0
2015-05-04	QQQ	ETF	109.4	109.91	109.17	109.23	23507259.0
2015-05-04	IWM	ETF	122.13	123.35	121.8	122.41	37675100.0
2015-05-04	DIA	ETF	180.34	181.05	180.25	180.44	3256900.0
2015-05-04	GLD	ETF	114.18	114.44	113.88	114.1	3648100.0
2015-05-04	TLT	ETF	124.3	124.53	122.72	122.83	9144700.0
2015-05-04	AADR	ETF	40.4	40.66	40.28	40.42	2200.0
2015-05-04	AAXJ	ETF	68.69	69.18	68.6	69.1	469600.0
2015-05-04	ACTX	ETF	3.54	3.54	1.77	2.95	15243.0
2015-05-04	ACWF	ETF	25.249	25.25	25.249	25.25	200.0
2015-05-04	ACWI	ETF	62.42	62.53	62.31	62.44	629900.0
2015-05-04	ACWV	ETF	73.39	73.7	73.39	73.67	69000.0
2015-05-04	ACWX	ETF	47.23	47.4	47.07	47.25	758444.0
2015-05-04	ADRE	ETF	37.73	37.9156	37.73	37.83	8279.0
2015-05-04	AFK	ETF	26.93	27.245	26.83	26.83	47742.0
2015-05-04	AFTY	ETF	23.29	23.43	23.27	23.36	16200.0
2015-05-04	AGG	ETF	110.42	110.47	110.12	110.13	1651900.0
2015-05-04	AGQ	ETF	41.28	41.53	40.11	40.32	262200.0
2015-05-04	AGZ	ETF	113.39	113.59	113.39	113.4	13592.0
2015-05-04	AGZD	ETF	24.475	24.53	24.45	24.455	4600.0
2015-05-04	AIA	ETF	54.09	54.48	54.09	54.44	49548.0
2015-05-04	AIQ	ETF	22.0	22.21	20.81	20.84	18253.0
2015-05-04	AIRR	ETF	18.39	18.4	18.301	18.34	11100.0
2015-05-04	AIVI	ETF	46.24	46.38	46.17	46.25	25400.0
2015-05-04	AMJ	ETF	45.67	45.77	45.37	45.39	955991.0
2015-05-04	AMLP	ETF	86.3	86.4	85.9	85.9	722880.0
2015-05-04	AMZA	ETF	226.4	226.4	223.7	225.1	1100.0
2015-05-04	ANGL	ETF	27.65	27.66	27.6	27.64	16100.0
2015-05-04	AOA	ETF	48.74	48.75	48.57	48.59	113200.0
2015-05-04	AOK	ETF	33.01	33.092	33.01	33.0573	13632.0
2015-05-04	AOM	ETF	35.9	36.02	35.83	35.89	85380.0
2015-05-04	AOR	ETF	41.61	41.61	41.428	41.49	61370.0
2015-05-04	ARGT	ETF	22.43	22.67	22.43	22.66	19900.0
2015-05-04	ARKG	ETF	23.0	23.11	22.87	22.915	5300.0
2015-05-04	ARKK	ETF	20.66	21.09	20.58	21.012	4600.0
2015-05-04	ARKQ	ETF	19.81	19.826	19.79	19.826	14000.0
2015-05-04	ARKW	ETF	22.46	22.47	22.46	22.47	600.0
2015-05-04	ASEA	ETF	16.05	16.1	16.01	16.09	20600.0
2015-05-04	ASHR	ETF	49.09	49.74	49.01	49.62	1231700.0
2015-05-04	ASHS	ETF	55.59	55.76	54.62	55.72	35300.0
2015-05-04	ATMP	ETF	30.9	30.9	30.7	30.7	30900.0
2015-05-04	AWAY	ETF	27.58	28.16	27.58	27.75	1312644.0
2015-05-04	BAB	ETF	29.96	29.97	29.65	29.66	179493.0
2015-05-04	BAL	ETF	45.01	45.4089	44.77	45.4089	4551.0
2015-05-04	BALT	ETF	1.44	1.45	1.41	1.45	291690.0
2015-05-04	BAR	ETF	2.6325	2.678	2.6325	2.677	46610.0
2015-05-04	BBC	ETF	31.58	32.3306	31.33	31.74	25777.0
2015-05-04	BBH	ETF	129.88	131.27	128.98	129.02	121800.0
2015-05-04	BBP	ETF	30.62	31.314	30.01	30.81	11200.0
2015-05-04	BCHP	ETF	20.709	20.709	20.709	20.709	259.0

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

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