PREVIEW / etf_daily / 2021-06-29

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-29.parquet
  size:    90 KB
  rows:    2,375

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-29	SPY	ETF	427.88	428.56	427.13	427.7	35970500.0
2021-06-29	QQQ	ETF	353.53	355.0199	352.67	354.99	29426039.0
2021-06-29	IWM	ETF	231.23	231.73	228.77	229.34	18844300.0
2021-06-29	DIA	ETF	343.98	344.73	342.61	342.86	2375800.0
2021-06-29	GLD	ETF	164.34	165.28	164.01	164.83	7451400.0
2021-06-29	TLT	ETF	143.1	143.72	143.04	143.71	11217900.0
2021-06-29	AAA	ETF	25.04	25.04	25.02	25.02	2784.0
2021-06-29	AAAU	ETF	17.48	17.57	17.44	17.53	368700.0
2021-06-29	AADR	ETF	66.38	66.8	66.38	66.72	2600.0
2021-06-29	AAXJ	ETF	94.32	95.03	94.09	95.03	788700.0
2021-06-29	ABEQ	ETF	27.24	27.3	27.215	27.24	2400.0
2021-06-29	ACES	ETF	77.01	77.77	76.29	76.51	74000.0
2021-06-29	ACIO	ETF	30.21	30.21	30.09	30.15	87200.0
2021-06-29	ACSI	ETF	49.9303	49.9303	49.9303	49.9303	275.0
2021-06-29	ACTV	ETF	38.91	38.92	38.8242	38.8286	3299.0
2021-06-29	ACVF	ETF	32.09	32.09	31.87	31.901	3000.0
2021-06-29	ACWF	ETF	38.199	38.199	38.165	38.1934	810.0
2021-06-29	ACWI	ETF	101.63	101.63	101.39	101.59	1806900.0
2021-06-29	ACWV	ETF	102.93	103.22	102.93	103.09	42500.0
2021-06-29	ACWX	ETF	57.91	57.91	57.74	57.89	650668.0
2021-06-29	ADFI	ETF	9.75	9.75	9.71	9.728	3800.0
2021-06-29	ADIV	ETF	18.73	18.73	18.72	18.72	200.0
2021-06-29	ADME	ETF	39.94	39.94	39.71	39.73	47600.0
2021-06-29	ADRE	ETF	57.77	58.38	57.67	58.3035	9757.0
2021-06-29	AESR	ETF	13.6	13.62	13.58	13.6	9600.0
2021-06-29	AFIF	ETF	9.72	9.72	9.69	9.715	9791.0
2021-06-29	AFK	ETF	21.88	21.93	21.83	21.83	9408.0
2021-06-29	AFLG	ETF	25.385	25.385	25.385	25.385	500.0
2021-06-29	AFTY	ETF	23.085	23.14	23.06	23.109	4000.0
2021-06-29	AGG	ETF	115.06	115.25	115.05	115.25	5097100.0
2021-06-29	AGGY	ETF	52.09	52.19	52.08	52.18	110700.0
2021-06-29	AGNG	ETF	30.67	30.67	30.53	30.605	7300.0
2021-06-29	AGOX	ETF	25.96	26.28	25.96	26.181	14500.0
2021-06-29	AGQ	ETF	44.58	45.09	44.24	44.91	861700.0
2021-06-29	AGZ	ETF	118.14	118.57	118.14	118.31	18070.0
2021-06-29	AGZD	ETF	23.515	23.52	23.51	23.515	32200.0
2021-06-29	AIA	ETF	91.7	92.26	91.335	92.26	115242.0
2021-06-29	AIEQ	ETF	42.0	42.015	41.742	41.75	67500.0
2021-06-29	AIQ	ETF	30.64	30.7492	30.595	30.7	16758.0
2021-06-29	AIRR	ETF	40.85	41.0	40.556	40.58	101200.0
2021-06-29	AIVI	ETF	43.53	43.53	43.41	43.48	5000.0
2021-06-29	ALTL	ETF	41.36	41.42	41.17	41.17	18673.0
2021-06-29	ALTY	ETF	13.68	13.68	13.61	13.61	16900.0
2021-06-29	AMJ	ETF	19.29	19.345	19.125	19.21	672484.0
2021-06-29	AMLP	ETF	35.66	35.86	35.46	35.71	1697200.0
2021-06-29	AMNA	ETF	33.7237	33.7237	33.7237	33.7237	40.0
2021-06-29	AMND	ETF	35.7333	35.7333	35.7333	35.7333	3.0
2021-06-29	AMOM	ETF	36.74	36.81	36.72	36.77	8600.0
2021-06-29	AMPS	ETF	9.88	9.88	9.77	9.79	246287.0
2021-06-29	AMTR	ETF	39.74	39.74	39.4539	39.4539	101.0

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

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