PREVIEW / etf_daily / 2018-04-02

all etf daily files

  file:    by_date/etf_daily/2018/2018-04-02.parquet
  size:    61 KB
  rows:    1,564

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-04-02	SPY	ETF	262.55	263.13	254.67	257.47	186286300.0
2018-04-02	QQQ	ETF	159.0	159.74	153.88	155.51	85549443.0
2018-04-02	IWM	ETF	151.52	152.07	147.18	148.13	35040700.0
2018-04-02	DIA	ETF	240.33	241.03	233.2	236.15	9217400.0
2018-04-02	GLD	ETF	126.65	127.54	126.38	127.26	11421100.0
2018-04-02	TLT	ETF	121.35	122.36	121.16	121.88	12036500.0
2018-04-02	AADR	ETF	58.96	58.96	57.12	57.31	16500.0
2018-04-02	AAXJ	ETF	77.12	77.33	75.45	76.08	377200.0
2018-04-02	ACSI	ETF	30.65	30.65	29.815	29.945	827.0
2018-04-02	ACTX	ETF	57.5255	63.7206	53.1005	53.6905	2253.0
2018-04-02	ACWF	ETF	30.6838	30.6838	30.0847	30.3157	13071.0
2018-04-02	ACWI	ETF	71.39	71.53	69.67	70.26	3336500.0
2018-04-02	ACWV	ETF	83.65	83.98	82.11	82.59	132200.0
2018-04-02	ACWX	ETF	49.6	49.66	48.665	49.0	860312.0
2018-04-02	ADRE	ETF	44.29	44.316	43.255	43.5053	3655.0
2018-04-02	AFK	ETF	25.7	25.735	25.0684	25.16	3732.0
2018-04-02	AFTY	ETF	17.092	17.13	17.09	17.11	2000.0
2018-04-02	AGG	ETF	106.9	107.04	106.82	106.9	7280300.0
2018-04-02	AGGY	ETF	49.26	49.345	49.211	49.29	60100.0
2018-04-02	AGNG	ETF	19.29	19.32	19.282	19.312	1900.0
2018-04-02	AGQ	ETF	31.98	32.3	31.78	32.1	185900.0
2018-04-02	AGZ	ETF	111.85	112.019	111.84	111.9101	10201.0
2018-04-02	AIA	ETF	67.62	67.68	66.04	66.55	96322.0
2018-04-02	AIEQ	ETF	25.93	26.0	25.19	25.4	83800.0
2018-04-02	AIRR	ETF	25.95	25.95	25.105	25.31	96600.0
2018-04-02	AIVI	ETF	43.05	43.11	42.46	42.73	7200.0
2018-04-02	ALTY	ETF	14.46	14.482	14.41	14.43	4600.0
2018-04-02	AMJ	ETF	23.89	24.25	23.51	23.79	2143756.0
2018-04-02	AMLP	ETF	46.75	47.5	45.9	46.5	3269820.0
2018-04-02	AMZA	ETF	68.4	69.3	66.95	67.9	163050.0
2018-04-02	ANGL	ETF	28.83	28.9	28.76	28.84	292900.0
2018-04-02	AOA	ETF	53.35	53.41	52.38	52.7	72100.0
2018-04-02	AOK	ETF	34.19	34.19	33.9501	34.05	92182.0
2018-04-02	AOM	ETF	37.7	37.7	37.33	37.46	108547.0
2018-04-02	AOR	ETF	44.5	44.5	43.8	44.06	166596.0
2018-04-02	ARGT	ETF	35.64	35.69	35.18	35.42	15400.0
2018-04-02	ARKG	ETF	25.97	25.97	24.63	24.86	133700.0
2018-04-02	ARKK	ETF	38.73	38.989	37.4	37.81	593600.0
2018-04-02	ARKQ	ETF	32.66	32.66	31.6	31.85	48600.0
2018-04-02	ARKW	ETF	49.33	49.64	47.89	48.41	388100.0
2018-04-02	ASEA	ETF	17.8	17.92	17.51	17.7	8800.0
2018-04-02	ASET	ETF	27.26	27.27	27.26	27.27	276.0
2018-04-02	ASHR	ETF	30.9	30.93	30.4	30.55	1142000.0
2018-04-02	ASHS	ETF	35.59	35.59	34.8	34.83	6700.0
2018-04-02	ATMP	ETF	18.02	18.45	17.91	18.04	78000.0
2018-04-02	BAB	ETF	29.99	30.1399	29.96	30.12	186967.0
2018-04-02	BAL	ETF	53.85	53.97	53.34	53.34	3377.0
2018-04-02	BAR	ETF	13.399	13.399	13.399	13.399	2160.0
2018-04-02	BBC	ETF	31.91	31.91	30.4232	30.6749	33768.0
2018-04-02	BBH	ETF	118.7	119.53	114.57	115.82	32400.0

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

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