PREVIEW / etf_daily / 2021-03-29

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-29.parquet
  size:    87 KB
  rows:    2,300

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-03-29	SPY	ETF	394.4	396.75	392.81	395.78	108107600.0
2021-03-29	QQQ	ETF	315.45	316.99	312.47	315.91	54607963.0
2021-03-29	IWM	ETF	219.01	220.93	214.08	214.4	38078800.0
2021-03-29	DIA	ETF	329.29	332.46	328.9	331.66	5200900.0
2021-03-29	GLD	ETF	161.46	161.52	159.83	160.31	8409300.0
2021-03-29	TLT	ETF	136.83	136.85	134.97	135.5	13968100.0
2021-03-29	AAA	ETF	25.05	25.05	25.05	25.05	900.0
2021-03-29	AAAU	ETF	17.15	17.16	16.99	17.02	416400.0
2021-03-29	AADR	ETF	61.59	61.59	60.78	61.12	2800.0
2021-03-29	AAXJ	ETF	92.02	92.4	91.69	92.1	566200.0
2021-03-29	ABEQ	ETF	26.34	26.51	26.34	26.44	8600.0
2021-03-29	ACES	ETF	74.39	74.39	71.4	71.81	92800.0
2021-03-29	ACIO	ETF	28.32	28.43	28.01	28.39	25200.0
2021-03-29	ACSI	ETF	45.65	46.0	45.65	45.9759	2810.0
2021-03-29	ACTV	ETF	35.64	35.7902	35.48	35.5481	2996.0
2021-03-29	ACVF	ETF	29.68	29.68	29.462	29.621	6400.0
2021-03-29	ACWF	ETF	36.24	36.31	36.11	36.2304	10922.0
2021-03-29	ACWI	ETF	94.94	95.29	94.49	95.11	8201800.0
2021-03-29	ACWV	ETF	98.79	99.77	98.79	99.63	174500.0
2021-03-29	ACWX	ETF	55.14	55.38	54.99	55.29	1908250.0
2021-03-29	ADFI	ETF	9.64	9.72	9.64	9.645	16000.0
2021-03-29	ADIV	ETF	18.58	18.58	18.5645	18.5645	1398.0
2021-03-29	ADME	ETF	36.44	36.52	36.296	36.39	10400.0
2021-03-29	ADRE	ETF	55.22	55.455	54.79	55.29	18683.0
2021-03-29	AESR	ETF	12.52	12.56	12.47	12.526	22900.0
2021-03-29	AFIF	ETF	9.715	9.73	9.695	9.6993	42051.0
2021-03-29	AFK	ETF	21.3	21.3	20.9301	21.03	21723.0
2021-03-29	AFLG	ETF	23.79	23.79	23.653	23.713	2900.0
2021-03-29	AFMC	ETF	23.96	23.96	23.812	23.812	300.0
2021-03-29	AFSM	ETF	24.335	24.335	24.335	24.335	100.0
2021-03-29	AFTY	ETF	22.5	22.5	22.36	22.381	4500.0
2021-03-29	AGG	ETF	113.52	114.0	113.52	113.72	7630800.0
2021-03-29	AGGY	ETF	51.3	51.3	51.126	51.14	247000.0
2021-03-29	AGNG	ETF	27.65	27.98	27.42	27.58	14800.0
2021-03-29	AGQ	ETF	42.65	42.83	41.22	42.05	679800.0
2021-03-29	AGZ	ETF	117.99	118.08	117.63	118.01	1427563.0
2021-03-29	AGZD	ETF	23.47	23.48	23.455	23.46	29600.0
2021-03-29	AIA	ETF	91.35	91.855	91.09	91.62	289499.0
2021-03-29	AIEQ	ETF	37.58	37.9	36.961	37.03	18900.0
2021-03-29	AIQ	ETF	28.13	28.205	27.88	28.01	9471.0
2021-03-29	AIRR	ETF	40.2	40.595	39.231	39.275	67500.0
2021-03-29	AIVI	ETF	42.69	42.89	42.64	42.74	37000.0
2021-03-29	ALTL	ETF	38.99	38.99	38.14	38.4075	5811.0
2021-03-29	ALTY	ETF	12.65	12.69	12.59	12.67	13300.0
2021-03-29	AMJ	ETF	16.63	16.67	16.28	16.45	654414.0
2021-03-29	AMLP	ETF	30.74	30.77	30.0	30.37	1937400.0
2021-03-29	AMNA	ETF	30.1338	30.1338	30.1338	30.1338	0.0
2021-03-29	AMND	ETF	32.002	32.002	32.002	32.002	0.0
2021-03-29	AMOM	ETF	32.69	33.28	32.69	33.046	3300.0
2021-03-29	AMPS	ETF	9.9587	9.9587	9.66	9.68	46916.0

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

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