PREVIEW / etf_daily / 2017-09-26

all etf daily files

  file:    by_date/etf_daily/2017/2017-09-26.parquet
  size:    56 KB
  rows:    1,445

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
2017-09-26	SPY	ETF	249.42	249.7	248.81	249.08	54082000.0
2017-09-26	QQQ	ETF	143.51	143.8	142.67	143.17	29628806.0
2017-09-26	IWM	ETF	144.29	145.15	144.18	144.61	28238100.0
2017-09-26	DIA	ETF	223.06	223.5	222.62	222.69	1314500.0
2017-09-26	GLD	ETF	123.57	123.81	122.9	123.14	8673600.0
2017-09-26	TLT	ETF	126.77	126.89	126.43	126.76	7251900.0
2017-09-26	AADR	ETF	54.79	54.79	54.03	54.16	53600.0
2017-09-26	AAXJ	ETF	71.82	71.89	71.47	71.54	912300.0
2017-09-26	ACSI	ETF	28.99	29.02	28.91	29.0	3711.0
2017-09-26	ACTX	ETF	72.2756	72.5707	66.0806	67.8506	287.0
2017-09-26	ACWF	ETF	28.7899	28.79	28.775	28.79	681.0
2017-09-26	ACWI	ETF	68.37	68.42	68.14	68.26	1015300.0
2017-09-26	ACWV	ETF	81.15	81.21	81.04	81.12	55300.0
2017-09-26	ACWX	ETF	47.99	48.045	47.82	47.97	387922.0
2017-09-26	ADRE	ETF	41.96	42.129	41.58	41.58	12383.0
2017-09-26	AFK	ETF	23.43	23.51	23.2	23.23	5365.0
2017-09-26	AFTY	ETF	16.99	16.99	16.99	16.99	300.0
2017-09-26	AGG	ETF	109.95	110.02	109.88	109.99	2749900.0
2017-09-26	AGGY	ETF	50.75	50.85	50.74	50.79	136700.0
2017-09-26	AGNG	ETF	19.23	19.23	19.12	19.12	2900.0
2017-09-26	AGQ	ETF	34.47	34.47	33.73	33.93	167100.0
2017-09-26	AGZ	ETF	113.8	113.98	113.8	113.96	22907.0
2017-09-26	AGZD	ETF	24.02	24.03	23.975	23.975	2200.0
2017-09-26	AIA	ETF	61.01	61.08	60.78	60.89	19184.0
2017-09-26	AIRR	ETF	25.24	25.63	25.24	25.49	28000.0
2017-09-26	AIVI	ETF	42.64	42.64	42.48	42.59	16000.0
2017-09-26	ALTY	ETF	15.76	15.76	15.67	15.71	5200.0
2017-09-26	AMJ	ETF	28.4	28.53	28.24	28.45	1245235.0
2017-09-26	AMLP	ETF	56.8	57.05	56.15	56.7	1126840.0
2017-09-26	AMZA	ETF	94.0	94.0	92.8	93.7	120650.0
2017-09-26	ANGL	ETF	30.25	30.28	30.2	30.21	735700.0
2017-09-26	AOA	ETF	53.26	53.29	53.12	53.19	31800.0
2017-09-26	AOK	ETF	34.44	34.4599	34.38	34.43	84306.0
2017-09-26	AOM	ETF	37.87	37.91	37.81	37.81	153819.0
2017-09-26	AOR	ETF	44.66	44.66	44.53	44.58	62802.0
2017-09-26	ARGT	ETF	31.21	31.36	31.07	31.09	71700.0
2017-09-26	ARKG	ETF	25.54	25.71	25.271	25.35	13500.0
2017-09-26	ARKK	ETF	33.59	33.816	33.24	33.25	49900.0
2017-09-26	ARKQ	ETF	30.82	31.239	30.82	31.022	13300.0
2017-09-26	ARKW	ETF	39.98	40.2	39.51	39.57	27200.0
2017-09-26	ASEA	ETF	15.62	15.62	15.57	15.58	2900.0
2017-09-26	ASHR	ETF	29.12	29.12	29.02	29.04	1096500.0
2017-09-26	ASHS	ETF	36.08	36.08	35.95	35.95	7100.0
2017-09-26	ASHX	ETF	21.52	21.52	21.49	21.49	5900.0
2017-09-26	ATMP	ETF	21.44	21.62	21.4	21.55	13100.0
2017-09-26	BAB	ETF	30.59	30.609	30.54	30.6	41751.0
2017-09-26	BAL	ETF	45.46	45.56	45.38	45.4208	2318.0
2017-09-26	BAR	ETF	13.025	13.025	13.006	13.006	7260.0
2017-09-26	BBC	ETF	28.62	28.62	27.72	27.74	10254.0
2017-09-26	BBH	ETF	134.28	134.87	133.06	133.12	13000.0

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

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