PREVIEW / etf_daily / 2020-09-08

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-08.parquet
  size:    79 KB
  rows:    2,085

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-09-08	SPY	ETF	336.71	342.64	332.88	333.21	114465300.0
2020-09-08	QQQ	ETF	272.27	278.22	269.66	269.95	99568645.0
2020-09-08	IWM	ETF	151.18	152.48	149.0	149.86	26447800.0
2020-09-08	DIA	ETF	278.82	278.83	275.01	275.42	4780100.0
2020-09-08	GLD	ETF	179.5	182.27	179.02	181.29	13229200.0
2020-09-08	TLT	ETF	164.37	165.26	163.74	163.74	13790400.0
2020-09-08	AAAU	ETF	19.04	19.33	19.0	19.25	1423200.0
2020-09-08	AADR	ETF	54.28	54.71	53.23	54.36	4200.0
2020-09-08	AAXJ	ETF	76.1	76.68	75.84	76.0	845800.0
2020-09-08	ABEQ	ETF	23.59	23.83	23.565	23.594	25400.0
2020-09-08	ACES	ETF	48.21	49.72	48.0	48.76	87900.0
2020-09-08	ACIO	ETF	26.38	26.58	26.369	26.369	9900.0
2020-09-08	ACSI	ETF	37.2	37.67	37.1148	37.1148	578.0
2020-09-08	ACTX	ETF	2.242	2.7748	2.242	2.2479	179.0
2020-09-08	ACWF	ETF	29.5	29.62	29.3403	29.3403	1287838.0
2020-09-08	ACWI	ETF	79.64	80.12	79.13	79.15	2485700.0
2020-09-08	ACWV	ETF	91.23	91.75	90.81	91.09	285300.0
2020-09-08	ACWX	ETF	45.88	46.28	45.73	45.88	1251009.0
2020-09-08	ADFI	ETF	10.003	10.003	10.003	10.003	100.0
2020-09-08	ADME	ETF	33.56	33.76	33.41	33.416	33900.0
2020-09-08	ADRE	ETF	45.89	46.475	45.81	45.89	11035.0
2020-09-08	AESR	ETF	10.8	10.85	10.722	10.722	13500.0
2020-09-08	AFIF	ETF	9.82	9.85	9.82	9.835	10587.0
2020-09-08	AFK	ETF	17.41	17.8	17.05	17.4498	15096.0
2020-09-08	AFLG	ETF	19.93	19.93	19.93	19.93	100.0
2020-09-08	AFMC	ETF	17.74	17.74	17.595	17.595	100.0
2020-09-08	AFSM	ETF	17.77	17.77	17.615	17.615	100.0
2020-09-08	AFTY	ETF	19.28	19.28	19.23	19.233	3200.0
2020-09-08	AGG	ETF	118.34	118.46	118.2	118.23	8894000.0
2020-09-08	AGGY	ETF	54.01	54.09	53.99	53.99	172000.0
2020-09-08	AGNG	ETF	24.99	25.22	24.99	25.02	6500.0
2020-09-08	AGQ	ETF	54.45	57.6	52.77	56.2	1749100.0
2020-09-08	AGZ	ETF	121.24	121.26	120.99	121.2	78426.0
2020-09-08	AGZD	ETF	23.55	23.6	23.55	23.565	14400.0
2020-09-08	AIA	ETF	70.99	71.61	70.96	71.06	114804.0
2020-09-08	AIEQ	ETF	29.48	29.8	29.22	29.242	13000.0
2020-09-08	AIQ	ETF	22.64	23.0	22.38	22.59	53660.0
2020-09-08	AIRR	ETF	26.385	26.423	26.15	26.15	5000.0
2020-09-08	AIVI	ETF	36.42	36.65	36.4	36.43	8000.0
2020-09-08	ALTL	ETF	24.835	24.835	24.6	24.6382	1873.0
2020-09-08	ALTY	ETF	10.7	10.73	10.627	10.7	16800.0
2020-09-08	AMJ	ETF	12.01	12.05	11.71	11.89	1019026.0
2020-09-08	AMLP	ETF	22.17	22.2	21.57	21.85	2661700.0
2020-09-08	AMNA	ETF	23.35	23.52	23.19	23.3025	9064.0
2020-09-08	AMND	ETF	24.36	24.4489	24.36	24.4489	1372.0
2020-09-08	AMOM	ETF	34.08	34.23	33.723	33.723	3100.0
2020-09-08	AMUB	ETF	7.47	7.52	7.42	7.44	30152.0
2020-09-08	AMZA	ETF	15.84	15.84	15.24	15.55	98600.0
2020-09-08	ANGL	ETF	30.19	30.24	30.04	30.11	1465200.0
2020-09-08	AOA	ETF	58.1	58.25	57.7	57.7	52000.0

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

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