PREVIEW / etf_daily / 2019-11-07

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-07.parquet
  size:    72 KB
  rows:    1,881

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-07	SPY	ETF	308.57	309.65	307.66	308.18	54272300.0
2019-11-07	QQQ	ETF	200.76	201.72	199.85	200.43	17832355.0
2019-11-07	IWM	ETF	159.74	160.17	158.17	158.65	13448900.0
2019-11-07	DIA	ETF	276.56	278.05	276.56	277.05	3023800.0
2019-11-07	GLD	ETF	140.11	140.2	137.6	138.27	15214200.0
2019-11-07	TLT	ETF	136.35	136.36	134.45	135.48	19209800.0
2019-11-07	AAAU	ETF	14.84	14.84	14.58	14.65	102600.0
2019-11-07	AADR	ETF	50.45	50.49	49.93	50.04	10400.0
2019-11-07	AAXJ	ETF	72.07	72.34	71.97	72.01	638900.0
2019-11-07	ACES	ETF	31.84	31.84	31.45	31.485	4700.0
2019-11-07	ACIO	ETF	25.244	25.28	25.18	25.18	4800.0
2019-11-07	ACSI	ETF	34.996	35.049	34.8	34.8	17552.0
2019-11-07	ACTX	ETF	8.8501	10.3133	8.8501	8.8501	253.0
2019-11-07	ACWF	ETF	30.42	30.54	30.39	30.422	6099.0
2019-11-07	ACWI	ETF	77.21	77.38	77.03	77.17	1212000.0
2019-11-07	ACWV	ETF	95.6	95.64	95.19	95.27	195900.0
2019-11-07	ACWX	ETF	48.56	48.61	48.455	48.49	1106300.0
2019-11-07	ADRE	ETF	41.87	42.1736	41.85	41.85	5414.0
2019-11-07	AFIF	ETF	9.71	9.7429	9.7	9.715	3987.0
2019-11-07	AFK	ETF	21.32	21.32	20.91	21.01	6249.0
2019-11-07	AFTY	ETF	18.09	18.26	18.09	18.15	15400.0
2019-11-07	AGG	ETF	112.12	112.12	111.64	111.87	4022400.0
2019-11-07	AGGY	ETF	51.9	51.918	51.71	51.81	200800.0
2019-11-07	AGNG	ETF	22.837	22.837	22.71	22.71	900.0
2019-11-07	AGQ	ETF	31.12	31.12	28.75	29.46	394200.0
2019-11-07	AGZ	ETF	115.59	115.59	115.2054	115.39	27710.0
2019-11-07	AGZD	ETF	24.025	24.04	23.95	23.995	7000.0
2019-11-07	AIA	ETF	64.06	64.34	64.0	64.0	20056.0
2019-11-07	AIEQ	ETF	26.67	26.95	26.67	26.77	24300.0
2019-11-07	AIQ	ETF	16.64	16.805	16.64	16.6498	3864.0
2019-11-07	AIRR	ETF	29.05	29.139	28.86	29.01	14600.0
2019-11-07	AIVI	ETF	42.25	42.25	42.11	42.14	4900.0
2019-11-07	ALTY	ETF	14.829	14.84	14.73	14.76	44400.0
2019-11-07	AMJ	ETF	21.82	21.91	21.29	21.45	2034833.0
2019-11-07	AMLP	ETF	42.9	42.9	41.55	41.9	7213420.0
2019-11-07	AMUB	ETF	13.5026	13.5026	13.5026	13.5026	0.0
2019-11-07	AMZA	ETF	45.0	45.2	43.6	44.1	111170.0
2019-11-07	ANGL	ETF	29.27	29.33	29.21	29.21	268300.0
2019-11-07	AOA	ETF	56.7	56.76	56.57	56.65	34300.0
2019-11-07	AOK	ETF	35.91	35.91	35.8011	35.83	63973.0
2019-11-07	AOM	ETF	39.65	39.6949	39.54	39.59	74117.0
2019-11-07	AOR	ETF	47.02	47.1	46.84	46.93	138053.0
2019-11-07	ARGT	ETF	21.87	22.3	21.87	22.11	34900.0
2019-11-07	ARKF	ETF	22.77	23.0	22.74	22.796	4400.0
2019-11-07	ARKG	ETF	30.36	30.539	29.84	29.94	94200.0
2019-11-07	ARKK	ETF	45.55	45.9	45.125	45.21	236500.0
2019-11-07	ARKQ	ETF	34.98	35.3	34.98	35.17	16900.0
2019-11-07	ARKW	ETF	52.33	53.094	52.118	52.34	52800.0
2019-11-07	ASEA	ETF	16.22	16.33	16.11	16.2	3000.0
2019-11-07	ASHR	ETF	29.11	29.28	29.07	29.18	2364900.0

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

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