PREVIEW / etf_daily / 2021-08-17

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-17.parquet
  size:    92 KB
  rows:    2,436

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-08-17	SPY	ETF	444.24	444.96	440.85	444.04	92673900.0
2021-08-17	QQQ	ETF	366.15	367.15	363.23	365.73	44793902.0
2021-08-17	IWM	ETF	216.66	217.44	213.75	216.4	35161500.0
2021-08-17	DIA	ETF	353.91	354.67	351.51	353.83	5019600.0
2021-08-17	GLD	ETF	167.29	167.73	166.56	166.97	7107000.0
2021-08-17	TLT	ETF	148.88	149.47	148.67	148.85	14126900.0
2021-08-17	AAA	ETF	25.0	25.015	25.0	25.015	648.0
2021-08-17	AAAU	ETF	17.8	17.83	17.72	17.76	168400.0
2021-08-17	AADR	ETF	66.43	67.19	66.43	67.19	800.0
2021-08-17	AAXJ	ETF	85.11	85.58	84.8	85.05	2181800.0
2021-08-17	ABEQ	ETF	27.93	27.96	27.847	27.927	6000.0
2021-08-17	ACES	ETF	67.74	67.9	66.5	67.4	73000.0
2021-08-17	ACIO	ETF	30.865	30.89	30.708	30.86	42200.0
2021-08-17	ACSI	ETF	50.87	51.2305	50.87	51.2305	342.0
2021-08-17	ACTV	ETF	38.06	38.1299	37.79	38.1062	18107.0
2021-08-17	ACTX	ETF	1.5	1.5	1.4	1.4	2674.0
2021-08-17	ACVF	ETF	33.05	33.05	32.786	32.969	6700.0
2021-08-17	ACWF	ETF	38.58	38.58	38.1884	38.4242	3896.0
2021-08-17	ACWI	ETF	102.76	102.92	102.05	102.66	3818900.0
2021-08-17	ACWV	ETF	105.86	106.41	105.86	106.39	214500.0
2021-08-17	ACWX	ETF	56.52	56.66	56.25	56.52	1287701.0
2021-08-17	ADFI	ETF	9.71	9.72	9.71	9.72	1200.0
2021-08-17	ADIV	ETF	18.049	18.049	18.015	18.037	400.0
2021-08-17	ADME	ETF	40.7	40.7	40.43	40.64	33200.0
2021-08-17	ADRE	ETF	50.23	50.5758	49.87	50.0222	10535.0
2021-08-17	AEMB	ETF	49.92	49.92	49.92	49.92	100.0
2021-08-17	AESR	ETF	14.01	14.05	13.95	14.036	25800.0
2021-08-17	AFIF	ETF	9.67	9.69	9.67	9.68	59743.0
2021-08-17	AFK	ETF	21.74	21.74	21.45	21.48	9727.0
2021-08-17	AFLG	ETF	26.238	26.329	26.238	26.329	700.0
2021-08-17	AFSM	ETF	25.82	25.82	25.804	25.804	400.0
2021-08-17	AFTY	ETF	20.36	20.379	20.3	20.344	3100.0
2021-08-17	AGG	ETF	115.98	116.09	115.93	115.94	5469200.0
2021-08-17	AGGY	ETF	52.63	52.715	52.63	52.67	55000.0
2021-08-17	AGNG	ETF	30.39	30.7	30.39	30.7	5600.0
2021-08-17	AGOV	ETF	99.85	99.85	99.75	99.77	15203.0
2021-08-17	AGOX	ETF	25.999	26.075	25.76	25.95	662000.0
2021-08-17	AGQ	ETF	37.43	37.84	36.76	37.05	510900.0
2021-08-17	AGZ	ETF	119.11	119.21	119.11	119.16	27478.0
2021-08-17	AGZD	ETF	23.39	23.425	23.39	23.41	15600.0
2021-08-17	AIA	ETF	80.1	80.47	79.68	79.88	116700.0
2021-08-17	AIEQ	ETF	41.37	41.37	40.85	41.17	21200.0
2021-08-17	AIQ	ETF	30.38	30.38	30.0501	30.18	22893.0
2021-08-17	AIRR	ETF	41.61	41.86	40.87	41.29	37600.0
2021-08-17	AIVI	ETF	43.62	43.62	43.32	43.55	23000.0
2021-08-17	ALTL	ETF	43.6	43.75	43.47	43.75	56016.0
2021-08-17	ALTY	ETF	13.72	13.72	13.62	13.63	5800.0
2021-08-17	AMJ	ETF	17.89	18.205	17.7643	17.94	320301.0
2021-08-17	AMLP	ETF	32.54	33.03	32.17	32.43	1432300.0
2021-08-17	AMNA	ETF	31.7112	31.7112	31.7112	31.7112	0.0

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

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