PREVIEW / etf_daily / 2021-06-28

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-28.parquet
  size:    89 KB
  rows:    2,384

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-28	SPY	ETF	427.17	427.65	425.89	427.47	53159600.0
2021-06-28	QQQ	ETF	350.78	353.85	350.72	353.71	39130305.0
2021-06-28	IWM	ETF	232.24	232.59	228.77	230.44	25006000.0
2021-06-28	DIA	ETF	344.33	344.42	341.82	342.8	3606300.0
2021-06-28	GLD	ETF	166.68	166.91	166.36	166.58	6508900.0
2021-06-28	TLT	ETF	142.72	143.8	142.7	143.47	11460700.0
2021-06-28	AAA	ETF	25.04	25.04	25.01	25.02	1405.0
2021-06-28	AAAU	ETF	17.72	17.73	17.68	17.71	250900.0
2021-06-28	AADR	ETF	66.17	66.42	66.17	66.42	1800.0
2021-06-28	AAXJ	ETF	94.92	95.16	94.86	95.13	759100.0
2021-06-28	ABEQ	ETF	27.302	27.38	27.25	27.36	16300.0
2021-06-28	ACES	ETF	74.69	76.83	74.69	76.83	98400.0
2021-06-28	ACIO	ETF	30.18	30.18	30.01	30.13	70800.0
2021-06-28	ACSI	ETF	49.77	49.8705	49.77	49.8705	602.0
2021-06-28	ACTV	ETF	39.5	39.5	38.84	38.9651	5344.0
2021-06-28	ACVF	ETF	32.03	32.03	31.86	31.883	20300.0
2021-06-28	ACWF	ETF	38.15	38.15	38.005	38.1388	15099.0
2021-06-28	ACWI	ETF	101.53	101.6	101.23	101.55	3817400.0
2021-06-28	ACWV	ETF	102.98	103.32	102.96	103.04	157700.0
2021-06-28	ACWX	ETF	58.05	58.05	57.81	57.91	1026167.0
2021-06-28	ADFI	ETF	9.76	9.76	9.741	9.741	200.0
2021-06-28	ADIV	ETF	18.725	18.74	18.725	18.74	300.0
2021-06-28	ADME	ETF	39.7	39.7	39.53	39.66	53700.0
2021-06-28	ADRE	ETF	57.85	58.29	57.83	58.085	6855.0
2021-06-28	AESR	ETF	13.55	13.586	13.53	13.586	4700.0
2021-06-28	AFIF	ETF	9.75	9.75	9.71	9.7344	11825.0
2021-06-28	AFK	ETF	22.0	22.0	21.87	21.87	9343.0
2021-06-28	AFLG	ETF	25.33	25.347	25.33	25.347	500.0
2021-06-28	AFMC	ETF	25.35	25.35	25.339	25.339	700.0
2021-06-28	AFSM	ETF	26.6	26.6	26.58	26.591	300.0
2021-06-28	AFTY	ETF	23.37	23.38	23.355	23.367	3100.0
2021-06-28	AGG	ETF	115.04	115.23	115.04	115.19	5739000.0
2021-06-28	AGGY	ETF	52.04	52.17	52.04	52.11	192800.0
2021-06-28	AGNG	ETF	30.96	31.03	30.695	30.695	9700.0
2021-06-28	AGOX	ETF	26.48	26.48	26.074	26.165	52900.0
2021-06-28	AGQ	ETF	46.19	46.46	45.94	46.15	402100.0
2021-06-28	AGZ	ETF	118.15	118.32	118.15	118.24	18299.0
2021-06-28	AGZD	ETF	23.505	23.59	23.505	23.55	94800.0
2021-06-28	AIA	ETF	92.32	92.43	92.08	92.19	41020.0
2021-06-28	AIEQ	ETF	41.69	41.98	41.69	41.965	37000.0
2021-06-28	AIQ	ETF	30.59	30.7335	30.56	30.7	270354.0
2021-06-28	AIRR	ETF	41.26	41.26	40.497	40.6	14700.0
2021-06-28	AIVI	ETF	43.57	43.6	43.48	43.54	2800.0
2021-06-28	ALTL	ETF	41.29	41.37	41.2486	41.3	44160.0
2021-06-28	ALTY	ETF	13.67	13.71	13.57	13.64	16000.0
2021-06-28	AMJ	ETF	19.48	19.49	18.94	19.11	1101264.0
2021-06-28	AMLP	ETF	36.31	36.33	35.11	35.45	2701400.0
2021-06-28	AMNA	ETF	33.7515	33.7515	33.7515	33.7515	58.0
2021-06-28	AMND	ETF	35.6696	35.6696	35.6696	35.6696	54.0
2021-06-28	AMOM	ETF	36.57	36.76	36.44	36.722	6200.0

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

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