PREVIEW / etf_daily / 2021-09-07

all etf daily files

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

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-09-07	SPY	ETF	452.71	452.81	450.74	451.46	51671500.0
2021-09-07	QQQ	ETF	381.68	382.778	380.4882	382.11	23970203.0
2021-09-07	IWM	ETF	227.72	229.0	226.25	226.39	19153400.0
2021-09-07	DIA	ETF	353.64	353.69	350.99	351.44	3168500.0
2021-09-07	GLD	ETF	169.56	169.78	167.63	167.71	10004600.0
2021-09-07	TLT	ETF	147.26	147.52	146.66	146.93	15547800.0
2021-09-07	AAA	ETF	25.005	25.005	25.005	25.005	58.0
2021-09-07	AAAU	ETF	18.04	18.05	17.83	17.84	237200.0
2021-09-07	AADR	ETF	68.64	68.64	68.19	68.39	1500.0
2021-09-07	AAXJ	ETF	90.26	90.99	90.26	90.7	1353100.0
2021-09-07	ABEQ	ETF	28.22	28.22	27.65	27.65	4500.0
2021-09-07	ACES	ETF	70.78	71.44	70.692	70.72	84100.0
2021-09-07	ACIO	ETF	31.1	31.12	31.02	31.02	59400.0
2021-09-07	ACSI	ETF	51.4045	51.4045	51.4045	51.4045	132.0
2021-09-07	ACTV	ETF	38.84	38.84	38.5153	38.5153	2050.0
2021-09-07	ACTX	ETF	1.11	1.11	1.0	1.1	2033.0
2021-09-07	ACVF	ETF	33.7	33.7	33.31	33.38	31600.0
2021-09-07	ACWF	ETF	39.41	39.41	39.18	39.21	66762.0
2021-09-07	ACWI	ETF	105.33	105.34	105.03	105.13	3807200.0
2021-09-07	ACWV	ETF	107.97	107.97	107.23	107.42	115800.0
2021-09-07	ACWX	ETF	58.45	58.56	58.42	58.44	756315.0
2021-09-07	ADFI	ETF	9.73	9.76	9.73	9.745	2000.0
2021-09-07	ADIV	ETF	18.142	18.142	18.142	18.142	100.0
2021-09-07	ADME	ETF	41.5	41.5	41.387	41.43	27600.0
2021-09-07	ADRE	ETF	53.51	53.8136	53.51	53.5322	8850.0
2021-09-07	AESR	ETF	14.36	14.36	14.27	14.27	6100.0
2021-09-07	AFIF	ETF	9.69	9.6999	9.68	9.68	9277.0
2021-09-07	AFK	ETF	21.92	21.95	21.79	21.8299	11789.0
2021-09-07	AFLG	ETF	26.719	26.719	26.654	26.654	300.0
2021-09-07	AFMC	ETF	25.896	25.896	25.896	25.896	100.0
2021-09-07	AFSM	ETF	26.615	26.615	26.615	26.615	200.0
2021-09-07	AFTY	ETF	20.75	20.77	20.75	20.77	500.0
2021-09-07	AGG	ETF	115.64	115.65	115.47	115.54	3579900.0
2021-09-07	AGGY	ETF	52.46	52.486	52.41	52.453	115700.0
2021-09-07	AGNG	ETF	31.09	31.25	31.0	31.0	1700.0
2021-09-07	AGOX	ETF	26.76	26.815	26.65	26.73	26200.0
2021-09-07	AGQ	ETF	39.48	39.82	38.52	39.08	1047300.0
2021-09-07	AGZ	ETF	119.05	119.05	118.95	119.0	69321.0
2021-09-07	AGZD	ETF	23.43	23.435	23.4	23.4	25200.0
2021-09-07	AIA	ETF	84.81	85.725	84.81	85.26	62775.0
2021-09-07	AIEQ	ETF	43.6	43.67	43.318	43.49	31500.0
2021-09-07	AIQ	ETF	32.1	32.32	32.1	32.32	21145.0
2021-09-07	AIRR	ETF	42.56	42.734	42.233	42.257	15900.0
2021-09-07	AIVI	ETF	43.68	43.73	43.63	43.64	11100.0
2021-09-07	ALTL	ETF	43.9	43.9	43.14	43.17	36839.0
2021-09-07	ALTY	ETF	13.71	13.77	13.65	13.66	27900.0
2021-09-07	AMJ	ETF	18.12	18.29	17.99	18.04	295810.0
2021-09-07	AMLP	ETF	33.29	33.65	33.03	33.04	1367000.0
2021-09-07	AMNA	ETF	32.222	32.222	32.222	32.222	0.0
2021-09-07	AMND	ETF	33.867	33.867	33.867	33.867	2.0

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

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