PREVIEW / etf_daily / 2020-07-10

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-10.parquet
  size:    76 KB
  rows:    2,028

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
2020-07-10	SPY	ETF	314.31	317.88	312.76	317.59	57550400.0
2020-07-10	QQQ	ETF	262.0	264.23	259.26	263.97	32885298.0
2020-07-10	IWM	ETF	139.14	141.5	138.46	141.31	24008200.0
2020-07-10	DIA	ETF	257.2	261.16	256.46	260.82	3110100.0
2020-07-10	GLD	ETF	169.95	170.15	168.57	169.19	8218000.0
2020-07-10	TLT	ETF	167.95	168.21	166.16	166.33	8478000.0
2020-07-10	AAAU	ETF	18.04	18.06	17.89	17.95	350900.0
2020-07-10	AADR	ETF	56.0	56.0	55.31	55.44	4100.0
2020-07-10	AAXJ	ETF	75.25	75.3	74.65	75.09	2988000.0
2020-07-10	ABEQ	ETF	22.1	22.167	22.065	22.167	5500.0
2020-07-10	ACES	ETF	42.5	42.91	42.285	42.82	24100.0
2020-07-10	ACIO	ETF	25.29	25.435	25.29	25.404	5200.0
2020-07-10	ACSI	ETF	34.4764	34.4764	34.4764	34.4764	100.0
2020-07-10	ACTX	ETF	2.8792	3.422	2.8084	3.1329	264.0
2020-07-10	ACWF	ETF	28.29	28.4635	28.21	28.4635	1289.0
2020-07-10	ACWI	ETF	75.86	76.47	75.5	76.43	4924700.0
2020-07-10	ACWV	ETF	88.48	88.83	88.16	88.78	230700.0
2020-07-10	ACWX	ETF	44.74	44.93	44.52	44.93	1622303.0
2020-07-10	ADME	ETF	32.84	33.011	32.84	33.011	2000.0
2020-07-10	ADRE	ETF	43.69	43.69	43.32	43.6596	2914.0
2020-07-10	AESR	ETF	10.24	10.288	10.21	10.288	19100.0
2020-07-10	AFIF	ETF	9.85	9.85	9.8	9.815	8678.0
2020-07-10	AFK	ETF	17.15	17.15	16.7621	16.91	5417.0
2020-07-10	AFLG	ETF	19.226	19.226	19.226	19.226	100.0
2020-07-10	AFMC	ETF	16.861	16.861	16.861	16.861	100.0
2020-07-10	AFSM	ETF	16.708	16.708	16.708	16.708	100.0
2020-07-10	AFTY	ETF	19.31	19.33	19.17	19.315	22900.0
2020-07-10	AGG	ETF	118.83	118.83	118.45	118.49	3133900.0
2020-07-10	AGGY	ETF	54.27	54.27	54.06	54.06	76400.0
2020-07-10	AGNG	ETF	24.75	24.91	24.61	24.813	1900.0
2020-07-10	AGQ	ETF	31.12	31.28	30.51	30.97	955900.0
2020-07-10	AGZ	ETF	121.13	121.13	120.88	120.88	26568.0
2020-07-10	AGZD	ETF	23.675	23.675	23.61	23.615	4400.0
2020-07-10	AIA	ETF	69.6	69.6	69.09	69.34	48137.0
2020-07-10	AIEQ	ETF	29.29	29.38	29.12	29.36	10400.0
2020-07-10	AIQ	ETF	22.13	22.19	21.94	22.0962	9748.0
2020-07-10	AIRR	ETF	22.37	22.904	22.37	22.904	10600.0
2020-07-10	AIVI	ETF	35.64	35.91	35.58	35.91	6300.0
2020-07-10	ALTL	ETF	23.34	23.8751	23.34	23.8751	24271.0
2020-07-10	ALTY	ETF	10.25	10.39	10.25	10.36	9100.0
2020-07-10	AMJ	ETF	12.2	12.49	12.12	12.49	1074840.0
2020-07-10	AMLP	ETF	22.66	23.19	22.46	23.15	2908500.0
2020-07-10	AMNA	ETF	22.7183	22.7183	22.7183	22.7183	0.0
2020-07-10	AMOM	ETF	31.902	32.265	31.902	32.265	400.0
2020-07-10	AMUB	ETF	7.6467	7.8382	7.64	7.8382	50170.0
2020-07-10	AMZA	ETF	15.47	15.97	15.32	15.97	77400.0
2020-07-10	ANGL	ETF	28.91	29.01	28.77	28.96	481400.0
2020-07-10	AOA	ETF	55.54	55.93	55.38	55.93	72700.0
2020-07-10	AOK	ETF	36.62	36.73	36.505	36.73	100110.0
2020-07-10	AOM	ETF	40.18	40.26	39.97	40.26	79381.0

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

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