PREVIEW / etf_daily / 2022-06-14

all etf daily files

  file:    by_date/etf_daily/2022/2022-06-14.parquet
  size:    102 KB
  rows:    2,740

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
2022-06-14	SPY	ETF	376.85	377.94	370.59	373.87	104011800.0
2022-06-14	QQQ	ETF	277.66	278.66	273.3375	275.91	64697521.0
2022-06-14	IWM	ETF	170.67	171.24	167.74	169.38	30282400.0
2022-06-14	DIA	ETF	306.61	307.43	301.93	304.3	3724000.0
2022-06-14	GLD	ETF	169.61	169.73	168.3	168.57	7347900.0
2022-06-14	TLT	ETF	110.53	110.98	108.59	108.81	21865900.0
2022-06-14	AAA	ETF	24.52	24.52	24.52	24.52	74.0
2022-06-14	AAAU	ETF	18.07	18.08	17.93	17.96	962800.0
2022-06-14	AADR	ETF	51.11	51.11	50.24	50.68	4600.0
2022-06-14	AAXJ	ETF	68.49	69.09	68.35	68.87	1761000.0
2022-06-14	ABEQ	ETF	27.34	27.34	27.155	27.155	2200.0
2022-06-14	ACES	ETF	48.58	48.59	47.16	47.73	74500.0
2022-06-14	ACIO	ETF	28.72	29.385	28.64	28.67	101500.0
2022-06-14	ACSI	ETF	41.4139	41.4139	41.4139	41.4139	4.0
2022-06-14	ACT	ETF	21.54	22.26	21.065	22.22	299936.0
2022-06-14	ACTV	ETF	29.83	29.83	29.49	29.6226	10614.0
2022-06-14	ACTX	ETF	0.8999	0.8999	0.88	0.88	1437.0
2022-06-14	ACVF	ETF	28.28	28.35	28.12	28.26	3100.0
2022-06-14	ACWF	ETF	31.42	31.43	31.11	31.297	2854.0
2022-06-14	ACWI	ETF	83.65	84.03	82.47	83.17	6172000.0
2022-06-14	ACWV	ETF	92.61	92.61	91.0	91.56	318400.0
2022-06-14	ACWX	ETF	45.09	45.26	44.54	44.88	5789479.0
2022-06-14	ADFI	ETF	8.39	8.41	8.36	8.41	21600.0
2022-06-14	ADIV	ETF	14.09	14.09	14.09	14.09	100.0
2022-06-14	ADME	ETF	34.849	34.85	34.145	34.49	94900.0
2022-06-14	ADRE	ETF	39.45	40.1299	39.45	39.97	2254.0
2022-06-14	AEMB	ETF	38.83	38.83	38.31	38.34	4500.0
2022-06-14	AESR	ETF	11.13	11.18	10.92	11.0	40200.0
2022-06-14	AFIF	ETF	8.931	8.931	8.88	8.8853	44361.0
2022-06-14	AFK	ETF	17.93	17.93	17.695	17.7151	8714.0
2022-06-14	AFLG	ETF	22.532	22.532	22.532	22.532	100.0
2022-06-14	AFMC	ETF	21.293	21.293	21.293	21.293	100.0
2022-06-14	AFSM	ETF	22.34	22.34	22.259	22.259	200.0
2022-06-14	AFTY	ETF	17.44	17.469	17.44	17.469	1300.0
2022-06-14	AGG	ETF	99.84	99.94	98.86	99.01	10943400.0
2022-06-14	AGGY	ETF	44.0	44.052	43.47	43.6	196900.0
2022-06-14	AGNG	ETF	23.65	23.72	23.64	23.689	2300.0
2022-06-14	AGOV	ETF	79.17	79.17	77.031	77.031	335.0
2022-06-14	AGOX	ETF	20.46	20.642	20.43	20.543	107900.0
2022-06-14	AGQ	ETF	27.14	27.23	26.32	26.59	726100.0
2022-06-14	AGZ	ETF	108.05	108.2016	107.21	107.21	59991.0
2022-06-14	AGZD	ETF	23.1	23.145	22.91	22.91	643600.0
2022-06-14	AHHX	ETF	8.56	8.56	8.48	8.5482	3764.0
2022-06-14	AHYB	ETF	42.84	42.935	42.395	42.709	1700.0
2022-06-14	AIA	ETF	62.75	63.4313	62.58	63.22	59236.0
2022-06-14	AIEQ	ETF	31.1	31.1	30.65	30.95	9300.0
2022-06-14	AIQ	ETF	20.95	20.95	20.68	20.85	13294.0
2022-06-14	AIRR	ETF	38.23	38.405	37.872	38.17	10500.0
2022-06-14	AIVI	ETF	36.8	36.8	36.2	36.41	17200.0
2022-06-14	AIVL	ETF	89.36	89.5	87.44	88.09	14200.0

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

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