PREVIEW / etf_daily / 2021-07-08

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-08.parquet
  size:    91 KB
  rows:    2,413

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-07-08	SPY	ETF	428.78	431.73	427.52	430.92	97595200.0
2021-07-08	QQQ	ETF	355.74	359.65	354.42	358.77	50890021.0
2021-07-08	IWM	ETF	219.31	224.08	217.85	221.7	42297900.0
2021-07-08	DIA	ETF	342.56	345.0	341.53	344.38	6379900.0
2021-07-08	GLD	ETF	169.82	169.86	167.91	168.65	7244300.0
2021-07-08	TLT	ETF	148.88	149.44	148.17	148.62	17487800.0
2021-07-08	AAA	ETF	25.005	25.005	25.005	25.005	83.0
2021-07-08	AAAU	ETF	18.06	18.06	17.85	17.93	210200.0
2021-07-08	AADR	ETF	64.4	64.4	63.43	63.83	32300.0
2021-07-08	AAXJ	ETF	89.97	90.33	89.75	90.09	1058500.0
2021-07-08	ABEQ	ETF	27.265	27.29	27.169	27.187	3400.0
2021-07-08	ACES	ETF	71.4	72.74	70.57	72.31	42100.0
2021-07-08	ACIO	ETF	30.43	30.518	30.38	30.44	50000.0
2021-07-08	ACSI	ETF	50.13	50.1398	50.11	50.1398	825.0
2021-07-08	ACTV	ETF	37.8	38.36	37.8	38.12	8906.0
2021-07-08	ACTX	ETF	2.6	2.6	2.6	2.6	239.0
2021-07-08	ACVF	ETF	31.57	31.849	31.57	31.849	2100.0
2021-07-08	ACWF	ETF	37.58	37.73	37.47	37.5764	19793.0
2021-07-08	ACWI	ETF	100.3	100.94	100.06	100.75	4030900.0
2021-07-08	ACWV	ETF	103.43	103.63	103.03	103.42	108500.0
2021-07-08	ACWX	ETF	56.23	56.47	56.04	56.34	2173079.0
2021-07-08	ADFI	ETF	9.77	9.77	9.77	9.77	100.0
2021-07-08	ADIV	ETF	18.15	18.18	18.15	18.18	400.0
2021-07-08	ADME	ETF	40.03	40.21	39.96	40.19	51700.0
2021-07-08	ADRE	ETF	53.8465	54.1337	53.43	54.04	67358.0
2021-07-08	AESR	ETF	13.6	13.67	13.55	13.648	4200.0
2021-07-08	AFIF	ETF	9.74	9.76	9.72	9.745	3546.0
2021-07-08	AFK	ETF	21.7	21.74	21.53	21.64	12982.0
2021-07-08	AFLG	ETF	25.32	25.56	25.32	25.443	200.0
2021-07-08	AFSM	ETF	25.693	25.693	25.693	25.693	100.0
2021-07-08	AFTY	ETF	22.02	22.126	22.02	22.126	3300.0
2021-07-08	AGG	ETF	116.04	116.18	115.96	116.06	6538400.0
2021-07-08	AGGY	ETF	52.68	52.78	52.68	52.74	55300.0
2021-07-08	AGNG	ETF	30.545	30.69	30.543	30.645	3900.0
2021-07-08	AGOX	ETF	25.645	25.78	25.59	25.688	12100.0
2021-07-08	AGQ	ETF	46.06	46.15	44.84	45.26	1043500.0
2021-07-08	AGZ	ETF	118.8	118.9599	118.8	118.92	18576.0
2021-07-08	AGZD	ETF	23.5	23.54	23.485	23.495	33000.0
2021-07-08	AIA	ETF	86.4	86.66	86.06	86.46	230514.0
2021-07-08	AIEQ	ETF	40.22	41.065	39.64	40.9	35500.0
2021-07-08	AIQ	ETF	30.04	30.4	30.03	30.29	29754.0
2021-07-08	AIRR	ETF	39.21	40.03	39.153	39.58	18000.0
2021-07-08	AIVI	ETF	42.77	42.86	42.77	42.86	2600.0
2021-07-08	ALTL	ETF	41.62	42.06	41.62	41.78	23394.0
2021-07-08	ALTY	ETF	13.49	13.492	13.38	13.42	18600.0
2021-07-08	AMJ	ETF	18.98	19.33	18.75	19.17	761271.0
2021-07-08	AMLP	ETF	35.15	35.84	34.71	35.49	2697900.0
2021-07-08	AMNA	ETF	33.6809	33.6809	33.6809	33.6809	3.0
2021-07-08	AMND	ETF	35.6427	35.6427	35.6427	35.6427	0.0
2021-07-08	AMOM	ETF	36.04	36.49	35.51	36.301	10600.0

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

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