PREVIEW / etf_daily / 2021-07-01

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-01.parquet
  size:    91 KB
  rows:    2,405

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-07-01	SPY	ETF	428.87	430.6	428.8	430.43	53441000.0
2021-07-01	QQQ	ETF	354.07	355.09	352.68	354.57	29289978.0
2021-07-01	IWM	ETF	230.81	231.85	229.71	231.39	18089100.0
2021-07-01	DIA	ETF	345.78	346.4	344.92	346.36	3606900.0
2021-07-01	GLD	ETF	166.65	166.88	165.5	166.2	7430500.0
2021-07-01	TLT	ETF	143.98	144.31	143.53	144.17	10810000.0
2021-07-01	AAA	ETF	24.995	24.995	24.995	24.995	53.0
2021-07-01	AAAU	ETF	17.71	17.73	17.6	17.67	217500.0
2021-07-01	AADR	ETF	66.65	66.65	66.11	66.28	3200.0
2021-07-01	AAXJ	ETF	94.47	94.47	93.44	93.84	995400.0
2021-07-01	ABEQ	ETF	27.39	27.39	27.371	27.371	600.0
2021-07-01	ACES	ETF	76.13	76.13	74.59	75.33	37600.0
2021-07-01	ACIO	ETF	30.226	30.35	30.18	30.35	35500.0
2021-07-01	ACSI	ETF	50.26	50.3311	50.26	50.3311	297.0
2021-07-01	ACTV	ETF	38.99	39.27	38.99	39.14	10401.0
2021-07-01	ACTX	ETF	3.2	3.2	3.2	3.2	428.0
2021-07-01	ACVF	ETF	32.1	32.1	32.07	32.076	1200.0
2021-07-01	ACWF	ETF	38.07	38.125	37.98	38.1018	51523.0
2021-07-01	ACWI	ETF	101.28	101.61	101.15	101.61	3398100.0
2021-07-01	ACWV	ETF	102.88	103.27	102.88	103.21	70000.0
2021-07-01	ACWX	ETF	57.56	57.56	57.27	57.53	899989.0
2021-07-01	ADFI	ETF	9.72	9.78	9.72	9.74	1400.0
2021-07-01	ADIV	ETF	18.61	18.659	18.57	18.57	800.0
2021-07-01	ADME	ETF	39.88	39.97	39.8	39.97	33300.0
2021-07-01	ADRE	ETF	58.32	58.32	57.0188	57.1	9079.0
2021-07-01	AEMB	ETF	50.07	50.07	49.98	49.99	2351.0
2021-07-01	AESR	ETF	13.65	13.7	13.64	13.681	12100.0
2021-07-01	AFIF	ETF	9.7	9.72	9.69	9.705	19224.0
2021-07-01	AFK	ETF	21.97	21.97	21.7207	21.79	11948.0
2021-07-01	AFLG	ETF	25.48	25.55	25.48	25.516	25700.0
2021-07-01	AFMC	ETF	25.56	25.56	25.56	25.56	100.0
2021-07-01	AFSM	ETF	26.768	26.768	26.768	26.768	100.0
2021-07-01	AFTY	ETF	23.0	23.049	23.0	23.049	800.0
2021-07-01	AGG	ETF	115.15	115.19	115.01	115.11	4744900.0
2021-07-01	AGGY	ETF	52.16	52.22	52.14	52.19	89300.0
2021-07-01	AGNG	ETF	30.521	30.73	30.521	30.679	4300.0
2021-07-01	AGOX	ETF	25.92	26.32	25.92	26.263	87900.0
2021-07-01	AGQ	ETF	46.55	46.64	45.46	45.81	580100.0
2021-07-01	AGZ	ETF	118.21	118.32	118.11	118.21	132603.0
2021-07-01	AGZD	ETF	23.515	23.515	23.48	23.51	237400.0
2021-07-01	AIA	ETF	91.31	91.45	90.5177	90.86	286149.0
2021-07-01	AIEQ	ETF	41.68	41.68	41.19	41.48	45900.0
2021-07-01	AIQ	ETF	30.55	30.61	30.36	30.57	26793.0
2021-07-01	AIRR	ETF	41.25	41.34	41.04	41.28	50100.0
2021-07-01	AIVI	ETF	43.22	43.26	43.15	43.26	6000.0
2021-07-01	ALTL	ETF	41.16	41.51	41.16	41.44	18007.0
2021-07-01	ALTY	ETF	13.68	13.69	13.626	13.67	13700.0
2021-07-01	AMJ	ETF	19.97	19.97	19.525	19.85	482075.0
2021-07-01	AMLP	ETF	36.83	36.98	36.22	36.86	3256900.0
2021-07-01	AMNA	ETF	34.3757	34.3757	34.3757	34.3757	10.0

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

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