PREVIEW / etf_daily / 2021-04-07

all etf daily files

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

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-07	SPY	ETF	405.94	406.96	405.45	406.59	55836300.0
2021-04-07	QQQ	ETF	330.33	332.48	329.37	331.62	32046381.0
2021-04-07	IWM	ETF	224.23	224.37	219.94	220.69	26233700.0
2021-04-07	DIA	ETF	334.14	335.17	333.44	334.37	2658500.0
2021-04-07	GLD	ETF	162.82	163.31	162.5	162.76	5436000.0
2021-04-07	TLT	ETF	137.45	138.1	136.88	136.88	11052700.0
2021-04-07	AAA	ETF	25.06	25.06	25.05	25.05	773.0
2021-04-07	AAAU	ETF	17.31	17.34	17.27	17.3	371100.0
2021-04-07	AADR	ETF	63.79	63.79	63.3	63.3	1900.0
2021-04-07	AAXJ	ETF	93.11	93.26	92.68	92.98	769900.0
2021-04-07	ABEQ	ETF	26.519	26.589	26.519	26.589	3500.0
2021-04-07	ACES	ETF	77.8	77.8	75.0	75.4	64500.0
2021-04-07	ACIO	ETF	29.11	29.11	28.85	28.85	61600.0
2021-04-07	ACSI	ETF	47.4938	47.4938	47.4938	47.4938	271.0
2021-04-07	ACTV	ETF	36.26	36.6	36.2197	36.2197	2813.0
2021-04-07	ACVF	ETF	30.39	30.39	30.18	30.218	1400.0
2021-04-07	ACWF	ETF	37.16	37.19	37.0	37.12	33471.0
2021-04-07	ACWI	ETF	97.11	97.34	96.95	97.19	4297700.0
2021-04-07	ACWV	ETF	99.53	99.83	99.44	99.56	178800.0
2021-04-07	ACWX	ETF	55.95	56.105	55.87	56.0	1515018.0
2021-04-07	ADFI	ETF	9.71	9.71	9.671	9.671	1300.0
2021-04-07	ADIV	ETF	18.64	18.74	18.63	18.63	1400.0
2021-04-07	ADME	ETF	37.445	37.51	37.4	37.49	85300.0
2021-04-07	ADRE	ETF	57.0	57.23	56.172	56.37	19441.0
2021-04-07	AESR	ETF	12.92	13.07	12.874	12.911	7200.0
2021-04-07	AFIF	ETF	9.71	9.76	9.7	9.7	48785.0
2021-04-07	AFK	ETF	21.53	21.53	21.29	21.37	13088.0
2021-04-07	AFLG	ETF	24.31	24.34	24.31	24.336	1800.0
2021-04-07	AFMC	ETF	24.484	24.484	24.484	24.484	100.0
2021-04-07	AFSM	ETF	25.224	25.224	25.224	25.224	1600.0
2021-04-07	AFTY	ETF	22.44	22.5	22.37	22.45	2200.0
2021-04-07	AGG	ETF	114.12	114.3	114.03	114.03	4505600.0
2021-04-07	AGGY	ETF	51.57	51.63	51.49	51.49	780900.0
2021-04-07	AGNG	ETF	27.854	27.854	27.72	27.72	2800.0
2021-04-07	AGQ	ETF	43.28	44.02	43.07	43.55	401300.0
2021-04-07	AGZ	ETF	117.9374	117.99	117.87	117.98	36006.0
2021-04-07	AGZD	ETF	23.61	23.61	23.57	23.575	54800.0
2021-04-07	AIA	ETF	92.4	92.8935	92.2	92.55	149290.0
2021-04-07	AIEQ	ETF	39.07	39.14	38.68	38.74	23800.0
2021-04-07	AIQ	ETF	29.29	29.49	29.27	29.45	23837.0
2021-04-07	AIRR	ETF	41.43	41.498	40.591	40.71	124600.0
2021-04-07	AIVI	ETF	42.82	42.92	42.74	42.8	5700.0
2021-04-07	ALTL	ETF	40.065	40.065	39.623	39.83	21834.0
2021-04-07	ALTY	ETF	12.77	12.87	12.77	12.83	13400.0
2021-04-07	AMJ	ETF	16.84	16.96	16.8	16.92	243955.0
2021-04-07	AMLP	ETF	31.2	31.3	30.96	31.3	2187900.0
2021-04-07	AMNA	ETF	30.3728	30.3728	30.3728	30.3728	0.0
2021-04-07	AMND	ETF	32.3415	32.3415	32.3415	32.3415	0.0
2021-04-07	AMOM	ETF	34.34	34.379	34.193	34.193	1800.0
2021-04-07	AMPS	ETF	9.99	10.01	9.91	10.0	29525.0

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

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