PREVIEW / etf_daily / 2022-09-07

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-07.parquet
  size:    103 KB
  rows:    2,782

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-09-07	SPY	ETF	390.43	398.59	390.2	397.78	70964200.0
2022-09-07	QQQ	ETF	293.54	299.99	293.27	298.97	49260381.0
2022-09-07	IWM	ETF	177.97	182.47	177.93	182.19	24781200.0
2022-09-07	DIA	ETF	311.64	316.94	311.45	316.33	2520200.0
2022-09-07	GLD	ETF	158.15	160.15	158.08	159.94	3981400.0
2022-09-07	TLT	ETF	108.32	109.48	108.21	109.19	17050100.0
2022-09-07	AAA	ETF	24.32	24.32	24.32	24.32	15.0
2022-09-07	AAAU	ETF	16.85	17.07	16.85	17.05	2037700.0
2022-09-07	AADR	ETF	48.49	48.96	48.41	48.96	1900.0
2022-09-07	AAPB	ETF	22.24	22.48	22.05	22.449	5715.0
2022-09-07	AAPD	ETF	26.59	26.651	26.251	26.3691	27403.0
2022-09-07	AAPU	ETF	22.6	22.99	22.44	22.8363	27554.0
2022-09-07	AAXJ	ETF	64.5	65.49	64.5	65.43	1059500.0
2022-09-07	ABEQ	ETF	26.43	26.548	26.399	26.548	6200.0
2022-09-07	ACES	ETF	61.65	64.66	61.65	64.55	24800.0
2022-09-07	ACIO	ETF	29.85	29.92	29.675	29.9	23700.0
2022-09-07	ACSI	ETF	45.6593	45.6593	45.6593	45.6593	46.0
2022-09-07	ACT	ETF	24.46	24.89	24.4	24.64	262421.0
2022-09-07	ACTV	ETF	29.12	29.72	29.085	29.7114	8203.0
2022-09-07	ACTX	ETF	0.51	0.51	0.51	0.51	1000.0
2022-09-07	ACVF	ETF	29.38	29.865	29.38	29.864	4100.0
2022-09-07	ACWF	ETF	31.44	32.0061	31.44	31.9686	6130.0
2022-09-07	ACWI	ETF	84.23	85.87	84.2	85.74	4054700.0
2022-09-07	ACWV	ETF	93.7	95.55	93.7	95.24	64000.0
2022-09-07	ACWX	ETF	42.93	43.645	42.93	43.62	2357684.0
2022-09-07	ADFI	ETF	8.48	8.52	8.48	8.508	10000.0
2022-09-07	ADIV	ETF	13.198	13.198	13.198	13.198	100.0
2022-09-07	ADME	ETF	35.046	35.33	34.975	35.275	22000.0
2022-09-07	ADRE	ETF	37.84	38.6199	37.84	38.59	4485.0
2022-09-07	AEMB	ETF	37.86	37.907	37.86	37.907	200.0
2022-09-07	AESR	ETF	11.47	11.66	11.47	11.65	42700.0
2022-09-07	AFIF	ETF	8.929	8.96	8.92	8.94	21896.0
2022-09-07	AFK	ETF	16.45	16.55	16.3	16.55	11110.0
2022-09-07	AFLG	ETF	23.591	23.591	23.591	23.591	100.0
2022-09-07	AFMC	ETF	22.07	22.07	22.07	22.07	100.0
2022-09-07	AFTY	ETF	16.406	16.406	16.406	16.406	100.0
2022-09-07	AGG	ETF	99.73	100.13	99.72	100.11	3607100.0
2022-09-07	AGGH	ETF	23.33	23.33	23.3135	23.3135	2115.0
2022-09-07	AGGY	ETF	43.96	44.13	43.95	44.11	68000.0
2022-09-07	AGNG	ETF	24.75	24.78	24.75	24.78	200.0
2022-09-07	AGOV	ETF	80.83	80.83	80.3996	80.3996	887.0
2022-09-07	AGOX	ETF	20.5	21.03	20.5	20.985	10200.0
2022-09-07	AGQ	ETF	18.76	19.6	18.65	19.6	808000.0
2022-09-07	AGZ	ETF	108.7266	108.99	108.7037	108.94	29720.0
2022-09-07	AGZD	ETF	22.885	22.945	22.85	22.9	30400.0
2022-09-07	AHHX	ETF	8.51	8.625	8.51	8.6244	8873.0
2022-09-07	AHYB	ETF	43.622	43.622	43.622	43.622	100.0
2022-09-07	AIA	ETF	55.95	56.73	55.89	56.65	34194.0
2022-09-07	AIEQ	ETF	31.998	32.676	31.998	32.62	3500.0
2022-09-07	AIQ	ETF	20.81	21.23	20.72	21.13	16271.0

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

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