PREVIEW / etf_daily / 2020-03-27

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-27.parquet
  size:    76 KB
  rows:    1,986

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-27	SPY	ETF	253.27	260.81	251.05	253.42	224341200.0
2020-03-27	QQQ	ETF	186.93	190.5149	184.66	185.3	58844975.0
2020-03-27	IWM	ETF	112.25	116.02	110.87	112.56	39931500.0
2020-03-27	DIA	ETF	217.61	223.26	214.57	216.35	10545600.0
2020-03-27	GLD	ETF	153.0	153.55	152.0	152.25	9824600.0
2020-03-27	TLT	ETF	165.52	168.25	164.59	167.7	12550000.0
2020-03-27	AAAU	ETF	16.35	16.38	16.25	16.29	172500.0
2020-03-27	AADR	ETF	40.36	40.5	39.9	40.42	6900.0
2020-03-27	AAXJ	ETF	58.33	59.18	58.02	58.29	1237100.0
2020-03-27	ABEQ	ETF	19.842	20.258	19.842	19.997	5400.0
2020-03-27	ACES	ETF	29.56	29.56	28.28	28.38	38000.0
2020-03-27	ACIO	ETF	22.571	22.78	22.515	22.65	137500.0
2020-03-27	ACSI	ETF	27.39	28.2414	27.39	27.8258	2543.0
2020-03-27	ACTX	ETF	5.9001	7.8176	5.8411	7.8176	1943.0
2020-03-27	ACWF	ETF	23.64	24.26	23.64	23.66	16184.0
2020-03-27	ACWI	ETF	61.19	62.86	60.84	61.68	5637900.0
2020-03-27	ACWV	ETF	79.09	81.91	79.09	80.33	896400.0
2020-03-27	ACWX	ETF	36.9	37.64	36.56	37.02	4124906.0
2020-03-27	ADME	ETF	28.95	28.95	27.9	28.165	148800.0
2020-03-27	ADRE	ETF	32.9	33.3556	32.74	33.3556	11147.0
2020-03-27	AESR	ETF	8.149	8.239	8.03	8.03	247800.0
2020-03-27	AFIF	ETF	9.68	9.6969	9.605	9.6969	1370894.0
2020-03-27	AFK	ETF	13.08	13.2	12.2	12.48	43645.0
2020-03-27	AFLG	ETF	15.58	15.608	15.58	15.608	200.0
2020-03-27	AFMC	ETF	13.982	13.982	13.982	13.982	200.0
2020-03-27	AFSM	ETF	13.6	13.6	13.415	13.415	2000.0
2020-03-27	AFTY	ETF	14.77	14.878	14.68	14.76	3900.0
2020-03-27	AGG	ETF	114.78	115.58	114.53	115.57	10841600.0
2020-03-27	AGGY	ETF	50.32	51.43	50.32	51.43	359200.0
2020-03-27	AGNG	ETF	19.33	19.858	19.32	19.553	8300.0
2020-03-27	AGQ	ETF	19.6	19.7	19.03	19.42	284100.0
2020-03-27	AGZ	ETF	120.46	120.46	119.5694	120.04	173181.0
2020-03-27	AGZD	ETF	22.725	23.5	22.725	23.275	91000.0
2020-03-27	AIA	ETF	54.75	55.35	54.33	54.48	123921.0
2020-03-27	AIEQ	ETF	22.2	22.72	21.89	22.09	24800.0
2020-03-27	AIQ	ETF	15.32	15.68	15.2087	15.61	7372.0
2020-03-27	AIRR	ETF	19.46	19.56	19.224	19.56	42900.0
2020-03-27	AIVI	ETF	30.89	31.4	30.7	30.96	341300.0
2020-03-27	ALTY	ETF	9.1	9.11	8.802	8.98	8100.0
2020-03-27	AMJ	ETF	8.93	8.93	8.465	8.6	5044336.0
2020-03-27	AMLP	ETF	16.7	16.8	15.95	16.2	8665600.0
2020-03-27	AMOM	ETF	22.77	22.77	22.083	22.083	500.0
2020-03-27	AMUB	ETF	5.43	5.4375	5.4109	5.4109	585.0
2020-03-27	AMZA	ETF	11.0	11.2	10.2	10.4	56260.0
2020-03-27	ANGL	ETF	25.15	25.86	25.05	25.19	895700.0
2020-03-27	AOA	ETF	46.99	48.14	46.61	47.29	202700.0
2020-03-27	AOK	ETF	33.56	33.9699	33.48	33.7	344918.0
2020-03-27	AOM	ETF	36.42	36.7799	36.21	36.48	607024.0
2020-03-27	AOR	ETF	41.03	41.6	40.7389	41.1	322274.0
2020-03-27	ARCM	ETF	99.315	99.315	99.315	99.315	100.0

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

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