PREVIEW / etf_daily / 2021-05-19

all etf daily files

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

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-19	SPY	ETF	406.92	411.05	405.33	410.86	106467100.0
2021-05-19	QQQ	ETF	316.66	322.9	316.3	322.59	66319108.0
2021-05-19	IWM	ETF	216.03	218.16	214.05	217.95	31202800.0
2021-05-19	DIA	ETF	337.56	339.56	335.2	339.44	7223900.0
2021-05-19	GLD	ETF	175.14	177.0	174.35	175.16	20741100.0
2021-05-19	TLT	ETF	136.54	137.3	135.62	136.11	14296000.0
2021-05-19	AAA	ETF	25.005	25.02	24.99	25.005	7727.0
2021-05-19	AAAU	ETF	18.62	18.81	18.54	18.61	922100.0
2021-05-19	AADR	ETF	63.57	63.99	63.17	63.88	2600.0
2021-05-19	AAXJ	ETF	90.99	92.08	90.7	91.85	519900.0
2021-05-19	ABEQ	ETF	28.035	28.105	28.035	28.105	600.0
2021-05-19	ACES	ETF	63.42	65.79	63.2	65.79	77200.0
2021-05-19	ACIO	ETF	29.13	29.325	29.11	29.325	15200.0
2021-05-19	ACSI	ETF	48.557	48.557	48.557	48.557	302.0
2021-05-19	ACTV	ETF	38.46	38.46	37.4801	37.85	3468.0
2021-05-19	ACTX	ETF	3.51	3.54	3.51	3.54	1177.0
2021-05-19	ACVF	ETF	30.34	30.67	30.255	30.67	4500.0
2021-05-19	ACWF	ETF	37.08	37.43	36.98	37.4271	11396.0
2021-05-19	ACWI	ETF	97.47	98.26	97.1	98.2	4550700.0
2021-05-19	ACWV	ETF	101.64	102.17	101.49	102.02	124900.0
2021-05-19	ACWX	ETF	56.56	57.11	56.41	56.88	1108565.0
2021-05-19	ADFI	ETF	9.65	9.66	9.632	9.632	3900.0
2021-05-19	ADIV	ETF	18.4	18.41	18.32	18.36	11700.0
2021-05-19	ADME	ETF	37.76	38.07	37.75	38.07	14400.0
2021-05-19	ADRE	ETF	54.18	55.11	54.18	55.1	18771.0
2021-05-19	AESR	ETF	12.61	12.98	12.61	12.98	30800.0
2021-05-19	AFIF	ETF	9.7001	9.71	9.69	9.695	10175.0
2021-05-19	AFK	ETF	22.09	22.09	21.77	21.87	6240.0
2021-05-19	AFLG	ETF	24.53	24.631	24.53	24.631	400.0
2021-05-19	AFMC	ETF	24.937	24.937	24.937	24.937	600.0
2021-05-19	AFSM	ETF	25.15	25.332	25.15	25.332	200.0
2021-05-19	AFTY	ETF	23.22	23.22	23.17	23.17	2100.0
2021-05-19	AGG	ETF	114.62	114.62	113.79	113.9	6892400.0
2021-05-19	AGGY	ETF	51.47	51.56	51.38	51.46	107500.0
2021-05-19	AGNG	ETF	28.475	28.657	28.475	28.657	2000.0
2021-05-19	AGOX	ETF	24.68	24.92	23.13	24.8	57500.0
2021-05-19	AGQ	ETF	52.3	54.58	51.59	52.53	1815900.0
2021-05-19	AGZ	ETF	117.95	118.0725	117.8536	118.01	1043490.0
2021-05-19	AGZD	ETF	23.48	23.515	23.475	23.505	20000.0
2021-05-19	AIA	ETF	88.21	89.3329	87.96	89.19	210914.0
2021-05-19	AIEQ	ETF	35.49	36.0	35.36	35.96	12200.0
2021-05-19	AIQ	ETF	27.42	27.86	27.375	27.81	13947.0
2021-05-19	AIRR	ETF	40.36	40.64	39.84	40.64	244400.0
2021-05-19	AIVI	ETF	43.68	43.91	43.68	43.84	2800.0
2021-05-19	ALTL	ETF	40.96	40.9934	40.62	40.9934	15495.0
2021-05-19	ALTY	ETF	13.26	13.31	13.09	13.29	43200.0
2021-05-19	AMJ	ETF	18.8	18.96	18.55	18.77	1193690.0
2021-05-19	AMLP	ETF	34.19	34.36	33.56	34.06	3158900.0
2021-05-19	AMNA	ETF	32.7857	32.7857	32.7857	32.7857	0.0
2021-05-19	AMND	ETF	34.7757	34.7757	34.7757	34.7757	3.0

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

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