PREVIEW / etf_daily / 2016-01-21

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-21.parquet
  size:    50 KB
  rows:    1,247

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
2016-01-21	SPY	ETF	186.21	188.87	184.64	186.69	195772900.0
2016-01-21	QQQ	ETF	101.19	102.349	99.82	100.85	61660101.0
2016-01-21	IWM	ETF	99.33	100.91	98.38	98.95	65798200.0
2016-01-21	DIA	ETF	157.81	160.29	156.88	158.6	16782400.0
2016-01-21	GLD	ETF	104.99	105.49	104.52	105.49	5425000.0
2016-01-21	TLT	ETF	126.94	127.29	125.67	125.82	11001600.0
2016-01-21	AADR	ETF	35.32	35.32	34.63	34.84	1000.0
2016-01-21	AAXJ	ETF	47.01	47.83	46.8	47.32	1187900.0
2016-01-21	ACTX	ETF	7.0801	7.0801	6.4901	7.0801	100.0
2016-01-21	ACWF	ETF	21.0007	21.0007	21.0007	21.0007	390.0
2016-01-21	ACWI	ETF	50.27	51.02	49.85	50.54	3640000.0
2016-01-21	ACWV	ETF	64.86	65.3	64.32	64.97	1061500.0
2016-01-21	ACWX	ETF	35.21	35.71	34.86	35.46	5989026.0
2016-01-21	ADRE	ETF	25.57	26.102	25.4706	25.82	5970.0
2016-01-21	AFK	ETF	15.0	15.64	15.0	15.22	176950.0
2016-01-21	AFTY	ETF	12.18	12.29	12.18	12.22	6300.0
2016-01-21	AGG	ETF	109.08	109.08	108.74	108.76	7256000.0
2016-01-21	AGGY	ETF	49.57	49.58	49.45	49.5	362600.0
2016-01-21	AGQ	ETF	27.54	28.24	27.24	28.24	192700.0
2016-01-21	AGZ	ETF	114.1	114.1	113.61	113.61	19036.0
2016-01-21	AGZD	ETF	23.715	23.765	23.715	23.765	3800.0
2016-01-21	AIA	ETF	37.09	37.58	36.99	37.17	80381.0
2016-01-21	AIQ	ETF	6.87	7.06	6.62	6.82	26919.0
2016-01-21	AIRR	ETF	14.508	14.572	14.375	14.46	6000.0
2016-01-21	AIVI	ETF	34.48	35.07	34.46	34.93	42500.0
2016-01-21	ALTY	ETF	12.44	12.49	12.44	12.46	1800.0
2016-01-21	AMJ	ETF	21.34	22.8	21.21	22.36	4266560.0
2016-01-21	AMLP	ETF	43.1	46.3	43.1	45.55	4386920.0
2016-01-21	AMZA	ETF	67.2	74.65	67.2	73.7	5860.0
2016-01-21	ANGL	ETF	23.35	23.65	23.27	23.39	66600.0
2016-01-21	AOA	ETF	41.37	41.73	41.03	41.49	211400.0
2016-01-21	AOK	ETF	30.74	30.87	30.6601	30.79	109960.0
2016-01-21	AOM	ETF	32.76	32.9132	32.74	32.85	243517.0
2016-01-21	AOR	ETF	36.67	36.85	36.4275	36.62	660090.0
2016-01-21	ARGT	ETF	15.65	15.84	15.33	15.81	9800.0
2016-01-21	ARKG	ETF	17.56	17.56	17.56	17.56	100.0
2016-01-21	ARKK	ETF	17.42	17.42	17.2	17.2	400.0
2016-01-21	ARKQ	ETF	16.23	16.39	16.17	16.39	700.0
2016-01-21	ARKW	ETF	19.67	19.67	19.5	19.5	300.0
2016-01-21	ASEA	ETF	11.16	11.25	11.12	11.22	2300.0
2016-01-21	ASET	ETF	22.55	22.55	22.42	22.42	3700.0
2016-01-21	ASHR	ETF	22.83	23.23	22.79	23.11	1102400.0
2016-01-21	ASHS	ETF	31.49	32.12	31.48	31.83	26200.0
2016-01-21	ATMP	ETF	14.54	15.06	14.48	14.83	261200.0
2016-01-21	BAB	ETF	29.9	29.91	29.75	29.78	185597.0
2016-01-21	BAL	ETF	41.25	41.39	41.19	41.19	6780.0
2016-01-21	BBC	ETF	21.13	21.63	20.67	20.67	7884.0
2016-01-21	BBH	ETF	108.03	108.99	105.97	106.16	98800.0
2016-01-21	BBP	ETF	25.27	25.66	24.84	25.0	5800.0
2016-01-21	BCM	ETF	21.68	22.03	21.68	21.997	3961.0

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

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