PREVIEW / etf_daily / 2015-07-23

all etf daily files

  file:    by_date/etf_daily/2015/2015-07-23.parquet
  size:    48 KB
  rows:    1,186

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-07-23	SPY	ETF	211.53	211.65	209.75	210.18	90509100.0
2015-07-23	QQQ	ETF	112.73	113.1	111.91	112.2	25698255.0
2015-07-23	IWM	ETF	124.99	125.39	123.3	123.57	39712100.0
2015-07-23	DIA	ETF	178.33	178.33	176.83	177.16	4968600.0
2015-07-23	GLD	ETF	104.98	105.3	104.2	104.33	5779300.0
2015-07-23	TLT	ETF	119.6	121.2	119.45	121.09	9087700.0
2015-07-23	AADR	ETF	39.79	39.79	39.75	39.75	600.0
2015-07-23	AAXJ	ETF	60.65	60.79	60.34	60.44	1441600.0
2015-07-23	ACTX	ETF	1.77	1.77	1.77	1.77	105.0
2015-07-23	ACWI	ETF	60.4	60.53	59.92	60.02	621000.0
2015-07-23	ACWV	ETF	70.99	70.99	70.39	70.56	90000.0
2015-07-23	ACWX	ETF	44.34	44.3868	44.04	44.075	220312.0
2015-07-23	ADRE	ETF	33.75	33.89	33.59	33.64	19555.0
2015-07-23	AFK	ETF	23.11	23.19	22.85	23.15	108577.0
2015-07-23	AFTY	ETF	20.15	20.405	20.15	20.2	114100.0
2015-07-23	AGG	ETF	108.84	109.15	108.81	109.14	1021400.0
2015-07-23	AGQ	ETF	32.13	32.27	31.3	31.5	186600.0
2015-07-23	AGZ	ETF	113.1	113.44	113.06	113.3095	19210.0
2015-07-23	AGZD	ETF	24.36	24.5	24.295	24.465	15400.0
2015-07-23	AIA	ETF	48.36	48.42	48.1	48.1595	21057.0
2015-07-23	AIQ	ETF	16.61	16.61	15.86	16.04	21634.0
2015-07-23	AIRR	ETF	17.57	17.688	17.41	17.41	50500.0
2015-07-23	AIVI	ETF	43.07	43.14	42.76	42.82	14600.0
2015-07-23	ALTY	ETF	15.09	15.09	14.8	14.8	3900.0
2015-07-23	AMJ	ETF	36.79	37.27	36.7	36.81	4170412.0
2015-07-23	AMLP	ETF	74.7	75.45	74.5	74.75	1556100.0
2015-07-23	AMZA	ETF	172.9	177.79	172.9	175.5	2390.0
2015-07-23	ANGL	ETF	26.94	26.99	26.9	26.97	17500.0
2015-07-23	AOA	ETF	47.58	47.58	47.28	47.36	24000.0
2015-07-23	AOK	ETF	32.4	32.5	32.3901	32.48	67744.0
2015-07-23	AOM	ETF	35.15	35.24	35.09	35.09	56346.0
2015-07-23	AOR	ETF	40.68	40.68	40.475	40.5	65934.0
2015-07-23	ARGT	ETF	19.01	19.01	18.77	18.79	6900.0
2015-07-23	ARKG	ETF	23.7	23.7	23.44	23.44	600.0
2015-07-23	ARKK	ETF	21.848	21.848	21.8	21.8	300.0
2015-07-23	ARKQ	ETF	19.892	19.892	19.892	19.892	100.0
2015-07-23	ARKW	ETF	23.93	24.15	23.93	23.97	1700.0
2015-07-23	ASEA	ETF	14.77	14.79	14.74	14.74	1800.0
2015-07-23	ASHR	ETF	44.33	44.58	44.13	44.3	3240900.0
2015-07-23	ASHS	ETF	54.58	54.78	54.2	54.25	175900.0
2015-07-23	ATMP	ETF	25.1	25.47	25.1	25.16	108800.0
2015-07-23	AWAY	ETF	31.31	31.72	30.98	31.25	619754.0
2015-07-23	BAB	ETF	28.82	28.984	28.75	28.97	75010.0
2015-07-23	BAL	ETF	43.28	43.751	43.27	43.27	5559.0
2015-07-23	BBC	ETF	38.69	39.0999	38.12	38.26	17139.0
2015-07-23	BBH	ETF	143.6	144.37	142.68	143.2	184300.0
2015-07-23	BBP	ETF	37.75	37.75	37.0	37.08	19900.0
2015-07-23	BCM	ETF	29.02	30.32	28.6657	28.6657	2464.0
2015-07-23	BFOR	ETF	8.3175	8.33	8.2325	8.245	103600.0
2015-07-23	BIB	ETF	103.38	104.38	101.75	102.42	545599.0

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

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