PREVIEW / etf_daily / 2022-08-25

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-25.parquet
  size:    104 KB
  rows:    2,778

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-08-25	SPY	ETF	415.24	419.56	414.09	419.51	50942300.0
2022-08-25	QQQ	ETF	316.83	320.6	315.7577	320.58	38098255.0
2022-08-25	IWM	ETF	193.38	195.45	192.98	195.4	14795000.0
2022-08-25	DIA	ETF	330.09	333.15	329.0	333.15	2498900.0
2022-08-25	GLD	ETF	163.97	163.99	163.24	163.75	2857500.0
2022-08-25	TLT	ETF	111.32	113.09	110.99	112.77	21429700.0
2022-08-25	AAA	ETF	24.43	24.43	24.43	24.43	21.0
2022-08-25	AAAU	ETF	17.47	17.47	17.4	17.45	1666800.0
2022-08-25	AADR	ETF	51.64	51.64	51.64	51.64	100.0
2022-08-25	AAPB	ETF	26.1244	26.2181	25.92	26.2181	1639.0
2022-08-25	AAPD	ETF	24.312	24.404	24.2158	24.2158	28667.0
2022-08-25	AAPU	ETF	25.84	26.13	25.7503	26.13	14578.0
2022-08-25	AAXJ	ETF	67.7	68.55	67.62	68.55	465200.0
2022-08-25	ABEQ	ETF	27.475	27.608	27.456	27.608	8100.0
2022-08-25	ACES	ETF	65.04	65.32	64.049	65.32	40300.0
2022-08-25	ACIO	ETF	30.9	30.99	30.75	30.99	216500.0
2022-08-25	ACSI	ETF	47.17	47.6119	47.17	47.6119	622.0
2022-08-25	ACT	ETF	26.15	26.7	26.01	26.46	134591.0
2022-08-25	ACTV	ETF	31.51	31.6596	31.44	31.6596	71506.0
2022-08-25	ACTX	ETF	0.64	0.64	0.625	0.63	12547.0
2022-08-25	ACVF	ETF	31.33	31.52	31.15	31.516	1400.0
2022-08-25	ACWF	ETF	33.36	33.54	33.3355	33.54	2107.0
2022-08-25	ACWI	ETF	89.64	90.6	89.51	90.6	3801500.0
2022-08-25	ACWV	ETF	97.81	98.37	97.63	98.33	62000.0
2022-08-25	ACWX	ETF	45.69	46.1	45.605	46.09	1792134.0
2022-08-25	ADFI	ETF	8.595	8.631	8.59	8.631	7600.0
2022-08-25	ADIV	ETF	13.55	13.703	13.55	13.703	1000.0
2022-08-25	ADME	ETF	36.4	36.884	36.4	36.884	11600.0
2022-08-25	ADRE	ETF	40.04	40.72	40.04	40.72	8829.0
2022-08-25	AESR	ETF	12.19	12.26	12.14	12.253	11400.0
2022-08-25	AFIF	ETF	8.96	8.985	8.95	8.985	10394.0
2022-08-25	AFK	ETF	17.49	17.535	17.44	17.535	2629.0
2022-08-25	AFLG	ETF	24.63	24.82	24.63	24.82	200.0
2022-08-25	AFMC	ETF	23.412	23.412	23.412	23.412	100.0
2022-08-25	AFSM	ETF	24.504	24.504	24.504	24.504	100.0
2022-08-25	AFTY	ETF	17.175	17.175	17.175	17.175	100.0
2022-08-25	AGG	ETF	101.33	101.87	101.24	101.8	8217300.0
2022-08-25	AGGY	ETF	44.67	45.09	44.635	44.89	88700.0
2022-08-25	AGNG	ETF	25.69	25.81	25.57	25.81	4100.0
2022-08-25	AGOV	ETF	82.0	82.0	81.53	81.9004	4573.0
2022-08-25	AGOX	ETF	22.12	22.2	22.06	22.2	21900.0
2022-08-25	AGQ	ETF	21.27	21.39	21.01	21.27	588800.0
2022-08-25	AGZ	ETF	109.43	109.56	109.41	109.55	32581.0
2022-08-25	AGZD	ETF	22.975	23.0	22.875	22.875	72200.0
2022-08-25	AHHX	ETF	8.8427	8.8427	8.8427	8.8427	170.0
2022-08-25	AHYB	ETF	44.664	44.664	44.664	44.664	100.0
2022-08-25	AIA	ETF	59.85	60.89	59.85	60.89	113465.0
2022-08-25	AIEQ	ETF	35.41	36.04	35.41	36.03	5000.0
2022-08-25	AIQ	ETF	22.34	22.85	22.34	22.85	12723.0
2022-08-25	AIRR	ETF	44.32	44.67	44.32	44.67	7200.0

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

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