PREVIEW / etf_daily / 2018-02-13

all etf daily files

  file:    by_date/etf_daily/2018/2018-02-13.parquet
  size:    60 KB
  rows:    1,552

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
2018-02-13	SPY	ETF	263.97	266.62	263.31	266.0	81223600.0
2018-02-13	QQQ	ETF	157.98	160.01	157.7197	159.69	31785595.0
2018-02-13	IWM	ETF	147.38	148.79	146.9	148.48	25021200.0
2018-02-13	DIA	ETF	244.72	247.25	244.33	246.57	6234000.0
2018-02-13	GLD	ETF	125.67	126.18	125.52	126.08	5321300.0
2018-02-13	TLT	ETF	118.61	119.01	118.39	118.99	8157600.0
2018-02-13	AADR	ETF	58.29	58.45	57.93	58.22	31900.0
2018-02-13	AAXJ	ETF	75.39	76.09	75.33	75.96	1245400.0
2018-02-13	ACSI	ETF	30.38	30.539	30.38	30.539	1014.0
2018-02-13	ACTX	ETF	79.0607	79.0607	71.3906	75.5207	817.0
2018-02-13	ACWF	ETF	30.44	30.7	30.44	30.692	11146.0
2018-02-13	ACWI	ETF	71.36	71.87	71.21	71.75	1918000.0
2018-02-13	ACWV	ETF	82.03	82.71	81.92	82.55	139200.0
2018-02-13	ACWX	ETF	49.19	49.53	49.19	49.49	515514.0
2018-02-13	ADRE	ETF	43.75	44.29	43.75	44.2101	5765.0
2018-02-13	AFK	ETF	24.95	25.2405	24.95	25.1788	4311.0
2018-02-13	AFTY	ETF	18.21	18.28	18.14	18.28	11700.0
2018-02-13	AGG	ETF	106.79	106.91	106.7	106.82	4256200.0
2018-02-13	AGGY	ETF	49.27	49.36	49.22	49.32	49300.0
2018-02-13	AGNG	ETF	19.46	19.54	19.45	19.54	2500.0
2018-02-13	AGQ	ETF	32.01	32.29	31.71	32.13	104200.0
2018-02-13	AGZ	ETF	111.67	111.69	111.6102	111.63	11366.0
2018-02-13	AGZD	ETF	24.01	24.245	24.01	24.02	11600.0
2018-02-13	AIA	ETF	65.93	66.66	65.85	66.54	87580.0
2018-02-13	AIEQ	ETF	25.88	26.04	25.75	26.0	48500.0
2018-02-13	AIRR	ETF	25.67	25.749	25.62	25.744	15700.0
2018-02-13	AIVI	ETF	42.57	42.82	42.57	42.8	10700.0
2018-02-13	ALTY	ETF	14.66	14.76	14.66	14.76	1600.0
2018-02-13	AMJ	ETF	27.82	28.18	27.63	28.11	2077392.0
2018-02-13	AMLP	ETF	53.35	54.5	53.1	54.25	1603400.0
2018-02-13	AMUB	ETF	17.3	17.3	17.3	17.3	1200.0
2018-02-13	AMZA	ETF	81.8	83.49	81.6	83.3	112120.0
2018-02-13	ANGL	ETF	29.33	29.39	29.2	29.28	548900.0
2018-02-13	AOA	ETF	53.22	53.42	53.03	53.37	137600.0
2018-02-13	AOK	ETF	33.98	34.08	33.9601	34.07	51788.0
2018-02-13	AOM	ETF	37.43	37.55	37.38	37.54	137662.0
2018-02-13	AOR	ETF	44.21	44.42	44.14	44.32	126825.0
2018-02-13	ARCM	ETF	100.32	100.33	100.32	100.33	1100.0
2018-02-13	ARGT	ETF	34.99	35.3	34.79	35.19	105000.0
2018-02-13	ARKG	ETF	25.68	25.846	25.091	25.79	53200.0
2018-02-13	ARKK	ETF	38.6	39.33	38.53	39.272	258700.0
2018-02-13	ARKQ	ETF	33.54	33.719	33.328	33.65	20900.0
2018-02-13	ARKW	ETF	47.92	48.8	47.92	48.71	186000.0
2018-02-13	ASEA	ETF	17.6	17.6	17.33	17.51	2800.0
2018-02-13	ASET	ETF	27.139	27.39	27.12	27.3717	5204.0
2018-02-13	ASHR	ETF	30.73	31.08	30.6	31.05	1709300.0
2018-02-13	ASHS	ETF	32.7	33.0	32.55	33.0	19000.0
2018-02-13	ASHX	ETF	21.41	21.5	21.41	21.5	501.0
2018-02-13	ATMP	ETF	20.96	21.25	20.96	21.18	120500.0
2018-02-13	BAB	ETF	29.66	29.88	29.6	29.69	107567.0

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

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