PREVIEW / etf_daily / 2021-06-21

all etf daily files

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

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-21	SPY	ETF	416.8	421.06	415.93	420.86	72822000.0
2021-06-21	QQQ	ETF	342.43	344.69	340.15	344.36	32992649.0
2021-06-21	IWM	ETF	224.05	227.5	223.28	226.88	26736400.0
2021-06-21	DIA	ETF	335.26	339.09	334.41	338.78	5435700.0
2021-06-21	GLD	ETF	166.52	167.22	166.0	166.95	8371000.0
2021-06-21	TLT	ETF	144.39	144.49	143.02	143.29	16485000.0
2021-06-21	AAA	ETF	25.03	25.03	25.02	25.02	1799.0
2021-06-21	AAAU	ETF	17.7	17.77	17.65	17.75	317500.0
2021-06-21	AADR	ETF	65.61	65.83	65.61	65.83	700.0
2021-06-21	AAXJ	ETF	92.7	93.11	92.27	93.09	859300.0
2021-06-21	ABEQ	ETF	27.47	27.51	27.43	27.5	7800.0
2021-06-21	ACES	ETF	71.51	71.805	70.38	71.36	62700.0
2021-06-21	ACIO	ETF	29.75	29.85	29.659	29.85	153100.0
2021-06-21	ACSI	ETF	48.8531	48.8531	48.8531	48.8531	114.0
2021-06-21	ACTV	ETF	38.61	38.8028	38.61	38.8028	3285.0
2021-06-21	ACTX	ETF	3.0	3.0	2.85	2.85	591.0
2021-06-21	ACVF	ETF	31.16	31.645	31.16	31.471	2000.0
2021-06-21	ACWF	ETF	37.24	37.589	37.2	37.5589	26252.0
2021-06-21	ACWI	ETF	99.46	100.32	99.2	100.24	2354700.0
2021-06-21	ACWV	ETF	101.46	102.43	101.44	102.37	131000.0
2021-06-21	ACWX	ETF	57.19	57.625	57.035	57.56	1290350.0
2021-06-21	ADFI	ETF	9.71	9.717	9.71	9.717	600.0
2021-06-21	ADIV	ETF	18.775	18.775	18.775	18.775	100.0
2021-06-21	ADME	ETF	38.968	39.17	38.968	39.17	77500.0
2021-06-21	ADRE	ETF	55.6	55.8	55.2325	55.77	12410.0
2021-06-21	AESR	ETF	13.3	13.34	13.3	13.335	9500.0
2021-06-21	AFIF	ETF	9.699	9.699	9.65	9.69	50137.0
2021-06-21	AFK	ETF	21.66	21.88	21.66	21.8	10870.0
2021-06-21	AFLG	ETF	24.81	25.032	24.79	25.032	300.0
2021-06-21	AFSM	ETF	26.022	26.022	26.022	26.022	800.0
2021-06-21	AFTY	ETF	22.62	22.754	22.62	22.754	6100.0
2021-06-21	AGG	ETF	115.06	115.12	114.92	114.99	6875500.0
2021-06-21	AGGY	ETF	52.24	52.24	52.13	52.15	92400.0
2021-06-21	AGNG	ETF	30.48	30.579	30.159	30.52	3600.0
2021-06-21	AGOX	ETF	25.77	25.82	25.47	25.78	10600.0
2021-06-21	AGQ	ETF	45.56	45.73	45.04	45.5	1119100.0
2021-06-21	AGZ	ETF	118.28	118.29	118.1693	118.19	21979.0
2021-06-21	AGZD	ETF	23.52	23.52	23.505	23.515	98800.0
2021-06-21	AIA	ETF	89.27	89.87	89.01	89.87	53573.0
2021-06-21	AIEQ	ETF	40.03	40.72	39.8	40.631	25400.0
2021-06-21	AIQ	ETF	29.62	29.8	29.49	29.74	21685.0
2021-06-21	AIRR	ETF	39.59	40.32	39.59	40.13	15900.0
2021-06-21	AIVI	ETF	43.81	44.09	43.81	44.06	4100.0
2021-06-21	ALTL	ETF	40.89	41.11	40.71	41.04	94600.0
2021-06-21	ALTY	ETF	13.55	13.69	13.45	13.67	30900.0
2021-06-21	AMJ	ETF	19.53	20.18	19.53	20.11	563002.0
2021-06-21	AMLP	ETF	36.17	37.27	36.17	37.01	3374700.0
2021-06-21	AMNA	ETF	34.26	34.492	34.26	34.492	661.0
2021-06-21	AMND	ETF	36.6115	36.6115	36.6115	36.6115	109.0
2021-06-21	AMOM	ETF	35.24	35.5	35.235	35.452	10700.0

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

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