PREVIEW / etf_daily / 2020-04-02

all etf daily files

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

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-02	SPY	ETF	245.19	252.68	244.59	251.83	177660400.0
2020-04-02	QQQ	ETF	181.59	190.1	180.97	186.01	56465348.0
2020-04-02	IWM	ETF	105.72	110.39	104.57	107.67	43774200.0
2020-04-02	DIA	ETF	208.31	214.79	207.18	213.96	8231900.0
2020-04-02	GLD	ETF	151.2	152.5	150.7	151.9	9188300.0
2020-04-02	TLT	ETF	168.83	169.22	167.26	168.1	5771200.0
2020-04-02	AAAU	ETF	16.21	16.21	15.99	16.18	99200.0
2020-04-02	AADR	ETF	39.4	39.74	38.84	39.5	9900.0
2020-04-02	AAXJ	ETF	58.15	59.17	58.11	59.02	1942300.0
2020-04-02	ABEQ	ETF	20.004	20.125	19.795	19.932	18200.0
2020-04-02	ACES	ETF	26.98	28.08	26.73	27.2	20900.0
2020-04-02	ACIO	ETF	22.321	22.72	22.18	22.7	21500.0
2020-04-02	ACSI	ETF	26.69	26.8609	26.69	26.8609	835.0
2020-04-02	ACTX	ETF	5.31	5.31	4.13	4.72	1014.0
2020-04-02	ACWF	ETF	23.47	23.53	23.245	23.43	3938.0
2020-04-02	ACWI	ETF	59.59	61.21	59.49	60.9	4061900.0
2020-04-02	ACWV	ETF	77.68	79.84	77.64	79.5	445600.0
2020-04-02	ACWX	ETF	36.08	36.9	36.045	36.7	2932848.0
2020-04-02	ADME	ETF	27.335	27.73	27.335	27.715	11100.0
2020-04-02	ADRE	ETF	32.44	33.21	32.42	33.1844	6541.0
2020-04-02	AESR	ETF	7.932	8.027	7.932	8.027	600.0
2020-04-02	AFIF	ETF	9.765	9.785	9.755	9.765	722.0
2020-04-02	AFK	ETF	12.36	12.58	12.17	12.45	16228.0
2020-04-02	AFMC	ETF	13.47	13.82	13.3	13.469	2600.0
2020-04-02	AFTY	ETF	15.01	15.11	14.94	15.108	6600.0
2020-04-02	AGG	ETF	115.02	115.22	114.7	114.9	11565400.0
2020-04-02	AGGY	ETF	51.57	52.04	51.48	51.63	358000.0
2020-04-02	AGNG	ETF	19.18	19.613	19.18	19.613	1200.0
2020-04-02	AGQ	ETF	19.38	19.82	19.16	19.63	239100.0
2020-04-02	AGZ	ETF	122.93	122.93	120.45	120.81	84327.0
2020-04-02	AGZD	ETF	23.365	23.54	22.92	23.09	110400.0
2020-04-02	AIA	ETF	54.67	55.6	54.67	55.6	52273.0
2020-04-02	AIEQ	ETF	21.6	22.01	21.422	22.01	25800.0
2020-04-02	AIQ	ETF	15.01	15.2	14.821	15.06	18117.0
2020-04-02	AIRR	ETF	18.88	19.437	18.82	19.238	3800.0
2020-04-02	AIVI	ETF	30.6	31.2	30.43	31.07	10600.0
2020-04-02	ALTY	ETF	8.21	8.355	8.13	8.199	4300.0
2020-04-02	AMJ	ETF	9.25	10.22	9.09	9.33	6688730.0
2020-04-02	AMLP	ETF	17.5	20.15	17.3	17.75	12700300.0
2020-04-02	AMUB	ETF	5.93	5.9596	5.8683	5.8694	10444.0
2020-04-02	AMZA	ETF	11.65	12.5	11.013	11.33	144600.0
2020-04-02	ANGL	ETF	25.01	25.68	25.01	25.65	733900.0
2020-04-02	AOA	ETF	45.68	47.44	45.63	46.5	92100.0
2020-04-02	AOK	ETF	33.52	33.71	33.3	33.71	115253.0
2020-04-02	AOM	ETF	35.93	36.31	35.7501	36.1	261920.0
2020-04-02	AOR	ETF	40.32	40.81	40.1844	40.8	167515.0
2020-04-02	ARGT	ETF	15.74	16.12	15.62	15.94	16500.0
2020-04-02	ARKF	ETF	19.18	19.609	19.04	19.31	31500.0
2020-04-02	ARKG	ETF	28.86	30.27	28.709	30.085	227400.0
2020-04-02	ARKK	ETF	39.63	41.7	39.41	40.49	516800.0

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

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