PREVIEW / etf_daily / 2015-05-21

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-21.parquet
  size:    47 KB
  rows:    1,177

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-21	SPY	ETF	212.71	213.75	212.51	213.5	64764600.0
2015-05-21	QQQ	ETF	109.82	110.73	109.66	110.58	16771801.0
2015-05-21	IWM	ETF	124.98	125.47	124.48	124.97	16229300.0
2015-05-21	DIA	ETF	182.62	183.04	182.36	182.79	2724200.0
2015-05-21	GLD	ETF	115.53	116.0	115.47	115.69	2514700.0
2015-05-21	TLT	ETF	119.58	120.61	119.45	120.35	11760700.0
2015-05-21	AADR	ETF	40.72	40.72	40.72	40.72	600.0
2015-05-21	AAXJ	ETF	67.48	67.74	67.34	67.68	1586300.0
2015-05-21	ACTX	ETF	3.54	3.54	2.95	2.95	136.0
2015-05-21	ACWF	ETF	25.49	25.52	25.49	25.5199	5133.0
2015-05-21	ACWI	ETF	62.77	63.08	62.69	62.99	1749000.0
2015-05-21	ACWV	ETF	73.6	73.73	73.44	73.56	60100.0
2015-05-21	ACWX	ETF	47.37	47.667	47.34	47.59	202634.0
2015-05-21	ADRE	ETF	36.85	36.919	36.73	36.8844	9667.0
2015-05-21	AFK	ETF	26.7	26.927	26.55	26.66	75419.0
2015-05-21	AFTY	ETF	22.35	22.41	22.335	22.39	31400.0
2015-05-21	AGG	ETF	109.65	109.93	109.65	109.91	2652600.0
2015-05-21	AGQ	ETF	43.55	44.04	43.45	43.72	97000.0
2015-05-21	AGZ	ETF	113.489	113.49	113.2618	113.297	7560.0
2015-05-21	AGZD	ETF	24.455	24.505	24.39	24.505	14800.0
2015-05-21	AIA	ETF	53.04	53.1264	52.934	53.083	40977.0
2015-05-21	AIQ	ETF	20.5	20.585	20.25	20.25	17812.0
2015-05-21	AIRR	ETF	18.62	18.68	18.598	18.61	3700.0
2015-05-21	AIVI	ETF	46.41	46.75	46.34	46.62	21600.0
2015-05-21	AMJ	ETF	44.84	45.05	44.7278	44.89	773238.0
2015-05-21	AMLP	ETF	84.3	84.55	84.05	84.3	860860.0
2015-05-21	AMZA	ETF	225.9	225.9	221.9	221.9	3060.0
2015-05-21	ANGL	ETF	27.58	27.62	27.58	27.6	11800.0
2015-05-21	AOA	ETF	48.9	49.07	48.9	49.03	27900.0
2015-05-21	AOK	ETF	32.97	33.15	32.97	33.14	60075.0
2015-05-21	AOM	ETF	35.77	36.0399	35.77	36.03	58013.0
2015-05-21	AOR	ETF	41.54	41.775	41.54	41.75	49825.0
2015-05-21	ARGT	ETF	21.92	22.07	21.85	21.9	12000.0
2015-05-21	ARKG	ETF	23.17	23.26	23.17	23.18	500.0
2015-05-21	ARKK	ETF	21.48	21.48	21.41	21.41	1400.0
2015-05-21	ARKQ	ETF	20.095	20.14	20.095	20.14	700.0
2015-05-21	ARKW	ETF	23.24	23.295	23.24	23.295	1000.0
2015-05-21	ASEA	ETF	15.97	15.99	15.94	15.95	2300.0
2015-05-21	ASHR	ETF	50.2	50.43	50.14	50.43	1865500.0
2015-05-21	ASHS	ETF	61.88	64.08	61.88	63.97	164000.0
2015-05-21	ATMP	ETF	30.59	30.59	30.38	30.58	45100.0
2015-05-21	AWAY	ETF	28.42	28.49	28.16	28.4	1094310.0
2015-05-21	BAB	ETF	28.93	29.0546	28.82	28.99	102895.0
2015-05-21	BAL	ETF	43.66	43.66	43.11	43.228	5522.0
2015-05-21	BALT	ETF	1.46	1.51	1.45	1.5	381538.0
2015-05-21	BAR	ETF	2.76	2.791	2.76	2.7843	16050.0
2015-05-21	BBC	ETF	34.75	35.0	34.3001	34.63	14829.0
2015-05-21	BBH	ETF	135.29	135.65	134.51	135.37	121000.0
2015-05-21	BBP	ETF	32.33	32.54	32.29	32.51	8300.0
2015-05-21	BCHP	ETF	20.69	20.69	20.6799	20.68	1081.0

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

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