PREVIEW / etf_daily / 2022-06-21

all etf daily files

  file:    by_date/etf_daily/2022/2022-06-21.parquet
  size:    102 KB
  rows:    2,749

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-06-21	SPY	ETF	371.89	376.53	371.81	375.07	76811900.0
2022-06-21	QQQ	ETF	278.75	283.45	278.64	281.08	51633741.0
2022-06-21	IWM	ETF	167.98	170.08	166.81	168.14	34665400.0
2022-06-21	DIA	ETF	303.08	306.47	302.62	305.29	3246500.0
2022-06-21	GLD	ETF	171.06	171.91	170.47	170.63	5608500.0
2022-06-21	TLT	ETF	110.09	111.02	109.81	110.18	17663800.0
2022-06-21	AAA	ETF	24.44	24.44	24.44	24.44	9.0
2022-06-21	AAAU	ETF	18.22	18.31	18.17	18.18	957100.0
2022-06-21	AADR	ETF	50.66	50.72	50.38	50.46	3400.0
2022-06-21	AAXJ	ETF	68.95	69.45	68.92	69.2	1334300.0
2022-06-21	ABEQ	ETF	27.078	27.12	26.99	27.03	9200.0
2022-06-21	ACES	ETF	49.45	51.05	49.42	49.92	144300.0
2022-06-21	ACIO	ETF	28.51	28.7	28.5	28.55	79100.0
2022-06-21	ACSI	ETF	42.083	42.083	42.0231	42.0231	452.0
2022-06-21	ACT	ETF	21.81	21.91	20.93	21.21	1181323.0
2022-06-21	ACTV	ETF	29.59	29.895	29.59	29.6478	6733.0
2022-06-21	ACTX	ETF	0.95	0.95	0.95	0.95	222.0
2022-06-21	ACVF	ETF	28.17	28.49	28.17	28.44	2600.0
2022-06-21	ACWF	ETF	31.16	31.23	30.98	31.0845	45217.0
2022-06-21	ACWI	ETF	83.34	84.08	83.25	83.76	4832300.0
2022-06-21	ACWV	ETF	91.68	92.73	91.68	92.48	148800.0
2022-06-21	ACWX	ETF	45.11	45.3	45.045	45.1	3959129.0
2022-06-21	ADFI	ETF	8.45	8.45	8.4	8.409	23200.0
2022-06-21	ADIV	ETF	14.22	14.22	14.12	14.12	10500.0
2022-06-21	ADME	ETF	34.128	34.497	34.128	34.38	97000.0
2022-06-21	ADRE	ETF	39.39	39.68	39.3	39.68	2511.0
2022-06-21	AEMB	ETF	38.435	38.435	38.435	38.435	100.0
2022-06-21	AESR	ETF	10.98	11.11	10.98	11.046	78800.0
2022-06-21	AFIF	ETF	8.869	8.87	8.85	8.855	14506.0
2022-06-21	AFK	ETF	17.48	17.66	17.43	17.48	18130.0
2022-06-21	AFLG	ETF	22.54	22.547	22.54	22.547	300.0
2022-06-21	AFMC	ETF	20.815	20.815	20.815	20.815	100.0
2022-06-21	AFSM	ETF	21.9	21.9	21.783	21.783	400.0
2022-06-21	AFTY	ETF	18.2	18.32	18.2	18.29	4000.0
2022-06-21	AGG	ETF	100.02	100.26	99.79	99.94	9022500.0
2022-06-21	AGGH	ETF	23.25	23.3029	23.25	23.3029	432.0
2022-06-21	AGGY	ETF	44.1	44.2	43.94	44.09	925200.0
2022-06-21	AGNG	ETF	24.46	24.46	24.255	24.37	2300.0
2022-06-21	AGOV	ETF	79.5472	79.5472	78.2475	78.2475	1240.0
2022-06-21	AGOX	ETF	20.38	20.695	20.38	20.45	45800.0
2022-06-21	AGQ	ETF	28.61	29.11	28.27	28.3	588900.0
2022-06-21	AGZ	ETF	108.36	108.65	108.07	108.41	77439.0
2022-06-21	AGZD	ETF	23.04	23.085	22.955	23.015	678000.0
2022-06-21	AHHX	ETF	8.57	8.59	8.54	8.5521	3238.0
2022-06-21	AHYB	ETF	43.255	43.255	42.886	42.886	1100.0
2022-06-21	AIA	ETF	63.26	63.61	63.03	63.37	179406.0
2022-06-21	AIEQ	ETF	30.45	31.054	30.45	30.7	14100.0
2022-06-21	AIQ	ETF	20.95	21.2457	20.9	21.08	15889.0
2022-06-21	AIRR	ETF	37.0	37.487	36.605	37.18	12800.0
2022-06-21	AIVI	ETF	36.82	36.82	36.69	36.69	2200.0

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

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