PREVIEW / etf_daily / 2022-03-25

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-25.parquet
  size:    100 KB
  rows:    2,677

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-03-25	SPY	ETF	451.16	452.98	448.43	452.69	77101300.0
2022-03-25	QQQ	ETF	359.59	360.67	354.9438	359.35	57584158.0
2022-03-25	IWM	ETF	206.09	206.62	204.44	206.12	19430400.0
2022-03-25	DIA	ETF	347.8	349.32	346.19	348.54	3206200.0
2022-03-25	GLD	ETF	181.81	183.13	181.35	182.38	7911100.0
2022-03-25	TLT	ETF	129.5	129.52	127.65	128.66	25684500.0
2022-03-25	AAA	ETF	24.8	24.8	24.785	24.785	428.0
2022-03-25	AAAU	ETF	19.35	19.5	19.32	19.42	639000.0
2022-03-25	AADR	ETF	59.63	59.77	59.34	59.77	3800.0
2022-03-25	AAXJ	ETF	74.92	75.13	74.56	75.1	1003600.0
2022-03-25	ABEQ	ETF	29.65	30.08	29.65	30.08	15800.0
2022-03-25	ACES	ETF	63.35	63.35	61.302	62.07	30000.0
2022-03-25	ACIO	ETF	31.44	31.44	31.22	31.43	40200.0
2022-03-25	ACSI	ETF	50.34	50.6161	50.34	50.6161	418.0
2022-03-25	ACT	ETF	22.58	22.95	22.27	22.87	71602.0
2022-03-25	ACTV	ETF	35.73	35.8327	35.56	35.8327	8964.0
2022-03-25	ACTX	ETF	0.885	0.885	0.885	0.885	202.0
2022-03-25	ACVF	ETF	33.697	33.87	33.69	33.87	1900.0
2022-03-25	ACWF	ETF	37.09	37.2044	36.98	37.2044	7077.0
2022-03-25	ACWI	ETF	99.72	100.08	99.16	99.98	3842000.0
2022-03-25	ACWV	ETF	103.73	104.11	103.52	104.07	2558200.0
2022-03-25	ACWX	ETF	52.22	52.35	51.97	52.35	1938827.0
2022-03-25	ADFI	ETF	8.96	8.96	8.96	8.96	200.0
2022-03-25	ADIV	ETF	15.613	15.613	15.613	15.613	100.0
2022-03-25	ADME	ETF	41.24	41.24	40.698	40.96	13400.0
2022-03-25	ADRE	ETF	44.37	44.6351	44.1	44.5784	6933.0
2022-03-25	AEMB	ETF	42.547	42.547	42.547	42.547	100.0
2022-03-25	AESR	ETF	13.41	13.445	13.39	13.43	2600.0
2022-03-25	AFIF	ETF	9.16	9.16	9.15	9.155	29699.0
2022-03-25	AFK	ETF	21.39	21.39	21.21	21.33	4714.0
2022-03-25	AFLG	ETF	26.72	26.837	26.72	26.837	200.0
2022-03-25	AFMC	ETF	24.93	25.031	24.93	25.031	100.0
2022-03-25	AFSM	ETF	25.98	26.074	25.98	26.074	100.0
2022-03-25	AFTY	ETF	17.92	17.92	17.84	17.888	600.0
2022-03-25	AGG	ETF	106.57	106.65	105.98	106.1	10538700.0
2022-03-25	AGGY	ETF	47.55	47.579	47.361	47.41	136800.0
2022-03-25	AGNG	ETF	28.08	28.15	28.041	28.1	2800.0
2022-03-25	AGOV	ETF	83.1	84.39	82.16	82.4616	2156.0
2022-03-25	AGOX	ETF	24.39	24.39	23.84	24.03	54900.0
2022-03-25	AGQ	ETF	40.72	40.98	40.16	40.65	521100.0
2022-03-25	AGZ	ETF	112.62	112.62	112.21	112.2823	28145.0
2022-03-25	AGZD	ETF	23.21	23.23	23.12	23.225	128600.0
2022-03-25	AHHX	ETF	9.45	9.51	9.4	9.455	15821.0
2022-03-25	AHYB	ETF	47.278	47.278	47.044	47.044	400.0
2022-03-25	AIA	ETF	68.74	68.92	68.37	68.92	55242.0
2022-03-25	AIEQ	ETF	37.18	37.19	36.9	37.14	8100.0
2022-03-25	AIQ	ETF	27.05	27.05	26.57	26.79	16448.0
2022-03-25	AIRR	ETF	43.41	43.43	43.1	43.16	21100.0
2022-03-25	AIVI	ETF	40.28	40.37	40.28	40.37	1400.0
2022-03-25	AIVL	ETF	98.97	99.19	98.58	99.16	13400.0

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

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