PREVIEW / etf_daily / 2017-07-10

all etf daily files

  file:    by_date/etf_daily/2017/2017-07-10.parquet
  size:    56 KB
  rows:    1,431

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-07-10	SPY	ETF	242.11	242.8	241.76	242.37	36663300.0
2017-07-10	QQQ	ETF	137.84	138.985	137.5	138.66	24853545.0
2017-07-10	IWM	ETF	139.92	140.89	139.37	139.88	17206000.0
2017-07-10	DIA	ETF	213.68	214.35	213.54	213.99	1156300.0
2017-07-10	GLD	ETF	115.02	115.57	114.83	115.47	4970900.0
2017-07-10	TLT	ETF	122.87	123.1	122.68	122.9	3859200.0
2017-07-10	AADR	ETF	47.03	47.46	47.03	47.44	3700.0
2017-07-10	AAXJ	ETF	66.99	67.52	66.99	67.44	783800.0
2017-07-10	ACSI	ETF	28.5	28.56	28.47	28.47	22220.0
2017-07-10	ACTX	ETF	92.0408	95.5809	88.5008	91.4508	333.0
2017-07-10	ACWF	ETF	27.36	27.38	27.28	27.28	4150.0
2017-07-10	ACWI	ETF	65.36	65.57	65.29	65.5	761900.0
2017-07-10	ACWV	ETF	78.49	78.65	78.46	78.51	198100.0
2017-07-10	ACWX	ETF	45.34	45.549	45.33	45.53	194053.0
2017-07-10	ADRE	ETF	38.29	38.88	38.29	38.868	8889.0
2017-07-10	AFK	ETF	21.45	21.49	21.45	21.48	2120.0
2017-07-10	AFTY	ETF	15.3	15.3	15.3	15.3	1500.0
2017-07-10	AGG	ETF	108.97	109.02	108.89	108.95	2386400.0
2017-07-10	AGGY	ETF	50.25	50.32	50.22	50.31	25500.0
2017-07-10	AGNG	ETF	19.09	19.09	18.66	18.66	2400.0
2017-07-10	AGQ	ETF	28.64	30.18	28.47	29.98	255000.0
2017-07-10	AGZ	ETF	113.19	113.57	113.19	113.43	22028.0
2017-07-10	AGZD	ETF	24.015	24.02	23.97	24.02	27800.0
2017-07-10	AIA	ETF	56.57	56.98	56.57	56.98	55041.0
2017-07-10	AIQ	ETF	13.2	13.25	13.2	13.25	8796.0
2017-07-10	AIRR	ETF	23.53	23.867	23.53	23.73	43600.0
2017-07-10	AIVI	ETF	40.4	40.61	40.4	40.58	6000.0
2017-07-10	ALTY	ETF	15.43	15.43	15.4	15.4	1000.0
2017-07-10	AMJ	ETF	29.69	29.76	29.36	29.47	6693357.0
2017-07-10	AMLP	ETF	59.65	59.75	59.15	59.35	2083620.0
2017-07-10	AMZA	ETF	95.7	96.0	94.3	95.0	79280.0
2017-07-10	ANGL	ETF	29.34	29.36	29.26	29.31	797500.0
2017-07-10	AOA	ETF	51.37	51.39	51.21	51.34	56900.0
2017-07-10	AOK	ETF	33.73	33.79	33.6601	33.77	49038.0
2017-07-10	AOM	ETF	36.87	36.9691	36.86	36.95	88130.0
2017-07-10	AOR	ETF	43.18	43.31	43.15	43.27	123007.0
2017-07-10	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-10	ARGT	ETF	29.3	29.45	29.25	29.33	43600.0
2017-07-10	ARKG	ETF	22.28	22.32	21.82	21.889	16800.0
2017-07-10	ARKK	ETF	28.71	28.959	28.336	28.54	57500.0
2017-07-10	ARKQ	ETF	28.0	28.37	27.95	28.32	13800.0
2017-07-10	ARKW	ETF	34.94	35.19	34.851	35.17	27700.0
2017-07-10	ASEA	ETF	15.05	15.09	15.01	15.09	700.0
2017-07-10	ASET	ETF	26.99	27.02	26.985	27.0	1271.0
2017-07-10	ASHR	ETF	27.15	27.15	27.1	27.13	175800.0
2017-07-10	ASHS	ETF	33.2	33.32	33.2	33.32	3000.0
2017-07-10	ASHX	ETF	20.7319	20.7319	20.7319	20.7319	210.0
2017-07-10	ATMP	ETF	22.18	22.29	22.18	22.24	16200.0
2017-07-10	BAB	ETF	29.91	29.98	29.89	29.97	66111.0
2017-07-10	BAL	ETF	45.38	45.38	44.48	44.59	7671.0

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

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