PREVIEW / etf_daily / 2019-08-01

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-01.parquet
  size:    71 KB
  rows:    1,847

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-08-01	SPY	ETF	297.6	300.87	293.96	294.84	142646600.0
2019-08-01	QQQ	ETF	191.51	194.98	189.23	190.15	63251648.0
2019-08-01	IWM	ETF	156.88	158.17	153.59	154.29	38070200.0
2019-08-01	DIA	ETF	268.82	271.71	265.4	265.76	7225300.0
2019-08-01	GLD	ETF	132.42	136.43	132.31	136.41	27719800.0
2019-08-01	TLT	ETF	133.39	135.39	133.26	135.26	26664800.0
2019-08-01	AAAU	ETF	14.03	14.44	14.02	14.43	80400.0
2019-08-01	AADR	ETF	50.7	51.44	50.7	50.95	19400.0
2019-08-01	AAXJ	ETF	67.84	68.38	66.21	66.46	2456900.0
2019-08-01	ACES	ETF	31.1	31.81	31.045	31.06	9400.0
2019-08-01	ACIO	ETF	25.03	25.11	24.78	24.78	57400.0
2019-08-01	ACSI	ETF	34.5	34.65	34.0487	34.0487	1538.0
2019-08-01	ACTX	ETF	23.2079	23.2079	20.0602	20.1192	172.0
2019-08-01	ACWF	ETF	29.1	29.2874	28.67	28.7036	10278.0
2019-08-01	ACWI	ETF	73.73	74.47	72.9	73.16	4611300.0
2019-08-01	ACWV	ETF	92.15	92.87	91.92	91.99	707100.0
2019-08-01	ACWX	ETF	45.97	46.3399	45.46	45.55	2005678.0
2019-08-01	ADRE	ETF	39.51	39.8	38.57	38.57	3777.0
2019-08-01	AFIF	ETF	9.87	9.91	9.87	9.91	4333.0
2019-08-01	AFK	ETF	21.18	21.18	21.0	21.0	2458.0
2019-08-01	AFTY	ETF	17.42	17.43	16.7	16.72	7800.0
2019-08-01	AGG	ETF	111.34	111.95	111.26	111.91	5709100.0
2019-08-01	AGGY	ETF	51.45	51.69	51.4	51.68	183900.0
2019-08-01	AGNG	ETF	21.44	21.5	21.25	21.5	1400.0
2019-08-01	AGQ	ETF	26.8	28.08	26.78	28.02	520100.0
2019-08-01	AGZ	ETF	114.96	115.47	114.96	115.47	23497.0
2019-08-01	AGZD	ETF	23.92	23.95	23.89	23.915	13600.0
2019-08-01	AIA	ETF	59.85	60.2699	58.54	58.54	39510.0
2019-08-01	AIEQ	ETF	26.51	26.805	26.211	26.37	44500.0
2019-08-01	AIQ	ETF	16.6	16.905	16.45	16.52	29062.0
2019-08-01	AIRR	ETF	26.33	26.33	25.6	25.63	38400.0
2019-08-01	AIVI	ETF	40.21	40.55	39.98	40.07	46900.0
2019-08-01	ALTY	ETF	15.04	15.15	15.018	15.15	19200.0
2019-08-01	AMJ	ETF	24.97	25.04	24.5844	24.65	1233207.0
2019-08-01	AMLP	ETF	49.05	49.15	48.3	48.55	3080040.0
2019-08-01	AMOM	ETF	26.236	26.236	26.236	26.236	800.0
2019-08-01	AMUB	ETF	15.5266	15.5266	15.5266	15.5266	4.0
2019-08-01	AMZA	ETF	53.6	53.85	52.6	52.8	91890.0
2019-08-01	ANGL	ETF	29.36	29.44	29.27	29.31	516900.0
2019-08-01	AOA	ETF	54.6	55.05	54.16	54.31	63400.0
2019-08-01	AOK	ETF	35.3	35.4884	35.3	35.36	47499.0
2019-08-01	AOM	ETF	38.8	39.0399	38.7401	38.84	117061.0
2019-08-01	AOR	ETF	45.54	45.9162	45.4311	45.51	51205.0
2019-08-01	ARCM	ETF	100.3	100.355	100.3	100.355	300.0
2019-08-01	ARGT	ETF	32.17	32.77	31.86	32.05	16100.0
2019-08-01	ARKF	ETF	23.02	23.4	22.7	22.8	9900.0
2019-08-01	ARKG	ETF	34.6	35.11	33.849	34.38	129200.0
2019-08-01	ARKK	ETF	48.46	48.75	46.96	47.72	322200.0
2019-08-01	ARKQ	ETF	32.99	33.165	31.9	32.15	18400.0
2019-08-01	ARKW	ETF	52.34	53.344	51.445	51.99	49400.0

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

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