PREVIEW / etf_daily / 2021-04-08

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-08.parquet
  size:    88 KB
  rows:    2,325

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
2021-04-08	SPY	ETF	407.93	408.58	406.93	408.52	57863100.0
2021-04-08	QQQ	ETF	334.56	335.27	333.7399	335.08	29940799.0
2021-04-08	IWM	ETF	221.84	222.82	219.39	222.56	23989400.0
2021-04-08	DIA	ETF	334.3	335.15	333.43	335.13	2665000.0
2021-04-08	GLD	ETF	164.17	164.77	164.14	164.51	6574500.0
2021-04-08	TLT	ETF	137.39	138.07	137.36	138.01	7847900.0
2021-04-08	AAA	ETF	25.06	25.06	25.05	25.05	200.0
2021-04-08	AAAU	ETF	17.43	17.5	17.43	17.48	375000.0
2021-04-08	AADR	ETF	63.8	64.04	63.8	63.9	2100.0
2021-04-08	AAXJ	ETF	94.21	94.34	93.91	93.93	584800.0
2021-04-08	ABEQ	ETF	26.68	26.68	26.666	26.666	200.0
2021-04-08	ACES	ETF	75.98	76.94	75.66	76.31	65900.0
2021-04-08	ACIO	ETF	29.19	29.19	28.995	29.05	30200.0
2021-04-08	ACSI	ETF	47.62	47.7379	47.62	47.7379	438.0
2021-04-08	ACTV	ETF	36.39	36.39	36.05	36.1576	3613.0
2021-04-08	ACVF	ETF	30.41	30.41	30.29	30.362	5300.0
2021-04-08	ACWF	ETF	37.29	37.3502	37.29	37.3502	1401.0
2021-04-08	ACWI	ETF	97.74	97.87	97.49	97.79	1939800.0
2021-04-08	ACWV	ETF	99.87	100.1	99.86	99.93	94600.0
2021-04-08	ACWX	ETF	56.41	56.52	56.26	56.43	999710.0
2021-04-08	ADFI	ETF	9.68	9.698	9.68	9.69	500.0
2021-04-08	ADIV	ETF	18.8	18.93	18.8	18.874	3400.0
2021-04-08	ADME	ETF	37.64	37.73	37.59	37.71	15000.0
2021-04-08	ADRE	ETF	57.03	57.1303	56.82	56.96	14627.0
2021-04-08	AESR	ETF	12.95	12.99	12.93	12.975	30800.0
2021-04-08	AFIF	ETF	9.735	9.75	9.72	9.7351	53302.0
2021-04-08	AFK	ETF	21.43	21.49	21.3	21.47	6130.0
2021-04-08	AFLG	ETF	24.42	24.48	24.42	24.464	2400.0
2021-04-08	AFMC	ETF	24.57	24.625	24.569	24.625	1200.0
2021-04-08	AFSM	ETF	25.4	25.485	25.399	25.485	700.0
2021-04-08	AFTY	ETF	22.52	22.53	22.47	22.499	4500.0
2021-04-08	AGG	ETF	114.18	114.31	114.13	114.31	4932100.0
2021-04-08	AGGY	ETF	51.54	51.64	51.54	51.63	78400.0
2021-04-08	AGNG	ETF	27.9	27.97	27.9	27.92	1800.0
2021-04-08	AGQ	ETF	44.9	45.21	44.47	44.74	539200.0
2021-04-08	AGZ	ETF	118.06	118.08	117.97	118.01	28017.0
2021-04-08	AGZD	ETF	23.58	23.59	23.555	23.585	53600.0
2021-04-08	AIA	ETF	93.86	94.129	93.665	93.78	87849.0
2021-04-08	AIEQ	ETF	39.14	39.3	38.9	39.3	42700.0
2021-04-08	AIQ	ETF	29.7	29.86	29.65	29.8192	27326.0
2021-04-08	AIRR	ETF	40.91	41.17	40.35	40.803	36400.0
2021-04-08	AIVI	ETF	42.95	43.03	42.9	42.99	5200.0
2021-04-08	ALTL	ETF	39.7	39.78	39.285	39.76	10988.0
2021-04-08	ALTY	ETF	12.89	12.9	12.826	12.9	13900.0
2021-04-08	AMJ	ETF	16.89	17.07	16.69	17.07	408900.0
2021-04-08	AMLP	ETF	31.19	31.51	30.76	31.51	2475800.0
2021-04-08	AMNA	ETF	30.35	30.35	30.35	30.35	0.0
2021-04-08	AMND	ETF	32.4108	32.4108	32.4108	32.4108	2.0
2021-04-08	AMOM	ETF	34.19	34.423	34.19	34.423	5400.0
2021-04-08	AMPS	ETF	10.0	10.02	9.95	9.99	510006.0

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

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