PREVIEW / etf_daily / 2021-05-05

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-05.parquet
  size:    88 KB
  rows:    2,331

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-05-05	SPY	ETF	417.38	417.63	415.15	415.75	60162200.0
2021-05-05	QQQ	ETF	332.25	333.14	328.23	329.03	46219307.0
2021-05-05	IWM	ETF	224.28	224.54	221.36	222.4	25139500.0
2021-05-05	DIA	ETF	342.25	343.3	340.37	342.28	3506100.0
2021-05-05	GLD	ETF	166.63	167.31	166.61	167.27	5950000.0
2021-05-05	TLT	ETF	139.03	139.85	138.92	139.69	11127900.0
2021-05-05	AAA	ETF	25.0082	25.01	24.97	24.985	37916.0
2021-05-05	AAAU	ETF	17.71	17.78	17.71	17.78	323200.0
2021-05-05	AADR	ETF	65.94	66.33	65.31	65.55	10000.0
2021-05-05	AAXJ	ETF	92.83	92.97	92.42	92.61	1509000.0
2021-05-05	ABEQ	ETF	27.61	27.68	27.61	27.674	1500.0
2021-05-05	ACES	ETF	69.19	69.19	67.2	67.81	175900.0
2021-05-05	ACIO	ETF	29.85	29.85	29.572	29.61	24000.0
2021-05-05	ACSI	ETF	48.8607	48.8607	48.8607	48.8607	244.0
2021-05-05	ACTV	ETF	37.23	37.56	37.23	37.43	6176.0
2021-05-05	ACTX	ETF	3.75	3.75	3.75	3.75	359.0
2021-05-05	ACVF	ETF	31.05	31.06	30.912	30.912	5400.0
2021-05-05	ACWF	ETF	37.69	37.8	37.7164	37.7164	787.0
2021-05-05	ACWI	ETF	99.25	99.38	98.76	99.0	1640800.0
2021-05-05	ACWV	ETF	101.7	102.0	101.46	101.73	101000.0
2021-05-05	ACWX	ETF	56.77	56.96	56.59	56.86	533769.0
2021-05-05	ADFI	ETF	9.7	9.72	9.69	9.71	3900.0
2021-05-05	ADIV	ETF	18.52	18.53	18.52	18.53	55900.0
2021-05-05	ADME	ETF	38.613	38.71	38.539	38.539	11900.0
2021-05-05	ADRE	ETF	56.18	56.4	55.96	56.0	9144.0
2021-05-05	AESR	ETF	13.2	13.25	13.182	13.182	13400.0
2021-05-05	AFIF	ETF	9.72	9.74	9.71	9.73	17334.0
2021-05-05	AFK	ETF	21.88	21.965	21.81	21.89	10566.0
2021-05-05	AFLG	ETF	24.97	24.97	24.917	24.917	3400.0
2021-05-05	AFMC	ETF	25.52	25.52	25.44	25.44	1300.0
2021-05-05	AFSM	ETF	25.711	25.711	25.711	25.711	800.0
2021-05-05	AFTY	ETF	22.549	22.549	22.549	22.549	100.0
2021-05-05	AGG	ETF	114.45	114.62	114.45	114.62	3329000.0
2021-05-05	AGGY	ETF	51.71	51.85	51.71	51.8	83600.0
2021-05-05	AGNG	ETF	28.66	28.66	28.551	28.56	2500.0
2021-05-05	AGQ	ETF	47.71	48.12	47.42	47.98	549000.0
2021-05-05	AGZ	ETF	118.03	118.24	118.03	118.24	21782.0
2021-05-05	AGZD	ETF	23.51	23.57	23.5	23.545	27800.0
2021-05-05	AIA	ETF	91.11	91.45	90.91	91.15	85353.0
2021-05-05	AIEQ	ETF	37.96	38.32	37.52	37.68	19100.0
2021-05-05	AIQ	ETF	28.77	28.799	28.49	28.5644	20297.0
2021-05-05	AIRR	ETF	42.18	42.34	41.637	41.92	72600.0
2021-05-05	AIVI	ETF	43.38	43.65	43.38	43.62	32600.0
2021-05-05	ALTL	ETF	41.39	41.5022	41.06	41.2691	34487.0
2021-05-05	ALTY	ETF	13.42	13.42	13.21	13.31	39400.0
2021-05-05	AMJ	ETF	18.03	18.4	18.0	18.0	304348.0
2021-05-05	AMLP	ETF	33.31	34.0	33.13	33.52	3626200.0
2021-05-05	AMNA	ETF	31.999	31.999	31.999	31.999	3.0
2021-05-05	AMND	ETF	33.9663	33.9663	33.9663	33.9663	4.0
2021-05-05	AMOM	ETF	35.29	35.29	34.7	34.7	8600.0

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

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