PREVIEW / etf_daily / 2015-06-29

all etf daily files

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

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-29	SPY	ETF	208.05	209.83	205.33	205.42	202621300.0
2015-06-29	QQQ	ETF	108.06	108.66	106.64	106.69	50874901.0
2015-06-29	IWM	ETF	126.63	127.07	124.11	124.28	49224900.0
2015-06-29	DIA	ETF	177.6	178.21	175.59	175.64	8888700.0
2015-06-29	GLD	ETF	112.81	113.23	112.53	113.07	5820200.0
2015-06-29	TLT	ETF	116.96	118.67	116.46	118.28	17132900.0
2015-06-29	AADR	ETF	38.92	38.92	38.92	38.92	400.0
2015-06-29	AAXJ	ETF	62.77	62.96	62.27	62.3	650100.0
2015-06-29	ACTX	ETF	1.77	2.36	1.77	2.36	6427.0
2015-06-29	ACWF	ETF	24.09	24.76	24.09	24.56	5425.0
2015-06-29	ACWI	ETF	60.01	60.25	59.31	59.35	2305000.0
2015-06-29	ACWV	ETF	69.93	70.32	69.37	69.59	107100.0
2015-06-29	ACWX	ETF	44.62	44.74	44.14	44.2	487760.0
2015-06-29	ADRE	ETF	34.99	35.19	34.72	34.72	10953.0
2015-06-29	AFK	ETF	24.37	24.6	24.11	24.33	48949.0
2015-06-29	AFTY	ETF	19.21	19.89	19.21	19.47	156600.0
2015-06-29	AGG	ETF	108.6	108.94	108.38	108.85	3278900.0
2015-06-29	AGQ	ETF	36.9	37.09	36.41	36.58	164600.0
2015-06-29	AGZ	ETF	113.069	113.29	113.01	113.15	15541.0
2015-06-29	AGZD	ETF	24.295	24.35	24.26	24.26	28800.0
2015-06-29	AIA	ETF	50.332	50.332	49.77	49.77	30309.0
2015-06-29	AIQ	ETF	19.81	19.81	18.77	18.81	13806.0
2015-06-29	AIRR	ETF	18.45	18.465	18.19	18.24	3300.0
2015-06-29	AIVI	ETF	43.18	43.37	42.74	42.75	84000.0
2015-06-29	AMJ	ETF	40.34	40.39	39.86	39.86	2887752.0
2015-06-29	AMLP	ETF	78.9	79.0	78.15	78.15	1667580.0
2015-06-29	AMZA	ETF	203.4	204.4	198.6	199.37	3350.0
2015-06-29	ANGL	ETF	27.2	27.32	27.1	27.1	20000.0
2015-06-29	AOA	ETF	47.81	47.96	47.22	47.22	33900.0
2015-06-29	AOK	ETF	32.4	32.5199	32.4	32.46	46051.0
2015-06-29	AOM	ETF	35.21	35.33	35.15	35.21	56969.0
2015-06-29	AOR	ETF	40.65	40.77	40.44	40.45	156402.0
2015-06-29	ARGT	ETF	20.18	20.29	19.98	20.02	6600.0
2015-06-29	ARKG	ETF	23.26	23.26	22.93	23.01	10500.0
2015-06-29	ARKK	ETF	21.5	21.5	21.16	21.16	5100.0
2015-06-29	ARKQ	ETF	19.78	19.78	19.67	19.67	2300.0
2015-06-29	ARKW	ETF	23.0	23.06	22.72	22.77	10900.0
2015-06-29	ASEA	ETF	14.91	15.02	14.84	14.85	5400.0
2015-06-29	ASHR	ETF	43.2	43.57	43.01	43.12	6042800.0
2015-06-29	ASHS	ETF	53.76	54.4	52.74	52.92	690700.0
2015-06-29	ATMP	ETF	27.8	27.8	27.48	27.48	65400.0
2015-06-29	AWAY	ETF	30.35	30.67	29.93	30.13	984985.0
2015-06-29	BAB	ETF	28.7	28.85	28.55	28.81	145390.0
2015-06-29	BAL	ETF	45.36	45.5326	45.0	45.073	15830.0
2015-06-29	BALT	ETF	1.54	1.59	1.54	1.57	209452.0
2015-06-29	BBC	ETF	34.71	35.7633	34.5	34.5	48651.0
2015-06-29	BBH	ETF	135.23	136.32	132.14	132.33	146500.0
2015-06-29	BBP	ETF	34.51	35.02	34.01	34.09	82000.0
2015-06-29	BCHP	ETF	19.53	19.53	19.53	19.53	350.0
2015-06-29	BCM	ETF	31.11	31.1799	31.11	31.1799	934.0

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

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