PREVIEW / etf_daily / 2020-06-12

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-12.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-12	SPY	ETF	308.24	309.08	298.6	304.21	194678900.0
2020-06-12	QQQ	ETF	239.09	240.4	231.74	235.88	72034787.0
2020-06-12	IWM	ETF	140.33	141.02	134.15	138.27	63864900.0
2020-06-12	DIA	ETF	259.0	260.32	251.43	256.74	9817200.0
2020-06-12	GLD	ETF	163.41	163.88	162.56	162.62	6895400.0
2020-06-12	TLT	ETF	162.41	163.66	162.05	162.3	9716100.0
2020-06-12	AAAU	ETF	17.34	17.37	17.25	17.27	161400.0
2020-06-12	AADR	ETF	50.37	50.37	48.93	49.59	4400.0
2020-06-12	AAXJ	ETF	68.57	68.67	67.4	68.26	1678000.0
2020-06-12	ABEQ	ETF	22.075	22.204	22.075	22.204	300.0
2020-06-12	ACES	ETF	38.21	38.21	36.33	37.315	38400.0
2020-06-12	ACIO	ETF	24.82	25.065	24.68	24.867	14200.0
2020-06-12	ACSI	ETF	32.93	33.1118	32.5	33.1118	329.0
2020-06-12	ACTX	ETF	4.72	4.72	4.13	4.3188	451.0
2020-06-12	ACWF	ETF	27.865	27.87	27.2516	27.5523	4538.0
2020-06-12	ACWI	ETF	73.96	74.22	72.01	73.19	4234400.0
2020-06-12	ACWV	ETF	89.37	89.37	86.83	87.97	480900.0
2020-06-12	ACWX	ETF	43.72	43.79	42.76	43.34	1495769.0
2020-06-12	ADME	ETF	31.5	31.84	31.3	31.542	2000.0
2020-06-12	ADRE	ETF	39.4038	39.4038	39.04	39.25	2574.0
2020-06-12	AESR	ETF	9.72	9.74	9.686	9.686	18600.0
2020-06-12	AFIF	ETF	9.68	9.86	9.68	9.825	98023.0
2020-06-12	AFK	ETF	16.41	16.5232	15.8999	16.16	10632.0
2020-06-12	AFLG	ETF	18.21	18.51	18.21	18.51	400.0
2020-06-12	AFMC	ETF	16.81	16.81	16.804	16.804	100.0
2020-06-12	AFSM	ETF	16.26	16.277	16.26	16.277	100.0
2020-06-12	AFTY	ETF	16.385	16.385	16.33	16.384	700.0
2020-06-12	AGG	ETF	117.6	117.7	117.44	117.58	4571800.0
2020-06-12	AGGY	ETF	53.76	53.76	53.57	53.65	467300.0
2020-06-12	AGNG	ETF	23.86	23.961	23.495	23.687	2700.0
2020-06-12	AGQ	ETF	27.49	27.79	26.6	26.87	351900.0
2020-06-12	AGZ	ETF	120.79	120.99	120.6962	120.99	96124.0
2020-06-12	AGZD	ETF	23.52	23.525	23.475	23.495	13000.0
2020-06-12	AIA	ETF	64.02	64.14	62.9162	63.66	76654.0
2020-06-12	AIEQ	ETF	27.24	27.39	26.51	26.85	24200.0
2020-06-12	AIQ	ETF	20.0	20.05	19.361	19.7344	12958.0
2020-06-12	AIRR	ETF	23.61	23.61	22.34	23.025	30300.0
2020-06-12	AIVI	ETF	35.83	35.85	35.16	35.61	7400.0
2020-06-12	ALTY	ETF	11.165	11.219	10.87	11.12	11200.0
2020-06-12	AMJ	ETF	15.26	15.26	14.1	14.31	2261103.0
2020-06-12	AMLP	ETF	27.78	28.0	26.25	26.6	4916400.0
2020-06-12	AMOM	ETF	27.964	27.964	27.964	27.964	200.0
2020-06-12	AMUB	ETF	9.05	9.05	8.91	9.0256	5938.0
2020-06-12	AMZA	ETF	20.55	20.845	19.3	19.72	69300.0
2020-06-12	ANGL	ETF	28.59	28.81	28.27	28.56	1321900.0
2020-06-12	AOA	ETF	54.55	54.71	53.47	54.09	73400.0
2020-06-12	AOK	ETF	36.25	36.25	35.87	36.13	96320.0
2020-06-12	AOM	ETF	39.74	39.8	39.2351	39.56	135465.0
2020-06-12	AOR	ETF	46.24	46.29	45.46	45.93	215318.0
2020-06-12	APRT	ETF	24.77	24.77	24.7619	24.7619	300.0

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

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