PREVIEW / etf_daily / 2022-03-29

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-29.parquet
  size:    100 KB
  rows:    2,695

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
2022-03-29	SPY	ETF	460.02	462.07	457.18	461.55	86581500.0
2022-03-29	QQQ	ETF	368.9	371.83	366.06	371.19	68072955.0
2022-03-29	IWM	ETF	208.0	212.25	207.88	211.71	29550600.0
2022-03-29	DIA	ETF	352.66	353.71	350.13	352.97	4711800.0
2022-03-29	GLD	ETF	177.02	179.33	176.69	179.14	10458900.0
2022-03-29	TLT	ETF	130.56	131.55	129.74	130.74	19319700.0
2022-03-29	AAA	ETF	24.785	24.785	24.785	24.785	62.0
2022-03-29	AAAU	ETF	18.86	19.09	18.82	19.03	9207600.0
2022-03-29	AADR	ETF	60.57	61.15	60.38	61.12	9900.0
2022-03-29	AAXJ	ETF	76.65	76.93	76.32	76.77	1577600.0
2022-03-29	ABEQ	ETF	30.02	30.083	29.95	30.083	11500.0
2022-03-29	ACES	ETF	62.75	64.86	62.51	64.66	40800.0
2022-03-29	ACIO	ETF	31.85	31.97	31.579	31.72	26600.0
2022-03-29	ACSI	ETF	51.5957	51.5957	51.5957	51.5957	160.0
2022-03-29	ACT	ETF	22.79	23.23	22.6	23.11	95921.0
2022-03-29	ACTV	ETF	36.36	36.73	36.36	36.69	14651.0
2022-03-29	ACTX	ETF	0.885	0.89	0.885	0.89	1224.0
2022-03-29	ACVF	ETF	34.24	34.477	34.225	34.477	5900.0
2022-03-29	ACWF	ETF	37.77	37.79	37.53	37.7857	6640.0
2022-03-29	ACWI	ETF	101.76	102.03	101.12	101.98	4242600.0
2022-03-29	ACWV	ETF	105.78	105.78	104.95	105.62	194500.0
2022-03-29	ACWX	ETF	53.31	53.385	52.87	53.27	1843868.0
2022-03-29	ADFI	ETF	9.039	9.045	9.01	9.045	1000.0
2022-03-29	ADIV	ETF	15.71	15.73	15.68	15.73	700.0
2022-03-29	ADME	ETF	41.459	41.7	41.34	41.59	29800.0
2022-03-29	ADRE	ETF	45.26	45.47	45.145	45.47	5524.0
2022-03-29	AEMB	ETF	43.605	43.605	43.605	43.605	100.0
2022-03-29	AESR	ETF	13.63	13.65	13.57	13.65	3700.0
2022-03-29	AFIF	ETF	9.215	9.23	9.2	9.225	39715.0
2022-03-29	AFK	ETF	21.32	21.4	21.275	21.4	7151.0
2022-03-29	AFLG	ETF	27.19	27.236	27.11	27.236	6100.0
2022-03-29	AFMC	ETF	25.468	25.468	25.468	25.468	100.0
2022-03-29	AFSM	ETF	26.53	26.53	26.53	26.53	100.0
2022-03-29	AFTY	ETF	17.78	17.83	17.765	17.765	6300.0
2022-03-29	AGG	ETF	106.61	106.89	106.46	106.86	11396500.0
2022-03-29	AGGY	ETF	47.53	47.7	47.504	47.68	120300.0
2022-03-29	AGNG	ETF	28.845	28.845	28.84	28.84	2600.0
2022-03-29	AGOV	ETF	83.33	86.3	82.7	83.3576	10106.0
2022-03-29	AGOX	ETF	24.292	24.558	24.05	24.44	357600.0
2022-03-29	AGQ	ETF	36.49	38.58	36.0	38.4	1087800.0
2022-03-29	AGZ	ETF	112.29	112.44	112.12	112.2	32992.0
2022-03-29	AGZD	ETF	23.15	23.275	23.15	23.24	93400.0
2022-03-29	AHHX	ETF	9.3022	9.41	9.3022	9.41	1247921.0
2022-03-29	AHYB	ETF	47.6	47.853	47.6	47.853	700.0
2022-03-29	AIA	ETF	70.5	71.17	70.4129	70.8	93424.0
2022-03-29	AIEQ	ETF	37.37	37.829	37.33	37.789	9100.0
2022-03-29	AIQ	ETF	27.87	28.13	27.6	28.01	225717.0
2022-03-29	AIRR	ETF	43.3	43.78	43.292	43.7	19700.0
2022-03-29	AIVI	ETF	41.06	41.06	40.68	40.91	5300.0
2022-03-29	AIVL	ETF	100.28	100.66	100.05	100.66	3600.0

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

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