PREVIEW / etf_daily / 2020-10-07

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-07.parquet
  size:    80 KB
  rows:    2,099

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-10-07	SPY	ETF	338.12	341.63	338.09	340.76	56999600.0
2020-10-07	QQQ	ETF	277.83	280.74	277.28	279.92	27539663.0
2020-10-07	IWM	ETF	158.59	160.56	158.46	160.04	27049700.0
2020-10-07	DIA	ETF	280.28	283.67	280.23	282.92	2422600.0
2020-10-07	GLD	ETF	177.09	177.42	176.43	177.22	6410900.0
2020-10-07	TLT	ETF	159.56	160.42	158.86	159.26	9429200.0
2020-10-07	AAA	ETF	24.9017	24.91	24.9	24.9	3875.0
2020-10-07	AAAU	ETF	18.8	18.82	18.73	18.8	449000.0
2020-10-07	AADR	ETF	56.12	56.36	56.12	56.36	2700.0
2020-10-07	AAXJ	ETF	79.05	79.42	78.87	79.29	1558200.0
2020-10-07	ABEQ	ETF	23.47	23.59	23.46	23.59	6000.0
2020-10-07	ACES	ETF	59.64	61.305	59.64	61.05	177400.0
2020-10-07	ACIO	ETF	26.59	26.8	26.59	26.78	75800.0
2020-10-07	ACSI	ETF	38.5084	38.5084	38.5084	38.5084	110.0
2020-10-07	ACTX	ETF	2.006	2.006	1.2449	1.298	5094.0
2020-10-07	ACWF	ETF	30.3115	30.45	30.3	30.4481	4369.0
2020-10-07	ACWI	ETF	81.05	81.65	81.02	81.46	3935300.0
2020-10-07	ACWV	ETF	92.77	93.13	92.65	92.93	138400.0
2020-10-07	ACWX	ETF	46.83	46.9901	46.771	46.9	871185.0
2020-10-07	ADME	ETF	34.14	34.14	33.855	33.99	51700.0
2020-10-07	ADRE	ETF	48.04	48.5	48.04	48.5	17782.0
2020-10-07	AESR	ETF	11.0	11.049	11.0	11.049	3300.0
2020-10-07	AFIF	ETF	9.7993	9.8199	9.79	9.805	15292.0
2020-10-07	AFK	ETF	17.62	17.83	17.62	17.7626	3995.0
2020-10-07	AFLG	ETF	20.44	20.604	20.44	20.604	600.0
2020-10-07	AFTY	ETF	19.77	19.832	19.77	19.832	800.0
2020-10-07	AGG	ETF	117.53	117.66	117.45	117.54	4801700.0
2020-10-07	AGGY	ETF	53.59	53.69	53.55	53.615	180300.0
2020-10-07	AGNG	ETF	25.98	26.29	25.98	26.29	12000.0
2020-10-07	AGQ	ETF	43.0	44.39	42.62	43.55	1316900.0
2020-10-07	AGZ	ETF	120.8	120.84	120.73	120.76	90962.0
2020-10-07	AGZD	ETF	23.46	23.525	23.46	23.5	10200.0
2020-10-07	AIA	ETF	73.78	74.09	73.59	74.0	89056.0
2020-10-07	AIEQ	ETF	31.67	31.817	31.445	31.757	8100.0
2020-10-07	AIQ	ETF	23.98	24.205	23.98	24.1949	13080.0
2020-10-07	AIRR	ETF	27.511	27.66	27.43	27.633	19900.0
2020-10-07	AIVI	ETF	36.54	36.64	36.4	36.61	8200.0
2020-10-07	ALTL	ETF	25.17	25.4379	25.17	25.3881	9474.0
2020-10-07	ALTY	ETF	10.69	10.71	10.64	10.66	13600.0
2020-10-07	AMJ	ETF	11.11	11.17	10.975	11.07	781985.0
2020-10-07	AMLP	ETF	20.54	20.7	20.34	20.48	2905600.0
2020-10-07	AMNA	ETF	22.0516	22.0516	22.0516	22.0516	0.0
2020-10-07	AMND	ETF	22.99	23.175	22.99	23.175	437.0
2020-10-07	AMOM	ETF	35.22	36.85	35.22	36.33	2900.0
2020-10-07	AMUB	ETF	6.91	6.9725	6.9	6.9725	345777.0
2020-10-07	AMZA	ETF	14.04	14.04	13.8	13.97	68600.0
2020-10-07	ANGL	ETF	29.97	30.02	29.91	29.95	844800.0
2020-10-07	AOA	ETF	58.51	58.85	58.51	58.74	27600.0
2020-10-07	AOK	ETF	37.2	37.37	37.2	37.35	76959.0
2020-10-07	AOM	ETF	41.13	41.268	40.95	41.19	80002.0

> showing 50 of 2,099 rows — these rows as CSV

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