PREVIEW / etf_daily / 2021-04-01

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-01.parquet
  size:    87 KB
  rows:    2,304

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-01	SPY	ETF	398.4	400.67	398.18	400.61	99682900.0
2021-04-01	QQQ	ETF	323.07	324.71	322.81	324.57	55685602.0
2021-04-01	IWM	ETF	222.4	223.9	222.02	223.74	29799200.0
2021-04-01	DIA	ETF	330.78	331.6	329.72	331.45	5936100.0
2021-04-01	GLD	ETF	161.56	162.11	161.28	161.98	7105200.0
2021-04-01	TLT	ETF	136.55	137.62	136.3	137.51	14885900.0
2021-04-01	AAA	ETF	25.04	25.04	25.04	25.04	138.0
2021-04-01	AAAU	ETF	17.16	17.22	17.14	17.2	386900.0
2021-04-01	AADR	ETF	63.04	63.51	63.01	63.51	2900.0
2021-04-01	AAXJ	ETF	93.97	94.2	93.6	93.71	677100.0
2021-04-01	ABEQ	ETF	26.278	26.449	26.278	26.449	8900.0
2021-04-01	ACES	ETF	79.82	80.14	77.955	78.24	189100.0
2021-04-01	ACIO	ETF	28.446	28.6	28.446	28.6	7500.0
2021-04-01	ACSI	ETF	46.58	46.58	46.5765	46.5765	15639.0
2021-04-01	ACTV	ETF	36.18	36.28	35.71	36.2623	7000.0
2021-04-01	ACVF	ETF	29.9	29.941	29.775	29.941	6600.0
2021-04-01	ACWF	ETF	36.645	36.8129	36.645	36.8129	9228.0
2021-04-01	ACWI	ETF	95.85	96.4	95.84	96.39	2815600.0
2021-04-01	ACWV	ETF	98.93	99.31	98.64	99.22	430100.0
2021-04-01	ACWX	ETF	55.68	55.95	55.62	55.92	1548319.0
2021-04-01	ADFI	ETF	9.68	9.7	9.666	9.666	900.0
2021-04-01	ADIV	ETF	18.63	18.66	18.57	18.66	1000.0
2021-04-01	ADME	ETF	36.63	36.94	36.63	36.94	6700.0
2021-04-01	ADRE	ETF	57.52	57.56	56.66	56.94	46030.0
2021-04-01	AESR	ETF	12.47	12.77	12.47	12.7	18200.0
2021-04-01	AFIF	ETF	9.76	9.77	9.7446	9.7699	23618.0
2021-04-01	AFK	ETF	21.24	21.36	21.2	21.36	4613.0
2021-04-01	AFLG	ETF	23.939	24.034	23.939	24.034	800.0
2021-04-01	AFMC	ETF	24.497	24.497	24.497	24.497	100.0
2021-04-01	AFSM	ETF	25.401	25.401	25.401	25.401	100.0
2021-04-01	AFTY	ETF	22.81	22.91	22.79	22.82	3400.0
2021-04-01	AGG	ETF	113.93	114.05	113.83	114.04	10767200.0
2021-04-01	AGGY	ETF	51.3	51.46	51.3	51.36	303900.0
2021-04-01	AGNG	ETF	27.78	27.86	27.73	27.839	3400.0
2021-04-01	AGQ	ETF	41.82	42.89	41.55	42.82	651700.0
2021-04-01	AGZ	ETF	117.78	117.947	117.76	117.92	85174.0
2021-04-01	AGZD	ETF	23.6	23.625	23.56	23.56	487000.0
2021-04-01	AIA	ETF	93.99	94.06	93.46	93.57	477956.0
2021-04-01	AIEQ	ETF	38.57	38.92	38.57	38.72	58400.0
2021-04-01	AIQ	ETF	28.79	29.0785	28.79	29.03	30811.0
2021-04-01	AIRR	ETF	40.84	41.02	40.51	41.02	60300.0
2021-04-01	AIVI	ETF	42.46	42.7	42.41	42.7	4800.0
2021-04-01	ALTL	ETF	39.3	39.63	39.14	39.63	21152.0
2021-04-01	ALTY	ETF	12.77	12.8	12.72	12.79	30700.0
2021-04-01	AMJ	ETF	16.64	16.91	16.38	16.91	992176.0
2021-04-01	AMLP	ETF	30.7	31.14	30.2	31.13	3095900.0
2021-04-01	AMNA	ETF	29.93	30.193	29.93	30.193	200.0
2021-04-01	AMND	ETF	32.2454	32.2454	32.2454	32.2454	0.0
2021-04-01	AMOM	ETF	33.668	33.84	33.66	33.84	4500.0
2021-04-01	AMPS	ETF	9.77	9.97	9.77	9.9	24083.0

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

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