PREVIEW / etf_daily / 2019-11-04

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-04.parquet
  size:    71 KB
  rows:    1,871

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
2019-11-04	SPY	ETF	307.85	308.0	306.96	307.37	60606900.0
2019-11-04	QQQ	ETF	200.19	200.5251	198.8658	200.1	19015855.0
2019-11-04	IWM	ETF	159.4	159.7	158.47	158.95	16182000.0
2019-11-04	DIA	ETF	274.73	275.05	273.96	274.55	1543200.0
2019-11-04	GLD	ETF	142.26	142.45	141.74	142.15	4740300.0
2019-11-04	TLT	ETF	138.97	139.14	138.53	138.71	11124300.0
2019-11-04	AAAU	ETF	15.07	15.09	15.02	15.05	103100.0
2019-11-04	AADR	ETF	50.93	50.93	50.44	50.77	8600.0
2019-11-04	AAXJ	ETF	71.25	71.34	71.06	71.1	531500.0
2019-11-04	ACES	ETF	31.48	31.64	31.37	31.429	7700.0
2019-11-04	ACIO	ETF	25.2	25.21	25.164	25.164	7800.0
2019-11-04	ACSI	ETF	34.8418	34.87	34.8126	34.8655	2540.0
2019-11-04	ACTX	ETF	9.9711	11.2101	8.5551	11.2101	969.0
2019-11-04	ACWF	ETF	30.23	30.2614	30.21	30.2345	11385.0
2019-11-04	ACWI	ETF	77.0	77.06	76.8	76.87	1415500.0
2019-11-04	ACWV	ETF	96.07	96.07	95.19	95.28	890400.0
2019-11-04	ACWX	ETF	48.34	48.4134	48.235	48.29	867030.0
2019-11-04	ADRE	ETF	41.5	41.5	41.421	41.5	47172.0
2019-11-04	AFIF	ETF	9.68	9.7178	9.675	9.695	2620.0
2019-11-04	AFK	ETF	20.71	20.97	20.68	20.938	11746.0
2019-11-04	AFTY	ETF	17.89	17.99	17.89	17.922	14700.0
2019-11-04	AGG	ETF	112.71	112.72	112.59	112.65	2662700.0
2019-11-04	AGGY	ETF	52.24	52.24	52.18	52.21	85200.0
2019-11-04	AGNG	ETF	22.97	23.04	22.7	22.75	800.0
2019-11-04	AGQ	ETF	33.12	33.24	32.58	32.84	235600.0
2019-11-04	AGZ	ETF	115.99	115.99	115.88	115.9	35036.0
2019-11-04	AGZD	ETF	24.11	24.11	23.88	23.97	99000.0
2019-11-04	AIA	ETF	63.27	63.42	63.1484	63.26	18587.0
2019-11-04	AIEQ	ETF	26.92	26.98	26.766	26.79	20400.0
2019-11-04	AIQ	ETF	16.66	16.83	16.6	16.83	58104.0
2019-11-04	AIRR	ETF	28.81	28.941	28.59	28.866	17100.0
2019-11-04	AIVI	ETF	42.31	42.35	42.19	42.23	32100.0
2019-11-04	ALTY	ETF	15.02	15.023	14.97	15.0	16100.0
2019-11-04	AMJ	ETF	22.11	22.41	22.11	22.32	1488035.0
2019-11-04	AMLP	ETF	43.4	43.9	43.4	43.75	3164440.0
2019-11-04	AMUB	ETF	14.016	14.016	14.016	14.016	0.0
2019-11-04	AMZA	ETF	45.7	46.6	45.5	46.4	74800.0
2019-11-04	ANGL	ETF	29.28	29.32	29.24	29.31	303500.0
2019-11-04	AOA	ETF	56.56	56.67	56.46	56.57	59600.0
2019-11-04	AOK	ETF	36.01	36.01	35.86	35.86	157376.0
2019-11-04	AOM	ETF	39.71	39.73	39.62	39.71	103477.0
2019-11-04	AOR	ETF	46.98	47.0301	46.92	46.96	142185.0
2019-11-04	ARGT	ETF	21.99	22.2	21.99	22.14	39500.0
2019-11-04	ARKF	ETF	22.73	22.733	22.58	22.65	11300.0
2019-11-04	ARKG	ETF	30.99	31.0	30.221	30.41	79200.0
2019-11-04	ARKK	ETF	45.63	45.83	45.209	45.48	125100.0
2019-11-04	ARKQ	ETF	34.2	34.654	34.2	34.63	16400.0
2019-11-04	ARKW	ETF	52.42	52.72	52.302	52.6	625200.0
2019-11-04	ASEA	ETF	16.2	16.27	16.16	16.23	64100.0
2019-11-04	ASET	ETF	30.4596	30.46	30.4596	30.46	370.0

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

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