PREVIEW / etf_daily / 2020-03-31

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-31.parquet
  size:    75 KB
  rows:    1,961

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-03-31	SPY	ETF	260.56	263.33	256.22	257.75	194881100.0
2020-03-31	QQQ	ETF	191.53	195.25	189.2	190.4	62659265.0
2020-03-31	IWM	ETF	114.6	116.17	111.96	114.46	52948000.0
2020-03-31	DIA	ETF	221.95	224.75	218.44	219.23	8426600.0
2020-03-31	GLD	ETF	151.36	151.8	147.97	148.05	13319500.0
2020-03-31	TLT	ETF	165.7	166.92	164.56	164.97	11464800.0
2020-03-31	AAAU	ETF	16.0	16.09	15.71	15.72	193700.0
2020-03-31	AADR	ETF	40.5	41.23	40.25	40.34	4500.0
2020-03-31	AAXJ	ETF	59.51	60.31	59.35	59.72	1123500.0
2020-03-31	ABEQ	ETF	20.4	20.47	20.202	20.214	118000.0
2020-03-31	ACES	ETF	28.67	29.415	28.47	28.71	36000.0
2020-03-31	ACIO	ETF	22.73	24.01	22.617	24.01	46100.0
2020-03-31	ACSI	ETF	28.46	28.46	28.0	28.0	2053.0
2020-03-31	ACTX	ETF	4.1949	6.4901	4.1949	6.4901	145.0
2020-03-31	ACWF	ETF	24.22	24.4699	23.93	23.95	45082.0
2020-03-31	ACWI	ETF	62.61	63.39	61.89	62.57	9648300.0
2020-03-31	ACWV	ETF	81.43	81.73	80.26	80.34	359400.0
2020-03-31	ACWX	ETF	37.3	37.92	37.16	37.65	4745487.0
2020-03-31	ADME	ETF	28.355	28.545	28.13	28.13	41400.0
2020-03-31	ADRE	ETF	33.3	33.8722	33.3	33.42	4212.0
2020-03-31	AESR	ETF	8.35	8.37	8.32	8.32	32900.0
2020-03-31	AFIF	ETF	10.49	10.49	9.69	9.6902	1438.0
2020-03-31	AFK	ETF	12.6	12.64	12.29	12.64	25535.0
2020-03-31	AFLG	ETF	16.13	16.13	15.821	15.821	1000.0
2020-03-31	AFTY	ETF	15.19	15.19	14.91	14.932	7900.0
2020-03-31	AGG	ETF	115.71	115.98	115.23	115.37	14018600.0
2020-03-31	AGGY	ETF	51.82	51.92	51.64	51.65	226900.0
2020-03-31	AGNG	ETF	20.05	20.436	20.03	20.11	11100.0
2020-03-31	AGQ	ETF	18.52	19.23	18.15	18.44	140700.0
2020-03-31	AGZ	ETF	120.7	124.1808	120.295	120.56	29454.0
2020-03-31	AGZD	ETF	23.035	23.265	22.94	23.035	12200.0
2020-03-31	AIA	ETF	56.08	56.52	55.5887	55.71	44747.0
2020-03-31	AIEQ	ETF	22.65	22.838	22.36	22.412	11300.0
2020-03-31	AIQ	ETF	15.69	15.966	15.5903	15.5903	8913.0
2020-03-31	AIRR	ETF	19.58	20.043	19.5	19.983	10900.0
2020-03-31	AIVI	ETF	31.14	31.71	31.14	31.45	44700.0
2020-03-31	ALTY	ETF	8.987	8.987	8.76	8.789	17000.0
2020-03-31	AMJ	ETF	8.55	9.07	8.44	9.03	2722695.0
2020-03-31	AMLP	ETF	15.95	17.25	15.85	17.2	8777860.0
2020-03-31	AMUB	ETF	5.37	5.7156	5.37	5.7156	3291.0
2020-03-31	AMZA	ETF	10.11	10.986	9.82	10.794	99600.0
2020-03-31	ANGL	ETF	25.54	25.73	25.22	25.3	566700.0
2020-03-31	AOA	ETF	47.78	48.26	47.34	47.46	149700.0
2020-03-31	AOK	ETF	34.05	34.0593	33.77	33.78	88278.0
2020-03-31	AOM	ETF	36.59	36.9394	36.59	36.74	345720.0
2020-03-31	AOR	ETF	41.55	41.895	41.2951	41.38	259076.0
2020-03-31	ARGT	ETF	15.96	16.79	15.96	16.44	13100.0
2020-03-31	ARKF	ETF	20.81	20.96	20.25	20.39	43100.0
2020-03-31	ARKG	ETF	32.29	32.29	30.63	31.28	244500.0
2020-03-31	ARKK	ETF	44.37	45.38	43.23	44.0	605800.0

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

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