PREVIEW / etf_daily / 2020-07-16

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-16.parquet
  size:    77 KB
  rows:    2,042

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
2020-07-16	SPY	ETF	319.79	321.28	319.09	320.79	54622500.0
2020-07-16	QQQ	ETF	257.97	259.78	255.62	259.12	47594111.0
2020-07-16	IWM	ETF	146.11	146.67	144.88	146.16	30530800.0
2020-07-16	DIA	ETF	267.16	268.93	266.02	267.47	2478100.0
2020-07-16	GLD	ETF	169.8	170.0	168.65	168.73	10242400.0
2020-07-16	TLT	ETF	167.4	167.77	167.04	167.13	9107400.0
2020-07-16	AAAU	ETF	18.01	18.03	17.89	17.9	498200.0
2020-07-16	AADR	ETF	55.96	56.13	55.81	56.04	3200.0
2020-07-16	AAXJ	ETF	73.22	73.59	72.96	73.45	1207200.0
2020-07-16	ABEQ	ETF	22.69	22.713	22.69	22.713	800.0
2020-07-16	ACES	ETF	45.37	45.44	44.83	44.99	48600.0
2020-07-16	ACIO	ETF	25.6	25.65	25.53	25.641	9400.0
2020-07-16	ACSI	ETF	35.0707	35.0707	35.0707	35.0707	123.0
2020-07-16	ACTX	ETF	2.7435	3.127	2.36	2.9205	446.0
2020-07-16	ACWF	ETF	28.89	29.0069	28.89	28.9894	2228.0
2020-07-16	ACWI	ETF	76.8	77.08	76.67	76.99	4876700.0
2020-07-16	ACWV	ETF	89.32	89.94	89.32	89.79	552700.0
2020-07-16	ACWX	ETF	45.06	45.28	45.04	45.18	1366673.0
2020-07-16	ADME	ETF	33.02	33.02	32.76	32.919	14400.0
2020-07-16	ADRE	ETF	42.73	43.0555	42.73	43.0555	6123.0
2020-07-16	AESR	ETF	10.28	10.308	10.26	10.308	5400.0
2020-07-16	AFIF	ETF	9.82	9.86	9.82	9.83	4000.0
2020-07-16	AFK	ETF	17.05	17.31	17.05	17.21	4241.0
2020-07-16	AFLG	ETF	19.544	19.544	19.544	19.544	100.0
2020-07-16	AFMC	ETF	17.437	17.437	17.437	17.437	100.0
2020-07-16	AFTY	ETF	18.41	18.53	18.41	18.49	8000.0
2020-07-16	AGG	ETF	118.83	118.89	118.74	118.76	3526900.0
2020-07-16	AGGY	ETF	54.21	54.27	54.19	54.25	143100.0
2020-07-16	AGNG	ETF	25.44	25.44	25.21	25.358	4400.0
2020-07-16	AGQ	ETF	32.95	33.25	32.15	32.18	881300.0
2020-07-16	AGZ	ETF	121.03	121.03	120.92	121.02	26298.0
2020-07-16	AGZD	ETF	23.645	23.65	23.59	23.62	4000.0
2020-07-16	AIA	ETF	67.8	68.2399	67.66	68.16	55072.0
2020-07-16	AIEQ	ETF	29.12	29.417	29.12	29.29	12700.0
2020-07-16	AIQ	ETF	21.4	21.47	21.18	21.41	20551.0
2020-07-16	AIRR	ETF	24.22	24.49	24.189	24.359	1000.0
2020-07-16	AIVI	ETF	36.65	36.72	36.51	36.56	7500.0
2020-07-16	ALTL	ETF	25.009	25.2	24.895	24.998	3406.0
2020-07-16	ALTY	ETF	10.64	10.66	10.53	10.605	16900.0
2020-07-16	AMJ	ETF	12.68	12.96	12.47	12.8	775645.0
2020-07-16	AMLP	ETF	23.66	24.01	23.09	23.74	2775300.0
2020-07-16	AMNA	ETF	23.58	23.8798	23.58	23.8798	600.0
2020-07-16	AMND	ETF	24.97	25.0152	24.72	25.0152	400.0
2020-07-16	AMOM	ETF	31.52	31.52	31.22	31.348	900.0
2020-07-16	AMUB	ETF	7.87	8.14	7.87	8.05	17294.0
2020-07-16	AMZA	ETF	16.71	17.1	16.31	16.83	123300.0
2020-07-16	ANGL	ETF	29.39	29.47	29.31	29.41	1880400.0
2020-07-16	AOA	ETF	56.35	56.43	56.16	56.37	54900.0
2020-07-16	AOK	ETF	36.93	36.93	36.8	36.88	127494.0
2020-07-16	AOM	ETF	40.55	40.5781	40.23	40.5	146167.0

> showing 50 of 2,042 rows — these rows as CSV

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