PREVIEW / etf_daily / 2021-12-01

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-01.parquet
  size:    98 KB
  rows:    2,591

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-12-01	SPY	ETF	461.64	464.67	450.29	450.5	131939200.0
2021-12-01	QQQ	ETF	398.28	400.48	386.64	387.12	78379245.0
2021-12-01	IWM	ETF	223.17	224.21	213.15	213.26	69120100.0
2021-12-01	DIA	ETF	348.04	350.38	340.32	340.46	8415000.0
2021-12-01	GLD	ETF	166.84	167.47	166.06	166.16	7808600.0
2021-12-01	TLT	ETF	150.49	152.41	149.79	152.34	30826500.0
2021-12-01	AAA	ETF	25.0	25.0199	25.0	25.0	3340.0
2021-12-01	AAAU	ETF	17.74	17.81	17.68	17.68	171500.0
2021-12-01	AADR	ETF	62.54	62.92	61.48	61.65	6900.0
2021-12-01	AAXJ	ETF	84.44	84.92	83.36	83.36	901600.0
2021-12-01	ABEQ	ETF	27.375	27.375	26.797	26.797	1600.0
2021-12-01	ACES	ETF	75.17	75.579	70.98	71.13	70600.0
2021-12-01	ACIO	ETF	31.41	31.72	31.16	31.16	59600.0
2021-12-01	ACSI	ETF	51.61	51.61	50.2302	50.2302	201.0
2021-12-01	ACT	ETF	21.02	21.51	20.75	20.89	118452.0
2021-12-01	ACTV	ETF	36.9109	37.03	35.91	35.91	4053.0
2021-12-01	ACTX	ETF	1.5	1.5	1.35	1.35	539.0
2021-12-01	ACVF	ETF	34.59	34.7	33.6	33.6	6100.0
2021-12-01	ACWF	ETF	37.92	38.105	37.1639	37.1639	24427.0
2021-12-01	ACWI	ETF	104.15	104.74	101.74	101.74	5985000.0
2021-12-01	ACWV	ETF	104.45	105.13	103.21	103.23	123200.0
2021-12-01	ACWX	ETF	55.39	55.69	54.4	54.41	3453432.0
2021-12-01	ADFI	ETF	9.58	9.62	9.58	9.609	1100.0
2021-12-01	ADIV	ETF	17.32	17.32	17.32	17.32	200.0
2021-12-01	ADME	ETF	41.825	42.05	41.07	41.07	19200.0
2021-12-01	ADRE	ETF	47.66	48.1999	47.1499	47.15	6132.0
2021-12-01	AEMB	ETF	48.0	48.01	47.98	47.98	2000.0
2021-12-01	AESR	ETF	14.58	14.653	14.228	14.228	5900.0
2021-12-01	AFIF	ETF	9.56	9.57	9.53	9.56	73642.0
2021-12-01	AFK	ETF	20.5	20.67	20.0	20.0	14825.0
2021-12-01	AFLG	ETF	27.2	27.2	26.532	26.532	100.0
2021-12-01	AFMC	ETF	26.0	26.06	25.126	25.126	7400.0
2021-12-01	AFSM	ETF	27.24	27.24	26.272	26.272	300.0
2021-12-01	AFTY	ETF	20.694	20.694	20.694	20.694	100.0
2021-12-01	AGG	ETF	114.27	114.64	114.21	114.63	12772700.0
2021-12-01	AGGY	ETF	51.88	51.98	51.78	51.92	58200.0
2021-12-01	AGNG	ETF	27.64	28.06	27.291	27.291	2300.0
2021-12-01	AGOV	ETF	98.49	98.49	98.1556	98.1556	306.0
2021-12-01	AGOX	ETF	25.3	25.38	24.54	24.57	31500.0
2021-12-01	AGQ	ETF	33.1	33.36	31.59	31.7	1416100.0
2021-12-01	AGZ	ETF	117.63	117.79	117.52	117.54	32528.0
2021-12-01	AGZD	ETF	23.345	23.37	23.295	23.325	314800.0
2021-12-01	AHHX	ETF	10.35	10.39	10.235	10.24	29001.0
2021-12-01	AIA	ETF	78.34	78.9762	77.4	77.49	100828.0
2021-12-01	AIEQ	ETF	42.44	42.71	41.191	41.22	17500.0
2021-12-01	AIQ	ETF	32.09	32.14	30.95	30.99	32296.0
2021-12-01	AIRR	ETF	45.09	45.159	43.42	43.49	106800.0
2021-12-01	AIVI	ETF	40.57	40.69	39.84	39.84	6800.0
2021-12-01	ALTL	ETF	44.02	44.4639	43.48	43.48	71024.0
2021-12-01	ALTY	ETF	13.3	13.309	13.06	13.11	45200.0

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

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