PREVIEW / etf_daily / 2015-01-20

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-20.parquet
  size:    47 KB
  rows:    1,163

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-01-20	SPY	ETF	202.4	202.72	200.17	202.06	130991100.0
2015-01-20	QQQ	ETF	101.43	101.88	100.29	101.62	30964056.0
2015-01-20	IWM	ETF	116.85	117.08	115.16	116.21	36444400.0
2015-01-20	DIA	ETF	175.23	175.61	173.14	174.9	7224100.0
2015-01-20	GLD	ETF	123.63	124.6	123.49	124.2	14968600.0
2015-01-20	TLT	ETF	134.13	135.11	134.07	134.96	7758700.0
2015-01-20	AADR	ETF	36.7	36.7	36.47	36.5	2000.0
2015-01-20	AAXJ	ETF	61.82	62.04	61.78	61.96	1209600.0
2015-01-20	ACWI	ETF	58.1	58.21	57.64	58.01	3414900.0
2015-01-20	ACWV	ETF	70.6	70.62	69.91	70.23	265500.0
2015-01-20	ACWX	ETF	42.95	42.97	42.69	42.86	1568068.0
2015-01-20	ADRE	ETF	35.97	36.13	35.8506	36.074	5264.0
2015-01-20	AFK	ETF	25.45	25.69	25.45	25.65	33789.0
2015-01-20	AGG	ETF	111.75	111.84	111.55	111.69	2059400.0
2015-01-20	AGQ	ETF	48.51	49.76	48.36	49.35	739000.0
2015-01-20	AGZ	ETF	114.77	114.84	114.16	114.5	43303.0
2015-01-20	AGZD	ETF	24.515	24.515	24.395	24.4	14600.0
2015-01-20	AIA	ETF	47.99	47.99	47.784	47.94	60560.0
2015-01-20	AIQ	ETF	21.7	21.97	21.2	21.82	30831.0
2015-01-20	AIRR	ETF	16.99	16.99	16.46	16.55	150200.0
2015-01-20	AIVI	ETF	43.11	43.14	42.87	43.06	20500.0
2015-01-20	ALTL	ETF	37.86	38.0	37.86	38.0	500.0
2015-01-20	AMJ	ETF	43.64	44.425	43.11	43.9	2121851.0
2015-01-20	AMLP	ETF	84.4	85.7	83.7	84.9	1326080.0
2015-01-20	AMZA	ETF	207.9	211.0	207.9	210.4	140.0
2015-01-20	ANGL	ETF	26.79	26.79	26.36	26.64	2200.0
2015-01-20	AOA	ETF	46.24	46.24	45.81	46.03	153700.0
2015-01-20	AOK	ETF	32.66	32.67	32.58	32.64	93925.0
2015-01-20	AOM	ETF	35.19	35.2145	35.04	35.16	361627.0
2015-01-20	AOR	ETF	40.18	40.18	39.8305	40.01	192080.0
2015-01-20	ARGT	ETF	18.15	18.27	18.1	18.26	4500.0
2015-01-20	ARKG	ETF	22.49	22.73	22.3	22.71	3900.0
2015-01-20	ARKK	ETF	19.8	19.9	19.69	19.89	1000.0
2015-01-20	ARKQ	ETF	18.5	18.67	18.5	18.644	1200.0
2015-01-20	ARKW	ETF	19.8	20.08	19.8	20.046	3700.0
2015-01-20	ASEA	ETF	15.55	15.57	15.42	15.48	16700.0
2015-01-20	ASHR	ETF	34.99	35.35	34.72	34.9	2111900.0
2015-01-20	ASHS	ETF	35.88	36.02	35.8	35.97	14300.0
2015-01-20	ATMP	ETF	29.0	29.26	28.64	29.11	12200.0
2015-01-20	AVIV	ETF	39.29	39.7	39.12	39.41	118846.0
2015-01-20	AWAY	ETF	25.92	26.73	25.82	26.54	1374407.0
2015-01-20	BAB	ETF	31.06	31.0999	30.91	31.06	192789.0
2015-01-20	BAL	ETF	40.018	40.018	39.16	39.16	10082.0
2015-01-20	BALT	ETF	1.76	1.91	1.68	1.76	3925815.0
2015-01-20	BAR	ETF	3.511	3.563	3.499	3.555	135500.0
2015-01-20	BBC	ETF	30.61	30.61	28.08	28.9599	9999.0
2015-01-20	BBH	ETF	121.84	123.97	120.5	123.7	202200.0
2015-01-20	BBP	ETF	28.54	28.54	27.33	28.1	2800.0
2015-01-20	BCHP	ETF	17.91	17.93	17.91	17.93	13069.0
2015-01-20	BCM	ETF	30.83	30.93	30.77	30.77	3358.0

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

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