PREVIEW / etf_daily / 2015-06-01

all etf daily files

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

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-01	SPY	ETF	211.94	212.34	210.62	211.57	93338800.0
2015-06-01	QQQ	ETF	110.64	110.72	109.52	110.42	24570186.0
2015-06-01	IWM	ETF	124.69	124.9	123.03	124.28	35649400.0
2015-06-01	DIA	ETF	181.0	181.15	179.81	180.4	4349000.0
2015-06-01	GLD	ETF	115.02	115.5	113.9	114.0	8254000.0
2015-06-01	TLT	ETF	122.11	122.38	120.69	121.13	13108100.0
2015-06-01	AAXJ	ETF	66.05	66.36	65.86	66.11	870000.0
2015-06-01	ACTX	ETF	4.72	4.72	3.54	3.54	370.0
2015-06-01	ACWF	ETF	25.13	25.13	25.05	25.12	4533.0
2015-06-01	ACWI	ETF	61.94	61.96	61.5	61.7	742200.0
2015-06-01	ACWV	ETF	72.33	72.37	71.95	72.12	235700.0
2015-06-01	ACWX	ETF	46.34	46.39	46.0	46.12	207261.0
2015-06-01	ADRE	ETF	35.93	36.02	35.86	35.86	15961.0
2015-06-01	AFK	ETF	25.67	25.67	25.5	25.5	38111.0
2015-06-01	AFTY	ETF	22.82	22.91	22.75	22.8	112600.0
2015-06-01	AGG	ETF	109.95	109.99	109.56	109.66	4327300.0
2015-06-01	AGQ	ETF	42.07	43.74	41.34	41.61	198700.0
2015-06-01	AGZ	ETF	113.53	113.59	113.31	113.31	7303.0
2015-06-01	AGZD	ETF	24.36	24.39	24.33	24.335	37600.0
2015-06-01	AIA	ETF	52.4	52.4	52.0	52.1	67158.0
2015-06-01	AIQ	ETF	18.73	18.81	18.35	18.64	12936.0
2015-06-01	AIRR	ETF	18.24	18.28	17.99	18.25	7200.0
2015-06-01	AIVI	ETF	45.19	45.21	44.78	44.98	21700.0
2015-06-01	AMJ	ETF	43.42	43.45	43.1	43.13	604474.0
2015-06-01	AMLP	ETF	82.8	83.15	82.7	82.8	919000.0
2015-06-01	AMZA	ETF	218.1	220.6	215.0	216.5	1300.0
2015-06-01	ANGL	ETF	27.8	27.8	27.73	27.76	51100.0
2015-06-01	AOA	ETF	48.43	48.62	48.14	48.35	87300.0
2015-06-01	AOK	ETF	33.18	33.18	32.87	32.92	52529.0
2015-06-01	AOM	ETF	35.85	35.85	35.66	35.73	35850.0
2015-06-01	AOR	ETF	41.34	41.34	41.1659	41.29	52711.0
2015-06-01	ARGT	ETF	21.0	21.03	20.71	21.03	11700.0
2015-06-01	ARKG	ETF	23.49	23.49	23.216	23.313	1500.0
2015-06-01	ARKK	ETF	21.475	21.53	21.475	21.52	1000.0
2015-06-01	ARKQ	ETF	20.15	20.15	20.15	20.15	100.0
2015-06-01	ARKW	ETF	23.3	23.3	23.25	23.25	500.0
2015-06-01	ASEA	ETF	15.22	15.24	15.21	15.21	6200.0
2015-06-01	ASHR	ETF	52.33	52.72	52.17	52.63	2388500.0
2015-06-01	ASHS	ETF	69.09	69.59	69.0	69.58	409200.0
2015-06-01	ATMP	ETF	29.72	29.72	29.28	29.3	16800.0
2015-06-01	AWAY	ETF	28.45	30.64	28.45	30.36	3701583.0
2015-06-01	BAB	ETF	29.26	29.36	29.07	29.12	109556.0
2015-06-01	BAL	ETF	44.06	44.211	43.0301	43.0301	13763.0
2015-06-01	BALT	ETF	1.54	1.54	1.5	1.52	164653.0
2015-06-01	BAR	ETF	2.7355	2.7355	2.64	2.64	4360.0
2015-06-01	BBC	ETF	36.63	36.63	35.0101	35.37	34931.0
2015-06-01	BBH	ETF	135.26	135.5	133.2	134.31	134500.0
2015-06-01	BBP	ETF	32.94	33.44	32.75	33.2	38000.0
2015-06-01	BCHP	ETF	22.5399	22.5399	20.28	20.33	2711.0
2015-06-01	BCM	ETF	31.58	31.61	31.534	31.55	91910.0

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

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