PREVIEW / etf_daily / 2020-11-25

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-25.parquet
  size:    80 KB
  rows:    2,120

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
2020-11-25	SPY	ETF	363.13	363.16	361.48	362.66	45330900.0
2020-11-25	QQQ	ETF	295.44	296.94	294.59	296.28	23326826.0
2020-11-25	IWM	ETF	183.5	184.31	181.89	183.59	21082700.0
2020-11-25	DIA	ETF	299.95	300.04	298.05	298.74	2629200.0
2020-11-25	GLD	ETF	169.98	170.52	169.24	169.51	10286600.0
2020-11-25	TLT	ETF	159.25	159.91	158.62	158.68	9145800.0
2020-11-25	AAA	ETF	25.05	25.05	25.05	25.05	228.0
2020-11-25	AAAU	ETF	18.03	18.1	17.98	17.98	386300.0
2020-11-25	AADR	ETF	56.87	57.33	56.87	57.17	6700.0
2020-11-25	AAXJ	ETF	86.11	86.35	85.83	86.31	1133500.0
2020-11-25	ABEQ	ETF	24.878	25.0	24.85	24.935	6000.0
2020-11-25	ACES	ETF	69.26	70.62	68.93	70.38	102900.0
2020-11-25	ACIO	ETF	27.37	27.37	27.26	27.33	10200.0
2020-11-25	ACSI	ETF	42.1728	42.1728	42.1728	42.1728	141.0
2020-11-25	ACTV	ETF	29.39	29.6	29.3004	29.5491	5630.0
2020-11-25	ACTX	ETF	2.8	2.8	2.8	2.8	738.0
2020-11-25	ACVF	ETF	26.87	26.89	26.85	26.864	2000.0
2020-11-25	ACWF	ETF	32.27	32.31	32.2176	32.24	1695.0
2020-11-25	ACWI	ETF	87.74	88.02	87.46	87.87	1404000.0
2020-11-25	ACWV	ETF	95.72	95.81	95.49	95.74	184800.0
2020-11-25	ACWX	ETF	51.22	51.53	51.12	51.47	1725293.0
2020-11-25	ADME	ETF	34.804	35.028	34.804	34.94	12500.0
2020-11-25	ADRE	ETF	53.99	54.46	53.99	54.42	7907.0
2020-11-25	AESR	ETF	11.59	11.59	11.51	11.55	21500.0
2020-11-25	AFIF	ETF	9.72	9.8096	9.72	9.8	26898.0
2020-11-25	AFK	ETF	20.02	20.09	19.9	20.0694	9882.0
2020-11-25	AFLG	ETF	21.52	21.571	21.52	21.571	2100.0
2020-11-25	AFSM	ETF	20.63	20.63	20.605	20.605	100.0
2020-11-25	AFTY	ETF	21.63	21.63	21.5	21.614	7400.0
2020-11-25	AGG	ETF	118.15	118.21	118.02	118.06	4125000.0
2020-11-25	AGGY	ETF	53.71	53.83	53.71	53.71	104500.0
2020-11-25	AGNG	ETF	26.49	26.53	26.42	26.452	4500.0
2020-11-25	AGQ	ETF	40.61	41.02	40.3	40.58	712200.0
2020-11-25	AGZ	ETF	120.86	120.8872	120.76	120.79	20694.0
2020-11-25	AGZD	ETF	23.54	23.545	23.48	23.54	11000.0
2020-11-25	AIA	ETF	82.32	82.64	82.12	82.59	115983.0
2020-11-25	AIEQ	ETF	32.97	33.4	32.97	33.39	10600.0
2020-11-25	AIQ	ETF	25.6	25.71	25.55	25.68	24478.0
2020-11-25	AIRR	ETF	32.5	32.5	32.099	32.321	15200.0
2020-11-25	AIVI	ETF	39.53	39.69	39.53	39.66	5700.0
2020-11-25	ALTL	ETF	31.01	31.19	31.01	31.0675	27425.0
2020-11-25	ALTY	ETF	11.75	11.77	11.685	11.726	10500.0
2020-11-25	AMJ	ETF	14.81	14.895	14.46	14.76	8003143.0
2020-11-25	AMLP	ETF	26.75	26.98	26.17	26.68	3046600.0
2020-11-25	AMNA	ETF	26.28	26.28	26.2072	26.2072	260.0
2020-11-25	AMND	ETF	27.9528	27.9528	27.9528	27.9528	0.0
2020-11-25	AMOM	ETF	37.46	37.682	37.46	37.682	400.0
2020-11-25	AMTR	ETF	29.42	29.73	29.33	29.56	27554.0
2020-11-25	AMUB	ETF	9.18	9.33	9.165	9.255	34674.0
2020-11-25	AMZA	ETF	19.8	19.955	19.18	19.71	91900.0

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

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