PREVIEW / etf_daily / 2021-10-04

all etf daily files

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

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-04	SPY	ETF	433.0	433.96	426.36	428.64	128570000.0
2021-10-04	QQQ	ETF	358.52	358.86	350.32	352.62	76766005.0
2021-10-04	IWM	ETF	222.14	222.32	218.93	220.26	32580200.0
2021-10-04	DIA	ETF	342.61	344.03	338.07	340.01	7037700.0
2021-10-04	GLD	ETF	163.69	165.54	163.47	165.36	7651700.0
2021-10-04	TLT	ETF	144.67	145.46	144.1	144.98	28027600.0
2021-10-04	AAA	ETF	25.01	25.01	24.99	24.995	2940.0
2021-10-04	AAAU	ETF	17.42	17.61	17.39	17.59	321500.0
2021-10-04	AADR	ETF	62.45	62.54	62.45	62.54	2400.0
2021-10-04	AAXJ	ETF	84.06	84.17	82.94	83.44	908600.0
2021-10-04	ABEQ	ETF	26.97	27.01	26.93	26.93	900.0
2021-10-04	ACES	ETF	66.38	66.38	64.214	64.36	120100.0
2021-10-04	ACIO	ETF	30.17	30.18	29.66	29.84	77800.0
2021-10-04	ACSI	ETF	49.0693	49.0693	49.0693	49.0693	117.0
2021-10-04	ACT	ETF	21.67	21.84	20.93	21.26	126505.0
2021-10-04	ACTV	ETF	35.92	38.9	35.92	38.4889	17029.0
2021-10-04	ACTX	ETF	1.0	1.05	1.0	1.05	1986.0
2021-10-04	ACVF	ETF	32.35	32.35	31.848	31.93	13700.0
2021-10-04	ACWF	ETF	36.88	36.89	36.455	36.5505	8171.0
2021-10-04	ACWI	ETF	100.44	100.54	99.01	99.52	6345700.0
2021-10-04	ACWV	ETF	102.66	102.99	101.86	102.29	113400.0
2021-10-04	ACWX	ETF	55.32	55.32	54.69	54.97	2281144.0
2021-10-04	ADFI	ETF	9.685	9.685	9.685	9.685	100.0
2021-10-04	ADIV	ETF	16.74	16.74	16.74	16.74	100.0
2021-10-04	ADME	ETF	39.18	39.33	39.13	39.231	46800.0
2021-10-04	ADRE	ETF	47.53	47.53	46.8	46.99	11663.0
2021-10-04	AEMB	ETF	48.89	48.89	48.83	48.83	200.0
2021-10-04	AESR	ETF	13.73	13.73	13.51	13.56	26800.0
2021-10-04	AFIF	ETF	9.61	9.66	9.61	9.66	49639.0
2021-10-04	AFK	ETF	20.93	20.93	20.69	20.8	7759.0
2021-10-04	AFLG	ETF	25.26	25.27	25.26	25.27	300.0
2021-10-04	AFMC	ETF	25.13	25.13	25.097	25.097	1000.0
2021-10-04	AFSM	ETF	26.092	26.092	26.092	26.092	100.0
2021-10-04	AFTY	ETF	20.08	20.162	20.08	20.162	1700.0
2021-10-04	AGG	ETF	114.92	115.03	114.8	114.92	4180600.0
2021-10-04	AGGY	ETF	52.05	52.13	52.027	52.075	59100.0
2021-10-04	AGNG	ETF	29.068	29.068	28.79	28.83	2800.0
2021-10-04	AGOV	ETF	99.437	99.437	99.395	99.395	105.0
2021-10-04	AGOX	ETF	25.941	25.941	25.57	25.63	32800.0
2021-10-04	AGQ	ETF	32.79	33.65	32.59	33.56	924500.0
2021-10-04	AGZ	ETF	118.51	118.6	118.41	118.54	115589.0
2021-10-04	AGZD	ETF	23.44	23.455	23.41	23.435	150600.0
2021-10-04	AIA	ETF	77.0198	77.05	75.8574	76.29	89776.0
2021-10-04	AIEQ	ETF	41.48	41.48	40.64	40.792	28900.0
2021-10-04	AIQ	ETF	30.17	30.24	29.4	29.61	20304.0
2021-10-04	AIRR	ETF	41.63	41.63	41.173	41.52	28700.0
2021-10-04	AIVI	ETF	40.93	40.97	40.63	40.77	9200.0
2021-10-04	ALTL	ETF	41.67	41.68	40.64	40.92	25170.0
2021-10-04	ALTY	ETF	13.27	13.34	13.26	13.3	15200.0
2021-10-04	AMJ	ETF	18.45	18.915	18.45	18.88	862248.0

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

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