PREVIEW / etf_daily / 2019-06-20

all etf daily files

  file:    by_date/etf_daily/2019/2019-06-20.parquet
  size:    70 KB
  rows:    1,819

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-06-20	SPY	ETF	296.04	296.31	293.13	295.86	116570000.0
2019-06-20	QQQ	ETF	189.72	189.76	187.1585	188.85	40921964.0
2019-06-20	IWM	ETF	156.05	156.22	154.44	155.29	17595700.0
2019-06-20	DIA	ETF	268.05	268.5	265.9	268.08	3471800.0
2019-06-20	GLD	ETF	130.41	131.49	130.19	131.11	18636300.0
2019-06-20	TLT	ETF	132.91	133.51	132.59	132.89	10721500.0
2019-06-20	AAAU	ETF	13.8	13.92	13.8	13.89	196900.0
2019-06-20	AADR	ETF	49.83	49.99	49.57	49.79	3400.0
2019-06-20	AAXJ	ETF	69.93	70.04	69.38	69.66	1022200.0
2019-06-20	ACES	ETF	29.423	29.423	29.314	29.414	3700.0
2019-06-20	ACSI	ETF	33.95	33.95	33.78	33.9348	675.0
2019-06-20	ACTX	ETF	17.8182	26.5502	17.8182	25.1637	659.0
2019-06-20	ACWF	ETF	29.0402	29.165	29.0402	29.1647	2796.0
2019-06-20	ACWI	ETF	73.97	74.07	73.48	73.94	1740500.0
2019-06-20	ACWV	ETF	93.0	93.01	92.45	92.75	475000.0
2019-06-20	ACWX	ETF	46.93	46.985	46.655	46.85	1043053.0
2019-06-20	ADRE	ETF	40.22	40.385	40.0761	40.25	9470.0
2019-06-20	AFIF	ETF	9.88	9.89	9.84	9.85	42235.0
2019-06-20	AFK	ETF	21.83	22.2	21.8069	22.1711	22032.0
2019-06-20	AFTY	ETF	17.63	17.668	17.54	17.61	4900.0
2019-06-20	AGG	ETF	111.39	111.57	111.34	111.41	4224300.0
2019-06-20	AGGY	ETF	51.3	51.37	51.24	51.3	416300.0
2019-06-20	AGNG	ETF	21.6	21.79	21.6	21.79	5100.0
2019-06-20	AGQ	ETF	24.97	25.43	24.84	25.17	794900.0
2019-06-20	AGZ	ETF	115.41	115.464	115.26	115.27	718063.0
2019-06-20	AGZD	ETF	23.815	23.855	23.79	23.845	19200.0
2019-06-20	AIA	ETF	61.17	61.17	60.6987	60.86	75750.0
2019-06-20	AIEQ	ETF	26.38	26.499	26.28	26.43	29400.0
2019-06-20	AIQ	ETF	16.42	16.474	16.3305	16.45	8696.0
2019-06-20	AIRR	ETF	25.55	25.87	25.55	25.83	9500.0
2019-06-20	AIVI	ETF	41.6	41.64	41.46	41.6	5600.0
2019-06-20	ALTY	ETF	14.975	14.995	14.92	14.96	6900.0
2019-06-20	AMJ	ETF	24.78	24.95	24.64	24.76	1112844.0
2019-06-20	AMLP	ETF	48.9	49.2	48.55	48.75	3885180.0
2019-06-20	AMOM	ETF	26.19	26.295	26.19	26.295	500.0
2019-06-20	AMUB	ETF	15.5707	15.5707	15.5707	15.5707	1.0
2019-06-20	AMZA	ETF	54.5	55.05	54.31	54.6	69730.0
2019-06-20	ANGL	ETF	29.2	29.3	29.17	29.24	280000.0
2019-06-20	AOA	ETF	55.23	55.26	54.94	55.24	43300.0
2019-06-20	AOK	ETF	35.37	35.48	35.36	35.42	62817.0
2019-06-20	AOM	ETF	39.12	39.1698	39.02	39.08	78129.0
2019-06-20	AOR	ETF	46.08	46.12	45.9	46.07	116379.0
2019-06-20	ARCM	ETF	100.26	100.26	100.26	100.26	100.0
2019-06-20	ARGT	ETF	32.35	32.4	31.84	32.18	62000.0
2019-06-20	ARKF	ETF	22.84	22.905	22.645	22.794	13800.0
2019-06-20	ARKG	ETF	32.87	32.98	32.17	32.49	136400.0
2019-06-20	ARKK	ETF	45.89	46.02	45.03	45.33	208700.0
2019-06-20	ARKQ	ETF	32.39	32.411	32.135	32.322	11000.0
2019-06-20	ARKW	ETF	52.0	52.425	51.4	51.83	75000.0
2019-06-20	ASEA	ETF	16.91	17.09	16.79	16.79	4900.0

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

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