PREVIEW / etf_daily / 2020-06-05

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-05.parquet
  size:    77 KB
  rows:    2,030

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-06-05	SPY	ETF	317.23	321.27	317.16	319.34	150524700.0
2020-06-05	QQQ	ETF	236.06	240.297	235.63	239.69	47365569.0
2020-06-05	IWM	ETF	150.86	152.32	149.55	150.18	53513400.0
2020-06-05	DIA	ETF	270.4	273.95	269.79	271.54	7866800.0
2020-06-05	GLD	ETF	158.72	158.72	157.04	158.01	16021200.0
2020-06-05	TLT	ETF	154.61	156.16	153.16	156.11	17778500.0
2020-06-05	AAAU	ETF	16.84	16.84	16.67	16.76	510400.0
2020-06-05	AADR	ETF	50.45	50.45	50.27	50.35	6300.0
2020-06-05	AAXJ	ETF	69.76	70.27	69.7	69.85	4575200.0
2020-06-05	ABEQ	ETF	23.17	23.29	23.17	23.232	600.0
2020-06-05	ACES	ETF	38.33	39.22	38.33	38.794	38000.0
2020-06-05	ACIO	ETF	24.68	25.05	24.67	24.982	3300.0
2020-06-05	ACSI	ETF	35.35	35.42	35.0792	35.0792	1108.0
2020-06-05	ACTX	ETF	4.2569	4.8557	4.2569	4.72	197.0
2020-06-05	ACWF	ETF	28.955	29.003	28.93	28.9647	11956.0
2020-06-05	ACWI	ETF	76.17	76.95	76.17	76.45	4274700.0
2020-06-05	ACWV	ETF	90.74	91.22	90.4	91.01	529000.0
2020-06-05	ACWX	ETF	44.96	45.26	44.87	44.92	1880839.0
2020-06-05	ADME	ETF	31.83	32.25	31.83	32.173	26600.0
2020-06-05	ADRE	ETF	40.22	40.65	40.22	40.35	4795.0
2020-06-05	AESR	ETF	9.88	10.02	9.88	9.996	29500.0
2020-06-05	AFIF	ETF	9.8	9.8	9.77	9.8	44615.0
2020-06-05	AFK	ETF	16.12	16.5661	16.12	16.48	18745.0
2020-06-05	AFLG	ETF	19.53	19.53	19.414	19.414	100.0
2020-06-05	AFMC	ETF	18.25	18.25	18.177	18.177	100.0
2020-06-05	AFSM	ETF	17.65	17.89	17.65	17.695	500.0
2020-06-05	AFTY	ETF	16.534	16.534	16.48	16.48	2600.0
2020-06-05	AGG	ETF	116.75	116.91	116.48	116.9	5166300.0
2020-06-05	AGGY	ETF	53.29	53.35	53.1	53.35	439000.0
2020-06-05	AGNG	ETF	24.748	25.0	24.748	24.877	800.0
2020-06-05	AGQ	ETF	26.74	26.94	26.37	26.86	417800.0
2020-06-05	AGZ	ETF	120.3	120.3	120.0	120.27	69629.0
2020-06-05	AGZD	ETF	23.44	23.505	23.435	23.505	12200.0
2020-06-05	AIA	ETF	64.48	64.9217	64.4	64.53	31608.0
2020-06-05	AIEQ	ETF	27.66	27.711	27.36	27.561	23100.0
2020-06-05	AIQ	ETF	20.1301	20.4	20.13	20.24	9212.0
2020-06-05	AIRR	ETF	25.85	26.34	25.78	26.04	19200.0
2020-06-05	AIVI	ETF	37.12	37.37	37.06	37.1	15000.0
2020-06-05	ALTY	ETF	11.66	11.99	11.66	11.82	12200.0
2020-06-05	AMJ	ETF	16.25	16.54	16.07	16.38	1477082.0
2020-06-05	AMLP	ETF	29.91	30.78	29.87	30.44	2852200.0
2020-06-05	AMOM	ETF	28.28	28.623	28.22	28.565	4400.0
2020-06-05	AMUB	ETF	10.31	10.36	10.13	10.2993	11264.0
2020-06-05	AMZA	ETF	22.98	24.14	22.98	23.68	103500.0
2020-06-05	ANGL	ETF	28.88	29.29	28.88	29.1	1250400.0
2020-06-05	AOA	ETF	55.94	56.42	55.94	56.1	97800.0
2020-06-05	AOK	ETF	36.55	36.58	36.4501	36.53	415852.0
2020-06-05	AOM	ETF	40.0	40.3	40.0	40.18	236360.0
2020-06-05	AOR	ETF	47.09	47.275	46.97	47.11	193074.0
2020-06-05	APRT	ETF	25.65	25.66	25.5662	25.5662	400.0

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

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