PREVIEW / etf_daily / 2020-03-30

all etf daily files

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

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-30	SPY	ETF	255.7	262.43	253.53	261.65	171369500.0
2020-03-30	QQQ	ETF	187.1	192.49	186.3406	192.04	49356936.0
2020-03-30	IWM	ETF	113.24	115.26	110.8	115.04	41552100.0
2020-03-30	DIA	ETF	217.36	223.72	215.1	223.1	7691800.0
2020-03-30	GLD	ETF	152.41	153.08	151.57	152.92	12080900.0
2020-03-30	TLT	ETF	168.3	170.11	165.94	166.32	13473200.0
2020-03-30	AAAU	ETF	16.29	16.33	16.09	16.24	536900.0
2020-03-30	AADR	ETF	40.55	40.71	39.97	40.71	3000.0
2020-03-30	AAXJ	ETF	58.56	59.43	58.13	59.43	1109800.0
2020-03-30	ABEQ	ETF	20.25	20.61	20.155	20.479	60700.0
2020-03-30	ACES	ETF	28.35	28.61	27.8	28.525	57100.0
2020-03-30	ACIO	ETF	22.669	22.89	22.56	22.66	55000.0
2020-03-30	ACSI	ETF	27.6246	28.3828	27.6246	28.3828	883.0
2020-03-30	ACTX	ETF	7.0801	7.0801	5.9001	6.4901	410.0
2020-03-30	ACWF	ETF	23.85	24.4199	23.85	24.32	27332.0
2020-03-30	ACWI	ETF	61.8	63.12	61.3	63.04	6088900.0
2020-03-30	ACWV	ETF	80.46	82.05	80.26	81.95	680500.0
2020-03-30	ACWX	ETF	37.08	37.65	36.83	37.62	7849358.0
2020-03-30	ADME	ETF	28.444	28.65	28.38	28.65	25000.0
2020-03-30	ADRE	ETF	32.77	33.18	32.6897	33.1622	13827.0
2020-03-30	AESR	ETF	7.85	8.37	7.38	8.37	141600.0
2020-03-30	AFIF	ETF	9.77	9.77	9.61	9.73	562239.0
2020-03-30	AFK	ETF	12.65	12.85	12.135	12.25	45400.0
2020-03-30	AFTY	ETF	14.77	15.089	14.77	15.089	2700.0
2020-03-30	AGG	ETF	115.77	116.26	115.62	115.68	13340200.0
2020-03-30	AGGY	ETF	51.71	51.93	51.5	51.74	316900.0
2020-03-30	AGNG	ETF	19.74	20.166	19.74	20.166	3900.0
2020-03-30	AGQ	ETF	18.4	19.01	18.0	18.6	369400.0
2020-03-30	AGZ	ETF	120.73	121.18	120.294	120.43	65160.0
2020-03-30	AGZD	ETF	23.135	23.15	22.955	23.095	5200.0
2020-03-30	AIA	ETF	55.22	56.06	54.89	55.99	211207.0
2020-03-30	AIEQ	ETF	22.24	22.76	22.24	22.64	40700.0
2020-03-30	AIQ	ETF	15.53	15.7852	15.4515	15.7	6197.0
2020-03-30	AIRR	ETF	19.31	19.52	18.97	19.52	19900.0
2020-03-30	AIVI	ETF	31.13	31.6	31.1	31.6	20600.0
2020-03-30	ALTY	ETF	9.09	9.09	8.27	8.73	9500.0
2020-03-30	AMJ	ETF	8.5	8.52	7.93	8.31	2987084.0
2020-03-30	AMLP	ETF	16.05	16.15	14.8	15.55	8628260.0
2020-03-30	AMUB	ETF	5.18	5.3	5.13	5.2253	9046.0
2020-03-30	AMZA	ETF	10.6	10.6	9.4	10.1	94170.0
2020-03-30	ANGL	ETF	25.1	25.82	25.0	25.26	869700.0
2020-03-30	AOA	ETF	47.17	48.09	46.9	47.84	157400.0
2020-03-30	AOK	ETF	33.72	34.0055	33.6858	33.98	143404.0
2020-03-30	AOM	ETF	36.48	36.87	36.35	36.81	344796.0
2020-03-30	AOR	ETF	41.18	41.8	41.1005	41.73	240510.0
2020-03-30	ARGT	ETF	15.89	16.12	15.6	15.94	19000.0
2020-03-30	ARKF	ETF	20.55	20.73	20.12	20.71	29900.0
2020-03-30	ARKG	ETF	31.71	31.97	30.53	31.97	252600.0
2020-03-30	ARKK	ETF	44.19	44.72	42.855	44.6	979800.0
2020-03-30	ARKQ	ETF	32.51	33.085	32.02	32.99	35300.0

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

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