PREVIEW / etf_daily / 2021-10-25

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-25.parquet
  size:    95 KB
  rows:    2,531

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
2021-10-25	SPY	ETF	454.28	455.9	452.39	455.55	45214500.0
2021-10-25	QQQ	ETF	375.56	378.87	373.56	377.93	32597804.0
2021-10-25	IWM	ETF	227.79	229.98	227.28	229.57	16387100.0
2021-10-25	DIA	ETF	357.36	357.89	356.29	357.55	2518200.0
2021-10-25	GLD	ETF	168.66	169.21	168.53	168.93	4881300.0
2021-10-25	TLT	ETF	143.67	144.3	143.63	143.91	8137900.0
2021-10-25	AAA	ETF	24.99	25.0	24.99	25.0	121.0
2021-10-25	AAAU	ETF	17.95	18.0	17.93	17.97	280600.0
2021-10-25	AADR	ETF	66.1	66.29	66.1	66.29	400.0
2021-10-25	AAXJ	ETF	88.45	88.55	87.99	88.39	399600.0
2021-10-25	ABEQ	ETF	27.957	28.04	27.93	28.0	6100.0
2021-10-25	ACES	ETF	72.28	74.17	72.042	74.1	53900.0
2021-10-25	ACIO	ETF	31.48	31.57	31.45	31.53	45300.0
2021-10-25	ACSI	ETF	51.65	52.0439	51.65	52.0439	245.0
2021-10-25	ACT	ETF	23.0	23.15	22.57	22.71	72380.0
2021-10-25	ACTV	ETF	39.9	39.9	39.2668	39.2668	10104.0
2021-10-25	ACTX	ETF	1.02	1.02	1.02	1.02	1292.0
2021-10-25	ACVF	ETF	34.0	34.185	33.99	34.18	4400.0
2021-10-25	ACWF	ETF	38.23	38.44	38.23	38.3151	4998.0
2021-10-25	ACWI	ETF	105.01	105.36	104.65	105.27	1513400.0
2021-10-25	ACWV	ETF	105.95	106.2	105.67	105.98	48300.0
2021-10-25	ACWX	ETF	57.45	57.5862	57.27	57.49	771048.0
2021-10-25	ADFI	ETF	9.649	9.67	9.64	9.64	2400.0
2021-10-25	ADIV	ETF	17.695	17.729	17.695	17.697	1600.0
2021-10-25	ADME	ETF	41.4	41.59	41.4	41.53	30700.0
2021-10-25	ADRE	ETF	51.7	51.725	51.518	51.62	9781.0
2021-10-25	AEMB	ETF	48.895	48.9	48.895	48.9	100.0
2021-10-25	AESR	ETF	14.39	14.48	14.39	14.47	11300.0
2021-10-25	AFIF	ETF	9.615	9.63	9.61	9.62	12262.0
2021-10-25	AFK	ETF	21.97	21.97	21.85	21.85	4327.0
2021-10-25	AFLG	ETF	26.79	26.79	26.779	26.779	200.0
2021-10-25	AFMC	ETF	26.268	26.268	26.268	26.268	100.0
2021-10-25	AFSM	ETF	27.3	27.3	27.285	27.285	1200.0
2021-10-25	AFTY	ETF	21.78	21.823	21.78	21.823	6100.0
2021-10-25	AGG	ETF	114.06	114.27	114.06	114.17	8569600.0
2021-10-25	AGGY	ETF	51.55	51.68	51.55	51.65	82800.0
2021-10-25	AGNG	ETF	29.8	29.8	29.61	29.711	3200.0
2021-10-25	AGOV	ETF	99.325	99.365	99.24	99.365	503.0
2021-10-25	AGOX	ETF	27.22	27.27	27.13	27.16	22500.0
2021-10-25	AGQ	ETF	39.14	39.62	38.75	39.46	703600.0
2021-10-25	AGZ	ETF	117.73	117.92	117.73	117.9	20011.0
2021-10-25	AGZD	ETF	23.46	23.475	23.42	23.42	99000.0
2021-10-25	AIA	ETF	82.76	82.86	82.19	82.58	36388.0
2021-10-25	AIEQ	ETF	43.05	43.38	43.01	43.265	10500.0
2021-10-25	AIQ	ETF	31.7	31.8599	31.55	31.79	35932.0
2021-10-25	AIRR	ETF	43.32	43.68	43.04	43.633	15400.0
2021-10-25	AIVI	ETF	41.68	41.74	41.68	41.71	4500.0
2021-10-25	ALTL	ETF	43.25	43.53	43.21	43.44	60695.0
2021-10-25	ALTY	ETF	13.69	13.72	13.66	13.72	57800.0
2021-10-25	AMJ	ETF	20.05	20.05	19.685	19.81	904896.0

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

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