PREVIEW / etf_daily / 2021-06-23

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-23.parquet
  size:    90 KB
  rows:    2,370

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-06-23	SPY	ETF	423.19	424.05	422.51	422.6	49445400.0
2021-06-23	QQQ	ETF	347.51	348.92	346.88	347.74	27188454.0
2021-06-23	IWM	ETF	227.99	229.96	227.99	228.66	22387500.0
2021-06-23	DIA	ETF	339.59	340.16	338.68	338.78	3082700.0
2021-06-23	GLD	ETF	166.97	168.03	165.97	166.14	8474300.0
2021-06-23	TLT	ETF	143.11	143.5	142.71	143.27	12040900.0
2021-06-23	AAA	ETF	25.0	25.04	25.0	25.005	2056.0
2021-06-23	AAAU	ETF	17.75	17.85	17.65	17.65	536200.0
2021-06-23	AADR	ETF	66.0	66.1	65.98	66.04	1400.0
2021-06-23	AAXJ	ETF	93.34	93.78	93.2	93.26	545400.0
2021-06-23	ABEQ	ETF	27.48	27.49	27.3	27.3	10100.0
2021-06-23	ACES	ETF	72.72	74.3	72.72	73.9	55800.0
2021-06-23	ACIO	ETF	29.93	29.96	29.9	29.9	80900.0
2021-06-23	ACSI	ETF	49.252	49.252	49.252	49.252	165.0
2021-06-23	ACTV	ETF	39.01	39.115	38.9132	38.9132	3753.0
2021-06-23	ACTX	ETF	2.97	3.5	2.97	3.4	2584.0
2021-06-23	ACVF	ETF	31.48	31.54	31.48	31.533	1200.0
2021-06-23	ACWF	ETF	37.7	37.76	37.6381	37.6381	2669.0
2021-06-23	ACWI	ETF	100.65	100.9	100.39	100.46	2294700.0
2021-06-23	ACWV	ETF	102.38	102.51	101.94	101.94	115400.0
2021-06-23	ACWX	ETF	57.61	57.765	57.34	57.41	2277769.0
2021-06-23	ADFI	ETF	9.72	9.72	9.71	9.71	1700.0
2021-06-23	ADIV	ETF	18.758	18.758	18.685	18.685	400.0
2021-06-23	ADME	ETF	39.38	39.48	39.28	39.28	77200.0
2021-06-23	ADRE	ETF	56.22	56.67	56.22	56.35	7401.0
2021-06-23	AESR	ETF	13.39	13.47	13.39	13.47	8300.0
2021-06-23	AFIF	ETF	9.705	9.714	9.69	9.705	5860.0
2021-06-23	AFK	ETF	21.84	21.999	21.84	21.89	12004.0
2021-06-23	AFLG	ETF	25.095	25.095	25.095	25.095	100.0
2021-06-23	AFTY	ETF	22.77	22.77	22.737	22.737	2600.0
2021-06-23	AGG	ETF	115.06	115.14	114.99	115.05	5070500.0
2021-06-23	AGGY	ETF	52.16	52.21	52.14	52.16	67000.0
2021-06-23	AGNG	ETF	30.7	30.7	30.543	30.6	6500.0
2021-06-23	AGOX	ETF	26.14	26.14	25.859	25.859	8200.0
2021-06-23	AGQ	ETF	45.52	46.74	44.92	45.08	770400.0
2021-06-23	AGZ	ETF	118.24	118.3234	118.1855	118.2566	31059.0
2021-06-23	AGZD	ETF	23.525	23.545	23.525	23.535	74200.0
2021-06-23	AIA	ETF	90.2	90.8121	90.19	90.22	93389.0
2021-06-23	AIEQ	ETF	41.03	41.37	41.03	41.32	21300.0
2021-06-23	AIQ	ETF	29.96	30.21	29.96	30.1	270413.0
2021-06-23	AIRR	ETF	40.41	40.64	40.29	40.29	150500.0
2021-06-23	AIVI	ETF	44.03	44.09	43.8	43.8	4300.0
2021-06-23	ALTL	ETF	41.34	41.34	40.83	40.83	26223.0
2021-06-23	ALTY	ETF	13.71	13.71	13.65	13.655	26600.0
2021-06-23	AMJ	ETF	20.12	20.2	19.8	19.82	569827.0
2021-06-23	AMLP	ETF	37.06	37.36	36.56	36.6	2407700.0
2021-06-23	AMNA	ETF	34.3741	34.3741	34.3741	34.3741	0.0
2021-06-23	AMND	ETF	36.3715	36.3715	36.3715	36.3715	0.0
2021-06-23	AMOM	ETF	35.88	36.1	35.88	36.1	13900.0
2021-06-23	AMPS	ETF	9.7902	9.8	9.74	9.77	2964.0

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

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