PREVIEW / etf_daily / 2017-12-05

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-05.parquet
  size:    59 KB
  rows:    1,520

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-12-05	SPY	ETF	263.19	265.15	263.04	263.19	77994500.0
2017-12-05	QQQ	ETF	152.64	154.55	152.1	152.81	40604211.0
2017-12-05	IWM	ETF	151.4	152.96	150.92	150.93	29667200.0
2017-12-05	DIA	ETF	243.78	243.79	241.77	242.01	4925600.0
2017-12-05	GLD	ETF	120.1	120.51	119.72	120.32	10041200.0
2017-12-05	TLT	ETF	126.47	127.5	126.45	127.24	10958900.0
2017-12-05	AADR	ETF	55.26	55.38	55.08	55.31	14500.0
2017-12-05	AAXJ	ETF	74.96	75.41	74.9	75.02	859800.0
2017-12-05	ACSI	ETF	31.06	31.08	30.8899	30.92	1728.0
2017-12-05	ACTX	ETF	67.8506	71.3906	59.5905	64.2516	490.0
2017-12-05	ACWF	ETF	30.4265	30.4699	30.2396	30.2396	1358.0
2017-12-05	ACWI	ETF	71.88	71.88	71.11	71.15	2596600.0
2017-12-05	ACWV	ETF	84.4	84.45	84.08	84.15	79900.0
2017-12-05	ACWX	ETF	49.25	49.38	49.135	49.16	535737.0
2017-12-05	ADRE	ETF	41.92	42.16	41.75	41.94	12347.0
2017-12-05	AFK	ETF	24.33	24.5	24.29	24.29	9109.0
2017-12-05	AFTY	ETF	18.581	18.65	18.581	18.626	17100.0
2017-12-05	AGG	ETF	109.26	109.26	109.08	109.26	2995500.0
2017-12-05	AGGY	ETF	50.64	50.76	50.63	50.76	53400.0
2017-12-05	AGNG	ETF	19.5	19.54	19.4	19.4	13000.0
2017-12-05	AGQ	ETF	31.1	31.1	30.45	30.81	173800.0
2017-12-05	AGZ	ETF	113.209	113.299	113.13	113.2445	33482.0
2017-12-05	AGZD	ETF	24.135	24.15	24.11	24.15	1600.0
2017-12-05	AIA	ETF	64.95	65.1599	64.73	64.76	66578.0
2017-12-05	AIEQ	ETF	25.56	25.586	25.32	25.32	92300.0
2017-12-05	AIRR	ETF	27.36	27.36	26.973	26.973	13000.0
2017-12-05	AIVI	ETF	43.25	43.38	43.15	43.21	4400.0
2017-12-05	ALTY	ETF	15.31	15.31	15.286	15.286	600.0
2017-12-05	AMJ	ETF	26.37	26.65	26.3138	26.36	3544358.0
2017-12-05	AMLP	ETF	52.35	52.55	51.9	52.0	2439920.0
2017-12-05	AMZA	ETF	82.7	83.01	81.7	81.9	71460.0
2017-12-05	ANGL	ETF	30.01	30.05	29.93	29.95	308800.0
2017-12-05	AOA	ETF	55.04	55.16	54.86	54.96	45400.0
2017-12-05	AOK	ETF	34.47	34.49	34.44	34.48	96133.0
2017-12-05	AOM	ETF	38.46	38.519	38.41	38.46	114579.0
2017-12-05	AOR	ETF	45.69	45.82	45.64	45.68	265889.0
2017-12-05	ARCM	ETF	100.2	100.2	100.2	100.2	50000.0
2017-12-05	ARGT	ETF	32.32	32.57	32.27	32.32	77600.0
2017-12-05	ARKG	ETF	25.16	25.37	24.67	24.69	18900.0
2017-12-05	ARKK	ETF	36.75	37.235	36.34	36.35	163100.0
2017-12-05	ARKQ	ETF	33.0	33.441	32.95	33.13	28400.0
2017-12-05	ARKW	ETF	44.45	45.165	44.22	44.33	99200.0
2017-12-05	ASEA	ETF	16.66	16.73	16.66	16.66	2100.0
2017-12-05	ASET	ETF	28.5757	28.5757	28.5757	28.5757	306.0
2017-12-05	ASHR	ETF	30.64	30.79	30.56	30.76	620200.0
2017-12-05	ASHS	ETF	33.6	33.81	33.47	33.56	9500.0
2017-12-05	ASHX	ETF	22.67	22.67	22.67	22.67	171.0
2017-12-05	ATMP	ETF	19.8	20.1	19.8	19.9	403200.0
2017-12-05	BAB	ETF	30.58	30.7	30.5566	30.66	108153.0
2017-12-05	BAL	ETF	47.95	48.26	47.95	48.099	2203.0

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

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