PREVIEW / etf_daily / 2015-02-10

all etf daily files

  file:    by_date/etf_daily/2015/2015-02-10.parquet
  size:    47 KB
  rows:    1,155

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-02-10	SPY	ETF	205.88	207.12	204.68	206.81	96164200.0
2015-02-10	QQQ	ETF	103.37	104.54	103.21	104.4	23686531.0
2015-02-10	IWM	ETF	119.53	119.84	118.1	119.62	28960800.0
2015-02-10	DIA	ETF	178.17	178.75	177.14	178.51	3572700.0
2015-02-10	GLD	ETF	118.63	119.06	118.21	118.47	4086300.0
2015-02-10	TLT	ETF	130.14	130.47	129.44	129.71	8290700.0
2015-02-10	AADR	ETF	37.5	37.67	37.23	37.67	2100.0
2015-02-10	AAXJ	ETF	62.67	62.76	62.44	62.64	514200.0
2015-02-10	ACWI	ETF	59.22	59.51	58.99	59.47	450700.0
2015-02-10	ACWV	ETF	70.71	70.9	70.36	70.79	169900.0
2015-02-10	ACWX	ETF	43.7415	43.9	43.61	43.87	291276.0
2015-02-10	ADRE	ETF	36.05	36.05	35.71	35.88	4530.0
2015-02-10	AFK	ETF	25.6	25.6	25.34	25.54	51409.0
2015-02-10	AGG	ETF	110.96	111.06	110.82	110.92	1272500.0
2015-02-10	AGQ	ETF	43.69	44.44	43.21	43.46	121400.0
2015-02-10	AGZ	ETF	114.0	114.5499	113.7201	114.4323	26308.0
2015-02-10	AGZD	ETF	24.62	24.66	24.51	24.645	8600.0
2015-02-10	AIA	ETF	48.49	48.59	48.41	48.56	50238.0
2015-02-10	AIQ	ETF	23.68	24.16	22.73	23.35	26362.0
2015-02-10	AIRR	ETF	17.97	17.97	17.71	17.83	26300.0
2015-02-10	AIVI	ETF	44.33	44.45	44.06	44.45	10100.0
2015-02-10	AMJ	ETF	45.59	45.9	44.805	45.52	898714.0
2015-02-10	AMLP	ETF	86.5	86.7	85.5	86.55	712180.0
2015-02-10	AMZA	ETF	216.1	217.7	216.1	217.7	240.0
2015-02-10	ANGL	ETF	27.12	27.18	26.94	27.16	19400.0
2015-02-10	AOA	ETF	46.7	46.8	46.53	46.8	26000.0
2015-02-10	AOK	ETF	32.48	32.59	32.48	32.54	32040.0
2015-02-10	AOM	ETF	35.16	35.19	35.07	35.15	118800.0
2015-02-10	AOR	ETF	40.16	40.33	40.126	40.33	56671.0
2015-02-10	ARGT	ETF	19.02	19.25	18.86	19.25	23200.0
2015-02-10	ARKG	ETF	22.01	22.5	22.01	22.49	1800.0
2015-02-10	ARKK	ETF	20.81	20.85	20.81	20.85	300.0
2015-02-10	ARKQ	ETF	19.47	19.54	19.47	19.52	500.0
2015-02-10	ARKW	ETF	21.25	21.3	21.25	21.3	400.0
2015-02-10	ASEA	ETF	15.77	15.77	15.7	15.73	3000.0
2015-02-10	ASHR	ETF	34.7	35.06	34.68	34.91	494200.0
2015-02-10	ASHS	ETF	36.5	36.63	36.44	36.51	24000.0
2015-02-10	ATMP	ETF	29.93	30.17	29.79	30.17	73400.0
2015-02-10	AVIV	ETF	36.52	36.62	35.55	36.26	212045.0
2015-02-10	AWAY	ETF	27.03	27.215	26.73	27.12	639780.0
2015-02-10	BAB	ETF	30.76	30.86	30.6716	30.73	110817.0
2015-02-10	BAL	ETF	43.13	43.26	42.53	42.8	10746.0
2015-02-10	BALT	ETF	1.78	1.78	1.63	1.67	681919.0
2015-02-10	BAR	ETF	3.012	3.054	3.001	3.001	23220.0
2015-02-10	BBC	ETF	27.6681	28.2	27.47	28.2	7548.0
2015-02-10	BBH	ETF	119.89	121.03	119.25	120.68	127500.0
2015-02-10	BBP	ETF	27.9	28.29	27.73	28.199	1100.0
2015-02-10	BCM	ETF	31.92	31.92	31.71	31.71	16219.0
2015-02-10	BFOR	ETF	7.9375	7.9825	7.895	7.9775	56400.0
2015-02-10	BIB	ETF	67.07	68.855	66.815	68.35	471202.0

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

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