PREVIEW / etf_daily / 2021-07-19

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-19.parquet
  size:    92 KB
  rows:    2,428

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-07-19	SPY	ETF	426.19	431.41	421.97	424.97	147987000.0
2021-07-19	QQQ	ETF	354.05	355.18	352.04	354.67	64404625.0
2021-07-19	IWM	ETF	210.63	214.45	209.05	211.73	58571000.0
2021-07-19	DIA	ETF	341.79	350.03	337.38	339.88	9715300.0
2021-07-19	GLD	ETF	169.51	169.91	168.89	169.61	6707400.0
2021-07-19	TLT	ETF	150.95	151.95	150.62	151.46	40203900.0
2021-07-19	AAA	ETF	25.0	25.02	25.0	25.015	3524.0
2021-07-19	AAAU	ETF	18.01	18.06	17.96	18.02	449100.0
2021-07-19	AADR	ETF	63.02	63.02	62.67	62.69	1500.0
2021-07-19	AAXJ	ETF	90.33	90.46	89.83	90.25	2803800.0
2021-07-19	ABEQ	ETF	26.98	26.99	26.755	26.875	3600.0
2021-07-19	ACES	ETF	66.2	67.565	65.655	67.41	52700.0
2021-07-19	ACIO	ETF	30.53	30.53	30.129	30.18	18800.0
2021-07-19	ACSI	ETF	49.4944	49.4944	49.4944	49.4944	392.0
2021-07-19	ACTV	ETF	36.8626	37.08	36.6501	36.8869	7552.0
2021-07-19	ACTX	ETF	2.38	2.38	2.0	2.0	1668.0
2021-07-19	ACVF	ETF	31.4	31.59	29.95	31.374	6200.0
2021-07-19	ACWF	ETF	37.09	37.155	36.96	37.1	6533.0
2021-07-19	ACWI	ETF	99.61	99.71	98.82	99.44	5313800.0
2021-07-19	ACWV	ETF	103.9	104.14	102.94	103.62	299500.0
2021-07-19	ACWX	ETF	55.73	55.77	55.33	55.61	2095598.0
2021-07-19	ADFI	ETF	9.748	9.748	9.748	9.748	200.0
2021-07-19	ADIV	ETF	18.07	18.07	18.07	18.07	100.0
2021-07-19	ADME	ETF	40.01	40.01	39.565	39.695	14700.0
2021-07-19	ADRE	ETF	53.76	53.876	53.292	53.721	10419.0
2021-07-19	AESR	ETF	13.44	13.48	13.36	13.423	14400.0
2021-07-19	AFIF	ETF	9.73	9.76	9.7295	9.7459	20318.0
2021-07-19	AFK	ETF	21.31	21.31	21.0	21.2015	15414.0
2021-07-19	AFLG	ETF	24.99	25.047	24.99	25.047	1600.0
2021-07-19	AFMC	ETF	24.06	24.115	24.045	24.115	1100.0
2021-07-19	AFSM	ETF	24.65	24.704	24.649	24.704	900.0
2021-07-19	AFTY	ETF	22.21	22.211	22.12	22.205	11300.0
2021-07-19	AGG	ETF	116.39	116.61	116.35	116.51	6688100.0
2021-07-19	AGGY	ETF	52.83	52.97	52.82	52.94	73500.0
2021-07-19	AGNG	ETF	30.08	30.08	29.83	29.83	6300.0
2021-07-19	AGOX	ETF	25.46	25.46	24.95	25.056	34200.0
2021-07-19	AGQ	ETF	43.03	43.14	41.98	42.39	1237000.0
2021-07-19	AGZ	ETF	119.23	119.3	119.1454	119.26	16386.0
2021-07-19	AGZD	ETF	23.47	23.48	23.365	23.43	90200.0
2021-07-19	AIA	ETF	87.28	87.3	86.6823	87.28	113087.0
2021-07-19	AIEQ	ETF	38.85	39.54	38.71	39.43	27100.0
2021-07-19	AIQ	ETF	29.7	29.89	29.56	29.82	35247.0
2021-07-19	AIRR	ETF	38.75	38.97	38.11	38.577	210900.0
2021-07-19	AIVI	ETF	42.66	42.66	42.38	42.48	6500.0
2021-07-19	ALTL	ETF	42.58	42.58	41.67	41.97	38346.0
2021-07-19	ALTY	ETF	13.39	13.39	13.18	13.22	38500.0
2021-07-19	AMJ	ETF	17.85	17.85	17.15	17.42	2336288.0
2021-07-19	AMLP	ETF	32.89	32.98	31.79	32.29	5717300.0
2021-07-19	AMNA	ETF	31.1349	31.1349	31.1349	31.1349	1.0
2021-07-19	AMND	ETF	32.7173	32.7173	32.7173	32.7173	3.0

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

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