PREVIEW / etf_daily / 2021-03-23

all etf daily files

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

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-23	SPY	ETF	391.91	393.46	388.66	389.5	90686600.0
2021-03-23	QQQ	ETF	319.73	321.09	316.375	317.22	53455411.0
2021-03-23	IWM	ETF	223.16	223.86	216.03	217.06	43660700.0
2021-03-23	DIA	ETF	326.32	327.48	323.44	324.06	5068400.0
2021-03-23	GLD	ETF	162.45	162.49	161.59	161.81	6048300.0
2021-03-23	TLT	ETF	136.59	137.54	136.15	137.49	16768400.0
2021-03-23	AAA	ETF	25.07	25.0899	25.06	25.06	15172.0
2021-03-23	AAAU	ETF	17.27	17.27	17.17	17.18	589100.0
2021-03-23	AADR	ETF	63.21	63.21	61.93	61.96	2900.0
2021-03-23	AAXJ	ETF	93.06	93.24	92.33	92.47	726800.0
2021-03-23	ABEQ	ETF	26.218	26.218	25.97	25.97	7800.0
2021-03-23	ACES	ETF	75.88	76.55	73.646	74.08	107600.0
2021-03-23	ACIO	ETF	27.68	28.039	27.47	27.89	24100.0
2021-03-23	ACSI	ETF	45.4789	45.4789	45.4789	45.4789	293.0
2021-03-23	ACTV	ETF	35.8	35.8	35.165	35.2281	3328.0
2021-03-23	ACTX	ETF	4.9	4.9	3.43	3.72	1055.0
2021-03-23	ACVF	ETF	29.42	29.42	29.145	29.145	1000.0
2021-03-23	ACWF	ETF	36.15	36.15	35.7	35.76	14494.0
2021-03-23	ACWI	ETF	94.73	95.03	94.0	94.13	3479600.0
2021-03-23	ACWV	ETF	97.82	98.19	97.54	97.68	168400.0
2021-03-23	ACWX	ETF	55.3	55.37	54.84	54.92	2293024.0
2021-03-23	ADFI	ETF	9.64	9.66	9.64	9.65	800.0
2021-03-23	ADME	ETF	35.973	36.118	35.907	35.91	18600.0
2021-03-23	ADRE	ETF	57.96	58.0609	57.3753	57.445	17449.0
2021-03-23	AESR	ETF	12.47	12.5	12.377	12.377	7700.0
2021-03-23	AFIF	ETF	9.73	9.73	9.68	9.7139	15641.0
2021-03-23	AFK	ETF	21.25	21.25	20.92	20.92	19115.0
2021-03-23	AFLG	ETF	23.56	23.56	23.424	23.424	2400.0
2021-03-23	AFMC	ETF	23.993	23.993	23.507	23.507	1900.0
2021-03-23	AFSM	ETF	24.669	24.669	24.669	24.669	100.0
2021-03-23	AFTY	ETF	22.39	22.485	22.22	22.34	7000.0
2021-03-23	AGG	ETF	113.89	114.04	113.77	114.02	5524900.0
2021-03-23	AGGY	ETF	51.32	51.46	51.31	51.42	250400.0
2021-03-23	AGNG	ETF	27.66	27.66	27.13	27.223	1800.0
2021-03-23	AGQ	ETF	44.18	44.44	43.21	43.24	1257500.0
2021-03-23	AGZ	ETF	117.92	118.0298	117.92	118.025	73101.0
2021-03-23	AGZD	ETF	23.525	23.605	23.505	23.565	171400.0
2021-03-23	AIA	ETF	92.29	92.5	91.545	91.67	125346.0
2021-03-23	AIEQ	ETF	39.09	39.09	37.86	37.89	21200.0
2021-03-23	AIQ	ETF	28.57	28.67	28.3391	28.3391	12019.0
2021-03-23	AIRR	ETF	39.57	39.74	38.26	38.5	119700.0
2021-03-23	AIVI	ETF	42.83	42.93	42.58	42.59	7100.0
2021-03-23	ALTL	ETF	38.615	38.615	37.405	37.4428	4201.0
2021-03-23	ALTY	ETF	12.638	12.64	12.517	12.55	12400.0
2021-03-23	AMJ	ETF	16.44	16.55	15.94	15.98	891731.0
2021-03-23	AMLP	ETF	30.3	30.47	29.33	29.36	2931300.0
2021-03-23	AMNA	ETF	29.094	29.094	29.094	29.094	0.0
2021-03-23	AMND	ETF	30.8972	30.8972	30.8972	30.8972	0.0
2021-03-23	AMOM	ETF	32.92	32.97	32.723	32.723	900.0
2021-03-23	AMPS	ETF	9.99	9.99	9.71	9.71	74991.0

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

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