PREVIEW / etf_daily / 2020-04-07

all etf daily files

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

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-07	SPY	ETF	274.21	275.03	264.89	265.13	201427200.0
2020-04-07	QQQ	ETF	202.14	202.66	196.0	196.4	69904478.0
2020-04-07	IWM	ETF	116.88	118.64	112.39	112.92	57546100.0
2020-04-07	DIA	ETF	235.46	236.16	226.45	226.6	10857700.0
2020-04-07	GLD	ETF	155.33	156.14	154.38	156.04	9195400.0
2020-04-07	TLT	ETF	164.96	166.42	163.71	166.3	13811400.0
2020-04-07	AAAU	ETF	16.48	16.55	16.38	16.54	214000.0
2020-04-07	AADR	ETF	43.01	43.01	41.49	41.7	7000.0
2020-04-07	AAXJ	ETF	62.8	62.8	61.13	61.27	2170600.0
2020-04-07	ABEQ	ETF	21.03	21.055	20.57	20.733	4700.0
2020-04-07	ACES	ETF	30.24	30.76	29.46	29.53	49200.0
2020-04-07	ACIO	ETF	23.3	23.3	23.01	23.063	6400.0
2020-04-07	ACSI	ETF	28.89	29.19	28.5104	28.5171	1925.0
2020-04-07	ACTX	ETF	4.72	5.8942	4.0179	5.0888	849.0
2020-04-07	ACWF	ETF	25.42	25.42	24.7	24.7	10925.0
2020-04-07	ACWI	ETF	65.88	65.99	63.75	63.76	3946300.0
2020-04-07	ACWV	ETF	84.71	84.83	82.36	82.47	635100.0
2020-04-07	ACWX	ETF	39.11	39.18	38.03	38.11	7161236.0
2020-04-07	ADME	ETF	28.808	28.92	28.495	28.495	6000.0
2020-04-07	ADRE	ETF	35.47	35.47	34.51	34.6502	8421.0
2020-04-07	AESR	ETF	8.601	8.601	8.51	8.511	80600.0
2020-04-07	AFIF	ETF	9.7	9.76	9.7	9.735	2636930.0
2020-04-07	AFK	ETF	13.39	13.57	13.22	13.22	9311.0
2020-04-07	AFTY	ETF	15.6	15.6	15.23	15.253	2600.0
2020-04-07	AGG	ETF	115.61	115.74	115.36	115.7	7743900.0
2020-04-07	AGGY	ETF	51.82	52.18	50.83	52.01	595800.0
2020-04-07	AGNG	ETF	20.8	20.87	20.641	20.641	3200.0
2020-04-07	AGQ	ETF	22.22	22.34	21.06	21.46	403500.0
2020-04-07	AGZ	ETF	120.27	120.3	119.64	120.3	1317945.0
2020-04-07	AGZD	ETF	23.14	23.45	23.08	23.225	25200.0
2020-04-07	AIA	ETF	59.04	59.04	57.5301	57.66	113909.0
2020-04-07	AIEQ	ETF	23.65	23.65	22.906	22.91	22400.0
2020-04-07	AIQ	ETF	16.54	16.55	16.0	16.0	11267.0
2020-04-07	AIRR	ETF	20.81	20.982	19.88	19.88	57500.0
2020-04-07	AIVI	ETF	32.79	32.79	31.8	31.87	26300.0
2020-04-07	ALTY	ETF	8.19	8.929	8.19	8.595	33200.0
2020-04-07	AMJ	ETF	9.87	10.19	9.52	9.55	6513905.0
2020-04-07	AMLP	ETF	18.85	19.5	18.05	18.15	11595940.0
2020-04-07	AMUB	ETF	6.2349	6.27	6.0491	6.0491	3980.0
2020-04-07	AMZA	ETF	11.86	12.61	11.66	11.66	105100.0
2020-04-07	ANGL	ETF	25.85	25.95	25.21	25.5	1733000.0
2020-04-07	AOA	ETF	49.38	49.41	48.14	48.4	139400.0
2020-04-07	AOK	ETF	34.43	34.43	34.05	34.16	246220.0
2020-04-07	AOM	ETF	37.25	37.27	36.85	36.9	212281.0
2020-04-07	AOR	ETF	42.43	42.5773	41.75	41.75	214991.0
2020-04-07	ARGT	ETF	17.19	17.71	16.81	17.18	23300.0
2020-04-07	ARKF	ETF	21.38	21.54	20.775	20.83	58600.0
2020-04-07	ARKG	ETF	32.99	33.09	31.4	31.48	186500.0
2020-04-07	ARKK	ETF	46.17	46.5	44.051	44.22	608100.0
2020-04-07	ARKQ	ETF	34.9	34.9	33.26	33.26	36600.0

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

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