PREVIEW / etf_daily / 2020-05-11

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-11.parquet
  size:    75 KB
  rows:    1,975

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-05-11	SPY	ETF	290.34	294.0	289.88	292.5	79514200.0
2020-05-11	QQQ	ETF	223.5	227.93	223.25	226.87	35714128.0
2020-05-11	IWM	ETF	130.41	132.95	129.33	131.7	33983200.0
2020-05-11	DIA	ETF	241.68	243.94	241.0	242.56	2743000.0
2020-05-11	GLD	ETF	160.34	160.71	158.89	159.42	11209800.0
2020-05-11	TLT	ETF	163.66	164.22	162.1	162.7	8713500.0
2020-05-11	AAAU	ETF	17.0	17.03	16.87	16.93	368300.0
2020-05-11	AADR	ETF	47.16	47.39	47.16	47.21	2000.0
2020-05-11	AAXJ	ETF	64.17	64.59	64.11	64.26	621900.0
2020-05-11	ABEQ	ETF	21.75	21.874	21.75	21.874	400.0
2020-05-11	ACES	ETF	34.8	34.96	34.41	34.87	25400.0
2020-05-11	ACIO	ETF	24.03	24.1	23.967	24.05	12600.0
2020-05-11	ACSI	ETF	31.0162	31.0162	30.917	30.917	200.0
2020-05-11	ACTX	ETF	4.9413	5.31	3.9825	4.071	166.0
2020-05-11	ACWF	ETF	26.36	26.5999	26.22	26.49	14152.0
2020-05-11	ACWI	ETF	68.76	69.57	68.71	69.33	9407000.0
2020-05-11	ACWV	ETF	86.51	86.97	86.14	86.54	410500.0
2020-05-11	ACWX	ETF	39.98	40.3	39.96	40.21	1883341.0
2020-05-11	ADME	ETF	30.49	30.81	30.49	30.744	18300.0
2020-05-11	ADRE	ETF	36.01	36.0252	35.8433	35.8433	2797.0
2020-05-11	AESR	ETF	9.39	9.407	9.39	9.407	3000.0
2020-05-11	AFIF	ETF	9.83	9.83	9.74	9.775	46741.0
2020-05-11	AFK	ETF	14.95	14.95	14.8727	14.9	6970.0
2020-05-11	AFLG	ETF	17.97	17.972	17.97	17.972	200.0
2020-05-11	AFMC	ETF	16.066	16.066	16.066	16.066	100.0
2020-05-11	AFTY	ETF	15.89	16.004	15.89	16.004	2600.0
2020-05-11	AGG	ETF	116.4	116.43	116.07	116.11	5249500.0
2020-05-11	AGGY	ETF	52.71	52.79	52.54	52.67	331100.0
2020-05-11	AGNG	ETF	23.07	23.345	23.07	23.345	1100.0
2020-05-11	AGQ	ETF	21.91	22.09	21.4	21.69	296900.0
2020-05-11	AGZ	ETF	120.8	121.15	120.5103	120.66	79117.0
2020-05-11	AGZD	ETF	23.285	23.32	23.2	23.265	18000.0
2020-05-11	AIA	ETF	59.36	59.77	59.25	59.64	22995.0
2020-05-11	AIEQ	ETF	26.38	27.14	26.38	27.0	34100.0
2020-05-11	AIQ	ETF	18.53	18.79	18.49	18.74	15671.0
2020-05-11	AIRR	ETF	21.2	21.205	20.78	21.081	15100.0
2020-05-11	AIVI	ETF	33.09	33.27	33.08	33.2	2800.0
2020-05-11	ALTY	ETF	10.0	10.067	9.91	9.985	11800.0
2020-05-11	AMJ	ETF	13.19	13.31	13.02	13.19	1587357.0
2020-05-11	AMLP	ETF	23.95	24.2	23.6	23.95	3575740.0
2020-05-11	AMOM	ETF	27.647	27.647	27.647	27.647	200.0
2020-05-11	AMUB	ETF	8.3	8.32	8.3	8.3185	5419.0
2020-05-11	AMZA	ETF	17.26	17.33	16.75	17.1	56300.0
2020-05-11	ANGL	ETF	26.97	27.0	26.83	26.84	851700.0
2020-05-11	AOA	ETF	51.35	51.67	51.24	51.59	121800.0
2020-05-11	AOK	ETF	35.0	35.13	35.0	35.11	126678.0
2020-05-11	AOM	ETF	38.13	38.32	38.129	38.27	265603.0
2020-05-11	AOR	ETF	43.87	44.12	43.8001	43.98	186191.0
2020-05-11	ARB	ETF	25.13	25.14	25.1	25.1005	2664.0
2020-05-11	ARGT	ETF	20.08	20.55	19.94	20.49	172400.0

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

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