PREVIEW / etf_daily / 2021-09-02

all etf daily files

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

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-02	SPY	ETF	453.32	454.05	451.91	453.19	42501000.0
2021-09-02	QQQ	ETF	381.97	382.31	379.15	380.4	25503535.0
2021-09-02	IWM	ETF	228.33	229.84	227.6	229.02	22810100.0
2021-09-02	DIA	ETF	354.78	355.18	353.92	354.87	2390000.0
2021-09-02	GLD	ETF	169.5	169.63	168.82	169.25	4599800.0
2021-09-02	TLT	ETF	149.24	149.55	148.75	149.54	9765900.0
2021-09-02	AAA	ETF	25.01	25.01	25.0001	25.0001	225.0
2021-09-02	AAAU	ETF	18.03	18.04	17.96	18.01	136600.0
2021-09-02	AADR	ETF	68.54	68.99	68.49	68.49	1200.0
2021-09-02	AAXJ	ETF	89.76	90.05	89.52	89.62	794300.0
2021-09-02	ABEQ	ETF	27.93	27.95	27.891	27.916	2700.0
2021-09-02	ACES	ETF	71.75	72.44	71.467	71.68	30800.0
2021-09-02	ACIO	ETF	31.1	31.271	31.1	31.23	320600.0
2021-09-02	ACSI	ETF	51.8	51.801	51.6603	51.6603	3211.0
2021-09-02	ACTV	ETF	38.7	39.038	38.7	38.91	837.0
2021-09-02	ACTX	ETF	1.09	1.15	1.09	1.15	4310.0
2021-09-02	ACVF	ETF	33.49	33.6	33.49	33.549	13500.0
2021-09-02	ACWF	ETF	39.22	39.26	39.151	39.2395	37407.0
2021-09-02	ACWI	ETF	105.15	105.26	104.86	105.05	1206700.0
2021-09-02	ACWV	ETF	107.43	107.76	107.42	107.68	710400.0
2021-09-02	ACWX	ETF	58.12	58.225	58.025	58.11	776145.0
2021-09-02	ADFI	ETF	9.78	9.8	9.78	9.782	2100.0
2021-09-02	ADME	ETF	41.538	41.59	41.44	41.54	15300.0
2021-09-02	ADRE	ETF	53.21	53.33	52.74	52.74	8546.0
2021-09-02	AEMB	ETF	50.238	50.238	50.238	50.238	100.0
2021-09-02	AESR	ETF	14.35	14.379	14.3	14.329	7600.0
2021-09-02	AFIF	ETF	9.705	9.74	9.7	9.71	21061.0
2021-09-02	AFK	ETF	22.11	22.19	21.83	21.83	6272.0
2021-09-02	AFLG	ETF	26.834	26.886	26.834	26.886	1300.0
2021-09-02	AFMC	ETF	26.295	26.295	26.295	26.295	300.0
2021-09-02	AFSM	ETF	27.025	27.04	26.956	26.956	700.0
2021-09-02	AFTY	ETF	20.29	20.29	20.19	20.23	1300.0
2021-09-02	AGG	ETF	116.02	116.06	115.92	116.05	5427300.0
2021-09-02	AGGY	ETF	52.63	52.69	52.6	52.681	94400.0
2021-09-02	AGNG	ETF	34.29	34.29	31.018	31.228	5900.0
2021-09-02	AGOX	ETF	26.77	26.94	26.77	26.87	41500.0
2021-09-02	AGQ	ETF	38.16	38.19	37.34	37.75	569600.0
2021-09-02	AGZ	ETF	119.15	119.22	119.15	119.1917	13557.0
2021-09-02	AGZD	ETF	23.39	23.435	23.39	23.425	99000.0
2021-09-02	AIA	ETF	84.5	84.54	83.8611	83.92	54705.0
2021-09-02	AIEQ	ETF	43.59	43.71	43.485	43.517	39100.0
2021-09-02	AIQ	ETF	32.11	32.2842	31.94	31.94	26195.0
2021-09-02	AIRR	ETF	42.59	42.987	42.54	42.987	25800.0
2021-09-02	AIVI	ETF	43.71	43.81	43.7	43.7	3200.0
2021-09-02	ALTL	ETF	43.73	43.81	43.635	43.81	22736.0
2021-09-02	ALTY	ETF	13.87	13.9	13.844	13.9	11800.0
2021-09-02	AMJ	ETF	17.93	18.295	17.93	18.24	205880.0
2021-09-02	AMLP	ETF	32.9	33.67	32.9	33.55	2575100.0
2021-09-02	AMNA	ETF	32.42	32.4572	32.42	32.4572	250.0
2021-09-02	AMND	ETF	34.1315	34.1315	34.1315	34.1315	2.0

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

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