PREVIEW / etf_daily / 2022-08-19

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-19.parquet
  size:    103 KB
  rows:    2,776

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-08-19	SPY	ETF	424.98	425.26	421.22	422.14	68016900.0
2022-08-19	QQQ	ETF	326.17	326.84	322.08	322.86	51770570.0
2022-08-19	IWM	ETF	196.83	197.11	194.07	194.65	27416400.0
2022-08-19	DIA	ETF	338.35	338.66	336.26	337.04	2010300.0
2022-08-19	GLD	ETF	163.65	163.74	162.62	162.72	8173000.0
2022-08-19	TLT	ETF	113.23	113.34	112.74	113.04	16330900.0
2022-08-19	AAA	ETF	24.41	24.41	24.41	24.41	6.0
2022-08-19	AAAU	ETF	17.43	17.43	17.33	17.33	756800.0
2022-08-19	AADR	ETF	50.9	51.16	50.9	51.03	2000.0
2022-08-19	AAPB	ETF	27.2	27.2	26.64	26.734	5710.0
2022-08-19	AAPD	ETF	23.87	24.04	23.737	24.04	115603.0
2022-08-19	AAPU	ETF	26.9081	26.9081	26.4475	26.52	18581.0
2022-08-19	AAXJ	ETF	67.52	67.67	67.14	67.23	591500.0
2022-08-19	ABEQ	ETF	28.14	28.14	27.62	27.642	4400.0
2022-08-19	ACES	ETF	64.5	64.5	62.5	62.98	150400.0
2022-08-19	ACIO	ETF	31.39	31.39	31.06	31.1	49300.0
2022-08-19	ACSI	ETF	47.8752	47.8752	47.8752	47.8752	2.0
2022-08-19	ACT	ETF	26.44	27.0	26.15	26.46	84879.0
2022-08-19	ACTV	ETF	31.8999	31.9	31.78	31.8224	2947.0
2022-08-19	ACTX	ETF	0.65	0.65	0.65	0.65	601.0
2022-08-19	ACVF	ETF	32.0	32.0	31.82	31.83	5500.0
2022-08-19	ACWF	ETF	33.53	33.6024	33.53	33.543	6818.0
2022-08-19	ACWI	ETF	91.34	91.39	90.57	90.77	3602900.0
2022-08-19	ACWV	ETF	99.53	99.63	99.2	99.39	114100.0
2022-08-19	ACWX	ETF	46.18	46.21	45.853	45.93	1582310.0
2022-08-19	ADFI	ETF	8.61	8.65	8.61	8.622	6600.0
2022-08-19	ADIV	ETF	13.663	13.663	13.663	13.663	100.0
2022-08-19	ADME	ETF	37.26	37.26	37.12	37.131	16300.0
2022-08-19	ADRE	ETF	39.67	39.67	39.24	39.3	6697.0
2022-08-19	AEMB	ETF	38.718	38.718	38.718	38.718	100.0
2022-08-19	AESR	ETF	12.27	12.32	12.26	12.3	14100.0
2022-08-19	AFIF	ETF	8.95	8.96	8.94	8.955	20633.0
2022-08-19	AFK	ETF	17.54	17.542	17.27	17.31	6314.0
2022-08-19	AFLG	ETF	25.01	25.01	24.988	24.988	100.0
2022-08-19	AFMC	ETF	23.52	23.52	23.509	23.509	100.0
2022-08-19	AFSM	ETF	24.57	24.57	24.562	24.562	200.0
2022-08-19	AFTY	ETF	17.06	17.06	17.01	17.05	1100.0
2022-08-19	AGG	ETF	102.13	102.13	101.85	101.99	4575500.0
2022-08-19	AGGH	ETF	23.55	23.55	23.55	23.55	289.0
2022-08-19	AGGY	ETF	45.23	45.25	45.1	45.25	62600.0
2022-08-19	AGNG	ETF	25.86	25.865	25.793	25.865	800.0
2022-08-19	AGOV	ETF	83.0	83.0	82.6992	82.6992	1490.0
2022-08-19	AGOX	ETF	22.33	22.39	22.061	22.13	174700.0
2022-08-19	AGQ	ETF	21.63	21.64	21.03	21.14	1389300.0
2022-08-19	AGZ	ETF	109.73	109.82	109.69	109.8006	10081.0
2022-08-19	AGZD	ETF	23.06	23.06	23.005	23.02	93000.0
2022-08-19	AHHX	ETF	8.81	8.81	8.76	8.7949	3230.0
2022-08-19	AHYB	ETF	44.651	44.651	44.59	44.62	1200.0
2022-08-19	AIA	ETF	59.2	59.33	58.821	58.94	36462.0
2022-08-19	AIEQ	ETF	35.721	35.721	35.41	35.413	4300.0

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

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