PREVIEW / etf_daily / 2021-04-22

all etf daily files

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

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-22	SPY	ETF	415.89	416.78	411.13	412.27	97582800.0
2021-04-22	QQQ	ETF	338.89	339.9	334.01	335.2	45936143.0
2021-04-22	IWM	ETF	223.26	225.33	220.78	221.58	31943700.0
2021-04-22	DIA	ETF	341.12	341.21	337.09	338.12	4962500.0
2021-04-22	GLD	ETF	167.11	167.53	166.49	167.04	7680100.0
2021-04-22	TLT	ETF	140.0	140.39	139.2	140.39	14156400.0
2021-04-22	AAA	ETF	25.05	25.05	25.04	25.04	202.0
2021-04-22	AAAU	ETF	17.76	17.8	17.69	17.74	280100.0
2021-04-22	AADR	ETF	64.8	65.25	64.65	64.69	2700.0
2021-04-22	AAXJ	ETF	93.83	93.85	92.95	93.26	663900.0
2021-04-22	ABEQ	ETF	27.4	27.49	27.304	27.304	4800.0
2021-04-22	ACES	ETF	74.38	75.515	73.56	74.09	109300.0
2021-04-22	ACIO	ETF	29.59	29.64	29.385	29.432	16600.0
2021-04-22	ACSI	ETF	48.24	48.24	48.0	48.0414	1075.0
2021-04-22	ACTV	ETF	36.42	36.655	36.39	36.47	6343.0
2021-04-22	ACTX	ETF	4.5	4.5	4.5	4.5	307.0
2021-04-22	ACVF	ETF	31.0	31.03	30.762	30.762	8500.0
2021-04-22	ACWF	ETF	37.795	37.918	37.53	37.65	5476.0
2021-04-22	ACWI	ETF	99.18	99.33	98.21	98.48	2419400.0
2021-04-22	ACWV	ETF	102.21	102.21	101.51	101.7	164400.0
2021-04-22	ACWX	ETF	56.86	56.86	56.4	56.54	1401961.0
2021-04-22	ADFI	ETF	9.72	9.72	9.61	9.688	3200.0
2021-04-22	ADIV	ETF	19.03	19.03	18.867	18.867	400.0
2021-04-22	ADME	ETF	38.57	38.62	38.24	38.35	17400.0
2021-04-22	ADRE	ETF	56.32	56.83	56.23	56.3	6932.0
2021-04-22	AESR	ETF	13.2	13.22	13.04	13.078	5100.0
2021-04-22	AFIF	ETF	9.71	9.72	9.69	9.71	14607.0
2021-04-22	AFK	ETF	21.72	21.7711	21.66	21.74	5658.0
2021-04-22	AFLG	ETF	24.95	25.01	24.754	24.754	1000.0
2021-04-22	AFMC	ETF	24.971	24.971	24.971	24.971	800.0
2021-04-22	AFSM	ETF	25.6	25.6	25.6	25.6	100.0
2021-04-22	AFTY	ETF	22.54	22.58	22.52	22.534	1200.0
2021-04-22	AGG	ETF	114.74	114.8	114.59	114.77	4570700.0
2021-04-22	AGGY	ETF	51.93	51.94	51.812	51.915	78900.0
2021-04-22	AGNG	ETF	29.31	29.31	29.21	29.218	2200.0
2021-04-22	AGQ	ETF	47.7	47.81	45.0	46.79	998500.0
2021-04-22	AGZ	ETF	118.24	118.37	118.2	118.37	25963.0
2021-04-22	AGZD	ETF	23.56	23.625	23.55	23.59	124800.0
2021-04-22	AIA	ETF	92.79	93.18	92.24	92.53	135136.0
2021-04-22	AIEQ	ETF	39.16	39.716	38.8	38.95	20100.0
2021-04-22	AIQ	ETF	29.61	29.63	29.22	29.26	22608.0
2021-04-22	AIRR	ETF	41.33	41.37	40.806	40.86	38800.0
2021-04-22	AIVI	ETF	43.48	43.48	43.18	43.18	32800.0
2021-04-22	ALTL	ETF	39.25	39.68	39.08	39.08	7384.0
2021-04-22	ALTY	ETF	13.2	13.2	13.061	13.09	10600.0
2021-04-22	AMJ	ETF	17.2	17.32	16.98	17.01	445708.0
2021-04-22	AMLP	ETF	32.0	32.03	31.37	31.51	2678500.0
2021-04-22	AMNA	ETF	29.824	29.824	29.824	29.824	5.0
2021-04-22	AMND	ETF	31.771	31.771	31.771	31.771	4.0
2021-04-22	AMOM	ETF	35.44	35.48	35.05	35.169	24300.0

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

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