PREVIEW / etf_daily / 2021-10-07

all etf daily files

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

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-07	SPY	ETF	438.39	441.68	438.2	438.66	72437500.0
2021-10-07	QQQ	ETF	362.8	365.69	362.25	362.97	39411172.0
2021-10-07	IWM	ETF	221.53	224.95	221.37	223.26	24289300.0
2021-10-07	DIA	ETF	346.87	349.77	346.77	347.63	5310400.0
2021-10-07	GLD	ETF	164.02	164.85	163.96	164.16	4791500.0
2021-10-07	TLT	ETF	143.19	143.34	142.59	142.88	14856000.0
2021-10-07	AAA	ETF	25.0	25.0	24.995	24.995	1400.0
2021-10-07	AAAU	ETF	17.44	17.53	17.44	17.46	55300.0
2021-10-07	AADR	ETF	62.5	63.47	62.5	63.38	3100.0
2021-10-07	AAXJ	ETF	84.8	85.75	84.8	85.42	594000.0
2021-10-07	ABEQ	ETF	27.55	27.55	27.398	27.403	4800.0
2021-10-07	ACES	ETF	65.11	66.6	65.11	65.88	488300.0
2021-10-07	ACIO	ETF	30.52	30.58	30.41	30.43	18100.0
2021-10-07	ACSI	ETF	50.3402	50.3402	50.3402	50.3402	23.0
2021-10-07	ACT	ETF	21.1	21.2	20.51	20.91	94973.0
2021-10-07	ACTV	ETF	38.86	39.14	38.8501	38.8644	7139.0
2021-10-07	ACTX	ETF	1.0325	1.0325	0.8782	1.0	3186.0
2021-10-07	ACVF	ETF	32.6	32.885	32.6	32.697	4700.0
2021-10-07	ACWF	ETF	37.32	37.42	37.2062	37.2062	4715.0
2021-10-07	ACWI	ETF	101.27	102.05	101.25	101.56	5346200.0
2021-10-07	ACWV	ETF	103.16	104.03	103.16	103.54	65300.0
2021-10-07	ACWX	ETF	55.45	55.84	55.45	55.68	991834.0
2021-10-07	ADFI	ETF	9.655	9.655	9.655	9.655	200.0
2021-10-07	ADIV	ETF	16.954	16.954	16.954	16.954	100.0
2021-10-07	ADME	ETF	40.35	40.38	40.198	40.2	15700.0
2021-10-07	ADRE	ETF	48.48	49.389	48.48	49.14	9708.0
2021-10-07	AEMB	ETF	48.79	48.79	48.79	48.79	100.0
2021-10-07	AESR	ETF	13.88	14.01	13.88	13.93	2800.0
2021-10-07	AFIF	ETF	9.63	9.63	9.62	9.625	13841.0
2021-10-07	AFK	ETF	20.99	21.17	20.97	21.08	4116.0
2021-10-07	AFLG	ETF	25.87	25.89	25.755	25.755	600.0
2021-10-07	AFMC	ETF	25.63	25.63	25.486	25.486	700.0
2021-10-07	AFSM	ETF	26.74	26.75	26.614	26.614	900.0
2021-10-07	AFTY	ETF	20.655	20.655	20.655	20.655	100.0
2021-10-07	AGG	ETF	114.46	114.5	114.34	114.38	4456100.0
2021-10-07	AGGY	ETF	51.86	51.86	51.765	51.786	52600.0
2021-10-07	AGNG	ETF	28.79	29.149	28.79	28.98	2800.0
2021-10-07	AGOV	ETF	98.95	99.08	98.95	99.08	275.0
2021-10-07	AGOX	ETF	26.15	26.33	26.13	26.14	24700.0
2021-10-07	AGQ	ETF	32.9	33.89	32.84	33.29	887400.0
2021-10-07	AGZ	ETF	118.38	118.38	118.2208	118.23	44825.0
2021-10-07	AGZD	ETF	23.44	23.44	23.41	23.41	13600.0
2021-10-07	AIA	ETF	78.06	79.3381	78.06	79.07	181448.0
2021-10-07	AIEQ	ETF	41.61	42.32	41.61	42.046	15400.0
2021-10-07	AIQ	ETF	30.47	30.828	30.47	30.64	16048.0
2021-10-07	AIRR	ETF	41.825	42.349	41.825	42.1	17000.0
2021-10-07	AIVI	ETF	41.0	41.03	40.86	40.86	8300.0
2021-10-07	ALTL	ETF	41.57	41.9299	41.53	41.53	28908.0
2021-10-07	ALTY	ETF	13.305	13.43	13.305	13.351	15300.0
2021-10-07	AMJ	ETF	18.46	18.76	18.37	18.75	383605.0

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

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