PREVIEW / etf_daily / 2021-10-08

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-08.parquet
  size:    94 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-08	SPY	ETF	439.48	439.89	437.19	437.86	74557400.0
2021-10-08	QQQ	ETF	364.08	364.3166	360.61	361.16	41822309.0
2021-10-08	IWM	ETF	223.39	224.11	221.5	221.58	17989600.0
2021-10-08	DIA	ETF	347.92	348.46	346.58	347.53	3658300.0
2021-10-08	GLD	ETF	166.32	166.42	164.14	164.23	8536100.0
2021-10-08	TLT	ETF	142.26	142.35	141.53	141.88	17257800.0
2021-10-08	AAA	ETF	25.0	25.0	25.0	25.0	4502.0
2021-10-08	AAAU	ETF	17.69	17.7	17.47	17.48	207800.0
2021-10-08	AADR	ETF	63.53	63.53	63.26	63.53	2900.0
2021-10-08	AAXJ	ETF	85.54	85.75	85.32	85.64	514000.0
2021-10-08	ABEQ	ETF	27.45	27.48	27.37	27.43	22600.0
2021-10-08	ACES	ETF	66.3	66.52	65.525	65.72	332300.0
2021-10-08	ACIO	ETF	30.487	30.487	30.345	30.41	13000.0
2021-10-08	ACSI	ETF	50.34	50.34	50.2071	50.2071	730.0
2021-10-08	ACT	ETF	21.05	21.44	20.82	20.91	67464.0
2021-10-08	ACTV	ETF	38.85	39.16	38.85	38.985	14094.0
2021-10-08	ACTX	ETF	1.02	1.02	1.02	1.02	308.0
2021-10-08	ACVF	ETF	32.89	32.89	32.578	32.67	7700.0
2021-10-08	ACWF	ETF	37.28	37.28	37.04	37.04	19764.0
2021-10-08	ACWI	ETF	101.81	101.83	101.29	101.45	2709600.0
2021-10-08	ACWV	ETF	103.64	103.74	103.26	103.26	126400.0
2021-10-08	ACWX	ETF	55.85	55.85	55.63	55.71	1095536.0
2021-10-08	ADFI	ETF	9.622	9.65	9.622	9.635	5200.0
2021-10-08	ADIV	ETF	17.0	17.044	16.97	17.044	5800.0
2021-10-08	ADME	ETF	40.19	40.19	40.04	40.04	12100.0
2021-10-08	ADRE	ETF	49.47	49.47	49.24	49.3892	35283.0
2021-10-08	AEMB	ETF	48.669	48.669	48.669	48.669	100.0
2021-10-08	AESR	ETF	13.9	13.95	13.86	13.86	16500.0
2021-10-08	AFIF	ETF	9.63	9.63	9.6	9.61	9026.0
2021-10-08	AFK	ETF	21.28	21.28	21.08	21.19	6417.0
2021-10-08	AFLG	ETF	25.706	25.706	25.706	25.706	100.0
2021-10-08	AFMC	ETF	25.37	25.37	25.325	25.325	1200.0
2021-10-08	AFTY	ETF	21.17	21.2	21.08	21.17	7900.0
2021-10-08	AGG	ETF	114.31	114.35	114.07	114.13	4581900.0
2021-10-08	AGGY	ETF	51.72	51.73	51.64	51.655	147000.0
2021-10-08	AGNG	ETF	29.09	29.33	28.809	28.809	6500.0
2021-10-08	AGOV	ETF	99.2299	99.2299	99.025	99.025	181.0
2021-10-08	AGOX	ETF	26.39	26.39	26.08	26.08	27300.0
2021-10-08	AGQ	ETF	34.86	34.99	33.4	33.47	1232900.0
2021-10-08	AGZ	ETF	118.27	118.27	118.1001	118.18	21781.0
2021-10-08	AGZD	ETF	23.43	23.435	23.415	23.425	7000.0
2021-10-08	AIA	ETF	78.99	79.49	78.85	79.22	38973.0
2021-10-08	AIEQ	ETF	42.15	42.34	41.9	41.939	5900.0
2021-10-08	AIQ	ETF	30.74	30.78	30.53	30.58	13561.0
2021-10-08	AIRR	ETF	42.17	42.17	41.78	41.9	33100.0
2021-10-08	AIVI	ETF	41.03	41.03	40.95	41.0	2100.0
2021-10-08	ALTL	ETF	41.6	41.8	41.43	41.5	38175.0
2021-10-08	ALTY	ETF	13.31	13.37	13.31	13.32	6200.0
2021-10-08	AMJ	ETF	18.78	19.05	18.76	19.01	444898.0
2021-10-08	AMLP	ETF	34.6	35.09	34.53	35.04	1905400.0

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

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