PREVIEW / etf_daily / 2020-07-13

all etf daily files

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

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-13	SPY	ETF	320.13	322.71	314.13	314.84	102997500.0
2020-07-13	QQQ	ETF	266.87	269.79	257.69	258.54	64108090.0
2020-07-13	IWM	ETF	142.8	144.64	139.39	139.52	34235500.0
2020-07-13	DIA	ETF	263.06	266.52	260.58	261.04	4876000.0
2020-07-13	GLD	ETF	170.29	170.42	169.16	169.4	11095900.0
2020-07-13	TLT	ETF	165.5	166.96	165.23	166.88	8054000.0
2020-07-13	AAAU	ETF	18.07	18.08	17.95	17.97	324600.0
2020-07-13	AADR	ETF	56.0	56.43	54.96	54.96	15700.0
2020-07-13	AAXJ	ETF	75.68	76.19	74.62	74.74	1453700.0
2020-07-13	ABEQ	ETF	22.2	22.402	22.2	22.207	6200.0
2020-07-13	ACES	ETF	44.49	44.49	42.1	42.14	46700.0
2020-07-13	ACIO	ETF	25.55	25.63	25.327	25.327	4600.0
2020-07-13	ACSI	ETF	34.087	34.087	34.087	34.087	100.0
2020-07-13	ACTX	ETF	2.8084	3.422	2.36	3.1388	2286.0
2020-07-13	ACWF	ETF	28.67	28.8376	28.27	28.27	16532.0
2020-07-13	ACWI	ETF	76.98	77.51	75.65	75.76	3757400.0
2020-07-13	ACWV	ETF	89.23	89.6	88.24	88.29	360100.0
2020-07-13	ACWX	ETF	45.23	45.41	44.57	44.64	1862407.0
2020-07-13	ADME	ETF	33.22	33.386	32.65	32.65	3600.0
2020-07-13	ADRE	ETF	43.95	44.2022	43.0863	43.0863	8751.0
2020-07-13	AESR	ETF	10.4	10.459	10.165	10.165	1400.0
2020-07-13	AFIF	ETF	9.8021	9.83	9.8	9.815	10731.0
2020-07-13	AFK	ETF	17.28	17.37	16.8747	16.8747	5172.0
2020-07-13	AFLG	ETF	19.079	19.079	19.079	19.079	100.0
2020-07-13	AFMC	ETF	16.73	16.73	16.73	16.73	200.0
2020-07-13	AFSM	ETF	16.49	16.49	16.49	16.49	200.0
2020-07-13	AFTY	ETF	19.49	19.707	19.44	19.45	25200.0
2020-07-13	AGG	ETF	118.46	118.53	118.37	118.48	4803200.0
2020-07-13	AGGY	ETF	54.02	54.1	54.02	54.1	168200.0
2020-07-13	AGNG	ETF	24.99	25.09	24.593	24.593	1500.0
2020-07-13	AGQ	ETF	33.0	33.3	31.99	32.09	1887100.0
2020-07-13	AGZ	ETF	120.87	120.92	120.825	120.84	33474.0
2020-07-13	AGZD	ETF	23.565	23.66	23.56	23.63	8600.0
2020-07-13	AIA	ETF	69.63	70.1346	68.78	68.84	166942.0
2020-07-13	AIEQ	ETF	29.48	29.87	28.81	28.81	25600.0
2020-07-13	AIQ	ETF	22.25	22.41	21.46	21.46	31219.0
2020-07-13	AIRR	ETF	23.11	23.452	22.89	23.043	3400.0
2020-07-13	AIVI	ETF	36.05	36.23	35.65	35.65	3500.0
2020-07-13	ALTL	ETF	24.27	24.27	23.8155	23.8155	19216.0
2020-07-13	ALTY	ETF	10.37	10.506	10.37	10.415	7400.0
2020-07-13	AMJ	ETF	12.67	12.67	12.11	12.2	1133846.0
2020-07-13	AMLP	ETF	23.22	23.34	22.45	22.7	4224800.0
2020-07-13	AMNA	ETF	22.6187	22.6187	22.6187	22.6187	0.0
2020-07-13	AMOM	ETF	33.085	33.085	31.0	31.009	1300.0
2020-07-13	AMUB	ETF	7.64	7.7843	7.64	7.6831	13410.0
2020-07-13	AMZA	ETF	16.05	16.1	15.375	15.5	58000.0
2020-07-13	ANGL	ETF	28.96	29.12	28.77	28.84	801400.0
2020-07-13	AOA	ETF	56.09	56.53	55.44	55.55	67100.0
2020-07-13	AOK	ETF	36.63	36.87	36.51	36.5255	113817.0
2020-07-13	AOM	ETF	40.37	40.46	40.0	40.0	147467.0

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

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