PREVIEW / etf_daily / 2021-03-30

all etf daily files

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

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-30	SPY	ETF	394.42	395.45	393.02	394.73	76262200.0
2021-03-30	QQQ	ETF	313.89	314.91	311.54	314.32	44635676.0
2021-03-30	IWM	ETF	214.39	218.68	213.14	218.01	36205400.0
2021-03-30	DIA	ETF	331.05	331.6	329.78	330.82	4568800.0
2021-03-30	GLD	ETF	157.94	158.2	157.55	157.57	8353200.0
2021-03-30	TLT	ETF	135.3	136.51	135.01	136.21	15020800.0
2021-03-30	AAA	ETF	25.05	25.07	25.05	25.06	15493.0
2021-03-30	AAAU	ETF	16.77	16.8	16.73	16.75	458400.0
2021-03-30	AADR	ETF	61.76	62.28	61.76	61.99	1900.0
2021-03-30	AAXJ	ETF	92.2	92.78	91.87	92.4	1374600.0
2021-03-30	ABEQ	ETF	26.33	26.377	26.307	26.307	4800.0
2021-03-30	ACES	ETF	71.07	74.89	71.07	74.8	77700.0
2021-03-30	ACIO	ETF	28.85	28.85	28.14	28.15	12400.0
2021-03-30	ACSI	ETF	45.995	46.0486	45.995	46.0486	1186.0
2021-03-30	ACTV	ETF	36.0294	36.0294	35.7553	35.8272	2347.0
2021-03-30	ACTX	ETF	3.72	3.72	3.72	3.72	179.0
2021-03-30	ACVF	ETF	29.53	29.59	29.474	29.474	2100.0
2021-03-30	ACWF	ETF	36.12	36.32	36.1	36.25	7375.0
2021-03-30	ACWI	ETF	94.78	95.06	94.52	94.96	2982400.0
2021-03-30	ACWV	ETF	99.26	99.27	98.75	98.84	168400.0
2021-03-30	ACWX	ETF	55.05	55.305	54.97	55.25	1647189.0
2021-03-30	ADFI	ETF	9.64	9.66	9.61	9.64	3500.0
2021-03-30	ADIV	ETF	18.45	18.54	18.45	18.54	400.0
2021-03-30	ADME	ETF	36.18	36.35	36.18	36.275	6600.0
2021-03-30	ADRE	ETF	55.36	56.03	55.32	55.94	5910.0
2021-03-30	AESR	ETF	12.5	12.54	12.47	12.49	35700.0
2021-03-30	AFIF	ETF	9.69	9.75	9.68	9.72	54711.0
2021-03-30	AFK	ETF	21.03	21.11	20.82	21.06	9705.0
2021-03-30	AFLG	ETF	23.6	23.67	23.6	23.67	600.0
2021-03-30	AFMC	ETF	23.8	24.1	23.8	24.1	500.0
2021-03-30	AFSM	ETF	24.29	24.692	24.29	24.692	600.0
2021-03-30	AFTY	ETF	22.44	22.485	22.43	22.485	3800.0
2021-03-30	AGG	ETF	113.64	113.85	113.53	113.81	4996900.0
2021-03-30	AGGY	ETF	51.11	51.27	51.062	51.22	107100.0
2021-03-30	AGNG	ETF	27.44	27.56	27.44	27.49	2000.0
2021-03-30	AGQ	ETF	40.23	40.4	39.2	39.63	1178800.0
2021-03-30	AGZ	ETF	117.91	117.91	117.78	117.83	81787.0
2021-03-30	AGZD	ETF	23.48	23.53	23.46	23.505	18200.0
2021-03-30	AIA	ETF	91.54	92.02	91.17	91.89	135751.0
2021-03-30	AIEQ	ETF	36.91	37.709	36.77	37.4	16700.0
2021-03-30	AIQ	ETF	28.01	28.09	27.83	28.05	9024.0
2021-03-30	AIRR	ETF	39.24	40.389	39.24	40.25	85400.0
2021-03-30	AIVI	ETF	42.63	42.73	42.53	42.7	3500.0
2021-03-30	ALTL	ETF	38.67	39.11	38.505	38.99	12794.0
2021-03-30	ALTY	ETF	12.65	12.7	12.603	12.685	10600.0
2021-03-30	AMJ	ETF	16.41	16.41	16.19	16.36	1240821.0
2021-03-30	AMLP	ETF	30.2	30.26	29.87	30.01	1720900.0
2021-03-30	AMNA	ETF	29.7779	29.7779	29.7779	29.7779	0.0
2021-03-30	AMND	ETF	31.6417	31.6417	31.6417	31.6417	14.0
2021-03-30	AMOM	ETF	32.86	32.991	32.78	32.991	1300.0

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

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