PREVIEW / etf_daily / 2021-04-05

all etf daily files

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

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-05	SPY	ETF	403.46	406.94	403.38	406.36	91684800.0
2021-04-05	QQQ	ETF	327.13	331.84	324.6375	331.05	42172475.0
2021-04-05	IWM	ETF	226.4	226.54	223.57	224.97	27826600.0
2021-04-05	DIA	ETF	333.94	336.15	333.91	335.2	5632700.0
2021-04-05	GLD	ETF	161.52	162.4	161.36	161.92	6163800.0
2021-04-05	TLT	ETF	136.55	136.97	135.94	136.91	8243000.0
2021-04-05	AAA	ETF	25.04	25.04	25.04	25.04	119.0
2021-04-05	AAAU	ETF	17.16	17.25	17.15	17.21	240000.0
2021-04-05	AADR	ETF	63.72	64.1	63.72	64.1	1300.0
2021-04-05	AAXJ	ETF	94.23	94.26	93.74	93.97	686900.0
2021-04-05	ABEQ	ETF	26.64	26.68	26.62	26.66	9700.0
2021-04-05	ACES	ETF	80.13	80.13	76.6	76.6	663800.0
2021-04-05	ACIO	ETF	29.08	29.08	28.78	28.93	48500.0
2021-04-05	ACSI	ETF	47.17	47.2273	47.08	47.2273	1916.0
2021-04-05	ACTV	ETF	36.46	36.53	36.3822	36.53	7540.0
2021-04-05	ACVF	ETF	30.51	30.51	30.0	30.33	5200.0
2021-04-05	ACWF	ETF	37.1	37.31	37.075	37.31	7446.0
2021-04-05	ACWI	ETF	96.94	97.6	96.87	97.46	2846500.0
2021-04-05	ACWV	ETF	99.38	100.26	99.38	100.07	526400.0
2021-04-05	ACWX	ETF	56.37	56.55	56.18	56.52	1245688.0
2021-04-05	ADFI	ETF	9.65	9.655	9.65	9.651	600.0
2021-04-05	ADIV	ETF	18.83	18.89	18.76	18.82	1600.0
2021-04-05	ADME	ETF	37.39	37.46	37.2	37.45	35600.0
2021-04-05	ADRE	ETF	57.85	57.91	56.62	57.15	34616.0
2021-04-05	AESR	ETF	12.84	12.93	12.84	12.908	18000.0
2021-04-05	AFIF	ETF	9.73	9.74	9.7	9.74	25156.0
2021-04-05	AFK	ETF	21.4	21.5	21.4	21.4508	8260.0
2021-04-05	AFLG	ETF	24.336	24.356	24.336	24.356	300.0
2021-04-05	AFSM	ETF	25.57	25.619	25.57	25.619	1700.0
2021-04-05	AFTY	ETF	22.91	23.1	22.91	23.05	5500.0
2021-04-05	AGG	ETF	113.78	113.89	113.69	113.81	9230100.0
2021-04-05	AGGY	ETF	51.41	51.41	51.33	51.36	125000.0
2021-04-05	AGNG	ETF	27.89	27.985	27.89	27.985	3400.0
2021-04-05	AGQ	ETF	42.42	43.05	41.87	42.56	642100.0
2021-04-05	AGZ	ETF	117.79	117.8312	117.67	117.83	65528.0
2021-04-05	AGZD	ETF	23.71	23.71	23.54	23.595	233000.0
2021-04-05	AIA	ETF	94.214	94.66	93.92	94.05	494245.0
2021-04-05	AIEQ	ETF	39.25	39.25	38.84	39.09	91200.0
2021-04-05	AIQ	ETF	29.28	29.54	29.2	29.4669	27522.0
2021-04-05	AIRR	ETF	41.6	41.69	41.16	41.42	92300.0
2021-04-05	AIVI	ETF	42.88	43.21	42.88	43.21	2700.0
2021-04-05	ALTL	ETF	39.71	40.06	39.71	39.7529	20712.0
2021-04-05	ALTY	ETF	12.84	12.84	12.73	12.73	19400.0
2021-04-05	AMJ	ETF	16.98	16.98	16.56	16.78	640484.0
2021-04-05	AMLP	ETF	31.14	31.15	30.5	31.01	2472900.0
2021-04-05	AMNA	ETF	30.1176	30.1176	30.1176	30.1176	17.0
2021-04-05	AMND	ETF	32.1758	32.1758	32.1758	32.1758	32.0
2021-04-05	AMOM	ETF	33.84	34.29	33.84	34.23	4600.0
2021-04-05	AMPS	ETF	9.9599	10.0	9.855	10.0	156664.0
2021-04-05	AMTR	ETF	34.6572	34.6572	34.6572	34.6572	21.0

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

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