PREVIEW / etf_daily / 2021-03-22

all etf daily files

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

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-22	SPY	ETF	390.03	394.07	389.97	392.59	73778600.0
2021-03-22	QQQ	ETF	315.21	320.74	315.21	318.61	56194755.0
2021-03-22	IWM	ETF	227.68	228.1	224.1	225.23	26128400.0
2021-03-22	DIA	ETF	325.55	327.98	325.03	327.24	3807600.0
2021-03-22	GLD	ETF	162.27	163.13	162.16	163.0	5240000.0
2021-03-22	TLT	ETF	135.69	136.41	135.37	136.26	17047500.0
2021-03-22	AAA	ETF	25.08	25.08	25.08	25.08	208.0
2021-03-22	AAAU	ETF	17.25	17.33	17.22	17.31	358500.0
2021-03-22	AADR	ETF	63.44	63.95	63.44	63.67	2800.0
2021-03-22	AAXJ	ETF	94.05	94.53	93.63	94.22	548100.0
2021-03-22	ABEQ	ETF	26.27	26.34	26.23	26.34	20600.0
2021-03-22	ACES	ETF	75.65	77.22	75.06	76.33	124000.0
2021-03-22	ACIO	ETF	27.59	27.95	27.59	27.92	38400.0
2021-03-22	ACSI	ETF	46.099	46.099	45.9964	45.9964	590.0
2021-03-22	ACTV	ETF	36.17	36.265	36.146	36.2308	5005.0
2021-03-22	ACTX	ETF	3.5	5.0	3.5	4.9	1711.0
2021-03-22	ACVF	ETF	30.0	30.0	29.32	29.408	800.0
2021-03-22	ACWF	ETF	36.0969	36.4	36.0969	36.34	6330.0
2021-03-22	ACWI	ETF	94.75	95.5	94.74	95.21	6435500.0
2021-03-22	ACWV	ETF	97.37	98.15	97.37	98.06	128600.0
2021-03-22	ACWX	ETF	55.64	55.875	55.55	55.75	2452292.0
2021-03-22	ADFI	ETF	9.59	9.61	9.59	9.61	300.0
2021-03-22	ADME	ETF	36.01	36.042	35.82	35.96	10500.0
2021-03-22	ADRE	ETF	58.03	58.4408	57.7828	58.17	12991.0
2021-03-22	AESR	ETF	12.45	12.55	12.45	12.51	17600.0
2021-03-22	AFIF	ETF	9.7045	9.72	9.7045	9.7051	76477.0
2021-03-22	AFK	ETF	21.56	21.56	21.43	21.46	9926.0
2021-03-22	AFLG	ETF	23.47	23.68	23.47	23.666	1300.0
2021-03-22	AFMC	ETF	24.199	24.199	24.199	24.199	1400.0
2021-03-22	AFSM	ETF	25.507	25.507	25.507	25.507	100.0
2021-03-22	AFTY	ETF	22.59	22.66	22.561	22.584	12600.0
2021-03-22	AGG	ETF	113.7	113.8	113.6	113.73	5468600.0
2021-03-22	AGGY	ETF	51.21	51.33	51.209	51.27	104200.0
2021-03-22	AGNG	ETF	27.51	27.785	27.51	27.676	6800.0
2021-03-22	AGQ	ETF	45.43	46.11	45.2	46.06	971400.0
2021-03-22	AGZ	ETF	117.89	117.9	117.78	117.86	30719.0
2021-03-22	AGZD	ETF	23.56	23.58	23.485	23.55	76000.0
2021-03-22	AIA	ETF	93.12	93.75	92.81	93.58	152625.0
2021-03-22	AIEQ	ETF	39.02	39.399	38.89	39.03	15000.0
2021-03-22	AIQ	ETF	28.49	28.83	28.49	28.63	28114.0
2021-03-22	AIRR	ETF	40.61	40.61	39.621	39.907	57300.0
2021-03-22	AIVI	ETF	42.91	43.14	42.86	43.05	46400.0
2021-03-22	ALTL	ETF	40.09	40.09	38.64	38.69	15571.0
2021-03-22	ALTY	ETF	12.68	12.68	12.6	12.66	8200.0
2021-03-22	AMJ	ETF	16.82	16.82	16.57	16.65	648484.0
2021-03-22	AMLP	ETF	30.89	30.91	30.49	30.72	1702500.0
2021-03-22	AMNA	ETF	29.7435	29.7435	29.7435	29.7435	0.0
2021-03-22	AMND	ETF	31.7353	31.7353	31.7353	31.7353	0.0
2021-03-22	AMOM	ETF	32.93	33.03	32.75	32.925	6700.0
2021-03-22	AMPS	ETF	10.1	10.1	9.9	9.98	28595.0

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

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