PREVIEW / etf_daily / 2020-04-01

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-01.parquet
  size:    74 KB
  rows:    1,967

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-04-01	SPY	ETF	247.98	257.66	243.9	246.15	189554600.0
2020-04-01	QQQ	ETF	184.81	187.66	180.86	182.31	53715375.0
2020-04-01	IWM	ETF	108.7	110.38	105.53	106.66	54224200.0
2020-04-01	DIA	ETF	210.65	214.78	207.77	209.38	8570300.0
2020-04-01	GLD	ETF	148.2	150.08	147.85	149.45	11827400.0
2020-04-01	TLT	ETF	168.48	168.96	166.4	167.04	11334700.0
2020-04-01	AAAU	ETF	15.74	16.16	15.68	15.87	296200.0
2020-04-01	AADR	ETF	39.17	39.17	38.6	39.03	5700.0
2020-04-01	AAXJ	ETF	58.04	58.36	57.07	57.07	2005400.0
2020-04-01	ABEQ	ETF	19.64	19.74	19.64	19.705	900.0
2020-04-01	ACES	ETF	27.95	28.34	26.66	26.91	26800.0
2020-04-01	ACIO	ETF	22.21	22.6	22.21	22.48	20400.0
2020-04-01	ACSI	ETF	26.4923	26.4923	26.4923	26.4923	190.0
2020-04-01	ACTX	ETF	6.7851	6.7851	3.0208	4.72	1381.0
2020-04-01	ACWF	ETF	23.15	23.4782	23.0	23.0	10351.0
2020-04-01	ACWI	ETF	60.12	60.92	59.3	59.7	4057600.0
2020-04-01	ACWV	ETF	78.25	78.86	77.41	77.94	990500.0
2020-04-01	ACWX	ETF	36.43	36.7	35.85	35.85	4048665.0
2020-04-01	ADME	ETF	27.48	27.584	27.325	27.447	14100.0
2020-04-01	ADRE	ETF	32.32	32.76	32.15	32.15	3401.0
2020-04-01	AESR	ETF	8.0	8.0	7.83	7.89	27100.0
2020-04-01	AFIF	ETF	9.68	9.7646	9.6	9.7134	7390.0
2020-04-01	AFK	ETF	12.25	12.64	12.005	12.16	16608.0
2020-04-01	AFLG	ETF	15.31	15.31	15.119	15.119	800.0
2020-04-01	AFMC	ETF	13.6	13.6	13.373	13.373	200.0
2020-04-01	AFTY	ETF	14.863	14.9	14.694	14.694	3700.0
2020-04-01	AGG	ETF	115.38	115.4	114.65	114.73	14192100.0
2020-04-01	AGGY	ETF	51.66	51.84	51.47	51.53	267900.0
2020-04-01	AGNG	ETF	19.66	19.66	19.2	19.285	18800.0
2020-04-01	AGQ	ETF	18.13	18.48	17.79	18.07	291100.0
2020-04-01	AGZ	ETF	120.84	120.84	120.3023	120.62	87445.0
2020-04-01	AGZD	ETF	23.23	23.415	22.87	23.23	559800.0
2020-04-01	AIA	ETF	54.61	54.78	53.61	53.64	125073.0
2020-04-01	AIEQ	ETF	21.72	21.96	21.44	21.7	16300.0
2020-04-01	AIQ	ETF	15.13	15.246	14.86	14.86	15040.0
2020-04-01	AIRR	ETF	19.0	19.308	18.735	18.77	27800.0
2020-04-01	AIVI	ETF	30.74	30.97	30.32	30.34	12600.0
2020-04-01	ALTY	ETF	8.6	8.6	8.12	8.122	11500.0
2020-04-01	AMJ	ETF	8.82	8.97	8.4655	8.84	2466250.0
2020-04-01	AMLP	ETF	16.75	17.15	16.05	16.95	6023080.0
2020-04-01	AMUB	ETF	6.13	6.13	5.54	5.5973	26148.0
2020-04-01	AMZA	ETF	10.13	10.75	10.0	10.75	115100.0
2020-04-01	ANGL	ETF	25.05	25.44	24.56	24.93	1367400.0
2020-04-01	AOA	ETF	46.41	46.87	45.75	46.01	223300.0
2020-04-01	AOK	ETF	33.58	33.841	33.43	33.48	274068.0
2020-04-01	AOM	ETF	36.11	36.3537	35.8069	36.07	681140.0
2020-04-01	AOR	ETF	40.56	40.93	40.29	40.45	165143.0
2020-04-01	ARCM	ETF	99.322	99.322	99.22	99.22	200.0
2020-04-01	ARGT	ETF	15.72	15.93	15.31	15.7	28900.0
2020-04-01	ARKF	ETF	19.8	19.8	19.115	19.225	75900.0

> showing 50 of 1,967 rows — these rows as CSV

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