PREVIEW / etf_daily / 2021-04-12

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-12.parquet
  size:    88 KB
  rows:    2,325

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-04-12	SPY	ETF	410.85	411.93	410.2	411.64	56704900.0
2021-04-12	QQQ	ETF	336.04	337.1	334.73	336.67	25833013.0
2021-04-12	IWM	ETF	222.72	222.93	220.4	221.72	20533900.0
2021-04-12	DIA	ETF	337.26	337.86	336.65	337.55	2951500.0
2021-04-12	GLD	ETF	162.73	162.8	161.81	162.28	4896700.0
2021-04-12	TLT	ETF	137.46	137.53	137.1	137.45	7659000.0
2021-04-12	AAA	ETF	25.05	25.05	25.05	25.05	12.0
2021-04-12	AAAU	ETF	17.28	17.29	17.19	17.23	549700.0
2021-04-12	AADR	ETF	63.05	63.05	62.13	62.13	1100.0
2021-04-12	AAXJ	ETF	92.59	92.59	92.18	92.41	2127300.0
2021-04-12	ABEQ	ETF	26.77	26.783	26.755	26.783	1000.0
2021-04-12	ACES	ETF	75.34	75.66	73.95	74.82	184300.0
2021-04-12	ACIO	ETF	29.21	29.23	29.11	29.2	22300.0
2021-04-12	ACSI	ETF	48.0652	48.1179	48.0652	48.1179	779.0
2021-04-12	ACTV	ETF	36.22	36.285	36.17	36.227	4595.0
2021-04-12	ACTX	ETF	4.75	4.75	4.75	4.75	499.0
2021-04-12	ACVF	ETF	30.9	30.9	30.513	30.669	7800.0
2021-04-12	ACWF	ETF	37.41	37.42	37.26	37.35	7965.0
2021-04-12	ACWI	ETF	97.91	98.0	97.69	97.96	2863600.0
2021-04-12	ACWV	ETF	99.94	99.97	99.75	99.95	146200.0
2021-04-12	ACWX	ETF	56.14	56.14	55.96	56.08	551667.0
2021-04-12	ADFI	ETF	9.67	9.69	9.65	9.675	4900.0
2021-04-12	ADIV	ETF	18.65	18.65	18.557	18.557	2200.0
2021-04-12	ADME	ETF	38.04	38.04	37.903	38.01	19400.0
2021-04-12	ADRE	ETF	56.52	56.59	56.125	56.52	14304.0
2021-04-12	AESR	ETF	13.05	13.11	13.04	13.088	25300.0
2021-04-12	AFIF	ETF	9.75	9.75	9.69	9.72	19438.0
2021-04-12	AFK	ETF	21.42	21.42	21.27	21.3	6646.0
2021-04-12	AFLG	ETF	24.71	24.71	24.61	24.684	1000.0
2021-04-12	AFMC	ETF	24.884	24.884	24.884	24.884	100.0
2021-04-12	AFSM	ETF	25.622	25.622	25.622	25.622	100.0
2021-04-12	AFTY	ETF	21.945	21.98	21.94	21.945	2700.0
2021-04-12	AGG	ETF	114.17	114.17	114.0	114.15	3844900.0
2021-04-12	AGGY	ETF	51.53	51.56	51.513	51.54	119500.0
2021-04-12	AGNG	ETF	27.975	28.07	27.975	27.986	1300.0
2021-04-12	AGQ	ETF	43.36	43.42	41.95	42.36	685000.0
2021-04-12	AGZ	ETF	117.89	117.8993	117.87	117.88	65596.0
2021-04-12	AGZD	ETF	23.555	23.59	23.525	23.55	42000.0
2021-04-12	AIA	ETF	92.95	92.96	92.51	92.96	188339.0
2021-04-12	AIEQ	ETF	39.48	39.48	39.0	39.03	30600.0
2021-04-12	AIQ	ETF	29.79	29.79	29.6	29.6881	20871.0
2021-04-12	AIRR	ETF	41.43	41.696	41.149	41.367	90400.0
2021-04-12	AIVI	ETF	42.89	42.89	42.75	42.78	1100.0
2021-04-12	ALTL	ETF	39.7062	39.88	39.6517	39.8147	10419.0
2021-04-12	ALTY	ETF	12.95	12.97	12.934	12.97	11800.0
2021-04-12	AMJ	ETF	16.88	17.01	16.685	16.74	640653.0
2021-04-12	AMLP	ETF	31.13	31.35	30.73	30.93	1925300.0
2021-04-12	AMNA	ETF	29.6217	29.6217	29.6217	29.6217	3.0
2021-04-12	AMND	ETF	31.479	31.479	31.479	31.479	17.0
2021-04-12	AMOM	ETF	34.65	34.81	34.3	34.783	12900.0

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

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