PREVIEW / etf_daily / 2021-09-22

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-22.parquet
  size:    94 KB
  rows:    2,488

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-09-22	SPY	ETF	436.05	440.03	433.75	437.86	102350100.0
2021-09-22	QQQ	ETF	367.09	371.07	365.9584	369.57	46972920.0
2021-09-22	IWM	ETF	218.88	222.55	218.87	220.9	32100300.0
2021-09-22	DIA	ETF	341.16	344.33	340.44	342.5	6862700.0
2021-09-22	GLD	ETF	165.89	167.15	165.03	165.42	9777800.0
2021-09-22	TLT	ETF	150.79	151.79	150.44	151.79	22277800.0
2021-09-22	AAA	ETF	25.01	25.015	25.01	25.015	322.0
2021-09-22	AAAU	ETF	17.65	17.78	17.56	17.6	1066100.0
2021-09-22	AADR	ETF	65.62	65.93	65.23	65.25	29900.0
2021-09-22	AAXJ	ETF	85.7	86.67	85.7	86.17	1685500.0
2021-09-22	ABEQ	ETF	27.068	27.068	26.935	26.935	4500.0
2021-09-22	ACES	ETF	67.88	68.83	67.88	68.3	54600.0
2021-09-22	ACIO	ETF	30.31	30.47	30.295	30.32	13300.0
2021-09-22	ACSI	ETF	50.03	50.03	49.9805	49.9805	225.0
2021-09-22	ACT	ETF	20.05	21.58	19.9	21.34	332526.0
2021-09-22	ACTV	ETF	37.56	37.7199	37.4054	37.4054	1772.0
2021-09-22	ACTX	ETF	1.02	1.05	0.885	0.89	10156.0
2021-09-22	ACVF	ETF	32.58	32.92	32.48	32.91	23600.0
2021-09-22	ACWF	ETF	37.86	38.17	37.86	37.9829	64589.0
2021-09-22	ACWI	ETF	101.8	102.75	101.73	102.12	4614000.0
2021-09-22	ACWV	ETF	104.96	105.51	104.8	105.02	126800.0
2021-09-22	ACWX	ETF	56.51	57.03	56.5	56.6	1391100.0
2021-09-22	ADFI	ETF	9.78	9.79	9.776	9.776	2700.0
2021-09-22	ADIV	ETF	17.4	17.4	17.4	17.4	300.0
2021-09-22	ADME	ETF	40.086	40.379	40.086	40.28	19600.0
2021-09-22	ADRE	ETF	49.06	49.58	49.06	49.502	12084.0
2021-09-22	AEMB	ETF	49.915	49.915	49.915	49.915	100.0
2021-09-22	AESR	ETF	13.79	13.93	13.79	13.87	20100.0
2021-09-22	AFIF	ETF	9.67	9.68	9.67	9.675	8102.0
2021-09-22	AFK	ETF	20.57	20.79	20.561	20.79	9375.0
2021-09-22	AFLG	ETF	25.91	26.03	25.91	25.917	400.0
2021-09-22	AFSM	ETF	26.08	26.08	26.055	26.055	100.0
2021-09-22	AFTY	ETF	20.076	20.076	20.076	20.076	100.0
2021-09-22	AGG	ETF	116.11	116.25	116.01	116.18	7139900.0
2021-09-22	AGGY	ETF	52.69	52.79	52.67	52.78	82500.0
2021-09-22	AGNG	ETF	30.13	30.279	30.13	30.141	800.0
2021-09-22	AGOV	ETF	100.28	100.28	100.265	100.265	100.0
2021-09-22	AGOX	ETF	26.06	26.26	25.98	26.08	29000.0
2021-09-22	AGQ	ETF	33.92	35.06	33.4	33.68	1404600.0
2021-09-22	AGZ	ETF	118.97	119.0899	118.97	119.0101	25798.0
2021-09-22	AGZD	ETF	23.45	23.45	23.38	23.43	32000.0
2021-09-22	AIA	ETF	78.84	79.795	78.84	79.26	62549.0
2021-09-22	AIEQ	ETF	42.37	42.8	42.225	42.588	19400.0
2021-09-22	AIQ	ETF	30.94	31.2078	30.87	31.1	12600.0
2021-09-22	AIRR	ETF	40.225	40.65	40.225	40.3	9600.0
2021-09-22	AIVI	ETF	42.44	42.69	42.43	42.43	3900.0
2021-09-22	ALTL	ETF	42.56	42.56	42.1805	42.39	56466.0
2021-09-22	ALTY	ETF	13.44	13.55	13.44	13.49	14700.0
2021-09-22	AMJ	ETF	17.33	17.775	17.33	17.58	1697473.0
2021-09-22	AMLP	ETF	31.76	32.65	31.76	32.26	3019100.0

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

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