PREVIEW / etf_daily / 2016-01-12

all etf daily files

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

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-12	SPY	ETF	193.82	194.55	191.14	193.66	172330500.0
2016-01-12	QQQ	ETF	105.31	106.08	104.08	105.54	46734241.0
2016-01-12	IWM	ETF	104.22	104.99	101.94	103.71	53702900.0
2016-01-12	DIA	ETF	165.19	165.78	163.05	164.95	10250300.0
2016-01-12	GLD	ETF	104.09	104.59	103.65	104.21	5540200.0
2016-01-12	TLT	ETF	122.34	124.32	122.15	123.77	12897700.0
2016-01-12	AADR	ETF	36.34	36.34	35.83	36.1	8800.0
2016-01-12	AAXJ	ETF	49.42	49.59	48.94	49.26	803300.0
2016-01-12	ACTX	ETF	7.6701	8.8501	7.6701	7.6701	579.0
2016-01-12	ACWF	ETF	22.13	22.13	21.78	21.81	4734.0
2016-01-12	ACWI	ETF	52.66	52.87	52.01	52.58	2414300.0
2016-01-12	ACWV	ETF	67.19	67.19	66.4	66.97	98300.0
2016-01-12	ACWX	ETF	37.21	37.25	36.73	37.06	2193711.0
2016-01-12	ADRE	ETF	26.53	26.53	26.295	26.4101	9628.0
2016-01-12	AFK	ETF	16.4	16.4	15.84	16.05	30166.0
2016-01-12	AFTY	ETF	12.79	12.859	12.61	12.66	21100.0
2016-01-12	AGG	ETF	108.44	108.82	108.36	108.59	3318400.0
2016-01-12	AGQ	ETF	27.02	27.12	26.75	26.99	91900.0
2016-01-12	AGZ	ETF	113.4	113.66	113.375	113.47	22627.0
2016-01-12	AGZD	ETF	23.945	23.945	23.865	23.885	22200.0
2016-01-12	AIA	ETF	39.0	39.12	38.63	38.91	64851.0
2016-01-12	AIQ	ETF	7.75	7.98	7.3	7.45	44066.0
2016-01-12	AIRR	ETF	15.28	15.28	14.96	15.14	15000.0
2016-01-12	AIVI	ETF	36.21	36.3	35.8	36.06	18900.0
2016-01-12	AMJ	ETF	25.74	26.45	23.76	25.36	11929364.0
2016-01-12	AMLP	ETF	52.65	54.5	48.65	51.8	6653020.0
2016-01-12	AMZA	ETF	90.0	90.0	79.0	80.6	5690.0
2016-01-12	ANGL	ETF	24.2	24.25	24.1	24.17	39400.0
2016-01-12	AOA	ETF	42.94	42.99	42.52	42.87	56600.0
2016-01-12	AOK	ETF	31.12	31.2	31.09	31.16	154887.0
2016-01-12	AOM	ETF	33.37	33.41	33.26	33.41	51800.0
2016-01-12	AOR	ETF	37.59	37.65	37.38	37.57	114887.0
2016-01-12	ARGT	ETF	16.84	17.02	16.6	16.85	7800.0
2016-01-12	ARKG	ETF	18.04	18.64	18.04	18.64	800.0
2016-01-12	ARKK	ETF	18.33	18.67	18.29	18.435	1700.0
2016-01-12	ARKQ	ETF	17.45	17.45	17.136	17.17	1100.0
2016-01-12	ARKW	ETF	20.86	21.15	20.784	20.784	9200.0
2016-01-12	ASEA	ETF	11.82	11.83	11.52	11.52	2800.0
2016-01-12	ASET	ETF	23.38	23.38	23.06	23.2	1100.0
2016-01-12	ASHR	ETF	24.19	24.31	23.95	24.19	1469700.0
2016-01-12	ASHS	ETF	33.21	33.41	32.69	33.26	68200.0
2016-01-12	ASHX	ETF	22.12	22.1373	22.12	22.1373	400.0
2016-01-12	ATMP	ETF	16.6	17.21	15.42	16.34	70300.0
2016-01-12	BAB	ETF	29.44	29.65	29.4	29.56	125772.0
2016-01-12	BAL	ETF	41.25	41.26	40.882	40.882	3320.0
2016-01-12	BBC	ETF	23.08	23.412	21.71	22.5199	8366.0
2016-01-12	BBH	ETF	113.16	115.96	110.05	113.58	113900.0
2016-01-12	BBP	ETF	26.49	26.86	25.26	26.168	14600.0
2016-01-12	BCM	ETF	22.2	22.3	22.2	22.3	635.0
2016-01-12	BDCZ	ETF	18.85	18.85	18.81	18.81	405.0

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

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