PREVIEW / etf_daily / 2015-06-25

all etf daily files

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

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-06-25	SPY	ETF	211.1	211.25	209.77	209.86	97107400.0
2015-06-25	QQQ	ETF	110.65	110.76	109.815	110.0	18326654.0
2015-06-25	IWM	ETF	128.35	128.42	127.25	127.85	24100900.0
2015-06-25	DIA	ETF	180.05	180.12	178.59	178.65	3602700.0
2015-06-25	GLD	ETF	112.43	112.71	112.32	112.44	2904700.0
2015-06-25	TLT	ETF	116.59	117.08	116.19	116.54	8287800.0
2015-06-25	AADR	ETF	39.87	40.01	39.86	39.97	5200.0
2015-06-25	AAXJ	ETF	64.83	64.9	64.47	64.5	282200.0
2015-06-25	ACTX	ETF	2.36	2.36	1.18	2.36	2243.0
2015-06-25	ACWI	ETF	61.37	61.39	60.96	60.96	1604500.0
2015-06-25	ACWV	ETF	70.86	71.07	70.64	70.83	174600.0
2015-06-25	ACWX	ETF	45.77	45.785	45.55	45.58	112847.0
2015-06-25	ADRE	ETF	35.95	35.9707	35.7601	35.8008	6311.0
2015-06-25	AFK	ETF	24.98	24.9999	24.9	24.94	15968.0
2015-06-25	AFTY	ETF	21.38	21.38	21.03	21.03	110700.0
2015-06-25	AGG	ETF	108.58	108.6	108.39	108.47	1222000.0
2015-06-25	AGQ	ETF	36.97	37.4	36.92	37.3	186300.0
2015-06-25	AGZ	ETF	112.77	113.36	112.5	112.9731	22979.0
2015-06-25	AGZD	ETF	24.33	24.355	24.29	24.315	50200.0
2015-06-25	AIA	ETF	51.71	51.72	51.5	51.52	17504.0
2015-06-25	AIQ	ETF	19.26	20.08	19.1618	19.98	21361.0
2015-06-25	AIRR	ETF	18.538	18.56	18.538	18.56	1600.0
2015-06-25	AIVI	ETF	44.39	44.41	44.2	44.24	75800.0
2015-06-25	ALTL	ETF	36.89	36.89	36.89	36.89	178.0
2015-06-25	AMJ	ETF	41.32	41.593	40.86	40.86	1368115.0
2015-06-25	AMLP	ETF	80.3	80.6	79.6	79.6	965260.0
2015-06-25	AMZA	ETF	208.5	208.5	202.9	202.9	1450.0
2015-06-25	ANGL	ETF	27.32	27.32	27.27	27.29	15600.0
2015-06-25	AOA	ETF	48.55	48.55	48.19	48.31	23800.0
2015-06-25	AOK	ETF	32.75	32.75	32.626	32.661	28980.0
2015-06-25	AOM	ETF	35.6	35.609	35.51	35.54	35362.0
2015-06-25	AOR	ETF	41.2	41.2193	41.1	41.1258	67521.0
2015-06-25	ARGT	ETF	20.9	20.9	20.64	20.66	1600.0
2015-06-25	ARKG	ETF	23.59	23.59	23.51	23.56	1200.0
2015-06-25	ARKK	ETF	22.1	22.1	21.9	21.9	8000.0
2015-06-25	ARKQ	ETF	20.398	20.4	20.398	20.4	700.0
2015-06-25	ARKW	ETF	23.61	23.718	23.61	23.682	5200.0
2015-06-25	ASEA	ETF	15.16	15.16	15.15	15.15	1400.0
2015-06-25	ASHR	ETF	48.33	48.59	47.81	47.81	4264400.0
2015-06-25	ASHS	ETF	66.29	66.29	63.66	63.69	221400.0
2015-06-25	ATMP	ETF	28.25	28.45	28.07	28.07	31000.0
2015-06-25	AWAY	ETF	31.79	31.83	31.18	31.19	797043.0
2015-06-25	BAB	ETF	28.82	28.9195	28.75	28.81	99158.0
2015-06-25	BAL	ETF	43.3299	44.029	43.1501	44.02	8122.0
2015-06-25	BALT	ETF	1.62	1.64	1.6	1.63	649860.0
2015-06-25	BBC	ETF	36.64	36.95	36.07	36.4	28735.0
2015-06-25	BBH	ETF	138.66	139.21	136.97	137.72	90100.0
2015-06-25	BBP	ETF	35.88	35.89	35.3	35.57	16300.0
2015-06-25	BCM	ETF	31.3	31.3	31.3	31.3	3556.0
2015-06-25	BFOR	ETF	8.5275	8.5275	8.46	8.49	18800.0

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

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