PREVIEW / etf_daily / 2021-07-23

all etf daily files

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

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-23	SPY	ETF	437.52	440.3	436.79	439.94	63766600.0
2021-07-23	QQQ	ETF	365.31	368.485	363.9157	368.2	31960799.0
2021-07-23	IWM	ETF	219.87	219.95	216.91	219.55	23660300.0
2021-07-23	DIA	ETF	350.0	350.99	349.21	350.57	4142300.0
2021-07-23	GLD	ETF	168.5	168.88	167.95	168.56	5831500.0
2021-07-23	TLT	ETF	147.94	148.66	147.89	148.5	12639300.0
2021-07-23	AAA	ETF	25.02	25.02	25.02	25.02	15.0
2021-07-23	AAAU	ETF	17.91	17.95	17.86	17.93	192900.0
2021-07-23	AADR	ETF	66.1	66.1	65.52	65.82	10500.0
2021-07-23	AAXJ	ETF	90.04	90.26	89.32	89.93	1227400.0
2021-07-23	ABEQ	ETF	27.47	27.47	27.23	27.29	700.0
2021-07-23	ACES	ETF	70.4	70.4	69.21	69.82	43500.0
2021-07-23	ACIO	ETF	30.98	31.05	30.81	31.0	11000.0
2021-07-23	ACSI	ETF	51.3004	51.3004	51.3004	51.3004	282.0
2021-07-23	ACTV	ETF	38.0	38.15	37.83	38.1283	4987.0
2021-07-23	ACTX	ETF	1.75	1.75	1.62	1.62	819.0
2021-07-23	ACVF	ETF	32.28	32.5	32.28	32.466	3200.0
2021-07-23	ACWF	ETF	37.96	38.05	37.81	38.05	3311.0
2021-07-23	ACWI	ETF	102.15	102.52	101.88	102.41	2398300.0
2021-07-23	ACWV	ETF	104.35	104.88	104.16	104.8	50200.0
2021-07-23	ACWX	ETF	56.84	56.84	56.59	56.76	1999474.0
2021-07-23	ADFI	ETF	9.79	9.8	9.75	9.768	4900.0
2021-07-23	ADIV	ETF	18.22	18.22	18.215	18.215	100.0
2021-07-23	ADME	ETF	40.828	40.93	40.57	40.91	12900.0
2021-07-23	ADRE	ETF	53.89	53.89	53.19	53.749	9328.0
2021-07-23	AEMB	ETF	50.26	50.26	50.225	50.225	200.0
2021-07-23	AESR	ETF	13.88	13.96	13.88	13.96	7800.0
2021-07-23	AFIF	ETF	9.685	9.71	9.66	9.6846	7575.0
2021-07-23	AFK	ETF	21.71	21.71	21.3	21.47	8929.0
2021-07-23	AFLG	ETF	25.91	25.966	25.91	25.966	600.0
2021-07-23	AFMC	ETF	25.124	25.124	25.124	25.124	100.0
2021-07-23	AFSM	ETF	25.62	25.7	25.62	25.7	100.0
2021-07-23	AFTY	ETF	21.82	21.84	21.73	21.84	8900.0
2021-07-23	AGG	ETF	116.03	116.22	116.03	116.21	4441000.0
2021-07-23	AGGY	ETF	52.69	52.79	52.69	52.775	64600.0
2021-07-23	AGNG	ETF	30.51	30.66	30.46	30.614	4400.0
2021-07-23	AGOV	ETF	100.48	100.48	99.71	99.895	4460.0
2021-07-23	AGOX	ETF	26.025	26.15	26.015	26.14	32500.0
2021-07-23	AGQ	ETF	42.65	42.79	41.93	42.6	926600.0
2021-07-23	AGZ	ETF	119.05	119.17	118.96	119.17	20699.0
2021-07-23	AGZD	ETF	23.465	23.5	23.465	23.485	42400.0
2021-07-23	AIA	ETF	87.11	87.11	86.2409	86.73	64060.0
2021-07-23	AIEQ	ETF	41.0	41.29	40.88	41.23	8800.0
2021-07-23	AIQ	ETF	30.94	31.05	30.8103	31.04	27875.0
2021-07-23	AIRR	ETF	39.98	40.22	39.6	40.15	18900.0
2021-07-23	AIVI	ETF	43.68	43.72	43.67	43.68	3700.0
2021-07-23	ALTL	ETF	42.46	42.68	42.13	42.68	40678.0
2021-07-23	ALTY	ETF	13.49	13.58	13.49	13.51	20300.0
2021-07-23	AMJ	ETF	18.33	18.33	17.99	18.18	680484.0
2021-07-23	AMLP	ETF	33.88	33.9	33.24	33.75	1848600.0

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

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