PREVIEW / etf_daily / 2017-07-27

all etf daily files

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

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-27	SPY	ETF	247.96	248.0	245.68	247.2	70766600.0
2017-07-27	QQQ	ETF	145.86	145.96	142.3	143.96	80665866.0
2017-07-27	IWM	ETF	143.48	143.68	141.55	142.34	24355800.0
2017-07-27	DIA	ETF	217.28	217.75	216.63	217.72	3202400.0
2017-07-27	GLD	ETF	120.1	120.14	119.28	119.79	6385200.0
2017-07-27	TLT	ETF	123.11	123.38	122.82	123.16	6390800.0
2017-07-27	AADR	ETF	49.76	49.87	48.72	49.0	37200.0
2017-07-27	AAXJ	ETF	71.4	71.49	70.4	70.75	4569800.0
2017-07-27	ACSI	ETF	29.07	29.12	28.999	29.06	11102.0
2017-07-27	ACTX	ETF	78.4117	78.4117	70.8006	76.5827	437.0
2017-07-27	ACWF	ETF	28.11	28.11	27.91	27.91	1750.0
2017-07-27	ACWI	ETF	67.59	67.59	66.91	67.27	1594100.0
2017-07-27	ACWV	ETF	80.34	80.38	80.12	80.27	189400.0
2017-07-27	ACWX	ETF	47.34	47.34	46.89	47.09	614388.0
2017-07-27	ADRE	ETF	41.55	41.7	40.8731	41.12	9120.0
2017-07-27	AFK	ETF	23.5	23.5139	23.23	23.27	12629.0
2017-07-27	AFTY	ETF	16.18	16.18	16.1	16.11	1900.0
2017-07-27	AGG	ETF	109.51	109.59	109.43	109.48	1868600.0
2017-07-27	AGGY	ETF	50.59	50.595	50.537	50.537	10500.0
2017-07-27	AGNG	ETF	19.058	19.064	18.881	18.881	1400.0
2017-07-27	AGQ	ETF	34.2	34.3	33.33	33.47	138900.0
2017-07-27	AGZ	ETF	113.67	113.82	113.628	113.65	7575.0
2017-07-27	AGZD	ETF	24.11	24.11	23.97	23.97	2600.0
2017-07-27	AIA	ETF	60.79	60.79	60.0084	60.38	53369.0
2017-07-27	AIQ	ETF	13.2	13.25	13.2	13.25	13780.0
2017-07-27	AIRR	ETF	24.056	24.14	23.95	24.08	17400.0
2017-07-27	AIVI	ETF	41.91	41.95	41.64	41.77	100700.0
2017-07-27	ALTY	ETF	15.74	15.75	15.667	15.75	4900.0
2017-07-27	AMJ	ETF	30.05	30.1	29.84	29.96	1249559.0
2017-07-27	AMLP	ETF	60.05	60.2	59.75	59.85	1400120.0
2017-07-27	AMZA	ETF	97.0	97.19	96.6	97.0	84090.0
2017-07-27	ANGL	ETF	29.97	29.99	29.9	29.97	290400.0
2017-07-27	AOA	ETF	52.59	52.65	52.3	52.47	69600.0
2017-07-27	AOK	ETF	34.2	34.21	34.1	34.14	58282.0
2017-07-27	AOM	ETF	37.58	37.58	37.359	37.4	49740.0
2017-07-27	AOR	ETF	44.15	44.18	43.93	44.03	65021.0
2017-07-27	ARCM	ETF	100.05	100.05	100.05	100.05	20.0
2017-07-27	ARGT	ETF	29.88	29.99	29.62	29.83	43400.0
2017-07-27	ARKG	ETF	22.757	22.94	22.191	22.36	11600.0
2017-07-27	ARKK	ETF	30.42	30.42	29.44	29.83	86500.0
2017-07-27	ARKQ	ETF	30.09	30.16	29.3	29.64	45700.0
2017-07-27	ARKW	ETF	37.52	37.8	36.53	36.99	57700.0
2017-07-27	ASEA	ETF	15.5	15.5	15.39	15.49	4400.0
2017-07-27	ASET	ETF	27.77	27.7816	27.77	27.7816	1169.0
2017-07-27	ASHR	ETF	27.99	27.99	27.81	27.9	294100.0
2017-07-27	ASHS	ETF	33.47	33.6	33.42	33.43	14000.0
2017-07-27	ASHX	ETF	21.02	21.02	21.02	21.02	100.0
2017-07-27	ATMP	ETF	22.94	22.94	22.64	22.75	45800.0
2017-07-27	BAB	ETF	29.94	29.97	29.9	29.94	48249.0
2017-07-27	BAL	ETF	45.8898	45.93	45.26	45.39	11664.0

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

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