PREVIEW / etf_daily / 2020-03-20

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-20.parquet
  size:    75 KB
  rows:    1,977

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-20	SPY	ETF	242.53	244.47	228.5	228.8	347158800.0
2020-03-20	QQQ	ETF	181.74	182.87	170.1	170.7	118983891.0
2020-03-20	IWM	ETF	106.12	108.76	100.45	101.4	76203700.0
2020-03-20	DIA	ETF	203.29	205.29	191.0	191.9	12206000.0
2020-03-20	GLD	ETF	140.71	141.17	139.14	140.11	20056000.0
2020-03-20	TLT	ETF	153.3	159.43	152.11	159.43	20863100.0
2020-03-20	AAAU	ETF	14.91	14.94	14.76	14.86	203600.0
2020-03-20	AADR	ETF	36.76	37.25	35.26	35.29	14900.0
2020-03-20	AAXJ	ETF	56.84	56.96	54.85	55.0	5204400.0
2020-03-20	ABEQ	ETF	19.44	19.66	18.66	18.66	11000.0
2020-03-20	ACES	ETF	26.9	27.66	25.71	25.71	218800.0
2020-03-20	ACIO	ETF	22.23	22.42	22.0	22.42	17700.0
2020-03-20	ACSI	ETF	26.4069	26.4069	25.1714	25.1714	1531.0
2020-03-20	ACTX	ETF	3.245	3.481	2.36	2.95	1059.0
2020-03-20	ACWF	ETF	22.45	22.56	21.3682	21.3777	38585.0
2020-03-20	ACWI	ETF	58.1	58.75	55.3	55.31	6484800.0
2020-03-20	ACWV	ETF	76.78	77.05	73.0	73.14	1791600.0
2020-03-20	ACWX	ETF	34.68	35.12	33.42	33.42	2980945.0
2020-03-20	ADME	ETF	27.425	27.603	26.92	26.942	8200.0
2020-03-20	ADRE	ETF	32.47	32.47	30.71	30.71	11897.0
2020-03-20	AFIF	ETF	9.545	9.745	9.435	9.5668	26450.0
2020-03-20	AFK	ETF	12.63	12.63	11.43	11.65	39820.0
2020-03-20	AFLG	ETF	14.93	14.93	14.01	14.01	200.0
2020-03-20	AFMC	ETF	13.39	13.39	12.469	12.469	400.0
2020-03-20	AFSM	ETF	12.96	12.96	12.071	12.071	200.0
2020-03-20	AFTY	ETF	14.52	14.57	14.098	14.098	3700.0
2020-03-20	AGG	ETF	108.46	110.24	108.46	110.03	16503700.0
2020-03-20	AGGY	ETF	47.06	47.61	47.04	47.2	705700.0
2020-03-20	AGNG	ETF	18.72	18.72	17.6	17.6	5300.0
2020-03-20	AGQ	ETF	14.76	15.2	14.2	14.46	394100.0
2020-03-20	AGZ	ETF	118.91	119.9799	118.91	119.86	57779.0
2020-03-20	AGZD	ETF	22.035	22.75	21.545	22.0	44600.0
2020-03-20	AIA	ETF	52.61	53.87	50.94	51.09	250520.0
2020-03-20	AIEQ	ETF	21.2	21.261	20.114	20.16	31900.0
2020-03-20	AIQ	ETF	14.4	14.62	13.88	13.88	27017.0
2020-03-20	AIRR	ETF	18.29	18.51	17.26	17.485	44800.0
2020-03-20	AIVI	ETF	29.12	29.2	27.86	27.86	112000.0
2020-03-20	ALTY	ETF	8.5	8.82	7.92	8.125	19000.0
2020-03-20	AMJ	ETF	8.4	9.99	8.02	9.16	8671523.0
2020-03-20	AMLP	ETF	16.9	19.4	15.9	17.8	23841960.0
2020-03-20	AMOM	ETF	19.857	19.857	19.857	19.857	100.0
2020-03-20	AMUB	ETF	5.87	5.8876	5.7059	5.7059	6438.0
2020-03-20	AMZA	ETF	11.0	13.49	10.5	11.8	180650.0
2020-03-20	ANGL	ETF	21.37	22.96	21.37	22.36	4163000.0
2020-03-20	AOA	ETF	44.64	44.79	42.67	42.71	345700.0
2020-03-20	AOK	ETF	31.84	32.22	31.39	31.62	146264.0
2020-03-20	AOM	ETF	34.42	34.677	33.83	34.04	267063.0
2020-03-20	AOR	ETF	38.75	39.2	37.81	37.97	587518.0
2020-03-20	ARCM	ETF	99.265	99.265	99.265	99.265	100.0
2020-03-20	ARGT	ETF	15.36	16.4	14.61	14.67	191900.0

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

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