PREVIEW / etf_daily / 2021-10-13

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-13.parquet
  size:    95 KB
  rows:    2,525

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-10-13	SPY	ETF	434.71	436.05	431.54	435.18	72974000.0
2021-10-13	QQQ	ETF	359.51	360.69	357.43	360.0	40120795.0
2021-10-13	IWM	ETF	221.89	222.7	219.83	222.57	19676200.0
2021-10-13	DIA	ETF	343.95	344.56	341.12	343.89	4189100.0
2021-10-13	GLD	ETF	165.28	167.92	165.28	167.59	11113800.0
2021-10-13	TLT	ETF	144.61	145.53	144.58	145.34	23584600.0
2021-10-13	AAA	ETF	25.0098	25.0098	25.0	25.0	103.0
2021-10-13	AAAU	ETF	17.57	17.85	17.57	17.82	130300.0
2021-10-13	AADR	ETF	64.58	64.67	64.58	64.67	800.0
2021-10-13	AAXJ	ETF	85.63	86.33	85.56	86.14	1056200.0
2021-10-13	ABEQ	ETF	27.29	27.36	27.276	27.36	4800.0
2021-10-13	ACES	ETF	69.99	71.35	69.915	71.23	200800.0
2021-10-13	ACIO	ETF	30.15	30.26	30.121	30.25	15100.0
2021-10-13	ACSI	ETF	49.8539	49.8539	49.8539	49.8539	129.0
2021-10-13	ACT	ETF	20.4	21.03	20.21	20.75	644761.0
2021-10-13	ACTV	ETF	38.86	38.86	38.48	38.58	11783.0
2021-10-13	ACTX	ETF	1.0	1.0	0.9	0.9	2310.0
2021-10-13	ACVF	ETF	32.56	32.56	32.25	32.52	12000.0
2021-10-13	ACWF	ETF	36.95	37.12	36.95	37.025	296994.0
2021-10-13	ACWI	ETF	101.16	101.61	100.66	101.48	3185600.0
2021-10-13	ACWV	ETF	103.25	103.57	102.86	103.5	71800.0
2021-10-13	ACWX	ETF	55.86	56.23	55.75	56.16	1078004.0
2021-10-13	ADFI	ETF	9.65	9.67	9.63	9.657	10700.0
2021-10-13	ADIV	ETF	17.031	17.122	17.03	17.122	1200.0
2021-10-13	ADME	ETF	39.7	39.845	39.64	39.841	11700.0
2021-10-13	ADRE	ETF	49.64	50.0	49.64	50.0	6059.0
2021-10-13	AEMB	ETF	48.86	48.928	48.86	48.928	51400.0
2021-10-13	AESR	ETF	13.72	13.8	13.7	13.79	12100.0
2021-10-13	AFIF	ETF	9.63	9.65	9.62	9.6403	96899.0
2021-10-13	AFK	ETF	21.49	21.5	21.37	21.46	8818.0
2021-10-13	AFLG	ETF	25.58	25.629	25.58	25.629	900.0
2021-10-13	AFSM	ETF	26.357	26.357	26.357	26.357	100.0
2021-10-13	AFTY	ETF	21.62	21.735	21.51	21.695	3400.0
2021-10-13	AGG	ETF	114.43	114.64	114.42	114.63	5522700.0
2021-10-13	AGGY	ETF	51.76	51.96	51.76	51.94	179600.0
2021-10-13	AGNG	ETF	28.88	28.93	28.8	28.855	4500.0
2021-10-13	AGOV	ETF	98.965	98.965	98.965	98.965	6.0
2021-10-13	AGOX	ETF	26.045	26.14	25.92	26.08	21400.0
2021-10-13	AGQ	ETF	33.88	35.29	33.88	34.62	1224400.0
2021-10-13	AGZ	ETF	118.13	118.23	118.13	118.23	13009.0
2021-10-13	AGZD	ETF	23.43	23.44	23.42	23.435	41200.0
2021-10-13	AIA	ETF	78.8	79.59	78.8	79.48	62058.0
2021-10-13	AIEQ	ETF	41.95	42.16	41.908	42.107	14400.0
2021-10-13	AIQ	ETF	30.55	30.86	30.55	30.76	15705.0
2021-10-13	AIRR	ETF	41.728	41.728	41.14	41.42	47900.0
2021-10-13	AIVI	ETF	41.05	41.27	41.05	41.26	1200.0
2021-10-13	ALTL	ETF	41.47	41.5	41.0597	41.39	182219.0
2021-10-13	ALTY	ETF	13.32	13.43	13.32	13.411	16100.0
2021-10-13	AMJ	ETF	19.3	19.45	19.03	19.44	817575.0
2021-10-13	AMLP	ETF	35.33	35.83	34.99	35.8	1367700.0

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

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