PREVIEW / etf_daily / 2022-06-27

all etf daily files

  file:    by_date/etf_daily/2022/2022-06-27.parquet
  size:    103 KB
  rows:    2,759

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-27	SPY	ETF	391.05	391.36	387.44	388.59	66009600.0
2022-06-27	QQQ	ETF	296.0	296.5799	291.29	292.45	54151452.0
2022-06-27	IWM	ETF	175.67	176.99	174.18	175.74	24745400.0
2022-06-27	DIA	ETF	315.4	315.89	313.38	314.36	1896500.0
2022-06-27	GLD	ETF	170.6	170.67	169.75	169.9	5719700.0
2022-06-27	TLT	ETF	111.22	112.22	111.16	111.6	12053000.0
2022-06-27	AAA	ETF	24.38	24.38	24.365	24.365	540.0
2022-06-27	AAAU	ETF	18.18	18.19	18.09	18.1	689300.0
2022-06-27	AADR	ETF	49.53	49.85	49.52	49.85	1600.0
2022-06-27	AAXJ	ETF	70.45	70.64	69.93	70.02	1381900.0
2022-06-27	ABEQ	ETF	27.438	27.53	27.39	27.408	6000.0
2022-06-27	ACES	ETF	51.61	51.94	50.82	51.57	72400.0
2022-06-27	ACIO	ETF	29.43	29.565	29.38	29.421	31700.0
2022-06-27	ACSI	ETF	43.5487	43.5487	43.5487	43.5487	132.0
2022-06-27	ACT	ETF	21.5	22.12	21.34	21.92	246485.0
2022-06-27	ACTV	ETF	31.52	31.64	31.19	31.4085	8091.0
2022-06-27	ACVF	ETF	29.23	29.4	29.23	29.342	8600.0
2022-06-27	ACWF	ETF	31.79	31.82	31.605	31.6829	7564.0
2022-06-27	ACWI	ETF	86.54	86.61	85.88	86.06	4133600.0
2022-06-27	ACWV	ETF	95.59	95.84	95.33	95.56	216100.0
2022-06-27	ACWX	ETF	45.81	45.955	45.61	45.69	4339258.0
2022-06-27	ADFI	ETF	8.49	8.49	8.46	8.465	11700.0
2022-06-27	ADIV	ETF	14.36	14.36	14.26	14.26	1000.0
2022-06-27	ADME	ETF	35.44	35.6	35.32	35.38	21600.0
2022-06-27	ADRE	ETF	40.39	40.39	40.1518	40.29	7716.0
2022-06-27	AEMB	ETF	38.28	38.28	37.873	37.873	300.0
2022-06-27	AESR	ETF	11.34	11.38	11.26	11.35	42300.0
2022-06-27	AFIF	ETF	8.89	8.89	8.86	8.8743	121326.0
2022-06-27	AFK	ETF	17.33	17.44	17.33	17.4	6183.0
2022-06-27	AFLG	ETF	23.179	23.179	23.179	23.179	100.0
2022-06-27	AFMC	ETF	21.493	21.493	21.493	21.493	100.0
2022-06-27	AFSM	ETF	22.456	22.456	22.456	22.456	100.0
2022-06-27	AFTY	ETF	18.81	18.82	18.79	18.79	1000.0
2022-06-27	AGG	ETF	100.67	100.95	100.48	100.6	8319700.0
2022-06-27	AGGY	ETF	44.302	44.42	44.21	44.26	148700.0
2022-06-27	AGNG	ETF	25.91	26.0	25.87	25.87	1500.0
2022-06-27	AGOV	ETF	79.515	80.68	79.14	79.93	4671.0
2022-06-27	AGOX	ETF	20.888	21.022	20.84	20.95	7300.0
2022-06-27	AGQ	ETF	27.44	27.44	26.78	26.84	452400.0
2022-06-27	AGZ	ETF	109.28	109.5183	109.06	109.14	21157.0
2022-06-27	AGZD	ETF	22.875	22.93	22.7	22.81	101200.0
2022-06-27	AHHX	ETF	8.59	8.59	8.51	8.55	3781.0
2022-06-27	AHYB	ETF	43.265	43.265	43.231	43.231	200.0
2022-06-27	AIA	ETF	64.65	64.73	64.115	64.16	56915.0
2022-06-27	AIEQ	ETF	32.37	32.37	31.849	31.997	14800.0
2022-06-27	AIQ	ETF	22.27	22.27	21.91	21.95	7742.0
2022-06-27	AIRR	ETF	38.21	38.6	38.03	38.329	15600.0
2022-06-27	AIVI	ETF	36.09	36.3	36.06	36.13	101900.0
2022-06-27	AIVL	ETF	90.47	90.76	90.1	90.36	7300.0
2022-06-27	ALTL	ETF	41.0	41.31	40.97	41.15	41870.0

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

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