PREVIEW / etf_daily / 2021-10-06

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-06.parquet
  size:    94 KB
  rows:    2,524

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-06	SPY	ETF	429.27	435.12	427.54	434.9	113032200.0
2021-10-06	QQQ	ETF	354.08	359.95	353.15	359.67	56806536.0
2021-10-06	IWM	ETF	218.76	220.2	216.76	219.87	32893300.0
2021-10-06	DIA	ETF	340.48	344.3	338.47	344.12	6276300.0
2021-10-06	GLD	ETF	164.23	165.06	164.15	165.03	6067200.0
2021-10-06	TLT	ETF	144.23	144.72	144.03	144.39	18696500.0
2021-10-06	AAA	ETF	24.99	24.99	24.99	24.99	530.0
2021-10-06	AAAU	ETF	17.47	17.55	17.46	17.55	206000.0
2021-10-06	AADR	ETF	62.2	62.48	62.2	62.48	1300.0
2021-10-06	AAXJ	ETF	82.94	83.63	82.67	83.62	603800.0
2021-10-06	ABEQ	ETF	26.908	27.186	26.885	27.186	3700.0
2021-10-06	ACES	ETF	63.8	64.57	63.073	64.28	246600.0
2021-10-06	ACIO	ETF	29.88	30.24	29.88	30.24	39400.0
2021-10-06	ACSI	ETF	49.7816	49.7816	49.7816	49.7816	10.0
2021-10-06	ACT	ETF	20.81	21.17	20.56	21.0	52177.0
2021-10-06	ACTV	ETF	38.055	38.48	37.9909	38.48	11760.0
2021-10-06	ACVF	ETF	32.57	32.57	31.865	32.46	15300.0
2021-10-06	ACWF	ETF	36.59	36.7432	36.32	36.7432	5402.0
2021-10-06	ACWI	ETF	99.31	100.5	98.94	100.46	6572800.0
2021-10-06	ACWV	ETF	101.71	102.85	101.65	102.84	210900.0
2021-10-06	ACWX	ETF	54.5	55.03	54.325	55.0	19630408.0
2021-10-06	ADFI	ETF	9.67	9.67	9.64	9.663	9400.0
2021-10-06	ADIV	ETF	16.56	16.699	16.455	16.699	1600.0
2021-10-06	ADME	ETF	39.41	39.908	39.41	39.83	57600.0
2021-10-06	ADRE	ETF	46.85	47.405	46.71	47.405	8084.0
2021-10-06	AEMB	ETF	48.69	48.69	48.69	48.69	100.0
2021-10-06	AESR	ETF	13.58	13.8	13.58	13.8	31100.0
2021-10-06	AFIF	ETF	9.65	9.66	9.65	9.655	6341.0
2021-10-06	AFK	ETF	20.84	20.88	20.8	20.88	12271.0
2021-10-06	AFLG	ETF	25.25	25.514	25.25	25.514	200.0
2021-10-06	AFSM	ETF	26.192	26.192	26.192	26.192	100.0
2021-10-06	AFTY	ETF	19.97	20.265	19.9	20.265	2800.0
2021-10-06	AGG	ETF	114.68	114.73	114.59	114.7	4893400.0
2021-10-06	AGGY	ETF	51.95	51.973	51.9	51.958	49000.0
2021-10-06	AGNG	ETF	28.55	28.81	28.4	28.64	11400.0
2021-10-06	AGOV	ETF	99.05	99.05	99.05	99.05	20.0
2021-10-06	AGOX	ETF	25.86	25.875	25.6	25.85	38600.0
2021-10-06	AGQ	ETF	32.78	33.58	32.44	33.47	1027900.0
2021-10-06	AGZ	ETF	118.36	118.47	118.36	118.42	24205.0
2021-10-06	AGZD	ETF	23.42	23.43	23.405	23.425	25400.0
2021-10-06	AIA	ETF	75.56	76.56	75.5224	76.46	54615.0
2021-10-06	AIEQ	ETF	40.72	41.31	40.59	41.26	8100.0
2021-10-06	AIQ	ETF	29.66	30.13	29.6	30.0694	221174.0
2021-10-06	AIRR	ETF	41.38	41.38	40.705	41.265	27300.0
2021-10-06	AIVI	ETF	40.44	40.72	40.37	40.72	6700.0
2021-10-06	ALTL	ETF	40.79	41.1581	40.5	41.11	121926.0
2021-10-06	ALTY	ETF	13.12	13.3	13.12	13.3	26700.0
2021-10-06	AMJ	ETF	18.62	18.65	18.2	18.39	518672.0
2021-10-06	AMLP	ETF	34.2	34.23	33.42	33.82	2378000.0
2021-10-06	AMNA	ETF	33.6954	33.6954	33.6954	33.6954	1.0

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

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