PREVIEW / etf_daily / 2021-06-30

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-30.parquet
  size:    91 KB
  rows:    2,386

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
2021-06-30	SPY	ETF	427.21	428.78	427.18	428.06	64827900.0
2021-06-30	QQQ	ETF	354.83	355.23	353.83	354.43	32723964.0
2021-06-30	IWM	ETF	228.65	230.32	227.76	229.37	26039000.0
2021-06-30	DIA	ETF	342.38	345.51	342.35	344.95	3778900.0
2021-06-30	GLD	ETF	164.57	166.1	164.29	165.63	7955800.0
2021-06-30	TLT	ETF	144.25	144.93	144.07	144.35	15708900.0
2021-06-30	AAA	ETF	25.04	25.04	25.0101	25.025	3829.0
2021-06-30	AAAU	ETF	17.5	17.65	17.47	17.6	303100.0
2021-06-30	AADR	ETF	66.8	66.8	66.47	66.47	700.0
2021-06-30	AAXJ	ETF	94.33	94.69	94.27	94.5	275100.0
2021-06-30	ABEQ	ETF	27.19	27.225	27.18	27.181	500.0
2021-06-30	ACES	ETF	76.51	76.58	75.46	75.82	39100.0
2021-06-30	ACIO	ETF	30.15	30.19	30.12	30.16	29300.0
2021-06-30	ACSI	ETF	49.99	50.1145	49.99	50.1145	423.0
2021-06-30	ACTV	ETF	38.865	39.03	38.81	38.8692	39574.0
2021-06-30	ACVF	ETF	32.21	32.21	31.89	31.949	2900.0
2021-06-30	ACWF	ETF	38.03	38.1089	37.99	38.1089	268675.0
2021-06-30	ACWI	ETF	101.18	101.37	101.09	101.19	2264300.0
2021-06-30	ACWV	ETF	102.64	103.1	102.64	102.86	598400.0
2021-06-30	ACWX	ETF	57.46	57.62	57.32	57.51	1800946.0
2021-06-30	ADFI	ETF	9.74	9.74	9.72	9.74	300.0
2021-06-30	ADIV	ETF	18.65	18.67	18.65	18.67	100.0
2021-06-30	ADME	ETF	39.75	39.76	39.681	39.75	49400.0
2021-06-30	ADRE	ETF	58.0921	58.2188	57.962	58.065	5984.0
2021-06-30	AESR	ETF	13.6	13.62	13.6	13.619	1300.0
2021-06-30	AFIF	ETF	9.7176	9.74	9.7	9.7232	10555.0
2021-06-30	AFK	ETF	22.0	22.098	21.83	21.86	11186.0
2021-06-30	AFLG	ETF	25.419	25.419	25.419	25.419	500.0
2021-06-30	AFMC	ETF	25.374	25.374	25.374	25.374	600.0
2021-06-30	AFSM	ETF	26.67	26.67	26.605	26.605	200.0
2021-06-30	AFTY	ETF	23.157	23.157	23.157	23.157	600.0
2021-06-30	AGG	ETF	115.36	115.45	115.3	115.33	6653100.0
2021-06-30	AGGY	ETF	52.23	52.29	52.2	52.2	114800.0
2021-06-30	AGNG	ETF	30.55	30.58	30.461	30.533	5400.0
2021-06-30	AGOX	ETF	25.96	26.23	25.96	26.202	11300.0
2021-06-30	AGQ	ETF	45.23	46.24	45.08	46.12	411800.0
2021-06-30	AGZ	ETF	118.3	118.4366	118.3	118.38	28464.0
2021-06-30	AGZD	ETF	23.515	23.55	23.515	23.52	63400.0
2021-06-30	AIA	ETF	91.59	91.83	91.44	91.65	196247.0
2021-06-30	AIEQ	ETF	41.84	41.99	41.34	41.45	14700.0
2021-06-30	AIQ	ETF	30.63	30.635	30.5	30.5	11814.0
2021-06-30	AIRR	ETF	40.66	41.05	40.615	40.99	49600.0
2021-06-30	AIVI	ETF	43.19	43.33	43.1	43.25	7000.0
2021-06-30	ALTL	ETF	41.04	41.3088	40.9	40.9	80001.0
2021-06-30	ALTY	ETF	13.65	13.65	13.61	13.62	20300.0
2021-06-30	AMJ	ETF	19.32	19.6996	19.29	19.65	771287.0
2021-06-30	AMLP	ETF	35.79	36.58	35.78	36.41	2966100.0
2021-06-30	AMNA	ETF	34.0805	34.0805	34.0805	34.0805	23.0
2021-06-30	AMND	ETF	36.1474	36.1474	36.1474	36.1474	2.0
2021-06-30	AMOM	ETF	36.79	36.882	36.53	36.882	12700.0

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

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