PREVIEW / etf_daily / 2020-07-07

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-07.parquet
  size:    77 KB
  rows:    2,039

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-07	SPY	ETF	315.38	317.52	313.37	313.78	82910000.0
2020-07-07	QQQ	ETF	258.1	260.88	256.3	256.61	36578191.0
2020-07-07	IWM	ETF	142.18	143.44	140.48	140.89	22661000.0
2020-07-07	DIA	ETF	261.1	261.85	258.78	259.04	2828700.0
2020-07-07	GLD	ETF	167.41	169.04	167.38	169.04	11633100.0
2020-07-07	TLT	ETF	163.42	165.34	163.2	165.21	12791900.0
2020-07-07	AAAU	ETF	17.76	17.93	17.76	17.93	326100.0
2020-07-07	AADR	ETF	54.99	55.05	54.71	54.88	4300.0
2020-07-07	AAXJ	ETF	74.11	74.5	73.79	73.84	961800.0
2020-07-07	ABEQ	ETF	22.298	22.33	22.263	22.263	1000.0
2020-07-07	ACES	ETF	41.75	41.95	41.4	41.63	33700.0
2020-07-07	ACIO	ETF	25.47	25.52	25.35	25.35	10100.0
2020-07-07	ACSI	ETF	34.21	34.21	33.9789	33.9789	304.0
2020-07-07	ACTX	ETF	3.009	3.186	2.95	3.1565	608.0
2020-07-07	ACWF	ETF	28.41	28.56	28.29	28.29	5700.0
2020-07-07	ACWI	ETF	75.86	76.32	75.46	75.51	2450200.0
2020-07-07	ACWV	ETF	88.63	89.06	88.47	88.58	320900.0
2020-07-07	ACWX	ETF	44.67	44.87	44.42	44.43	1220561.0
2020-07-07	ADME	ETF	32.865	32.96	32.59	32.59	4800.0
2020-07-07	ADRE	ETF	42.4	42.4999	41.9993	41.9993	2313.0
2020-07-07	AESR	ETF	10.1	10.255	10.08	10.141	7600.0
2020-07-07	AFIF	ETF	9.81	9.8499	9.81	9.8381	21964.0
2020-07-07	AFK	ETF	16.62	16.7535	16.5445	16.65	5338.0
2020-07-07	AFLG	ETF	19.18	19.18	19.027	19.027	400.0
2020-07-07	AFMC	ETF	16.91	16.91	16.781	16.781	100.0
2020-07-07	AFSM	ETF	16.72	16.72	16.563	16.563	100.0
2020-07-07	AFTY	ETF	18.42	19.6	18.42	19.454	20400.0
2020-07-07	AGG	ETF	118.23	118.38	118.06	118.36	5454700.0
2020-07-07	AGGY	ETF	53.94	54.0	53.87	54.0	157700.0
2020-07-07	AGNG	ETF	25.16	25.16	24.76	24.884	1200.0
2020-07-07	AGQ	ETF	28.89	29.78	28.86	29.49	1112400.0
2020-07-07	AGZ	ETF	120.82	121.28	120.68	120.69	44788.0
2020-07-07	AGZD	ETF	23.58	23.665	23.55	23.565	14400.0
2020-07-07	AIA	ETF	68.7	69.025	68.38	68.38	72916.0
2020-07-07	AIEQ	ETF	28.95	29.23	28.898	28.99	16900.0
2020-07-07	AIQ	ETF	21.47	21.67	21.3546	21.39	23260.0
2020-07-07	AIRR	ETF	23.542	23.63	23.178	23.178	6300.0
2020-07-07	AIVI	ETF	35.95	36.11	35.8	35.8	54800.0
2020-07-07	ALTL	ETF	24.11	24.11	23.6688	23.6688	49837.0
2020-07-07	ALTY	ETF	10.65	10.65	10.5	10.515	14300.0
2020-07-07	AMJ	ETF	12.54	13.03	12.5	12.71	1744201.0
2020-07-07	AMLP	ETF	23.31	24.16	23.14	23.66	3635400.0
2020-07-07	AMNA	ETF	23.1	23.62	22.96	23.2004	76200.0
2020-07-07	AMOM	ETF	31.47	31.47	31.416	31.416	700.0
2020-07-07	AMUB	ETF	8.1	8.1	8.01	8.0244	898.0
2020-07-07	AMZA	ETF	16.15	16.925	16.01	16.54	99000.0
2020-07-07	ANGL	ETF	29.02	29.11	28.87	28.89	1837000.0
2020-07-07	AOA	ETF	55.73	55.88	55.34	55.42	81800.0
2020-07-07	AOK	ETF	36.49	36.68	36.49	36.6	146491.0
2020-07-07	AOM	ETF	40.14	40.15	39.96	40.07	272851.0

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

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