PREVIEW / etf_daily / 2021-09-08

all etf daily files

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

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-08	SPY	ETF	450.89	451.67	448.86	450.91	56181900.0
2021-09-08	QQQ	ETF	381.93	381.93	378.45	380.78	32949159.0
2021-09-08	IWM	ETF	225.61	225.97	222.63	223.92	25241500.0
2021-09-08	DIA	ETF	350.82	352.17	349.64	350.73	3075700.0
2021-09-08	GLD	ETF	168.02	168.08	166.7	167.29	6576000.0
2021-09-08	TLT	ETF	147.66	148.19	147.39	147.93	14533700.0
2021-09-08	AAA	ETF	25.02	25.02	25.005	25.005	281.0
2021-09-08	AAAU	ETF	17.86	17.87	17.73	17.78	339300.0
2021-09-08	AADR	ETF	68.39	68.39	68.39	68.39	500.0
2021-09-08	AAXJ	ETF	90.17	90.17	89.31	89.52	739500.0
2021-09-08	ABEQ	ETF	27.63	27.725	27.63	27.725	1000.0
2021-09-08	ACES	ETF	71.27	71.48	69.38	69.38	71100.0
2021-09-08	ACIO	ETF	30.923	31.079	30.923	31.07	109200.0
2021-09-08	ACSI	ETF	51.2837	51.2837	51.2837	51.2837	30.0
2021-09-08	ACTV	ETF	38.78	38.78	38.1652	38.1652	2868.0
2021-09-08	ACTX	ETF	1.01	1.15	0.98	1.15	6351.0
2021-09-08	ACVF	ETF	33.56	33.56	33.21	33.3	43300.0
2021-09-08	ACWF	ETF	39.08	39.08	38.79	38.9223	6882.0
2021-09-08	ACWI	ETF	104.81	104.91	104.23	104.57	2538000.0
2021-09-08	ACWV	ETF	107.04	107.64	107.04	107.52	91400.0
2021-09-08	ACWX	ETF	58.17	58.17	57.75	57.85	1221022.0
2021-09-08	ADFI	ETF	9.74	9.76	9.74	9.755	300.0
2021-09-08	ADIV	ETF	17.96	17.96	17.96	17.96	100.0
2021-09-08	ADME	ETF	41.293	41.4	41.235	41.33	47900.0
2021-09-08	ADRE	ETF	53.17	53.17	52.23	52.26	4926.0
2021-09-08	AEMB	ETF	50.23	50.23	50.23	50.23	100.0
2021-09-08	AESR	ETF	14.28	14.28	14.18	14.24	3200.0
2021-09-08	AFIF	ETF	9.7	9.72	9.7	9.715	9080.0
2021-09-08	AFK	ETF	21.72	21.72	21.4	21.4	7810.0
2021-09-08	AFLG	ETF	26.6	26.614	26.59	26.614	300.0
2021-09-08	AFMC	ETF	25.83	25.83	25.83	25.83	100.0
2021-09-08	AFSM	ETF	26.396	26.396	26.396	26.396	100.0
2021-09-08	AFTY	ETF	20.55	20.55	20.48	20.541	300.0
2021-09-08	AGG	ETF	115.7	115.82	115.62	115.73	3417500.0
2021-09-08	AGGY	ETF	52.48	52.58	52.47	52.559	71000.0
2021-09-08	AGNG	ETF	31.0	31.0	30.426	30.86	3500.0
2021-09-08	AGOX	ETF	26.85	26.85	26.43	26.55	27500.0
2021-09-08	AGQ	ETF	38.91	38.93	37.66	37.84	898700.0
2021-09-08	AGZ	ETF	118.99	119.12	118.99	119.07	16744.0
2021-09-08	AGZD	ETF	23.45	23.45	23.405	23.415	33200.0
2021-09-08	AIA	ETF	84.8	84.8	83.8	83.92	65235.0
2021-09-08	AIEQ	ETF	43.37	43.37	43.01	43.1	9300.0
2021-09-08	AIQ	ETF	32.09	32.12	31.65	31.71	27483.0
2021-09-08	AIRR	ETF	42.14	42.174	41.747	41.99	8200.0
2021-09-08	AIVI	ETF	43.59	43.59	43.41	43.45	2400.0
2021-09-08	ALTL	ETF	42.97	43.56	42.97	43.56	36352.0
2021-09-08	ALTY	ETF	13.7	13.719	13.65	13.7	13100.0
2021-09-08	AMJ	ETF	18.03	18.19	17.84	17.92	472811.0
2021-09-08	AMLP	ETF	33.15	33.39	32.79	32.81	1764800.0
2021-09-08	AMNA	ETF	32.1732	32.1732	32.1732	32.1732	0.0

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

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