PREVIEW / etf_daily / 2020-03-03

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-03.parquet
  size:    76 KB
  rows:    1,976

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-03-03	SPY	ETF	309.5	313.84	297.57	300.24	300139100.0
2020-03-03	QQQ	ETF	217.11	219.61	207.62	209.48	131953546.0
2020-03-03	IWM	ETF	151.09	154.2	146.31	147.95	42941300.0
2020-03-03	DIA	ETF	267.8	271.02	257.18	259.3	11482600.0
2020-03-03	GLD	ETF	150.84	155.24	150.74	153.89	28687700.0
2020-03-03	TLT	ETF	153.81	159.7	152.36	156.33	38608000.0
2020-03-03	AAAU	ETF	15.99	16.42	15.98	16.31	256700.0
2020-03-03	AADR	ETF	51.18	52.05	50.47	50.75	24500.0
2020-03-03	AAXJ	ETF	69.29	70.12	68.39	68.89	1910600.0
2020-03-03	ABEQ	ETF	23.56	23.56	23.195	23.242	3700.0
2020-03-03	ACES	ETF	39.0	40.32	38.312	38.68	100100.0
2020-03-03	ACIO	ETF	24.9	24.91	24.19	24.2	106700.0
2020-03-03	ACSI	ETF	34.1335	34.72	33.3571	33.3961	3201.0
2020-03-03	ACTX	ETF	8.3781	8.3781	6.4458	6.4458	224.0
2020-03-03	ACWF	ETF	29.08	29.3	28.49	28.5589	33657.0
2020-03-03	ACWI	ETF	74.85	75.93	72.66	72.87	6983500.0
2020-03-03	ACWV	ETF	93.44	95.34	91.65	92.45	528000.0
2020-03-03	ACWX	ETF	45.21	45.76	44.31	44.7	2326025.0
2020-03-03	ADME	ETF	30.64	30.99	30.13	30.14	20500.0
2020-03-03	ADRE	ETF	40.82	41.0747	39.72	40.195	10542.0
2020-03-03	AESR	ETF	9.621	9.621	9.36	9.418	1500.0
2020-03-03	AFIF	ETF	10.06	10.06	9.9117	9.975	1581.0
2020-03-03	AFK	ETF	17.84	17.89	17.54	17.61	23053.0
2020-03-03	AFLG	ETF	18.919	18.919	18.919	18.919	100.0
2020-03-03	AFMC	ETF	18.332	18.332	18.332	18.332	100.0
2020-03-03	AFSM	ETF	18.56	18.56	18.059	18.059	200.0
2020-03-03	AFTY	ETF	16.703	16.81	16.55	16.55	6800.0
2020-03-03	AGG	ETF	116.05	117.26	116.01	116.73	12541000.0
2020-03-03	AGGY	ETF	53.81	54.25	53.8	54.1	536900.0
2020-03-03	AGNG	ETF	22.91	23.12	22.715	22.83	12900.0
2020-03-03	AGQ	ETF	27.36	29.42	27.3	28.38	457900.0
2020-03-03	AGZ	ETF	119.06	119.97	119.055	119.69	57849.0
2020-03-03	AGZD	ETF	23.825	23.85	23.725	23.79	30200.0
2020-03-03	AIA	ETF	62.84	63.47	62.15	62.3559	54508.0
2020-03-03	AIEQ	ETF	27.53	27.883	26.51	26.79	133600.0
2020-03-03	AIQ	ETF	18.03	18.2178	17.4394	17.54	42157.0
2020-03-03	AIRR	ETF	26.28	26.704	25.54	25.808	4600.0
2020-03-03	AIVI	ETF	38.08	38.55	37.45	37.7	21900.0
2020-03-03	ALTY	ETF	14.05	14.08	13.745	13.775	16300.0
2020-03-03	AMJ	ETF	17.74	18.19	17.13	17.35	7168287.0
2020-03-03	AMLP	ETF	34.55	35.3	33.2	33.65	7090700.0
2020-03-03	AMOM	ETF	25.218	25.218	25.218	25.218	100.0
2020-03-03	AMUB	ETF	10.94	10.94	10.9351	10.9351	400.0
2020-03-03	AMZA	ETF	33.0	33.8	31.1	31.8	124840.0
2020-03-03	ANGL	ETF	29.63	29.94	29.32	29.41	1510100.0
2020-03-03	AOA	ETF	55.42	56.5	54.28	54.55	103300.0
2020-03-03	AOK	ETF	36.27	36.56	36.05	36.13	141088.0
2020-03-03	AOM	ETF	39.79	40.1828	39.47	39.6	151451.0
2020-03-03	AOR	ETF	46.54	47.83	45.89	46.09	343380.0
2020-03-03	ARCM	ETF	99.87	100.095	99.87	100.095	100.0

> showing 50 of 1,976 rows — these rows as CSV

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