PREVIEW / etf_daily / 2017-07-07

all etf daily files

  file:    by_date/etf_daily/2017/2017-07-07.parquet
  size:    55 KB
  rows:    1,410

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-07	SPY	ETF	241.21	242.28	240.56	242.11	57972300.0
2017-07-07	QQQ	ETF	136.74	138.13	136.74	137.76	36970402.0
2017-07-07	IWM	ETF	139.43	140.68	139.18	140.49	20511000.0
2017-07-07	DIA	ETF	213.54	214.16	213.42	214.05	1326500.0
2017-07-07	GLD	ETF	115.78	115.79	114.8	115.28	11153600.0
2017-07-07	TLT	ETF	122.84	123.03	122.59	122.72	9401800.0
2017-07-07	AADR	ETF	46.97	47.03	46.54	47.03	4000.0
2017-07-07	AAXJ	ETF	67.0	67.08	66.72	66.99	497700.0
2017-07-07	ACSI	ETF	28.59	28.59	28.57	28.5799	3211.0
2017-07-07	ACTX	ETF	99.1209	99.1209	90.2708	92.9258	194.0
2017-07-07	ACWI	ETF	65.09	65.4	65.06	65.34	2179200.0
2017-07-07	ACWV	ETF	78.37	78.57	78.23	78.54	99900.0
2017-07-07	ACWX	ETF	45.29	45.41	45.17	45.39	280745.0
2017-07-07	ADRE	ETF	38.29	38.42	38.26	38.39	2020.0
2017-07-07	AFK	ETF	21.4893	21.4893	21.3601	21.45	1957.0
2017-07-07	AGG	ETF	108.89	108.95	108.83	108.9	2727400.0
2017-07-07	AGGY	ETF	50.25	51.42	50.18	50.19	196600.0
2017-07-07	AGNG	ETF	18.81	18.81	18.705	18.78	6100.0
2017-07-07	AGQ	ETF	30.65	30.7	28.85	29.72	411700.0
2017-07-07	AGZ	ETF	113.22	113.55	113.16	113.39	28594.0
2017-07-07	AGZD	ETF	23.965	23.98	23.96	23.975	21600.0
2017-07-07	AIA	ETF	56.38	56.63	56.32	56.59	28626.0
2017-07-07	AIQ	ETF	13.25	13.25	13.2	13.2	7369.0
2017-07-07	AIRR	ETF	23.57	23.749	23.41	23.73	111600.0
2017-07-07	AIVI	ETF	40.44	40.54	40.29	40.54	7800.0
2017-07-07	ALTY	ETF	15.36	15.39	15.345	15.39	2600.0
2017-07-07	AMJ	ETF	29.53	29.77	29.24	29.73	1785061.0
2017-07-07	AMLP	ETF	59.35	59.8	58.9	59.65	3028640.0
2017-07-07	AMZA	ETF	95.1	95.9	93.7	95.7	89230.0
2017-07-07	ANGL	ETF	29.38	29.41	29.28	29.36	1347400.0
2017-07-07	AOA	ETF	51.12	51.28	51.06	51.26	37900.0
2017-07-07	AOK	ETF	33.69	33.74	33.55	33.67	53028.0
2017-07-07	AOM	ETF	36.85	36.9098	36.81	36.9	70659.0
2017-07-07	AOR	ETF	43.14	43.2	43.0754	43.18	60044.0
2017-07-07	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-07	ARGT	ETF	29.36	29.38	29.21	29.29	16100.0
2017-07-07	ARKG	ETF	22.09	22.36	22.09	22.2	70300.0
2017-07-07	ARKK	ETF	28.5	28.75	28.465	28.58	105100.0
2017-07-07	ARKQ	ETF	27.78	28.0	27.78	27.96	10700.0
2017-07-07	ARKW	ETF	34.42	34.88	34.42	34.86	73800.0
2017-07-07	ASEA	ETF	15.08	15.09	15.0	15.07	3000.0
2017-07-07	ASET	ETF	26.9699	26.97	26.9699	26.97	760.0
2017-07-07	ASHR	ETF	27.05	27.17	27.05	27.16	211700.0
2017-07-07	ASHS	ETF	33.33	33.4	33.33	33.35	2800.0
2017-07-07	ATMP	ETF	22.23	22.38	22.02	22.36	25000.0
2017-07-07	BAB	ETF	29.87	29.905	29.84	29.89	53151.0
2017-07-07	BAL	ETF	45.35	45.39	44.8	45.1	2254.0
2017-07-07	BBC	ETF	24.75	24.8899	24.62	24.73	8605.0
2017-07-07	BBH	ETF	125.88	126.43	125.67	125.94	18000.0
2017-07-07	BBP	ETF	40.18	40.19	40.02	40.02	2600.0

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

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