PREVIEW / etf_daily / 2022-06-09

all etf daily files

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

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-09	SPY	ETF	409.34	411.74	401.44	401.44	86289800.0
2022-06-09	QQQ	ETF	305.91	309.05	299.23	299.4	55900475.0
2022-06-09	IWM	ETF	186.55	187.07	183.53	183.57	21697200.0
2022-06-09	DIA	ETF	328.16	329.99	323.0	323.0	2591500.0
2022-06-09	GLD	ETF	172.45	172.59	171.58	172.23	4701100.0
2022-06-09	TLT	ETF	113.84	114.71	113.68	114.48	15527300.0
2022-06-09	AAA	ETF	24.51	24.51	24.51	24.51	11.0
2022-06-09	AAAU	ETF	18.36	18.38	18.28	18.35	1205900.0
2022-06-09	AADR	ETF	54.71	54.71	54.03	54.03	1300.0
2022-06-09	AAXJ	ETF	71.8	71.97	70.73	70.73	1149300.0
2022-06-09	ABEQ	ETF	28.717	28.717	28.351	28.351	9100.0
2022-06-09	ACES	ETF	54.46	55.125	53.52	53.58	54500.0
2022-06-09	ACIO	ETF	30.195	30.195	29.65	29.67	26400.0
2022-06-09	ACSI	ETF	44.1189	44.1189	44.1189	44.1189	82.0
2022-06-09	ACT	ETF	24.1	24.51	23.62	23.7	279034.0
2022-06-09	ACTV	ETF	32.7	32.8399	32.2635	32.2635	10390.0
2022-06-09	ACTX	ETF	0.75	0.7501	0.75	0.75	5895.0
2022-06-09	ACVF	ETF	30.76	31.15	30.426	30.426	9500.0
2022-06-09	ACWF	ETF	33.74	33.74	33.1906	33.1906	2175.0
2022-06-09	ACWI	ETF	90.59	90.95	88.94	88.94	3580400.0
2022-06-09	ACWV	ETF	96.42	97.02	95.25	95.25	547700.0
2022-06-09	ACWX	ETF	48.21	48.36	47.51	47.51	3031362.0
2022-06-09	ADFI	ETF	8.66	8.67	8.64	8.645	2700.0
2022-06-09	ADIV	ETF	14.62	14.62	14.62	14.62	300.0
2022-06-09	ADME	ETF	37.125	37.279	36.6	36.6	19600.0
2022-06-09	ADRE	ETF	42.62	42.62	41.25	41.69	1990.0
2022-06-09	AESR	ETF	12.14	12.2	11.93	11.93	40700.0
2022-06-09	AFIF	ETF	9.05	9.06	9.04	9.05	9327.0
2022-06-09	AFK	ETF	19.23	19.23	18.65	18.76	17893.0
2022-06-09	AFLG	ETF	24.127	24.127	24.127	24.127	200.0
2022-06-09	AFMC	ETF	23.34	23.34	23.01	23.01	500.0
2022-06-09	AFSM	ETF	24.07	24.07	23.85	23.85	200.0
2022-06-09	AFTY	ETF	17.54	17.59	17.423	17.423	4500.0
2022-06-09	AGG	ETF	102.07	102.22	101.97	102.05	5423500.0
2022-06-09	AGGY	ETF	45.12	45.235	45.12	45.12	165400.0
2022-06-09	AGNG	ETF	25.75	25.75	25.3	25.3	700.0
2022-06-09	AGOV	ETF	79.7466	79.7466	79.7466	79.7466	183.0
2022-06-09	AGOX	ETF	22.251	22.312	21.927	21.927	19900.0
2022-06-09	AGQ	ETF	29.31	29.33	28.16	28.49	544200.0
2022-06-09	AGZ	ETF	109.86	110.02	109.74	109.77	33110.0
2022-06-09	AGZD	ETF	23.08	23.09	23.025	23.04	68600.0
2022-06-09	AHHX	ETF	9.0601	9.08	9.0177	9.0177	2670.0
2022-06-09	AHYB	ETF	44.725	44.725	44.503	44.503	500.0
2022-06-09	AIA	ETF	66.6	66.63	65.35	65.35	59983.0
2022-06-09	AIEQ	ETF	34.45	34.45	33.791	33.791	2800.0
2022-06-09	AIQ	ETF	23.0	23.24	22.6	22.6	13565.0
2022-06-09	AIRR	ETF	41.53	41.625	41.22	41.22	2400.0
2022-06-09	AIVI	ETF	39.19	39.25	38.74	38.74	2200.0
2022-06-09	AIVL	ETF	95.69	95.92	94.19	94.19	5500.0
2022-06-09	ALTL	ETF	42.23	42.3897	41.405	41.41	99195.0

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

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