PREVIEW / etf_daily / 2020-09-21

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-21.parquet
  size:    79 KB
  rows:    2,101

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-09-21	SPY	ETF	325.7	327.13	321.73	326.97	99450800.0
2020-09-21	QQQ	ETF	262.52	267.65	260.11	267.51	57168570.0
2020-09-21	IWM	ETF	149.82	150.26	146.33	147.92	40652500.0
2020-09-21	DIA	ETF	271.58	272.17	267.05	271.44	5936900.0
2020-09-21	GLD	ETF	179.84	180.29	176.75	179.52	17436100.0
2020-09-21	TLT	ETF	164.89	165.4	164.14	164.4	11086900.0
2020-09-21	AAA	ETF	24.99	24.99	24.98	24.98	8756.0
2020-09-21	AAAU	ETF	19.09	19.13	18.76	19.05	1124700.0
2020-09-21	AADR	ETF	54.57	54.84	54.32	54.84	5000.0
2020-09-21	AAXJ	ETF	76.44	77.14	76.0	77.14	759500.0
2020-09-21	ABEQ	ETF	23.051	23.164	23.0	23.164	6900.0
2020-09-21	ACES	ETF	51.45	51.495	49.9	51.495	149200.0
2020-09-21	ACIO	ETF	26.023	26.193	26.014	26.193	68700.0
2020-09-21	ACSI	ETF	36.2099	36.2099	36.2099	36.2099	111.0
2020-09-21	ACTX	ETF	2.3659	2.3659	2.3659	2.3659	2.0
2020-09-21	ACWF	ETF	29.11	29.3105	29.04	29.3105	2661.0
2020-09-21	ACWI	ETF	78.45	78.8	77.57	78.8	2157800.0
2020-09-21	ACWV	ETF	90.61	90.88	90.08	90.77	229800.0
2020-09-21	ACWX	ETF	45.82	45.94	45.34	45.92	1987921.0
2020-09-21	ADME	ETF	32.59	32.97	32.48	32.97	42500.0
2020-09-21	ADRE	ETF	45.93	46.1417	45.3662	46.1417	1993.0
2020-09-21	AESR	ETF	10.585	10.585	10.585	10.585	100.0
2020-09-21	AFIF	ETF	9.82	9.83	9.81	9.8152	12243.0
2020-09-21	AFK	ETF	17.74	17.74	17.2901	17.3884	16258.0
2020-09-21	AFLG	ETF	19.5	19.728	19.5	19.728	300.0
2020-09-21	AFMC	ETF	17.399	17.399	17.399	17.399	100.0
2020-09-21	AFSM	ETF	17.497	17.497	17.497	17.497	100.0
2020-09-21	AFTY	ETF	19.52	19.65	19.46	19.65	1600.0
2020-09-21	AGG	ETF	118.41	118.42	118.24	118.24	6191900.0
2020-09-21	AGGY	ETF	54.13	54.13	54.0	54.09	108000.0
2020-09-21	AGNG	ETF	25.41	25.41	24.97	25.213	6800.0
2020-09-21	AGQ	ETF	53.26	53.9	43.37	47.58	5420300.0
2020-09-21	AGZ	ETF	121.34	121.35	121.15	121.33	35113.0
2020-09-21	AGZD	ETF	23.525	23.53	23.5	23.51	13600.0
2020-09-21	AIA	ETF	71.68	72.15	71.14	72.15	84164.0
2020-09-21	AIEQ	ETF	29.19	29.854	29.171	29.854	13800.0
2020-09-21	AIQ	ETF	22.4	22.6836	22.18	22.6836	33338.0
2020-09-21	AIRR	ETF	25.73	25.73	24.665	24.946	11000.0
2020-09-21	AIVI	ETF	36.44	36.44	36.1	36.32	15800.0
2020-09-21	ALTL	ETF	24.47	24.5189	24.28	24.5189	39110.0
2020-09-21	ALTY	ETF	10.7	10.7	10.552	10.584	22600.0
2020-09-21	AMJ	ETF	11.46	11.46	11.185	11.38	1068221.0
2020-09-21	AMLP	ETF	21.12	21.12	20.62	20.9	2177600.0
2020-09-21	AMNA	ETF	22.43	22.6503	22.38	22.6503	3700.0
2020-09-21	AMND	ETF	23.671	23.671	23.671	23.671	0.0
2020-09-21	AMOM	ETF	33.24	34.153	33.24	34.153	900.0
2020-09-21	AMUB	ETF	7.17	7.17	7.04	7.12	44439.0
2020-09-21	AMZA	ETF	14.37	14.37	13.9	14.21	129000.0
2020-09-21	ANGL	ETF	29.95	29.98	29.74	29.79	2510500.0
2020-09-21	AOA	ETF	57.45	57.45	56.45	57.28	72800.0

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

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