PREVIEW / etf_daily / 2019-03-18

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-18.parquet
  size:    68 KB
  rows:    1,755

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
2019-03-18	SPY	ETF	281.55	282.66	281.3	282.33	62199800.0
2019-03-18	QQQ	ETF	177.95	178.99	177.5915	178.45	32935125.0
2019-03-18	IWM	ETF	155.06	156.45	154.48	155.75	24510200.0
2019-03-18	DIA	ETF	257.94	259.12	257.71	258.99	2786200.0
2019-03-18	GLD	ETF	123.3	123.4	122.89	123.04	7783200.0
2019-03-18	TLT	ETF	121.57	121.87	121.52	121.68	3893300.0
2019-03-18	AAAU	ETF	13.04	13.04	13.01	13.02	10300.0
2019-03-18	AADR	ETF	45.91	46.14	45.79	46.0	12400.0
2019-03-18	AAXJ	ETF	70.77	70.98	70.64	70.96	1053200.0
2019-03-18	ACES	ETF	27.4	27.47	27.266	27.295	7900.0
2019-03-18	ACSI	ETF	32.6528	32.7402	32.6528	32.7402	869.0
2019-03-18	ACTX	ETF	56.0505	56.0505	51.3305	52.5105	905.0
2019-03-18	ACWF	ETF	29.29	29.35	29.1832	29.34	10021.0
2019-03-18	ACWI	ETF	72.16	72.46	72.12	72.46	1392000.0
2019-03-18	ACWV	ETF	88.69	88.79	88.43	88.63	412200.0
2019-03-18	ACWX	ETF	46.6	46.78	46.5655	46.78	1104055.0
2019-03-18	ADRE	ETF	41.54	41.7176	41.42	41.5585	5160.0
2019-03-18	AFIF	ETF	10.0	10.03	9.99	10.01	15043.0
2019-03-18	AFK	ETF	21.8	21.81	21.7777	21.78	8151.0
2019-03-18	AFTY	ETF	16.73	16.829	16.73	16.76	11900.0
2019-03-18	AGG	ETF	107.67	107.7	107.63	107.68	2295500.0
2019-03-18	AGGY	ETF	49.26	49.28	49.2	49.27	90400.0
2019-03-18	AGNG	ETF	22.015	22.015	21.511	21.702	1400.0
2019-03-18	AGQ	ETF	25.39	25.56	25.23	25.3	80300.0
2019-03-18	AGZ	ETF	112.5	112.59	112.5	112.59	13556.0
2019-03-18	AGZD	ETF	23.895	23.925	23.845	23.925	5600.0
2019-03-18	AIA	ETF	61.44	61.66	61.4	61.66	15095.0
2019-03-18	AIEQ	ETF	25.95	26.1	25.92	26.07	29300.0
2019-03-18	AIQ	ETF	15.65	15.67	15.47	15.55	102503.0
2019-03-18	AIRR	ETF	24.87	25.21	24.87	25.21	6800.0
2019-03-18	AIVI	ETF	41.71	41.9	41.71	41.89	5900.0
2019-03-18	ALTY	ETF	14.78	14.8	14.774	14.791	5000.0
2019-03-18	AMJ	ETF	25.18	25.47	25.06	25.46	797680.0
2019-03-18	AMLP	ETF	49.55	50.2	49.3	50.05	2461920.0
2019-03-18	AMUB	ETF	16.0249	16.0249	16.0249	16.0249	0.0
2019-03-18	AMZA	ETF	59.6	60.7	59.4	60.4	83600.0
2019-03-18	ANGL	ETF	28.56	28.6	28.56	28.58	306000.0
2019-03-18	AOA	ETF	53.43	53.61	53.42	53.57	420200.0
2019-03-18	AOK	ETF	34.27	34.34	34.2301	34.34	47912.0
2019-03-18	AOM	ETF	37.79	37.93	37.79	37.92	712236.0
2019-03-18	AOR	ETF	44.54	44.7	44.535	44.69	567548.0
2019-03-18	ARGT	ETF	28.62	28.96	28.59	28.92	87500.0
2019-03-18	ARKF	ETF	21.5	21.577	21.37	21.5	72400.0
2019-03-18	ARKG	ETF	32.87	33.21	32.48	32.84	178100.0
2019-03-18	ARKK	ETF	47.0	47.42	46.39	46.85	289900.0
2019-03-18	ARKQ	ETF	33.91	34.213	33.826	33.97	9600.0
2019-03-18	ARKW	ETF	51.63	51.99	51.2	51.56	183400.0
2019-03-18	ASEA	ETF	15.94	16.03	15.94	16.03	1400.0
2019-03-18	ASET	ETF	28.9	28.9	28.8902	28.8902	805.0
2019-03-18	ASHR	ETF	28.82	28.88	28.72	28.78	11715300.0

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

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