PREVIEW / etf_daily / 2021-06-01

all etf daily files

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

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-01	SPY	ETF	422.57	422.72	419.2	419.67	54216600.0
2021-06-01	QQQ	ETF	335.3	335.785	331.43	332.82	31145424.0
2021-06-01	IWM	ETF	227.46	228.56	225.96	228.06	23081500.0
2021-06-01	DIA	ETF	348.54	348.65	345.6	345.87	2584300.0
2021-06-01	GLD	ETF	178.76	178.85	177.19	177.9	9143300.0
2021-06-01	TLT	ETF	137.82	138.26	137.25	138.21	11778500.0
2021-06-01	AAA	ETF	25.0	25.0	24.97	24.985	10649.0
2021-06-01	AAAU	ETF	18.99	19.0	18.83	18.9	393700.0
2021-06-01	AADR	ETF	67.48	67.79	67.48	67.79	1600.0
2021-06-01	AAXJ	ETF	96.34	96.39	95.72	96.06	495400.0
2021-06-01	ABEQ	ETF	28.288	28.31	28.283	28.307	4100.0
2021-06-01	ACES	ETF	69.7	70.221	68.61	69.18	51500.0
2021-06-01	ACIO	ETF	30.2	30.2	29.67	29.67	53200.0
2021-06-01	ACSI	ETF	49.0988	49.0988	49.0988	49.0988	247.0
2021-06-01	ACTV	ETF	39.17	39.61	39.17	39.3978	7513.0
2021-06-01	ACTX	ETF	3.52	3.52	3.4	3.4	1245.0
2021-06-01	ACVF	ETF	31.65	31.65	31.29	31.32	14800.0
2021-06-01	ACWF	ETF	38.659	38.659	38.49	38.5139	2285.0
2021-06-01	ACWI	ETF	101.57	101.58	100.83	100.98	3465900.0
2021-06-01	ACWV	ETF	103.56	103.68	103.0	103.0	59200.0
2021-06-01	ACWX	ETF	59.1	59.1	58.84	58.9	1665295.0
2021-06-01	ADFI	ETF	9.71	9.72	9.67	9.69	3600.0
2021-06-01	ADIV	ETF	19.07	19.07	19.07	19.07	200.0
2021-06-01	ADME	ETF	39.24	39.24	38.67	38.68	46400.0
2021-06-01	ADRE	ETF	57.91	58.1399	57.6475	58.1	16095.0
2021-06-01	AESR	ETF	13.357	13.36	13.28	13.3	6100.0
2021-06-01	AFIF	ETF	9.73	9.73	9.69	9.6901	8569.0
2021-06-01	AFK	ETF	22.8	22.9	22.75	22.89	16556.0
2021-06-01	AFLG	ETF	25.29	25.29	25.09	25.091	1400.0
2021-06-01	AFMC	ETF	25.65	25.656	25.605	25.656	1200.0
2021-06-01	AFTY	ETF	24.5	24.54	24.39	24.47	28700.0
2021-06-01	AGG	ETF	114.36	114.4	114.16	114.33	6209800.0
2021-06-01	AGGY	ETF	51.64	51.87	51.6	51.87	88600.0
2021-06-01	AGNG	ETF	29.23	29.43	29.12	29.173	7100.0
2021-06-01	AGOX	ETF	26.27	26.27	25.87	25.922	22600.0
2021-06-01	AGQ	ETF	55.35	55.5	52.84	52.96	1748900.0
2021-06-01	AGZ	ETF	118.13	118.2	118.12	118.2	35098.0
2021-06-01	AGZD	ETF	23.505	23.505	23.45	23.495	395800.0
2021-06-01	AIA	ETF	93.76	93.76	93.03	93.47	62544.0
2021-06-01	AIEQ	ETF	38.41	38.41	37.95	38.34	9500.0
2021-06-01	AIQ	ETF	29.36	29.36	29.0	29.12	12972.0
2021-06-01	AIRR	ETF	41.94	42.35	41.94	42.3	87100.0
2021-06-01	AIVI	ETF	44.56	44.57	44.44	44.44	2800.0
2021-06-01	ALTL	ETF	41.48	41.48	41.02	41.03	17980.0
2021-06-01	ALTY	ETF	13.6	13.64	13.52	13.64	223400.0
2021-06-01	AMJ	ETF	18.75	19.2	18.75	19.15	397599.0
2021-06-01	AMLP	ETF	34.68	35.38	34.68	35.32	2785500.0
2021-06-01	AMNA	ETF	33.64	33.68	33.61	33.6222	17894.0
2021-06-01	AMND	ETF	35.7	35.7	35.6383	35.6383	7005.0
2021-06-01	AMOM	ETF	35.55	35.55	35.035	35.22	32300.0

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

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