PREVIEW / etf_daily / 2020-07-15

all etf daily files

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

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-15	SPY	ETF	322.41	323.04	319.27	321.85	87196500.0
2020-07-15	QQQ	ETF	261.68	262.69	257.49	260.9	54523869.0
2020-07-15	IWM	ETF	145.42	147.78	144.79	147.03	40770100.0
2020-07-15	DIA	ETF	270.47	270.54	267.05	268.91	5220600.0
2020-07-15	GLD	ETF	169.62	170.43	169.39	170.34	7533800.0
2020-07-15	TLT	ETF	165.92	166.95	165.83	166.34	7840300.0
2020-07-15	AAAU	ETF	18.0	18.08	17.97	18.07	152200.0
2020-07-15	AADR	ETF	56.13	56.51	56.04	56.25	4100.0
2020-07-15	AAXJ	ETF	75.01	75.16	74.53	74.83	604400.0
2020-07-15	ABEQ	ETF	22.77	22.77	22.71	22.77	4200.0
2020-07-15	ACES	ETF	45.34	45.45	44.585	45.45	83900.0
2020-07-15	ACIO	ETF	25.68	25.75	25.66	25.72	22400.0
2020-07-15	ACSI	ETF	35.1682	35.1682	35.1682	35.1682	189.0
2020-07-15	ACTX	ETF	2.891	3.1506	2.891	3.1506	105.0
2020-07-15	ACWF	ETF	28.9	29.07	28.8601	28.99	9304.0
2020-07-15	ACWI	ETF	77.61	77.78	76.95	77.46	4154700.0
2020-07-15	ACWV	ETF	90.06	90.38	89.74	89.92	334400.0
2020-07-15	ACWX	ETF	45.71	45.81	45.39	45.56	1422350.0
2020-07-15	ADME	ETF	33.247	33.247	32.991	33.087	22300.0
2020-07-15	ADRE	ETF	43.84	43.84	43.39	43.545	6647.0
2020-07-15	AESR	ETF	10.51	10.51	10.32	10.367	153200.0
2020-07-15	AFIF	ETF	9.97	9.97	9.81	9.83	15258.0
2020-07-15	AFK	ETF	17.19	17.34	17.17	17.195	6171.0
2020-07-15	AFMC	ETF	17.472	17.472	17.472	17.472	100.0
2020-07-15	AFSM	ETF	17.337	17.337	17.337	17.337	100.0
2020-07-15	AFTY	ETF	19.24	19.371	19.24	19.312	2600.0
2020-07-15	AGG	ETF	118.5	118.7	118.5	118.68	3403600.0
2020-07-15	AGGY	ETF	54.15	54.19	54.08	54.19	101100.0
2020-07-15	AGNG	ETF	25.22	25.37	25.22	25.37	1900.0
2020-07-15	AGQ	ETF	32.64	33.38	32.36	33.38	1093500.0
2020-07-15	AGZ	ETF	120.9	120.95	120.86	120.89	32218.0
2020-07-15	AGZD	ETF	23.655	23.675	23.58	23.63	5000.0
2020-07-15	AIA	ETF	69.65	69.78	69.18	69.48	32013.0
2020-07-15	AIEQ	ETF	29.31	29.626	29.31	29.4	12900.0
2020-07-15	AIQ	ETF	21.67	21.79	21.44	21.645	12843.0
2020-07-15	AIRR	ETF	24.11	24.49	24.05	24.448	36400.0
2020-07-15	AIVI	ETF	36.68	36.9	36.6	36.71	9700.0
2020-07-15	ALTL	ETF	24.7297	25.1848	24.72	25.1848	10103.0
2020-07-15	ALTY	ETF	10.55	10.68	10.55	10.635	6500.0
2020-07-15	AMJ	ETF	12.31	12.88	12.31	12.8	716149.0
2020-07-15	AMLP	ETF	23.07	23.89	22.97	23.79	3401500.0
2020-07-15	AMNA	ETF	23.54	23.9089	23.54	23.9089	200.0
2020-07-15	AMOM	ETF	32.75	32.75	31.415	31.763	1700.0
2020-07-15	AMUB	ETF	7.98	8.0946	7.94	8.0946	4196.0
2020-07-15	AMZA	ETF	16.0	16.939	15.96	16.87	58500.0
2020-07-15	ANGL	ETF	29.19	29.4	29.12	29.37	1923900.0
2020-07-15	AOA	ETF	56.42	56.76	56.31	56.67	75300.0
2020-07-15	AOK	ETF	36.88	36.93	36.812	36.88	132110.0
2020-07-15	AOM	ETF	40.49	40.6	40.4373	40.55	125430.0
2020-07-15	AOR	ETF	47.56	47.577	47.3	47.5	78155.0

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

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