PREVIEW / etf_daily / 2020-10-01

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-01.parquet
  size:    80 KB
  rows:    2,103

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-10-01	SPY	ETF	337.69	338.74	335.01	337.04	88698700.0
2020-10-01	QQQ	ETF	281.79	282.8794	279.84	282.25	50020223.0
2020-10-01	IWM	ETF	150.81	152.2	149.49	152.18	25872000.0
2020-10-01	DIA	ETF	279.33	280.35	276.57	278.14	2968000.0
2020-10-01	GLD	ETF	178.71	179.5	178.04	178.7	10402800.0
2020-10-01	TLT	ETF	162.51	163.74	162.1	163.36	11523900.0
2020-10-01	AAA	ETF	24.93	24.93	24.9175	24.92	24857.0
2020-10-01	AAAU	ETF	18.97	19.05	18.89	18.97	479300.0
2020-10-01	AADR	ETF	56.13	56.34	55.89	56.16	6100.0
2020-10-01	AAXJ	ETF	77.94	78.16	77.49	78.05	1320000.0
2020-10-01	ABEQ	ETF	23.36	23.48	23.311	23.48	18600.0
2020-10-01	ACES	ETF	56.32	57.01	56.044	56.937	66000.0
2020-10-01	ACIO	ETF	26.74	26.75	26.646	26.667	170600.0
2020-10-01	ACSI	ETF	37.8999	37.9674	37.8999	37.9674	219.0
2020-10-01	ACTX	ETF	1.77	2.3718	1.77	1.77	200.0
2020-10-01	ACWF	ETF	29.82	29.8682	29.73	29.852	4888.0
2020-10-01	ACWI	ETF	80.53	80.66	80.07	80.52	3440100.0
2020-10-01	ACWV	ETF	92.18	92.51	91.91	92.41	329500.0
2020-10-01	ACWX	ETF	46.32	46.37	46.07	46.37	977997.0
2020-10-01	ADFI	ETF	9.96	9.975	9.95	9.975	18900.0
2020-10-01	ADME	ETF	33.68	33.84	33.68	33.782	112800.0
2020-10-01	ADRE	ETF	47.014	47.105	46.9672	47.065	2215.0
2020-10-01	AESR	ETF	10.99	11.01	10.86	10.999	22200.0
2020-10-01	AFIF	ETF	9.8173	9.83	9.8069	9.825	6937.0
2020-10-01	AFK	ETF	17.7	17.7	17.465	17.4699	1773.0
2020-10-01	AFLG	ETF	20.25	20.282	20.25	20.282	3100.0
2020-10-01	AFMC	ETF	17.892	17.892	17.892	17.892	100.0
2020-10-01	AFSM	ETF	18.23	18.23	18.23	18.23	200.0
2020-10-01	AFTY	ETF	19.55	19.65	19.55	19.646	800.0
2020-10-01	AGG	ETF	117.81	118.04	117.75	118.02	9741800.0
2020-10-01	AGGY	ETF	53.75	53.87	53.696	53.77	169000.0
2020-10-01	AGNG	ETF	25.76	25.845	25.675	25.748	1900.0
2020-10-01	AGQ	ETF	43.25	45.19	42.3	43.57	2353700.0
2020-10-01	AGZ	ETF	121.07	121.465	120.9499	121.14	102728.0
2020-10-01	AGZD	ETF	23.405	23.485	23.38	23.44	83800.0
2020-10-01	AIA	ETF	72.51	72.75	72.1	72.68	132186.0
2020-10-01	AIEQ	ETF	30.75	31.155	30.7	31.101	21400.0
2020-10-01	AIQ	ETF	23.75	23.86	23.64	23.8066	26663.0
2020-10-01	AIRR	ETF	25.9	25.9	25.55	25.88	7000.0
2020-10-01	AIVI	ETF	35.97	35.97	35.83	35.96	58900.0
2020-10-01	ALTL	ETF	25.1	25.135	24.975	25.0397	3166.0
2020-10-01	ALTY	ETF	10.59	10.632	10.52	10.632	6800.0
2020-10-01	AMJ	ETF	10.86	10.87	10.53	10.68	854608.0
2020-10-01	AMLP	ETF	19.97	20.11	19.47	19.83	2645400.0
2020-10-01	AMNA	ETF	21.4308	21.4308	21.4308	21.4308	0.0
2020-10-01	AMND	ETF	22.5	22.5	22.4678	22.4678	20900.0
2020-10-01	AMOM	ETF	36.0	36.149	36.0	36.044	1700.0
2020-10-01	AMUB	ETF	6.7	6.76	6.68	6.73	9351.0
2020-10-01	AMZA	ETF	13.45	13.53	12.945	13.2	92300.0
2020-10-01	ANGL	ETF	29.72	29.74	29.63	29.72	2058600.0

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

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