PREVIEW / etf_daily / 2021-09-10

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-10.parquet
  size:    92 KB
  rows:    2,455

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-09-10	SPY	ETF	451.04	451.49	445.31	445.44	89948200.0
2021-09-10	QQQ	ETF	381.23	381.97	376.245	376.59	40249405.0
2021-09-10	IWM	ETF	225.16	225.29	221.52	221.62	24366100.0
2021-09-10	DIA	ETF	351.25	351.66	346.57	346.7	4539000.0
2021-09-10	GLD	ETF	167.81	168.08	167.15	167.18	7426300.0
2021-09-10	TLT	ETF	148.9	149.17	148.16	148.4	14894600.0
2021-09-10	AAA	ETF	25.0	25.005	25.0	25.005	219.0
2021-09-10	AAAU	ETF	17.85	17.87	17.78	17.79	86200.0
2021-09-10	AADR	ETF	67.88	67.88	67.15	67.15	2300.0
2021-09-10	AAXJ	ETF	89.92	90.04	89.17	89.17	1596900.0
2021-09-10	ABEQ	ETF	27.99	27.99	27.337	27.337	400.0
2021-09-10	ACES	ETF	70.06	70.25	68.45	68.47	40700.0
2021-09-10	ACIO	ETF	31.067	31.067	30.7	30.7	146600.0
2021-09-10	ACSI	ETF	51.12	51.12	50.6554	50.6554	2319.0
2021-09-10	ACTV	ETF	37.77	37.95	37.6772	37.6772	4883.0
2021-09-10	ACTX	ETF	1.13	1.5	1.04	1.46	14360.0
2021-09-10	ACVF	ETF	33.25	33.4	33.02	33.02	37100.0
2021-09-10	ACWF	ETF	39.27	39.42	38.8425	38.8425	22608.0
2021-09-10	ACWI	ETF	104.87	104.9	103.68	103.68	1700500.0
2021-09-10	ACWV	ETF	107.26	107.38	106.58	106.61	125000.0
2021-09-10	ACWX	ETF	58.1632	58.19	57.62	57.62	1330873.0
2021-09-10	ADFI	ETF	9.77	9.77	9.77	9.77	900.0
2021-09-10	ADIV	ETF	18.024	18.024	18.024	18.024	100.0
2021-09-10	ADME	ETF	41.37	41.37	40.86	40.86	27200.0
2021-09-10	ADRE	ETF	52.74	52.74	52.552	52.552	2528.0
2021-09-10	AESR	ETF	14.214	14.214	14.07	14.07	9400.0
2021-09-10	AFIF	ETF	9.7	9.7	9.69	9.695	13720.0
2021-09-10	AFK	ETF	21.47	21.47	21.36	21.36	4191.0
2021-09-10	AFLG	ETF	26.49	26.49	26.332	26.332	200.0
2021-09-10	AFMC	ETF	25.543	25.543	25.543	25.543	100.0
2021-09-10	AFSM	ETF	26.41	26.48	26.169	26.169	1800.0
2021-09-10	AFTY	ETF	21.02	21.02	20.879	20.879	200.0
2021-09-10	AGG	ETF	115.99	116.01	115.78	115.87	3957300.0
2021-09-10	AGGY	ETF	52.69	52.694	52.561	52.6	77700.0
2021-09-10	AGNG	ETF	30.53	30.53	30.161	30.161	4100.0
2021-09-10	AGOX	ETF	26.4	26.73	26.4	26.46	98100.0
2021-09-10	AGQ	ETF	38.2	38.5	37.16	37.18	678700.0
2021-09-10	AGZ	ETF	119.16	119.16	119.03	119.12	11908.0
2021-09-10	AGZD	ETF	23.43	23.44	23.415	23.44	15400.0
2021-09-10	AIA	ETF	83.81	83.89	82.98	83.06	52798.0
2021-09-10	AIEQ	ETF	43.52	43.52	42.82	42.874	16200.0
2021-09-10	AIQ	ETF	31.96	32.0055	31.6	31.6	9578.0
2021-09-10	AIRR	ETF	41.9	41.9	41.03	41.03	14900.0
2021-09-10	AIVI	ETF	43.5	43.62	43.26	43.26	4600.0
2021-09-10	ALTL	ETF	43.31	43.31	42.98	42.99	25303.0
2021-09-10	ALTY	ETF	13.75	13.75	13.6	13.6	6700.0
2021-09-10	AMJ	ETF	17.98	18.04	17.63	17.65	432155.0
2021-09-10	AMLP	ETF	33.14	33.18	32.43	32.48	1556800.0
2021-09-10	AMNA	ETF	31.8429	31.8429	31.8429	31.8429	0.0
2021-09-10	AMND	ETF	33.3935	33.3935	33.3935	33.3935	4.0

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

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