PREVIEW / etf_daily / 2020-06-09

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-09.parquet
  size:    77 KB
  rows:    2,031

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-06-09	SPY	ETF	320.3	323.28	319.36	320.79	77479200.0
2020-06-09	QQQ	ETF	240.66	244.18	240.47	243.3	35046254.0
2020-06-09	IWM	ETF	150.86	151.77	149.06	150.26	39646000.0
2020-06-09	DIA	ETF	273.24	275.02	272.13	273.38	4632600.0
2020-06-09	GLD	ETF	161.1	161.78	160.87	161.26	9045600.0
2020-06-09	TLT	ETF	159.05	159.64	158.3	158.49	9095300.0
2020-06-09	AAAU	ETF	17.11	17.18	17.07	17.11	296100.0
2020-06-09	AADR	ETF	50.5	50.89	50.5	50.72	15600.0
2020-06-09	AAXJ	ETF	69.06	69.74	68.99	69.61	1082000.0
2020-06-09	ABEQ	ETF	23.16	23.2	23.16	23.166	1200.0
2020-06-09	ACES	ETF	41.26	41.26	38.8	39.259	52900.0
2020-06-09	ACIO	ETF	25.0	25.12	25.0	25.11	10600.0
2020-06-09	ACSI	ETF	35.25	35.2646	35.2086	35.2086	853.0
2020-06-09	ACTX	ETF	4.248	4.72	4.248	4.248	1378.0
2020-06-09	ACWF	ETF	28.91	29.03	28.88	28.9185	11486.0
2020-06-09	ACWI	ETF	76.42	76.92	76.27	76.66	5235700.0
2020-06-09	ACWV	ETF	91.0	91.32	90.94	91.11	198400.0
2020-06-09	ACWX	ETF	44.76	45.085	44.63	44.93	2078822.0
2020-06-09	ADME	ETF	32.33	32.49	32.33	32.393	5200.0
2020-06-09	ADRE	ETF	40.24	40.46	40.1261	40.41	13809.0
2020-06-09	AESR	ETF	10.07	10.12	10.055	10.088	9800.0
2020-06-09	AFIF	ETF	9.8367	9.85	9.8	9.8	24777.0
2020-06-09	AFK	ETF	16.66	16.72	16.6	16.67	4953.0
2020-06-09	AFLG	ETF	19.53	19.53	19.507	19.507	100.0
2020-06-09	AFMC	ETF	18.08	18.122	18.08	18.122	100.0
2020-06-09	AFSM	ETF	17.61	17.652	17.61	17.652	100.0
2020-06-09	AFTY	ETF	16.45	16.59	16.45	16.57	7700.0
2020-06-09	AGG	ETF	117.31	117.33	117.18	117.18	5512300.0
2020-06-09	AGGY	ETF	53.48	53.56	53.46	53.54	365000.0
2020-06-09	AGNG	ETF	24.82	24.855	24.6	24.701	4400.0
2020-06-09	AGQ	ETF	27.76	28.09	27.45	27.51	188600.0
2020-06-09	AGZ	ETF	120.41	120.4399	120.29	120.33	42304.0
2020-06-09	AGZD	ETF	23.475	23.565	23.475	23.475	115200.0
2020-06-09	AIA	ETF	64.01	65.04	63.93	64.93	1320584.0
2020-06-09	AIEQ	ETF	27.83	28.14	27.83	27.91	24500.0
2020-06-09	AIQ	ETF	20.32	20.47	20.16	20.3672	17503.0
2020-06-09	AIRR	ETF	25.92	25.92	25.45	25.567	4100.0
2020-06-09	AIVI	ETF	37.03	37.22	37.0	37.15	9500.0
2020-06-09	ALTY	ETF	12.2	12.2	11.957	11.985	10400.0
2020-06-09	AMJ	ETF	16.64	16.64	15.94	16.18	2715639.0
2020-06-09	AMLP	ETF	30.97	30.98	29.59	30.09	3408500.0
2020-06-09	AMOM	ETF	28.792	28.792	28.792	28.792	100.0
2020-06-09	AMUB	ETF	9.88	10.38	9.88	10.2	31154.0
2020-06-09	AMZA	ETF	24.59	24.74	22.55	23.42	121600.0
2020-06-09	ANGL	ETF	29.14	29.19	28.83	28.98	925400.0
2020-06-09	AOA	ETF	56.22	56.46	56.1	56.39	54400.0
2020-06-09	AOK	ETF	36.63	36.69	36.55	36.64	169390.0
2020-06-09	AOM	ETF	40.31	40.4085	40.25	40.37	193330.0
2020-06-09	AOR	ETF	47.28	47.38	47.02	47.3	91904.0
2020-06-09	APRT	ETF	25.64	25.71	25.62	25.6493	8645.0

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

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