PREVIEW / etf_daily / 2020-07-02

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-02.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-02	SPY	ETF	314.24	315.7	311.51	312.23	69344200.0
2020-07-02	QQQ	ETF	252.97	254.27	251.71	252.19	31956497.0
2020-07-02	IWM	ETF	144.56	145.28	141.89	142.4	24022400.0
2020-07-02	DIA	ETF	261.15	262.17	257.88	258.42	3830000.0
2020-07-02	GLD	ETF	166.2	167.24	166.02	166.98	8753500.0
2020-07-02	TLT	ETF	162.7	163.74	162.24	163.59	7599800.0
2020-07-02	AAAU	ETF	17.64	17.74	17.62	17.71	257500.0
2020-07-02	AADR	ETF	54.2	54.2	54.09	54.09	900.0
2020-07-02	AAXJ	ETF	71.45	71.96	71.38	71.71	1491300.0
2020-07-02	ABEQ	ETF	22.45	22.52	22.3	22.322	6800.0
2020-07-02	ACES	ETF	40.68	40.68	39.83	40.053	49800.0
2020-07-02	ACIO	ETF	25.42	25.44	25.31	25.31	69300.0
2020-07-02	ACSI	ETF	33.8499	33.8499	33.8499	33.8499	116.0
2020-07-02	ACTX	ETF	3.422	3.54	3.304	3.304	683.0
2020-07-02	ACWF	ETF	28.16	28.25	28.0552	28.0552	19985.0
2020-07-02	ACWI	ETF	75.26	75.63	74.82	74.96	1674500.0
2020-07-02	ACWV	ETF	88.78	89.0	88.25	88.5	159600.0
2020-07-02	ACWX	ETF	44.19	44.425	44.0	44.1	1247471.0
2020-07-02	ADME	ETF	32.56	32.62	32.407	32.43	78300.0
2020-07-02	ADRE	ETF	40.63	41.0325	40.63	40.8521	2881.0
2020-07-02	AESR	ETF	10.085	10.11	10.044	10.044	1600.0
2020-07-02	AFIF	ETF	9.825	9.83	9.82	9.83	14469.0
2020-07-02	AFK	ETF	16.61	16.71	16.5316	16.55	7589.0
2020-07-02	AFLG	ETF	19.055	19.055	18.935	18.935	300.0
2020-07-02	AFMC	ETF	16.88	16.88	16.88	16.88	200.0
2020-07-02	AFSM	ETF	16.72	16.72	16.72	16.72	100.0
2020-07-02	AFTY	ETF	17.76	17.76	17.52	17.69	16900.0
2020-07-02	AGG	ETF	118.05	118.21	117.99	118.19	3614300.0
2020-07-02	AGGY	ETF	53.81	53.92	53.74	53.92	141300.0
2020-07-02	AGQ	ETF	28.05	28.81	27.97	28.4	964600.0
2020-07-02	AGZ	ETF	120.86	120.94	120.55	120.94	87572.0
2020-07-02	AGZD	ETF	23.74	23.74	23.505	23.56	42200.0
2020-07-02	AIA	ETF	67.0	67.34	66.77	67.09	69321.0
2020-07-02	AIEQ	ETF	28.71	28.84	28.461	28.48	31600.0
2020-07-02	AIQ	ETF	21.14	21.23	21.01	21.0545	22478.0
2020-07-02	AIRR	ETF	24.33	24.41	23.84	23.86	17200.0
2020-07-02	AIVI	ETF	35.99	36.02	35.88	35.88	6400.0
2020-07-02	ALTL	ETF	24.67	24.67	24.0162	24.0162	1048098.0
2020-07-02	ALTY	ETF	10.94	10.98	10.83	10.83	60100.0
2020-07-02	AMJ	ETF	13.38	13.38	13.02	13.03	965150.0
2020-07-02	AMLP	ETF	24.65	24.76	24.14	24.19	4895800.0
2020-07-02	AMNA	ETF	24.01	24.03	23.75	23.7885	6100.0
2020-07-02	AMOM	ETF	30.533	30.533	30.533	30.533	100.0
2020-07-02	AMUB	ETF	8.28	8.3	8.2142	8.2142	9168.0
2020-07-02	AMZA	ETF	17.55	17.55	16.85	16.97	44900.0
2020-07-02	ANGL	ETF	28.88	28.9	28.73	28.78	866100.0
2020-07-02	AOA	ETF	55.29	55.53	55.01	55.09	58500.0
2020-07-02	AOK	ETF	36.39	36.5599	36.35	36.38	126758.0
2020-07-02	AOM	ETF	39.95	40.07	39.821	39.91	123801.0
2020-07-02	AOR	ETF	46.57	46.78	46.39	46.5	292277.0

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

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