PREVIEW / etf_daily / 2022-07-12

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-12.parquet
  size:    102 KB
  rows:    2,733

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-07-12	SPY	ETF	383.65	386.16	378.99	380.83	62219200.0
2022-07-12	QQQ	ETF	290.32	292.28	284.61	286.24	55797088.0
2022-07-12	IWM	ETF	171.54	173.36	170.56	171.47	23864200.0
2022-07-12	DIA	ETF	310.56	313.55	308.6	309.97	2806000.0
2022-07-12	GLD	ETF	161.22	161.62	160.72	160.83	5375100.0
2022-07-12	TLT	ETF	115.51	116.23	114.97	115.12	18547300.0
2022-07-12	AAA	ETF	24.2949	24.2949	24.2949	24.2949	24.0
2022-07-12	AAAU	ETF	17.17	17.22	17.12	17.14	1028000.0
2022-07-12	AADR	ETF	47.38	47.53	47.19	47.19	700.0
2022-07-12	AAXJ	ETF	67.09	67.44	66.81	67.05	1772800.0
2022-07-12	ABEQ	ETF	26.8	26.9	26.63	26.664	17200.0
2022-07-12	ACES	ETF	49.89	50.0	48.62	49.13	28600.0
2022-07-12	ACIO	ETF	29.05	29.09	28.8	28.86	168900.0
2022-07-12	ACSI	ETF	43.24	43.24	42.9059	42.9059	178.0
2022-07-12	ACT	ETF	21.62	22.415	21.62	22.35	125313.0
2022-07-12	ACTV	ETF	30.34	30.76	30.34	30.4489	10081.0
2022-07-12	ACTX	ETF	0.8	0.8	0.8	0.8	1050.0
2022-07-12	ACVF	ETF	28.79	29.052	28.692	28.692	1400.0
2022-07-12	ACWF	ETF	31.32	31.34	30.9201	31.0153	24114.0
2022-07-12	ACWI	ETF	84.03	84.53	83.37	83.72	2987400.0
2022-07-12	ACWV	ETF	95.33	95.54	94.55	94.88	384300.0
2022-07-12	ACWX	ETF	43.92	44.27	43.84	43.95	2143429.0
2022-07-12	ADFI	ETF	8.56	8.57	8.52	8.531	12100.0
2022-07-12	ADIV	ETF	13.64	13.64	13.616	13.616	400.0
2022-07-12	ADME	ETF	34.82	34.85	34.515	34.59	140400.0
2022-07-12	ADRE	ETF	38.11	38.22	37.9362	37.98	1754.0
2022-07-12	AEMB	ETF	36.84	36.84	36.83	36.83	900.0
2022-07-12	AESR	ETF	11.19	11.33	11.07	11.12	19900.0
2022-07-12	AFIF	ETF	8.87	8.89	8.87	8.87	6690.0
2022-07-12	AFK	ETF	16.62	16.82	16.62	16.72	18876.0
2022-07-12	AFMC	ETF	21.19	21.19	21.18	21.18	1200.0
2022-07-12	AFSM	ETF	21.93	21.93	21.925	21.925	1100.0
2022-07-12	AFTY	ETF	18.17	18.17	18.15	18.17	200.0
2022-07-12	AGG	ETF	102.02	102.19	101.82	101.84	6690500.0
2022-07-12	AGGH	ETF	23.74	23.74	23.6949	23.6949	2300.0
2022-07-12	AGGY	ETF	44.98	45.07	44.88	44.88	139500.0
2022-07-12	AGNG	ETF	25.553	25.575	25.54	25.575	1000.0
2022-07-12	AGOV	ETF	80.46	80.46	79.26	79.705	461.0
2022-07-12	AGOX	ETF	20.07	20.32	20.02	20.03	38300.0
2022-07-12	AGQ	ETF	21.37	21.75	21.14	21.25	483500.0
2022-07-12	AGRH	ETF	25.241	25.265	25.241	25.265	397.0
2022-07-12	AGZ	ETF	110.24	110.32	109.84	109.91	54281.0
2022-07-12	AGZD	ETF	22.9	22.92	22.76	22.76	34400.0
2022-07-12	AHHX	ETF	8.46	8.4776	8.42	8.4621	4700.0
2022-07-12	AHYB	ETF	43.18	43.236	43.18	43.236	300.0
2022-07-12	AIA	ETF	60.42	60.6871	60.07	60.31	51584.0
2022-07-12	AIEQ	ETF	31.697	31.697	31.4	31.58	3200.0
2022-07-12	AIQ	ETF	21.12	21.12	20.785	20.81	9058.0
2022-07-12	AIRR	ETF	37.7	37.81	37.29	37.31	12700.0
2022-07-12	AIVI	ETF	34.46	34.83	34.46	34.65	1700.0

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

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