PREVIEW / etf_daily / 2021-01-06

all etf daily files

  file:    by_date/etf_daily/2021/2021-01-06.parquet
  size:    84 KB
  rows:    2,223

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-01-06	SPY	ETF	369.71	376.98	369.12	373.55	107997700.0
2021-01-06	QQQ	ETF	307.0	311.88	305.98	307.54	52809622.0
2021-01-06	IWM	ETF	199.48	206.78	199.16	204.53	52952200.0
2021-01-06	DIA	ETF	303.75	310.24	303.06	308.21	7290300.0
2021-01-06	GLD	ETF	181.49	181.58	178.24	179.9	18453500.0
2021-01-06	TLT	ETF	153.82	153.85	152.29	153.16	22827300.0
2021-01-06	AAA	ETF	25.08	25.09	25.075	25.075	622.0
2021-01-06	AAAU	ETF	19.27	19.27	18.93	19.1	1425400.0
2021-01-06	AADR	ETF	61.86	62.32	61.62	61.82	23600.0
2021-01-06	AAXJ	ETF	92.01	92.74	91.39	91.64	1613000.0
2021-01-06	ABEQ	ETF	25.69	25.89	25.69	25.89	100.0
2021-01-06	ACES	ETF	84.5	89.54	84.05	87.52	1146400.0
2021-01-06	ACIO	ETF	27.64	27.909	27.64	27.72	9700.0
2021-01-06	ACSI	ETF	43.08	43.1852	43.08	43.1852	474.0
2021-01-06	ACTV	ETF	32.45	32.8	32.19	32.5903	12373.0
2021-01-06	ACTX	ETF	2.5	2.7	2.45	2.68	1594.0
2021-01-06	ACVF	ETF	27.665	27.88	27.665	27.706	3000.0
2021-01-06	ACWF	ETF	34.2201	34.63	34.2201	34.3787	4699.0
2021-01-06	ACWI	ETF	90.83	92.42	90.72	91.66	9674400.0
2021-01-06	ACWV	ETF	96.29	97.6	96.29	97.38	404000.0
2021-01-06	ACWX	ETF	54.04	54.7589	53.99	54.33	1305552.0
2021-01-06	ADFI	ETF	9.906	9.906	9.906	9.906	100.0
2021-01-06	ADME	ETF	35.86	35.97	35.502	35.76	9600.0
2021-01-06	ADRE	ETF	57.57	58.4599	57.2666	57.315	17142.0
2021-01-06	AESR	ETF	11.74	11.94	11.74	11.816	2700.0
2021-01-06	AFIF	ETF	9.72	9.74	9.72	9.73	19354.0
2021-01-06	AFK	ETF	20.81	21.01	20.7438	20.81	17254.0
2021-01-06	AFLG	ETF	22.33	22.402	22.33	22.402	300.0
2021-01-06	AFMC	ETF	21.705	22.075	21.705	22.075	200.0
2021-01-06	AFSM	ETF	23.23	23.23	23.206	23.206	400.0
2021-01-06	AFTY	ETF	24.02	24.13	24.02	24.128	7000.0
2021-01-06	AGG	ETF	117.9	117.9	117.15	117.34	10687200.0
2021-01-06	AGGY	ETF	53.35	53.36	53.07	53.27	176500.0
2021-01-06	AGNG	ETF	27.86	28.284	27.86	28.18	4600.0
2021-01-06	AGQ	ETF	54.44	54.7	51.69	54.33	2217900.0
2021-01-06	AGZ	ETF	119.41	119.41	119.26	119.31	25302.0
2021-01-06	AGZD	ETF	23.515	23.615	23.515	23.55	362800.0
2021-01-06	AIA	ETF	89.82	90.66	89.4	89.71	309246.0
2021-01-06	AIEQ	ETF	35.84	36.86	35.7	36.41	19900.0
2021-01-06	AIQ	ETF	27.01	27.3	26.85	26.87	58800.0
2021-01-06	AIRR	ETF	34.3	36.72	34.3	36.488	54000.0
2021-01-06	AIVI	ETF	41.49	41.95	41.49	41.78	24500.0
2021-01-06	ALTL	ETF	33.508	33.75	33.2886	33.4	6991.0
2021-01-06	ALTY	ETF	11.74	11.812	11.675	11.81	12400.0
2021-01-06	AMJ	ETF	14.38	14.99	14.24	14.93	1536147.0
2021-01-06	AMLP	ETF	26.95	27.75	26.34	27.67	5249200.0
2021-01-06	AMNA	ETF	26.7374	26.7374	26.7374	26.7374	0.0
2021-01-06	AMND	ETF	28.6023	28.6023	28.6023	28.6023	2.0
2021-01-06	AMOM	ETF	31.89	31.89	31.602	31.602	1200.0
2021-01-06	AMTR	ETF	29.77	30.27	29.77	30.1797	22600.0

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

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