PREVIEW / etf_daily / 2021-05-18

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-18.parquet
  size:    88 KB
  rows:    2,345

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-05-18	SPY	ETF	415.8	416.06	411.77	411.94	59810200.0
2021-05-18	QQQ	ETF	325.39	326.65	321.94	322.22	36528454.0
2021-05-18	IWM	ETF	221.39	223.24	219.47	219.64	24564500.0
2021-05-18	DIA	ETF	343.85	344.5	340.87	341.11	3462300.0
2021-05-18	GLD	ETF	175.18	175.21	174.46	175.04	7294000.0
2021-05-18	TLT	ETF	136.4	136.57	136.07	136.44	11423100.0
2021-05-18	AAA	ETF	25.02	25.02	25.005	25.005	468.0
2021-05-18	AAAU	ETF	18.62	18.62	18.54	18.61	219800.0
2021-05-18	AADR	ETF	65.3	65.44	64.9	65.19	2400.0
2021-05-18	AAXJ	ETF	91.83	92.4	91.79	91.86	764500.0
2021-05-18	ABEQ	ETF	28.44	28.44	28.3	28.304	800.0
2021-05-18	ACES	ETF	63.65	65.599	63.536	64.83	93000.0
2021-05-18	ACIO	ETF	29.54	29.55	29.376	29.376	21800.0
2021-05-18	ACSI	ETF	48.987	48.987	48.987	48.987	321.0
2021-05-18	ACTV	ETF	38.45	38.6	38.13	38.14	10721.0
2021-05-18	ACTX	ETF	3.51	3.51	3.51	3.51	804.0
2021-05-18	ACVF	ETF	30.81	30.96	30.77	30.78	6000.0
2021-05-18	ACWF	ETF	37.87	37.87	37.5862	37.5862	36777.0
2021-05-18	ACWI	ETF	99.25	99.43	98.65	98.66	1210400.0
2021-05-18	ACWV	ETF	102.73	103.03	102.44	102.45	114000.0
2021-05-18	ACWX	ETF	57.44	57.57	57.31	57.31	1348454.0
2021-05-18	ADFI	ETF	9.67	9.67	9.63	9.65	1300.0
2021-05-18	ADIV	ETF	18.496	18.496	18.453	18.453	100.0
2021-05-18	ADME	ETF	38.4	38.43	38.15	38.15	26900.0
2021-05-18	ADRE	ETF	55.0	55.35	54.93	55.28	12137.0
2021-05-18	AESR	ETF	13.17	13.18	13.046	13.046	5200.0
2021-05-18	AFIF	ETF	9.68	9.71	9.68	9.695	10892.0
2021-05-18	AFK	ETF	22.19	22.19	21.87	22.18	16183.0
2021-05-18	AFLG	ETF	24.782	24.782	24.782	24.782	100.0
2021-05-18	AFMC	ETF	25.48	25.48	25.183	25.183	800.0
2021-05-18	AFTY	ETF	23.345	23.37	23.34	23.346	2200.0
2021-05-18	AGG	ETF	114.11	114.11	114.03	114.06	3674600.0
2021-05-18	AGGY	ETF	51.52	51.53	51.47	51.53	120000.0
2021-05-18	AGNG	ETF	28.7	28.95	28.7	28.763	3000.0
2021-05-18	AGOX	ETF	24.88	25.34	24.88	25.083	16500.0
2021-05-18	AGQ	ETF	55.34	55.39	53.67	54.37	1260000.0
2021-05-18	AGZ	ETF	117.92	118.0492	117.9166	117.96	20918.0
2021-05-18	AGZD	ETF	23.46	23.52	23.46	23.515	35000.0
2021-05-18	AIA	ETF	89.14	89.685	89.03	89.29	100294.0
2021-05-18	AIEQ	ETF	36.48	36.847	36.26	36.26	6600.0
2021-05-18	AIQ	ETF	27.99	28.1462	27.92	27.92	32486.0
2021-05-18	AIRR	ETF	41.78	41.78	41.06	41.06	40500.0
2021-05-18	AIVI	ETF	44.55	44.55	44.3	44.3	2700.0
2021-05-18	ALTL	ETF	41.43	41.43	41.2	41.2026	13011.0
2021-05-18	ALTY	ETF	13.42	13.47	13.39	13.42	19500.0
2021-05-18	AMJ	ETF	19.35	19.4	19.14	19.16	380684.0
2021-05-18	AMLP	ETF	35.11	35.23	34.67	34.67	2634700.0
2021-05-18	AMNA	ETF	33.355	33.355	33.355	33.355	3.0
2021-05-18	AMND	ETF	35.4403	35.4403	35.4403	35.4403	1.0
2021-05-18	AMOM	ETF	34.18	34.21	33.74	33.74	34400.0

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

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