PREVIEW / etf_daily / 2015-04-23

all etf daily files

  file:    by_date/etf_daily/2015/2015-04-23.parquet
  size:    47 KB
  rows:    1,169

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-04-23	SPY	ETF	210.15	211.94	210.01	211.16	102585900.0
2015-04-23	QQQ	ETF	108.28	109.55	108.26	109.06	29473221.0
2015-04-23	IWM	ETF	125.48	126.54	125.26	126.28	18025800.0
2015-04-23	DIA	ETF	179.44	181.07	179.2	180.37	4893000.0
2015-04-23	GLD	ETF	113.9	114.96	113.81	114.66	3459500.0
2015-04-23	TLT	ETF	127.8	128.85	127.61	128.27	6843400.0
2015-04-23	AAXJ	ETF	69.14	69.56	68.92	69.42	1448700.0
2015-04-23	ACWI	ETF	62.02	62.59	61.91	62.43	996000.0
2015-04-23	ACWV	ETF	73.57	74.16	73.55	74.03	104800.0
2015-04-23	ACWX	ETF	46.72	47.31	46.69	47.25	373770.0
2015-04-23	ADRE	ETF	37.35	38.0	37.35	38.0	7945.0
2015-04-23	AFK	ETF	26.32	26.7299	26.3	26.62	13481.0
2015-04-23	AFTY	ETF	22.67	22.892	22.67	22.87	57200.0
2015-04-23	AGG	ETF	111.15	111.42	111.14	111.31	1483900.0
2015-04-23	AGQ	ETF	37.42	38.05	37.25	37.9	98000.0
2015-04-23	AGZ	ETF	114.084	114.199	113.97	114.1799	13574.0
2015-04-23	AGZD	ETF	24.53	24.57	24.5	24.5	10200.0
2015-04-23	AIA	ETF	54.14	54.55	54.12	54.41	45622.0
2015-04-23	AIQ	ETF	23.75	23.75	23.18	23.38	10019.0
2015-04-23	AIRR	ETF	18.787	18.92	18.77	18.87	10600.0
2015-04-23	AIVI	ETF	45.25	45.83	45.21	45.77	33200.0
2015-04-23	AMJ	ETF	44.06	44.607	44.0001	44.5	468940.0
2015-04-23	AMLP	ETF	84.65	85.15	84.65	85.1	606340.0
2015-04-23	AMZA	ETF	222.0	222.0	220.6	221.6	690.0
2015-04-23	ANGL	ETF	27.69	27.73	27.68	27.7	4600.0
2015-04-23	AOA	ETF	48.5	48.83	48.43	48.75	25200.0
2015-04-23	AOK	ETF	33.15	33.35	33.14	33.3	59906.0
2015-04-23	AOM	ETF	35.86	36.1399	35.86	36.0	68423.0
2015-04-23	AOR	ETF	41.45	41.6999	41.428	41.67	81624.0
2015-04-23	ARGT	ETF	21.88	22.3	21.88	22.28	3400.0
2015-04-23	ARKG	ETF	23.736	23.889	23.736	23.889	2300.0
2015-04-23	ARKK	ETF	22.03	22.03	21.985	21.985	1100.0
2015-04-23	ARKQ	ETF	20.45	20.65	20.45	20.649	1300.0
2015-04-23	ARKW	ETF	23.0	23.17	22.9	23.15	1600.0
2015-04-23	ASEA	ETF	16.24	16.33	16.2	16.32	20600.0
2015-04-23	ASHR	ETF	48.48	48.79	48.36	48.58	1619500.0
2015-04-23	ASHS	ETF	54.66	55.1	54.27	54.86	96200.0
2015-04-23	ATMP	ETF	30.31	30.43	30.31	30.4	8400.0
2015-04-23	AWAY	ETF	32.0	32.7	31.91	32.17	2417254.0
2015-04-23	BAB	ETF	30.25	30.35	30.21	30.25	95631.0
2015-04-23	BAL	ETF	43.64	44.6	43.6	44.45	9399.0
2015-04-23	BALT	ETF	1.62	1.71	1.58	1.65	796617.0
2015-04-23	BAR	ETF	2.663	2.682	2.663	2.681	18860.0
2015-04-23	BBC	ETF	34.82	35.26	34.4299	35.2356	20114.0
2015-04-23	BBH	ETF	134.59	136.1	134.0	135.82	42200.0
2015-04-23	BBP	ETF	33.32	33.57	32.989	33.55	13300.0
2015-04-23	BCM	ETF	31.9199	31.9199	31.83	31.83	7445.0
2015-04-23	BFOR	ETF	8.4725	8.5225	8.4725	8.5025	81600.0
2015-04-23	BIB	ETF	88.58	90.775	87.68	90.41	655676.0
2015-04-23	BICK	ETF	25.65	25.745	25.65	25.745	756.0

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

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