PREVIEW / etf_daily / 2021-01-07

all etf daily files

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

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-07	SPY	ETF	376.1	379.9	375.91	379.1	68766800.0
2021-01-07	QQQ	ETF	310.28	315.84	310.25	314.98	30394826.0
2021-01-07	IWM	ETF	205.71	208.52	205.7	208.17	24031400.0
2021-01-07	DIA	ETF	309.72	311.98	309.06	310.5	4107900.0
2021-01-07	GLD	ETF	179.69	179.92	178.84	179.48	7110200.0
2021-01-07	TLT	ETF	151.79	152.17	151.26	151.81	14651900.0
2021-01-07	AAA	ETF	25.075	25.075	25.075	25.075	402.0
2021-01-07	AAAU	ETF	19.07	19.1	18.99	19.05	330200.0
2021-01-07	AADR	ETF	62.0	62.49	62.0	62.41	3200.0
2021-01-07	AAXJ	ETF	92.19	92.67	91.74	92.56	1758300.0
2021-01-07	ABEQ	ETF	26.02	26.07	25.982	26.065	6600.0
2021-01-07	ACES	ETF	92.87	93.87	91.0	93.11	508100.0
2021-01-07	ACIO	ETF	27.85	27.97	27.85	27.95	34400.0
2021-01-07	ACSI	ETF	43.83	43.83	43.7938	43.7938	208.0
2021-01-07	ACTV	ETF	32.98	32.98	32.525	32.87	4802.0
2021-01-07	ACTX	ETF	2.4	2.4	2.4	2.4	372.0
2021-01-07	ACVF	ETF	27.9	28.145	27.9	28.145	1000.0
2021-01-07	ACWF	ETF	34.49	34.811	34.49	34.811	6906.0
2021-01-07	ACWI	ETF	92.09	92.78	92.01	92.62	4807800.0
2021-01-07	ACWV	ETF	97.23	97.51	97.0	97.36	405500.0
2021-01-07	ACWX	ETF	54.44	54.651	54.34	54.62	1430046.0
2021-01-07	ADFI	ETF	9.892	9.892	9.892	9.892	100.0
2021-01-07	ADME	ETF	35.84	36.265	35.84	36.26	10400.0
2021-01-07	ADRE	ETF	57.93	58.46	57.4916	58.34	24278.0
2021-01-07	AESR	ETF	11.95	12.011	11.95	12.011	3000.0
2021-01-07	AFIF	ETF	9.75	9.76	9.74	9.76	297111.0
2021-01-07	AFK	ETF	20.9	21.08	20.8903	21.01	5338.0
2021-01-07	AFLG	ETF	22.58	22.744	22.58	22.744	500.0
2021-01-07	AFMC	ETF	22.41	22.428	22.41	22.428	200.0
2021-01-07	AFSM	ETF	23.6	23.624	23.6	23.624	200.0
2021-01-07	AFTY	ETF	24.54	24.725	24.54	24.725	4500.0
2021-01-07	AGG	ETF	117.13	117.26	117.07	117.22	6639400.0
2021-01-07	AGGY	ETF	53.22	53.22	53.16	53.2	155500.0
2021-01-07	AGNG	ETF	28.24	28.521	28.184	28.44	4300.0
2021-01-07	AGQ	ETF	53.87	54.45	53.1	54.09	906800.0
2021-01-07	AGZ	ETF	119.28	119.28	119.19	119.19	76810.0
2021-01-07	AGZD	ETF	23.555	23.59	23.51	23.59	7000.0
2021-01-07	AIA	ETF	90.21	90.89	89.9666	90.73	401394.0
2021-01-07	AIEQ	ETF	37.04	37.61	37.04	37.54	38900.0
2021-01-07	AIQ	ETF	27.1	27.5	27.01	27.44	64976.0
2021-01-07	AIRR	ETF	36.85	37.08	36.69	36.983	37800.0
2021-01-07	AIVI	ETF	41.9	41.97	41.83	41.96	7600.0
2021-01-07	ALTL	ETF	33.72	34.095	33.72	34.035	4601.0
2021-01-07	ALTY	ETF	11.82	11.84	11.78	11.78	15400.0
2021-01-07	AMJ	ETF	15.15	15.305	14.93	15.18	1054927.0
2021-01-07	AMLP	ETF	27.83	28.36	27.62	28.13	3447700.0
2021-01-07	AMNA	ETF	27.2128	27.2128	27.2128	27.2128	0.0
2021-01-07	AMND	ETF	29.01	29.01	29.01	29.01	0.0
2021-01-07	AMOM	ETF	31.75	32.567	31.75	32.567	2900.0
2021-01-07	AMTR	ETF	30.42	30.7211	30.4	30.7211	708.0

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

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