PREVIEW / etf_daily / 2021-07-27

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-27.parquet
  size:    91 KB
  rows:    2,421

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-27	SPY	ETF	439.91	439.94	435.99	439.01	67397100.0
2021-07-27	QQQ	ETF	368.22	368.22	360.16	364.43	57933148.0
2021-07-27	IWM	ETF	219.01	219.08	215.38	217.62	35063600.0
2021-07-27	DIA	ETF	350.02	350.68	348.73	350.62	3902600.0
2021-07-27	GLD	ETF	168.73	168.91	167.93	168.44	6300200.0
2021-07-27	TLT	ETF	149.33	149.69	148.99	149.64	13036500.0
2021-07-27	AAA	ETF	25.0299	25.0299	24.99	25.02	1601.0
2021-07-27	AAAU	ETF	17.94	17.95	17.86	17.92	431100.0
2021-07-27	AADR	ETF	65.2	65.58	65.2	65.58	1300.0
2021-07-27	AAXJ	ETF	85.52	85.82	84.38	85.53	4398300.0
2021-07-27	ABEQ	ETF	27.335	27.39	27.321	27.383	5300.0
2021-07-27	ACES	ETF	69.46	69.46	67.53	68.92	44700.0
2021-07-27	ACIO	ETF	31.009	31.009	30.85	30.948	4700.0
2021-07-27	ACSI	ETF	51.1284	51.1284	51.1284	51.1284	145.0
2021-07-27	ACTV	ETF	38.45	38.45	37.675	37.8314	7403.0
2021-07-27	ACVF	ETF	32.4	32.44	32.28	32.436	5000.0
2021-07-27	ACWF	ETF	37.92	37.92	37.5453	37.7936	39221.0
2021-07-27	ACWI	ETF	101.82	101.82	100.92	101.66	2535900.0
2021-07-27	ACWV	ETF	104.17	104.57	104.14	104.57	85100.0
2021-07-27	ACWX	ETF	55.95	55.98	55.57	55.96	984666.0
2021-07-27	ADFI	ETF	9.78	9.78	9.75	9.773	3000.0
2021-07-27	ADIV	ETF	17.82	17.874	17.82	17.874	300.0
2021-07-27	ADME	ETF	40.74	40.78	40.585	40.778	4900.0
2021-07-27	ADRE	ETF	51.12	51.275	50.0878	51.07	16309.0
2021-07-27	AEMB	ETF	49.875	49.875	49.875	49.875	100.0
2021-07-27	AESR	ETF	14.04	14.04	13.82	13.895	5900.0
2021-07-27	AFIF	ETF	9.6945	9.728	9.6945	9.71	10525.0
2021-07-27	AFK	ETF	21.45	21.45	21.0601	21.29	6627.0
2021-07-27	AFLG	ETF	25.87	25.912	25.87	25.912	400.0
2021-07-27	AFMC	ETF	25.05	25.12	25.05	25.12	100.0
2021-07-27	AFSM	ETF	25.472	25.472	25.472	25.472	100.0
2021-07-27	AFTY	ETF	19.7	19.718	19.36	19.6	36200.0
2021-07-27	AGG	ETF	116.35	116.4	116.27	116.38	5423800.0
2021-07-27	AGGY	ETF	52.77	52.79	52.73	52.78	87800.0
2021-07-27	AGNG	ETF	30.69	30.69	30.12	30.22	4500.0
2021-07-27	AGOV	ETF	99.86	100.0	99.5001	99.715	2411.0
2021-07-27	AGOX	ETF	26.01	26.01	25.766	25.933	23800.0
2021-07-27	AGQ	ETF	42.31	42.33	40.1	40.98	980700.0
2021-07-27	AGZ	ETF	119.18	119.26	119.08	119.16	155223.0
2021-07-27	AGZD	ETF	23.44	23.45	23.43	23.435	51800.0
2021-07-27	AIA	ETF	81.41	81.85	80.31	81.85	268875.0
2021-07-27	AIEQ	ETF	41.22	41.22	40.25	40.77	14700.0
2021-07-27	AIQ	ETF	30.5	30.5	29.925	30.28	20514.0
2021-07-27	AIRR	ETF	40.24	40.68	40.04	40.46	119500.0
2021-07-27	AIVI	ETF	43.52	43.68	43.52	43.64	2300.0
2021-07-27	ALTL	ETF	43.12	43.12	42.5	42.87	221935.0
2021-07-27	ALTY	ETF	13.61	13.61	13.55	13.598	10500.0
2021-07-27	AMJ	ETF	18.65	18.65	18.18	18.24	564224.0
2021-07-27	AMLP	ETF	34.48	34.48	33.63	33.76	1809400.0
2021-07-27	AMNA	ETF	32.3362	32.3362	32.3362	32.3362	35.0

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

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