PREVIEW / etf_daily / 2017-04-18

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-18.parquet
  size:    55 KB
  rows:    1,394

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-04-18	SPY	ETF	233.72	234.49	233.08	233.87	83225800.0
2017-04-18	QQQ	ETF	131.01	131.66	130.95	131.28	12841087.0
2017-04-18	IWM	ETF	134.72	135.46	134.16	135.32	24553300.0
2017-04-18	DIA	ETF	205.36	205.81	204.42	205.08	2497900.0
2017-04-18	GLD	ETF	122.43	123.03	121.73	122.82	10903700.0
2017-04-18	TLT	ETF	123.86	124.98	123.55	124.7	11529700.0
2017-04-18	AADR	ETF	46.39	46.39	46.0	46.13	5200.0
2017-04-18	AAXJ	ETF	62.38	62.49	62.16	62.36	1535300.0
2017-04-18	ACSI	ETF	27.9799	27.9799	27.8099	27.9032	400.0
2017-04-18	ACTX	ETF	111.806	118.0011	99.5929	102.6609	1646.0
2017-04-18	ACWF	ETF	25.5993	25.5993	25.5711	25.5711	314.0
2017-04-18	ACWI	ETF	62.75	62.91	62.57	62.77	1750800.0
2017-04-18	ACWV	ETF	77.4	77.59	77.37	77.54	159600.0
2017-04-18	ACWX	ETF	43.26	43.33	43.13	43.3	1769303.0
2017-04-18	ADRE	ETF	36.38	36.4027	36.264	36.33	5091.0
2017-04-18	AFK	ETF	21.56	21.56	21.11	21.11	5318.0
2017-04-18	AFTY	ETF	13.63	13.63	13.61	13.61	3500.0
2017-04-18	AGG	ETF	109.41	109.7	109.39	109.65	2369500.0
2017-04-18	AGGY	ETF	50.44	50.64	50.43	50.5	92800.0
2017-04-18	AGNG	ETF	17.103	17.103	17.103	17.103	200.0
2017-04-18	AGQ	ETF	41.94	42.05	40.47	41.57	266100.0
2017-04-18	AGZ	ETF	113.7	113.8881	113.66	113.76	1314974.0
2017-04-18	AGZD	ETF	24.025	24.025	24.0	24.005	22200.0
2017-04-18	AIA	ETF	51.9	51.9	51.66	51.73	86235.0
2017-04-18	AIQ	ETF	12.9	12.95	12.85	12.9	191428.0
2017-04-18	AIRR	ETF	23.41	23.65	23.341	23.61	50100.0
2017-04-18	AIVI	ETF	38.95	39.1	38.83	39.05	10400.0
2017-04-18	ALTY	ETF	15.68	15.68	15.571	15.6	5900.0
2017-04-18	AMJ	ETF	31.76	32.12	31.76	32.01	704365.0
2017-04-18	AMLP	ETF	63.0	63.25	62.85	63.15	826380.0
2017-04-18	AMZA	ETF	105.0	105.5	104.6	105.2	39270.0
2017-04-18	ANGL	ETF	29.54	29.55	29.43	29.54	182100.0
2017-04-18	AOA	ETF	49.55	49.63	49.43	49.61	81400.0
2017-04-18	AOK	ETF	33.34	33.44	33.34	33.43	60075.0
2017-04-18	AOM	ETF	36.25	36.39	36.25	36.38	62185.0
2017-04-18	AOR	ETF	42.07	42.21	42.07	42.2	171007.0
2017-04-18	ARCM	ETF	100.0	100.0	100.0	100.0	4000.0
2017-04-18	ARGT	ETF	28.86	28.98	28.73	28.8	47700.0
2017-04-18	ARKG	ETF	20.32	20.32	19.963	19.963	600.0
2017-04-18	ARKK	ETF	24.14	24.16	24.08	24.16	12300.0
2017-04-18	ARKQ	ETF	24.74	24.92	24.72	24.92	5600.0
2017-04-18	ARKW	ETF	29.08	29.25	29.08	29.25	7200.0
2017-04-18	ASEA	ETF	14.39	14.39	14.22	14.35	5700.0
2017-04-18	ASET	ETF	26.8332	26.9	26.8332	26.9	1616.0
2017-04-18	ASHR	ETF	25.05	25.05	24.93	24.96	999700.0
2017-04-18	ASHS	ETF	33.92	33.92	33.69	33.73	7300.0
2017-04-18	ASHX	ETF	19.4009	19.4009	19.4009	19.4009	500.0
2017-04-18	ATMP	ETF	23.54	23.7	23.49	23.57	49300.0
2017-04-18	BAB	ETF	29.6	29.7324	29.59	29.73	82091.0
2017-04-18	BAL	ETF	49.59	49.8813	49.59	49.708	5416.0

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

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